14/07/2022 09:41:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2264' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 09:42:00 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' , '2264' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 14/07/2022 09:42:00 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 = '59167' 14/07/2022 09:42:00 am >> DELETE FROM ps_document_detail WHERE id_document = '59167' 14/07/2022 09:42:00 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 ( '59167' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 14/07/2022 09:42:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 14/07/2022 09:42:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 14/07/2022 09:43:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2265' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 09:43:43 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' , '2265' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '4.16' , NOW() , NOW() ) 14/07/2022 09:43:43 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 = '59168' 14/07/2022 09:43:43 am >> DELETE FROM ps_document_detail WHERE id_document = '59168' 14/07/2022 09:43:43 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 ( '59168' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 14/07/2022 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '' 14/07/2022 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '' , '1' ) 14/07/2022 09:43:43 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 ( '59168' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 14/07/2022 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 14/07/2022 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 14/07/2022 09:43:43 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 ( '59168' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 14/07/2022 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '6356' AND id_supplier = '' 14/07/2022 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6356' , '' , '1' ) 14/07/2022 10:04:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2266' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 10:04:11 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' , '2266' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 14/07/2022 10:04:11 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 = '59169' 14/07/2022 10:04:11 am >> DELETE FROM ps_document_detail WHERE id_document = '59169' 14/07/2022 10:04:11 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 ( '59169' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '30' , '-30' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '30.00' ) 14/07/2022 10:04:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18619' AND id_supplier = '' 14/07/2022 10:04:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18619' , '' , '1' ) 14/07/2022 10:08:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2267' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 10:08:36 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' , '2267' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 14/07/2022 10:08:36 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 = '59170' 14/07/2022 10:08:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59170' 14/07/2022 10:08:36 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 ( '59170' , '19657' , 'STATUA ADDOLORATA CM 20 - 355' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 14/07/2022 10:08:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19657' AND id_supplier = '' 14/07/2022 10:08:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19657' , '' , '1' ) 14/07/2022 10:33:17 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 ( '33' , '604717' , '2022-07-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '42.12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1326.86' , '1326.86' , NOW() , NOW() ) 14/07/2022 10:33:17 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 = '59171' 14/07/2022 10:33:17 am >> DELETE FROM ps_document_detail WHERE id_document = '59171' 14/07/2022 10:33:17 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 ( '59171' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 14/07/2022 10:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 14/07/2022 10:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 14/07/2022 10:33:17 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 ( '59171' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '14529' , 'PANE E VINO - SUSSIDIO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '7' 14/07/2022 10:33:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '7' , '1' ) 14/07/2022 10:33:18 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 ( '59171' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 14/07/2022 10:33:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5451' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5451' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '60' , '60' , '4' , '3.00' , '3' , '0' , '35+7' , '108.8100' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '5' , '5' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '60' , '60' , '4' , '3.00' , '3' , '0' , '35+7' , '108.8100' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '5' , '5' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '7' 14/07/2022 10:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '7' , '1' ) 14/07/2022 10:33: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 ( '59171' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '84' , '84' , '4' , '3.00' , '3' , '0' , '35+7' , '152.3340' ) 14/07/2022 10:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '7' , '7' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '60' , '60' , '4' , '3.00' , '3' , '0' , '35+7' , '108.8100' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '5' , '5' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '9681' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9681' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '48' , '48' , '4' , '3.00' , '3' , '0' , '35+7' , '87.0480' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '4' , '4' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '7' , '1' ) 14/07/2022 10:33:20 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 ( '59171' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '48' , '48' , '4' , '3.00' , '3' , '0' , '35+7' , '87.0480' ) 14/07/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '7' 14/07/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '4' , '4' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '36' , '36' , '4' , '5.00' , '5' , '0' , '35+7' , '108.8100' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '3' , '3' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '60' , '60' , '4' , '5.00' , '5' , '0' , '35+7' , '181.3500' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '5' , '5' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '10748' , 'TU MI CHIAMI PER NOME' , '12' , '12' , '4' , '4.90' , '4.9' , '0' , '30+7' , '38.2788' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '14719' , 'TU MI AMI DAVVERO' , '12' , '12' , '4' , '4.90' , '4.9' , '0' , '30+7' , '38.2788' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 14/07/2022 10:33:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 14/07/2022 10:33:21 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 ( '59171' , '14719' , 'TU MI AMI DAVVERO' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 14/07/2022 10:33:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 14/07/2022 10:33:22 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 ( '59171' , '10751' , 'TU MI PERDONI' , '12' , '12' , '4' , '4.90' , '4.9' , '0' , '30+7' , '38.2788' ) 14/07/2022 10:33:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 14/07/2022 10:33:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 14/07/2022 10:33:22 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 ( '59171' , '10751' , 'TU MI PERDONI' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 14/07/2022 10:33:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 14/07/2022 10:33:22 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 ( '59171' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '12' , '12' , '4' , '4.90' , '4.9' , '0' , '30+7' , '38.2788' ) 14/07/2022 10:33:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16129' AND id_supplier = '7' 14/07/2022 10:33:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16129' , '7' , '1' ) 14/07/2022 10:33:22 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 ( '59171' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '100' , '0.0000' ) 14/07/2022 10:33:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16129' AND id_supplier = '7' 14/07/2022 10:33:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16129' , '7' , '1' ) 14/07/2022 10:39:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2268' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 10:39:48 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' , '2268' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.69' , NOW() , NOW() ) 14/07/2022 10:39:48 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 = '59172' 14/07/2022 10:39:48 am >> DELETE FROM ps_document_detail WHERE id_document = '59172' 14/07/2022 10:39:48 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 ( '59172' , '8179' , 'PORTACORONA - 017' , '1' , '-1' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '1.70' ) 14/07/2022 10:39:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '8179' AND id_supplier = '' 14/07/2022 10:39:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8179' , '' , '1' ) 14/07/2022 10:39:48 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 ( '59172' , '872' , 'AVE PIENA DI GRAZIA ' , '1' , '-1' , '4' , '1.30' , '1.3' , '0' , '0' , '1.30' ) 14/07/2022 10:39:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '872' AND id_supplier = '' 14/07/2022 10:39:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '872' , '' , '1' ) 14/07/2022 10:39:48 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 ( '59172' , '19583' , 'ROSARIO AL SACRO CUORE - 8063' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 14/07/2022 10:39:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19583' AND id_supplier = '' 14/07/2022 10:39:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19583' , '' , '1' ) 14/07/2022 10:42:59 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 ( '33' , '283' , '2022-07-11' , '' , '0' , '127' , '4670269' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 14/07/2022 10:42:59 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 = '5377' 14/07/2022 10:42:59 am >> DELETE FROM ps_document_detail WHERE id_document = '5377' 14/07/2022 10:42:59 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 ( '5377' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '400' , '400' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 14/07/2022 10:42:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '127' 14/07/2022 10:42:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '127' , '1' ) 14/07/2022 10:45:15 am >> SELECT document_num FROM ps_document WHERE document_num = '50/A' AND id_document != '59120' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 14/07/2022 10:45:15 am >> UPDATE ps_document SET id_document_type = '24', document_num = '50/A', document_date = '2022-07-08', document_letter = 'A', id_customer = '2379', id_supplier = '', id_address = '4671437', address1 = 'R.NE PESCARA 84025 EBOLI', 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 = '1084.00', price_tax_excluded = '1084.00', date_upd = NOW() WHERE id_document = '59120' 14/07/2022 10:45: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 = '59120' 14/07/2022 10:45:15 am >> DELETE FROM ps_document_detail WHERE id_document = '59120' 14/07/2022 10:45: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 ( '59120' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '10' , '135.00' ) 14/07/2022 10:45:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '' 14/07/2022 10:45:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '' , '1' ) 14/07/2022 10:45: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 ( '59120' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '50' , '-50' , '4' , '5.0000' , '5' , '0' , '10' , '225.00' ) 14/07/2022 10:45:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '' 14/07/2022 10:45:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '' , '1' ) 14/07/2022 10:45:16 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 ( '59120' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 14/07/2022 10:45:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 14/07/2022 10:45:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 14/07/2022 10:45:16 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 ( '59120' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '10' , '108.00' ) 14/07/2022 10:45:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 14/07/2022 10:45:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 14/07/2022 10:45:16 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 ( '59120' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '80' , '-80' , '4' , '3.0000' , '3' , '0' , '10' , '216.00' ) 14/07/2022 10:45:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 14/07/2022 10:45:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 14/07/2022 10:45:16 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 ( '59120' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '10' , '135.00' ) 14/07/2022 10:45:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 14/07/2022 10:45:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 14/07/2022 10:45:16 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 ( '59120' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 14/07/2022 10:45:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 14/07/2022 10:45:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 14/07/2022 10:45:17 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 ( '59120' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 14/07/2022 10:45:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 14/07/2022 10:45:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 14/07/2022 10:45:17 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 ( '59120' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '20' , '8.00' ) 14/07/2022 10:45:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 14/07/2022 10:45:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 14/07/2022 10:45:17 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 ( '59120' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.4000' , '3.4' , '0' , '20' , '68.00' ) 14/07/2022 10:45:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 14/07/2022 10:45:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 14/07/2022 11:41:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2269' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 11:41:31 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' , '2269' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.65' , '72.37' , NOW() , NOW() ) 14/07/2022 11:41:31 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 = '59173' 14/07/2022 11:41:31 am >> DELETE FROM ps_document_detail WHERE id_document = '59173' 14/07/2022 11:41: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 ( '59173' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/07/2022 11:41:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11272' AND id_supplier = '' 14/07/2022 11:41:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11272' , '' , '1' ) 14/07/2022 11:41: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 ( '59173' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '47.00' , '38.524590163934' , '22' , '0' , '47.00' ) 14/07/2022 11:41:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '780' AND id_supplier = '' 14/07/2022 11:41:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '780' , '' , '1' ) 14/07/2022 11:41: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 ( '59173' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '5' , '25.65' ) 14/07/2022 11:41:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '' 14/07/2022 11:41:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '' , '1' ) 14/07/2022 11:47:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2270' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 11:47:13 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' , '2270' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 14/07/2022 11:47:13 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 = '59174' 14/07/2022 11:47:13 am >> DELETE FROM ps_document_detail WHERE id_document = '59174' 14/07/2022 11:47:13 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 ( '59174' , '18246' , 'CLERGY JEANS NIDO DAPE MM - S' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 14/07/2022 11:47:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '18246' AND id_supplier = '' 14/07/2022 11:47:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18246' , '' , '1' ) 14/07/2022 11:47:13 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 ( '59174' , '18257' , 'CLERGY BLU NIDO DAPE MM - S' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 14/07/2022 11:47:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '18257' AND id_supplier = '' 14/07/2022 11:47:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18257' , '' , '1' ) 14/07/2022 11:47:14 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 ( '59174' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 14/07/2022 11:47:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 14/07/2022 11:47:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 14/07/2022 11:47:14 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 ( '59174' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 14/07/2022 11:47:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 14/07/2022 11:47:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 14/07/2022 11:47:14 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 ( '59174' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 14/07/2022 11:47:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '1544' AND id_supplier = '' 14/07/2022 11:47:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1544' , '' , '1' ) 14/07/2022 12:47:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2271' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 12:47:10 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' , '2271' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 14/07/2022 12:47:10 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 = '59175' 14/07/2022 12:47:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '59175' 14/07/2022 12:47:10 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 ( '59175' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 14/07/2022 12:47:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 14/07/2022 12:47:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 14/07/2022 12:57:35 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2866' 14/07/2022 12:57:35 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '2866' , '10' , '145' , '' , 'GIANNICO' , 'DON MASSIMILIANO' , 'VIA ROMA, 9' , '9' , '81016' , 'SAN POTITO SANNITICO' , 'VIA MUNICIPIO 18 - TABACCHINO - ' , '0823863607' , '' , '' , '' , NOW() , NOW() ) 14/07/2022 12:57:35 pm >> UPDATE ps_customer SET email = 'massimilianogiannico@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2866' 14/07/2022 01:00:00 pm >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-07-14' WHERE id_order = '367' 14/07/2022 01:00:00 pm >> DELETE FROM ps_document WHERE document_num = '367' AND id_document_type = '28' 14/07/2022 01:00:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 01:00:40 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 ( '21' , '105' , '2022-07-14' , '' , '2866' , '0' , '4674412' , 'VIA ROMA, 9 81016 SAN POTITO SANNITICO' , '' , '' , '5.00' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '43.00' , '43.00' , NOW() , NOW() ) 14/07/2022 01:00:40 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 = '59687' 14/07/2022 01:00:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '59687' 14/07/2022 01:00:40 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 ( '59687' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '25' , '-25' , '4' , '1.6000' , '1.6' , '0' , '5' , '38.00' ) 14/07/2022 05:02:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2272' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 05:02:56 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' , '2272' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 14/07/2022 05:02:56 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 = '59688' 14/07/2022 05:02:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '59688' 14/07/2022 05:02:56 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 ( '59688' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 14/07/2022 05:02:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 14/07/2022 05:02:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 14/07/2022 05:02:56 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 ( '59688' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/07/2022 05:02:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 14/07/2022 05:02:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 14/07/2022 05:21:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2273' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 05:21:44 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' , '2273' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 14/07/2022 05:21:44 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 = '59689' 14/07/2022 05:21:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '59689' 14/07/2022 05:21:44 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 ( '59689' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/07/2022 05:21:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 14/07/2022 05:21:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 14/07/2022 06:13:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2274' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 14/07/2022 06:13:08 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' , '2274' , '2022-07-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '530.00' , '434.43' , NOW() , NOW() ) 14/07/2022 06:13:08 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 = '59690' 14/07/2022 06:13:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '59690' 14/07/2022 06:13:08 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 ( '59690' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '490' , '401.6393442623' , '22' , '0' , '490.00' ) 14/07/2022 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 14/07/2022 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 14/07/2022 06:13:08 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 ( '59690' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 14/07/2022 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7736' AND id_supplier = '' 14/07/2022 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7736' , '' , '1' )