21/11/2023 09:03:00 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '13752' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-18') 21/11/2023 09:03:00 am >> UPDATE ps_document SET id_document_type = '21', document_num = '106', document_date = '2023-11-18', document_letter = '', id_customer = '7077', id_supplier = '', id_address = '163357303', address1 = 'VIA CAMPOFIORITO 12 95022 ACI CATENA', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '125.90', price_tax_excluded = '125.90', date_upd = NOW() WHERE id_document = '13752' 21/11/2023 09:03: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 = '13752' 21/11/2023 09:03:00 am >> DELETE FROM ps_document_detail WHERE id_document = '13752' 21/11/2023 09:03: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 ( '13752' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '50' , '-50' , '4' , '2.38' , '2.38' , '0' , '0' , '119.00' ) 21/11/2023 09:13:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 09:13:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3668' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 21/11/2023 09:13:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89048' 21/11/2023 09:13:03 am >> DELETE FROM ps_document_detail WHERE id_document = '89048' 21/11/2023 09:13:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89048' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 21/11/2023 09:14:05 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '13752' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-18') 21/11/2023 09:14:05 am >> UPDATE ps_document SET id_document_type = '21', document_num = '106', document_date = '2023-11-18', document_letter = '', id_customer = '7077', id_supplier = '', id_address = '163357303', address1 = 'VIA CAMPOFIORITO 12 95022 ACI CATENA', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '125.65', price_tax_excluded = '125.65', date_upd = NOW() WHERE id_document = '13752' 21/11/2023 09:14: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 = '13752' 21/11/2023 09:14:06 am >> DELETE FROM ps_document_detail WHERE id_document = '13752' 21/11/2023 09:14:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13752' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '50' , '-50' , '4' , '2.5' , '2.5' , '0' , '5' , '118.75' ) 21/11/2023 09:23:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3664' AND id_document != '89041' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 21/11/2023 09:23:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3664', document_date = '2023-11-20', 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 = '4.95', price_tax_excluded = '4.95', date_upd = NOW() WHERE id_document = '89041' 21/11/2023 09:23:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89041' 21/11/2023 09:23:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89041' 21/11/2023 09:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '16362' , 'BIANCANEVE E I SETTE NANI' , '2' , '-2' , '4' , '0.99' , '0.99' , '0' , '0' , '1.98' ) 21/11/2023 09:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.97' , '2.97' , '0' , '0' , '2.97' ) 21/11/2023 09:24:30 am >> SELECT document_num FROM ps_document WHERE document_num = '128/A' AND id_document != '88977' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-15') 21/11/2023 09:24:30 am >> UPDATE ps_document SET id_document_type = '24', document_num = '128/A', document_date = '2023-11-15', document_letter = 'A', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', 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 = '168.00', price_tax_excluded = '149.97', date_upd = NOW() WHERE id_document = '88977' 21/11/2023 09:24:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88977' 21/11/2023 09:24:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88977' 21/11/2023 09:24: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 ( '88977' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '0' , '3.5000' , '3.5' , '0' , '0' , '14.00' ) 21/11/2023 09:24: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 ( '88977' , '21838' , 'CARTOLINA CARLO ACUTIS' , '30' , '-30' , '0' , '0.1500' , '0.15' , '0' , '0' , '4.50' ) 21/11/2023 09:24: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 ( '88977' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '11' , '-11' , '0' , '4.5000' , '4.5' , '0' , '0' , '49.50' ) 21/11/2023 09:24: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 ( '88977' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '50' , '-50' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '100.00' ) 21/11/2023 10:05:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 10:05:46 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' , '3669' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 21/11/2023 10:05:46 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 = '89049' 21/11/2023 10:05:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89049' 21/11/2023 10:05:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89049' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/11/2023 10:06:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 10:06:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3670' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 21/11/2023 10:06:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89050' 21/11/2023 10:06:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89050' 21/11/2023 10:06:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89050' , '21526' , 'MESSALE FESTIVO 2024' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 21/11/2023 10:23:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 10:23: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 ( '11' , '3671' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.18' , '6.18' , NOW() , NOW() ) 21/11/2023 10:23: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 = '89051' 21/11/2023 10:23:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89051' 21/11/2023 10:23: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 ( '89051' , '1824' , 'CATECHISMO DELLA CHIESA CATTOLICA - COMPENDIO' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 21/11/2023 10:41:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 10:41: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 ( '11' , '3672' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.27' , '12.27' , NOW() , NOW() ) 21/11/2023 10:41: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 = '89052' 21/11/2023 10:41:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89052' 21/11/2023 10:41: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 ( '89052' , '21627' , 'AVVENTO E NATALE 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 21/11/2023 10:41: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 ( '89052' , '21845' , 'VIENI SIGNORE GESU!' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 21/11/2023 10:41: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 ( '89052' , '21741' , 'ALLAVVENTURA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 21/11/2023 10:41: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 ( '89052' , '15580' , 'CHRISTUS VIVIT' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 21/11/2023 11:12:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 11:12:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3673' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.00' , '101.64' , NOW() , NOW() ) 21/11/2023 11:12:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89053' 21/11/2023 11:12:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89053' 21/11/2023 11:12:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89053' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 21/11/2023 11:12:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89053' , '8163' , 'ASTUCCIO PORTA VIATICO DAMASCATO - 23' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 21/11/2023 11:14:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 11:14:42 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' , '3674' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 21/11/2023 11:14: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 = '89054' 21/11/2023 11:14:42 am >> DELETE FROM ps_document_detail WHERE id_document = '89054' 21/11/2023 11:14: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 ( '89054' , '14940' , 'SAN CHARBEL - 8850' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 21/11/2023 11:20:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 11:20: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' , '3675' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 21/11/2023 11:20: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 = '89055' 21/11/2023 11:20:23 am >> DELETE FROM ps_document_detail WHERE id_document = '89055' 21/11/2023 11:20: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 ( '89055' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 21/11/2023 11:20: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 ( '89055' , '8163' , 'ASTUCCIO PORTA VIATICO DAMASCATO - 23' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 21/11/2023 11:20:43 am >> DELETE FROM ps_document WHERE id_document = '89055' 21/11/2023 11:20:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89055' 21/11/2023 11:23:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 11:23: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' , '3675' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '313.78' , '287.35' , NOW() , NOW() ) 21/11/2023 11:23: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 = '89056' 21/11/2023 11:23:24 am >> DELETE FROM ps_document_detail WHERE id_document = '89056' 21/11/2023 11:23: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 ( '89056' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '4' , '-4' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '54.00' ) 21/11/2023 11:23: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 ( '89056' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 21/11/2023 11:23: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 ( '89056' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 21/11/2023 11:23: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 ( '89056' , '21577' , 'AVVENTO 2023' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 21/11/2023 11:23: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 ( '89056' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 21/11/2023 11:23: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 ( '89056' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 21/11/2023 11:23: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 ( '89056' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '50' , '-50' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '175.00' ) 21/11/2023 11:23: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 ( '89056' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 21/11/2023 04:26:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 04:26:09 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' , '3676' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 21/11/2023 04:26:09 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 = '89057' 21/11/2023 04:26:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89057' 21/11/2023 04:26:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89057' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 21/11/2023 04:40:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '530' , '2023-11-21' , '' , '2765' , '0' , '11512' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '84.00' , '84.00' , NOW() , NOW() ) 21/11/2023 04:40:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89058' 21/11/2023 04:40:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89058' 21/11/2023 04:40:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89058' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3200' , '3200' , '4' , '0.035' , '0.035' , '0' , '25' , '84.0000' ) 21/11/2023 04:44:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000418' AND id_product != '939' AND ean13 != '' 21/11/2023 04:44:49 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000418', date_upd = NOW() WHERE id_product = '939' 21/11/2023 04:44:49 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 4 - CARNE - P1', description = '' WHERE id_product = '939' 21/11/2023 04:44:49 pm >> UPDATE ps_product SET wholesale_price = '0.12', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '939' 21/11/2023 04:44:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.12', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '939' 21/11/2023 04:44:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '939' 21/11/2023 04:44:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000419' AND id_product != '940' AND ean13 != '' 21/11/2023 04:44:57 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000419', date_upd = NOW() WHERE id_product = '940' 21/11/2023 04:44:57 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 4 - FOSFORO - P1', description = '' WHERE id_product = '940' 21/11/2023 04:44:57 pm >> UPDATE ps_product SET wholesale_price = '0.12', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '940' 21/11/2023 04:44:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.12', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '940' 21/11/2023 04:44:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '940' 21/11/2023 04:46:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000416' AND id_product != '941' AND ean13 != '' 21/11/2023 04:46:15 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000416', date_upd = NOW() WHERE id_product = '941' 21/11/2023 04:46:15 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 5 - CARNE - PX', description = '' WHERE id_product = '941' 21/11/2023 04:46:15 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.3278688524590164' WHERE id_product = '941' 21/11/2023 04:46:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.3278688524590164', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '941' 21/11/2023 04:46:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '941' 21/11/2023 04:46:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000417' AND id_product != '942' AND ean13 != '' 21/11/2023 04:46:23 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000417', date_upd = NOW() WHERE id_product = '942' 21/11/2023 04:46:23 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 5 - FOSFORO - PX', description = '' WHERE id_product = '942' 21/11/2023 04:46:23 pm >> UPDATE ps_product SET wholesale_price = '0.13', on_sale = '0', price = '0.3278688524590164' WHERE id_product = '942' 21/11/2023 04:46:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.13', price = '0.3278688524590164', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '942' 21/11/2023 04:46:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '942' 21/11/2023 04:52:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 04:52:43 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' , '281' , '2023-11-21' , '' , '1923' , '0' , '4669431' , 'VIA APPIA ANTICA, 35 04019 TERRACINA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '31.13' , '31.13' , NOW() , NOW() ) 21/11/2023 04:52:43 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 = '89059' 21/11/2023 04:52:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89059' 21/11/2023 04:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89059' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.13' ) 21/11/2023 06:34:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 06:34:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3677' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 21/11/2023 06:34:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89060' 21/11/2023 06:34:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '89060' 21/11/2023 06:34:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89060' , '17290' , 'SPILLA PORTACIUCCIO' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 21/11/2023 07:19:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 21/11/2023 07:19:47 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' , '3678' , '2023-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '1.20' , NOW() , NOW() ) 21/11/2023 07:19:47 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 = '89061' 21/11/2023 07:19:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '89061' 21/11/2023 07:19:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89061' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' )