2022-06-01 14:54:43.238824
SELECT 0_tax_types.*,
                    Chart1.account_name AS SalesAccountName,
                    Chart2.account_name AS PurchasingAccountName
            FROM 0_tax_types, 0_chart_master AS Chart1,
                    0_chart_master AS Chart2
            WHERE 0_tax_types.sales_gl_code = Chart1.account_code
                    AND 0_tax_types.purchasing_gl_code = Chart2.account_code  AND !0_tax_types.inactive ORDER BY 0_tax_types.sequence

2022-06-01 14:54:43.243244
SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
			FROM 0_chart_master chart,0_chart_types type
			WHERE chart.account_type=type.id ORDER BY type.class_id,type.id,account_code

2022-06-01 14:54:43.250998
SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
			FROM 0_chart_master chart,0_chart_types type
			WHERE chart.account_type=type.id ORDER BY type.class_id,type.id,account_code

2022-06-01 14:56:40.951576
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:56:48.384077
SELECT COUNT(*) FROM 0_chart_types

2022-06-01 14:56:48.389011
SELECT COUNT(*) FROM 0_chart_master

2022-06-01 14:56:48.390641
SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
			FROM 0_chart_master chart,0_chart_types type
			WHERE chart.account_type=type.id ORDER BY type.class_id,type.id,account_code

2022-06-01 14:56:48.397582
SELECT id, name FROM 0_chart_types ORDER BY class_id,id,parent

2022-06-01 14:56:48.401543
SELECT * FROM 0_tags WHERE type='1' AND !inactive ORDER BY name

2022-06-01 14:57:04.657693
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:57:08.71823
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:57:08.214062
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:57:15.359357
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:57:22.133411
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:57:22.231620
SELECT * FROM 0_fiscal_year WHERE id='15'

2022-06-01 14:57:22.247284
SELECT * FROM 0_chart_class WHERE !inactive ORDER BY ctype, cid

2022-06-01 14:57:22.255376
SELECT * FROM 0_chart_types WHERE !inactive AND class_id='1' AND (parent = '' OR parent = '-1') ORDER BY class_id, id, parent

2022-06-01 14:57:22.256978
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='77000' ORDER BY account_code

2022-06-01 14:57:22.258298
SELECT * FROM 0_chart_types WHERE !inactive AND parent='77000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.260496
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='77100' ORDER BY account_code

2022-06-01 14:57:22.264985
SELECT * FROM 0_chart_types WHERE !inactive AND parent='77100' ORDER BY class_id, id, parent

2022-06-01 14:57:22.266385
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='77200' ORDER BY account_code

2022-06-01 14:57:22.267717
SELECT * FROM 0_chart_types WHERE !inactive AND parent='77200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.270492
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='77210' ORDER BY account_code

2022-06-01 14:57:22.281565
SELECT * FROM 0_chart_types WHERE !inactive AND parent='77210' ORDER BY class_id, id, parent

2022-06-01 14:57:22.283204
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='77220' ORDER BY account_code

2022-06-01 14:57:22.294362
SELECT * FROM 0_chart_types WHERE !inactive AND parent='77220' ORDER BY class_id, id, parent

2022-06-01 14:57:22.296006
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='78000' ORDER BY account_code

2022-06-01 14:57:22.299193
SELECT * FROM 0_chart_types WHERE !inactive AND parent='78000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.300531
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='79000' ORDER BY account_code

2022-06-01 14:57:22.311135
SELECT * FROM 0_chart_types WHERE !inactive AND parent='79000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.312658
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='81000' ORDER BY account_code

2022-06-01 14:57:22.318351
SELECT * FROM 0_chart_types WHERE !inactive AND parent='81000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.319854
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='82000' ORDER BY account_code

2022-06-01 14:57:22.324701
SELECT * FROM 0_chart_types WHERE !inactive AND parent='82000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.326022
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='83000' ORDER BY account_code

2022-06-01 14:57:22.328836
SELECT * FROM 0_chart_types WHERE !inactive AND parent='83000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.330175
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='84000' ORDER BY account_code

