08/10/2022 08:28:20 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '5316' 08/10/2022 08:28:20 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 ( '5316' , '10' , '208' , '' , 'RAVIGLIA' , ' DON ALBERTO' , 'VIA 7 MARZO 12' , '' , '00037' , 'SEGNI' , 'ORDINA EGO MET ' , '' , '' , '' , '' , NOW() , NOW() ) 08/10/2022 08:28:20 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '5316' 08/10/2022 08:28:30 am >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '1775' 08/10/2022 08:29:19 am >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 08:29:20 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' , '92' , '2022-10-08' , '' , '5316' , '0' , '84014828' , 'VIA 7 MARZO 12 00037 SEGNI' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 08/10/2022 08:29:20 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 = '7143' 08/10/2022 08:29:20 am >> DELETE FROM ps_document_detail WHERE id_document = '7143' 08/10/2022 08:29:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7143' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 08/10/2022 09:29:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2972' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 09:29:09 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' , '2972' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.00' , '63.93' , NOW() , NOW() ) 08/10/2022 09:29:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65219' 08/10/2022 09:29:09 am >> DELETE FROM ps_document_detail WHERE id_document = '65219' 08/10/2022 09:29:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65219' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '54.00' ) 08/10/2022 09:29:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 08/10/2022 09:29:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 08/10/2022 09:29:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65219' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 08/10/2022 09:29:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19819' AND id_supplier = '' 08/10/2022 09:29:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19819' , '' , '1' ) 08/10/2022 09:31:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2973' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 09:31:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2973' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.90' , '76.66' , NOW() , NOW() ) 08/10/2022 09:31:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65220' 08/10/2022 09:31:48 am >> DELETE FROM ps_document_detail WHERE id_document = '65220' 08/10/2022 09:31:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65220' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/10/2022 09:31:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 08/10/2022 09:31:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 08/10/2022 09:31:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65220' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '3.5' , '3.5' , '0' , '0' , '21.00' ) 08/10/2022 09:31:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 08/10/2022 09:31:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 08/10/2022 09:31:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65220' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '11.50' ) 08/10/2022 09:31:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 08/10/2022 09:31:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 08/10/2022 10:10:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '34' , '6022018080' , '2022-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.10' , '9.10' , NOW() , NOW() ) 08/10/2022 10:10:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65221' 08/10/2022 10:10:59 am >> DELETE FROM ps_document_detail WHERE id_document = '65221' 08/10/2022 10:10:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65221' , '18506' , 'UN GIORNO UNA PAROLA' , '1' , '0' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 08/10/2022 10:10:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18506' AND id_supplier = '109' 08/10/2022 10:10:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18506' , '109' , '1' ) 08/10/2022 10:14:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2365' , '2022-09-30' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '14.13' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.27' , '199.27' , NOW() , NOW() ) 08/10/2022 10:14:27 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 = '65222' 08/10/2022 10:14:27 am >> DELETE FROM ps_document_detail WHERE id_document = '65222' 08/10/2022 10:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65222' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '12' , '0' , '4' , '1.0000' , '1' , '0' , '30' , '8.40' ) 08/10/2022 10:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 08/10/2022 10:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 08/10/2022 10:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65222' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '1' , '0' , '4' , '1.0000' , '1' , '0' , '100' , '0.00' ) 08/10/2022 10:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 08/10/2022 10:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 08/10/2022 10:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65222' , '19975' , 'POSTINO DI DIO - A. LUCIANI' , '2' , '0' , '4' , '19.0000' , '19' , '0' , '30' , '26.60' ) 08/10/2022 10:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19975' AND id_supplier = '47' 08/10/2022 10:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19975' , '47' , '1' ) 08/10/2022 10:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65222' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '2' , '0' , '4' , '12.9000' , '12.9' , '0' , '27' , '18.83' ) 08/10/2022 10:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '47' 08/10/2022 10:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '47' , '1' ) 08/10/2022 10:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65222' , '20018' , 'VITA DI GESU - A. TORNIELLI' , '3' , '0' , '4' , '17.9000' , '17.9' , '0' , '27' , '39.20' ) 08/10/2022 10:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '20018' AND id_supplier = '47' 08/10/2022 10:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20018' , '47' , '1' ) 08/10/2022 10:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65222' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '2' , '0' , '4' , '12.9000' , '12.9' , '0' , '27' , '18.83' ) 08/10/2022 10:14:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '47' 08/10/2022 10:14:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '47' , '1' ) 08/10/2022 10:14: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 ( '65222' , '20019' , 'DARE IL CUORE AI MISERI - G. PAIS' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 08/10/2022 10:14:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20019' AND id_supplier = '47' 08/10/2022 10:14:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20019' , '47' , '1' ) 08/10/2022 10:14: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 ( '65222' , '20020' , 'INVIDIA IL MORSO DEL DIAVOLO - P. LIVIO FANZAGA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '27' , '11.68' ) 08/10/2022 10:14:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20020' AND id_supplier = '47' 08/10/2022 10:14:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20020' , '47' , '1' ) 08/10/2022 10:14: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 ( '65222' , '20017' , 'CHI DORME NON PIGLIA CRISTO - M. POZZA' , '4' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '44.80' ) 08/10/2022 10:14:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20017' AND id_supplier = '47' 08/10/2022 10:14:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20017' , '47' , '1' ) 08/10/2022 10:14: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 ( '65222' , '10525' , 'TEMPO DI LIBERAZIONE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 08/10/2022 10:14:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '10525' AND id_supplier = '47' 08/10/2022 10:14:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10525' , '47' , '1' ) 08/10/2022 10:24: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 ( '32' , '6022299268' , '2022-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.1' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '158.69' , '158.69' , NOW() , NOW() ) 08/10/2022 10:24: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 = '65223' 08/10/2022 10:24:15 am >> DELETE FROM ps_document_detail WHERE id_document = '65223' 08/10/2022 10:24: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 ( '65223' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '2' , '0' , '4' , '26.23' , '26.23' , '0' , '' , '52.4600' ) 08/10/2022 10:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 08/10/2022 10:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 08/10/2022 10:24: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 ( '65223' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '0' , '4' , '12.62' , '12.62' , '0' , '0' , '12.6200' ) 08/10/2022 10:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '109' 08/10/2022 10:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '109' , '1' ) 08/10/2022 10:24: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 ( '65223' , '12899' , 'LODE A TE, SIGNORE' , '10' , '0' , '4' , '2.78' , '2.78' , '0' , '0' , '27.8000' ) 08/10/2022 10:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '12899' AND id_supplier = '109' 08/10/2022 10:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12899' , '109' , '1' ) 08/10/2022 10:24: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 ( '65223' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '0' , '4' , '27.76' , '27.76' , '0' , '0' , '27.7600' ) 08/10/2022 10:24:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 08/10/2022 10:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 08/10/2022 10:24: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 ( '65223' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '0' , '4' , '13.35' , '13.35' , '0' , '0' , '13.3500' ) 08/10/2022 10:24:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '109' 08/10/2022 10:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '109' , '1' ) 08/10/2022 10:24: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 ( '65223' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '0' , '4' , '24.6' , '24.6' , '0' , '0' , '24.6000' ) 08/10/2022 10:24:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 08/10/2022 10:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 08/10/2022 10:29:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/10/2022 10:29:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20082' , '1' , '' , 'nuovo-prodotto' ) 08/10/2022 10:29:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20082' , '1' , '1' , '2' , NOW() , NOW() ) 08/10/2022 10:29:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20082' , '0' , '1' , '0' , '0' ) 08/10/2022 10:30:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868983628' AND id_product != '20082' AND ean13 != '' 08/10/2022 10:30:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868983628', date_upd = NOW() WHERE id_product = '20082' 08/10/2022 10:30:41 am >> UPDATE ps_product_lang SET name = 'UN GIORNO UNA PAROLA 2023', description = '' WHERE id_product = '20082' 08/10/2022 10:30:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20082' 08/10/2022 10:30:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '0', id_category_default = '257', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20082' 08/10/2022 10:30:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20082' 08/10/2022 10:31:33 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/10/2022 10:31:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20083' , '1' , '' , 'nuovo-prodotto' ) 08/10/2022 10:31:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20083' , '1' , '1' , '2' , NOW() , NOW() ) 08/10/2022 10:31:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20083' , '0' , '1' , '0' , '0' ) 08/10/2022 10:32:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868983628' AND id_product != '20082' AND ean13 != '' 08/10/2022 10:32:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868983628', date_upd = NOW() WHERE id_product = '20082' 08/10/2022 10:32:28 am >> UPDATE ps_product_lang SET name = 'UN GIORNO UNA PAROLA 2023', description = '' WHERE id_product = '20082' 08/10/2022 10:32:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20082' 08/10/2022 10:32:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '257', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20082' 08/10/2022 10:32:28 am >> DELETE FROM ps_specific_price WHERE id_product = '20082' 08/10/2022 10:32:42 am >> UPDATE ps_document SET id_document_type = '34', document_num = '6022018080', 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.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 = '9.10', price_tax_excluded = '9.10', date_upd = NOW() WHERE id_document = '65221' 08/10/2022 10:32:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65221' 08/10/2022 10:32:42 am >> DELETE FROM ps_document_detail WHERE id_document = '65221' 08/10/2022 10:32:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65221' , '20082' , 'UN GIORNO UNA PAROLA 2023' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 08/10/2022 10:32:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '20082' AND id_supplier = '' 08/10/2022 10:32:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20082' , '' , '1' ) 08/10/2022 10:35:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022299266' , '2022-10-08' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '-0.1' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.35' , '34.35' , NOW() , NOW() ) 08/10/2022 10:35:02 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 = '65224' 08/10/2022 10:35:02 am >> DELETE FROM ps_document_detail WHERE id_document = '65224' 08/10/2022 10:35:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '19918' , 'LO RICONOBBERO NELLO SPEZZARE ... - E. MALNATI' , '1' , '0' , '4' , '8.04' , '8.04' , '0' , '0' , '8.0400' ) 08/10/2022 10:35:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19918' AND id_supplier = '109' 08/10/2022 10:35:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19918' , '109' , '1' ) 08/10/2022 10:35:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '20082' , 'UN GIORNO UNA PAROLA 2023' , '1' , '0' , '4' , '9.38' , '9.38' , '0' , '0' , '9.3800' ) 08/10/2022 10:35:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20082' AND id_supplier = '109' 08/10/2022 10:35:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20082' , '109' , '1' ) 08/10/2022 10:35:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '19958' , 'FINO IN CIMA - A. BELLO' , '1' , '0' , '4' , '9.38' , '9.38' , '0' , '0' , '9.3800' ) 08/10/2022 10:35:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19958' AND id_supplier = '109' 08/10/2022 10:35:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19958' , '109' , '1' ) 08/10/2022 10:35:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65224' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '0' , '4' , '7.65' , '7.65' , '0' , '0' , '7.6500' ) 08/10/2022 10:35:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20051' AND id_supplier = '109' 08/10/2022 10:35:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20051' , '109' , '1' ) 08/10/2022 11:06:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2974' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:06:23 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' , '2974' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '242.20' , '209.03' , NOW() , NOW() ) 08/10/2022 11:06:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65225' 08/10/2022 11:06:23 am >> DELETE FROM ps_document_detail WHERE id_document = '65225' 08/10/2022 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 08/10/2022 11:06:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 08/10/2022 11:06:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 08/10/2022 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 08/10/2022 11:06:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 08/10/2022 11:06:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 08/10/2022 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/10/2022 11:06:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 08/10/2022 11:06:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 08/10/2022 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '16147' , 'SCOPRIAMO LA MESSA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16147' AND id_supplier = '' 08/10/2022 11:06:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16147' , '' , '1' ) 08/10/2022 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '18666' , 'SCOPRIAMO LA BIBBIA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18666' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18666' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '17517' , 'SCOPRIAMO INSIEME GESU' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '17517' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17517' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '19565' , 'SCOPRIAMO INSIEME SEGNI E SIMBOLI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '19294' , 'SCOPRIAMO INSIEME IL VANGELO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19294' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19294' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18064' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18064' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '18168' , 'SCATOLA PORTAOSTIE ' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18168' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18168' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 08/10/2022 11:06:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 08/10/2022 11:06:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65225' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2022 11:06:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 08/10/2022 11:06:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 08/10/2022 11:06: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 ( '65225' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2022 11:06:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 08/10/2022 11:06:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 08/10/2022 11:06: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 ( '65225' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2022 11:06:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 08/10/2022 11:06:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 08/10/2022 11:06: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 ( '65225' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2022 11:06:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 08/10/2022 11:06:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 08/10/2022 11:14:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2975' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:14:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2975' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '11.54' , NOW() , NOW() ) 08/10/2022 11:14:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65226' 08/10/2022 11:14:00 am >> DELETE FROM ps_document_detail WHERE id_document = '65226' 08/10/2022 11:14:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65226' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 08/10/2022 11:14:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 08/10/2022 11:14:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 08/10/2022 11:27:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2976' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:27:23 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' , '2976' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.30' , NOW() , NOW() ) 08/10/2022 11:27:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65227' 08/10/2022 11:27:23 am >> DELETE FROM ps_document_detail WHERE id_document = '65227' 08/10/2022 11:27:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65227' , '19652' , 'vangelo in famiglia' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/10/2022 11:27:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19652' AND id_supplier = '' 08/10/2022 11:27:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19652' , '' , '1' ) 08/10/2022 11:27:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65227' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 08/10/2022 11:27:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 08/10/2022 11:27:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 08/10/2022 11:29:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2977' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:29:47 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' , '2977' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.96' , '170.54' , NOW() , NOW() ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65228' 08/10/2022 11:29:47 am >> DELETE FROM ps_document_detail WHERE id_document = '65228' 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19931' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19931' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '20' , '-20' , '4' , '2.7' , '2.7' , '0' , '0' , '54.00' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '15' , '-15' , '4' , '2.7' , '2.7' , '0' , '0' , '40.50' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 08/10/2022 11:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 08/10/2022 11:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/10/2022 11:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 08/10/2022 11:29:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 08/10/2022 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65228' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 08/10/2022 11:29:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 08/10/2022 11:29:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 08/10/2022 11:38:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2978' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:38:27 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' , '2978' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.18' , '102.18' , NOW() , NOW() ) 08/10/2022 11:38:27 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 = '65229' 08/10/2022 11:38:27 am >> DELETE FROM ps_document_detail WHERE id_document = '65229' 08/10/2022 11:38:27 am >> INSERT INTO ps_document_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' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49.9' , '40.901639344262' , '22' , '0' , '49.90' ) 08/10/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 08/10/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 08/10/2022 11:38:27 am >> INSERT INTO ps_document_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.00' , '10' , '0' , '5' , '9.50' ) 08/10/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 08/10/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 08/10/2022 11:38:27 am >> INSERT INTO ps_document_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.00' , '15' , '0' , '5' , '14.25' ) 08/10/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '8974' AND id_supplier = '' 08/10/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8974' , '' , '1' ) 08/10/2022 11:38:27 am >> INSERT INTO ps_document_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.50' , '39.5' , '0' , '5' , '37.53' ) 08/10/2022 11:38:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '' 08/10/2022 11:38:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '' , '1' ) 08/10/2022 11:40:40 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:40:40 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' , '153' , '2022-10-08' , '' , '541' , '0' , '4671522' , 'VIA GALLIANO 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '175.54' , '175.54' , NOW() , NOW() ) 08/10/2022 11:40:40 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' 08/10/2022 11:40:40 am >> DELETE FROM ps_document_detail WHERE id_document = '65230' 08/10/2022 11:40:40 am >> INSERT INTO ps_document_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.50' , '3.5' , '0' , '15' , '38.68' ) 08/10/2022 11:40:40 am >> INSERT INTO ps_document_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.50' , '3.5' , '0' , '15' , '44.63' ) 08/10/2022 11:40:40 am >> INSERT INTO ps_document_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.50' , '3.5' , '0' , '15' , '92.23' ) 08/10/2022 11:46:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2979' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 11:46: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' , '2979' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 08/10/2022 11:46: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 = '65231' 08/10/2022 11:46:17 am >> DELETE FROM ps_document_detail WHERE id_document = '65231' 08/10/2022 11:46: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 ( '65231' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '4' , '-4' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '13.20' ) 08/10/2022 11:46:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 08/10/2022 11:46:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 08/10/2022 12:05:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 12:05:22 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' , '2980' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 08/10/2022 12:05:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65232' 08/10/2022 12:05:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '65232' 08/10/2022 12:05:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65232' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 08/10/2022 12:05:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 08/10/2022 12:05:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 08/10/2022 12:06:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2961' AND id_document != '65202' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 08/10/2022 12:06:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2961', document_date = '2022-10-07', 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 = '7.50', price_tax_excluded = '7.50', date_upd = NOW() WHERE id_document = '65202' 08/10/2022 12:06: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 = '65202' 08/10/2022 12:06:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '65202' 08/10/2022 12:06: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 ( '65202' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 08/10/2022 12:06:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 08/10/2022 12:06:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 08/10/2022 12:06: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 ( '65202' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 08/10/2022 12:06:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 08/10/2022 12:06:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 08/10/2022 12:06: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 ( '65202' , '2083' , 'CINQUE PRIMI SABATI DEL MESE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 08/10/2022 12:06:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2083' AND id_supplier = '' 08/10/2022 12:06:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2083' , '' , '1' ) 08/10/2022 12:11:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 12:11:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2981' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 08/10/2022 12:11:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65233' 08/10/2022 12:11:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '65233' 08/10/2022 12:11: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 ( '65233' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 08/10/2022 12:11:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 08/10/2022 12:11:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 08/10/2022 12:21:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 12:21:13 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' , '2982' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 08/10/2022 12:21: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 = '65234' 08/10/2022 12:21:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '65234' 08/10/2022 12:21: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 ( '65234' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 08/10/2022 12:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16190' AND id_supplier = '' 08/10/2022 12:21:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16190' , '' , '1' ) 08/10/2022 12:29:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 12:29:02 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' , '2983' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 08/10/2022 12:29:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65235' 08/10/2022 12:29:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '65235' 08/10/2022 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65235' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 08/10/2022 12:29:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12527' AND id_supplier = '' 08/10/2022 12:29:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12527' , '' , '1' ) 08/10/2022 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65235' , '12529' , 'LAMPADA A SFERA VERDE' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 08/10/2022 12:29:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12529' AND id_supplier = '' 08/10/2022 12:29:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12529' , '' , '1' ) 08/10/2022 12:31:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 08/10/2022 12:31:02 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' , '2984' , '2022-10-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 08/10/2022 12:31:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65236' 08/10/2022 12:31:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '65236' 08/10/2022 12:31:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65236' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/10/2022 12:31:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 08/10/2022 12:31:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 08/10/2022 12:40:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830725416' AND id_product != '20047' AND ean13 != '' 08/10/2022 12:40:27 pm >> UPDATE ps_product SET id_supplier = '109', reference = '', ean13 = '9788830725416', date_upd = NOW() WHERE id_product = '20047' 08/10/2022 12:40:27 pm >> UPDATE ps_product_lang SET name = 'AGENDA MISSIONARIA 2023', description = '' WHERE id_product = '20047' 08/10/2022 12:40:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '20047' 08/10/2022 12:40:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '85', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20047' 08/10/2022 12:40:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '20047' 08/10/2022 12:40:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830725423' AND id_product != '20048' AND ean13 != '' 08/10/2022 12:40:34 pm >> UPDATE ps_product SET id_supplier = '109', reference = '', ean13 = '9788830725423', date_upd = NOW() WHERE id_product = '20048' 08/10/2022 12:40:34 pm >> UPDATE ps_product_lang SET name = 'AGENDA MISSIONARIA 2023', description = '' WHERE id_product = '20048' 08/10/2022 12:40:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '20048' 08/10/2022 12:40:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '85', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20048' 08/10/2022 12:40:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '20048' 08/10/2022 12:41:21 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' , '6022299265' , '2022-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.58' , '153.58' , NOW() , NOW() ) 08/10/2022 12:41:21 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 = '65237' 08/10/2022 12:41:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '65237' 08/10/2022 12:41:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19914' , 'FORZA DELLE VIRTU - C.M. MARTINI' , '1' , '0' , '4' , '10.05' , '10.05' , '0' , '0' , '10.0500' ) 08/10/2022 12:41:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19914' AND id_supplier = '109' 08/10/2022 12:41:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19914' , '109' , '1' ) 08/10/2022 12:41:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19916' , 'VINO NUOVO IN OTRI NUOVI ANNO A - R. GIUE' , '1' , '0' , '4' , '17.09' , '17.09' , '0' , '0' , '17.0900' ) 08/10/2022 12:41:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19916' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19916' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19917' , 'RUMINARE LE SCRITTURE - F. MOSCONI' , '1' , '0' , '4' , '5.47' , '5.47' , '0' , '0' , '5.4700' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19917' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19917' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19913' , 'PARLARE DELLE SCRITTURE - P. BEAUCHAMP' , '1' , '0' , '4' , '9.38' , '9.38' , '0' , '0' , '9.3800' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19913' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19913' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '20025' , 'LECTIO DIVINA SUL VANGELO DI MARCO' , '1' , '0' , '4' , '23.93' , '23.93' , '0' , '' , '23.9300' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20025' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20025' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19955' , 'SAN FRANCESCO DI SALES - G. JEANGUENIN' , '1' , '0' , '4' , '9.38' , '9.38' , '0' , '0' , '9.3800' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19955' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19955' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '1' , '0' , '4' , '16.75' , '16.75' , '0' , '0' , '16.7500' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19956' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19956' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '17254' , 'PADRE NOSTRO PER I PICCOLI - M. BALDACCI' , '1' , '0' , '4' , '9.31' , '9.31' , '0' , '0' , '9.3100' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17254' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17254' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '19957' , 'ESERCIZI SPIRITUALI CON SAN PAOLO - B. SECONDIN' , '1' , '0' , '4' , '10.05' , '10.05' , '0' , '0' , '10.0500' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19957' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19957' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '20047' , 'AGENDA MISSIONARIA 2023' , '1' , '0' , '4' , '8.7' , '8.7' , '0' , '0' , '8.7000' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20047' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20047' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '20048' , 'AGENDA MISSIONARIA 2023' , '1' , '0' , '4' , '7.37' , '7.37' , '0' , '0' , '7.3700' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20048' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20048' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '20052' , 'DOMANDE SU DIO - A. PAIRETTI' , '1' , '0' , '4' , '10.01' , '10.01' , '0' , '0' , '10.0100' ) 08/10/2022 12:41:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20052' AND id_supplier = '109' 08/10/2022 12:41:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20052' , '109' , '1' ) 08/10/2022 12:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65237' , '20049' , 'MANUALE PER CATECHISTI DISPERATI' , '1' , '0' , '4' , '16.09' , '16.09' , '0' , '0' , '16.0900' ) 08/10/2022 12:41:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20049' AND id_supplier = '109' 08/10/2022 12:41:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20049' , '109' , '1' )