10/01/2023 09:02:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 09:02:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '2/A' , '2023-01-10' , 'A' , '3549' , '0' , '4671010' , 'PIAZZA SAN MARCO 03037 PONTECORVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '72.00' , NOW() , NOW() ) 10/01/2023 09:02:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78223' 10/01/2023 09:02:26 am >> DELETE FROM ps_document_detail WHERE id_document = '78223' 10/01/2023 09:02:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78223' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '8' , '-8' , '0' , '3.50' , '3.5' , '' , '0' , '28.00' ) 10/01/2023 09:02:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78223' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '0' , '1.90' , '1.9' , '' , '0' , '19.00' ) 10/01/2023 09:02:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78223' , '' , 'CANDELE' , '1' , '-1' , '0' , '25' , '25' , '' , '0' , '25.00' ) 10/01/2023 09:12:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 09:12:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '3' , '2023-01-10' , '' , '2630' , '0' , '4673397' , 'VIA LOMBARDA, 189 55013 LAMMARI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '165.75' , '165.75' , NOW() , NOW() ) 10/01/2023 09:12:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78224' 10/01/2023 09:12:26 am >> DELETE FROM ps_document_detail WHERE id_document = '78224' 10/01/2023 09:12:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78224' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '35' , '-35' , '4' , '5.00' , '5' , '0' , '15' , '148.75' ) 10/01/2023 09:12:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78224' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '15' , '17.00' ) 10/01/2023 09:23:11 am >> SELECT document_num FROM ps_document WHERE document_num = '85' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 09:23: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' , '85' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 10/01/2023 09:23: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 = '78225' 10/01/2023 09:23:11 am >> DELETE FROM ps_document_detail WHERE id_document = '78225' 10/01/2023 09:23: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 ( '78225' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '44.00' , '44' , '0' , '5' , '41.80' ) 10/01/2023 09:27:56 am >> SELECT document_num FROM ps_document WHERE document_num = '86' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 09:27:56 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' , '86' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 10/01/2023 09:27:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78226' 10/01/2023 09:27:56 am >> DELETE FROM ps_document_detail WHERE id_document = '78226' 10/01/2023 09:27:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78226' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 10/01/2023 09:54:49 am >> SELECT document_num FROM ps_document WHERE document_num = '87' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 09:54: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' , '87' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '73.61' , NOW() , NOW() ) 10/01/2023 09:54: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 = '78227' 10/01/2023 09:54:49 am >> DELETE FROM ps_document_detail WHERE id_document = '78227' 10/01/2023 09:54: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 ( '78227' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 10/01/2023 09:54: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 ( '78227' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 10/01/2023 09:54: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 ( '78227' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 10/01/2023 09:54: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 ( '78227' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 10/01/2023 09:54: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 ( '78227' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 10/01/2023 09:54: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 ( '78227' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/01/2023 10:05:48 am >> SELECT document_num FROM ps_document WHERE document_num = '88' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 10:05:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '88' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '6.89' , NOW() , NOW() ) 10/01/2023 10:05: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 = '78228' 10/01/2023 10:05:48 am >> DELETE FROM ps_document_detail WHERE id_document = '78228' 10/01/2023 10:05: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 ( '78228' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 10/01/2023 10:05: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 ( '78228' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '8' , '-8' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '6.40' ) 10/01/2023 10:10:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3335' AND id_document != '70365' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 10/01/2023 10:10:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3335', document_date = '2022-11-04', 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 = '284.00', price_tax_excluded = '260.65', date_upd = NOW() WHERE id_document = '70365' 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70365' 10/01/2023 10:10:20 am >> DELETE FROM ps_document_detail WHERE id_document = '70365' 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/01/2023 10:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '14724' , 'STOLA MARIANA - ART.1028/342' , '1' , '-1' , '1' , '127.8' , '104.75409836066' , '22' , '0' , '127.80' ) 10/01/2023 11:17:55 am >> SELECT document_num FROM ps_document WHERE document_num = '89' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:17:56 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' , '89' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.13' , NOW() , NOW() ) 10/01/2023 11:17:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78229' 10/01/2023 11:17:56 am >> DELETE FROM ps_document_detail WHERE id_document = '78229' 10/01/2023 11:17:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78229' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 10/01/2023 11:17:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78229' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 10/01/2023 11:34:20 am >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:34:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '90' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '157.00' , '128.69' , NOW() , NOW() ) 10/01/2023 11:34:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78230' 10/01/2023 11:34:20 am >> DELETE FROM ps_document_detail WHERE id_document = '78230' 10/01/2023 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78230' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '62' , '50.819672131148' , '22' , '0' , '62.00' ) 10/01/2023 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78230' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 10/01/2023 11:39:07 am >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:39:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '91' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.76' , '43.74' , NOW() , NOW() ) 10/01/2023 11:39: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 = '78231' 10/01/2023 11:39:07 am >> DELETE FROM ps_document_detail WHERE id_document = '78231' 10/01/2023 11:39: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 ( '78231' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 10/01/2023 11:39: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 ( '78231' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 10/01/2023 11:39:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:39: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 ( '24' , '3/A' , '2023-01-10' , 'A' , '27' , '0' , '4677541' , 'P.ZZA PIRONTI 83025 PIANO DI MONTORO' , '' , 'acconto 250' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '500.00' , '500.00' , NOW() , NOW() ) 10/01/2023 11:39: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 = '78232' 10/01/2023 11:39:46 am >> DELETE FROM ps_document_detail WHERE id_document = '78232' 10/01/2023 11:39: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 ( '78232' , '' , 'calice + pisside' , '1' , '-1' , '0' , '500' , '500' , '' , '0' , '500.00' ) 10/01/2023 11:45:35 am >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:45:36 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' , '92' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.90' , '70.92' , NOW() , NOW() ) 10/01/2023 11:45:36 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 = '78233' 10/01/2023 11:45:36 am >> DELETE FROM ps_document_detail WHERE id_document = '78233' 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '13319' , 'VIVI LA VITA - 30' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '100' , '0.00' ) 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '16710' , 'MESSAGGIO DI TENEREZZA - 17' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '100' , '0.00' ) 10/01/2023 11:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78233' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '1' , '-1' , '1' , '73.00' , '59.83606557377' , '22' , '0' , '73.00' ) 10/01/2023 11:49:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3/A' AND id_document != '78232' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:49:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '3/A', document_date = '2023-01-10', document_letter = 'A', id_customer = '27', id_supplier = '', id_address = '4677541', address1 = 'P.ZZA PIRONTI 83025 PIANO DI MONTORO', address2 = '', note = 'acconto 250', 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 = '551.50', price_tax_excluded = '542.21', date_upd = NOW() WHERE id_document = '78232' 10/01/2023 11:49:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78232' 10/01/2023 11:49:17 am >> DELETE FROM ps_document_detail WHERE id_document = '78232' 10/01/2023 11:49:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78232' , '0' , 'calice + pisside' , '1' , '-1' , '0' , '500.0000' , '500' , '0' , '0' , '500.00' ) 10/01/2023 11:49:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78232' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '-1' , '1' , '51.50' , '42.213114754098' , '22' , '0' , '51.50' ) 10/01/2023 11:53:59 am >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:53: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' , '93' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '164.00' , '134.97' , NOW() , NOW() ) 10/01/2023 11:53: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 = '78234' 10/01/2023 11:53:59 am >> DELETE FROM ps_document_detail WHERE id_document = '78234' 10/01/2023 11:53: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 ( '78234' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 10/01/2023 11:53: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 ( '78234' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 10/01/2023 11:53: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 ( '78234' , '802' , 'ASTUCCIO VASETTI DORATI - 958' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 10/01/2023 11:53: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 ( '78234' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/01/2023 11:53: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 ( '78234' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 10/01/2023 11:53: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 ( '78234' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 10/01/2023 11:58:03 am >> SELECT document_num FROM ps_document WHERE document_num = '94' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 11:58: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' , '94' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 10/01/2023 11:58: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 = '78235' 10/01/2023 11:58:03 am >> DELETE FROM ps_document_detail WHERE id_document = '78235' 10/01/2023 11:58: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 ( '78235' , '11756' , 'VINO BIANCO SECCO - 14%' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 10/01/2023 12:05:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '78234' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 12:05:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '93', document_date = '2023-01-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '164.00', price_tax_excluded = '134.97', date_upd = NOW() WHERE id_document = '78234' 10/01/2023 12:05:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78234' 10/01/2023 12:05:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '78234' 10/01/2023 12:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78234' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 10/01/2023 12:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78234' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 10/01/2023 12:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78234' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '79' , '64.754098360656' , '22' , '0' , '79.00' ) 10/01/2023 12:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78234' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/01/2023 12:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78234' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 10/01/2023 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78234' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 10/01/2023 12:07:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000049' AND id_product != '802' AND ean13 != '' 10/01/2023 12:07:37 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000049', date_upd = NOW() WHERE id_product = '802' 10/01/2023 12:07:37 pm >> UPDATE ps_product_lang SET name = 'ASTUCCIO VASETTI DORATI - 958', description = '' WHERE id_product = '802' 10/01/2023 12:07:37 pm >> UPDATE ps_product SET wholesale_price = '33.25', on_sale = '0', price = '71.31147540983606' WHERE id_product = '802' 10/01/2023 12:07:37 pm >> UPDATE ps_product_shop SET wholesale_price = '33.25', price = '71.31147540983606', id_tax_rules_group = '1', id_category_default = '147', 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 = '802' 10/01/2023 12:07:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '802' 10/01/2023 12:21:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000539' AND id_product != '1626' AND ean13 != '' 10/01/2023 12:21:04 pm >> UPDATE ps_product SET id_supplier = '73', reference = '2014', ean13 = '000539', date_upd = NOW() WHERE id_product = '1626' 10/01/2023 12:21:04 pm >> UPDATE ps_product_lang SET name = 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ', description = '' WHERE id_product = '1626' 10/01/2023 12:21:04 pm >> UPDATE ps_product SET wholesale_price = '34.40', on_sale = '0', price = '55.73770491803279' WHERE id_product = '1626' 10/01/2023 12:21:04 pm >> UPDATE ps_product_shop SET wholesale_price = '34.40', price = '55.73770491803279', id_tax_rules_group = '1', id_category_default = '227', 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 = '1626' 10/01/2023 12:21:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '1626' 10/01/2023 12:51:50 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/01/2023 12:51:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20610' , '1' , '' , 'nuovo-prodotto' ) 10/01/2023 12:51:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20610' , '1' , '1' , '2' , NOW() , NOW() ) 10/01/2023 12:51:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20610' , '0' , '1' , '0' , '0' ) 10/01/2023 12:52:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254711439' AND id_product != '20610' AND ean13 != '' 10/01/2023 12:52:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9791254711439', date_upd = NOW() WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> UPDATE ps_product_lang SET name = 'sole anche di notte - d. blain', description = '' WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20611' , '1' , '' , 'nuovo-prodotto' ) 10/01/2023 12:52:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20611' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20610' 10/01/2023 12:52:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20611' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20610' 10/01/2023 12:53:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254711439' AND id_product != '20610' AND ean13 != '' 10/01/2023 12:53:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9791254711439', date_upd = NOW() WHERE id_product = '20610' 10/01/2023 12:53:16 pm >> UPDATE ps_product_lang SET name = 'SOLE ANCHE DI NOTTE - D. BLAIN', description = '' WHERE id_product = '20610' 10/01/2023 12:53:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '20610' 10/01/2023 12:53:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20610' 10/01/2023 12:53:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '20610' 10/01/2023 12:55:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837234805' AND id_product != '20611' AND ean13 != '' 10/01/2023 12:55:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9788837234805', date_upd = NOW() WHERE id_product = '20611' 10/01/2023 12:55:24 pm >> UPDATE ps_product_lang SET name = 'JOSEPH RATZINGER - R. RUSCONI', description = '' WHERE id_product = '20611' 10/01/2023 12:55:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '20611' 10/01/2023 12:55:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '161', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20611' 10/01/2023 12:55:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '20611' 10/01/2023 12:55:59 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/01/2023 12:55:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20612' , '1' , '' , 'nuovo-prodotto' ) 10/01/2023 12:55:59 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20612' , '1' , '1' , '2' , NOW() , NOW() ) 10/01/2023 12:55:59 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20612' , '0' , '1' , '0' , '0' ) 10/01/2023 12:57:11 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 10/01/2023 12:57:11 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '514' , '1' ) 10/01/2023 12:57:11 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '514' , '2' ) 10/01/2023 12:57:11 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '514' , '3' ) 10/01/2023 12:57:11 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '514' , '1' , 'SONZOGNO' , LOWER('SONZOGNO') ) 10/01/2023 12:57:11 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '514' , '1' , '0' ) 10/01/2023 12:57:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845403576' AND id_product != '20612' AND ean13 != '' 10/01/2023 12:57:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788845403576', date_upd = NOW() WHERE id_product = '20612' 10/01/2023 12:57:20 pm >> UPDATE ps_product_lang SET name = 'LIBRO CHE CI LEGGE - C. MIRIANO', description = '' WHERE id_product = '20612' 10/01/2023 12:57:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20612' 10/01/2023 12:57:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '514', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20612' 10/01/2023 12:57:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '20612' 10/01/2023 12:57:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20612' 10/01/2023 12:57:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20613' , '1' , '' , 'nuovo-prodotto' ) 10/01/2023 12:57:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20613' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20612' 10/01/2023 12:57:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20613' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20612' 10/01/2023 12:58:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788828208778' AND id_product != '20613' AND ean13 != '' 10/01/2023 12:58:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9788828208778', date_upd = NOW() WHERE id_product = '20613' 10/01/2023 12:58:25 pm >> UPDATE ps_product_lang SET name = 'MONASTERO BENEDETTO XVI - M. FRANCO', description = '' WHERE id_product = '20613' 10/01/2023 12:58:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20613' 10/01/2023 12:58:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '452', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20613' 10/01/2023 12:58:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20613' 10/01/2023 12:58:26 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20613' 10/01/2023 12:58:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20614' , '1' , '' , 'nuovo-prodotto' ) 10/01/2023 12:58:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20614' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20613' 10/01/2023 12:58:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20614' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20613' 10/01/2023 12:58:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '005163' , '2023-01-09' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '194.00' , '194.00' , NOW() , NOW() ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78236' 10/01/2023 12:58:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '78236' 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '2' , '2' , '4' , '40.00' , '40' , '0' , '0' , '80.0000' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17702' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17702' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '19630' , 'BERNADETTE - A. MAGGI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19630' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19630' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '20610' , 'SOLE ANCHE DI NOTTE - D. BLAIN' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20610' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20610' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '20611' , 'JOSEPH RATZINGER - R. RUSCONI' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20611' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20611' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '16353' , 'QUALCUNO A CUI GUARDARE - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16353' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16353' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '20612' , 'LIBRO CHE CI LEGGE - C. MIRIANO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20612' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20612' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '19915' , 'VITA LUNGA - PAPA FRANCESCO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19915' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19915' , '109' , '1' ) 10/01/2023 12:58:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78236' , '20613' , 'MONASTERO BENEDETTO XVI - M. FRANCO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 10/01/2023 12:58:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20613' AND id_supplier = '109' 10/01/2023 12:58:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20613' , '109' , '1' ) 10/01/2023 03:16:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 03:16:33 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' , '95' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 10/01/2023 03:16:33 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 = '78237' 10/01/2023 03:16:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '78237' 10/01/2023 03:16:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78237' , '19630' , 'BERNADETTE - A. MAGGI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 10/01/2023 03:24:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '96' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 03:24: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' , '96' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 10/01/2023 03:24: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 = '78238' 10/01/2023 03:24:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '78238' 10/01/2023 03:24: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 ( '78238' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 10/01/2023 03:39:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 03:39: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 ( '11' , '97' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 10/01/2023 03:39: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 = '78239' 10/01/2023 03:39:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '78239' 10/01/2023 03:39: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 ( '78239' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 10/01/2023 03:46:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '98' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 03:46: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' , '98' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 10/01/2023 03:46: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 = '78240' 10/01/2023 03:46:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '78240' 10/01/2023 03:46: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 ( '78240' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 10/01/2023 03:48:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 03:48:29 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' , '99' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.50' , NOW() , NOW() ) 10/01/2023 03:48: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 = '78241' 10/01/2023 03:48:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '78241' 10/01/2023 03:48: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 ( '78241' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 10/01/2023 04:25:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 04:25: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' , '100' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 10/01/2023 04:25: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 = '78242' 10/01/2023 04:25:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '78242' 10/01/2023 04:25: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 ( '78242' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 10/01/2023 04:25: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 ( '78242' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/01/2023 04:27:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '78211' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 10/01/2023 04:27:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '73', document_date = '2023-01-09', 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 = '20.70', price_tax_excluded = '16.97', date_upd = NOW() WHERE id_document = '78211' 10/01/2023 04:27:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78211' 10/01/2023 04:27:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '78211' 10/01/2023 04:27:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78211' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '1.10' ) 10/01/2023 04:27:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78211' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '4' , '-4' , '1' , '4.9' , '4.016393442623' , '22' , '0' , '19.60' ) 10/01/2023 04:46:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 04:46: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' , '101' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.00' , '81.15' , NOW() , NOW() ) 10/01/2023 04:46: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 = '78243' 10/01/2023 04:46:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '78243' 10/01/2023 04:46: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 ( '78243' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 10/01/2023 05:00:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 05:00: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 ( '11' , '102' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 10/01/2023 05:00: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 = '78244' 10/01/2023 05:00:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '78244' 10/01/2023 05:00: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 ( '78244' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 10/01/2023 05:18:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2385' 10/01/2023 05:18:53 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '2385' , '10' , '210' , 'PARR. S. MARTINO E QUIRICO' , 'DEL REGNO' , ' DON ANIELLO' , 'VIA CAMPOMANFOLI' , '' , '84084' , 'LANCUSI BOLANO' , '' , '' , '' , '' , '97000080651' , NOW() , NOW() ) 10/01/2023 05:18:53 pm >> UPDATE ps_customer SET email = 'donandere@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2385' 10/01/2023 05:20:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 05:20: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 ( '21' , '4' , '2023-01-10' , '' , '2385' , '0' , '4678090' , 'VIA CAMPOMANFOLI 84084 LANCUSI BOLANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '121.13' , '121.13' , NOW() , NOW() ) 10/01/2023 05:20: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 = '78245' 10/01/2023 05:20:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '78245' 10/01/2023 05:20: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 ( '78245' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 10/01/2023 05:20: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 ( '78245' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '35' , '-35' , '4' , '3.50' , '3.5' , '0' , '15' , '104.13' ) 10/01/2023 05:22:36 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2385' 10/01/2023 05:22:36 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '2385' , '10' , '210' , 'PARR. S. MARTINO E QUIRICO' , 'DEL REGNO' , ' DON ANIELLO' , 'PIAZZA REGINA MARGHERITA' , '' , '84084' , 'LANCUSI BOLANO' , '' , '' , '' , '' , '97000080651' , NOW() , NOW() ) 10/01/2023 05:22:36 pm >> UPDATE ps_customer SET email = 'donandere@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2385' 10/01/2023 05:28:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '4/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 05:28:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '4/A' , '2023-01-10' , 'A' , '949' , '0' , '4671033' , 'VIA P. PALMIERI, 39 10138 TORINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 10/01/2023 05:28: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 = '78246' 10/01/2023 05:28:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '78246' 10/01/2023 05:28: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 ( '78246' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.00' , '85' , '' , '0' , '85.00' ) 10/01/2023 05:31:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 05:31:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '103' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 10/01/2023 05:31:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78247' 10/01/2023 05:31:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '78247' 10/01/2023 05:31:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78247' , '20585' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2023' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/01/2023 06:13:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 06:13:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '104' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.07' , '33.07' , NOW() , NOW() ) 10/01/2023 06:13:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78248' 10/01/2023 06:13:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '78248' 10/01/2023 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78248' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 10/01/2023 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78248' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/01/2023 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78248' , '18643' , 'BEATITUDINI - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/01/2023 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78248' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 10/01/2023 06:29:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 06:29:29 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' , '105' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 10/01/2023 06:29: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 = '78249' 10/01/2023 06:29:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '78249' 10/01/2023 06:29: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 ( '78249' , '13947' , 'NELLA MIA LOTTA, SIGNORE, SII TU A LOTTARE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/01/2023 06:41:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 06:41:48 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' , '106' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 10/01/2023 06:41:48 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 = '78250' 10/01/2023 06:41:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '78250' 10/01/2023 06:41:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78250' , '20266' , 'MISTICA CITTA DI DIO DI MARIA DI GESU DAGREDA - S. SCIORIO' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 10/01/2023 06:41:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78250' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/01/2023 06:49:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 10/01/2023 06:49:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '107' , '2023-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 10/01/2023 06:49:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78251' 10/01/2023 06:49:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '78251' 10/01/2023 06:49:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78251' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/01/2023 07:28:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '45' AND id_document != '78179' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 10/01/2023 07:28:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '45', document_date = '2023-01-04', 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 = '78179' 10/01/2023 07:28: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 = '78179' 10/01/2023 07:28:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '78179' 10/01/2023 07:28: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 ( '78179' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.75' , '4.75' , '0' , '0' , '4.75' ) 10/01/2023 07:28: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 ( '78179' , '13947' , 'NELLA MIA LOTTA, SIGNORE, SII TU A LOTTARE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/01/2023 07:40:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '45' AND id_document != '78179' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 10/01/2023 07:40:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '45', document_date = '2023-01-04', 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 = '78179' 10/01/2023 07:40: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 = '78179' 10/01/2023 07:40:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '78179' 10/01/2023 07:40: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 ( '78179' , '13947' , 'NELLA MIA LOTTA, SIGNORE, SII TU A LOTTARE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/01/2023 07:40: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 ( '78179' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/01/2023 07:41:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '59' AND id_document != '78194' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-05') 10/01/2023 07:41:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '59', document_date = '2023-01-05', 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 = '8.90', price_tax_excluded = '8.90', date_upd = NOW() WHERE id_document = '78194' 10/01/2023 07:41:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78194' 10/01/2023 07:41:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '78194' 10/01/2023 07:41:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78194' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '4.1' , '4.1' , '0' , '0' , '8.20' ) 10/01/2023 07:41:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78194' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' )