2022-06-01 14:57:22.331380
SELECT * FROM 0_chart_types WHERE !inactive AND parent='84000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.333578
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='84100' ORDER BY account_code

2022-06-01 14:57:22.338478
SELECT * FROM 0_chart_types WHERE !inactive AND parent='84100' ORDER BY class_id, id, parent

2022-06-01 14:57:22.339706
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='84200' ORDER BY account_code

2022-06-01 14:57:22.351104
SELECT * FROM 0_chart_types WHERE !inactive AND parent='84200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.352647
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='84300' ORDER BY account_code

2022-06-01 14:57:22.358789
SELECT * FROM 0_chart_types WHERE !inactive AND parent='84300' ORDER BY class_id, id, parent

2022-06-01 14:57:22.360097
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='84400' ORDER BY account_code

2022-06-01 14:57:22.364427
SELECT * FROM 0_chart_types WHERE !inactive AND parent='84400' ORDER BY class_id, id, parent

2022-06-01 14:57:22.365859
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='84500' ORDER BY account_code

2022-06-01 14:57:22.376135
SELECT * FROM 0_chart_types WHERE !inactive AND parent='84500' ORDER BY class_id, id, parent

2022-06-01 14:57:22.378206
SELECT * FROM 0_chart_types WHERE !inactive AND class_id='2' AND (parent = '' OR parent = '-1') ORDER BY class_id, id, parent

2022-06-01 14:57:22.379707
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='50000' ORDER BY account_code

2022-06-01 14:57:22.382679
SELECT * FROM 0_chart_types WHERE !inactive AND parent='50000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.383912
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51100' ORDER BY account_code

2022-06-01 14:57:22.388746
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51100' ORDER BY class_id, id, parent

2022-06-01 14:57:22.390235
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51200' ORDER BY account_code

2022-06-01 14:57:22.403638
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.405216
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51250' ORDER BY account_code

2022-06-01 14:57:22.410398
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51250' ORDER BY class_id, id, parent

2022-06-01 14:57:22.411852
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51260' ORDER BY account_code

2022-06-01 14:57:22.416484
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51260' ORDER BY class_id, id, parent

2022-06-01 14:57:22.418259
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51270' ORDER BY account_code

2022-06-01 14:57:22.424607
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51270' ORDER BY class_id, id, parent

2022-06-01 14:57:22.426214
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51280' ORDER BY account_code

2022-06-01 14:57:22.436507
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51280' ORDER BY class_id, id, parent

2022-06-01 14:57:22.438005
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='51300' ORDER BY account_code

2022-06-01 14:57:22.448805
SELECT * FROM 0_chart_types WHERE !inactive AND parent='51300' ORDER BY class_id, id, parent

2022-06-01 14:57:22.450488
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='52000' ORDER BY account_code

2022-06-01 14:57:22.453364
SELECT * FROM 0_chart_types WHERE !inactive AND parent='52000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.454812
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='52100' ORDER BY account_code

2022-06-01 14:57:22.467687
SELECT * FROM 0_chart_types WHERE !inactive AND parent='52100' ORDER BY class_id, id, parent

2022-06-01 14:57:22.469019
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='52200' ORDER BY account_code

2022-06-01 14:57:22.470463
SELECT * FROM 0_chart_types WHERE !inactive AND parent='52200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.471780
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='53000' ORDER BY account_code

2022-06-01 14:57:22.473197
SELECT * FROM 0_chart_types WHERE !inactive AND parent='53000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.475254
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='53100' ORDER BY account_code

2022-06-01 14:57:22.487467
SELECT * FROM 0_chart_types WHERE !inactive AND parent='53100' ORDER BY class_id, id, parent

2022-06-01 14:57:22.488869
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='53200' ORDER BY account_code

2022-06-01 14:57:22.502632
SELECT * FROM 0_chart_types WHERE !inactive AND parent='53200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.504960
SELECT * FROM 0_chart_types WHERE !inactive AND class_id='5' AND (parent = '' OR parent = '-1') ORDER BY class_id, id, parent

