14/02/2023 09:03:32 am >> SELECT document_num FROM ps_document WHERE document_num = '507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 09:03:33 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' , '507' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '3.20' , NOW() , NOW() ) 14/02/2023 09:03:33 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 = '81347' 14/02/2023 09:03:33 am >> DELETE FROM ps_document_detail WHERE id_document = '81347' 14/02/2023 09:03:33 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 ( '81347' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 14/02/2023 09:51:12 am >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '81337' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-13') 14/02/2023 09:51:12 am >> UPDATE ps_document SET id_document_type = '24', document_num = '8', document_date = '2023-02-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = 'RESA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '168.00', price_tax_excluded = '162.95', date_upd = NOW() WHERE id_document = '81337' 14/02/2023 09:51:12 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 = '81337' 14/02/2023 09:51:12 am >> DELETE FROM ps_document_detail WHERE id_document = '81337' 14/02/2023 09:51:12 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 ( '81337' , '15867' , 'LETTERA AI MINISTRI STRAORDINARI DELLA COMUNIONE - 8964' , '7' , '-7' , '4' , '1.5000' , '1.5' , '0' , '0' , '10.50' ) 14/02/2023 09:51:12 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 ( '81337' , '5198' , 'IN TE MI RIFUGIO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 09:51:12 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 ( '81337' , '13503' , 'A BRACCIA APERTE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 09:51:12 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 ( '81337' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 14/02/2023 09:51:12 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 ( '81337' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 09:51:12 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 ( '81337' , '19921' , 'AGENDA 2023 - 40809' , '4' , '-4' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '28.00' ) 14/02/2023 09:51:12 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 ( '81337' , '15802' , 'VITA DI GESU CRISTO - MEDITAZIONI VANGELI - COF. 2 VOL. - 8937' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '0' , '24.00' ) 14/02/2023 09:51:12 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 ( '81337' , '18438' , 'MADONNA APPARE A LOURDES' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 09:51:12 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 ( '81337' , '18322' , 'BAMBINI AIUTATE IL MIO CUORE A VINCERE - 8106' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/02/2023 09:51:12 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 ( '81337' , '13996' , 'CORONA BIBLICA PER IL DONO DEI FIGLI - 8443' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 14/02/2023 09:51:12 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 ( '81337' , '16592' , 'CORONCINA PER LE ANIME DEI SACERDOTI... 8195' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/02/2023 09:51:12 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 ( '81337' , '2776' , 'CORONCINA E NOVENA AL PREZIOSISSIMO SANGUE' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/02/2023 09:51:12 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 ( '81337' , '10726' , 'TREDICINA A SANTANTONIO DI PADOVA' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 14/02/2023 09:51:12 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 ( '81337' , '8762' , 'QUINDICI GIOVEDÌ DI SANTA RITA - 8405' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 14/02/2023 09:51:12 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 ( '81337' , '11886' , 'NOVENA E CORONCINA A GESU BAMBINO DI PRAGA - 8365' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/02/2023 09:51:12 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 ( '81337' , '18320' , 'VANGELO DI LUCA - N. MARCONI - 8009' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 09:51:12 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 ( '81337' , '16444' , 'VANGELO DI MARCO - 8998' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 09:51:12 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 ( '81337' , '15579' , 'SONO RINATA - M. CALCAGNO - 8944' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/02/2023 09:51:12 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 ( '81337' , '18321' , 'IO ROSA - 8022' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/02/2023 09:51:12 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 ( '81337' , '18332' , 'NON LHO VISTO MA LHO INCONTRATO - D. CIPOLLONI - 8896' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 09:59:13 am >> SELECT document_num FROM ps_document WHERE document_num = '369' AND id_document != '81168' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-02') 14/02/2023 09:59:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '369', document_date = '2023-02-02', 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 = '33.13', price_tax_excluded = '33.13', date_upd = NOW() WHERE id_document = '81168' 14/02/2023 09:59: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 = '81168' 14/02/2023 09:59:14 am >> DELETE FROM ps_document_detail WHERE id_document = '81168' 14/02/2023 09:59: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 ( '81168' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 14/02/2023 09:59: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 ( '81168' , '13996' , 'CORONA BIBLICA PER IL DONO DEI FIGLI - 8443' , '1' , '-1' , '4' , '0.8' , '0.8' , '0' , '0' , '0.80' ) 14/02/2023 09:59: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 ( '81168' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 14/02/2023 09:59: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 ( '81168' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.46' ) 14/02/2023 09:59: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 ( '81168' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 14/02/2023 09:59: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 ( '81168' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.76' ) 14/02/2023 10:53:50 am >> SELECT document_num FROM ps_document WHERE document_num = '508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 10:53:50 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' , '508' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 14/02/2023 10:53:50 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 = '81348' 14/02/2023 10:53:50 am >> DELETE FROM ps_document_detail WHERE id_document = '81348' 14/02/2023 10:53:50 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 ( '81348' , '20718' , 'SPOSA BELLA - A. COMASTRI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 14/02/2023 10:55:08 am >> SELECT document_num FROM ps_document WHERE document_num = '509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 10:55: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' , '509' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 14/02/2023 10:55: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 = '81349' 14/02/2023 10:55:08 am >> DELETE FROM ps_document_detail WHERE id_document = '81349' 14/02/2023 10:55: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 ( '81349' , '4120' , 'FEDE NELLO ZAINETTO' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 14/02/2023 11:13:48 am >> SELECT document_num FROM ps_document WHERE document_num = '510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:13: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' , '510' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 14/02/2023 11:13: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 = '81350' 14/02/2023 11:13:48 am >> DELETE FROM ps_document_detail WHERE id_document = '81350' 14/02/2023 11:13: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 ( '81350' , '20160' , 'BRACCIALE IN CORDA E METALLO - 800/328' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 14/02/2023 11:13: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 ( '81350' , '18131' , 'TAU MEDIO CM3 - T6' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 14/02/2023 11:19:26 am >> SELECT document_num FROM ps_document WHERE document_num = '511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:19:26 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' , '511' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 14/02/2023 11:19:26 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 = '81351' 14/02/2023 11:19:26 am >> DELETE FROM ps_document_detail WHERE id_document = '81351' 14/02/2023 11:19:26 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 ( '81351' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '2' , '-2' , '4' , '20.00' , '20' , '0' , '5' , '38.00' ) 14/02/2023 11:26:42 am >> SELECT document_num FROM ps_document WHERE document_num = '512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:26:42 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' , '512' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.75' , '12.95' , NOW() , NOW() ) 14/02/2023 11:26:42 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 = '81352' 14/02/2023 11:26:42 am >> DELETE FROM ps_document_detail WHERE id_document = '81352' 14/02/2023 11:26:42 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 ( '81352' , '20026' , 'CANDELA VOTIVA 20X30' , '20' , '-20' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '10.00' ) 14/02/2023 11:26:42 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 ( '81352' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/02/2023 11:34:08 am >> SELECT document_num FROM ps_document WHERE document_num = '513' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:34: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' , '513' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 14/02/2023 11:34: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 = '81353' 14/02/2023 11:34:08 am >> DELETE FROM ps_document_detail WHERE id_document = '81353' 14/02/2023 11:34: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 ( '81353' , '19779' , 'ANELLO CROCE/CUORE' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 14/02/2023 11:34: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 ( '81353' , '19778' , 'ANELLO CROCE/S. RITA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 14/02/2023 11:36:21 am >> SELECT document_num FROM ps_document WHERE document_num = '514' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:36:21 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' , '514' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.40' , '67.88' , NOW() , NOW() ) 14/02/2023 11:36:21 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 = '81354' 14/02/2023 11:36:21 am >> DELETE FROM ps_document_detail WHERE id_document = '81354' 14/02/2023 11:36: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 ( '81354' , '11151' , 'LIBRI' , '9' , '-9' , '4' , '3.8' , '3.8' , '0' , '0' , '34.20' ) 14/02/2023 11:36: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 ( '81354' , '11151' , 'LIBRI' , '9' , '-9' , '4' , '2.3' , '2.3' , '0' , '0' , '20.70' ) 14/02/2023 11:36: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 ( '81354' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/02/2023 11:36: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 ( '81354' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/02/2023 11:36: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 ( '81354' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 14/02/2023 11:38:19 am >> SELECT document_num FROM ps_document WHERE document_num = '515' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:38: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' , '515' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 14/02/2023 11:38: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 = '81355' 14/02/2023 11:38:19 am >> DELETE FROM ps_document_detail WHERE id_document = '81355' 14/02/2023 11:38: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 ( '81355' , '12899' , 'LODE A TE, SIGNORE' , '19' , '-19' , '4' , '4' , '4' , '0' , '0' , '76.00' ) 14/02/2023 11:47:49 am >> SELECT document_num FROM ps_document WHERE document_num = '514' AND id_document != '81354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 11:47:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '514', document_date = '2023-02-14', 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 = '68.40', price_tax_excluded = '67.88', date_upd = NOW() WHERE id_document = '81354' 14/02/2023 11:47: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 = '81354' 14/02/2023 11:47:49 am >> DELETE FROM ps_document_detail WHERE id_document = '81354' 14/02/2023 11:47: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 ( '81354' , '11151' , 'LIBRI' , '9' , '-9' , '4' , '3.8000' , '3.8' , '0' , '0' , '34.20' ) 14/02/2023 11:47: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 ( '81354' , '11151' , 'LIBRI' , '9' , '-9' , '4' , '2.3000' , '2.3' , '0' , '0' , '20.70' ) 14/02/2023 11:47: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 ( '81354' , '20433' , 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/02/2023 11:47: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 ( '81354' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/02/2023 11:47: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 ( '81354' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 14/02/2023 11:58:13 am >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '81337' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-13') 14/02/2023 11:58:13 am >> UPDATE ps_document SET id_document_type = '24', document_num = '8', document_date = '2023-02-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = 'RESA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '85.00', price_tax_excluded = '79.95', date_upd = NOW() WHERE id_document = '81337' 14/02/2023 11:58: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 = '81337' 14/02/2023 11:58:13 am >> DELETE FROM ps_document_detail WHERE id_document = '81337' 14/02/2023 11:58: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 ( '81337' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 14/02/2023 11:58: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 ( '81337' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 11:58: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 ( '81337' , '19921' , 'AGENDA 2023 - 40809' , '4' , '-4' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '28.00' ) 14/02/2023 11:58: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 ( '81337' , '18438' , 'MADONNA APPARE A LOURDES' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 11:58: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 ( '81337' , '18322' , 'BAMBINI AIUTATE IL MIO CUORE A VINCERE - 8106' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/02/2023 11:58: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 ( '81337' , '18320' , 'VANGELO DI LUCA - N. MARCONI - 8009' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 11:58: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 ( '81337' , '18321' , 'IO ROSA - 8022' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/02/2023 11:58: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 ( '81337' , '18332' , 'NON LHO VISTO MA LHO INCONTRATO - D. CIPOLLONI - 8896' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 12:24:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '177' AND id_document != '79370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-17') 14/02/2023 12:24:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '177', document_date = '2023-01-17', 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 = '50.80', price_tax_excluded = '47.30', date_upd = NOW() WHERE id_document = '79370' 14/02/2023 12:24:09 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 = '79370' 14/02/2023 12:24:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '79370' 14/02/2023 12:24:09 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 ( '79370' , '20620' , 'OMELIE DI PENTLING' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 14/02/2023 12:24:09 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 ( '79370' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 14/02/2023 12:24:09 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 ( '79370' , '17784' , 'MEDAGLIA S. BENEDETTO MET. OX - Q 1010-OX' , '1' , '-1' , '1' , '16.9000' , '13.852459016393' , '22' , '0' , '16.90' ) 14/02/2023 12:24:09 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 ( '79370' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 14/02/2023 12:24:09 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 ( '79370' , '18942' , 'DI DOMENICA, UNA PAROLA - ANNO C - E. ABBATTISTA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/02/2023 12:24:09 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 ( '79370' , '15020' , 'PREGARE OGNI GIORNO' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '5' , '4.75' ) 14/02/2023 02:33:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 02:33:59 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 ( '24' , '9' , '2023-02-14' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , 'RESO A FORNITORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.30' , '159.30' , NOW() , NOW() ) 14/02/2023 02:33:59 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 = '81356' 14/02/2023 02:33:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '81356' 14/02/2023 02:33:59 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 ( '81356' , '17153' , 'SAN CHARBEL' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '0' , '7.50' ) 14/02/2023 02:33:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17153' AND id_supplier = '47' 14/02/2023 02:33:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17153' , '47' , '1' ) 14/02/2023 02:33:59 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 ( '81356' , '13578' , 'GRANDE CROCIATA DELLAMORE - C. RIVAS' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 14/02/2023 02:33:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13578' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13578' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '15799' , 'PAROLE DI LUCE E VITA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15799' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15799' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '4118' , 'FEDE INSEGNATA AI FIGLI - L. FANZAGA' , '1' , '-1' , '4' , '15.50' , '15.5' , '0' , '0' , '15.50' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4118' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4118' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '19165' , 'MESSAGGIO TEOLOGICO DI GUADALUPE - S. ALDAY' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19165' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19165' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '17968' , 'IO SONO LA MADRE DI GESU - M. STANZIONE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17968' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17968' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '3762' , 'ECCO TUA MADRE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3762' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3762' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '16266' , 'IPOTESI SU GESU - V. MESSORI' , '1' , '-1' , '4' , '16.80' , '16.8' , '0' , '0' , '16.80' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16266' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16266' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '13941' , 'SANTO VOLTO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13941' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13941' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '9595' , 'SANTA RITA - 15 MEDITAZIONI' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '0' , '7.50' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9595' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9595' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '16400' , 'LODE QUOTIDIANA A MARIA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '0' , '12.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16400' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16400' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '14545' , 'ROSARIO - M. DELBREL' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '0' , '18.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14545' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14545' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '13653' , 'LIBERACI DAL MALE - PREGHIERE DI LIBERAZIONE - VOL. 2' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13653' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13653' , '47' , '1' ) 14/02/2023 02:34:00 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 ( '81356' , '17558' , 'IN SINU JESU' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 14/02/2023 02:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17558' AND id_supplier = '47' 14/02/2023 02:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17558' , '47' , '1' ) 14/02/2023 02:51:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 02:51:24 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 ( '24' , '10' , '2023-02-14' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , 'RESO A FORNITORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '523.80' , '523.80' , NOW() , NOW() ) 14/02/2023 02:51:24 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 = '81357' 14/02/2023 02:51:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '81357' 14/02/2023 02:51:24 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 ( '81357' , '19764' , 'PRIMO PASSO - TACCUINO' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '0' , '10.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '15697' , 'RICCHEZZA DEL LIMITE - A. SCICCHITANO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15697' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15697' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '5834' , 'LIBRO DEL CELEBRANTE - VOL 1 SLUZHEBNIK' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5834' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5834' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '18466' , 'ETERNO ASSENTE SANTAGOSTINO - A. BISOGNO' , '2' , '-2' , '4' , '30.00' , '30' , '0' , '0' , '60.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18466' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18466' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '18505' , 'RITROVARE SE STESSI - C.M. MARTINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18505' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18505' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18043' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18043' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '19766' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19766' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19766' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '15525' , 'CASA DI CURIA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15525' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15525' , '109' , '1' ) 14/02/2023 02:51:24 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 ( '81357' , '20240' , 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 14/02/2023 02:51:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20240' AND id_supplier = '109' 14/02/2023 02:51:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20240' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '20241' , 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20241' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20241' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '20242' , 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20242' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20242' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '19380' , 'OGGETTO PREDICA' , '2' , '-2' , '4' , '16.00' , '16' , '0' , '0' , '32.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19380' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19380' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '13914' , 'BAMBINI A MESSA ANNO C - AAVV' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13914' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13914' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '16173' , 'FORTI NELLA FEDE - M. MARGAGLIOTTI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16173' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16173' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '16178' , 'NELLA PREDILEZIONE DI CRISTO - M.G. LEPORI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16178' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16178' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20590' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20590' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '19491' , 'IN DIALOGO CON IL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19491' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19491' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '20047' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20047' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20047' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '873' , 'AVE, SPERANZA NOSTRA - MADONNA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '873' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '873' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '6086' , 'MADRE DI MISERICORDIA - M.PAPPALARDO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6086' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6086' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '16049' , 'CINQUANTA GRANI DI CIELO -S. PROIETTI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16049' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16049' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8351' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8351' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '4774' , 'GRIDO DEL POVERO - M. MOSCA' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4774' AND id_supplier = '109' 14/02/2023 02:51:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4774' , '109' , '1' ) 14/02/2023 02:51:25 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 ( '81357' , '9099' , 'ROSARIO DELLA TENEREZZA - MADONNA' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 14/02/2023 02:51:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9099' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9099' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '19048' , 'CELIBATO E CONTINENZA ECCLESIALI - C. BONIVENTO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19048' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19048' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '18202' , 'COSTRUIRE UN MONDO NUOVO - AAVV' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18202' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18202' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '17595' , 'STATUTO AZIONE CATTOLICA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17595' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17595' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '6642' , 'MIA PRIMA COMUNIONE - M. IASEVOLI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6642' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6642' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14334' , 'VIVIAMO INSIEME IL VANGELO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14334' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14334' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14433' , 'VIVIAMO IL VANGELO - BATTESIMO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14433' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14433' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14432' , 'VIVIAMO IL VANGELO - ANNO 1 - FAMIGLIE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14432' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14432' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14335' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14335' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14335' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14429' , 'VIVIAMO IL VANGELO - ANNO 3 - FAMIGLIE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14429' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14429' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14337' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2 GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14337' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14337' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14338' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2 SCHEDE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/02/2023 02:51:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14338' AND id_supplier = '109' 14/02/2023 02:51:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14338' , '109' , '1' ) 14/02/2023 02:51:26 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 ( '81357' , '14340' , 'IO SONO CON VOI - QUADERNO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14340' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14340' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '14336' , 'VIVIAMO INSIEME IL VANGELO - ANNO 1 GUIDA' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14336' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14336' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '14431' , 'VIVIAMO IL VANGELO - ANNO 3 - GUIDA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14431' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14431' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '14430' , 'VIVIAMO IL VANGELO - ANNO 3 - SCHEDE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14430' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14430' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '14697' , 'CREDI AMA SPERA - A. GRAZIANI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14697' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14697' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '18467' , 'INNAMORARSI OGNI GIORNO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18467' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18467' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '0' , '12.50' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '0' , '12.50' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '0' , '10.50' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20051' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20051' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19767' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19767' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19761' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19761' , '109' , '1' ) 14/02/2023 02:51:27 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 ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 02:51:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19761' AND id_supplier = '109' 14/02/2023 02:51:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19761' , '109' , '1' ) 14/02/2023 02:51:28 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 ( '81357' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 02:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '109' 14/02/2023 02:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '109' , '1' ) 14/02/2023 02:51:28 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 ( '81357' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 02:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '109' 14/02/2023 02:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '109' , '1' ) 14/02/2023 02:51:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '81356' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 02:51:57 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '9', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = 'RESO A FORNITORE', 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 = '173.30', price_tax_excluded = '173.30', date_upd = NOW() WHERE id_document = '81356' 14/02/2023 02:51:57 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 = '81356' 14/02/2023 02:51:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '81356' 14/02/2023 02:51:57 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 ( '81356' , '17153' , 'SAN CHARBEL' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 14/02/2023 02:51:57 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 ( '81356' , '13578' , 'GRANDE CROCIATA DELLAMORE - C. RIVAS' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/02/2023 02:51:57 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 ( '81356' , '15799' , 'PAROLE DI LUCE E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:57 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 ( '81356' , '4118' , 'FEDE INSEGNATA AI FIGLI - L. FANZAGA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 14/02/2023 02:51:58 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 ( '81356' , '19165' , 'MESSAGGIO TEOLOGICO DI GUADALUPE - S. ALDAY' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 14/02/2023 02:51:58 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 ( '81356' , '17968' , 'IO SONO LA MADRE DI GESU - M. STANZIONE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/02/2023 02:51:58 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 ( '81356' , '3762' , 'ECCO TUA MADRE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:58 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 ( '81356' , '16266' , 'IPOTESI SU GESU - V. MESSORI' , '1' , '-1' , '4' , '16.8000' , '16.8' , '0' , '0' , '16.80' ) 14/02/2023 02:51:58 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 ( '81356' , '13941' , 'SANTO VOLTO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 02:51:58 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 ( '81356' , '9595' , 'SANTA RITA - 15 MEDITAZIONI' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 14/02/2023 02:51:58 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 ( '81356' , '16400' , 'LODE QUOTIDIANA A MARIA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 14/02/2023 02:51:58 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 ( '81356' , '14545' , 'ROSARIO - M. DELBREL' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '0' , '18.00' ) 14/02/2023 02:51:58 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 ( '81356' , '13653' , 'LIBERACI DAL MALE - PREGHIERE DI LIBERAZIONE - VOL. 2' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/02/2023 02:51:58 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 ( '81356' , '17558' , 'IN SINU JESU' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/02/2023 02:51:58 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 ( '81356' , '16399' , 'CONCERTO DI NATALE - S. CONTI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/02/2023 02:51:58 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 ( '81356' , '14544' , 'DIVENTARE AMICI DELLO SPIRITO SANTO - R. CANTALAMESSA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 14/02/2023 03:06:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '81357' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 03:06:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = 'RESO A FORNITORE', 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 = '432.30', price_tax_excluded = '432.30', date_upd = NOW() WHERE id_document = '81357' 14/02/2023 03:06:29 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 = '81357' 14/02/2023 03:06:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '81357' 14/02/2023 03:06:29 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 ( '81357' , '19764' , 'PRIMO PASSO - TACCUINO' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 14/02/2023 03:06:29 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 ( '81357' , '15697' , 'RICCHEZZA DEL LIMITE - A. SCICCHITANO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/02/2023 03:06:29 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 ( '81357' , '5834' , 'LIBRO DEL CELEBRANTE - VOL 1 SLUZHEBNIK' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 14/02/2023 03:06:29 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 ( '81357' , '18466' , 'ETERNO ASSENTE SANTAGOSTINO - A. BISOGNO' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 14/02/2023 03:06:29 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 ( '81357' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:06:29 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 ( '81357' , '19766' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 03:06:29 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 ( '81357' , '15525' , 'CASA DI CURIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/02/2023 03:06:29 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 ( '81357' , '20240' , 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/02/2023 03:06:29 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 ( '81357' , '20241' , 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/02/2023 03:06:29 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 ( '81357' , '20242' , 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/02/2023 03:06:29 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 ( '81357' , '19380' , 'OGGETTO PREDICA' , '2' , '-2' , '4' , '16.0000' , '16' , '0' , '0' , '32.00' ) 14/02/2023 03:06:29 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 ( '81357' , '13914' , 'BAMBINI A MESSA ANNO C - AAVV' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/02/2023 03:06:29 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 ( '81357' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/02/2023 03:06:29 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 ( '81357' , '19491' , 'IN DIALOGO CON IL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/02/2023 03:06:29 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 ( '81357' , '20047' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/02/2023 03:06:29 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 ( '81357' , '873' , 'AVE, SPERANZA NOSTRA - MADONNA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:06:29 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 ( '81357' , '6086' , 'MADRE DI MISERICORDIA - M.PAPPALARDO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 03:06:29 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 ( '81357' , '16049' , 'CINQUANTA GRANI DI CIELO -S. PROIETTI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 14/02/2023 03:06:29 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 ( '81357' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 03:06:29 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 ( '81357' , '4774' , 'GRIDO DEL POVERO - M. MOSCA' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/02/2023 03:06:30 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 ( '81357' , '9099' , 'ROSARIO DELLA TENEREZZA - MADONNA' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 14/02/2023 03:06:30 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 ( '81357' , '19048' , 'CELIBATO E CONTINENZA ECCLESIALI - C. BONIVENTO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/02/2023 03:06:30 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 ( '81357' , '18202' , 'COSTRUIRE UN MONDO NUOVO - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/02/2023 03:06:30 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 ( '81357' , '17595' , 'STATUTO AZIONE CATTOLICA' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 03:06:30 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 ( '81357' , '6642' , 'MIA PRIMA COMUNIONE - M. IASEVOLI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/02/2023 03:06:30 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 ( '81357' , '14334' , 'VIVIAMO INSIEME IL VANGELO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:06:30 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 ( '81357' , '14433' , 'VIVIAMO IL VANGELO - BATTESIMO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 03:06:30 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 ( '81357' , '14432' , 'VIVIAMO IL VANGELO - ANNO 1 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 14/02/2023 03:06:30 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 ( '81357' , '14335' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:06:30 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 ( '81357' , '14429' , 'VIVIAMO IL VANGELO - ANNO 3 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 14/02/2023 03:06:30 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 ( '81357' , '14340' , 'IO SONO CON VOI - QUADERNO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/02/2023 03:06:30 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 ( '81357' , '14697' , 'CREDI AMA SPERA - A. GRAZIANI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/02/2023 03:06:30 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 ( '81357' , '18467' , 'INNAMORARSI OGNI GIORNO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/02/2023 03:06:30 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 ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 14/02/2023 03:06:30 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 ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 14/02/2023 03:06:30 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 ( '81357' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 14/02/2023 03:06:30 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 ( '81357' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 03:06:30 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 ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:06:30 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 ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:06:30 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 ( '81357' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:06:30 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 ( '81357' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:32:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165297' AND id_product != '14340' AND ean13 != '' 14/02/2023 03:32:47 pm >> UPDATE ps_product SET id_supplier = '109', reference = '2/1', ean13 = '9788831165297', date_upd = NOW() WHERE id_product = '14340' 14/02/2023 03:32:47 pm >> UPDATE ps_product_lang SET name = 'IO SONO CON VOI - QUADERNO', description = '' WHERE id_product = '14340' 14/02/2023 03:32:47 pm >> UPDATE ps_product SET wholesale_price = '1.95', on_sale = '0', price = '3.9' WHERE id_product = '14340' 14/02/2023 03:32:47 pm >> UPDATE ps_product_shop SET wholesale_price = '1.95', price = '3.9', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14340' 14/02/2023 03:32:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '14340' 14/02/2023 03:33:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '81357' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 03:33:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = 'RESO A FORNITORE', 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 = '433.20', price_tax_excluded = '433.20', date_upd = NOW() WHERE id_document = '81357' 14/02/2023 03:33:03 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 = '81357' 14/02/2023 03:33:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '81357' 14/02/2023 03:33:03 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 ( '81357' , '19764' , 'PRIMO PASSO - TACCUINO' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 14/02/2023 03:33:03 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 ( '81357' , '15697' , 'RICCHEZZA DEL LIMITE - A. SCICCHITANO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/02/2023 03:33:03 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 ( '81357' , '5834' , 'LIBRO DEL CELEBRANTE - VOL 1 SLUZHEBNIK' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 14/02/2023 03:33:03 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 ( '81357' , '18466' , 'ETERNO ASSENTE SANTAGOSTINO - A. BISOGNO' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 14/02/2023 03:33:03 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 ( '81357' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:33:03 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 ( '81357' , '19766' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 03:33:03 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 ( '81357' , '15525' , 'CASA DI CURIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/02/2023 03:33:03 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 ( '81357' , '20240' , 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/02/2023 03:33:03 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 ( '81357' , '20241' , 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/02/2023 03:33:03 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 ( '81357' , '20242' , 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/02/2023 03:33:03 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 ( '81357' , '19380' , 'OGGETTO PREDICA' , '2' , '-2' , '4' , '16.0000' , '16' , '0' , '0' , '32.00' ) 14/02/2023 03:33:03 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 ( '81357' , '13914' , 'BAMBINI A MESSA ANNO C - AAVV' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/02/2023 03:33:03 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 ( '81357' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/02/2023 03:33:03 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 ( '81357' , '19491' , 'IN DIALOGO CON IL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/02/2023 03:33:04 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 ( '81357' , '20047' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/02/2023 03:33:04 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 ( '81357' , '873' , 'AVE, SPERANZA NOSTRA - MADONNA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:33:04 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 ( '81357' , '6086' , 'MADRE DI MISERICORDIA - M.PAPPALARDO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 03:33:04 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 ( '81357' , '16049' , 'CINQUANTA GRANI DI CIELO -S. PROIETTI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 14/02/2023 03:33:04 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 ( '81357' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 03:33:04 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 ( '81357' , '4774' , 'GRIDO DEL POVERO - M. MOSCA' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/02/2023 03:33:04 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 ( '81357' , '9099' , 'ROSARIO DELLA TENEREZZA - MADONNA' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 14/02/2023 03:33:04 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 ( '81357' , '19048' , 'CELIBATO E CONTINENZA ECCLESIALI - C. BONIVENTO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/02/2023 03:33:04 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 ( '81357' , '18202' , 'COSTRUIRE UN MONDO NUOVO - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/02/2023 03:33:04 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 ( '81357' , '17595' , 'STATUTO AZIONE CATTOLICA' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 03:33:04 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 ( '81357' , '6642' , 'MIA PRIMA COMUNIONE - M. IASEVOLI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/02/2023 03:33:04 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 ( '81357' , '14334' , 'VIVIAMO INSIEME IL VANGELO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:33:04 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 ( '81357' , '14433' , 'VIVIAMO IL VANGELO - BATTESIMO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/02/2023 03:33:04 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 ( '81357' , '14432' , 'VIVIAMO IL VANGELO - ANNO 1 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 14/02/2023 03:33:04 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 ( '81357' , '14335' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/02/2023 03:33:04 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 ( '81357' , '14429' , 'VIVIAMO IL VANGELO - ANNO 3 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 14/02/2023 03:33:04 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 ( '81357' , '14340' , 'IO SONO CON VOI - QUADERNO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 14/02/2023 03:33:04 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 ( '81357' , '14697' , 'CREDI AMA SPERA - A. GRAZIANI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/02/2023 03:33:04 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 ( '81357' , '18467' , 'INNAMORARSI OGNI GIORNO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/02/2023 03:33:04 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 ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 14/02/2023 03:33:04 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 ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 14/02/2023 03:33:04 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 ( '81357' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 14/02/2023 03:33:04 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 ( '81357' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/02/2023 03:33:04 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 ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:33:04 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 ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:33:04 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 ( '81357' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 03:33:04 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 ( '81357' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 14/02/2023 04:08:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 04:08:17 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' , '8' , '2023-02-14' , '' , '3329' , '0' , '4669752' , 'Via Tivoli , 90 70022 ALTAMURA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '149.90' , '149.90' , NOW() , NOW() ) 14/02/2023 04:08:17 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 = '10793' 14/02/2023 04:08:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '10793' 14/02/2023 04:08:17 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 ( '10793' , '125' , 'MIE PREGHIERINE - N. E.' , '100' , '-100' , '4' , '1.43' , '1.43' , '0' , '0' , '143.00' ) 14/02/2023 04:08:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 04:08: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' , '516' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '53.57' , NOW() , NOW() ) 14/02/2023 04:08: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 = '81358' 14/02/2023 04:08:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '81358' 14/02/2023 04:08: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 ( '81358' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '30' , '-30' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 14/02/2023 04:08: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 ( '81358' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/02/2023 04:08:57 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 ( '81358' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 14/02/2023 04:11:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '517' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 04:11:11 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' , '517' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 14/02/2023 04:11:11 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 = '81359' 14/02/2023 04:11:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '81359' 14/02/2023 04:11:11 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 ( '81359' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/02/2023 04:11:11 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 ( '81359' , '20742' , 'ALLA FINESTRA LA SPERANZA - T. BELLO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 14/02/2023 04:23:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825037364' AND id_product != '1160' AND ean13 != '' 14/02/2023 04:23:06 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/2', ean13 = '9788825037364', date_upd = NOW() WHERE id_product = '1160' 14/02/2023 04:23:06 pm >> UPDATE ps_product_lang SET name = 'BIBBIA FRANCESCANA', description = '' WHERE id_product = '1160' 14/02/2023 04:23:06 pm >> UPDATE ps_product SET wholesale_price = '20.30', on_sale = '0', price = '29.0000' WHERE id_product = '1160' 14/02/2023 04:23:06 pm >> UPDATE ps_product_shop SET wholesale_price = '20.30', price = '29.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1160' 14/02/2023 04:23:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '1160' 14/02/2023 04:23:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810607220' AND id_product != '11406' AND ean13 != '' 14/02/2023 04:23:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/1', ean13 = '9788810607220', date_upd = NOW() WHERE id_product = '11406' 14/02/2023 04:23:59 pm >> UPDATE ps_product_lang SET name = 'VISITARE E RIESPRIMERE IL DOCUMENTO DI BASE', description = '' WHERE id_product = '11406' 14/02/2023 04:23:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.8000' WHERE id_product = '11406' 14/02/2023 04:23:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.8000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '22', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11406' 14/02/2023 04:23:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '11406' 14/02/2023 04:29:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '518' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 04:29:00 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' , '518' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.50' , '25.82' , NOW() , NOW() ) 14/02/2023 04:29:00 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 = '81360' 14/02/2023 04:29:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81360' 14/02/2023 04:29:00 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 ( '81360' , '17617' , 'IMMAGINI ISONZO X 100' , '9' , '-9' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '31.50' ) 14/02/2023 04:40:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983485' AND id_product != '19545' AND ean13 != '' 14/02/2023 04:40:59 pm >> UPDATE ps_product SET id_supplier = '7', reference = '1/3', ean13 = '9788872983485', date_upd = NOW() WHERE id_product = '19545' 14/02/2023 04:40:59 pm >> UPDATE ps_product_lang SET name = 'SANTA MESSA - 100 DOMANDE...', description = '' WHERE id_product = '19545' 14/02/2023 04:40:59 pm >> UPDATE ps_product SET wholesale_price = '5.60', on_sale = '0', price = '8.0000' WHERE id_product = '19545' 14/02/2023 04:40:59 pm >> UPDATE ps_product_shop SET wholesale_price = '5.60', price = '8.0000', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19545' 14/02/2023 04:41:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '19545' 14/02/2023 04:51:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 04:51:15 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' , '519' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 14/02/2023 04:51:15 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 = '81361' 14/02/2023 04:51:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '81361' 14/02/2023 04:51:15 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 ( '81361' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 14/02/2023 04:56:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226173' AND id_product != '18544' AND ean13 != '' 14/02/2023 04:56:17 pm >> UPDATE ps_product SET id_supplier = '7', reference = '1/4', ean13 = '9788892226173', date_upd = NOW() WHERE id_product = '18544' 14/02/2023 04:56:17 pm >> UPDATE ps_product_lang SET name = 'IN CAMMINO CON CHIARA E FRANCESCO ', description = '' WHERE id_product = '18544' 14/02/2023 04:56:17 pm >> UPDATE ps_product SET wholesale_price = '13.40', on_sale = '0', price = '20.0000' WHERE id_product = '18544' 14/02/2023 04:56:17 pm >> UPDATE ps_product_shop SET wholesale_price = '13.40', price = '20.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18544' 14/02/2023 04:56:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '18544' 14/02/2023 05:04:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 05:05:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 14/02/2023 05:05:19 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' , '520' , '2023-02-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 14/02/2023 05:05:19 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 = '81362' 14/02/2023 05:05:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '81362' 14/02/2023 05:05:19 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 ( '81362' , '19326' , 'SUL DOLORE - P. CURTAZ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' )