03/08/2022 09:49:31 am >> UPDATE ps_document SET id_document_type = '33', document_num = '211560', document_date = '2022-07-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '182.50', price_tax_excluded = '182.50', date_upd = NOW() WHERE id_document = '59824' 03/08/2022 09:49:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59824' 03/08/2022 09:49:31 am >> DELETE FROM ps_document_detail WHERE id_document = '59824' 03/08/2022 09:49:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19825' , '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 03/08/2022 09:49:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19825' AND id_supplier = '' 03/08/2022 09:49:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19825' , '' , '1' ) 03/08/2022 09:49:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19822' , 'CRISTIANESIMO COME FORMA DI VITA' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19822' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19822' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '2' , '2' , '4' , '15.9000' , '15.9' , '0' , '0' , '31.80' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '19828' , 'CHIESA SINODALE NELLOGGI' , '2' , '2' , '4' , '15.9000' , '15.9' , '0' , '0' , '31.80' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19826' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19826' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '15970' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15970' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '19823' , 'PAOLO INTERPRETE INTERPRETATO' , '1' , '1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19823' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19823' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '19381' , 'SINODALITA' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19381' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19381' , '' , '1' ) 03/08/2022 09:49:32 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 ( '59824' , '19380' , 'OGGETTO PREDICA' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 03/08/2022 09:49:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19380' AND id_supplier = '' 03/08/2022 09:49:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19380' , '' , '1' ) 03/08/2022 10:00:23 am >> UPDATE ps_document SET id_document_type = '33', document_num = '211560', document_date = '2022-07-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '150.70', price_tax_excluded = '150.70', date_upd = NOW() WHERE id_document = '59824' 03/08/2022 10:00:23 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 = '59824' 03/08/2022 10:00:23 am >> DELETE FROM ps_document_detail WHERE id_document = '59824' 03/08/2022 10:00:23 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 ( '59824' , '19825' , '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 03/08/2022 10:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19825' AND id_supplier = '' 03/08/2022 10:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19825' , '' , '1' ) 03/08/2022 10:00:23 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 ( '59824' , '19822' , 'CRISTIANESIMO COME FORMA DI VITA' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 03/08/2022 10:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19822' AND id_supplier = '' 03/08/2022 10:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19822' , '' , '1' ) 03/08/2022 10:00:23 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 ( '59824' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '1' , '1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.9000' ) 03/08/2022 10:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '' 03/08/2022 10:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '' , '1' ) 03/08/2022 10:00:23 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 ( '59824' , '19828' , 'CHIESA SINODALE NELLOGGI' , '1' , '1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.9000' ) 03/08/2022 10:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '' 03/08/2022 10:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '' , '1' ) 03/08/2022 10:00:23 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 ( '59824' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 03/08/2022 10:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19826' AND id_supplier = '' 03/08/2022 10:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19826' , '' , '1' ) 03/08/2022 10:00:23 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 ( '59824' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 03/08/2022 10:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '15970' AND id_supplier = '' 03/08/2022 10:00:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15970' , '' , '1' ) 03/08/2022 10:00:24 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 ( '59824' , '19823' , 'PAOLO INTERPRETE INTERPRETATO' , '1' , '1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 03/08/2022 10:00:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19823' AND id_supplier = '' 03/08/2022 10:00:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19823' , '' , '1' ) 03/08/2022 10:00:24 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 ( '59824' , '19381' , 'SINODALITA' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 03/08/2022 10:00:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19381' AND id_supplier = '' 03/08/2022 10:00:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19381' , '' , '1' ) 03/08/2022 10:00:24 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 ( '59824' , '19380' , 'OGGETTO PREDICA' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 03/08/2022 10:00:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19380' AND id_supplier = '' 03/08/2022 10:00:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19380' , '' , '1' ) 03/08/2022 10:04:54 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 ( '32' , '6022279379' , '2022-07-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '161.24' , '161.24' , NOW() , NOW() ) 03/08/2022 10:04:54 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 = '59898' 03/08/2022 10:04:54 am >> DELETE FROM ps_document_detail WHERE id_document = '59898' 03/08/2022 10:04:54 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 ( '59898' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '1' , '0' , '4' , '10.66' , '10.66' , '0' , '0' , '10.6600' ) 03/08/2022 10:04:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '109' 03/08/2022 10:04:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '109' , '1' ) 03/08/2022 10:04:54 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 ( '59898' , '19828' , 'CHIESA SINODALE NELL\'OGGI' , '1' , '0' , '4' , '10.66' , '10.66' , '0' , '0' , '10.6600' ) 03/08/2022 10:04:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '109' 03/08/2022 10:04:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '109' , '1' ) 03/08/2022 10:04:54 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 ( '59898' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '0' , '4' , '10.66' , '10.66' , '0' , '0' , '10.6600' ) 03/08/2022 10:04:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19826' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19826' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19763' , 'FATTI DI VOCE ' , '1' , '0' , '4' , '7.91' , '7.91' , '0' , '0' , '7.9100' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19763' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19763' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19764' , 'PRIMO PASSO - TACCUINO' , '1' , '0' , '4' , '3.6' , '3.6' , '0' , '0' , '3.6000' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '0' , '4' , '9' , '9' , '0' , '0' , '9.0000' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '0' , '4' , '8.28' , '8.28' , '0' , '0' , '8.2800' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '0' , '4' , '11.88' , '11.88' , '0' , '0' , '11.8800' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19761' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19761' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '0' , '4' , '11.88' , '11.88' , '0' , '0' , '11.8800' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '0' , '4' , '11.88' , '11.88' , '0' , '0' , '11.8800' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '0' , '4' , '11.88' , '11.88' , '0' , '0' , '11.8800' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19766' , 'WORK IN PROGRESS' , '1' , '0' , '4' , '5.04' , '5.04' , '0' , '0' , '5.0400' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19766' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19766' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '0' , '4' , '5.04' , '5.04' , '0' , '0' , '5.0400' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19767' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19767' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19836' , 'MISTERO MISTAGOGIA MISTICA - Y DE ANDIA' , '1' , '0' , '4' , '20.09' , '20.09' , '0' , '0' , '20.0900' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19836' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19836' , '109' , '1' ) 03/08/2022 10:04:55 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 ( '59898' , '19838' , 'NATUZZA EVOLO E LALDILA - V. MARINELLI' , '1' , '0' , '4' , '12.06' , '12.06' , '0' , '0' , '12.0600' ) 03/08/2022 10:04:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19838' AND id_supplier = '109' 03/08/2022 10:04:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19838' , '109' , '1' ) 03/08/2022 10:04:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59898' , '19839' , 'SAN GIOVANNI DELLA CROCE - M. TONDO' , '1' , '0' , '4' , '10.72' , '10.72' , '0' , '0' , '10.7200' ) 03/08/2022 10:04:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19839' AND id_supplier = '109' 03/08/2022 10:04:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19839' , '109' , '1' ) 03/08/2022 10:07:18 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 ( '32' , '6022279382' , '2022-07-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '20.56' , '20.56' , NOW() , NOW() ) 03/08/2022 10:07:18 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 = '59899' 03/08/2022 10:07:18 am >> DELETE FROM ps_document_detail WHERE id_document = '59899' 03/08/2022 10:07:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59899' , '19380' , 'OGGETTO PREDICA' , '1' , '0' , '4' , '10.72' , '10.72' , '0' , '0' , '10.7200' ) 03/08/2022 10:07:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19380' AND id_supplier = '109' 03/08/2022 10:07:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19380' , '109' , '1' ) 03/08/2022 10:07:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59899' , '19381' , 'SINODALITA' , '1' , '0' , '4' , '9.84' , '9.84' , '0' , '0' , '9.8400' ) 03/08/2022 10:07:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19381' AND id_supplier = '109' 03/08/2022 10:07:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19381' , '109' , '1' ) 03/08/2022 10:25:30 am >> UPDATE ps_document SET id_document_type = '33', document_num = '211560', document_date = '2022-07-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '182.50', price_tax_excluded = '182.50', date_upd = NOW() WHERE id_document = '59824' 03/08/2022 10:25:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59824' 03/08/2022 10:25:30 am >> DELETE FROM ps_document_detail WHERE id_document = '59824' 03/08/2022 10:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19825' , '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 03/08/2022 10:25:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19825' AND id_supplier = '' 03/08/2022 10:25:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19825' , '' , '1' ) 03/08/2022 10:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19822' , 'CRISTIANESIMO COME FORMA DI VITA' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 03/08/2022 10:25:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19822' AND id_supplier = '' 03/08/2022 10:25:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19822' , '' , '1' ) 03/08/2022 10:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '2' , '2' , '4' , '15.9000' , '15.9' , '0' , '0' , '31.8000' ) 03/08/2022 10:25:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '' 03/08/2022 10:25:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '' , '1' ) 03/08/2022 10:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19828' , 'CHIESA SINODALE NELLOGGI' , '2' , '2' , '4' , '15.9000' , '15.9' , '0' , '0' , '31.8000' ) 03/08/2022 10:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '' 03/08/2022 10:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '' , '1' ) 03/08/2022 10:25:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 03/08/2022 10:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19826' AND id_supplier = '' 03/08/2022 10:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19826' , '' , '1' ) 03/08/2022 10:25:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 03/08/2022 10:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '15970' AND id_supplier = '' 03/08/2022 10:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15970' , '' , '1' ) 03/08/2022 10:25:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19823' , 'PAOLO INTERPRETE INTERPRETATO' , '1' , '1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 03/08/2022 10:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19823' AND id_supplier = '' 03/08/2022 10:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19823' , '' , '1' ) 03/08/2022 10:25:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19381' , 'SINODALITA' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 03/08/2022 10:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19381' AND id_supplier = '' 03/08/2022 10:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19381' , '' , '1' ) 03/08/2022 10:25:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19380' , 'OGGETTO PREDICA' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 03/08/2022 10:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19380' AND id_supplier = '' 03/08/2022 10:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19380' , '' , '1' ) 03/08/2022 10:28:53 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 ( '32' , '6022279381' , '2022-07-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '79.56' , '79.56' , NOW() , NOW() ) 03/08/2022 10:28:53 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 = '59900' 03/08/2022 10:28:53 am >> DELETE FROM ps_document_detail WHERE id_document = '59900' 03/08/2022 10:28:53 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 ( '59900' , '19828' , 'CHIESA SINODALE NELLOGGI' , '1' , '0' , '4' , '11.45' , '11.45' , '0' , '0' , '11.4500' ) 03/08/2022 10:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '109' 03/08/2022 10:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '109' , '1' ) 03/08/2022 10:28:53 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 ( '59900' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '0' , '4' , '12.23' , '12.23' , '0' , '0' , '12.2300' ) 03/08/2022 10:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '15970' AND id_supplier = '109' 03/08/2022 10:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15970' , '109' , '1' ) 03/08/2022 10:28:53 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 ( '59900' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '1' , '0' , '4' , '11.45' , '11.45' , '0' , '0' , '11.4500' ) 03/08/2022 10:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '109' 03/08/2022 10:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '109' , '1' ) 03/08/2022 10:28:53 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 ( '59900' , '19825' , '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI' , '1' , '0' , '4' , '16.09' , '16.09' , '0' , '0' , '16.0900' ) 03/08/2022 10:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19825' AND id_supplier = '109' 03/08/2022 10:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19825' , '109' , '1' ) 03/08/2022 10:28:53 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 ( '59900' , '19822' , 'CRISTIANESIMO COME FORMA DI VITA' , '1' , '0' , '4' , '10.97' , '10.97' , '0' , '0' , '10.9700' ) 03/08/2022 10:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19822' AND id_supplier = '109' 03/08/2022 10:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19822' , '109' , '1' ) 03/08/2022 10:28:53 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 ( '59900' , '19835' , 'CHIESA SINODALE' , '1' , '0' , '4' , '17.37' , '17.37' , '0' , '0' , '17.3700' ) 03/08/2022 10:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19835' AND id_supplier = '109' 03/08/2022 10:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19835' , '109' , '1' ) 03/08/2022 10:30:58 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 ( '32' , '6022279380' , '2022-07-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '54.80' , '54.80' , NOW() , NOW() ) 03/08/2022 10:30:58 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 = '59901' 03/08/2022 10:30:58 am >> DELETE FROM ps_document_detail WHERE id_document = '59901' 03/08/2022 10:30:58 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 ( '59901' , '19823' , 'PAOLO INTERPRETE INTERPRETATO' , '1' , '0' , '4' , '12.73' , '12.73' , '0' , '0' , '12.7300' ) 03/08/2022 10:30:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19823' AND id_supplier = '109' 03/08/2022 10:30:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19823' , '109' , '1' ) 03/08/2022 10:30:58 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 ( '59901' , '19768' , 'LAVORO 4.0' , '2' , '0' , '4' , '8.64' , '8.64' , '0' , '0' , '17.2800' ) 03/08/2022 10:30:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19768' AND id_supplier = '109' 03/08/2022 10:30:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19768' , '109' , '1' ) 03/08/2022 10:30:58 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 ( '59901' , '19837' , 'ABBANDONATEVI A CRISTO - F. SHEEN' , '1' , '0' , '4' , '16.75' , '16.75' , '0' , '0' , '16.7500' ) 03/08/2022 10:30:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19837' AND id_supplier = '109' 03/08/2022 10:30:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19837' , '109' , '1' ) 03/08/2022 10:30:58 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 ( '59901' , '19840' , 'PERLE DI DON DOLINDO' , '1' , '0' , '4' , '8.04' , '8.04' , '0' , '0' , '8.0400' ) 03/08/2022 10:30:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19840' AND id_supplier = '109' 03/08/2022 10:30:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19840' , '109' , '1' ) 03/08/2022 10:44:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 10:44:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2432' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 03/08/2022 10:44:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59902' 03/08/2022 10:44:17 am >> DELETE FROM ps_document_detail WHERE id_document = '59902' 03/08/2022 10:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59902' , '14064' , 'STELLARIO PLEX CM 16' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 03/08/2022 10:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '14064' AND id_supplier = '' 03/08/2022 10:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14064' , '' , '1' ) 03/08/2022 10:55:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2433' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 10:55:34 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' , '2433' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.62' , '30.62' , NOW() , NOW() ) 03/08/2022 10:55:34 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 = '59903' 03/08/2022 10:55:34 am >> DELETE FROM ps_document_detail WHERE id_document = '59903' 03/08/2022 10:55:34 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 ( '59903' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '19.5' , '19.5' , '0' , '0' , '19.50' ) 03/08/2022 10:55:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 03/08/2022 10:55:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 03/08/2022 10:55:34 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 ( '59903' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/08/2022 10:55:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 03/08/2022 10:55:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 03/08/2022 10:55:34 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 ( '59903' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/08/2022 10:55:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 03/08/2022 10:55:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 03/08/2022 10:55:35 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 ( '59903' , '529' , 'AMORIS LAETITIA' , '3' , '-3' , '4' , '2.20' , '2.2' , '0' , '5' , '6.27' ) 03/08/2022 10:55:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '' 03/08/2022 10:55:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '' , '1' ) 03/08/2022 10:56:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2434' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 10:56:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2434' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '16.80' , NOW() , NOW() ) 03/08/2022 10:56:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59904' 03/08/2022 10:56:17 am >> DELETE FROM ps_document_detail WHERE id_document = '59904' 03/08/2022 10:56:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59904' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.03' , '0.03' , '0' , '0' , '16.80' ) 03/08/2022 10:56:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 03/08/2022 10:56:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 03/08/2022 11:37:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2435' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 11:37:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2435' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.80' , '102.88' , NOW() , NOW() ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59905' 03/08/2022 11:37:43 am >> DELETE FROM ps_document_detail WHERE id_document = '59905' 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '18934' , 'SPOSI, PROFETI DELLAMORE - DE ROSA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18934' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18934' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '19682' , 'IDENTITA SESSUALE - C. CORBELLA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19682' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19682' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '15580' , 'CHRISTUS VIVIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '15580' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15580' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '15902' , 'MASCHIO E FEMMINA LI CREO' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '15902' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15902' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '17377' , 'SAMARITANUS BONUS' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '17377' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17377' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '19743' , 'CE POSTO PER TUTTI - A. RUCCIA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19743' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19743' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '19566' , 'FAMIGLIA AMORIS LAETITIA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18884' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18884' , '' , '1' ) 03/08/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59905' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 03/08/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/08/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/08/2022 11:51:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2436' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 11:51:16 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' , '2436' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 03/08/2022 11:51:16 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 = '59906' 03/08/2022 11:51:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59906' 03/08/2022 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59906' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/08/2022 11:51:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 03/08/2022 11:51:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 03/08/2022 11:55:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2437' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 11:55:10 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' , '2437' , '2022-08-03' , '' , '' , '' , '' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.70' , '81.36' , NOW() , NOW() ) 03/08/2022 11:55:10 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 = '59907' 03/08/2022 11:55:10 am >> DELETE FROM ps_document_detail WHERE id_document = '59907' 03/08/2022 11:55:10 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 ( '59907' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3654' , '4' , '0' , '21.00' ) 03/08/2022 11:55:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 03/08/2022 11:55:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 03/08/2022 11:55:10 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 ( '59907' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269' , '4' , '0' , '9.50' ) 03/08/2022 11:55:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/08/2022 11:55:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/08/2022 11:55:10 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 ( '59907' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8462' , '4' , '0' , '4.00' ) 03/08/2022 11:55:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 03/08/2022 11:55:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 03/08/2022 11:55:10 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 ( '59907' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.0300' , '0.03' , '0' , '0' , '7.20' ) 03/08/2022 11:55:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 03/08/2022 11:55:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 03/08/2022 11:55:10 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 ( '59907' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0492' , '22' , '0' , '50.00' ) 03/08/2022 11:55:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 03/08/2022 11:55:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 03/08/2022 11:56:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2438' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 11:56:16 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' , '2438' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 03/08/2022 11:56:16 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 = '59908' 03/08/2022 11:56:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59908' 03/08/2022 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59908' , '14725' , 'STOLA LANA/SETA/VISC. - ART. 1125' , '2' , '-2' , '1' , '125' , '102.45901639344' , '22' , '0' , '250.00' ) 03/08/2022 11:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '14725' AND id_supplier = '' 03/08/2022 11:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14725' , '' , '1' ) 03/08/2022 11:57:08 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '59751' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-21') 03/08/2022 11:57:08 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2022-07-21', document_letter = 'A', id_customer = '3030', id_supplier = '', id_address = '4671709', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO', 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 = '250.00', price_tax_excluded = '204.92', date_upd = NOW() WHERE id_document = '59751' 03/08/2022 11:57: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 = '59751' 03/08/2022 11:57:08 am >> DELETE FROM ps_document_detail WHERE id_document = '59751' 03/08/2022 11:57: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 ( '59751' , '14725' , 'STOLA LANA/SETA/VISC. - ART. 1125' , '2' , '-2' , '1' , '125.0000' , '102.45901639344' , '22' , '0' , '250.00' ) 03/08/2022 11:57:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '14725' AND id_supplier = '' 03/08/2022 11:57:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14725' , '' , '1' ) 03/08/2022 12:20:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 12:20:36 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' , '38' , '2022-08-03' , '' , '3381' , '0' , '4670127' , 'VIA BONAVENTURA, 13 07026 OLBIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 03/08/2022 12:20:36 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 = '5389' 03/08/2022 12:20:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '5389' 03/08/2022 12:20:36 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 ( '5389' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 03/08/2022 12:34:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '39' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 12:34:03 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' , '39' , '2022-08-03' , '' , '3463' , '0' , '4670120' , 'VIA MARCO AURELIO 81 80126 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 03/08/2022 12:34: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 = '5390' 03/08/2022 12:34:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '5390' 03/08/2022 12:34: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 ( '5390' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 03/08/2022 02:54:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001322' AND id_product != '16456' AND ean13 != '' 03/08/2022 02:54:27 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '001322', date_upd = NOW() WHERE id_product = '16456' 03/08/2022 02:54:27 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING03', description = '' WHERE id_product = '16456' 03/08/2022 02:54:27 pm >> UPDATE ps_product SET wholesale_price = '5.34', on_sale = '0', price = '11.475409836065573' WHERE id_product = '16456' 03/08/2022 02:54:27 pm >> UPDATE ps_product_shop SET wholesale_price = '5.34', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16456' 03/08/2022 02:54:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '16456' 03/08/2022 02:55:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'CING08ORO' AND id_product != '14114' AND ean13 != '' 03/08/2022 02:55:32 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'CING08ORO', date_upd = NOW() WHERE id_product = '14114' 03/08/2022 02:55:32 pm >> UPDATE ps_product_lang SET name = 'CINGOLO ORO - CING08ORO', description = '' WHERE id_product = '14114' 03/08/2022 02:55:32 pm >> UPDATE ps_product SET wholesale_price = '12.22', on_sale = '0', price = '27.868852459016395' WHERE id_product = '14114' 03/08/2022 02:55:32 pm >> UPDATE ps_product_shop SET wholesale_price = '12.22', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14114' 03/08/2022 02:55:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '14114' 03/08/2022 02:56:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000847' AND id_product != '14114' AND ean13 != '' 03/08/2022 02:56:25 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '000847', date_upd = NOW() WHERE id_product = '14114' 03/08/2022 02:56:25 pm >> UPDATE ps_product_lang SET name = 'CINGOLO ORO - CING08ORO', description = '' WHERE id_product = '14114' 03/08/2022 02:56:25 pm >> UPDATE ps_product SET wholesale_price = '12.22', on_sale = '0', price = '27.8689' WHERE id_product = '14114' 03/08/2022 02:56:25 pm >> UPDATE ps_product_shop SET wholesale_price = '12.22', price = '27.8689', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14114' 03/08/2022 02:56:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '14114' 03/08/2022 02:58:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000848' AND id_product != '15893' AND ean13 != '' 03/08/2022 02:58:02 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '000848', date_upd = NOW() WHERE id_product = '15893' 03/08/2022 02:58:02 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING17', description = '' WHERE id_product = '15893' 03/08/2022 02:58:02 pm >> UPDATE ps_product SET wholesale_price = '18.33', on_sale = '0', price = '39.3443' WHERE id_product = '15893' 03/08/2022 02:58:02 pm >> UPDATE ps_product_shop SET wholesale_price = '18.33', price = '39.3443', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15893' 03/08/2022 02:58:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '15893' 03/08/2022 02:59:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000849' AND id_product != '17533' AND ean13 != '' 03/08/2022 02:59:45 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '000849', date_upd = NOW() WHERE id_product = '17533' 03/08/2022 02:59:45 pm >> UPDATE ps_product_lang SET name = 'CINGOLO ORO/COL - CING06', description = '' WHERE id_product = '17533' 03/08/2022 02:59:45 pm >> UPDATE ps_product SET wholesale_price = '7.33', on_sale = '0', price = '15.573770491803279' WHERE id_product = '17533' 03/08/2022 02:59:45 pm >> UPDATE ps_product_shop SET wholesale_price = '7.33', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17533' 03/08/2022 02:59:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '17533' 03/08/2022 03:02:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000850' AND id_product != '14021' AND ean13 != '' 03/08/2022 03:02:28 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '000850', date_upd = NOW() WHERE id_product = '14021' 03/08/2022 03:02:28 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING08', description = '' WHERE id_product = '14021' 03/08/2022 03:02:28 pm >> UPDATE ps_product SET wholesale_price = '9.17', on_sale = '0', price = '21.311475409836067' WHERE id_product = '14021' 03/08/2022 03:02:28 pm >> UPDATE ps_product_shop SET wholesale_price = '9.17', price = '21.311475409836067', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14021' 03/08/2022 03:02:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '14021' 03/08/2022 03:03:15 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 03/08/2022 03:03:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19857' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:03:15 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19857' , '1' , '1' , '2' , NOW() , NOW() ) 03/08/2022 03:03:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19857' , '0' , '1' , '0' , '0' ) 03/08/2022 03:06:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000852' AND id_product != '19857' AND ean13 != '' 03/08/2022 03:06:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000852', date_upd = NOW() WHERE id_product = '19857' 03/08/2022 03:06:20 pm >> UPDATE ps_product_lang SET name = 'cingolo col/oro - cing21', description = '' WHERE id_product = '19857' 03/08/2022 03:06:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19857' 03/08/2022 03:06:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19857' 03/08/2022 03:06:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '19857' 03/08/2022 03:07:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000852' AND id_product != '19857' AND ean13 != '' 03/08/2022 03:07:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000852', date_upd = NOW() WHERE id_product = '19857' 03/08/2022 03:07:00 pm >> UPDATE ps_product_lang SET name = 'CINGOLO COL/ORO - CING 21', description = '' WHERE id_product = '19857' 03/08/2022 03:07:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.4918' WHERE id_product = '19857' 03/08/2022 03:07:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.4918', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19857' 03/08/2022 03:07:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '19857' 03/08/2022 03:07:01 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19857' 03/08/2022 03:07:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19858' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:07:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19858' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19857' 03/08/2022 03:07:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19858' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19857' 03/08/2022 03:07:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000852' AND id_product != '19857' AND ean13 != '' 03/08/2022 03:07:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000852', date_upd = NOW() WHERE id_product = '19857' 03/08/2022 03:07:56 pm >> UPDATE ps_product_lang SET name = 'CINGOLO COL/ORO - CING 21', description = '' WHERE id_product = '19857' 03/08/2022 03:07:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.4918' WHERE id_product = '19857' 03/08/2022 03:07:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.4918', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19857' 03/08/2022 03:07:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '19857' 03/08/2022 03:07:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19857' 03/08/2022 03:07:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19859' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:07:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19859' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19857' 03/08/2022 03:07:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19859' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19857' 03/08/2022 03:08:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000854' AND id_product != '19859' AND ean13 != '' 03/08/2022 03:08:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000854', date_upd = NOW() WHERE id_product = '19859' 03/08/2022 03:08:47 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING 29', description = '' WHERE id_product = '19859' 03/08/2022 03:08:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19859' 03/08/2022 03:08:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19859' 03/08/2022 03:08:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19859' 03/08/2022 03:10:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001898' AND id_product != '19097' AND ean13 != '' 03/08/2022 03:10:34 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '001898', date_upd = NOW() WHERE id_product = '19097' 03/08/2022 03:10:34 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING04', description = '' WHERE id_product = '19097' 03/08/2022 03:10:34 pm >> UPDATE ps_product SET wholesale_price = '11.55', on_sale = '0', price = '27.049180327868854' WHERE id_product = '19097' 03/08/2022 03:10:34 pm >> UPDATE ps_product_shop SET wholesale_price = '11.55', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19097' 03/08/2022 03:10:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '19097' 03/08/2022 03:12:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000854' AND id_product != '19859' AND ean13 != '' 03/08/2022 03:12:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000854', date_upd = NOW() WHERE id_product = '19859' 03/08/2022 03:12:11 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING 29', description = '' WHERE id_product = '19859' 03/08/2022 03:12:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19859' 03/08/2022 03:12:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19859' 03/08/2022 03:12:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19859' 03/08/2022 03:12:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000854' AND id_product != '19859' AND ean13 != '' 03/08/2022 03:12:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000854', date_upd = NOW() WHERE id_product = '19859' 03/08/2022 03:12:44 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING 29', description = '' WHERE id_product = '19859' 03/08/2022 03:12:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19859' 03/08/2022 03:12:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19859' 03/08/2022 03:12:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19859' 03/08/2022 03:12:46 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19859' 03/08/2022 03:12:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19860' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:12:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19860' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19859' 03/08/2022 03:12:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19860' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19859' 03/08/2022 03:13:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B250/CA' AND id_product != '19860' AND ean13 != '' 03/08/2022 03:13:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B250/CA', date_upd = NOW() WHERE id_product = '19860' 03/08/2022 03:13:43 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B250/CA', description = '' WHERE id_product = '19860' 03/08/2022 03:13:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '19860' 03/08/2022 03:13:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19860' 03/08/2022 03:13:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19860' 03/08/2022 03:13:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19860' 03/08/2022 03:13:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19861' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:13:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19861' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19860' 03/08/2022 03:13:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19861' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19860' 03/08/2022 03:14:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B225/CA' AND id_product != '19861' AND ean13 != '' 03/08/2022 03:14:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B225/CA', date_upd = NOW() WHERE id_product = '19861' 03/08/2022 03:14:42 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B225/CA', description = '' WHERE id_product = '19861' 03/08/2022 03:14:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0327868852459' WHERE id_product = '19861' 03/08/2022 03:14:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0327868852459', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19861' 03/08/2022 03:14:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19861' 03/08/2022 03:14:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19861' 03/08/2022 03:14:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19862' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:14:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19862' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19861' 03/08/2022 03:14:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19862' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19861' 03/08/2022 03:15:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B238/CA' AND id_product != '19862' AND ean13 != '' 03/08/2022 03:15:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B238/CA', date_upd = NOW() WHERE id_product = '19862' 03/08/2022 03:15:22 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B238/CA', description = '' WHERE id_product = '19862' 03/08/2022 03:15:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.163934426229508' WHERE id_product = '19862' 03/08/2022 03:15:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.163934426229508', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19862' 03/08/2022 03:15:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '19862' 03/08/2022 03:15:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B238/CA' AND id_product != '19862' AND ean13 != '' 03/08/2022 03:15:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B238/CA', date_upd = NOW() WHERE id_product = '19862' 03/08/2022 03:15:46 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B238/CA', description = '' WHERE id_product = '19862' 03/08/2022 03:15:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.163934426229508' WHERE id_product = '19862' 03/08/2022 03:15:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.163934426229508', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19862' 03/08/2022 03:15:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19862' 03/08/2022 03:15:47 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19862' 03/08/2022 03:15:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19863' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:15:47 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19863' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19862' 03/08/2022 03:15:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19863' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19862' 03/08/2022 03:16:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B18/FE' AND id_product != '16271' AND ean13 != '' 03/08/2022 03:16:48 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'B18/FE', date_upd = NOW() WHERE id_product = '16271' 03/08/2022 03:16:48 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO ORO - B18/FE', description = '' WHERE id_product = '16271' 03/08/2022 03:16:48 pm >> UPDATE ps_product SET wholesale_price = '5.14', on_sale = '0', price = '11.4754' WHERE id_product = '16271' 03/08/2022 03:16:48 pm >> UPDATE ps_product_shop SET wholesale_price = '5.14', price = '11.4754', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16271' 03/08/2022 03:16:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '16271' 03/08/2022 03:18:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '21399/FE' AND id_product != '19863' AND ean13 != '' 03/08/2022 03:18:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '21399/FE', date_upd = NOW() WHERE id_product = '19863' 03/08/2022 03:18:06 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - 21399/FE', description = '' WHERE id_product = '19863' 03/08/2022 03:18:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '19863' 03/08/2022 03:18:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19863' 03/08/2022 03:18:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '19863' 03/08/2022 03:18:08 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19863' 03/08/2022 03:18:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19864' , '1' , '' , 'nuovo-prodotto' ) 03/08/2022 03:18:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19864' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19863' 03/08/2022 03:18:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19864' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19863' 03/08/2022 03:20:16 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 ( '31' , '316' , '2022-08-01' , '' , '0' , '95' , '2757' , 'VIA A. POLENGHI, 97 26845 CODOGNO' , '' , '' , '12.02' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '386.75' , '317.01' , NOW() , NOW() ) 03/08/2022 03:20:16 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 = '59909' 03/08/2022 03:20:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '59909' 03/08/2022 03:20:16 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 ( '59909' , '16456' , 'CINGOLO - CING03' , '10' , '10' , '1' , '5.73' , '4.6967213114754' , '22' , '3' , '67.8088' ) 03/08/2022 03:20:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '95' 03/08/2022 03:20:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '95' , '1' ) 03/08/2022 03:20:16 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 ( '59909' , '14114' , 'CINGOLO ORO - CING08ORO' , '2' , '2' , '1' , '13.86' , '11.360655737705' , '22' , '3' , '32.8038' ) 03/08/2022 03:20:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14114' AND id_supplier = '95' 03/08/2022 03:20:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14114' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '15893' , 'CINGOLO - CING17' , '2' , '2' , '1' , '18.9' , '15.491803278689' , '22' , '3' , '44.7325' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15893' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15893' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '17533' , 'CINGOLO ORO/COL - CING06' , '5' , '5' , '1' , '7.76' , '6.3606557377049' , '22' , '3' , '45.9159' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17533' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17533' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '14021' , 'CINGOLO - CING08' , '1' , '1' , '1' , '10.4' , '8.5245901639344' , '22' , '3' , '12.3074' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14021' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14021' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19857' , 'CINGOLO COL/ORO - CING 21' , '5' , '5' , '1' , '10.2' , '8.3606557377049' , '22' , '3' , '60.3534' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19857' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19857' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19859' , 'CINGOLO - CING 29' , '4' , '4' , '1' , '10.23' , '8.3852459016393' , '22' , '3' , '48.4247' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19859' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19859' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19097' , 'CINGOLO - CING04' , '1' , '1' , '1' , '13.5' , '11.065573770492' , '22' , '3' , '15.9759' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19097' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19097' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '16271' , 'FERMAGLIO ORO' , '1' , '1' , '1' , '5.59' , '4.5819672131148' , '22' , '3' , '6.6152' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16271' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16271' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19863' , 'FERMAGLIO - 21399/FE' , '2' , '2' , '1' , '4.65' , '3.8114754098361' , '22' , '3' , '11.0056' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19863' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19863' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19862' , 'FERMAGLIO - B238/CA' , '1' , '1' , '1' , '7.5' , '6.1475409836066' , '22' , '3' , '8.8755' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19862' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19862' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19861' , 'FERMAGLIO - B225/CA' , '1' , '1' , '1' , '9.09' , '7.4508196721311' , '22' , '3' , '10.7571' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19861' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19861' , '95' , '1' ) 03/08/2022 03:20: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 ( '59909' , '19860' , 'FERMAGLIO - B250/CA' , '1' , '1' , '1' , '5.5' , '4.5081967213115' , '22' , '3' , '6.5087' ) 03/08/2022 03:20:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19860' AND id_supplier = '95' 03/08/2022 03:20:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19860' , '95' , '1' ) 03/08/2022 03:29:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 03:29:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '14/S' , '2022-08-03' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1865.70' , '1865.70' , NOW() , NOW() ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5391' 03/08/2022 03:29:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '5391' 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '13' , 'BUSSATE E VI SARÀ APERTO' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '24' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '18.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '125' , 'MIE PREGHIERINE - N. E.' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '3.75' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '4.95' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '10' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '64' , 'MARIA APPARIZIONI E MESSAGGI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '11' , '0' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '92' , 'LA PREGHIERA DEL ROSARIO' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '106' , 'RICORDO DI UNA GIORNATA SPECIALE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '110' , 'SE MI AMI NON PIANGERE' , '16' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '12.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '51' , '0' , '4' , '4.00' , '4' , '0' , '50' , '102.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '4' , '0' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '175' , '0' , '4' , '18.00' , '18' , '0' , '50' , '1575.00' ) 03/08/2022 03:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5391' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 03/08/2022 03:32:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 03:32:41 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 ( '25' , '15/S' , '2022-08-03' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA LUGLIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.50' , '81.50' , NOW() , NOW() ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5392' 03/08/2022 03:32:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '5392' 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '20' , 'GIOVEDÌ SANTO' , '16' , '16' , '4' , '1.50' , '1.5' , '0' , '50' , '12.00' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '4' , '4' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '50' , 'PERDONAMI SIGNORE' , '6' , '6' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '52' , 'Il Padre Nostro spiegato ai bambini' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '23' , '23' , '4' , '2.00' , '2' , '0' , '50' , '23.00' ) 03/08/2022 03:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 03/08/2022 03:32:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/08/2022 03:32:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/08/2022 03:32:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '9' , '9' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 03/08/2022 03:32:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 03/08/2022 03:32:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5392' , '126' , 'SACRAMENTO DEL PERDONO' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 03/08/2022 03:33:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/S' AND id_document != '5391' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 03:33:02 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '14/S', document_date = '2022-08-03', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO LUGLIO 2022', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '1865.70', price_tax_excluded = '1865.70', date_upd = NOW() WHERE id_document = '5391' 03/08/2022 03:33:02 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 = '5391' 03/08/2022 03:33:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '5391' 03/08/2022 03:33:02 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 ( '5391' , '13' , 'BUSSATE E VI SARÀ APERTO' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 03/08/2022 03:33:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13' AND id_supplier = '' 03/08/2022 03:33:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13' , '' , '1' ) 03/08/2022 03:33:02 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 ( '5391' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 03/08/2022 03:33:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19' AND id_supplier = '' 03/08/2022 03:33:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19' , '' , '1' ) 03/08/2022 03:33:02 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 ( '5391' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '2.25' ) 03/08/2022 03:33:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20' , '' , '1' ) 03/08/2022 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 ( '5391' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '24' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '18.00' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '124' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '124' , '' , '1' ) 03/08/2022 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 ( '5391' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '9' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '11.25' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23' , '' , '1' ) 03/08/2022 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 ( '5391' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '121' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '121' , '' , '1' ) 03/08/2022 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 ( '5391' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '25' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '31.25' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '130' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '130' , '' , '1' ) 03/08/2022 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 ( '5391' , '125' , 'MIE PREGHIERINE - N. E.' , '5' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.75' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '' , '1' ) 03/08/2022 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 ( '5391' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '3.75' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '33' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '33' , '' , '1' ) 03/08/2022 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 ( '5391' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '5' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '42' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '42' , '' , '1' ) 03/08/2022 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 ( '5391' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '50' , '4.95' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '44' AND id_supplier = '' 03/08/2022 03:33:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '44' , '' , '1' ) 03/08/2022 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 ( '5391' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 03/08/2022 03:33:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '47' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '47' , '' , '1' ) 03/08/2022 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 ( '5391' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '10' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '7.50' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '55' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '55' , '' , '1' ) 03/08/2022 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 ( '5391' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '57' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '57' , '' , '1' ) 03/08/2022 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 ( '5391' , '64' , 'MARIA APPARIZIONI E MESSAGGI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '64' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '64' , '' , '1' ) 03/08/2022 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 ( '5391' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '11' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '11.00' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '67' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '67' , '' , '1' ) 03/08/2022 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 ( '5391' , '92' , 'LA PREGHIERA DEL ROSARIO' , '25' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '31.25' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '92' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '92' , '' , '1' ) 03/08/2022 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 ( '5391' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '127' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '127' , '' , '1' ) 03/08/2022 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 ( '5391' , '106' , 'RICORDO DI UNA GIORNATA SPECIALE' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '106' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '106' , '' , '1' ) 03/08/2022 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 ( '5391' , '110' , 'SE MI AMI NON PIANGERE' , '16' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '12.00' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '' , '1' ) 03/08/2022 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 ( '5391' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '51' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '102.00' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '115' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '115' , '' , '1' ) 03/08/2022 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 ( '5391' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 03/08/2022 03:33:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '132' AND id_supplier = '' 03/08/2022 03:33:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '132' , '' , '1' ) 03/08/2022 03:33:05 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 ( '5391' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '4' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 03/08/2022 03:33:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '129' AND id_supplier = '' 03/08/2022 03:33:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '129' , '' , '1' ) 03/08/2022 03:33:05 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 ( '5391' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '175' , '0' , '4' , '18.0000' , '18' , '0' , '50' , '1575.00' ) 03/08/2022 03:33:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 03/08/2022 03:33:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 03/08/2022 03:33:05 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 ( '5391' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 03/08/2022 03:33:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '126' AND id_supplier = '' 03/08/2022 03:33:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '126' , '' , '1' ) 03/08/2022 03:39:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2262' AND id_document != '59165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 03/08/2022 03:39:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2262', document_date = '2022-07-13', 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 = '24.00', price_tax_excluded = '19.67', date_upd = NOW() WHERE id_document = '59165' 03/08/2022 03:39:22 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 = '59165' 03/08/2022 03:39:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '59165' 03/08/2022 03:39:22 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 ( '59165' , '6359' , 'MEDAGLIA SCAPOLARE ARGENTO - MM12 ' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 03/08/2022 03:39:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6359' AND id_supplier = '' 03/08/2022 03:39:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6359' , '' , '1' ) 03/08/2022 03:39:22 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 ( '59165' , '16271' , 'FERMAGLIO ORO - B18/FE' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 03/08/2022 03:39:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16271' AND id_supplier = '' 03/08/2022 03:39:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16271' , '' , '1' ) 03/08/2022 03:54:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 03:54:35 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 ( '22' , '25/E' , '2022-08-03' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO LUGLIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '988.80' , '984.02' , NOW() , NOW() ) 03/08/2022 03:54:35 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 = '59910' 03/08/2022 03:54:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '59910' 03/08/2022 03:54:35 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 ( '59910' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '2.40' ) 03/08/2022 03:54:35 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 ( '59910' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/08/2022 03:54:35 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 ( '59910' , '9675' , 'SARETE MIEI TESTIMONI' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 03/08/2022 03:54:35 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 ( '59910' , '5458' , 'IO SONO CON VOI 2 PARTE' , '100' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '125.00' ) 03/08/2022 03:54:35 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 ( '59910' , '11191' , 'VENITE CON ME 1 PARTE' , '100' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '125.00' ) 03/08/2022 03:54:35 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 ( '59910' , '11192' , 'VENITE CON ME 2 PARTE' , '100' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '125.00' ) 03/08/2022 03:54:35 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 ( '59910' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '10' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '4.25' ) 03/08/2022 03:54:35 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 ( '59910' , '11308' , 'VIA CRUCIS ' , '11' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '8.25' ) 03/08/2022 03:54:35 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 ( '59910' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 03/08/2022 03:54:35 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 ( '59910' , '2679' , 'CONOSCERE GESU' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/08/2022 03:54:35 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 ( '59910' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '5' , '0' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 03/08/2022 03:54:35 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 ( '59910' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '0' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 03/08/2022 03:54:35 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 ( '59910' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '37' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '29.60' ) 03/08/2022 03:54:35 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 ( '59910' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 03/08/2022 03:54:35 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 ( '59910' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 03/08/2022 03:54:35 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 ( '59910' , '7543' , 'PARABOLE DI GESÙ' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 03/08/2022 03:54:35 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 ( '59910' , '12819' , 'REGISTRO DEL CATECHISTA ' , '53' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '26.50' ) 03/08/2022 03:54:35 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 ( '59910' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 03/08/2022 03:54:35 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 ( '59910' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/08/2022 03:54:35 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 ( '59910' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 03/08/2022 03:54:35 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 ( '59910' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '3' , '0' , '4' , '1.00' , '1' , '0' , '50' , '1.50' ) 03/08/2022 03:54:35 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 ( '59910' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '0.80' ) 03/08/2022 03:54:35 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 ( '59910' , '15020' , 'PREGARE OGNI GIORNO' , '14' , '0' , '4' , '1.00' , '1' , '0' , '50' , '7.00' ) 03/08/2022 03:54:35 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 ( '59910' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/08/2022 03:54:35 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 ( '59910' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '0' , '4' , '1.00' , '1' , '0' , '50' , '10.00' ) 03/08/2022 03:54:35 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 ( '59910' , '16667' , 'VIA CRUCIS' , '9' , '0' , '4' , '3.00' , '3' , '0' , '50' , '13.50' ) 03/08/2022 03:54:35 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 ( '59910' , '17257' , 'IO TI BATTEZZO ' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 03/08/2022 03:54:35 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 ( '59910' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 03/08/2022 03:54:35 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 ( '59910' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 03/08/2022 03:54:35 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 ( '59910' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 03/08/2022 03:54:35 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 ( '59910' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '4' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '3.80' ) 03/08/2022 03:54:35 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 ( '59910' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '6' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 03/08/2022 03:54:36 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 ( '59910' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '9' , '0' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 03/08/2022 03:54:36 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 ( '59910' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '2' , '0' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 03/08/2022 03:54:36 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 ( '59910' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '9' , '0' , '4' , '7.00' , '7' , '0' , '50' , '31.50' ) 03/08/2022 03:54:36 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 ( '59910' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 03/08/2022 03:54:36 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 ( '59910' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '8' , '0' , '4' , '10.00' , '10' , '0' , '50' , '40.00' ) 03/08/2022 03:54:36 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 ( '59910' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '11' , '0' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 03/08/2022 03:54:36 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 ( '59910' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 03/08/2022 03:54:36 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 ( '59910' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '3' , '0' , '4' , '12.00' , '12' , '0' , '50' , '18.00' ) 03/08/2022 03:54:36 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 ( '59910' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '22' , '0' , '4' , '20.00' , '20' , '0' , '50' , '220.00' ) 03/08/2022 03:54:36 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 ( '59910' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '9' , '0' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 03/08/2022 03:54:36 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 ( '59910' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '3' , '0' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 03/08/2022 03:54:36 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 ( '59910' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 03/08/2022 04:13:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 04:13:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '26/E' , '2022-08-03' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA LUGLIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '655.95' , '655.95' , NOW() , NOW() ) 03/08/2022 04:13:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59911' 03/08/2022 04:13:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '59911' 03/08/2022 04:13: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 ( '59911' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '27' , '27' , '4' , '2.40' , '2.4' , '0' , '50' , '32.40' ) 03/08/2022 04:13: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 ( '59911' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 03/08/2022 04:13: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 ( '59911' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '5' , '5' , '4' , '3.40' , '3.4' , '0' , '50' , '8.50' ) 03/08/2022 04:13: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 ( '59911' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 03/08/2022 04:13: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 ( '59911' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 03/08/2022 04:13: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 ( '59911' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 03/08/2022 04:13: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 ( '59911' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 03/08/2022 04:13: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 ( '59911' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 03/08/2022 04:13: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 ( '59911' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 03/08/2022 04:13: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 ( '59911' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '3' , '3' , '4' , '1.60' , '1.6' , '0' , '50' , '2.40' ) 03/08/2022 04:13: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 ( '59911' , '14029' , 'ANGELO DI DIO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 03/08/2022 04:13: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 ( '59911' , '15019' , 'PREGHIAMO CON MARIA' , '3' , '3' , '4' , '0.80' , '0.8' , '0' , '50' , '1.20' ) 03/08/2022 04:13: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 ( '59911' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '57' , '57' , '4' , '1.00' , '1' , '0' , '50' , '28.50' ) 03/08/2022 04:13: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 ( '59911' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 03/08/2022 04:13: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 ( '59911' , '16667' , 'VIA CRUCIS' , '9' , '9' , '4' , '3.00' , '3' , '0' , '50' , '13.50' ) 03/08/2022 04:13: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 ( '59911' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 03/08/2022 04:13: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 ( '59911' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 03/08/2022 04:13: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 ( '59911' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '3' , '3' , '4' , '3.80' , '3.8' , '0' , '50' , '5.70' ) 03/08/2022 04:13: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 ( '59911' , '18036' , 'FERITE FERITOIE ' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 03/08/2022 04:13: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 ( '59911' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '2' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 03/08/2022 04:13: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 ( '59911' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '8' , '8' , '4' , '4.80' , '4.8' , '0' , '50' , '19.20' ) 03/08/2022 04:13: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 ( '59911' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '36' , '36' , '4' , '1.00' , '1' , '0' , '50' , '18.00' ) 03/08/2022 04:13: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 ( '59911' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 03/08/2022 04:13: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 ( '59911' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '3' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 03/08/2022 04:13: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 ( '59911' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 03/08/2022 04:13: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 ( '59911' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '46' , '46' , '4' , '1.50' , '1.5' , '0' , '50' , '34.50' ) 03/08/2022 04:13: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 ( '59911' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 03/08/2022 04:13: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 ( '59911' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 03/08/2022 04:13: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 ( '59911' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '4' , '4' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 03/08/2022 04:13: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 ( '59911' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 03/08/2022 04:13: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 ( '59911' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '6' , '6' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 03/08/2022 04:13: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 ( '59911' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 03/08/2022 04:13: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 ( '59911' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 03/08/2022 04:13: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 ( '59911' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '4' , '4' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 03/08/2022 04:13: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 ( '59911' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '5' , '5' , '4' , '7.00' , '7' , '0' , '50' , '17.50' ) 03/08/2022 04:13: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 ( '59911' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '7' , '7' , '4' , '4.80' , '4.8' , '0' , '50' , '16.80' ) 03/08/2022 04:13: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 ( '59911' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '28' , '28' , '4' , '2.00' , '2' , '0' , '50' , '28.00' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '7' , '7' , '4' , '9.00' , '9' , '0' , '50' , '31.50' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '6' , '6' , '4' , '9.00' , '9' , '0' , '50' , '27.00' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '8' , '8' , '4' , '9.00' , '9' , '0' , '50' , '36.00' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '2' , '2' , '4' , '18.00' , '18' , '0' , '50' , '18.00' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 03/08/2022 04:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59911' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '60' , '60' , '4' , '2.00' , '2' , '0' , '50' , '60.00' ) 03/08/2022 04:15:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '318' , '2022-08-03' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , 'INVIATI A BYBLOS' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 03/08/2022 04:15:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59912' 03/08/2022 04:15:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '59912' 03/08/2022 04:15:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59912' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '400' , '400' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 03/08/2022 04:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19728' AND id_supplier = '145' 03/08/2022 04:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19728' , '145' , '1' ) 03/08/2022 04:16:18 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 ( '33' , '317' , '2022-08-03' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 03/08/2022 04:16:18 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 = '59913' 03/08/2022 04:16:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '59913' 03/08/2022 04:16:18 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 ( '59913' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '100' , '100' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 03/08/2022 04:16:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19728' AND id_supplier = '145' 03/08/2022 04:16:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19728' , '145' , '1' ) 03/08/2022 06:26:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2439' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 03/08/2022 06:26:46 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' , '2439' , '2022-08-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '7.20' , NOW() , NOW() ) 03/08/2022 06:26:46 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 = '59914' 03/08/2022 06:26:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '59914' 03/08/2022 06:26:46 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 ( '59914' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.03' , '0.03' , '0' , '0' , '7.20' ) 03/08/2022 06:26:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 03/08/2022 06:26:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' )