2022-06-01 14:57:22.507000
SELECT * FROM 0_chart_types WHERE !inactive AND class_id='3' AND (parent = '' OR parent = '-1') ORDER BY class_id, id, parent

2022-06-01 14:57:22.508393
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='20000' ORDER BY account_code

2022-06-01 14:57:22.511363
SELECT * FROM 0_chart_types WHERE !inactive AND parent='20000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.512810
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='20200' ORDER BY account_code

2022-06-01 14:57:22.525398
SELECT * FROM 0_chart_types WHERE !inactive AND parent='20200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.526766
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='60000' ORDER BY account_code

2022-06-01 14:57:22.531573
SELECT * FROM 0_chart_types WHERE !inactive AND parent='60000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.533638
SELECT * FROM 0_chart_types WHERE !inactive AND class_id='4' AND (parent = '' OR parent = '-1') ORDER BY class_id, id, parent

2022-06-01 14:57:22.534998
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='10000' ORDER BY account_code

2022-06-01 14:57:22.547357
SELECT * FROM 0_chart_types WHERE !inactive AND parent='10000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.548911
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='10140' ORDER BY account_code

2022-06-01 14:57:22.553576
SELECT * FROM 0_chart_types WHERE !inactive AND parent='10140' ORDER BY class_id, id, parent

2022-06-01 14:57:22.554818
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='80000' ORDER BY account_code

2022-06-01 14:57:22.562347
SELECT * FROM 0_chart_types WHERE !inactive AND parent='80000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.564764
SELECT * FROM 0_chart_types WHERE !inactive AND class_id='6' AND (parent = '' OR parent = '-1') ORDER BY class_id, id, parent

2022-06-01 14:57:22.566286
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='30000' ORDER BY account_code

2022-06-01 14:57:22.568090
SELECT * FROM 0_chart_types WHERE !inactive AND parent='30000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.570495
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='30100' ORDER BY account_code

2022-06-01 14:57:22.578184
SELECT * FROM 0_chart_types WHERE !inactive AND parent='30100' ORDER BY class_id, id, parent

2022-06-01 14:57:22.579714
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='30200' ORDER BY account_code

2022-06-01 14:57:22.616353
SELECT * FROM 0_chart_types WHERE !inactive AND parent='30200' ORDER BY class_id, id, parent

2022-06-01 14:57:22.618590
SELECT 0_chart_master.*, 0_chart_types.name AS AccountTypeName, 0_chart_types.depth   
		FROM 0_chart_master,0_chart_types
		WHERE 0_chart_master.account_type=0_chart_types.id AND account_type='40000' ORDER BY account_code

2022-06-01 14:57:22.625170
SELECT * FROM 0_chart_types WHERE !inactive AND parent='40000' ORDER BY class_id, id, parent

2022-06-01 14:57:22.630467
SELECT printer FROM 0_print_profiles WHERE profile='' AND report='701'

2022-06-01 14:57:22.635396
SELECT printer FROM 0_print_profiles WHERE profile='' AND report=''

2022-06-01 15:01:04.734336
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:01:08.680385
SELECT COUNT(*) FROM 0_tax_types

2022-06-01 15:01:08.707170
SELECT * FROM 0_tax_groups WHERE !inactive ORDER BY display_sequence

2022-06-01 15:01:08.724890
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id=(SELECT id FROM 0_tax_groups WHERE tax_shipping=1) WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:01:09.354082
SELECT COUNT(*) FROM 0_tax_types

2022-06-01 15:01:09.356073
SELECT * FROM 0_tax_groups WHERE !inactive ORDER BY display_sequence

2022-06-01 15:01:09.359303
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id=(SELECT id FROM 0_tax_groups WHERE tax_shipping=1) WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:03:36.76985
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:03:38.638727
SELECT COUNT(*) FROM 0_tax_types

2022-06-01 15:03:38.640612
SELECT * FROM 0_tax_groups WHERE !inactive ORDER BY display_sequence

