25/06/2022 08:53:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 08:53:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2041' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.50' , '121.50' , NOW() , NOW() ) 25/06/2022 08:53:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58898' 25/06/2022 08:53:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58898' 25/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58898' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '27' , '-27' , '4' , '4.5' , '4.5' , '0' , '0' , '121.50' ) 25/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 25/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 25/06/2022 08:53:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 08:53:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2042' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 25/06/2022 08:53:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58899' 25/06/2022 08:53:19 am >> DELETE FROM ps_document_detail WHERE id_document = '58899' 25/06/2022 08:53:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58899' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 25/06/2022 08:53:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 25/06/2022 08:53:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 25/06/2022 09:10:15 am >> SELECT document_num FROM ps_document WHERE document_num = '20/E' AND id_document != '58888' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-24') 25/06/2022 09:10:15 am >> UPDATE ps_document SET id_document_type = '23', document_num = '20/E', document_date = '2022-06-24', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '820.80', price_tax_excluded = '672.79', date_upd = NOW() WHERE id_document = '58888' 25/06/2022 09:10:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58888' 25/06/2022 09:10:15 am >> DELETE FROM ps_document_detail WHERE id_document = '58888' 25/06/2022 09:10:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58888' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '38.0000' , '31.147540983607' , '22' , '40' , '273.60' ) 25/06/2022 09:10:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 25/06/2022 09:10:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 25/06/2022 09:10:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58888' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '38.0000' , '31.147540983607' , '22' , '40' , '273.60' ) 25/06/2022 09:10:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 25/06/2022 09:10:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 25/06/2022 09:10:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58888' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '12' , '-12' , '1' , '38.0000' , '31.147540983607' , '22' , '40' , '273.60' ) 25/06/2022 09:10:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '12818' AND id_supplier = '' 25/06/2022 09:10:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12818' , '' , '1' ) 25/06/2022 09:29:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 09:29:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2043' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.80' , '17.05' , NOW() , NOW() ) 25/06/2022 09:29:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58900' 25/06/2022 09:29:56 am >> DELETE FROM ps_document_detail WHERE id_document = '58900' 25/06/2022 09:29:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58900' , '1339' , 'BRACCIALE PADRE NOSTRO' , '3' , '-3' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '20.70' ) 25/06/2022 09:29:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '1339' AND id_supplier = '' 25/06/2022 09:29:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1339' , '' , '1' ) 25/06/2022 09:29:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58900' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.10' , '0.081967213114754' , '22' , '0' , '0.10' ) 25/06/2022 09:29:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 25/06/2022 09:29:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 25/06/2022 09:41:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2043' AND id_document != '58900' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 09:41:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2043', document_date = '2022-06-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.80', price_tax_excluded = '17.05', date_upd = NOW() WHERE id_document = '58900' 25/06/2022 09:41:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58900' 25/06/2022 09:41:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58900' 25/06/2022 09:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58900' , '1339' , 'BRACCIALE PADRE NOSTRO' , '3' , '-3' , '1' , '6.7' , '5.4918032786885' , '22' , '0' , '20.10' ) 25/06/2022 09:41:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1339' AND id_supplier = '' 25/06/2022 09:41:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1339' , '' , '1' ) 25/06/2022 09:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58900' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '0.70' ) 25/06/2022 09:41:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 25/06/2022 09:41:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 25/06/2022 10:28:30 am >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '58887' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-24') 25/06/2022 10:28:30 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18', document_date = '2022-06-24', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1130.00', price_tax_excluded = '1130.00', date_upd = NOW() WHERE id_document = '58887' 25/06/2022 10:28:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58887' 25/06/2022 10:28:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58887' 25/06/2022 10:28:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58887' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '350' , '-350' , '4' , '1.0000' , '1' , '0' , '0' , '350.00' ) 25/06/2022 10:28:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '15030' AND id_supplier = '' 25/06/2022 10:28:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15030' , '' , '1' ) 25/06/2022 10:28:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58887' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '38' , '-38' , '4' , '15.0000' , '15' , '0' , '0' , '570.00' ) 25/06/2022 10:28:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '17117' AND id_supplier = '' 25/06/2022 10:28:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17117' , '' , '1' ) 25/06/2022 10:28:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58887' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '30' , '-30' , '4' , '7.0000' , '7' , '0' , '0' , '210.00' ) 25/06/2022 10:28:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 25/06/2022 10:28:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 25/06/2022 10:29:24 am >> DELETE FROM ps_document WHERE id_document = '53221' 25/06/2022 10:29:24 am >> DELETE FROM ps_document_detail WHERE id_document = '53221' 25/06/2022 10:33:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 10:33:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2044' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 25/06/2022 10:33:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58901' 25/06/2022 10:33:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58901' 25/06/2022 10:33:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58901' , '18928' , 'SAN PIO E GLI SPIRITI CELESTI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 25/06/2022 10:33:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '18928' AND id_supplier = '' 25/06/2022 10:33:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18928' , '' , '1' ) 25/06/2022 10:35:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 10:35:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2045' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '52.38' , NOW() , NOW() ) 25/06/2022 10:35:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58902' 25/06/2022 10:35:49 am >> DELETE FROM ps_document_detail WHERE id_document = '58902' 25/06/2022 10:35:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58902' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 25/06/2022 10:35:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 25/06/2022 10:35:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 25/06/2022 10:35:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58902' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '37' , '37' , '0' , '' , '37.00' ) 25/06/2022 10:35:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '' 25/06/2022 10:35:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '' , '1' ) 25/06/2022 11:57:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 11:57:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2046' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 25/06/2022 11:57:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58903' 25/06/2022 11:57:47 am >> DELETE FROM ps_document_detail WHERE id_document = '58903' 25/06/2022 11:57:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58903' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 25/06/2022 11:57:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '' 25/06/2022 11:57:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '' , '1' ) 25/06/2022 12:03:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 12:03:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2047' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 25/06/2022 12:03:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58904' 25/06/2022 12:03:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '58904' 25/06/2022 12:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58904' , '17037' , 'CLERGY M/LINO MM ' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 25/06/2022 12:03:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17037' AND id_supplier = '' 25/06/2022 12:03:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17037' , '' , '1' ) 25/06/2022 12:04:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 12:04:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2048' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 25/06/2022 12:04:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58905' 25/06/2022 12:04:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58905' 25/06/2022 12:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58905' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 25/06/2022 12:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '' 25/06/2022 12:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '' , '1' ) 25/06/2022 12:15:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 12:15:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2049' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 25/06/2022 12:15:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58906' 25/06/2022 12:15:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '58906' 25/06/2022 12:15:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58906' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 25/06/2022 12:15:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/06/2022 12:15:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/06/2022 12:27:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 12:27:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2050' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.75' , NOW() , NOW() ) 25/06/2022 12:27:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58907' 25/06/2022 12:27:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '58907' 25/06/2022 12:27:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58907' , '18761' , 'BRACCIALE ARG. DIAMANTINO - 1856' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 25/06/2022 12:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18761' AND id_supplier = '' 25/06/2022 12:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18761' , '' , '1' ) 25/06/2022 12:27:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58907' , '529' , 'AMORIS LAETITIA' , '2' , '-2' , '4' , '2' , '2' , '0' , '0' , '4.00' ) 25/06/2022 12:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '' 25/06/2022 12:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '' , '1' ) 25/06/2022 12:28:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1452' AND id_document != '56661' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-07') 25/06/2022 12:28:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1452', document_date = '2022-05-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '31.80', price_tax_excluded = '28.60', date_upd = NOW() WHERE id_document = '56661' 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56661' 25/06/2022 12:28:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '56661' 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56661' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 25/06/2022 12:28:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 25/06/2022 12:28:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56661' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 25/06/2022 12:28:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '' 25/06/2022 12:28:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '' , '1' ) 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56661' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 25/06/2022 12:28:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 25/06/2022 12:28:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56661' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '11.00' ) 25/06/2022 12:28:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 25/06/2022 12:28:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56661' , '529' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 25/06/2022 12:28:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '' 25/06/2022 12:28:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '' , '1' ) 25/06/2022 12:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56661' , '18222' , 'ROSARIO COLORATO - R316' , '5' , '-5' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '3.50' ) 25/06/2022 12:28:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 25/06/2022 12:28:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 25/06/2022 12:32:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856685015' AND id_product != '19501' AND ean13 != '' 25/06/2022 12:32:02 pm >> UPDATE ps_product SET id_supplier = '47', reference = '7/6', ean13 = '9788856685015', date_upd = NOW() WHERE id_product = '19501' 25/06/2022 12:32:02 pm >> UPDATE ps_product_lang SET name = 'PACE INTERIORE - C. AMIRANTE', description = '' WHERE id_product = '19501' 25/06/2022 12:32:02 pm >> UPDATE ps_product SET wholesale_price = '9.42', on_sale = '0', price = '12.9000' WHERE id_product = '19501' 25/06/2022 12:32:02 pm >> UPDATE ps_product_shop SET wholesale_price = '9.42', price = '12.9000', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19501' 25/06/2022 12:32:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19501' 25/06/2022 12:40:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2051' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 25/06/2022 12:40:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2051' , '2022-06-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.75' , NOW() , NOW() ) 25/06/2022 12:40:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58908' 25/06/2022 12:40:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '58908' 25/06/2022 12:40:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58908' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 25/06/2022 12:40:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 25/06/2022 12:40:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 25/06/2022 12:40:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58908' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 25/06/2022 12:40:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 25/06/2022 12:40:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )