Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.12, 10.2.13, 10.2(EOL), 10.3(EOL)
-
CentOS release 6.5 x86_64, MariaDB 10.2.12, 10.2.13
-
10.2.14
Description
the following query:
SELECT DISTINCT T3.ZEBWD_SYS_ID, |
T4.ZEBWD_SYS_IDT,
|
T3.ZEBWD_SYS_AV
|
FROM T_ZEBWDT1040 T1, /* A001/A002 */ |
T_ZEBWDT1050 T2,
|
T_ZEBWDT1000 T3,
|
T_ZEBWDT1000T T4
|
WHERE T1.ZEBWD_ROLE_ID = T2.ZEBWD_ROLE_ID |
AND T2.ZEBWD_MENU_ID = T3.ZEBWD_SYS_ID |
AND T3.ZEBWD_SYS_DEL = 'N' |
AND T3.ZEBWD_SYS_UP = '0000000000' |
AND T3.ZEBWD_SYS_ID = T4.ZEBWD_SYS_ID |
AND T1.ZEBWD_USER_ID = 'test' |
ORDER BY T3.ZEBWD_SYS_AV ASC; |
Test Case 1: SET SESSION join_cache_level=8;
+------+-------------+-------+--------+---------------+---------+---------+----------------------------+------+-----------------------------------------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+--------+---------------+---------+---------+----------------------------+------+-----------------------------------------------------------+
|
| 1 | SIMPLE | T1 | index | PRIMARY | PRIMARY | 154 | NULL | 1 | Using where; Using index; Using temporary; Using filesort |
|
| 1 | SIMPLE | T2 | ref | PRIMARY | PRIMARY | 62 | bnlh_test.T1.ZEBWD_ROLE_ID | 4 | Using index |
|
| 1 | SIMPLE | T3 | eq_ref | PRIMARY | PRIMARY | 92 | bnlh_test.T2.ZEBWD_MENU_ID | 1 | Using where |
|
| 1 | SIMPLE | T4 | ref | PRIMARY | PRIMARY | 92 | bnlh_test.T2.ZEBWD_MENU_ID | 1 | |
|
+------+-------------+-------+--------+---------------+---------+---------+----------------------------+------+-----------------------------------------------------------+
|
4 rows in set (0.00 sec)
|
|
|
MariaDB [bnlh_test]>
|
|
|
+--------------+---------------+--------------+
|
| ZEBWD_SYS_ID | ZEBWD_SYS_IDT | ZEBWD_SYS_AV |
|
+--------------+---------------+--------------+
|
| ZSBILL1000 | MENU1 | 1 |
|
| ZSBILL3000 | MENU3 | 2 |
|
| ZSBILL2000 | MENU2 | 3 |
|
| ZSBILL7000 | MENU7 | 4 |
|
| ZSBILL4000 | MENU4 | 5 |
|
| ZSBILL5000 | MENU5 | 6 |
|
| ZSBILL8000 | MENU8 | 7 |
|
| ZSBILL6000 | MENU6 | 8 |
|
| ZSBILL9000 | MENU9 | 9 |
|
+--------------+---------------+--------------+
|
9 rows in set (0.00 sec)
|
Test Case 2: SET SESSION join_cache_level=4;
+------+-------------+-------+------------+---------------+-----------------------+---------+----------------------------+------+-----------------------------------------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+------------+---------------+-----------------------+---------+----------------------------+------+-----------------------------------------------------------+
|
| 1 | SIMPLE | T1 | index | PRIMARY | PRIMARY | 154 | NULL | 1 | Using where; Using index; Using temporary; Using filesort |
|
| 1 | SIMPLE | T2 | hash_index | PRIMARY | #hash#PRIMARY:PRIMARY | 62:154 | bnlh_test.T1.ZEBWD_ROLE_ID | 9 | Using index; Using join buffer (flat, BNLH join) |
|
| 1 | SIMPLE | T3 | hash_ALL | PRIMARY | #hash#PRIMARY | 92 | bnlh_test.T2.ZEBWD_MENU_ID | 42 | Using where |
|
| 1 | SIMPLE | T4 | hash_ALL | PRIMARY | #hash#PRIMARY | 92 | bnlh_test.T2.ZEBWD_MENU_ID | 42 | |
|
+------+-------------+-------+------------+---------------+-----------------------+---------+----------------------------+------+-----------------------------------------------------------+
|
4 rows in set (0.00 sec)
|
|
|
MariaDB [bnlh_test]> SELECT DISTINCT T3.ZEBWD_SYS_ID,
|
-> T4.ZEBWD_SYS_IDT,
|
-> T3.ZEBWD_SYS_AV
|
-> FROM T_ZEBWDT1040 T1, /* A001/A002 */
|
-> T_ZEBWDT1050 T2,
|
-> T_ZEBWDT1000 T3,
|
-> T_ZEBWDT1000T T4
|
-> WHERE T1.ZEBWD_ROLE_ID = T2.ZEBWD_ROLE_ID
|
-> AND T2.ZEBWD_MENU_ID = T3.ZEBWD_SYS_ID
|
-> AND T3.ZEBWD_SYS_DEL = 'N'
|
-> AND T3.ZEBWD_SYS_UP = '0000000000'
|
-> AND T3.ZEBWD_SYS_ID = T4.ZEBWD_SYS_ID
|
-> AND T1.ZEBWD_USER_ID = 'test'
|
-> ORDER BY T3.ZEBWD_SYS_AV ASC;
|
+--------------+---------------+--------------+
|
| ZEBWD_SYS_ID | ZEBWD_SYS_IDT | ZEBWD_SYS_AV |
|
+--------------+---------------+--------------+
|
| ZSBILL1000 | MENU4 - SUB1 | 1 |
|
| ZSBILL1000 | MENU3 | 1 |
|
| ZSBILL1000 | MENU9 - SUB5 | 1 |
|
| ZSBILL1000 | MENU1 - SUB3 | 1 |
|
| ZSBILL1000 | MENU9 | 1 |
|
| ZSBILL1000 | MENU6 - SUB3 | 1 |
|
| ZSBILL1000 | MENU5 - SUB3 | 1 |
|
| ZSBILL1000 | MENU4 - SUB8 | 1 |
|
| ZSBILL1000 | MENU4 - SUB3 | 1 |
|
| ZSBILL1000 | MENU3 - SUB2 | 1 |
|
| ZSBILL1000 | MENU2 - SUB1 | 1 |
|
| ZSBILL1000 | MENU9 - SUB2 | 1 |
|
| ZSBILL1000 | MENU1 | 1 |
|
| ZSBILL1000 | MENU6 - SUB5 | 1 |
|
| ZSBILL1000 | MENU6 | 1 |
|
| ZSBILL1000 | MENU5 | 1 |
|
| ZSBILL1000 | MENU4 - SUB5 | 1 |
|
| ZSBILL1000 | MENU4 | 1 |
|
| ZSBILL1000 | MENU2 - SUB3 | 1 |
|
| ZSBILL1000 | MENU9 - SUB4 | 1 |
|
| ZSBILL1000 | MENU1 - SUB2 | 1 |
|
| ZSBILL1000 | MENU8 | 1 |
|
| ZSBILL1000 | MENU6 - SUB2 | 1 |
|
| ZSBILL1000 | MENU5 - SUB2 | 1 |
|
| ZSBILL1000 | MENU4 - SUB7 | 1 |
|
| ZSBILL1000 | MENU4 - SUB2 | 1 |
|
| ZSBILL1000 | MENU3 - SUB1 | 1 |
|
| ZSBILL1000 | MENU9 - SUB6 | 1 |
|
| ZSBILL1000 | MENU2 | 1 |
|
| ZSBILL1000 | MENU9 - SUB1 | 1 |
|
| ZSBILL1000 | MENU6 - SUB4 | 1 |
|
| ZSBILL1000 | MENU5 - SUB4 | 1 |
|
| ZSBILL1000 | MENU4 - SUB9 | 1 |
|
| ZSBILL1000 | MENU4 - SUB4 | 1 |
|
| ZSBILL1000 | MENU3 - SUB3 | 1 |
|
| ZSBILL1000 | MENU2 - SUB2 | 1 |
|
| ZSBILL1000 | MENU9 - SUB3 | 1 |
|
| ZSBILL1000 | MENU1 - SUB1 | 1 |
|
| ZSBILL1000 | MENU7 | 1 |
|
| ZSBILL1000 | MENU6 - SUB1 | 1 |
|
| ZSBILL1000 | MENU5 - SUB1 | 1 |
|
| ZSBILL1000 | MENU4 - SUB6 | 1 |
|
| ZSBILL3000 | MENU5 - SUB3 | 2 |
|
| ZSBILL3000 | MENU4 - SUB8 | 2 |
|
| ZSBILL3000 | MENU4 - SUB3 | 2 |
|
| ZSBILL3000 | MENU3 - SUB2 | 2 |
|
| ZSBILL3000 | MENU2 - SUB1 | 2 |
|
| ZSBILL3000 | MENU9 - SUB2 | 2 |
|
| ZSBILL3000 | MENU1 | 2 |
|
| ZSBILL3000 | MENU6 - SUB5 | 2 |
|
| ZSBILL3000 | MENU6 | 2 |
|
| ZSBILL3000 | MENU5 | 2 |
|
| ZSBILL3000 | MENU4 - SUB5 | 2 |
|
| ZSBILL3000 | MENU4 | 2 |
|
| ZSBILL3000 | MENU2 - SUB3 | 2 |
|
| ZSBILL3000 | MENU9 - SUB4 | 2 |
|
| ZSBILL3000 | MENU1 - SUB2 | 2 |
|
| ZSBILL3000 | MENU8 | 2 |
|
| ZSBILL3000 | MENU6 - SUB2 | 2 |
|
| ZSBILL3000 | MENU5 - SUB2 | 2 |
|
| ZSBILL3000 | MENU4 - SUB7 | 2 |
|
| ZSBILL3000 | MENU4 - SUB2 | 2 |
|
| ZSBILL3000 | MENU3 - SUB1 | 2 |
|
| ZSBILL3000 | MENU9 - SUB6 | 2 |
|
| ZSBILL3000 | MENU2 | 2 |
|
| ZSBILL3000 | MENU9 - SUB1 | 2 |
|
| ZSBILL3000 | MENU6 - SUB4 | 2 |
|
| ZSBILL3000 | MENU5 - SUB4 | 2 |
|
| ZSBILL3000 | MENU4 - SUB9 | 2 |
|
| ZSBILL3000 | MENU4 - SUB4 | 2 |
|
| ZSBILL3000 | MENU3 - SUB3 | 2 |
|
| ZSBILL3000 | MENU2 - SUB2 | 2 |
|
| ZSBILL3000 | MENU9 - SUB3 | 2 |
|
| ZSBILL3000 | MENU1 - SUB1 | 2 |
|
| ZSBILL3000 | MENU7 | 2 |
|
| ZSBILL3000 | MENU6 - SUB1 | 2 |
|
| ZSBILL3000 | MENU5 - SUB1 | 2 |
|
| ZSBILL3000 | MENU4 - SUB6 | 2 |
|
| ZSBILL3000 | MENU4 - SUB1 | 2 |
|
| ZSBILL3000 | MENU3 | 2 |
|
| ZSBILL3000 | MENU9 - SUB5 | 2 |
|
| ZSBILL3000 | MENU1 - SUB3 | 2 |
|
| ZSBILL3000 | MENU9 | 2 |
|
| ZSBILL3000 | MENU6 - SUB3 | 2 |
|
| ZSBILL2000 | MENU1 - SUB3 | 3 |
|
| ZSBILL2000 | MENU9 | 3 |
|
| ZSBILL2000 | MENU6 - SUB3 | 3 |
|
| ZSBILL2000 | MENU5 - SUB3 | 3 |
|
| ZSBILL2000 | MENU4 - SUB8 | 3 |
|
| ZSBILL2000 | MENU4 - SUB3 | 3 |
|
| ZSBILL2000 | MENU3 - SUB2 | 3 |
|
| ZSBILL2000 | MENU2 - SUB1 | 3 |
|
| ZSBILL2000 | MENU9 - SUB2 | 3 |
|
| ZSBILL2000 | MENU1 | 3 |
|
| ZSBILL2000 | MENU6 - SUB5 | 3 |
|
| ZSBILL2000 | MENU6 | 3 |
|
| ZSBILL2000 | MENU5 | 3 |
|
| ZSBILL2000 | MENU4 - SUB5 | 3 |
|
| ZSBILL2000 | MENU4 | 3 |
|
| ZSBILL2000 | MENU2 - SUB3 | 3 |
|
| ZSBILL2000 | MENU9 - SUB4 | 3 |
|
| ZSBILL2000 | MENU1 - SUB2 | 3 |
|
| ZSBILL2000 | MENU8 | 3 |
|
| ZSBILL2000 | MENU6 - SUB2 | 3 |
|
| ZSBILL2000 | MENU5 - SUB2 | 3 |
|
| ZSBILL2000 | MENU4 - SUB7 | 3 |
|
| ZSBILL2000 | MENU4 - SUB2 | 3 |
|
| ZSBILL2000 | MENU3 - SUB1 | 3 |
|
| ZSBILL2000 | MENU9 - SUB6 | 3 |
|
| ZSBILL2000 | MENU2 | 3 |
|
| ZSBILL2000 | MENU9 - SUB1 | 3 |
|
| ZSBILL2000 | MENU6 - SUB4 | 3 |
|
| ZSBILL2000 | MENU5 - SUB4 | 3 |
|
| ZSBILL2000 | MENU4 - SUB9 | 3 |
|
| ZSBILL2000 | MENU4 - SUB4 | 3 |
|
| ZSBILL2000 | MENU3 - SUB3 | 3 |
|
| ZSBILL2000 | MENU2 - SUB2 | 3 |
|
| ZSBILL2000 | MENU9 - SUB3 | 3 |
|
| ZSBILL2000 | MENU1 - SUB1 | 3 |
|
| ZSBILL2000 | MENU7 | 3 |
|
| ZSBILL2000 | MENU6 - SUB1 | 3 |
|
| ZSBILL2000 | MENU5 - SUB1 | 3 |
|
| ZSBILL2000 | MENU4 - SUB6 | 3 |
|
| ZSBILL2000 | MENU4 - SUB1 | 3 |
|
| ZSBILL2000 | MENU3 | 3 |
|
| ZSBILL2000 | MENU9 - SUB5 | 3 |
|
| ZSBILL7000 | MENU4 - SUB5 | 4 |
|
| ZSBILL7000 | MENU4 | 4 |
|
| ZSBILL7000 | MENU2 - SUB3 | 4 |
|
| ZSBILL7000 | MENU9 - SUB4 | 4 |
|
| ZSBILL7000 | MENU1 - SUB2 | 4 |
|
| ZSBILL7000 | MENU8 | 4 |
|
| ZSBILL7000 | MENU6 - SUB2 | 4 |
|
| ZSBILL7000 | MENU5 - SUB2 | 4 |
|
| ZSBILL7000 | MENU4 - SUB7 | 4 |
|
| ZSBILL7000 | MENU4 - SUB2 | 4 |
|
| ZSBILL7000 | MENU3 - SUB1 | 4 |
|
| ZSBILL7000 | MENU9 - SUB6 | 4 |
|
| ZSBILL7000 | MENU2 | 4 |
|
| ZSBILL7000 | MENU9 - SUB1 | 4 |
|
| ZSBILL7000 | MENU6 - SUB4 | 4 |
|
| ZSBILL7000 | MENU5 - SUB4 | 4 |
|
| ZSBILL7000 | MENU4 - SUB9 | 4 |
|
| ZSBILL7000 | MENU4 - SUB4 | 4 |
|
| ZSBILL7000 | MENU3 - SUB3 | 4 |
|
| ZSBILL7000 | MENU2 - SUB2 | 4 |
|
| ZSBILL7000 | MENU9 - SUB3 | 4 |
|
| ZSBILL7000 | MENU1 - SUB1 | 4 |
|
| ZSBILL7000 | MENU7 | 4 |
|
| ZSBILL7000 | MENU6 - SUB1 | 4 |
|
| ZSBILL7000 | MENU5 - SUB1 | 4 |
|
| ZSBILL7000 | MENU4 - SUB6 | 4 |
|
| ZSBILL7000 | MENU4 - SUB1 | 4 |
|
| ZSBILL7000 | MENU3 | 4 |
|
| ZSBILL7000 | MENU9 - SUB5 | 4 |
|
| ZSBILL7000 | MENU1 - SUB3 | 4 |
|
| ZSBILL7000 | MENU9 | 4 |
|
| ZSBILL7000 | MENU6 - SUB3 | 4 |
|
| ZSBILL7000 | MENU5 - SUB3 | 4 |
|
| ZSBILL7000 | MENU4 - SUB8 | 4 |
|
| ZSBILL7000 | MENU4 - SUB3 | 4 |
|
| ZSBILL7000 | MENU3 - SUB2 | 4 |
|
| ZSBILL7000 | MENU2 - SUB1 | 4 |
|
| ZSBILL7000 | MENU9 - SUB2 | 4 |
|
| ZSBILL7000 | MENU1 | 4 |
|
| ZSBILL7000 | MENU6 - SUB5 | 4 |
|
| ZSBILL7000 | MENU6 | 4 |
|
| ZSBILL7000 | MENU5 | 4 |
|
| ZSBILL4000 | MENU4 - SUB3 | 5 |
|
| ZSBILL4000 | MENU3 - SUB2 | 5 |
|
| ZSBILL4000 | MENU2 - SUB1 | 5 |
|
| ZSBILL4000 | MENU9 - SUB2 | 5 |
|
| ZSBILL4000 | MENU1 | 5 |
|
| ZSBILL4000 | MENU6 - SUB5 | 5 |
|
| ZSBILL4000 | MENU6 | 5 |
|
| ZSBILL4000 | MENU5 | 5 |
|
| ZSBILL4000 | MENU4 - SUB5 | 5 |
|
| ZSBILL4000 | MENU4 | 5 |
|
| ZSBILL4000 | MENU2 - SUB3 | 5 |
|
| ZSBILL4000 | MENU9 - SUB4 | 5 |
|
| ZSBILL4000 | MENU1 - SUB2 | 5 |
|
| ZSBILL4000 | MENU8 | 5 |
|
| ZSBILL4000 | MENU6 - SUB2 | 5 |
|
| ZSBILL4000 | MENU5 - SUB2 | 5 |
|
| ZSBILL4000 | MENU4 - SUB7 | 5 |
|
| ZSBILL4000 | MENU4 - SUB2 | 5 |
|
| ZSBILL4000 | MENU3 - SUB1 | 5 |
|
| ZSBILL4000 | MENU9 - SUB6 | 5 |
|
| ZSBILL4000 | MENU2 | 5 |
|
| ZSBILL4000 | MENU9 - SUB1 | 5 |
|
| ZSBILL4000 | MENU6 - SUB4 | 5 |
|
| ZSBILL4000 | MENU5 - SUB4 | 5 |
|
| ZSBILL4000 | MENU4 - SUB9 | 5 |
|
| ZSBILL4000 | MENU4 - SUB4 | 5 |
|
| ZSBILL4000 | MENU3 - SUB3 | 5 |
|
| ZSBILL4000 | MENU2 - SUB2 | 5 |
|
| ZSBILL4000 | MENU9 - SUB3 | 5 |
|
| ZSBILL4000 | MENU1 - SUB1 | 5 |
|
| ZSBILL4000 | MENU7 | 5 |
|
| ZSBILL4000 | MENU6 - SUB1 | 5 |
|
| ZSBILL4000 | MENU5 - SUB1 | 5 |
|
| ZSBILL4000 | MENU4 - SUB6 | 5 |
|
| ZSBILL4000 | MENU4 - SUB1 | 5 |
|
| ZSBILL4000 | MENU3 | 5 |
|
| ZSBILL4000 | MENU9 - SUB5 | 5 |
|
| ZSBILL4000 | MENU1 - SUB3 | 5 |
|
| ZSBILL4000 | MENU9 | 5 |
|
| ZSBILL4000 | MENU6 - SUB3 | 5 |
|
| ZSBILL4000 | MENU5 - SUB3 | 5 |
|
| ZSBILL4000 | MENU4 - SUB8 | 5 |
|
| ZSBILL5000 | MENU2 - SUB1 | 6 |
|
| ZSBILL5000 | MENU9 - SUB2 | 6 |
|
| ZSBILL5000 | MENU1 | 6 |
|
| ZSBILL5000 | MENU6 - SUB5 | 6 |
|
| ZSBILL5000 | MENU6 | 6 |
|
| ZSBILL5000 | MENU5 | 6 |
|
| ZSBILL5000 | MENU4 - SUB5 | 6 |
|
| ZSBILL5000 | MENU4 | 6 |
|
| ZSBILL5000 | MENU2 - SUB3 | 6 |
|
| ZSBILL5000 | MENU9 - SUB4 | 6 |
|
| ZSBILL5000 | MENU1 - SUB2 | 6 |
|
| ZSBILL5000 | MENU8 | 6 |
|
| ZSBILL5000 | MENU6 - SUB2 | 6 |
|
| ZSBILL5000 | MENU5 - SUB2 | 6 |
|
| ZSBILL5000 | MENU4 - SUB7 | 6 |
|
| ZSBILL5000 | MENU4 - SUB2 | 6 |
|
| ZSBILL5000 | MENU3 - SUB1 | 6 |
|
| ZSBILL5000 | MENU9 - SUB6 | 6 |
|
| ZSBILL5000 | MENU2 | 6 |
|
| ZSBILL5000 | MENU9 - SUB1 | 6 |
|
| ZSBILL5000 | MENU6 - SUB4 | 6 |
|
| ZSBILL5000 | MENU5 - SUB4 | 6 |
|
| ZSBILL5000 | MENU4 - SUB9 | 6 |
|
| ZSBILL5000 | MENU4 - SUB4 | 6 |
|
| ZSBILL5000 | MENU3 - SUB3 | 6 |
|
| ZSBILL5000 | MENU2 - SUB2 | 6 |
|
| ZSBILL5000 | MENU9 - SUB3 | 6 |
|
| ZSBILL5000 | MENU1 - SUB1 | 6 |
|
| ZSBILL5000 | MENU7 | 6 |
|
| ZSBILL5000 | MENU6 - SUB1 | 6 |
|
| ZSBILL5000 | MENU5 - SUB1 | 6 |
|
| ZSBILL5000 | MENU4 - SUB6 | 6 |
|
| ZSBILL5000 | MENU4 - SUB1 | 6 |
|
| ZSBILL5000 | MENU3 | 6 |
|
| ZSBILL5000 | MENU9 - SUB5 | 6 |
|
| ZSBILL5000 | MENU1 - SUB3 | 6 |
|
| ZSBILL5000 | MENU9 | 6 |
|
| ZSBILL5000 | MENU6 - SUB3 | 6 |
|
| ZSBILL5000 | MENU5 - SUB3 | 6 |
|
| ZSBILL5000 | MENU4 - SUB8 | 6 |
|
| ZSBILL5000 | MENU4 - SUB3 | 6 |
|
| ZSBILL5000 | MENU3 - SUB2 | 6 |
|
| ZSBILL8000 | MENU9 - SUB4 | 7 |
|
| ZSBILL8000 | MENU2 - SUB3 | 7 |
|
| ZSBILL8000 | MENU1 - SUB2 | 7 |
|
| ZSBILL8000 | MENU8 | 7 |
|
| ZSBILL8000 | MENU6 - SUB2 | 7 |
|
| ZSBILL8000 | MENU5 - SUB2 | 7 |
|
| ZSBILL8000 | MENU4 - SUB7 | 7 |
|
| ZSBILL8000 | MENU4 - SUB2 | 7 |
|
| ZSBILL8000 | MENU9 - SUB6 | 7 |
|
| ZSBILL8000 | MENU3 - SUB1 | 7 |
|
| ZSBILL8000 | MENU9 - SUB1 | 7 |
|
| ZSBILL8000 | MENU2 | 7 |
|
| ZSBILL8000 | MENU6 - SUB4 | 7 |
|
| ZSBILL8000 | MENU5 - SUB4 | 7 |
|
| ZSBILL8000 | MENU4 - SUB9 | 7 |
|
| ZSBILL8000 | MENU4 - SUB4 | 7 |
|
| ZSBILL8000 | MENU3 - SUB3 | 7 |
|
| ZSBILL8000 | MENU9 - SUB3 | 7 |
|
| ZSBILL8000 | MENU2 - SUB2 | 7 |
|
| ZSBILL8000 | MENU1 - SUB1 | 7 |
|
| ZSBILL8000 | MENU7 | 7 |
|
| ZSBILL8000 | MENU6 - SUB1 | 7 |
|
| ZSBILL8000 | MENU5 - SUB1 | 7 |
|
| ZSBILL8000 | MENU4 - SUB6 | 7 |
|
| ZSBILL8000 | MENU4 - SUB1 | 7 |
|
| ZSBILL8000 | MENU9 - SUB5 | 7 |
|
| ZSBILL8000 | MENU3 | 7 |
|
| ZSBILL8000 | MENU1 - SUB3 | 7 |
|
| ZSBILL8000 | MENU9 | 7 |
|
| ZSBILL8000 | MENU6 - SUB3 | 7 |
|
| ZSBILL8000 | MENU5 - SUB3 | 7 |
|
| ZSBILL8000 | MENU4 - SUB8 | 7 |
|
| ZSBILL8000 | MENU4 - SUB3 | 7 |
|
| ZSBILL8000 | MENU3 - SUB2 | 7 |
|
| ZSBILL8000 | MENU9 - SUB2 | 7 |
|
| ZSBILL8000 | MENU2 - SUB1 | 7 |
|
| ZSBILL8000 | MENU1 | 7 |
|
| ZSBILL8000 | MENU6 - SUB5 | 7 |
|
| ZSBILL8000 | MENU6 | 7 |
|
| ZSBILL8000 | MENU5 | 7 |
|
| ZSBILL8000 | MENU4 - SUB5 | 7 |
|
| ZSBILL8000 | MENU4 | 7 |
|
| ZSBILL6000 | MENU6 | 8 |
|
| ZSBILL6000 | MENU5 | 8 |
|
| ZSBILL6000 | MENU4 - SUB5 | 8 |
|
| ZSBILL6000 | MENU4 | 8 |
|
| ZSBILL6000 | MENU9 - SUB4 | 8 |
|
| ZSBILL6000 | MENU2 - SUB3 | 8 |
|
| ZSBILL6000 | MENU8 | 8 |
|
| ZSBILL6000 | MENU1 - SUB2 | 8 |
|
| ZSBILL6000 | MENU6 - SUB2 | 8 |
|
| ZSBILL6000 | MENU5 - SUB2 | 8 |
|
| ZSBILL6000 | MENU4 - SUB7 | 8 |
|
| ZSBILL6000 | MENU4 - SUB2 | 8 |
|
| ZSBILL6000 | MENU9 - SUB6 | 8 |
|
| ZSBILL6000 | MENU3 - SUB1 | 8 |
|
| ZSBILL6000 | MENU9 - SUB1 | 8 |
|
| ZSBILL6000 | MENU2 | 8 |
|
| ZSBILL6000 | MENU6 - SUB4 | 8 |
|
| ZSBILL6000 | MENU5 - SUB4 | 8 |
|
| ZSBILL6000 | MENU4 - SUB9 | 8 |
|
| ZSBILL6000 | MENU4 - SUB4 | 8 |
|
| ZSBILL6000 | MENU3 - SUB3 | 8 |
|
| ZSBILL6000 | MENU9 - SUB3 | 8 |
|
| ZSBILL6000 | MENU2 - SUB2 | 8 |
|
| ZSBILL6000 | MENU1 - SUB1 | 8 |
|
| ZSBILL6000 | MENU7 | 8 |
|
| ZSBILL6000 | MENU6 - SUB1 | 8 |
|
| ZSBILL6000 | MENU5 - SUB1 | 8 |
|
| ZSBILL6000 | MENU4 - SUB6 | 8 |
|
| ZSBILL6000 | MENU4 - SUB1 | 8 |
|
| ZSBILL6000 | MENU9 - SUB5 | 8 |
|
| ZSBILL6000 | MENU3 | 8 |
|
| ZSBILL6000 | MENU9 | 8 |
|
| ZSBILL6000 | MENU1 - SUB3 | 8 |
|
| ZSBILL6000 | MENU6 - SUB3 | 8 |
|
| ZSBILL6000 | MENU5 - SUB3 | 8 |
|
| ZSBILL6000 | MENU4 - SUB8 | 8 |
|
| ZSBILL6000 | MENU4 - SUB3 | 8 |
|
| ZSBILL6000 | MENU3 - SUB2 | 8 |
|
| ZSBILL6000 | MENU9 - SUB2 | 8 |
|
| ZSBILL6000 | MENU2 - SUB1 | 8 |
|
| ZSBILL6000 | MENU1 | 8 |
|
| ZSBILL6000 | MENU6 - SUB5 | 8 |
|
| ZSBILL9000 | MENU6 - SUB2 | 9 |
|
| ZSBILL9000 | MENU5 - SUB2 | 9 |
|
| ZSBILL9000 | MENU4 - SUB7 | 9 |
|
| ZSBILL9000 | MENU4 - SUB2 | 9 |
|
| ZSBILL9000 | MENU3 - SUB1 | 9 |
|
| ZSBILL9000 | MENU9 - SUB6 | 9 |
|
| ZSBILL9000 | MENU2 | 9 |
|
| ZSBILL9000 | MENU9 - SUB1 | 9 |
|
| ZSBILL9000 | MENU6 - SUB4 | 9 |
|
| ZSBILL9000 | MENU5 - SUB4 | 9 |
|
| ZSBILL9000 | MENU4 - SUB9 | 9 |
|
| ZSBILL9000 | MENU4 - SUB4 | 9 |
|
| ZSBILL9000 | MENU3 - SUB3 | 9 |
|
| ZSBILL9000 | MENU2 - SUB2 | 9 |
|
| ZSBILL9000 | MENU9 - SUB3 | 9 |
|
| ZSBILL9000 | MENU1 - SUB1 | 9 |
|
| ZSBILL9000 | MENU7 | 9 |
|
| ZSBILL9000 | MENU6 - SUB1 | 9 |
|
| ZSBILL9000 | MENU5 - SUB1 | 9 |
|
| ZSBILL9000 | MENU4 - SUB6 | 9 |
|
| ZSBILL9000 | MENU4 - SUB1 | 9 |
|
| ZSBILL9000 | MENU3 | 9 |
|
| ZSBILL9000 | MENU9 - SUB5 | 9 |
|
| ZSBILL9000 | MENU1 - SUB3 | 9 |
|
| ZSBILL9000 | MENU9 | 9 |
|
| ZSBILL9000 | MENU6 - SUB3 | 9 |
|
| ZSBILL9000 | MENU5 - SUB3 | 9 |
|
| ZSBILL9000 | MENU4 - SUB8 | 9 |
|
| ZSBILL9000 | MENU4 - SUB3 | 9 |
|
| ZSBILL9000 | MENU3 - SUB2 | 9 |
|
| ZSBILL9000 | MENU2 - SUB1 | 9 |
|
| ZSBILL9000 | MENU9 - SUB2 | 9 |
|
| ZSBILL9000 | MENU1 | 9 |
|
| ZSBILL9000 | MENU6 - SUB5 | 9 |
|
| ZSBILL9000 | MENU6 | 9 |
|
| ZSBILL9000 | MENU5 | 9 |
|
| ZSBILL9000 | MENU4 - SUB5 | 9 |
|
| ZSBILL9000 | MENU4 | 9 |
|
| ZSBILL9000 | MENU2 - SUB3 | 9 |
|
| ZSBILL9000 | MENU9 - SUB4 | 9 |
|
| ZSBILL9000 | MENU1 - SUB2 | 9 |
|
| ZSBILL9000 | MENU8 | 9 |
|
+--------------+---------------+--------------+
|
378 rows in set (0.01 sec)
|