2022-06-01 15:03:38.643674
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id=(SELECT id FROM 0_tax_groups WHERE tax_shipping=1) WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:03:38.857906
SELECT COUNT(*) FROM 0_tax_types

2022-06-01 15:03:38.859711
SELECT * FROM 0_tax_groups WHERE !inactive ORDER BY display_sequence

2022-06-01 15:03:38.862692
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id=(SELECT id FROM 0_tax_groups WHERE tax_shipping=1) WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:04:13.204134
SELECT COUNT(*) FROM 0_tax_types

2022-06-01 15:04:13.206099
SELECT tax_code, id  
            FROM 0_tax_groups  
            WHERE tax_code = 'SVAT12'

2022-06-01 15:04:13.208083
SELECT name, id   
            FROM 0_tax_groups  
            WHERE name = 'SVAT 12 Only'

2022-06-01 15:04:13.210534
SELECT rate FROM 0_tax_types WHERE id='9'

2022-06-01 15:04:13.211882
BEGIN

2022-06-01 15:04:13.213621
INSERT INTO 0_tax_groups (name, tax_shipping, display_sequence, 
                                                   inactive, tax_code) 
                    VALUES ('SVAT 12 Only', '0', '155', 
                            '0', 'SVAT12')

2022-06-01 15:04:13.215984
INSERT INTO 0_tax_group_items (tax_group_id, tax_type_id, rate)
			VALUES ('10',  '9', 12)

2022-06-01 15:04:13.218756
COMMIT

2022-06-01 15:04:13.221828
SELECT * FROM 0_tax_groups WHERE !inactive ORDER BY display_sequence

2022-06-01 15:04:13.225330
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id=(SELECT id FROM 0_tax_groups WHERE tax_shipping=1) WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:04:47.443381
SELECT COUNT(*) FROM 0_tax_types

2022-06-01 15:04:47.445373
SELECT tax_code, id  
            FROM 0_tax_groups  
            WHERE tax_code = 'VAT12'

2022-06-01 15:04:47.446872
SELECT name, id   
            FROM 0_tax_groups  
            WHERE name = 'VAT 12 Only'

2022-06-01 15:04:47.448341
SELECT rate FROM 0_tax_types WHERE id='8'

2022-06-01 15:04:47.449825
BEGIN

2022-06-01 15:04:47.451518
INSERT INTO 0_tax_groups (name, tax_shipping, display_sequence, 
                                                   inactive, tax_code) 
                    VALUES ('VAT 12 Only', '0', '8', 
                            '0', 'VAT12')

2022-06-01 15:04:47.453817
INSERT INTO 0_tax_group_items (tax_group_id, tax_type_id, rate)
			VALUES ('11',  '8', 12)

2022-06-01 15:04:47.455195
COMMIT

2022-06-01 15:04:47.459162
SELECT * FROM 0_tax_groups WHERE !inactive ORDER BY display_sequence

2022-06-01 15:04:47.462662
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id=(SELECT id FROM 0_tax_groups WHERE tax_shipping=1) WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:05:09.307642
SELECT * FROM 0_fiscal_year WHERE '2022-06-01' >= begin AND '2022-06-01' <= end AND closed=0

2022-06-01 15:05:09.312786
SELECT next_reference FROM 0_sys_types WHERE type_id = '18'

2022-06-01 15:05:09.317655
SELECT COUNT(*) FROM 0_suppliers

2022-06-01 15:05:09.323497
SELECT COUNT(*) FROM 0_stock_master WHERE mb_flag!='M'

2022-06-01 15:05:09.347859
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:05:09.350434
SELECT supplier_id, supp_ref,  value_name, supp_name, curr_code, s.inactive 
            FROM 0_suppliers s
                    LEFT JOIN 0_list_values lv ON 
                            s.supplier_type = lv.id ORDER BY value_name,supp_ref

2022-06-01 15:05:09.358893
SELECT * FROM 0_suppliers WHERE supplier_id='35'

