26/10/2022 09:04:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 09:04: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 ( '11' , '3191' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.30' , '13.54' , NOW() , NOW() ) 26/10/2022 09:04: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 = '68624' 26/10/2022 09:04:58 am >> DELETE FROM ps_document_detail WHERE id_document = '68624' 26/10/2022 09:04: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 ( '68624' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '14.00' ) 26/10/2022 09:04:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 26/10/2022 09:04:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 26/10/2022 09:04:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68624' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 26/10/2022 09:04:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/10/2022 09:04:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/10/2022 09:04:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68624' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 26/10/2022 09:04:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '' 26/10/2022 09:04:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '' , '1' ) 26/10/2022 09:06:13 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '68' 26/10/2022 09:06:13 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '68' , '10' , '210' , 'PARROCCHIA SANT\'ANNA ALL\'OLIVETO' , 'SPATUZZI ' , 'DON DOMENICO' , 'PIAZZA BERNARDINO LAMBERTI' , '' , '84013' , 'CAVA DE\' TIRRENI' , '' , '3517696871' , '' , '' , '80036790659' , NOW() , NOW() ) 26/10/2022 09:06:13 am >> UPDATE ps_customer SET email = 'domenicospatuzzi@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '68' 26/10/2022 09:07:31 am >> SELECT document_num FROM ps_document WHERE document_num = '198' AND id_document != '68042' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-21') 26/10/2022 09:07:31 am >> UPDATE ps_document SET id_document_type = '21', document_num = '198', document_date = '2022-10-21', document_letter = '', id_customer = '68', id_supplier = '0', id_address = '4676195', address1 = 'PIAZZA BERNARDINO LAMBERTI 84013 CAVA DE\\\' TIRRENI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '79.05', price_tax_excluded = '79.05', date_upd = NOW() WHERE id_document = '68042' 26/10/2022 09:07: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 = '68042' 26/10/2022 09:07:32 am >> DELETE FROM ps_document_detail WHERE id_document = '68042' 26/10/2022 09:07: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 ( '68042' , '4154' , 'FESTA DEL PERDONO' , '29' , '-29' , '4' , '3.0000' , '3' , '0' , '15' , '73.95' ) 26/10/2022 09:07: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 ( '68042' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 26/10/2022 09:12:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2977' AND id_document != '65228' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 26/10/2022 09:12:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2977', document_date = '2022-10-08', 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 = '170.96', price_tax_excluded = '170.54', date_upd = NOW() WHERE id_document = '65228' 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65228' 26/10/2022 09:12:21 am >> DELETE FROM ps_document_detail WHERE id_document = '65228' 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '5' , '14.16' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19931' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19931' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '5' , '22.80' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '6' , '-6' , '4' , '2.7000' , '2.7' , '0' , '0' , '16.20' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '15' , '-15' , '4' , '2.7000' , '2.7' , '0' , '0' , '40.50' ) 26/10/2022 09:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 26/10/2022 09:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 26/10/2022 09:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/10/2022 09:12:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/10/2022 09:12:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/10/2022 09:12:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 26/10/2022 09:12:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 26/10/2022 09:12:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 26/10/2022 09:12:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 26/10/2022 09:12:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 26/10/2022 09:12:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 26/10/2022 09:12:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '12' , '-12' , '4' , '2.7000' , '2.7' , '0' , '0' , '32.40' ) 26/10/2022 09:12:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 26/10/2022 09:12:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 26/10/2022 09:12:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/10/2022 09:12:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 09:12:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 09:14:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3069' AND id_document != '66378' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 26/10/2022 09:14:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3069', document_date = '2022-10-15', 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 = '175.88', price_tax_excluded = '175.07', date_upd = NOW() WHERE id_document = '66378' 26/10/2022 09:14:09 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 = '66378' 26/10/2022 09:14:09 am >> DELETE FROM ps_document_detail WHERE id_document = '66378' 26/10/2022 09:14:09 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 ( '66378' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '18' , '-18' , '4' , '2.7000' , '2.7' , '0' , '0' , '48.60' ) 26/10/2022 09:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 26/10/2022 09:14:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 26/10/2022 09:14:09 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 ( '66378' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '18' , '-18' , '4' , '2.7000' , '2.7' , '0' , '0' , '48.60' ) 26/10/2022 09:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 26/10/2022 09:14:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 26/10/2022 09:14:09 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 ( '66378' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '7' , '-7' , '4' , '2.7000' , '2.7' , '0' , '0' , '18.90' ) 26/10/2022 09:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 26/10/2022 09:14:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 26/10/2022 09:14:09 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 ( '66378' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '10.8000' , '10.8' , '0' , '0' , '21.60' ) 26/10/2022 09:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '' 26/10/2022 09:14:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '' , '1' ) 26/10/2022 09:14:09 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 ( '66378' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 26/10/2022 09:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 26/10/2022 09:14:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 26/10/2022 09:14:09 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 ( '66378' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 26/10/2022 09:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 26/10/2022 09:14: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 ( '66378' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.46' ) 26/10/2022 09:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 26/10/2022 09:14: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 ( '66378' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 26/10/2022 09:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18064' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18064' , '' , '1' ) 26/10/2022 09:14: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 ( '66378' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/10/2022 09:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 26/10/2022 09:14: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 ( '66378' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/10/2022 09:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 26/10/2022 09:14: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 ( '66378' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/10/2022 09:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 26/10/2022 09:14: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 ( '66378' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '4.05' , '4.05' , '0' , '0' , '8.10' ) 26/10/2022 09:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 09:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 09:14:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3044' AND id_document != '66347' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 26/10/2022 09:14:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3044', document_date = '2022-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.80', price_tax_excluded = '85.92', date_upd = NOW() WHERE id_document = '66347' 26/10/2022 09:14: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 = '66347' 26/10/2022 09:14:34 am >> DELETE FROM ps_document_detail WHERE id_document = '66347' 26/10/2022 09:14: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 ( '66347' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '3' , '-3' , '4' , '12.0000' , '12' , '0' , '5' , '34.20' ) 26/10/2022 09:14:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '' 26/10/2022 09:14:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/10/2022 09:14:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18704' AND id_supplier = '' 26/10/2022 09:14:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18704' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/10/2022 09:14:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '' 26/10/2022 09:14:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '18691' , 'IN_SEGUENDO GESU - QUADERNO' , '1' , '-1' , '4' , '4.85' , '4.85' , '0' , '0' , '4.85' ) 26/10/2022 09:14:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '' 26/10/2022 09:14:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '19921' , 'AGENDA 2023 - 40809' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '5' , '6.65' ) 26/10/2022 09:14:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19921' AND id_supplier = '' 26/10/2022 09:14:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19921' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '19.00' ) 26/10/2022 09:14:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 26/10/2022 09:14:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 26/10/2022 09:14:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 26/10/2022 09:14:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '19962' , 'MESSA MEDITAZIONE - NOV 2022' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 26/10/2022 09:14:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19962' AND id_supplier = '' 26/10/2022 09:14:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19962' , '' , '1' ) 26/10/2022 09:14: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 ( '66347' , '19963' , 'MESSA MEDITAZIONE - DIC 2022' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 26/10/2022 09:14:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19963' AND id_supplier = '' 26/10/2022 09:14:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19963' , '' , '1' ) 26/10/2022 09:15:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3101' AND id_document != '67968' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-18') 26/10/2022 09:15:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3101', document_date = '2022-10-18', 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 = '122.05', price_tax_excluded = '102.66', date_upd = NOW() WHERE id_document = '67968' 26/10/2022 09:15:01 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 = '67968' 26/10/2022 09:15:01 am >> DELETE FROM ps_document_detail WHERE id_document = '67968' 26/10/2022 09:15:01 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 ( '67968' , '12819' , 'REGISTRO DEL CATECHISTA ' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 26/10/2022 09:15:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 26/10/2022 09:15:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 26/10/2022 09:15:01 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 ( '67968' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 26/10/2022 09:15:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 09:15:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 09:15:01 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 ( '67968' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '48.5500' , '39.795081967213' , '22' , '0' , '48.55' ) 26/10/2022 09:15:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18962' AND id_supplier = '' 26/10/2022 09:15:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18962' , '' , '1' ) 26/10/2022 09:15:02 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 ( '67968' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 26/10/2022 09:15:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 26/10/2022 09:15:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 26/10/2022 09:15:02 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 ( '67968' , '19464' , 'TAPPI IN VETRO' , '2' , '-2' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '10.00' ) 26/10/2022 09:15:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19464' AND id_supplier = '' 26/10/2022 09:15:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19464' , '' , '1' ) 26/10/2022 09:15:02 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 ( '67968' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/10/2022 09:15:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '13418' AND id_supplier = '' 26/10/2022 09:15:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13418' , '' , '1' ) 26/10/2022 09:15:02 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 ( '67968' , '16910' , 'SERVIZIO DEL MINISTRO STRAORDINARIO - 8954' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/10/2022 09:15:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16910' AND id_supplier = '' 26/10/2022 09:15:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16910' , '' , '1' ) 26/10/2022 09:15:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2856' AND id_document != '61971' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 26/10/2022 09:15:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2856', document_date = '2022-09-28', 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 = '55.90', price_tax_excluded = '55.46', date_upd = NOW() WHERE id_document = '61971' 26/10/2022 09:15: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 = '61971' 26/10/2022 09:15:31 am >> DELETE FROM ps_document_detail WHERE id_document = '61971' 26/10/2022 09:15: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 ( '61971' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '2.92' , '2.92' , '0' , '0' , '2.92' ) 26/10/2022 09:15:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 09:15:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 09:15: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 ( '61971' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 26/10/2022 09:15:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 26/10/2022 09:15:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 26/10/2022 09:15: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 ( '61971' , '14259' , 'ARCA DI NOE - GIOCO' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 26/10/2022 09:15:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '14259' AND id_supplier = '' 26/10/2022 09:15:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14259' , '' , '1' ) 26/10/2022 09:15: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 ( '61971' , '19220' , 'lo vide e gli corse incontro - 3/6' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 26/10/2022 09:15:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19220' AND id_supplier = '' 26/10/2022 09:15:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19220' , '' , '1' ) 26/10/2022 09:15: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 ( '61971' , '19393' , 'GIOIA INFINITA - QUARESIMA 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/10/2022 09:15:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19393' AND id_supplier = '' 26/10/2022 09:15:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19393' , '' , '1' ) 26/10/2022 09:15: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 ( '61971' , '19305' , 'TEMPO PER TE - QUARESIMA 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 26/10/2022 09:15:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19305' AND id_supplier = '' 26/10/2022 09:15:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19305' , '' , '1' ) 26/10/2022 09:15: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 ( '61971' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 26/10/2022 09:15:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 09:15:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 09:21:38 am >> DELETE FROM ps_product WHERE id_product = '3398' 26/10/2022 09:21:38 am >> DELETE FROM ps_product_shop WHERE id_product = '3398' 26/10/2022 09:21:38 am >> DELETE FROM ps_product_lang WHERE id_product = '3398' 26/10/2022 09:21:38 am >> DELETE FROM ps_stock_available WHERE id_product = '3398' 26/10/2022 09:44:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 09:44:05 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' , '3192' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.20' , '130.48' , NOW() , NOW() ) 26/10/2022 09:44:05 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 = '68625' 26/10/2022 09:44:05 am >> DELETE FROM ps_document_detail WHERE id_document = '68625' 26/10/2022 09:44:05 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 ( '68625' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 26/10/2022 09:44:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 26/10/2022 09:44:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 26/10/2022 09:44:05 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 ( '68625' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '31.70' , '25.983606557377' , '22' , '0' , '31.70' ) 26/10/2022 09:44:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 26/10/2022 09:44:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 26/10/2022 09:51:59 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 26/10/2022 09:51:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', 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 = '373.49', price_tax_excluded = '339.59', date_upd = NOW() WHERE id_document = '61817' 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61817' 26/10/2022 09:51:59 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '20.00' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , '13/10/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 26/10/2022 09:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/10/2022 09:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/10/2022 09:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '7.80' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '9126' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9126' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '20171' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20171' , '' , '1' ) 26/10/2022 09:52:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '' , 'LAMPADINE' , '50' , '-50' , '0' , '1.8' , '1.8' , '' , '0' , '90.00' ) 26/10/2022 09:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 26/10/2022 09:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 26/10/2022 09:52:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3193' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 09:52:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3193' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 26/10/2022 09:52:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68626' 26/10/2022 09:52:59 am >> DELETE FROM ps_document_detail WHERE id_document = '68626' 26/10/2022 09:52:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68626' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 26/10/2022 09:52:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = '' 26/10/2022 09:52:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '' , '1' ) 26/10/2022 10:17:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3194' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:17:41 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' , '3194' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 26/10/2022 10:17:41 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 = '68627' 26/10/2022 10:17:41 am >> DELETE FROM ps_document_detail WHERE id_document = '68627' 26/10/2022 10:17:41 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 ( '68627' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/10/2022 10:17:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 10:17:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 10:26:22 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '344' 26/10/2022 10:26:22 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '344' , '10' , '210' , 'PARR. S. MARIA DELLA MISERICORDIA' , 'D\'INCECCO' , 'DON UMBERTO' , 'L.GO MONS. G. PALUMBO' , '' , '84020' , 'OLIVETO CITRA' , '' , '0828798327' , '3773945271' , '' , '91036840659' , NOW() , NOW() ) 26/10/2022 10:26:22 am >> UPDATE ps_customer SET email = 'parrocchiaoliveto@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '344' 26/10/2022 10:27:52 am >> SELECT document_num FROM ps_document WHERE document_num = '211' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:27:52 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 ( '21' , '211' , '2022-10-26' , '' , '344' , '0' , '4676196' , 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '325.56' , '325.56' , NOW() , NOW() ) 26/10/2022 10:27:52 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 = '68628' 26/10/2022 10:27:52 am >> DELETE FROM ps_document_detail WHERE id_document = '68628' 26/10/2022 10:27:52 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 ( '68628' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 26/10/2022 10:27:52 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 ( '68628' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 26/10/2022 10:27:52 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 ( '68628' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 26/10/2022 10:27:52 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 ( '68628' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '45' , '-45' , '4' , '2.40' , '2.4' , '0' , '15' , '91.80' ) 26/10/2022 10:27:52 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 ( '68628' , '4120' , 'FEDE NELLO ZAINETTO' , '30' , '-30' , '4' , '5.00' , '5' , '0' , '15' , '127.50' ) 26/10/2022 10:32:48 am >> SELECT document_num FROM ps_document WHERE document_num = '211' AND id_document != '68628' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:32:49 am >> UPDATE ps_document SET id_document_type = '21', document_num = '211', document_date = '2022-10-26', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4676196', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', address2 = '', note = 'ACCONTO € 150,00', 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 = '345.11', price_tax_excluded = '345.11', date_upd = NOW() WHERE id_document = '68628' 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68628' 26/10/2022 10:32:49 am >> DELETE FROM ps_document_detail WHERE id_document = '68628' 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '45' , '-45' , '4' , '2.4000' , '2.4' , '0' , '15' , '91.80' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '4120' , 'FEDE NELLO ZAINETTO' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '15' , '127.50' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 26/10/2022 10:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 26/10/2022 10:32:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 26/10/2022 10:32:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 26/10/2022 10:33:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3195' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:33:38 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' , '3195' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/10/2022 10:33:38 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 = '68629' 26/10/2022 10:33:38 am >> DELETE FROM ps_document_detail WHERE id_document = '68629' 26/10/2022 10:33:38 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 ( '68629' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/10/2022 10:33:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 10:33:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 10:35:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3196' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:35: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 ( '11' , '3196' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.43' , '16.53' , NOW() , NOW() ) 26/10/2022 10:35: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 = '68630' 26/10/2022 10:35:18 am >> DELETE FROM ps_document_detail WHERE id_document = '68630' 26/10/2022 10:35:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68630' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 26/10/2022 10:35:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '' 26/10/2022 10:35:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '' , '1' ) 26/10/2022 10:35:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68630' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '-1' , '4' , '11.50' , '11.5' , '0' , '5' , '10.93' ) 26/10/2022 10:35:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '' 26/10/2022 10:35:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '' , '1' ) 26/10/2022 10:35:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68630' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 26/10/2022 10:35:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 26/10/2022 10:35:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 26/10/2022 10:35:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3197' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:35:57 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' , '3197' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.03' , '47.03' , NOW() , NOW() ) 26/10/2022 10:35:57 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 = '68631' 26/10/2022 10:35:57 am >> DELETE FROM ps_document_detail WHERE id_document = '68631' 26/10/2022 10:35:57 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 ( '68631' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '-1' , '4' , '11.50' , '11.5' , '0' , '5' , '10.93' ) 26/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '' 26/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '' , '1' ) 26/10/2022 10:35:57 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 ( '68631' , '20205' , 'VIE DELLA PAROLA - M. BERGAMASCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 26/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20205' AND id_supplier = '' 26/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20205' , '' , '1' ) 26/10/2022 10:35:57 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 ( '68631' , '11529' , 'VOCAZIONE?!' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 26/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11529' AND id_supplier = '' 26/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11529' , '' , '1' ) 26/10/2022 10:48:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 10:48:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3198' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 26/10/2022 10:48:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68632' 26/10/2022 10:48:00 am >> DELETE FROM ps_document_detail WHERE id_document = '68632' 26/10/2022 10:48:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68632' , '3988' , 'EVANGELII GAUDIUM ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 26/10/2022 10:48:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '3988' AND id_supplier = '' 26/10/2022 10:48:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3988' , '' , '1' ) 26/10/2022 11:18:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:18:38 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' , '3199' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.55' , '12.78' , NOW() , NOW() ) 26/10/2022 11:18:38 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 = '68633' 26/10/2022 11:18:38 am >> DELETE FROM ps_document_detail WHERE id_document = '68633' 26/10/2022 11:18:38 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 ( '68633' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/10/2022 11:18:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 11:18:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 11:18:38 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 ( '68633' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 26/10/2022 11:18:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/10/2022 11:18:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/10/2022 11:26:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:26:12 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' , '3200' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 26/10/2022 11:26:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68634' 26/10/2022 11:26:12 am >> DELETE FROM ps_document_detail WHERE id_document = '68634' 26/10/2022 11:26:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68634' , '7943' , 'PERGAMENE - OCCASIONI MOD. B' , '50' , '-50' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '20.00' ) 26/10/2022 11:26:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7943' AND id_supplier = '' 26/10/2022 11:26:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7943' , '' , '1' ) 26/10/2022 11:33:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:33:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3201' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '73.50' , NOW() , NOW() ) 26/10/2022 11:33:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68635' 26/10/2022 11:33:50 am >> DELETE FROM ps_document_detail WHERE id_document = '68635' 26/10/2022 11:33:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68635' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/10/2022 11:33:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 26/10/2022 11:33:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 26/10/2022 11:33:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68635' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 26/10/2022 11:33:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 26/10/2022 11:33:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 26/10/2022 11:33:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68635' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 26/10/2022 11:33:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 26/10/2022 11:33:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 26/10/2022 11:33:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68635' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '1.60' ) 26/10/2022 11:33:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 26/10/2022 11:33:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 26/10/2022 11:40:49 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3467' 26/10/2022 11:40:49 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3467' , '10' , '217' , 'PARR. SANTA VITTORIA' , 'GRANATO' , 'P. MARIO' , 'VIA DUCA DEGLI ABRUZZI, 2' , '' , '64035' , 'CASTILENTI' , '' , '' , '3477281503' , '' , '81001140672' , NOW() , NOW() ) 26/10/2022 11:40:50 am >> UPDATE ps_customer SET email = 'trasfigurazione2004@hotmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3467' 26/10/2022 11:48:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:48: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 ( '11' , '3202' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.40' , '98.40' , NOW() , NOW() ) 26/10/2022 11:48: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 = '68636' 26/10/2022 11:48:54 am >> DELETE FROM ps_document_detail WHERE id_document = '68636' 26/10/2022 11:48: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 ( '68636' , '20057' , 'CINQUE PANI DORZO 2023' , '15' , '-15' , '4' , '6.90' , '6.9' , '0' , '5' , '98.40' ) 26/10/2022 11:48:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '' 26/10/2022 11:48:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '' , '1' ) 26/10/2022 11:52:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:52:04 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' , '3203' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 26/10/2022 11:52:04 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 = '68637' 26/10/2022 11:52:04 am >> DELETE FROM ps_document_detail WHERE id_document = '68637' 26/10/2022 11:52:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3203' AND id_document != '68637' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:52:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3203', document_date = '2022-10-26', 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 = '5.00', price_tax_excluded = '4.10', date_upd = NOW() WHERE id_document = '68637' 26/10/2022 11:52:37 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 = '68637' 26/10/2022 11:52:37 am >> DELETE FROM ps_document_detail WHERE id_document = '68637' 26/10/2022 11:52:37 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 ( '68637' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 26/10/2022 11:52:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/10/2022 11:52:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/10/2022 11:54:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3203' AND id_document != '68637' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 11:54:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3203', document_date = '2022-10-26', 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 = '5.00', price_tax_excluded = '4.10', date_upd = NOW() WHERE id_document = '68637' 26/10/2022 11:54:51 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 = '68637' 26/10/2022 11:54:51 am >> DELETE FROM ps_document_detail WHERE id_document = '68637' 26/10/2022 11:54:51 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 ( '68637' , '16330' , 'GRUPPO NATIVITA PORCELLANA CM 17' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 26/10/2022 11:54:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16330' AND id_supplier = '' 26/10/2022 11:54:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16330' , '' , '1' ) 26/10/2022 12:03:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '212' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 12:03:57 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' , '212' , '2022-10-26' , '' , '3467' , '0' , '4676197' , 'VIA DUCA DEGLI ABRUZZI, 2 64035 CASTILENTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '127.52' , '127.52' , NOW() , NOW() ) 26/10/2022 12:03:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68638' 26/10/2022 12:03:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '68638' 26/10/2022 12:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68638' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 26/10/2022 12:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68638' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 26/10/2022 12:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68638' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 26/10/2022 12:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68638' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 26/10/2022 12:14:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 12:14:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3204' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 26/10/2022 12:14:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68639' 26/10/2022 12:14:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '68639' 26/10/2022 12:14:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68639' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 26/10/2022 12:14:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 12:14:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 12:18:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 12:18:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3205' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 26/10/2022 12:18:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68640' 26/10/2022 12:18:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '68640' 26/10/2022 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68640' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/10/2022 12:18:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 26/10/2022 12:18:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 26/10/2022 12:27:52 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/10/2022 12:27:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20240' , '1' , '' , 'nuovo-prodotto' ) 26/10/2022 12:27:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20240' , '1' , '1' , '2' , NOW() , NOW() ) 26/10/2022 12:27:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20240' , '0' , '1' , '0' , '0' ) 26/10/2022 12:28:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713596' AND id_product != '20240' AND ean13 != '' 26/10/2022 12:28:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832713596', date_upd = NOW() WHERE id_product = '20240' 26/10/2022 12:28:30 pm >> UPDATE ps_product_lang SET name = 'PRONTI PARTENZA A BETLEMME', description = '' WHERE id_product = '20240' 26/10/2022 12:28:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20240' 26/10/2022 12:28:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20240' 26/10/2022 12:28:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '20240' 26/10/2022 12:28:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713596' AND id_product != '20240' AND ean13 != '' 26/10/2022 12:28:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832713596', date_upd = NOW() WHERE id_product = '20240' 26/10/2022 12:28:51 pm >> UPDATE ps_product_lang SET name = 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI', description = '' WHERE id_product = '20240' 26/10/2022 12:28:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20240' 26/10/2022 12:28:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20240' 26/10/2022 12:28:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '20240' 26/10/2022 12:28:52 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 = '20240' 26/10/2022 12:28:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20241' , '1' , '' , 'nuovo-prodotto' ) 26/10/2022 12:28:52 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 '20241' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20240' 26/10/2022 12:28:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20241' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20240' 26/10/2022 12:29:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713589' AND id_product != '20241' AND ean13 != '' 26/10/2022 12:29:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832713589', date_upd = NOW() WHERE id_product = '20241' 26/10/2022 12:29:19 pm >> UPDATE ps_product_lang SET name = 'PRONTI PARTENZA A BATLEMME - 7-10 ANNI', description = '' WHERE id_product = '20241' 26/10/2022 12:29:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20241' 26/10/2022 12:29:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20241' 26/10/2022 12:29:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '20241' 26/10/2022 12:29:20 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 = '20241' 26/10/2022 12:29:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20242' , '1' , '' , 'nuovo-prodotto' ) 26/10/2022 12:29:20 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 '20242' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20241' 26/10/2022 12:29:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20242' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20241' 26/10/2022 12:29:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713572' AND id_product != '20242' AND ean13 != '' 26/10/2022 12:29:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832713572', date_upd = NOW() WHERE id_product = '20242' 26/10/2022 12:29:50 pm >> UPDATE ps_product_lang SET name = 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI', description = '' WHERE id_product = '20242' 26/10/2022 12:29:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20242' 26/10/2022 12:29:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20242' 26/10/2022 12:29:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20242' 26/10/2022 12:30:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713589' AND id_product != '20241' AND ean13 != '' 26/10/2022 12:30:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832713589', date_upd = NOW() WHERE id_product = '20241' 26/10/2022 12:30:49 pm >> UPDATE ps_product_lang SET name = 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI', description = '' WHERE id_product = '20241' 26/10/2022 12:30:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0000' WHERE id_product = '20241' 26/10/2022 12:30:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20241' 26/10/2022 12:30:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '20241' 26/10/2022 12:31:55 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/10/2022 12:31:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20243' , '1' , '' , 'nuovo-prodotto' ) 26/10/2022 12:31:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20243' , '1' , '1' , '2' , NOW() , NOW() ) 26/10/2022 12:31:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20243' , '0' , '1' , '0' , '0' ) 26/10/2022 12:36:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713565' AND id_product != '20243' AND ean13 != '' 26/10/2022 12:36:29 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788832713565', date_upd = NOW() WHERE id_product = '20243' 26/10/2022 12:36:29 pm >> UPDATE ps_product_lang SET name = 'VIVA LA PARROCCHIA! ', description = '' WHERE id_product = '20243' 26/10/2022 12:36:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20243' 26/10/2022 12:36:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20243' 26/10/2022 12:36:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '20243' 26/10/2022 12:36:34 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 = '20243' 26/10/2022 12:36:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20244' , '1' , '' , 'nuovo-prodotto' ) 26/10/2022 12:36:34 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 '20244' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20243' 26/10/2022 12:36:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20244' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20243' 26/10/2022 12:38:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713619' AND id_product != '20244' AND ean13 != '' 26/10/2022 12:38:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788832713619', date_upd = NOW() WHERE id_product = '20244' 26/10/2022 12:38:01 pm >> UPDATE ps_product_lang SET name = 'PERCHE\' MI CERCHI? - S. MISCIO', description = '' WHERE id_product = '20244' 26/10/2022 12:38:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20244' 26/10/2022 12:38:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20244' 26/10/2022 12:38:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20244' 26/10/2022 12:39:05 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' , '635441' , '2022-10-25' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.80' , '89.80' , NOW() , NOW() ) 26/10/2022 12:39:05 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 = '68641' 26/10/2022 12:39:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '68641' 26/10/2022 12:39: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 ( '68641' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '1' , '1' , '4' , '22.00' , '22' , '0' , '30' , '15.4000' ) 26/10/2022 12:39:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16980' AND id_supplier = '109' 26/10/2022 12:39:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16980' , '109' , '1' ) 26/10/2022 12:39: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 ( '68641' , '20242' , 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI' , '2' , '2' , '4' , '4.00' , '4' , '0' , '35' , '5.2000' ) 26/10/2022 12:39:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20242' AND id_supplier = '109' 26/10/2022 12:39:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20242' , '109' , '1' ) 26/10/2022 12:39: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 ( '68641' , '20241' , 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI' , '2' , '2' , '4' , '4.00' , '4' , '0' , '35' , '5.2000' ) 26/10/2022 12:39:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20241' AND id_supplier = '109' 26/10/2022 12:39:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20241' , '109' , '1' ) 26/10/2022 12:39: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 ( '68641' , '20240' , 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI' , '2' , '2' , '4' , '4.00' , '4' , '0' , '35' , '5.2000' ) 26/10/2022 12:39:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20240' AND id_supplier = '109' 26/10/2022 12:39:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20240' , '109' , '1' ) 26/10/2022 12:39: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 ( '68641' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '25' , '12.3750' ) 26/10/2022 12:39:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '109' 26/10/2022 12:39:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '109' , '1' ) 26/10/2022 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68641' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '35' , '21.4500' ) 26/10/2022 12:39:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '109' 26/10/2022 12:39:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '109' , '1' ) 26/10/2022 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68641' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '25' , '9.3750' ) 26/10/2022 12:39:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '109' 26/10/2022 12:39:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '109' , '1' ) 26/10/2022 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68641' , '20243' , 'VIVA LA PARROCCHIA! ' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 26/10/2022 12:39:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20243' AND id_supplier = '109' 26/10/2022 12:39:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20243' , '109' , '1' ) 26/10/2022 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68641' , '20244' , 'PERCHE MI CERCHI? - S. MISCIO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 26/10/2022 12:39:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20244' AND id_supplier = '109' 26/10/2022 12:39:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20244' , '109' , '1' ) 26/10/2022 12:42:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864097923' AND id_product != '16980' AND ean13 != '' 26/10/2022 12:42:50 pm >> UPDATE ps_product SET id_supplier = '109', reference = '6/6', ean13 = '9788864097923', date_upd = NOW() WHERE id_product = '16980' 26/10/2022 12:42:50 pm >> UPDATE ps_product_lang SET name = 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN', description = '' WHERE id_product = '16980' 26/10/2022 12:42:50 pm >> UPDATE ps_product SET wholesale_price = '15.84', on_sale = '0', price = '22.0000' WHERE id_product = '16980' 26/10/2022 12:42:51 pm >> UPDATE ps_product_shop SET wholesale_price = '15.84', price = '22.0000', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16980' 26/10/2022 12:42:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '16980' 26/10/2022 12:46: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 ( '33' , '3131' , '2022-10-25' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '208.55' , '208.55' , NOW() , NOW() ) 26/10/2022 12:46: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 = '68642' 26/10/2022 12:46:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '68642' 26/10/2022 12:46: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 ( '68642' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 26/10/2022 12:46:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2549' AND id_supplier = '79' 26/10/2022 12:46:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2549' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '45' , '2.7500' ) 26/10/2022 12:46:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13418' AND id_supplier = '79' 26/10/2022 12:46:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13418' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '5765' , 'LEZIONARIO FERIALE TEMPI FORTI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 26/10/2022 12:46:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5765' AND id_supplier = '79' 26/10/2022 12:46:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5765' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '2' , '2' , '4' , '27.00' , '27' , '0' , '30' , '37.8000' ) 26/10/2022 12:46:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 26/10/2022 12:46:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 26/10/2022 12:46:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '79' 26/10/2022 12:46:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 26/10/2022 12:46:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '79' 26/10/2022 12:46:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 26/10/2022 12:46:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 26/10/2022 12:46:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 26/10/2022 12:46: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 ( '68642' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 26/10/2022 12:46:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 26/10/2022 12:46:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 26/10/2022 01:00:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '68051' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 26/10/2022 01:00:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2022-10-22', document_letter = '', id_customer = '541', id_supplier = '', id_address = '4671522', address1 = 'VIA GALLIANO 84126 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 = '68.00', price_tax_excluded = '68.00', date_upd = NOW() WHERE id_document = '68051' 26/10/2022 01:00:39 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 = '68051' 26/10/2022 01:00:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '68051' 26/10/2022 01:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 26/10/2022 01:00:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 26/10/2022 01:00:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 26/10/2022 01:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 26/10/2022 01:00:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 26/10/2022 01:00:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 26/10/2022 01:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 26/10/2022 01:00:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 26/10/2022 01:00:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 26/10/2022 01:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 26/10/2022 01:00:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 26/10/2022 01:00:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 26/10/2022 03:10:21 pm >> DELETE FROM ps_product WHERE id_product = '5443' 26/10/2022 03:10:21 pm >> DELETE FROM ps_product_shop WHERE id_product = '5443' 26/10/2022 03:10:21 pm >> DELETE FROM ps_product_lang WHERE id_product = '5443' 26/10/2022 03:10:21 pm >> DELETE FROM ps_stock_available WHERE id_product = '5443' 26/10/2022 03:40:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '213' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 03:40:45 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' , '213' , '2022-10-26' , '' , '1199' , '0' , '4671102' , 'VIA DELLE PUGLIE 84085 PANDOLA-MERCATO S.SEVER.' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '29.75' , '29.75' , NOW() , NOW() ) 26/10/2022 03:40:45 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 = '68643' 26/10/2022 03:40:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '68643' 26/10/2022 03:40:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68643' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 26/10/2022 03:48:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '202' AND id_document != '68052' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 26/10/2022 03:48:30 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '202', document_date = '2022-10-22', document_letter = '', id_customer = '1213', id_supplier = '', id_address = '1213', address1 = 'VIA M. PIRONTI 83020 MONTORO INFERIORE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '81.00', price_tax_excluded = '81.00', date_upd = NOW() WHERE id_document = '68052' 26/10/2022 03:48:30 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 = '68052' 26/10/2022 03:48:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '68052' 26/10/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68052' , '6629' , 'MIA PREGHIERA' , '100' , '-100' , '4' , '0.9000' , '0.9' , '0' , '10' , '81.00' ) 26/10/2022 03:48:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 26/10/2022 03:48:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 26/10/2022 03:52:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '214' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 03:52:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '214' , '2022-10-26' , '' , '388' , '0' , '4670962' , 'VIA DELLA CHIESA, 11 55064 S. MARTINO IN FREDDANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '74.30' , '74.30' , NOW() , NOW() ) 26/10/2022 03:52:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69155' 26/10/2022 03:52:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '69155' 26/10/2022 03:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69155' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.38' , '2.38' , '0' , '0' , '47.60' ) 26/10/2022 03:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69155' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.38' , '2.38' , '0' , '0' , '23.80' ) 26/10/2022 03:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69155' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 26/10/2022 04:02:46 pm >> UPDATE ps_orders SET current_state = '4', delivery_date = '' WHERE id_order = '391' 26/10/2022 04:02:46 pm >> DELETE FROM ps_document WHERE document_num = '391' AND id_document_type = '28' 26/10/2022 04:06:41 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3867' 26/10/2022 04:06:41 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3867' , '10' , '165' , 'PARROCCHIA S. MARIA ASSUNTA' , 'RICCI' , 'DON ANGELO ' , 'VIA SANT\'ONOFRIO' , '' , '86095' , 'FROSOLONE' , 'PARR. S. MARIA ASSUNTA \r\nC/O CASA CANONICA' , '' , '3391172888' , '' , '90011790947' , NOW() , NOW() ) 26/10/2022 04:06:41 pm >> UPDATE ps_customer SET email = 'r.angel@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3867' 26/10/2022 04:12:09 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'pB08Ut7khAY5lk8G' , NOW() , NOW() ) 26/10/2022 04:12:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3951' , '1' ) 26/10/2022 04:12:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3951' , '2' ) 26/10/2022 04:12:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3951' , '3' ) 26/10/2022 04:15:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3951' 26/10/2022 04:15:03 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3951' , '10' , '145' , 'PARR. S. MARIA DELLA LIBERA' , 'MASSA' , 'DON GIUSEPPE ' , 'VIA FATTORI - FRAZ. CARATTANO' , '' , '81010' , 'GIOIA SANNITICA' , '' , '' , '3397022285' , '' , '' , NOW() , NOW() ) 26/10/2022 04:15:03 pm >> UPDATE ps_customer SET email = 'gppemas56@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3951' 26/10/2022 04:20:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 04:20:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '215' , '2022-10-26' , '' , '3951' , '0' , '4676199' , 'VIA FATTORI - FRAZ. CARATTANO 81010 GIOIA SANNITICA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '79.65' , '79.65' , NOW() , NOW() ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69667' 26/10/2022 04:20:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '69667' 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.50' , '2.5' , '0' , '15' , '14.88' ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.50' , '2.5' , '0' , '15' , '14.88' ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '14323' , 'RELIGIOCANDO - ANTICO TESTAMENTO' , '7' , '-7' , '4' , '2.50' , '2.5' , '0' , '5' , '16.63' ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11191' , 'VENITE CON ME 1 PARTE' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 26/10/2022 04:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 26/10/2022 04:27:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 04:27:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3206' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 26/10/2022 04:27:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69668' 26/10/2022 04:27:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '69668' 26/10/2022 04:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69668' , '19925' , 'AMEN - NOV. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/10/2022 04:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 26/10/2022 04:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 26/10/2022 04:32:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 04:32:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3207' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.65' , '25.65' , NOW() , NOW() ) 26/10/2022 04:32:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69669' 26/10/2022 04:32:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '69669' 26/10/2022 04:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69669' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '5' , '25.65' ) 26/10/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '' 26/10/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '' , '1' ) 26/10/2022 05:24:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 05:24:34 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' , '3208' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 26/10/2022 05:24:34 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 = '69670' 26/10/2022 05:24:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '69670' 26/10/2022 05:24:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69670' , '20013' , 'CALENDARIO FRATE INDOVINO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 26/10/2022 05:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20013' AND id_supplier = '' 26/10/2022 05:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20013' , '' , '1' ) 26/10/2022 06:35:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '69667' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 06:35:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '215', document_date = '2022-10-26', document_letter = '', id_customer = '3951', id_supplier = '', id_address = '4676199', address1 = 'VIA FATTORI - FRAZ. CARATTANO 81010 GIOIA SANNITICA', address2 = '', note = 'avvisare prima di spedire appena l\'ordine è completo ', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '79.65', price_tax_excluded = '79.65', date_upd = NOW() WHERE id_document = '69667' 26/10/2022 06:35: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 = '69667' 26/10/2022 06:35:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '69667' 26/10/2022 06:35: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 ( '69667' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 26/10/2022 06:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 06:35: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 ( '69667' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 26/10/2022 06:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 26/10/2022 06:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 26/10/2022 06:35: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 ( '69667' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 26/10/2022 06:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 26/10/2022 06:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 26/10/2022 06:35: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 ( '69667' , '14323' , 'RELIGIOCANDO - ANTICO TESTAMENTO' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '5' , '16.63' ) 26/10/2022 06:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14323' AND id_supplier = '' 26/10/2022 06:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14323' , '' , '1' ) 26/10/2022 06:35: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 ( '69667' , '11191' , 'VENITE CON ME 1 PARTE' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '15' , '10.63' ) 26/10/2022 06:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 26/10/2022 06:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 26/10/2022 06:35:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '15' , '10.63' ) 26/10/2022 06:35:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 26/10/2022 06:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 26/10/2022 06:35:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 26/10/2022 06:35:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 26/10/2022 06:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 26/10/2022 06:40:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '139' AND id_document != '63580' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-03') 26/10/2022 06:40:29 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '139', document_date = '2022-10-03', document_letter = '', id_customer = '1529', id_supplier = '', id_address = '4671563', address1 = 'P.ZZA S. CROCE, 1 80059 TORRE DEL GRECO', address2 = '', note = '', price_shipping = '1.7', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '283.56', price_tax_excluded = '283.56', date_upd = NOW() WHERE id_document = '63580' 26/10/2022 06:40:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63580' 26/10/2022 06:40:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '63580' 26/10/2022 06:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63580' , '5457' , 'IO SONO CON VOI 1 PARTE' , '72' , '-72' , '4' , '2.5000' , '2.5' , '0' , '15' , '153.00' ) 26/10/2022 06:40:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:40:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 06:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63580' , '5458' , 'IO SONO CON VOI 2 PARTE' , '60' , '-60' , '4' , '2.5000' , '2.5' , '0' , '15' , '127.50' ) 26/10/2022 06:40:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 26/10/2022 06:40:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 26/10/2022 06:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63580' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '-1' , '4' , '1.6000' , '1.6' , '0' , '15' , '1.36' ) 26/10/2022 06:40:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 26/10/2022 06:40:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 26/10/2022 06:42:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '65774' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 26/10/2022 06:42:16 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '158', document_date = '2022-10-10', document_letter = '', id_customer = '1854', id_supplier = '', id_address = '4671605', address1 = 'PIAZZA S. GREGORIO 84020 SAN GREGORIO MAGNO', address2 = '', note = '', price_shipping = '0.42', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '538.05', price_tax_excluded = '538.05', date_upd = NOW() WHERE id_document = '65774' 26/10/2022 06:42: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 = '65774' 26/10/2022 06:42:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '65774' 26/10/2022 06:42: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 ( '65774' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 26/10/2022 06:42: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 ( '65774' , '5457' , 'IO SONO CON VOI 1 PARTE' , '19' , '-19' , '4' , '2.50' , '2.5' , '0' , '15' , '40.38' ) 26/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 06:48:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '182' AND id_document != '67952' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-18') 26/10/2022 06:48:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '182', document_date = '2022-10-18', document_letter = '', id_customer = '1741', id_supplier = '', id_address = '4673393', address1 = 'L.GO CAMPANILE, 1 83040 FLUMERI', address2 = '', note = '', price_shipping = '0.08', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '659.39', price_tax_excluded = '659.39', date_upd = NOW() WHERE id_document = '67952' 26/10/2022 06:48: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 = '67952' 26/10/2022 06:48:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '67952' 26/10/2022 06:48: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 ( '67952' , '13397' , 'MIO GESU\'' , '21' , '-21' , '4' , '3.5000' , '3.5' , '0' , '15' , '62.48' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 26/10/2022 06:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 26/10/2022 06:48: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 ( '67952' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 26/10/2022 06:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 26/10/2022 06:48: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 ( '67952' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 26/10/2022 06:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 26/10/2022 06:48: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 ( '67952' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '29' , '-29' , '4' , '3.5000' , '3.5' , '0' , '15' , '86.28' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 26/10/2022 06:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 26/10/2022 06:48: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 ( '67952' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '15' , '34.00' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 26/10/2022 06:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 26/10/2022 06:48: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 ( '67952' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '27' , '-27' , '4' , '3.5000' , '3.5' , '0' , '15' , '80.33' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 26/10/2022 06:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 26/10/2022 06:48: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 ( '67952' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '15' , '34.00' ) 26/10/2022 06:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 26/10/2022 06:48:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 26/10/2022 06:48:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67952' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '4' , '-4' , '4' , '5.1600' , '5.16' , '0' , '15' , '17.54' ) 26/10/2022 06:48:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '106' AND id_supplier = '' 26/10/2022 06:48:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '106' , '' , '1' ) 26/10/2022 06:48:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67952' , '6629' , 'MIA PREGHIERA' , '50' , '-50' , '4' , '0.9000' , '0.9' , '0' , '15' , '38.25' ) 26/10/2022 06:48:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 26/10/2022 06:48:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 26/10/2022 06:48:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67952' , '5457' , 'IO SONO CON VOI 1 PARTE' , '81' , '-81' , '4' , '2.50' , '2.5' , '0' , '15' , '172.13' ) 26/10/2022 06:48:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:48:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 06:48:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67952' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 26/10/2022 06:48:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 26/10/2022 06:48:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 26/10/2022 06:51:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '161' AND id_document != '65789' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-11') 26/10/2022 06:51:01 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '161', document_date = '2022-10-11', document_letter = '', id_customer = '1246', id_supplier = '', id_address = '4675590', address1 = 'L.GO MARGHERITA DI SAVOIA 85021 AVIGLIANO', address2 = '', note = '', price_shipping = '1.7', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '142.92', price_tax_excluded = '142.92', date_upd = NOW() WHERE id_document = '65789' 26/10/2022 06:51:01 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 = '65789' 26/10/2022 06:51:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '65789' 26/10/2022 06:51:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65789' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '65' , '-65' , '4' , '0.3000' , '0.3' , '0' , '0' , '19.50' ) 26/10/2022 06:51:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '5' , '0.76' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15030' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15030' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19977' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19977' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '15742' , 'AVE MARIA - PREGHIERE MARIANE' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15742' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15742' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '5' , '0.85' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '15' , '5.95' ) 26/10/2022 06:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 26/10/2022 06:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '19159' , 'VOLTI DELL\'AMORE - V. SALVOLDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 26/10/2022 06:51:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19159' AND id_supplier = '' 26/10/2022 06:51:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19159' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '3443' , 'DIECI PAROLE D\'AMORE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 26/10/2022 06:51:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3443' AND id_supplier = '' 26/10/2022 06:51:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3443' , '' , '1' ) 26/10/2022 06:51: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 ( '65789' , '5457' , 'IO SONO CON VOI 1 PARTE' , '44' , '-44' , '4' , '2.50' , '2.5' , '0' , '15' , '93.50' ) 26/10/2022 06:51:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:51:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 06:51:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '65757' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 26/10/2022 06:51:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '156', document_date = '2022-10-10', document_letter = '', id_customer = '3525', id_supplier = '', id_address = '4670933', address1 = 'VIA CUTINELLI 1 - Località Ponte di Ferro 80038 POMIGLIANO D\\\'ARCO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '136.00', price_tax_excluded = '136.00', date_upd = NOW() WHERE id_document = '65757' 26/10/2022 06:51:39 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 = '65757' 26/10/2022 06:51:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '65757' 26/10/2022 06:51:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65757' , '11191' , 'VENITE CON ME 1 PARTE' , '32' , '-32' , '4' , '2.5000' , '2.5' , '0' , '15' , '68.00' ) 26/10/2022 06:51:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 26/10/2022 06:51:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 26/10/2022 06:51:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65757' , '5457' , 'IO SONO CON VOI 1 PARTE' , '32' , '-32' , '4' , '2.50' , '2.5' , '0' , '15' , '68.00' ) 26/10/2022 06:51:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:51:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 06:53:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '165' AND id_document != '66328' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-12') 26/10/2022 06:53:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '165', document_date = '2022-10-12', document_letter = '', id_customer = '3934', id_supplier = '', id_address = '4675733', address1 = 'Corso Vittorio Emanuele , 96 95028 Valverde ', address2 = '', note = '', price_shipping = '5.19', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '38.44', price_tax_excluded = '38.44', date_upd = NOW() WHERE id_document = '66328' 26/10/2022 06:53:07 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 = '66328' 26/10/2022 06:53:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '66328' 26/10/2022 06:53:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66328' , '5457' , 'IO SONO CON VOI 1 PARTE' , '14' , '-14' , '4' , '2.50' , '2.5' , '0' , '5' , '33.25' ) 26/10/2022 06:53:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 06:53:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 07:01:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 26/10/2022 07:01:54 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' , '3209' , '2022-10-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.25' , '46.25' , NOW() , NOW() ) 26/10/2022 07:01:54 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 = '69671' 26/10/2022 07:01:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '69671' 26/10/2022 07:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69671' , '20096' , 'VISIONI BIBLICHE E CONTEMPLAZIONI MISTICHE - A.K. EMMERICK' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 26/10/2022 07:01:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20096' AND id_supplier = '' 26/10/2022 07:01:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20096' , '' , '1' ) 26/10/2022 07:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69671' , '14529' , 'PANE E VINO - SUSSIDIO' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/10/2022 07:01:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 26/10/2022 07:01:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 26/10/2022 07:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69671' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 26/10/2022 07:01:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '' 26/10/2022 07:01:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '' , '1' ) 26/10/2022 07:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69671' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 26/10/2022 07:01:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 26/10/2022 07:01:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 26/10/2022 07:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69671' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 26/10/2022 07:01:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 26/10/2022 07:01:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 26/10/2022 07:14:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '208' AND id_document != '68603' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 26/10/2022 07:14:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '208', document_date = '2022-10-25', document_letter = '', id_customer = '1127', id_supplier = '', id_address = '4672060', address1 = 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '57.07', price_tax_excluded = '57.07', date_upd = NOW() WHERE id_document = '68603' 26/10/2022 07:14: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 = '68603' 26/10/2022 07:14:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '68603' 26/10/2022 07:14: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 ( '68603' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 26/10/2022 07:14:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 26/10/2022 07:14:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 26/10/2022 07:14: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 ( '68603' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 26/10/2022 07:14:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 26/10/2022 07:14:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 26/10/2022 07:14: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 ( '68603' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 26/10/2022 07:14:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 26/10/2022 07:14:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 26/10/2022 07:14: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 ( '68603' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 26/10/2022 07:14:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 26/10/2022 07:14:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 26/10/2022 07:14: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 ( '68603' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.04' , '2.04' , '0' , '0' , '20.40' ) 26/10/2022 07:14:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 07:14:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 07:16:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '166' AND id_document != '66330' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 26/10/2022 07:16:30 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '166', document_date = '2022-10-13', document_letter = '', id_customer = '3907', id_supplier = '', id_address = '4674901', address1 = 'VIA DIOCLEZIANO 130 80124 NAPOLI', address2 = '', note = '', price_shipping = '5.42', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '48.70', price_tax_excluded = '48.70', date_upd = NOW() WHERE id_document = '66330' 26/10/2022 07:16:30 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 = '66330' 26/10/2022 07:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '66330' 26/10/2022 07:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66330' , '0' , 'spese di contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 26/10/2022 07:16:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/10/2022 07:16:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/10/2022 07:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66330' , '5457' , 'IO SONO CON VOI 1 PARTE' , '19' , '-19' , '4' , '2.50' , '2.5' , '0' , '15' , '40.38' ) 26/10/2022 07:16:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 26/10/2022 07:16:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 26/10/2022 07:33:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3078' AND id_document != '67413' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-17') 26/10/2022 07:33:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3078', document_date = '2022-10-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.00', price_tax_excluded = '4.92', date_upd = NOW() WHERE id_document = '67413' 26/10/2022 07:33:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67413' 26/10/2022 07:33:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '67413' 26/10/2022 07:33: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 ( '67413' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 26/10/2022 07:33:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 26/10/2022 07:33:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' )