13/10/2023 08:47:24 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' , '4773' , '2023-10-11' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '161.00' , '161.00' , NOW() , NOW() ) 13/10/2023 08:47:24 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 = '88259' 13/10/2023 08:47:24 am >> DELETE FROM ps_document_detail WHERE id_document = '88259' 13/10/2023 08:47: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 ( '88259' , '19383' , 'EVANGELO COFANETTO - VALTORTA' , '1' , '1' , '4' , '230.00' , '230' , '0' , '30' , '161.0000' ) 13/10/2023 08:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19383' AND id_supplier = '47' 13/10/2023 08:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19383' , '47' , '1' ) 13/10/2023 09:06: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 ( '32' , '6023284852' , '2023-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.23' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '120.48' , '120.48' , NOW() , NOW() ) 13/10/2023 09:06: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 = '88260' 13/10/2023 09:06:44 am >> DELETE FROM ps_document_detail WHERE id_document = '88260' 13/10/2023 09:06: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 ( '88260' , '2640' , 'CONFESSIONI - S. AGOSTINO ' , '1' , '0' , '4' , '5.6' , '5.6' , '0' , '0' , '5.6000' ) 13/10/2023 09:06:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '2640' AND id_supplier = '109' 13/10/2023 09:06:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2640' , '109' , '1' ) 13/10/2023 09:06: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 ( '88260' , '21428' , 'TOCCA A TE - GUIDA 2023/24 GIOVANI' , '2' , '0' , '4' , '8.625' , '8.625' , '0' , '0' , '17.2500' ) 13/10/2023 09:06:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21428' AND id_supplier = '109' 13/10/2023 09:06:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21428' , '109' , '1' ) 13/10/2023 09:06: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 ( '88260' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '0' , '4' , '20.3' , '20.3' , '0' , '0' , '40.6000' ) 13/10/2023 09:06:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21616' AND id_supplier = '109' 13/10/2023 09:06:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21616' , '109' , '1' ) 13/10/2023 09:06: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 ( '88260' , '21619' , 'IO AVRO\' CURA DI TE - PAPA FRANCESCO' , '1' , '0' , '4' , '10.3' , '10.3' , '0' , '0' , '10.3000' ) 13/10/2023 09:06:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '21619' AND id_supplier = '109' 13/10/2023 09:06:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21619' , '109' , '1' ) 13/10/2023 09:06: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 ( '88260' , '21476' , 'QUESTA CASA E TUA 3 - 12/14 ANNI' , '2' , '0' , '4' , '12.375' , '12.375' , '0' , '0' , '24.7500' ) 13/10/2023 09:06:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '21476' AND id_supplier = '109' 13/10/2023 09:06:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21476' , '109' , '1' ) 13/10/2023 09:06: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 ( '88260' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '2' , '0' , '4' , '9.375' , '9.375' , '0' , '0' , '18.7500' ) 13/10/2023 09:06:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '21475' AND id_supplier = '109' 13/10/2023 09:06:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21475' , '109' , '1' ) 13/10/2023 09:09:51 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' , '2234' , '2023-09-30' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.26' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.41' , '57.41' , NOW() , NOW() ) 13/10/2023 09:09:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88261' 13/10/2023 09:09:51 am >> DELETE FROM ps_document_detail WHERE id_document = '88261' 13/10/2023 09:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88261' , '21603' , 'SAN PIO DA PIETRALCINA MAESTRO DI VITA - GUARINO/STANZIONE' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 13/10/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21603' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21603' , '47' , '1' ) 13/10/2023 09:09: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 ( '88261' , '21604' , 'PARABOLIAMONE - AAVV' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 13/10/2023 09:09:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21604' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21604' , '47' , '1' ) 13/10/2023 09:09: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 ( '88261' , '21605' , 'PADRE MATTEO LA GRUA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 13/10/2023 09:09:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21605' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21605' , '47' , '1' ) 13/10/2023 09:09: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 ( '88261' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 13/10/2023 09:09:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21606' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21606' , '47' , '1' ) 13/10/2023 09:09: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 ( '88261' , '21607' , 'O GESU MI ABBANDONO A TE - DOLINDO RUOTOLO' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '30' , '6.65' ) 13/10/2023 09:09:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21607' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21607' , '47' , '1' ) 13/10/2023 09:09: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 ( '88261' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '12' , '0' , '4' , '1.0000' , '1' , '0' , '30' , '8.40' ) 13/10/2023 09:09:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 13/10/2023 09:09: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 ( '88261' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '1' , '0' , '4' , '1.0000' , '1' , '0' , '100' , '0.00' ) 13/10/2023 09:09:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 13/10/2023 09:09:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 13/10/2023 09:15:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 09:15:24 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' , '3148' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.70' , '1.52' , NOW() , NOW() ) 13/10/2023 09:15:24 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 = '88262' 13/10/2023 09:15:24 am >> DELETE FROM ps_document_detail WHERE id_document = '88262' 13/10/2023 09:15: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 ( '88262' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 13/10/2023 09:15: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 ( '88262' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 13/10/2023 09:18:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023284854' , '2023-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.28' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '9.38' , '9.38' , NOW() , NOW() ) 13/10/2023 09:18:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88263' 13/10/2023 09:18:05 am >> DELETE FROM ps_document_detail WHERE id_document = '88263' 13/10/2023 09:18:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88263' , '21551' , 'PRIMA NASCITA E LA SECONDA - G. ANGELINI' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 13/10/2023 09:18:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '21551' AND id_supplier = '109' 13/10/2023 09:18:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21551' , '109' , '1' ) 13/10/2023 09:27:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3149' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 09:27: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 ( '11' , '3149' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 13/10/2023 09:27: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 = '88264' 13/10/2023 09:27:15 am >> DELETE FROM ps_document_detail WHERE id_document = '88264' 13/10/2023 09:27: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 ( '88264' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 13/10/2023 09:37:07 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('2023-10-13') 13/10/2023 09:37: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 ( '21' , '153' , '2023-10-13' , '' , '1854' , '0' , '4671605' , 'PIAZZA S. GREGORIO 84020 SAN GREGORIO MAGNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.95' , '22.95' , NOW() , NOW() ) 13/10/2023 09:37: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 = '88265' 13/10/2023 09:37:07 am >> DELETE FROM ps_document_detail WHERE id_document = '88265' 13/10/2023 09:37: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 ( '88265' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 13/10/2023 09:37: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 ( '88265' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 13/10/2023 09:37:29 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '88265' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 09:37:29 am >> UPDATE ps_document SET id_document_type = '21', document_num = '153', document_date = '2023-10-13', 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 = '1', id_causal = '0', price_tax_included = '22.95', price_tax_excluded = '22.95', date_upd = NOW() WHERE id_document = '88265' 13/10/2023 09:37:29 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 = '88265' 13/10/2023 09:37:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88265' 13/10/2023 09:37: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 ( '88265' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 13/10/2023 09:37: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 ( '88265' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 13/10/2023 09:52:51 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' , '6023284851' , '2023-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.72' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '91.03' , '91.03' , NOW() , NOW() ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88266' 13/10/2023 09:52:51 am >> DELETE FROM ps_document_detail WHERE id_document = '88266' 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '21549' , 'VIE DELLA PREGHIERA - A. BARBAN' , '1' , '0' , '4' , '7.8' , '7.8' , '0' , '0' , '7.8000' ) 13/10/2023 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21549' AND id_supplier = '109' 13/10/2023 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21549' , '109' , '1' ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '21550' , 'MANUALE DEL DIAVOLO - R. CAMILLERI' , '1' , '0' , '4' , '14.94' , '14.94' , '0' , '0' , '14.9400' ) 13/10/2023 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21550' AND id_supplier = '109' 13/10/2023 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21550' , '109' , '1' ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '21554' , 'CATECHESI CREATIVA 2 - A. QUEIROLO' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 13/10/2023 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21554' AND id_supplier = '109' 13/10/2023 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21554' , '109' , '1' ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '21552' , 'GESU DI TUTTI - V. ANDREOLI' , '1' , '0' , '4' , '16.9' , '16.9' , '0' , '0' , '16.9000' ) 13/10/2023 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21552' AND id_supplier = '109' 13/10/2023 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21552' , '109' , '1' ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '21617' , 'SINFONIA DELLA PAROLA - F. MANNS' , '1' , '0' , '4' , '11.7' , '11.7' , '0' , '0' , '11.7000' ) 13/10/2023 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21617' AND id_supplier = '109' 13/10/2023 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21617' , '109' , '1' ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '21618' , 'TRASMETTERE LA FEDE - SALZANO/ACUTIS' , '2' , '0' , '4' , '9.095' , '9.095' , '0' , '0' , '18.1900' ) 13/10/2023 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21618' AND id_supplier = '109' 13/10/2023 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21618' , '109' , '1' ) 13/10/2023 09:52:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88266' , '8769' , 'RACCONTA LA BIBBIA AI TUOI RAGAZZI' , '1' , '0' , '4' , '9.68' , '9.68' , '0' , '0' , '9.6800' ) 13/10/2023 09:52:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '8769' AND id_supplier = '109' 13/10/2023 09:52:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8769' , '109' , '1' ) 13/10/2023 09:56:51 am >> SELECT document_num FROM ps_document WHERE document_num = '6023284853' AND id_document != '' AND id_document_type LIKE '22' AND YEAR(document_date) = YEAR('2023-09-30') 13/10/2023 09:56:51 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 ( '22' , '6023284853' , '2023-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.1' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '73.32' , '73.32' , NOW() , NOW() ) 13/10/2023 09:56:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88267' 13/10/2023 09:56:51 am >> DELETE FROM ps_document_detail WHERE id_document = '88267' 13/10/2023 09:56:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88267' , '21553' , 'SCOPRIRE IL VANGELO IN UN WEEKEND - J. FABRE' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.10' ) 13/10/2023 09:56:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21553' AND id_supplier = '109' 13/10/2023 09:56:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21553' , '109' , '1' ) 13/10/2023 09:56:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88267' , '21548' , 'SCHIACCIARE LANIMA - D. DE LASSUS' , '1' , '0' , '4' , '19.8' , '19.8' , '0' , '0' , '19.80' ) 13/10/2023 09:56:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21548' AND id_supplier = '109' 13/10/2023 09:56:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21548' , '109' , '1' ) 13/10/2023 09:56:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88267' , '1142' , 'BIBBIA DI GERUSALEMME - TASC.' , '2' , '0' , '4' , '21.16' , '21.16' , '0' , '0' , '42.32' ) 13/10/2023 09:56:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '1142' AND id_supplier = '109' 13/10/2023 09:56:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1142' , '109' , '1' ) 13/10/2023 10:02:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3150' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 10:02:11 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' , '3150' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 13/10/2023 10:02: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 = '88268' 13/10/2023 10:02:11 am >> DELETE FROM ps_document_detail WHERE id_document = '88268' 13/10/2023 10:02: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 ( '88268' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 13/10/2023 10:06: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 ( '32' , '475/23' , '2023-10-10' , '23' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '665.60' , '640.00' , NOW() , NOW() ) 13/10/2023 10:06: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 = '88269' 13/10/2023 10:06:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88269' 13/10/2023 10:06:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88269' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '500' , '0' , '3' , '1.28' , '1.2307692307692' , '4' , '0' , '665.6000' ) 13/10/2023 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21644' AND id_supplier = '159' 13/10/2023 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21644' , '159' , '1' ) 13/10/2023 10:07:20 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'vJQ6xc4zVL6MzL0A' , NOW() , NOW() ) 13/10/2023 10:07:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4036' , '1' ) 13/10/2023 10:07:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4036' , '2' ) 13/10/2023 10:07:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4036' , '3' ) 13/10/2023 10:07:24 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 13/10/2023 10:07:24 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '180' , '1' ) 13/10/2023 10:07:24 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '180' , '1' ) 13/10/2023 10:07:24 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '180' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 13/10/2023 10:09:56 am >> UPDATE ps_address SET id_state = '135', lastname = 'I NUOVI QUINDICI SRL', address1 = 'VIA TORQUATO TASSO 10', address2 = '', postcode = '24020', dni = '', vat_number = '03313550166', city = 'GORLE', phone = '035655421', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '180' 13/10/2023 10:09:56 am >> UPDATE ps_supplier SET email = '', name = 'I NUOVI QUINDICI SRL', date_upd = NOW() WHERE id_supplier = '180' 13/10/2023 10:09:56 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '180' 13/10/2023 10:10:25 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/10/2023 10:10:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21675' , '1' , '' , 'nuovo-prodotto' ) 13/10/2023 10:10:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21675' , '1' , '1' , '2' , NOW() , NOW() ) 13/10/2023 10:10:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21675' , '0' , '1' , '0' , '0' ) 13/10/2023 10:11:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0701' AND id_product != '21675' AND ean13 != '' 13/10/2023 10:11:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '0701', date_upd = NOW() WHERE id_product = '21675' 13/10/2023 10:11:33 am >> UPDATE ps_product_lang SET name = 'ITALIANI IN GUERRA - UTET', description = '' WHERE id_product = '21675' 13/10/2023 10:11:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '800' WHERE id_product = '21675' 13/10/2023 10:11:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '800', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '226', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21675' 13/10/2023 10:11:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21675' 13/10/2023 10:11:38 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 = '21675' 13/10/2023 10:11:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21676' , '1' , '' , 'nuovo-prodotto' ) 13/10/2023 10:11:38 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 '21676' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21675' 13/10/2023 10:11:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21676' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21675' 13/10/2023 10:12:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0702' AND id_product != '21676' AND ean13 != '' 13/10/2023 10:12:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '0702', date_upd = NOW() WHERE id_product = '21676' 13/10/2023 10:12:04 am >> UPDATE ps_product_lang SET name = 'CRISTIANESIMO 5 VOL. - UTET', description = '' WHERE id_product = '21676' 13/10/2023 10:12:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '300' WHERE id_product = '21676' 13/10/2023 10:12:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '300', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '226', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21676' 13/10/2023 10:12:04 am >> DELETE FROM ps_specific_price WHERE id_product = '21676' 13/10/2023 10:12: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 ( '31' , '2023065/T' , '2023-10-10' , 'T' , '0' , '180' , '4679124' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1100.00' , '1100.00' , NOW() , NOW() ) 13/10/2023 10:12: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 = '88270' 13/10/2023 10:12:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88270' 13/10/2023 10:12: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 ( '88270' , '21675' , 'ITALIANI IN GUERRA - UTET' , '1' , '1' , '4' , '800.00' , '800' , '0' , '0' , '800.00' ) 13/10/2023 10:12:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21675' AND id_supplier = '180' 13/10/2023 10:12:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21675' , '180' , '1' ) 13/10/2023 10:12: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 ( '88270' , '21676' , 'CRISTIANESIMO 5 VOL. - UTET' , '1' , '1' , '4' , '300.00' , '300' , '0' , '0' , '300.00' ) 13/10/2023 10:12:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21676' AND id_supplier = '180' 13/10/2023 10:12:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21676' , '180' , '1' ) 13/10/2023 10:46:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 10:46:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3151' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.84' , '65.35' , NOW() , NOW() ) 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88271' 13/10/2023 10:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '88271' 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88271' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88271' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88271' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88271' , '9879' , 'SEPPELLIRE I MORTI, PREGARE DIO PER I VIVI E I DEFUNTI - N. BENAZZI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88271' , '16177' , 'ROSARIO PER I DEFUNTI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 13/10/2023 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88271' , '16006' , 'CONTEMPLERO IL TUO VOLTO - GUGLIELMONI/NEGRI' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 13/10/2023 10:48:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 10:48:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3152' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.10' , '37.10' , NOW() , NOW() ) 13/10/2023 10:48: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 = '88272' 13/10/2023 10:48:57 am >> DELETE FROM ps_document_detail WHERE id_document = '88272' 13/10/2023 10:48: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 ( '88272' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 13/10/2023 10:48: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 ( '88272' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 13/10/2023 10:48: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 ( '88272' , '21170' , 'ANCHE DIO HA I SUOI CAMPIONI - M. SCUDU' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 13/10/2023 10:49:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 10:49:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3153' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 13/10/2023 10:49: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 = '88273' 13/10/2023 10:49:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88273' 13/10/2023 10:49: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 ( '88273' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 13/10/2023 11:00:29 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 13/10/2023 11:00:29 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\nportiere per corriere Franco 3668670210 ' , '' , '3384440704' , '' , ' 92002190657' , NOW() , NOW() ) 13/10/2023 11:00:29 am >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 13/10/2023 11:01:11 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 13/10/2023 11:01:12 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\nportiere per corriere Franco 3668670210 ' , '' , '3384440704' , '' , ' 92002190657' , NOW() , NOW() ) 13/10/2023 11:01:12 am >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 13/10/2023 11:01:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 11:01:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3154' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.56' , '4.56' , NOW() , NOW() ) 13/10/2023 11:01:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88274' 13/10/2023 11:01:41 am >> DELETE FROM ps_document_detail WHERE id_document = '88274' 13/10/2023 11:01:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88274' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.40' , '2.4' , '0' , '5' , '4.56' ) 13/10/2023 11:15:41 am >> SELECT document_num FROM ps_document WHERE document_num = '47/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 11:15:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '47/E' , '2023-10-13' , 'E' , '3581' , '0' , '4679126' , 'PIAZZA 4 NOVEMBRE 84039 TEGGIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1100.00' , '1100.00' , NOW() , NOW() ) 13/10/2023 11:15:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88275' 13/10/2023 11:15:41 am >> DELETE FROM ps_document_detail WHERE id_document = '88275' 13/10/2023 11:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88275' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '500' , '-500' , '4' , '2.2' , '2.2' , '0' , '0' , '1100.00' ) 13/10/2023 11:18:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3155' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 11:18:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3155' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.72' , NOW() , NOW() ) 13/10/2023 11:18:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88276' 13/10/2023 11:18:54 am >> DELETE FROM ps_document_detail WHERE id_document = '88276' 13/10/2023 11:18:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88276' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.55' , '2.9098360655738' , '22' , '0' , '7.10' ) 13/10/2023 11:18:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88276' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 13/10/2023 11:21:38 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 13/10/2023 11:21:38 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\nportiere per corriere Franco 3668670210 ' , '' , '3384440704' , '' , ' 92002190657' , NOW() , NOW() ) 13/10/2023 11:21:38 am >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '0000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 13/10/2023 11:21:59 am >> SELECT document_num FROM ps_document WHERE document_num = '47/E' AND id_document != '88275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 11:21:59 am >> UPDATE ps_document SET id_document_type = '23', document_num = '47/E', document_date = '2023-10-13', document_letter = 'E', id_customer = '3581', id_supplier = '0', id_address = '4679127', address1 = 'PIAZZA 4 NOVEMBRE 84039 TEGGIANO', 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 = '1100.00', price_tax_excluded = '1100.00', date_upd = NOW() WHERE id_document = '88275' 13/10/2023 11:21: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 = '88275' 13/10/2023 11:21:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88275' 13/10/2023 11:21: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 ( '88275' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '500' , '-500' , '4' , '2.2000' , '2.2' , '0' , '0' , '1100.00' ) 13/10/2023 11:27:15 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 13/10/2023 11:27:16 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\nportiere per corriere Franco 3668670210 ' , '' , '3384440704' , '92002190657' , '92002190657' , NOW() , NOW() ) 13/10/2023 11:27:16 am >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '0000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 13/10/2023 11:27:44 am >> SELECT document_num FROM ps_document WHERE document_num = '47/E' AND id_document != '88275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 11:27:44 am >> UPDATE ps_document SET id_document_type = '23', document_num = '47/E', document_date = '2023-10-13', document_letter = 'E', id_customer = '3581', id_supplier = '0', id_address = '4679128', address1 = 'PIAZZA 4 NOVEMBRE 84039 TEGGIANO', 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 = '1100.00', price_tax_excluded = '1100.00', date_upd = NOW() WHERE id_document = '88275' 13/10/2023 11:27: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 = '88275' 13/10/2023 11:27:44 am >> DELETE FROM ps_document_detail WHERE id_document = '88275' 13/10/2023 11:27: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 ( '88275' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '500' , '-500' , '4' , '2.2000' , '2.2' , '0' , '0' , '1100.00' ) 13/10/2023 11:30:16 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 13/10/2023 11:30:16 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\n Franco portiere per corriere 3668670210 ' , '' , '3384440704' , '92002190657' , '92002190657' , NOW() , NOW() ) 13/10/2023 11:30:16 am >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '0000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 13/10/2023 11:38:41 am >> UPDATE ps_address SET id_state = '183', lastname = 'COCO CLER DI ARMANDO COCO', address1 = 'VIA G. BATTISTA VICO 73', address2 = '', postcode = '80010', dni = 'CCORND82L30C495Q', vat_number = '06135521216', city = 'VILLARICCA', phone = '081 19102823', phone_mobile = '3289645775', date_upd = NOW() WHERE id_supplier = '137' 13/10/2023 11:38:41 am >> UPDATE ps_supplier SET email = 'cococler@gmail.com', name = 'COCO CLER DI ARMANDO COCO', date_upd = NOW() WHERE id_supplier = '137' 13/10/2023 11:38:41 am >> UPDATE ps_supplier_lang SET description = 'SEDE OPERATIVA: VIA I TRAV. CASACELLE 27 - 80014 GIUGLIANO IN CAMPANIA', meta_title = '', meta_description = '' WHERE id_supplier = '137' 13/10/2023 11:48:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 11:48:49 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' , '3156' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 13/10/2023 11:48:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88277' 13/10/2023 11:48:49 am >> DELETE FROM ps_document_detail WHERE id_document = '88277' 13/10/2023 11:48:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88277' , '20008' , 'FRANCESCO DI SALES - L. NUOVO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 13/10/2023 12:03:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3157' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 12:03:58 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' , '3157' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '21.12' , NOW() , NOW() ) 13/10/2023 12:03:58 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 = '88278' 13/10/2023 12:03:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '88278' 13/10/2023 12:03:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88278' , '19542' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 13/10/2023 12:03:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88278' , '5975' , 'LUCERNA COLORATA - 1491' , '1' , '-1' , '1' , '21.50' , '17.622950819672' , '22' , '0' , '21.50' ) 13/10/2023 12:04:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 12:04: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' , '3158' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '152.00' , '152.00' , NOW() , NOW() ) 13/10/2023 12:04: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 = '88279' 13/10/2023 12:04:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88279' 13/10/2023 12:04: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 ( '88279' , '20393' , 'DON MILANI - TUTTE LE OPERE' , '1' , '-1' , '4' , '140.00' , '140' , '0' , '5' , '133.00' ) 13/10/2023 12:04: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 ( '88279' , '21671' , 'RESISTI CUORE' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 13/10/2023 12:05:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 12:05:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3159' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.63' , '96.63' , NOW() , NOW() ) 13/10/2023 12:05:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88280' 13/10/2023 12:05:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '88280' 13/10/2023 12:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88280' , '13431' , 'PASSI VERSO LEUCARISTIA' , '3' , '-3' , '4' , '5.90' , '5.9' , '0' , '5' , '16.83' ) 13/10/2023 12:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88280' , '1876' , 'CELEBRARE LA PRIMA RICONCILIAZIONE E LA PRIMA COM.' , '6' , '-6' , '4' , '7.00' , '7' , '0' , '5' , '39.90' ) 13/10/2023 12:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88280' , '1864' , 'CELEBRARE LAVVENTO E IL NATALE... - 1' , '6' , '-6' , '4' , '7.00' , '7' , '0' , '5' , '39.90' ) 13/10/2023 12:10:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3156' AND id_document != '88277' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 12:10:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3156', document_date = '2023-10-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.50', price_tax_excluded = '9.50', date_upd = NOW() WHERE id_document = '88277' 13/10/2023 12:10:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88277' 13/10/2023 12:10:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '88277' 13/10/2023 12:10:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88277' , '19668' , 'LUIGI MARIA PALAZZOLO - E. PLATI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 13/10/2023 12:10:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88277' , '9583' , 'SANTA MARIA MADDALENA DE PAZZI - SUOR M. ORESKOVA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 13/10/2023 12:11:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3138' AND id_document != '88248' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-12') 13/10/2023 12:11:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3138', document_date = '2023-10-12', 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 = '71.00', price_tax_excluded = '61.10', date_upd = NOW() WHERE id_document = '88248' 13/10/2023 12:11: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 = '88248' 13/10/2023 12:11:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '88248' 13/10/2023 12:11: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 ( '88248' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '5' , '29.00' ) 13/10/2023 12:11: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 ( '88248' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '24.00' ) 13/10/2023 12:11: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 ( '88248' , '21651' , 'CALENDARIO DA TAVOLO 2024' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '5' , '1.90' ) 13/10/2023 12:11: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 ( '88248' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 13/10/2023 12:11: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 ( '88248' , '3965' , 'EUCARISTIA CORPO DI CRISTO - POSTER' , '1' , '-1' , '4' , '1.9400' , '1.94' , '0' , '0' , '1.94' ) 13/10/2023 12:11: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 ( '88248' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '1' , '-1' , '4' , '4.3' , '4.3' , '0' , '0' , '4.30' ) 13/10/2023 12:11: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 ( '88248' , '12868' , 'GIOCANDO SCOPRIAMO LANNO LITURGICO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 13/10/2023 12:11: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 ( '88248' , '9300' , 'SACRAMENTI - R. LUPI - POSTER' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 13/10/2023 12:11: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 ( '88248' , '17585' , 'RUOTA DELLA S. MESSA - POSTER' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 13/10/2023 12:15:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 12:15:04 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' , '3160' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '230.00' , NOW() , NOW() ) 13/10/2023 12:15:04 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 = '88281' 13/10/2023 12:15:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '88281' 13/10/2023 12:15:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88281' , '19383' , 'EVANGELO COFANETTO - VALTORTA' , '1' , '-1' , '4' , '230.00' , '230' , '0' , '5' , '218.50' ) 13/10/2023 12:15:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88281' , '21492' , 'PASCI LE MIE PECORE - F. SALVI' , '1' , '-1' , '4' , '11.5' , '11.5' , '0' , '0' , '11.50' ) 13/10/2023 12:53:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 12:53:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3161' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '4.67' , NOW() , NOW() ) 13/10/2023 12:53:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88282' 13/10/2023 12:53:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '88282' 13/10/2023 12:53: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 ( '88282' , '20525' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM' , '1' , '-1' , '1' , '4.20' , '3.4426229508197' , '22' , '0' , '4.20' ) 13/10/2023 12:53: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 ( '88282' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/10/2023 02:36:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '200' , '2023-10-11' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '207.40' , '170.00' , NOW() , NOW() ) 13/10/2023 02:36:58 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 = '88283' 13/10/2023 02:36:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '88283' 13/10/2023 02:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88283' , '15408' , 'STOLA IN RASO CON RICAMO CROCE E SPIGHE - 7897' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 13/10/2023 02:36:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15408' AND id_supplier = '126' 13/10/2023 02:36:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15408' , '126' , '1' ) 13/10/2023 02:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88283' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 13/10/2023 02:36:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18238' AND id_supplier = '126' 13/10/2023 02:36:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18238' , '126' , '1' ) 13/10/2023 02:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88283' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 13/10/2023 02:36:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '126' 13/10/2023 02:36:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '126' , '1' ) 13/10/2023 02:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88283' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 13/10/2023 02:36:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18237' AND id_supplier = '126' 13/10/2023 02:36:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18237' , '126' , '1' ) 13/10/2023 02:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88283' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '0' , '48.8000' ) 13/10/2023 02:36:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 13/10/2023 02:36:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 13/10/2023 02:44:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 02:44:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '106/A' , '2023-10-13' , 'A' , '1656' , '0' , '4677544' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '149.77' , '149.77' , NOW() , NOW() ) 13/10/2023 02:44:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88284' 13/10/2023 02:44:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '88284' 13/10/2023 02:44:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '23' , '-23' , '4' , '3.40' , '3.4' , '0' , '15' , '66.47' ) 13/10/2023 02:44:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '28' , '-28' , '4' , '3.50' , '3.5' , '0' , '15' , '83.30' ) 13/10/2023 05:42:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 05:42:14 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' , '3162' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.50' , '32.06' , NOW() , NOW() ) 13/10/2023 05:42:14 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 = '88285' 13/10/2023 05:42:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '88285' 13/10/2023 05:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88285' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 13/10/2023 05:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88285' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '8.5' , '8.5' , '0' , '0' , '25.50' ) 13/10/2023 05:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88285' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 13/10/2023 05:46:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 05:46:51 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' , '107/A' , '2023-10-13' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA SAN LEONARDO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 13/10/2023 05:46:51 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 = '88286' 13/10/2023 05:46:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88286' 13/10/2023 05:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88286' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 13/10/2023 05:52:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 05:52:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '154' , '2023-10-13' , '' , '3455' , '0' , '4672079' , 'C. DA SANTA DOMENICA, SNC 84031 AULETTA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.75' , '9.75' , NOW() , NOW() ) 13/10/2023 05:52:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88287' 13/10/2023 05:52:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '88287' 13/10/2023 05:52:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88287' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/10/2023 05:53:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '88287' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 05:53:05 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '154', document_date = '2023-10-13', document_letter = '', id_customer = '3455', id_supplier = '', id_address = '4672079', address1 = 'C. DA SANTA DOMENICA, SNC 84031 AULETTA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '9.75', price_tax_excluded = '9.75', date_upd = NOW() WHERE id_document = '88287' 13/10/2023 05:53: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 = '88287' 13/10/2023 05:53:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '88287' 13/10/2023 05:53: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 ( '88287' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 13/10/2023 07:04:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 07:04:55 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' , '3163' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 13/10/2023 07:04:55 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 = '88288' 13/10/2023 07:04:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '88288' 13/10/2023 07:04:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88288' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 13/10/2023 07:04:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88288' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 13/10/2023 07:27:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-13') 13/10/2023 07:27: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' , '3164' , '2023-10-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.30' , '7.13' , NOW() , NOW() ) 13/10/2023 07:27: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 = '88289' 13/10/2023 07:27:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '88289' 13/10/2023 07:27: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 ( '88289' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 13/10/2023 07:27: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 ( '88289' , '18357' , 'MIE PREGHIERINE N.E.' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' )