2022-06-01 15:05:09.360712
SELECT id, name FROM 0_tax_groups WHERE inactive = 0 ORDER BY display_sequence

2022-06-01 15:05:09.362485
SELECT curr_code, supp_name, supp.tax_group_id, supp.tax_included,
			supp.credit_limit - Sum(IFNULL(ov_amount + ov_gst + ov_discount,0)) as cur_credit,
				terms.terms, terms.days_before_due, terms.day_in_following_month
		FROM 0_suppliers supp
			 LEFT JOIN 0_supp_trans trans ON supp.supplier_id = trans.supplier_id
			 LEFT JOIN 0_payment_terms terms ON supp.payment_terms=terms.terms_indicator
		WHERE supp.supplier_id = '35'
		GROUP BY
			  supp.supp_name

2022-06-01 15:05:09.367131
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id='5' WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:05:09.369928
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 15:05:09.371783
SELECT terms.terms_indicator, terms.terms, terms.days_before_due, terms.day_in_following_month
            FROM 0_suppliers supp
                    LEFT JOIN 0_payment_terms terms ON 
                            supp.payment_terms=terms.terms_indicator
            WHERE supp.supplier_id = '35'

2022-06-01 15:05:09.373436
SELECT terms_indicator, terms, inactive FROM 0_payment_terms ORDER BY terms

2022-06-01 15:05:09.375204
SELECT *, (t.days_before_due=0) AND (t.day_in_following_month=0) as cash_sale
	 FROM 0_payment_terms t WHERE terms_indicator='4'

2022-06-01 15:05:09.376867
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =1 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:05:09.378701
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '' AND 
                        pap.approval_path_type = 'PO'

2022-06-01 15:05:09.380426
SELECT delivery_address, phone FROM 0_locations WHERE loc_code='HEAD'

2022-06-01 15:05:09.382530
SELECT stock_id, s.description, c.description, s.inactive, s.editable
			FROM 0_stock_master s,0_stock_category c WHERE s.category_id=c.category_id AND s.inactive = 0 AND (stock_id='') ORDER BY c.description,stock_id

2022-06-01 15:05:09.384234
SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units, decimals, stock_control_method , minimum_price 
		FROM 0_stock_master,0_item_units
		WHERE stock_id='' AND 0_stock_master.units=0_item_units.abbr

2022-06-01 15:05:09.386046
SELECT au.alternate_unit, iu.name 
                FROM 0_alternate_units au,
                        0_item_units iu  
                WHERE au.alternate_unit = iu.abbr AND 
                        au.stock_id = '' AND au.inactive = 0 ORDER BY name

2022-06-01 15:05:09.396315
SELECT id, description  FROM 0_project_sites WHERE project_id = '' ORDER BY description

2022-06-01 15:05:09.399882
SELECT price, discount    
            FROM 0_purch_data
            WHERE stock_id = '' 
                    AND supplier_id = '35' 
                    AND (project_id = '' OR project_id = 0) 
                    AND suppliers_uom = '' 
                    AND effective_date <= '2022-06-02' 
                    AND expiry_date >= '2022-06-02' 
                    
            ORDER BY effective_date DESC, price LIMIT 1

2022-06-01 15:05:13.474737
SELECT COUNT(*) FROM 0_suppliers

2022-06-01 15:05:13.476816
SELECT COUNT(*) FROM 0_stock_master WHERE mb_flag!='M'

2022-06-01 15:05:13.479178
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:05:13.481332
SELECT supplier_id, supp_ref,  value_name, supp_name, curr_code, s.inactive 
            FROM 0_suppliers s
                    LEFT JOIN 0_list_values lv ON 
                            s.supplier_type = lv.id ORDER BY value_name,supp_ref

2022-06-01 15:05:13.488816
SELECT id, name FROM 0_tax_groups WHERE inactive = 0 ORDER BY display_sequence

2022-06-01 15:05:13.491704
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id='10' WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:05:13.493971
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 15:05:13.495580
SELECT terms_indicator, terms, inactive FROM 0_payment_terms ORDER BY terms

