10/10/2022 08:26:57 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '65230' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-08') 10/10/2022 08:26:57 am >> UPDATE ps_document SET id_document_type = '21', document_num = '153', document_date = '2022-10-08', 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 = '1', id_causal = '0', price_tax_included = '175.54', price_tax_excluded = '175.54', date_upd = NOW() WHERE id_document = '65230' 10/10/2022 08:26: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 = '65230' 10/10/2022 08:26:57 am >> DELETE FROM ps_document_detail WHERE id_document = '65230' 10/10/2022 08:26: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 ( '65230' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 10/10/2022 08:26:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 08:26:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 08:26: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 ( '65230' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 10/10/2022 08:26:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 08:26:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 08:26: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 ( '65230' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 10/10/2022 08:26:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 10/10/2022 08:26:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 10/10/2022 08:33:15 am >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 08:33:15 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' , '154' , '2022-10-10' , '' , '3929' , '' , '4675583' , 'Via Montevergine, , 34 92010 Caltabellotta ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '171.98' , '171.98' , NOW() , NOW() ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65749' 10/10/2022 08:33:15 am >> DELETE FROM ps_document_detail WHERE id_document = '65749' 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 10/10/2022 08:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 10/10/2022 08:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '' 10/10/2022 08:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 10/10/2022 08:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 10/10/2022 08:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 10/10/2022 08:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 10/10/2022 08:33:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '5' , '0.86' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '7824' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7824' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8510' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8510' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8511' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8511' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8514' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8514' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8515' AND id_supplier = '' 10/10/2022 08:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8515' , '' , '1' ) 10/10/2022 08:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/10/2022 08:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9996' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9996' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '4' , '1' , '1' , '0' , '5' , '9.50' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '5' , '0.95' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16666' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16666' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17274' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17274' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18527' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18527' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 10/10/2022 08:33:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 10/10/2022 08:33:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 10/10/2022 08:33:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 10/10/2022 08:35:43 am >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '65749' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 08:35:43 am >> UPDATE ps_document SET id_document_type = '21', document_num = '154', document_date = '2022-10-10', document_letter = '', id_customer = '3929', id_supplier = '', id_address = '4675583', address1 = 'Via Montevergine, , 34 92010 Caltabellotta ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '171.98', price_tax_excluded = '171.98', date_upd = NOW() WHERE id_document = '65749' 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65749' 10/10/2022 08:35:43 am >> DELETE FROM ps_document_detail WHERE id_document = '65749' 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:35:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 10/10/2022 08:35:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 10/10/2022 08:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '5' , '0.86' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '7824' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7824' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8510' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8510' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8511' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8511' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8514' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8514' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8515' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8515' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9996' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9996' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '4' , '1.0000' , '1' , '0' , '5' , '9.50' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 10/10/2022 08:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/10/2022 08:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 10/10/2022 08:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16666' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16666' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17274' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17274' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18527' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18527' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 10/10/2022 08:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65749' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 10/10/2022 08:35:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 10/10/2022 08:35:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 10/10/2022 08:42:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/10/2022 08:42:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20084' , '1' , '' , 'nuovo-prodotto' ) 10/10/2022 08:42:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20084' , '1' , '1' , '2' , NOW() , NOW() ) 10/10/2022 08:42:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20084' , '0' , '1' , '0' , '0' ) 10/10/2022 08:43:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242272' AND id_product != '9307' AND ean13 != '' 10/10/2022 08:43:15 am >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788861242272', date_upd = NOW() WHERE id_product = '9307' 10/10/2022 08:43:15 am >> UPDATE ps_product_lang SET name = 'SACRAMENTI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '9307' 10/10/2022 08:43:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '9307' 10/10/2022 08:43:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9307' 10/10/2022 08:43:15 am >> DELETE FROM ps_specific_price WHERE id_product = '9307' 10/10/2022 08:44:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '610472' , '2022-10-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '12.16' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '411.00' , '411.00' , NOW() , NOW() ) 10/10/2022 08:44:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65750' 10/10/2022 08:44:16 am >> DELETE FROM ps_document_detail WHERE id_document = '65750' 10/10/2022 08:44:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '2' , '2' , '4' , '5.00' , '5' , '0' , '33+7' , '6.2310' ) 10/10/2022 08:44:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '18704' AND id_supplier = '7' 10/10/2022 08:44:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18704' , '7' , '1' ) 10/10/2022 08:44:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '18691' , 'IN_SEGUENDO GESU - QUADERNO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '33+7' , '6.2310' ) 10/10/2022 08:44:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '7' 10/10/2022 08:44:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '7' , '1' ) 10/10/2022 08:44:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '20041' , 'FOLLOWERS DIARIO FAMIGLIE 1' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '33+7' , '4.0502' ) 10/10/2022 08:44:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20041' AND id_supplier = '7' 10/10/2022 08:44:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20041' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '20042' , 'FOLLOWERS DIARIO FAMIGLIE 2' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '33+7' , '4.0502' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '20042' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20042' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '20043' , 'FOLLOWERS DIARIO FAMIGLIE - GUIDA' , '2' , '2' , '4' , '14.00' , '14' , '0' , '33+7' , '17.4468' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '20043' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20043' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '15327' , 'BATTESIMO E CONFERMAZIONE - P. BAU' , '1' , '1' , '4' , '48.00' , '48' , '0' , '30' , '33.6000' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '15327' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15327' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '3898' , 'ESCATOLOGIA CRISTIANA - G. ANCONA' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '3898' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3898' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '16215' , 'EUCARISTIA - A. GRILLO' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16215' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16215' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '70' , '70' , '4' , '5.90' , '5.9' , '0' , '30+7' , '268.8630' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17244' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17244' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '9307' , 'SACRAMENTI SPIEGATI AI BAMBINI' , '4' , '4' , '4' , '3.90' , '3.9' , '0' , '30+7' , '10.1556' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '9307' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9307' , '7' , '1' ) 10/10/2022 08:44:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65750' , '13129' , 'ESAME DI COSCIENZA SPIEGATO AI BAMBINI' , '3' , '3' , '4' , '3.90' , '3.9' , '0' , '30+7' , '7.6167' ) 10/10/2022 08:44:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '13129' AND id_supplier = '7' 10/10/2022 08:44:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13129' , '7' , '1' ) 10/10/2022 09:20:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 09:20:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2985' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.89' , '5.89' , NOW() , NOW() ) 10/10/2022 09:20:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65751' 10/10/2022 09:20:17 am >> DELETE FROM ps_document_detail WHERE id_document = '65751' 10/10/2022 09:20:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65751' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.20' , '6.2' , '0' , '5' , '5.89' ) 10/10/2022 09:20:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 10/10/2022 09:20:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 10/10/2022 09:42:36 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2312' 10/10/2022 09:42:36 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 ( '2312' , '10' , '210' , 'PARROCCHIA S. ANDREA AP.' , 'GIORDANO' , 'DON GIUSEPPE ' , 'VIA SANT\'ANDREA' , '' , '84081' , 'ANTESSANO BARONISSI' , '' , '' , '' , '' , '80031700653' , NOW() , NOW() ) 10/10/2022 09:42:36 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2312' 10/10/2022 09:45:13 am >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 09:45:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '155' , '2022-10-10' , '' , '2312' , '0' , '4675584' , 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '267.33' , '267.33' , NOW() , NOW() ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65752' 10/10/2022 09:45:13 am >> DELETE FROM ps_document_detail WHERE id_document = '65752' 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '4154' , 'FESTA DEL PERDONO' , '22' , '-22' , '4' , '3.00' , '3' , '0' , '15' , '56.10' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8408' , 'PRENDETE E MANGIATE' , '22' , '-22' , '4' , '3.00' , '3' , '0' , '15' , '56.10' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '18' , '-18' , '4' , '3.50' , '3.5' , '0' , '15' , '53.55' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.50' , '2.5' , '0' , '15' , '44.63' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 10/10/2022 09:45:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 10/10/2022 09:54:25 am >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '65752' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 09:54:25 am >> UPDATE ps_document SET id_document_type = '21', document_num = '155', document_date = '2022-10-10', document_letter = '', id_customer = '2312', id_supplier = '', id_address = '4675584', address1 = 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI', 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 = '272.43', price_tax_excluded = '272.43', date_upd = NOW() WHERE id_document = '65752' 10/10/2022 09:54:25 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 = '65752' 10/10/2022 09:54:25 am >> DELETE FROM ps_document_detail WHERE id_document = '65752' 10/10/2022 09:54:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '4154' , 'FESTA DEL PERDONO' , '22' , '-22' , '4' , '3.0000' , '3' , '0' , '15' , '56.10' ) 10/10/2022 09:54:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 10/10/2022 09:54:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 10/10/2022 09:54:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8408' , 'PRENDETE E MANGIATE' , '22' , '-22' , '4' , '3.0000' , '3' , '0' , '15' , '56.10' ) 10/10/2022 09:54:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 10/10/2022 09:54:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 10/10/2022 09:54:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '18' , '-18' , '4' , '3.5000' , '3.5' , '0' , '15' , '53.55' ) 10/10/2022 09:54:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 10/10/2022 09:54:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 10/10/2022 09:54:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.5000' , '2.5' , '0' , '15' , '44.63' ) 10/10/2022 09:54:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 10/10/2022 09:54:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 10/10/2022 09:54:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 10/10/2022 09:54:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 10/10/2022 09:54:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 10/10/2022 09:54:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '11191' , 'VENITE CON ME 1 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 10/10/2022 09:54:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 10/10/2022 09:54:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 10/10/2022 09:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 10/10/2022 09:54:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 10/10/2022 09:54:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 10/10/2022 09:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 10/10/2022 09:54:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 10/10/2022 09:54:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 10/10/2022 09:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 10/10/2022 09:54:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 10/10/2022 09:54:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 10/10/2022 09:54:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 09:54: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 ( '11' , '2986' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 10/10/2022 09:54: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 = '65753' 10/10/2022 09:54:52 am >> DELETE FROM ps_document_detail WHERE id_document = '65753' 10/10/2022 09:54: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 ( '65753' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '9.50' ) 10/10/2022 09:54:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 10/10/2022 09:54:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 10/10/2022 09:54: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 ( '65753' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 10/10/2022 09:54:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 10/10/2022 09:54:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 10/10/2022 09:56:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 09:56:03 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' , '2987' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 10/10/2022 09:56:03 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 = '65754' 10/10/2022 09:56:03 am >> DELETE FROM ps_document_detail WHERE id_document = '65754' 10/10/2022 09:56:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65754' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 10/10/2022 09:56:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 10/10/2022 09:56:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 10/10/2022 10:03:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 10:03:03 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' , '2988' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.89' , '30.66' , NOW() , NOW() ) 10/10/2022 10:03:03 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 = '65755' 10/10/2022 10:03:03 am >> DELETE FROM ps_document_detail WHERE id_document = '65755' 10/10/2022 10:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65755' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '6.80' , '5.5737704918033' , '22' , '0' , '6.80' ) 10/10/2022 10:03:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1621' AND id_supplier = '' 10/10/2022 10:03:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1621' , '' , '1' ) 10/10/2022 10:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65755' , '19936' , 'SANTI PER IL CATECHISMO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 10/10/2022 10:03:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19936' AND id_supplier = '' 10/10/2022 10:03:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19936' , '' , '1' ) 10/10/2022 10:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65755' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 10/10/2022 10:03:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 10/10/2022 10:03:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' ) 10/10/2022 10:05:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858144114' AND id_product != '20084' AND ean13 != '' 10/10/2022 10:05:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788858144114', date_upd = NOW() WHERE id_product = '20084' 10/10/2022 10:05:45 am >> UPDATE ps_product_lang SET name = 'CHIESA BRUCIA - A. RICCARDI', description = '' WHERE id_product = '20084' 10/10/2022 10:05:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20084' 10/10/2022 10:05:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '350', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20084' 10/10/2022 10:05:45 am >> DELETE FROM ps_specific_price WHERE id_product = '20084' 10/10/2022 10:06:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858144114' AND id_product != '20084' AND ean13 != '' 10/10/2022 10:06:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788858144114', date_upd = NOW() WHERE id_product = '20084' 10/10/2022 10:06:05 am >> UPDATE ps_product_lang SET name = 'CHIESA BRUCIA - A. RICCARDI', description = '' WHERE id_product = '20084' 10/10/2022 10:06:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20084' 10/10/2022 10:06:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '350', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20084' 10/10/2022 10:06:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20084' 10/10/2022 10:06:06 am >> 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 = '20084' 10/10/2022 10:06:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20085' , '1' , '' , 'nuovo-prodotto' ) 10/10/2022 10:06:06 am >> 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 '20085' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20084' 10/10/2022 10:06:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20085' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20084' 10/10/2022 10:06:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298813' AND id_product != '20085' AND ean13 != '' 10/10/2022 10:06:44 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788869298813', date_upd = NOW() WHERE id_product = '20085' 10/10/2022 10:06:44 am >> UPDATE ps_product_lang SET name = 'CARTA FORBICI E ... - D. MAZZOLI', description = '' WHERE id_product = '20085' 10/10/2022 10:06:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20085' 10/10/2022 10:06:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20085' 10/10/2022 10:06:44 am >> DELETE FROM ps_specific_price WHERE id_product = '20085' 10/10/2022 10:06:45 am >> 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 = '20085' 10/10/2022 10:06:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20086' , '1' , '' , 'nuovo-prodotto' ) 10/10/2022 10:06:45 am >> 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 '20086' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20085' 10/10/2022 10:06:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20086' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20085' 10/10/2022 10:08: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 ( '33' , '626732' , '2022-10-10' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.50' , '79.50' , NOW() , NOW() ) 10/10/2022 10:08: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 = '65756' 10/10/2022 10:08:50 am >> DELETE FROM ps_document_detail WHERE id_document = '65756' 10/10/2022 10:08: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 ( '65756' , '20084' , 'CHIESA BRUCIA - A. RICCARDI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 10/10/2022 10:08:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20084' AND id_supplier = '109' 10/10/2022 10:08:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20084' , '109' , '1' ) 10/10/2022 10:08: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 ( '65756' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 10/10/2022 10:08:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20085' AND id_supplier = '109' 10/10/2022 10:08:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20085' , '109' , '1' ) 10/10/2022 10:08: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 ( '65756' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 10/10/2022 10:08:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '109' 10/10/2022 10:08:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '109' , '1' ) 10/10/2022 10:08: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 ( '65756' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 10/10/2022 10:08:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '109' 10/10/2022 10:08:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '109' , '1' ) 10/10/2022 10:08: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 ( '65756' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '0' , '12.50' ) 10/10/2022 10:08:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '109' 10/10/2022 10:08:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '109' , '1' ) 10/10/2022 10:11:51 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3525' 10/10/2022 10:11:51 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 ( '3525' , '10' , '183' , 'PARROCCHIA MARIA SS IMMACOLATA' , 'D\'AVINO' , 'DON DAVIDE ' , 'VIA CUTINELLI 1 - Località Ponte di Ferro' , '' , '80038' , 'POMIGLIANO D\'ARCO' , 'davide.davino@tiscali.it' , '' , '3926746140' , '' , '93004000639' , NOW() , NOW() ) 10/10/2022 10:11:51 am >> UPDATE ps_customer SET email = 'parmariassimm@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3525' 10/10/2022 10:12:28 am >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 10:12:28 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' , '156' , '2022-10-10' , '' , '3525' , '0' , '4670933' , 'VIA CUTINELLI 1 - Località Ponte di Ferro 80038 POMIGLIANO D\\\'ARCO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '136.00' , '136.00' , NOW() , NOW() ) 10/10/2022 10:12:28 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 = '65757' 10/10/2022 10:12:28 am >> DELETE FROM ps_document_detail WHERE id_document = '65757' 10/10/2022 10:12:28 am >> INSERT INTO ps_document_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.50' , '2.5' , '0' , '15' , '68.00' ) 10/10/2022 10:12:28 am >> INSERT INTO ps_document_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' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '50' , '-50' , '4' , '1.60' , '1.6' , '0' , '15' , '68.00' ) 10/10/2022 10:12:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3525' 10/10/2022 10:12:44 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 ( '3525' , '10' , '183' , 'PARROCCHIA MARIA SS IMMACOLATA' , 'D\'AVINO' , 'DON DAVIDE ' , 'VIA CUTINELLI 1 - Località Ponte di Ferro' , '' , '80038' , 'POMIGLIANO D\'ARCO' , 'davide.davino@tiscali.it' , '' , '3926746140' , '' , '93004000639' , NOW() , NOW() ) 10/10/2022 10:12:44 am >> UPDATE ps_customer SET email = 'parmariassimm@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3525' 10/10/2022 10:16:11 am >> UPDATE ps_document SET id_document_type = '33', document_num = '626732', document_date = '2022-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '129.00', price_tax_excluded = '129.00', date_upd = NOW() WHERE id_document = '65756' 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65756' 10/10/2022 10:16:11 am >> DELETE FROM ps_document_detail WHERE id_document = '65756' 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '20084' , 'CHIESA BRUCIA - A. RICCARDI' , '1' , '1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20084' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20084' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20085' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20085' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '1' , '4' , '11.50' , '11.5' , '0' , '0' , '11.50' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19764' , 'PRIMO PASSO - TACCUINO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '' , '1' ) 10/10/2022 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65756' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 10/10/2022 10:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19761' AND id_supplier = '' 10/10/2022 10:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19761' , '' , '1' ) 10/10/2022 10:32:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 10:32:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2989' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 10/10/2022 10:32:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65758' 10/10/2022 10:32:33 am >> DELETE FROM ps_document_detail WHERE id_document = '65758' 10/10/2022 10:32:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65758' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/10/2022 10:32:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 10/10/2022 10:32:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 10/10/2022 10:53:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 10:53: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 ( '11' , '2990' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 10/10/2022 10:53: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 = '65759' 10/10/2022 10:53:52 am >> DELETE FROM ps_document_detail WHERE id_document = '65759' 10/10/2022 10:53: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 ( '65759' , '20057' , 'CINQUE PANI DORZO 2023' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '' , '6.90' ) 10/10/2022 10:53:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '' 10/10/2022 10:53:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '' , '1' ) 10/10/2022 10:53: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 ( '65759' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 10/10/2022 10:53:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 10/10/2022 10:53:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 10/10/2022 11:05:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:05:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2991' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.10' , '93.10' , NOW() , NOW() ) 10/10/2022 11:05:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65760' 10/10/2022 11:05:44 am >> DELETE FROM ps_document_detail WHERE id_document = '65760' 10/10/2022 11:05:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65760' , '20084' , 'CHIESA BRUCIA - A. RICCARDI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 10/10/2022 11:05:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20084' AND id_supplier = '' 10/10/2022 11:05:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20084' , '' , '1' ) 10/10/2022 11:05:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65760' , '15327' , 'BATTESIMO E CONFERMAZIONE - P. BAU' , '1' , '-1' , '4' , '48.00' , '48' , '0' , '5' , '45.60' ) 10/10/2022 11:05:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '15327' AND id_supplier = '' 10/10/2022 11:05:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15327' , '' , '1' ) 10/10/2022 11:05:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65760' , '16215' , 'EUCARISTIA - A. GRILLO' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 10/10/2022 11:05:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16215' AND id_supplier = '' 10/10/2022 11:05:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16215' , '' , '1' ) 10/10/2022 11:07:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001571' AND id_product != '17277' AND ean13 != '' 10/10/2022 11:07:32 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '001571', date_upd = NOW() WHERE id_product = '17277' 10/10/2022 11:07:32 am >> UPDATE ps_product_lang SET name = 'BRACCIALE PIETRE DURE - 4633', description = '' WHERE id_product = '17277' 10/10/2022 11:07:32 am >> UPDATE ps_product SET wholesale_price = '2.38', on_sale = '0', price = '5.081967213114754' WHERE id_product = '17277' 10/10/2022 11:07:32 am >> UPDATE ps_product_shop SET wholesale_price = '2.38', price = '5.081967213114754', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17277' 10/10/2022 11:07:32 am >> DELETE FROM ps_specific_price WHERE id_product = '17277' 10/10/2022 11:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:08:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2992' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.65' , '62.41' , NOW() , NOW() ) 10/10/2022 11:08:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65761' 10/10/2022 11:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '65761' 10/10/2022 11:08:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65761' , '19583' , 'ROSARIO AL SACRO CUORE - 8063' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 10/10/2022 11:08:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19583' AND id_supplier = '' 10/10/2022 11:08:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19583' , '' , '1' ) 10/10/2022 11:08:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65761' , '8339' , 'PREGHIERE AL CUORE IMMACOLATO DI MARIA - 8155' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/10/2022 11:08:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8339' AND id_supplier = '' 10/10/2022 11:08:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8339' , '' , '1' ) 10/10/2022 11:08:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65761' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/10/2022 11:08:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '9647' AND id_supplier = '' 10/10/2022 11:08:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9647' , '' , '1' ) 10/10/2022 11:08:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65761' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/10/2022 11:08:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 10/10/2022 11:08:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 10/10/2022 11:08: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 ( '65761' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '12.40' ) 10/10/2022 11:08:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 10/10/2022 11:08:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 10/10/2022 11:12:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:12:07 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' , '2993' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.25' , '44.04' , NOW() , NOW() ) 10/10/2022 11:12:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65762' 10/10/2022 11:12:07 am >> DELETE FROM ps_document_detail WHERE id_document = '65762' 10/10/2022 11:12:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65762' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/10/2022 11:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 10/10/2022 11:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 10/10/2022 11:12:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65762' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 10/10/2022 11:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 10/10/2022 11:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 10/10/2022 11:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65762' , '3649' , 'DON ERNEST SIMONI - M. MUOLO' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '10' , '11.25' ) 10/10/2022 11:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '3649' AND id_supplier = '' 10/10/2022 11:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3649' , '' , '1' ) 10/10/2022 11:12:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:12:30 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' , '2994' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 10/10/2022 11:12:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65763' 10/10/2022 11:12:30 am >> DELETE FROM ps_document_detail WHERE id_document = '65763' 10/10/2022 11:12:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65763' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 10/10/2022 11:12:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 10/10/2022 11:12:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 10/10/2022 11:30:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:30:22 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' , '2995' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '17.62' , NOW() , NOW() ) 10/10/2022 11:30:22 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 = '65764' 10/10/2022 11:30:22 am >> DELETE FROM ps_document_detail WHERE id_document = '65764' 10/10/2022 11:30: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 ( '65764' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 10/10/2022 11:30:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '' 10/10/2022 11:30:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '' , '1' ) 10/10/2022 11:30: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 ( '65764' , '7217' , 'OLIO DI NARDO NATURALE - 1079/103ITA' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 10/10/2022 11:30:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '7217' AND id_supplier = '' 10/10/2022 11:30:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7217' , '' , '1' ) 10/10/2022 11:38:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:38:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2996' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '249.40' , '204.43' , NOW() , NOW() ) 10/10/2022 11:38:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65765' 10/10/2022 11:38:26 am >> DELETE FROM ps_document_detail WHERE id_document = '65765' 10/10/2022 11:38:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65765' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 10/10/2022 11:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 10/10/2022 11:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 10/10/2022 11:38:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65765' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 10/10/2022 11:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 10/10/2022 11:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 10/10/2022 11:38:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65765' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 10/10/2022 11:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 10/10/2022 11:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 10/10/2022 11:38:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65765' , '16612' , 'AMPOLLE FUSIONE VESUVIO - 1516' , '1' , '-1' , '1' , '149.00' , '122.13114754098' , '22' , '0' , '149.00' ) 10/10/2022 11:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16612' AND id_supplier = '' 10/10/2022 11:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16612' , '' , '1' ) 10/10/2022 11:52:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2995' AND id_document != '65764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 11:52:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2995', document_date = '2022-10-10', 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 = '21.50', price_tax_excluded = '17.62', date_upd = NOW() WHERE id_document = '65764' 10/10/2022 11:52:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65764' 10/10/2022 11:52:56 am >> DELETE FROM ps_document_detail WHERE id_document = '65764' 10/10/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65764' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 10/10/2022 11:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '' 10/10/2022 11:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '' , '1' ) 10/10/2022 11:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65764' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 10/10/2022 11:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/10/2022 11:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/10/2022 11:55:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884043092' AND id_product != '9647' AND ean13 != '' 10/10/2022 11:55:16 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884043092', date_upd = NOW() WHERE id_product = '9647' 10/10/2022 11:55:16 am >> UPDATE ps_product_lang SET name = 'SANTO ROSARIO - A. COMASTRI - 8627', description = '' WHERE id_product = '9647' 10/10/2022 11:55:16 am >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7' WHERE id_product = '9647' 10/10/2022 11:55:16 am >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9647' 10/10/2022 11:55:16 am >> DELETE FROM ps_specific_price WHERE id_product = '9647' 10/10/2022 12:02:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 12:02:49 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' , '2997' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 10/10/2022 12:02:49 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 = '65766' 10/10/2022 12:02:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '65766' 10/10/2022 12:02:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65766' , '19910' , 'LAMPADA COLORATA - 1490/KIT' , '1' , '-1' , '1' , '17.3' , '14.180327868852' , '22' , '0' , '17.30' ) 10/10/2022 12:02:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19910' AND id_supplier = '' 10/10/2022 12:02:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19910' , '' , '1' ) 10/10/2022 12:02:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65766' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '4.70' ) 10/10/2022 12:02:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 10/10/2022 12:02:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 10/10/2022 12:04:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2988' AND id_document != '65755' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 12:04:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2988', document_date = '2022-10-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '31.89', price_tax_excluded = '30.66', date_upd = NOW() WHERE id_document = '65755' 10/10/2022 12:04:13 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 = '65755' 10/10/2022 12:04:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '65755' 10/10/2022 12:04:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65755' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.8' , '5.5737704918033' , '22' , '0' , '6.80' ) 10/10/2022 12:04:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/10/2022 12:04:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/10/2022 12:04:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65755' , '19936' , 'SANTI PER IL CATECHISMO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 10/10/2022 12:04:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19936' AND id_supplier = '' 10/10/2022 12:04:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19936' , '' , '1' ) 10/10/2022 12:04:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65755' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 10/10/2022 12:04:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 10/10/2022 12:04:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' ) 10/10/2022 12:05:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229037' AND id_product != '19652' AND ean13 != '' 10/10/2022 12:05:42 pm >> UPDATE ps_product SET id_supplier = '7', reference = '4/3', ean13 = '9788892229037', date_upd = NOW() WHERE id_product = '19652' 10/10/2022 12:05:42 pm >> UPDATE ps_product_lang SET name = 'VANGELO IN FAMIGLIA', description = '' WHERE id_product = '19652' 10/10/2022 12:05:42 pm >> UPDATE ps_product SET wholesale_price = '1.94', on_sale = '0', price = '2.9000' WHERE id_product = '19652' 10/10/2022 12:05:42 pm >> UPDATE ps_product_shop SET wholesale_price = '1.94', price = '2.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19652' 10/10/2022 12:05:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19652' 10/10/2022 12:40:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022299267' , '2022-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '241.63' , '241.63' , NOW() , NOW() ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65767' 10/10/2022 12:40:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '65767' 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19915' , 'VITA LUNGA - PAPA FRANCESCO' , '2' , '0' , '4' , '12.4' , '12.4' , '0' , '0' , '24.8000' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19915' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19915' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '20024' , 'PER L\'ETERNITA\' - R. SARAH' , '2' , '0' , '4' , '16.55' , '16.55' , '0' , '0' , '33.1000' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20024' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20024' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '20023' , 'ALBINO LUCIANI' , '1' , '0' , '4' , '16.09' , '16.09' , '0' , '0' , '16.0900' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20023' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20023' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '2' , '0' , '4' , '15.84' , '15.84' , '0' , '0' , '31.6800' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16980' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16980' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19837' , 'ABBANDONATEVI A CRISTO - F. SHEEN' , '1' , '0' , '4' , '18' , '18' , '0' , '0' , '18.0000' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19837' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19837' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '1' , '0' , '4' , '18' , '18' , '0' , '0' , '18.0000' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19956' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19956' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19959' , 'PREGHIERE PER DUE' , '1' , '0' , '4' , '6.48' , '6.48' , '0' , '0' , '6.4800' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19959' AND id_supplier = '109' 10/10/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19959' , '109' , '1' ) 10/10/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19764' , 'PRIMO PASSO - TACCUINO' , '1' , '0' , '4' , '3.85' , '3.85' , '0' , '0' , '3.8500' ) 10/10/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '0' , '4' , '8.85' , '8.85' , '0' , '' , '8.8500' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '0' , '4' , '12.7' , '12.7' , '0' , '0' , '12.7000' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '2' , '0' , '4' , '12.7' , '12.7' , '0' , '0' , '25.4000' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '0' , '4' , '12.7' , '12.7' , '0' , '0' , '12.7000' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '0' , '4' , '12.7' , '12.7' , '0' , '0' , '12.7000' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '19306' , 'VITA SPIRITUALE - GARRIGOU - LANGRANGE' , '1' , '0' , '4' , '12.96' , '12.96' , '0' , '0' , '12.9600' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19306' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19306' , '109' , '1' ) 10/10/2022 12:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65767' , '20050' , 'PROJECTUS - G. COTICHELLA' , '1' , '0' , '4' , '4.32' , '4.32' , '0' , '0' , '4.3200' ) 10/10/2022 12:40:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20050' AND id_supplier = '109' 10/10/2022 12:40:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20050' , '109' , '1' ) 10/10/2022 12:43:32 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '6022299266', document_date = '2022-09-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = '', price_shipping = '-0.10', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '34.35', price_tax_excluded = '34.35', date_upd = NOW() WHERE id_document = '65224' 10/10/2022 12:43:32 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 = '65224' 10/10/2022 12:43:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '65224' 10/10/2022 12:43:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '19918' , 'LO RICONOBBERO NELLO SPEZZARE ... - E. MALNATI' , '1' , '0' , '4' , '8.0400' , '8.04' , '0' , '0' , '8.04' ) 10/10/2022 12:43:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19918' AND id_supplier = '' 10/10/2022 12:43:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19918' , '' , '1' ) 10/10/2022 12:43:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '20082' , 'UN GIORNO UNA PAROLA 2023' , '1' , '0' , '4' , '9.3800' , '9.38' , '0' , '0' , '9.38' ) 10/10/2022 12:43:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20082' AND id_supplier = '' 10/10/2022 12:43:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20082' , '' , '1' ) 10/10/2022 12:43:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '19958' , 'FINO IN CIMA - A. BELLO' , '1' , '0' , '4' , '9.3800' , '9.38' , '0' , '0' , '9.38' ) 10/10/2022 12:43:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19958' AND id_supplier = '' 10/10/2022 12:43:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19958' , '' , '1' ) 10/10/2022 12:43:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '0' , '4' , '7.6500' , '7.65' , '0' , '0' , '7.65' ) 10/10/2022 12:43:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20051' AND id_supplier = '' 10/10/2022 12:43:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20051' , '' , '1' ) 10/10/2022 12:48:39 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 ( '32' , '401' , '2022-09-30' , '' , '0' , '58' , '2653' , 'VIA COSTABELLA, 20-24 00195 ROMA' , '' , '' , '55' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '959.49' , '786.47' , NOW() , NOW() ) 10/10/2022 12:48: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 = '65768' 10/10/2022 12:48:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '65768' 10/10/2022 12:48: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 ( '65768' , '19997' , 'GESU BAMBINO CM 34 - BJ140-34E' , '10' , '0' , '1' , '18.6500' , '15.2869' , '22' , '0' , '227.53' ) 10/10/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19997' AND id_supplier = '58' 10/10/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19997' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '19996' , 'GESU BAMBINO CM 34 - BJ142/34E' , '5' , '0' , '1' , '18.6500' , '15.2869' , '22' , '0' , '113.77' ) 10/10/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19996' AND id_supplier = '58' 10/10/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19996' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '19998' , 'GESU BAMBINO CM 20 - BJ142-28E' , '5' , '0' , '1' , '13.7900' , '11.3033' , '22' , '0' , '84.12' ) 10/10/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19998' AND id_supplier = '58' 10/10/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19998' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '19999' , 'GESU BAMBINO CON AUREOLA CM 15 - BJ148-15' , '5' , '0' , '1' , '4.8200' , '3.9508' , '22' , '0' , '29.40' ) 10/10/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19999' AND id_supplier = '58' 10/10/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19999' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '20000' , 'GESU BAMBINO CM 15 - BJ140-15E' , '5' , '0' , '1' , '4.8200' , '3.9508' , '22' , '0' , '29.40' ) 10/10/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20000' AND id_supplier = '58' 10/10/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20000' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '5' , '0' , '1' , '4.8200' , '3.9508' , '22' , '0' , '29.40' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20001' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20001' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '5' , '0' , '1' , '4.8200' , '3.9508' , '22' , '0' , '29.40' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4381' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4381' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '20003' , 'GESU BAMBINO CM 4 - BJ140-4E' , '48' , '0' , '1' , '0.9100' , '0.7459' , '22' , '0' , '53.29' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20003' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20003' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '20004' , 'GESU BAMBINO CM 20 - BJ142-20E' , '5' , '0' , '1' , '8.5600' , '7.0164' , '22' , '0' , '52.22' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20004' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20004' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '20005' , 'GESU BAMBINO CON AUREOLA CM 20 - BJ148-20' , '5' , '0' , '1' , '8.5600' , '7.0164' , '22' , '0' , '52.22' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20005' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20005' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '20002' , 'GESU BAMBINO DORATO CM 20 - BJ146-20D' , '3' , '0' , '1' , '8.5600' , '7.0164' , '22' , '0' , '31.33' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20002' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20002' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '9447' , 'SAN GIORGIO CM 13 - SG/13E' , '1' , '0' , '1' , '11.5000' , '9.4262' , '22' , '0' , '14.03' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9447' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9447' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '17800' , 'GESU BAMBINO DI PRAGA CM 12' , '1' , '0' , '1' , '3.8000' , '3.1148' , '22' , '0' , '4.64' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17800' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17800' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '6098' , 'MADRE TERESA CM 13 - 023 MT/13' , '1' , '0' , '1' , '3.8000' , '3.1148' , '22' , '0' , '4.64' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6098' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6098' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '9552' , 'SANTA CHIARA CM 13 - 023 SCH/13E' , '1' , '0' , '1' , '3.5000' , '2.8689' , '22' , '0' , '4.27' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9552' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9552' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '9576' , 'SANTA LUCIA CM 13 - 023SL/13' , '1' , '0' , '1' , '3.5000' , '2.8689' , '22' , '0' , '4.27' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9576' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9576' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '2' , '0' , '1' , '3.6000' , '2.9508' , '22' , '0' , '8.78' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9464' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9464' , '58' , '1' ) 10/10/2022 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65768' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '2' , '0' , '1' , '2.9900' , '2.4508' , '22' , '0' , '7.30' ) 10/10/2022 12:48:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6075' AND id_supplier = '58' 10/10/2022 12:48:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6075' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '9209' , 'S. FAMIGLIA BABY - 023 HF/9 BB' , '3' , '0' , '1' , '4.3000' , '3.5246' , '22' , '0' , '15.74' ) 10/10/2022 12:48:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9209' AND id_supplier = '58' 10/10/2022 12:48:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9209' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '2' , '0' , '1' , '3.9200' , '3.2131' , '22' , '0' , '9.56' ) 10/10/2022 12:48:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '626' AND id_supplier = '58' 10/10/2022 12:48:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '626' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '13113' , 'GUADALUPE BABY - 023 GUA 9 BB' , '1' , '0' , '1' , '3.9900' , '3.2705' , '22' , '0' , '4.87' ) 10/10/2022 12:48:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13113' AND id_supplier = '58' 10/10/2022 12:48:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13113' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '18' , '0' , '1' , '3.1100' , '2.5492' , '22' , '0' , '68.30' ) 10/10/2022 12:48:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '739' AND id_supplier = '58' 10/10/2022 12:48:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '739' , '58' , '1' ) 10/10/2022 12:48: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 ( '65768' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '3' , '0' , '1' , '3.8000' , '3.1148' , '22' , '0' , '13.91' ) 10/10/2022 12:48:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10207' AND id_supplier = '58' 10/10/2022 12:48:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10207' , '58' , '1' ) 10/10/2022 12:54:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 12:54:53 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' , '157' , '2022-10-10' , '' , '3541' , '0' , '4671525' , 'CORSO DELLA REPUBBLICA 29 00060 MONTERANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '225.26' , '225.26' , NOW() , NOW() ) 10/10/2022 12:54:53 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 = '65769' 10/10/2022 12:54:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '65769' 10/10/2022 12:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65769' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 10/10/2022 12:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65769' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 10/10/2022 12:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65769' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 10/10/2022 12:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65769' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 10/10/2022 12:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65769' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 10/10/2022 01:12:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 01:12:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2998' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '31.73' , NOW() , NOW() ) 10/10/2022 01:12:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65770' 10/10/2022 01:12:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '65770' 10/10/2022 01:12: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 ( '65770' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 10/10/2022 01:12:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 10/10/2022 01:12:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 10/10/2022 01:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65770' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 10/10/2022 01:12:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 10/10/2022 01:12:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 10/10/2022 02:42:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '65752' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 02:42:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '155', document_date = '2022-10-10', document_letter = '', id_customer = '2312', id_supplier = '', id_address = '4675584', address1 = 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI', 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 = '272.43', price_tax_excluded = '272.43', date_upd = NOW() WHERE id_document = '65752' 10/10/2022 02:42: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 = '65752' 10/10/2022 02:42:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '65752' 10/10/2022 02:42: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 ( '65752' , '4154' , 'FESTA DEL PERDONO' , '22' , '-22' , '4' , '3.0000' , '3' , '0' , '15' , '56.10' ) 10/10/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 10/10/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 10/10/2022 02:42: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 ( '65752' , '8408' , 'PRENDETE E MANGIATE' , '22' , '-22' , '4' , '3.0000' , '3' , '0' , '15' , '56.10' ) 10/10/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 10/10/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 10/10/2022 02:42: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 ( '65752' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '18' , '-18' , '4' , '3.5000' , '3.5' , '0' , '15' , '53.55' ) 10/10/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 10/10/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 10/10/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.5000' , '2.5' , '0' , '15' , '44.63' ) 10/10/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 10/10/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 10/10/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 10/10/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 10/10/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 10/10/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '11191' , 'VENITE CON ME 1 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 10/10/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 10/10/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 10/10/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 10/10/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 10/10/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 10/10/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 10/10/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 10/10/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 10/10/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65752' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 10/10/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 10/10/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 10/10/2022 02:53:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3541' 10/10/2022 02:53:37 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 ( '3541' , '10' , '208' , 'PARR. SANTA MARIA ASSUNTA IN CIELO' , 'NIETO' , 'P. JAIME' , 'CORSO DELLA REPUBBLICA 29' , '' , '00060' , 'CANALE MONTERANO' , 'jaimenietocr@yahoo.com' , '' , '3408933012' , '' , '96112690589' , NOW() , NOW() ) 10/10/2022 02:53:37 pm >> UPDATE ps_customer SET email = 'parrococanalemonterano@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3541' 10/10/2022 04:23:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2978' AND id_document != '65229' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 10/10/2022 04:23:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2978', 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 = '111.18', price_tax_excluded = '102.18', date_upd = NOW() WHERE id_document = '65229' 10/10/2022 04:23:50 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 = '65229' 10/10/2022 04:23:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '65229' 10/10/2022 04:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65229' , '20078' , 'ROSARIO ARGENTO' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 10/10/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20078' AND id_supplier = '' 10/10/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20078' , '' , '1' ) 10/10/2022 04:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65229' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/10/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 10/10/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 10/10/2022 04:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65229' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 10/10/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8974' AND id_supplier = '' 10/10/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8974' , '' , '1' ) 10/10/2022 04:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65229' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '-1' , '4' , '39.5000' , '39.5' , '0' , '5' , '37.53' ) 10/10/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '' 10/10/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '' , '1' ) 10/10/2022 04:40:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318227' AND id_product != '16985' AND ean13 != '' 10/10/2022 04:40:40 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400318227', date_upd = NOW() WHERE id_product = '16985' 10/10/2022 04:40:40 pm >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE DORMIENTE - 4040', description = '' WHERE id_product = '16985' 10/10/2022 04:40:40 pm >> UPDATE ps_product SET wholesale_price = '5.80', on_sale = '0', price = '15.573770491803279' WHERE id_product = '16985' 10/10/2022 04:40:40 pm >> UPDATE ps_product_shop SET wholesale_price = '5.80', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16985' 10/10/2022 04:40:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '16985' 10/10/2022 04:42:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400108958' AND id_product != '14687' AND ean13 != '' 10/10/2022 04:42:48 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400108958', date_upd = NOW() WHERE id_product = '14687' 10/10/2022 04:42:48 pm >> UPDATE ps_product_lang SET name = 'CROCE DELL\'AMICIZIA IN ULIVO CM 18 - 2842', description = '' WHERE id_product = '14687' 10/10/2022 04:42:48 pm >> UPDATE ps_product SET wholesale_price = '7.95', on_sale = '0', price = '18.0327868852459' WHERE id_product = '14687' 10/10/2022 04:42:48 pm >> UPDATE ps_product_shop SET wholesale_price = '7.95', price = '18.0327868852459', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14687' 10/10/2022 04:42:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '14687' 10/10/2022 04:45:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000533' AND id_product != '2665' AND ean13 != '' 10/10/2022 04:45:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000533', date_upd = NOW() WHERE id_product = '2665' 10/10/2022 04:45:36 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE CROCE S. BENEDETTO - 1901', description = '' WHERE id_product = '2665' 10/10/2022 04:45:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.098360655737705' WHERE id_product = '2665' 10/10/2022 04:45:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.098360655737705', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2665' 10/10/2022 04:45:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '2665' 10/10/2022 04:48:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'A4054' , '2022-10-07' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '154.27' , '126.45' , NOW() , NOW() ) 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65771' 10/10/2022 04:48:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '65771' 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65771' , '14687' , 'CROCE DELL\'AMICIZIA IN ULIVO CM 18 - 2842' , '2' , '2' , '1' , '8.35' , '6.844262295082' , '22' , '0' , '20.3740' ) 10/10/2022 04:48:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14687' AND id_supplier = '28' 10/10/2022 04:48:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14687' , '28' , '1' ) 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65771' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '3' , '3' , '1' , '7.03' , '5.7622950819672' , '22' , '0' , '25.7298' ) 10/10/2022 04:48:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16985' AND id_supplier = '28' 10/10/2022 04:48:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16985' , '28' , '1' ) 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65771' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '6' , '6' , '1' , '2.39' , '1.9590163934426' , '22' , '0' , '17.4948' ) 10/10/2022 04:48:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28' 10/10/2022 04:48:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' ) 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65771' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '300' , '300' , '1' , '0.08' , '0.065573770491803' , '22' , '0' , '29.2800' ) 10/10/2022 04:48:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '28' 10/10/2022 04:48:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '28' , '1' ) 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65771' , '2665' , 'CONFEZIONE CROCE S. BENEDETTO - 1901' , '4' , '4' , '1' , '2.08' , '1.7049180327869' , '22' , '0' , '10.1504' ) 10/10/2022 04:48:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2665' AND id_supplier = '28' 10/10/2022 04:48:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2665' , '28' , '1' ) 10/10/2022 04:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65771' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '300' , '300' , '1' , '0.14' , '0.11475409836066' , '22' , '0' , '51.2400' ) 10/10/2022 04:48:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '28' 10/10/2022 04:48:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '28' , '1' ) 10/10/2022 05:52:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 05:52:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2999' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.30' , '5.31' , NOW() , NOW() ) 10/10/2022 05:52:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65772' 10/10/2022 05:52:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '65772' 10/10/2022 05:52:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65772' , '9118' , 'ROSARIO IN LEGNO FRANCESCANO - 7/P - RL348' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 10/10/2022 05:52:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9118' AND id_supplier = '' 10/10/2022 05:52:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9118' , '' , '1' ) 10/10/2022 05:52:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65772' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.8' , '0.8' , '0' , '0' , '0.80' ) 10/10/2022 05:52:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/10/2022 05:52:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/10/2022 06:22:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 06:22: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 ( '11' , '3000' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.21' , NOW() , NOW() ) 10/10/2022 06:22: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 = '65773' 10/10/2022 06:22:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '65773' 10/10/2022 06:22: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 ( '65773' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 10/10/2022 06:22:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19149' AND id_supplier = '' 10/10/2022 06:22:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19149' , '' , '1' ) 10/10/2022 06:22: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 ( '65773' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 10/10/2022 06:22:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/10/2022 06:22:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/10/2022 06:22: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 ( '65773' , '19753' , 'INCENSO GLORIA' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 10/10/2022 06:22:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19753' AND id_supplier = '' 10/10/2022 06:22:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19753' , '' , '1' ) 10/10/2022 07:03:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 07:03:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '158' , '2022-10-10' , '' , '1854' , '0' , '4671605' , 'PIAZZA S. GREGORIO 84020 SAN GREGORIO MAGNO' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '538.05' , '538.05' , NOW() , NOW() ) 10/10/2022 07:03:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65774' 10/10/2022 07:03:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '65774' 10/10/2022 07:03: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.50' , '3.5' , '0' , '15' , '59.50' ) 10/10/2022 07:03: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.50' , '3.5' , '0' , '15' , '119.00' ) 10/10/2022 07:03: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.00' , '5' , '0' , '15' , '12.75' ) 10/10/2022 07:03: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.50' , '3.5' , '0' , '15' , '89.25' ) 10/10/2022 07:03: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.50' , '3.5' , '0' , '15' , '89.25' ) 10/10/2022 07:03: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.00' , '10' , '0' , '15' , '8.50' ) 10/10/2022 07:03: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.50' , '3.5' , '0' , '15' , '119.00' ) 10/10/2022 07:03: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' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '30' , '-30' , '4' , '1.60' , '1.6' , '0' , '15' , '40.80' ) 10/10/2022 07:03:35 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') 10/10/2022 07:03:35 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.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 = '538.05', price_tax_excluded = '538.05', date_upd = NOW() WHERE id_document = '65774' 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65774' 10/10/2022 07:03:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '65774' 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 10/10/2022 07:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '30' , '-30' , '4' , '1.6000' , '1.6' , '0' , '15' , '40.80' ) 10/10/2022 07:03:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = '' 10/10/2022 07:03:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' ) 10/10/2022 07:15:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 07:15:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '76/A' , '2022-10-10' , 'A' , '1854' , '0' , '4671605' , 'PIAZZA S. GREGORIO 84020 SAN GREGORIO MAGNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 10/10/2022 07:15:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65775' 10/10/2022 07:15:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '65775' 10/10/2022 07:15: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 ( '65775' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 10/10/2022 07:26:08 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') 10/10/2022 07:26:08 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.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 = '538.05', price_tax_excluded = '538.05', date_upd = NOW() WHERE id_document = '65774' 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65774' 10/10/2022 07:26:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '65774' 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 10/10/2022 07:26:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65774' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '30' , '-30' , '4' , '1.6000' , '1.6' , '0' , '15' , '40.80' ) 10/10/2022 07:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = '' 10/10/2022 07:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' ) 10/10/2022 07:43:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 10/10/2022 07:43:49 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' , '3001' , '2022-10-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 10/10/2022 07:43:49 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 = '65776' 10/10/2022 07:43:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '65776' 10/10/2022 07:43:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65776' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 10/10/2022 07:43:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1544' AND id_supplier = '' 10/10/2022 07:43:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1544' , '' , '1' )