2022-06-01 15:05:13.497083
SELECT *, (t.days_before_due=0) AND (t.day_in_following_month=0) as cash_sale
	 FROM 0_payment_terms t WHERE terms_indicator='4'

2022-06-01 15:05:13.498718
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =1 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:05:13.500434
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '' AND 
                        pap.approval_path_type = 'PO'

2022-06-01 15:05:13.502949
SELECT stock_id, s.description, c.description, s.inactive, s.editable
			FROM 0_stock_master s,0_stock_category c WHERE s.category_id=c.category_id AND s.inactive = 0 AND (stock_id='') ORDER BY c.description,stock_id

2022-06-01 15:05:13.504685
SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units, decimals, stock_control_method , minimum_price 
		FROM 0_stock_master,0_item_units
		WHERE stock_id='' AND 0_stock_master.units=0_item_units.abbr

2022-06-01 15:05:13.506363
SELECT au.alternate_unit, iu.name 
                FROM 0_alternate_units au,
                        0_item_units iu  
                WHERE au.alternate_unit = iu.abbr AND 
                        au.stock_id = '' AND au.inactive = 0 ORDER BY name

2022-06-01 15:05:13.508999
SELECT id, description  FROM 0_project_sites WHERE project_id = '' ORDER BY description

2022-06-01 15:05:20.879209
SELECT COUNT(*) FROM 0_suppliers

2022-06-01 15:05:20.881371
SELECT COUNT(*) FROM 0_stock_master WHERE mb_flag!='M'

2022-06-01 15:05:20.883836
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:05:20.886105
SELECT supplier_id, supp_ref,  value_name, supp_name, curr_code, s.inactive 
            FROM 0_suppliers s
                    LEFT JOIN 0_list_values lv ON 
                            s.supplier_type = lv.id ORDER BY value_name,supp_ref

2022-06-01 15:05:20.894038
SELECT id, name FROM 0_tax_groups WHERE inactive = 0 ORDER BY display_sequence

2022-06-01 15:05:20.897517
SELECT t.sequence, t.add_to_price, t.name, t.id as tax_type_id, t.suspended, CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,t.sales_gl_code,
                t.purchasing_gl_code,
                IF(g.tax_type_id, t.rate, NULL) as rate                 
            FROM 0_tax_types t 
                    LEFT JOIN 0_tax_group_items g ON t.id=g.tax_type_id
                            AND g.tax_group_id='11' WHERE !t.inactive  ORDER BY t.sequence

2022-06-01 15:05:20.900150
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 15:05:20.902108
SELECT terms_indicator, terms, inactive FROM 0_payment_terms ORDER BY terms

2022-06-01 15:05:20.903765
SELECT *, (t.days_before_due=0) AND (t.day_in_following_month=0) as cash_sale
	 FROM 0_payment_terms t WHERE terms_indicator='4'

2022-06-01 15:05:20.905482
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =1 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:05:20.907294
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '' AND 
                        pap.approval_path_type = 'PO'

2022-06-01 15:05:20.909573
SELECT stock_id, s.description, c.description, s.inactive, s.editable
			FROM 0_stock_master s,0_stock_category c WHERE s.category_id=c.category_id AND s.inactive = 0 AND (stock_id='') ORDER BY c.description,stock_id

2022-06-01 15:05:20.911353
SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units, decimals, stock_control_method , minimum_price 
		FROM 0_stock_master,0_item_units
		WHERE stock_id='' AND 0_stock_master.units=0_item_units.abbr

2022-06-01 15:05:20.913040
SELECT au.alternate_unit, iu.name 
                FROM 0_alternate_units au,
                        0_item_units iu  
                WHERE au.alternate_unit = iu.abbr AND 
                        au.stock_id = '' AND au.inactive = 0 ORDER BY name

2022-06-01 15:05:20.915730
SELECT id, description  FROM 0_project_sites WHERE project_id = '' ORDER BY description

