31/01/2025 08:54:35 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2025 08:54:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23394' , '1' , '' , 'nuovo-prodotto' ) 31/01/2025 08:54:35 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23394' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2025 08:54:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23394' , '0' , '1' , '0' , '0' ) 31/01/2025 08:55:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788874771851' AND id_product != '23394' AND ean13 != '' 31/01/2025 08:55:28 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788874771851', date_upd = NOW() WHERE id_product = '23394' 31/01/2025 08:55:28 am >> UPDATE ps_product_lang SET name = 'VANGELO DI GESU\' ', description = '' WHERE id_product = '23394' 31/01/2025 08:55:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '23394' 31/01/2025 08:55:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '246', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23394' 31/01/2025 08:55:28 am >> DELETE FROM ps_specific_price WHERE id_product = '23394' 31/01/2025 08:55:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '688219' , '2025-01-29' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.02' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '71.31' , '71.31' , NOW() , NOW() ) 31/01/2025 08:55:55 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 = '95511' 31/01/2025 08:55:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95511' 31/01/2025 08:55:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95511' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 31/01/2025 08:55:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '20948' AND id_supplier = '7' 31/01/2025 08:55:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20948' , '7' , '1' ) 31/01/2025 08:55:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95511' , '20033' , 'CAMMINO DEL DESIDERIO - G. PICCOLO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33' , '21.4400' ) 31/01/2025 08:55:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '20033' AND id_supplier = '7' 31/01/2025 08:55:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20033' , '7' , '1' ) 31/01/2025 08:55:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95511' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '1' , '4' , '24.00' , '24' , '0' , '30' , '16.8000' ) 31/01/2025 08:55:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '8416' AND id_supplier = '7' 31/01/2025 08:55:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8416' , '7' , '1' ) 31/01/2025 08:55:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95511' , '23394' , 'VANGELO DI GESU ' , '4' , '4' , '4' , '9.00' , '9' , '0' , '30' , '25.2000' ) 31/01/2025 08:55:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '23394' AND id_supplier = '7' 31/01/2025 08:55:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23394' , '7' , '1' ) 31/01/2025 09:12:25 am >> SELECT document_num FROM ps_document WHERE document_num = '318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 09:12:25 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' , '318' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.55' , '5.55' , NOW() , NOW() ) 31/01/2025 09:12:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95512' 31/01/2025 09:12:25 am >> DELETE FROM ps_document_detail WHERE id_document = '95512' 31/01/2025 09:12:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95512' , '23393' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2025 09:12:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95512' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 31/01/2025 09:17:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839918680' AND id_product != '8416' AND ean13 != '' 31/01/2025 09:17:06 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/7', ean13 = '9788839918680', date_upd = NOW() WHERE id_product = '8416' 31/01/2025 09:17:06 am >> UPDATE ps_product_lang SET name = 'PREPARARE E CELEBRARE - TRIDUO PASQUALE', description = '' WHERE id_product = '8416' 31/01/2025 09:17:06 am >> UPDATE ps_product SET wholesale_price = '14.00', on_sale = '0', price = '24.0000' WHERE id_product = '8416' 31/01/2025 09:17:06 am >> UPDATE ps_product_shop SET wholesale_price = '14.00', price = '24.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8416' 31/01/2025 09:17:06 am >> DELETE FROM ps_specific_price WHERE id_product = '8416' 31/01/2025 09:18:49 am >> SELECT document_num FROM ps_document WHERE document_num = '182' AND id_document != '95337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 31/01/2025 09:18:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '182', document_date = '2025-01-18', 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 = '17.00', price_tax_excluded = '13.93', date_upd = NOW() WHERE id_document = '95337' 31/01/2025 09:18: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 = '95337' 31/01/2025 09:18:49 am >> DELETE FROM ps_document_detail WHERE id_document = '95337' 31/01/2025 09:18: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 ( '95337' , '22300' , 'BRUCIA INCENSO NIKEL CM 8' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 31/01/2025 09:18: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 ( '95337' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '6' , '-6' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '3.00' ) 31/01/2025 09:19:39 am >> SELECT document_num FROM ps_document WHERE document_num = '209' AND id_document != '95368' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-21') 31/01/2025 09:19:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '209', document_date = '2025-01-21', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '95368' 31/01/2025 09:19:39 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 = '95368' 31/01/2025 09:19:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95368' 31/01/2025 09:19: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 ( '95368' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 31/01/2025 09:19: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 ( '95368' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '15' , '-15' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '3.00' ) 31/01/2025 09:29:58 am >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 09:29: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' , '319' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.75' , '17.52' , NOW() , NOW() ) 31/01/2025 09:29: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 = '95513' 31/01/2025 09:29:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95513' 31/01/2025 09:29: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 ( '95513' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2025 09:29: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 ( '95513' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/01/2025 09:40:09 am >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 09:40:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '32/A' , '2025-01-31' , 'A' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '213.20' , '213.20' , NOW() , NOW() ) 31/01/2025 09:40:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95514' 31/01/2025 09:40:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95514' 31/01/2025 09:40:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95514' , '5929' , 'LODI E VESPRI' , '52' , '-52' , '4' , '4.1' , '4.1' , '0' , '0' , '213.20' ) 31/01/2025 10:14:05 am >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:14:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '320' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.73' , NOW() , NOW() ) 31/01/2025 10: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 = '95515' 31/01/2025 10:14:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95515' 31/01/2025 10:14:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95515' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/01/2025 10:22:49 am >> SELECT document_num FROM ps_document WHERE document_num = '321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:22: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' , '321' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.40' , '132.11' , NOW() , NOW() ) 31/01/2025 10:22: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 = '95516' 31/01/2025 10:22:49 am >> DELETE FROM ps_document_detail WHERE id_document = '95516' 31/01/2025 10:22: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 ( '95516' , '23341' , 'SPERA - PAPA FRANCESCO' , '2' , '-2' , '4' , '22.00' , '22' , '0' , '5' , '41.80' ) 31/01/2025 10:22: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 ( '95516' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.24' , '1.016393442623' , '22' , '0' , '1.24' ) 31/01/2025 10:22: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 ( '95516' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 31/01/2025 10:22: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 ( '95516' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/01/2025 10:22: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 ( '95516' , '23019' , 'SPERANZA NON DELUDE - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 31/01/2025 10:22: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 ( '95516' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 31/01/2025 10:22: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 ( '95516' , '23013' , 'EUCARISTIA LA MIA AUTOSTRADA N.E. - CARLO ACUTIS' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/01/2025 10:22: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 ( '95516' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 31/01/2025 10:22: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 ( '95516' , '23327' , 'ABBIAMO CONOSCIUTO LAMORE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 31/01/2025 10:23:13 am >> SELECT document_num FROM ps_document WHERE document_num = '322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:23:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '322' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '695.00' , '569.67' , NOW() , NOW() ) 31/01/2025 10:23:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95517' 31/01/2025 10:23:13 am >> DELETE FROM ps_document_detail WHERE id_document = '95517' 31/01/2025 10:23:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95517' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '695' , '569.67213114754' , '22' , '0' , '695.00' ) 31/01/2025 10:25:29 am >> SELECT document_num FROM ps_document WHERE document_num = '323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:25:29 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' , '323' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 31/01/2025 10:25:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95518' 31/01/2025 10:25:29 am >> DELETE FROM ps_document_detail WHERE id_document = '95518' 31/01/2025 10:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95518' , '17786' , 'CROCE METALLO CM 10 - FX125-SA' , '1' , '-1' , '1' , '9.80' , '8.0327868852459' , '22' , '0' , '9.80' ) 31/01/2025 10:42:52 am >> SELECT document_num FROM ps_document WHERE document_num = '324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:42:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '324' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '22.80' , NOW() , NOW() ) 31/01/2025 10:42:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95519' 31/01/2025 10:42:52 am >> DELETE FROM ps_document_detail WHERE id_document = '95519' 31/01/2025 10:42:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95519' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '8' , '-8' , '4' , '3.00' , '3' , '0' , '5' , '22.80' ) 31/01/2025 10:43:28 am >> SELECT document_num FROM ps_document WHERE document_num = '325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:43:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '325' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 31/01/2025 10:43:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95520' 31/01/2025 10:43:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95520' 31/01/2025 10:43:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95520' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 31/01/2025 10:56:52 am >> SELECT document_num FROM ps_document WHERE document_num = '326' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 10:56:53 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' , '326' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.86' , '85.79' , NOW() , NOW() ) 31/01/2025 10:56:53 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 = '95521' 31/01/2025 10:56:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95521' 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '23393' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 31/01/2025 10:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '6809' , 'MOCCOLO 60X165' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 31/01/2025 11:27:29 am >> SELECT document_num FROM ps_document WHERE document_num = '327' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:27:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '327' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '70.00' , NOW() , NOW() ) 31/01/2025 11:27: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 = '95522' 31/01/2025 11:27:30 am >> DELETE FROM ps_document_detail WHERE id_document = '95522' 31/01/2025 11:27: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 ( '95522' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '70' , '70' , '0' , '0' , '70.00' ) 31/01/2025 11:30:11 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2025 11:30:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23395' , '1' , '' , 'nuovo-prodotto' ) 31/01/2025 11:30:11 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23395' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2025 11:30:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23395' , '0' , '1' , '0' , '0' ) 31/01/2025 11:30:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788891830852' AND id_product != '23395' AND ean13 != '' 31/01/2025 11:30:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788891830852', date_upd = NOW() WHERE id_product = '23395' 31/01/2025 11:30:58 am >> UPDATE ps_product_lang SET name = 'FINCHE\' MUTUO NON CI SEPARI', description = '' WHERE id_product = '23395' 31/01/2025 11:30:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.9' WHERE id_product = '23395' 31/01/2025 11:30:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.9', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23395' 31/01/2025 11:30:58 am >> DELETE FROM ps_specific_price WHERE id_product = '23395' 31/01/2025 11:31:00 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23395' 31/01/2025 11:31:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23396' , '1' , '' , 'nuovo-prodotto' ) 31/01/2025 11:31:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23396' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23395' 31/01/2025 11:31:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23396' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23395' 31/01/2025 11:32:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256270200' AND id_product != '23396' AND ean13 != '' 31/01/2025 11:32:11 am >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9791256270200', date_upd = NOW() WHERE id_product = '23396' 31/01/2025 11:32:11 am >> UPDATE ps_product_lang SET name = 'SPIRITUALITA\' E TEOLOGIA - A. STAGLIANO\'', description = '' WHERE id_product = '23396' 31/01/2025 11:32:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '23396' 31/01/2025 11:32:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '137', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23396' 31/01/2025 11:32:11 am >> DELETE FROM ps_specific_price WHERE id_product = '23396' 31/01/2025 11:34:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1556804' , '2025-01-30' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.90' , '105.90' , NOW() , NOW() ) 31/01/2025 11:34:14 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 = '95523' 31/01/2025 11:34:14 am >> DELETE FROM ps_document_detail WHERE id_document = '95523' 31/01/2025 11:34:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95523' , '23395' , 'FINCHE MUTUO NON CI SEPARI' , '1' , '1' , '4' , '19.90' , '19.9' , '0' , '0' , '19.90' ) 31/01/2025 11:34:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23395' AND id_supplier = '177' 31/01/2025 11:34:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23395' , '177' , '1' ) 31/01/2025 11:34:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95523' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' , '5' , '4' , '12.00' , '12' , '0' , '0' , '60.0000' ) 31/01/2025 11:34:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 31/01/2025 11:34:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 31/01/2025 11:34:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95523' , '23396' , 'SPIRITUALITA\' E TEOLOGIA - A. STAGLIANO\'' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 31/01/2025 11:34:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '23396' AND id_supplier = '177' 31/01/2025 11:34:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23396' , '177' , '1' ) 31/01/2025 11:40:12 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:40:12 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' , '20' , '2025-01-31' , '' , '161' , '0' , '4679379' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '319.20' , '319.20' , NOW() , NOW() ) 31/01/2025 11:40:12 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 = '95524' 31/01/2025 11:40:12 am >> DELETE FROM ps_document_detail WHERE id_document = '95524' 31/01/2025 11:40:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95524' , '23394' , 'VANGELO DI GESU ' , '4' , '-4' , '4' , '9.00' , '9' , '0' , '5' , '34.20' ) 31/01/2025 11:40:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95524' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '10' , '-10' , '4' , '12.00' , '12' , '0' , '5' , '114.00' ) 31/01/2025 11:40:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95524' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '60' , '-60' , '4' , '3.00' , '3' , '0' , '5' , '171.00' ) 31/01/2025 11:47:02 am >> SELECT document_num FROM ps_document WHERE document_num = '328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:47:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '328' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 31/01/2025 11:47:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95525' 31/01/2025 11:47:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95525' 31/01/2025 11:47:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95525' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13.5' , '11.065573770492' , '22' , '0' , '13.50' ) 31/01/2025 11:47:28 am >> SELECT document_num FROM ps_document WHERE document_num = '329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:47:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '329' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 31/01/2025 11:47:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95526' 31/01/2025 11:47:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95526' 31/01/2025 11:47:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95526' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 31/01/2025 11:51:28 am >> SELECT document_num FROM ps_document WHERE document_num = '328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:51:35 am >> SELECT document_num FROM ps_document WHERE document_num = '330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:51:35 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' , '330' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 31/01/2025 11:51:35 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 = '95527' 31/01/2025 11:51:35 am >> DELETE FROM ps_document_detail WHERE id_document = '95527' 31/01/2025 11:51:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95527' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 31/01/2025 11:52:12 am >> SELECT document_num FROM ps_document WHERE document_num = '326' AND id_document != '95521' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:52:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '326', document_date = '2025-01-31', 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 = '96.86', price_tax_excluded = '85.79', date_upd = NOW() WHERE id_document = '95521' 31/01/2025 11:52:12 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 = '95521' 31/01/2025 11:52:12 am >> DELETE FROM ps_document_detail WHERE id_document = '95521' 31/01/2025 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 31/01/2025 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 31/01/2025 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/01/2025 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 31/01/2025 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/01/2025 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '23393' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2025 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '6' , '-6' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '1.20' ) 31/01/2025 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 31/01/2025 11:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95521' , '6809' , 'MOCCOLO 60X165' , '3' , '-3' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '13.50' ) 31/01/2025 11:52:40 am >> SELECT document_num FROM ps_document WHERE document_num = '330' AND id_document != '95527' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:52:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '330', document_date = '2025-01-31', 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 = '2.50', price_tax_excluded = '2.05', date_upd = NOW() WHERE id_document = '95527' 31/01/2025 11:52: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 = '95527' 31/01/2025 11:52:40 am >> DELETE FROM ps_document_detail WHERE id_document = '95527' 31/01/2025 11:52: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 ( '95527' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 31/01/2025 11:52: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 ( '95527' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 31/01/2025 11:56:19 am >> SELECT document_num FROM ps_document WHERE document_num = '328' AND id_document != '95525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 11:56:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '328', document_date = '2025-01-31', 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 = '13.50', price_tax_excluded = '11.07', date_upd = NOW() WHERE id_document = '95525' 31/01/2025 11:56:19 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 = '95525' 31/01/2025 11:56:19 am >> DELETE FROM ps_document_detail WHERE id_document = '95525' 31/01/2025 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95525' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 31/01/2025 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95525' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.35' , '2.7459016393443' , '22' , '0' , '13.40' ) 31/01/2025 12:00:59 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2025 12:00:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23397' , '1' , '' , 'nuovo-prodotto' ) 31/01/2025 12:00:59 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23397' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2025 12:00:59 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23397' , '0' , '1' , '0' , '0' ) 31/01/2025 12:01:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '999/7D' AND id_product != '23397' AND ean13 != '' 31/01/2025 12:01:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '999/7D', date_upd = NOW() WHERE id_product = '23397' 31/01/2025 12:01:47 pm >> UPDATE ps_product_lang SET name = 'PATENA DORATA CM 25', description = '' WHERE id_product = '23397' 31/01/2025 12:01:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '172.13114754098362' WHERE id_product = '23397' 31/01/2025 12:01:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '172.13114754098362', id_tax_rules_group = '1', id_category_default = '480', 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 = '23397' 31/01/2025 12:01:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '23397' 31/01/2025 12:02:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '999/7D' AND id_product != '23397' AND ean13 != '' 31/01/2025 12:02:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '999/7D', date_upd = NOW() WHERE id_product = '23397' 31/01/2025 12:02:22 pm >> UPDATE ps_product_lang SET name = 'PATENA DORATA CM 25 - 999/7D', description = '' WHERE id_product = '23397' 31/01/2025 12:02:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '172.1311' WHERE id_product = '23397' 31/01/2025 12:02:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '172.1311', id_tax_rules_group = '1', id_category_default = '480', 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 = '23397' 31/01/2025 12:02:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '23397' 31/01/2025 12:02: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 ( '33' , '4' , '2025-01-29' , '' , '0' , '149' , '4671100' , 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 31/01/2025 12:02: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 = '95528' 31/01/2025 12:02:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '95528' 31/01/2025 12:02: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 ( '95528' , '23397' , 'PATENA DORATA CM 25 - 999/7D' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 31/01/2025 12:02:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23397' AND id_supplier = '149' 31/01/2025 12:02:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23397' , '149' , '1' ) 31/01/2025 12:07:27 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '46', document_date = '2025-01-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', 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 = '494.58', price_tax_excluded = '494.58', date_upd = NOW() WHERE id_document = '95286' 31/01/2025 12:07:27 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 = '95286' 31/01/2025 12:07:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '95286' 31/01/2025 12:07:27 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 ( '95286' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '2' , '2' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/01/2025 12:07:28 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 ( '95286' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '2' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/01/2025 12:07:28 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 ( '95286' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '2' , '2' , '4' , '35.0000' , '35' , '0' , '35' , '45.50' ) 31/01/2025 12:07:28 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 ( '95286' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '3' , '3' , '4' , '35.0000' , '35' , '0' , '30' , '73.50' ) 31/01/2025 12:07:28 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 ( '95286' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '2' , '2' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/01/2025 12:07:28 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 ( '95286' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 31/01/2025 12:07:28 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 ( '95286' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/01/2025 12:07:28 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 ( '95286' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '5' , '5' , '4' , '9.5000' , '9.5' , '0' , '45' , '26.13' ) 31/01/2025 12:07:28 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 ( '95286' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '2' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 31/01/2025 12:07:28 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 ( '95286' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '2' , '2' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 31/01/2025 12:07:28 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 ( '95286' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '3' , '3' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 31/01/2025 12:07:28 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 ( '95286' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '3' , '3' , '4' , '25.0000' , '25' , '0' , '35' , '48.75' ) 31/01/2025 12:07:28 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 ( '95286' , '10119' , 'SPE SALVI' , '1' , '1' , '4' , '2.0000' , '2' , '0' , '45' , '1.10' ) 31/01/2025 12:09: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 ( '32' , '2025 FV000115' , '2025-01-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '8' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '502.58' , '502.58' , NOW() , NOW() ) 31/01/2025 12:09: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 = '95529' 31/01/2025 12:09:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '95529' 31/01/2025 12:09: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 ( '95529' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '45.50' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22112' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22112' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '3' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '73.50' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '5' , '0' , '4' , '9.5000' , '9.5' , '0' , '45' , '26.13' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23313' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23313' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 31/01/2025 12:09:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 31/01/2025 12:09:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 31/01/2025 12:09:10 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 ( '95529' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 31/01/2025 12:09:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21615' AND id_supplier = '79' 31/01/2025 12:09:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21615' , '79' , '1' ) 31/01/2025 12:09:11 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 ( '95529' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '3' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '48.75' ) 31/01/2025 12:09:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 31/01/2025 12:09:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 31/01/2025 12:09:11 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 ( '95529' , '10119' , 'SPE SALVI' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '1.10' ) 31/01/2025 12:09:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10119' AND id_supplier = '79' 31/01/2025 12:09:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10119' , '79' , '1' ) 31/01/2025 12:35:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 12:35:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '21' , '2025-01-31' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '546.72' , '546.72' , NOW() , NOW() ) 31/01/2025 12:35:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95530' 31/01/2025 12:35:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '95530' 31/01/2025 12:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95530' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 31/01/2025 12:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95530' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 31/01/2025 12:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95530' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 31/01/2025 12:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95530' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 31/01/2025 12:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95530' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 31/01/2025 12:36:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 31/01/2025 12:36:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '11/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'DDT 124/A DEL 14/11/2024 - acconto 05/12 € 260,00', 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 = '281.60', price_tax_excluded = '250.66', date_upd = NOW() WHERE id_document = '94256' 31/01/2025 12:36:26 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 = '94256' 31/01/2025 12:36:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '94256' 31/01/2025 12:36:26 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 ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 31/01/2025 12:36:26 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 ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 31/01/2025 12:36:26 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 ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 31/01/2025 12:36:26 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 ( '94256' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '54.00' ) 31/01/2025 12:36:26 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 ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 31/01/2025 12:36:26 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 ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '14.40' ) 31/01/2025 12:39:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 12:39:59 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' , '331' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 31/01/2025 12:39:59 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 = '95531' 31/01/2025 12:39:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95531' 31/01/2025 12:39:59 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 ( '95531' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 31/01/2025 02:37:57 pm >> DELETE FROM ps_document WHERE id_document = '94256' 31/01/2025 02:37:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '94256' 31/01/2025 02:39:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 31/01/2025 02:39:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '94912' 31/01/2025 02:39:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 31/01/2025 02:39:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 31/01/2025 02:40:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '95345' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 31/01/2025 02:40:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '190', document_date = '2025-01-18', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '95345' 31/01/2025 02:40:06 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 = '95345' 31/01/2025 02:40:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '95345' 31/01/2025 02:40:06 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 ( '95345' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 31/01/2025 02:41:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '214' AND id_document != '95374' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-21') 31/01/2025 02:41:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '214', document_date = '2025-01-21', 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 = '28.00', price_tax_excluded = '22.95', date_upd = NOW() WHERE id_document = '95374' 31/01/2025 02:41:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95374' 31/01/2025 02:41:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95374' 31/01/2025 02:41:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95374' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '28' , '-28' , '1' , '1' , '0.81967213114754' , '22' , '0' , '28.00' ) 31/01/2025 02:41:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '275' AND id_document != '95458' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 31/01/2025 02:41:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '275', document_date = '2025-01-28', 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 = '281.21', price_tax_excluded = '251.80', date_upd = NOW() WHERE id_document = '95458' 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95458' 31/01/2025 02:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95458' 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '4' , '-4' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '40.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.06' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '8.60' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 31/01/2025 02:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95458' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 31/01/2025 02:42:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '95465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 31/01/2025 02:42:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '281', document_date = '2025-01-28', 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 = '10.40', price_tax_excluded = '8.52', date_upd = NOW() WHERE id_document = '95465' 31/01/2025 02:42:20 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 = '95465' 31/01/2025 02:42:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '95465' 31/01/2025 02:42:20 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 ( '95465' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '10.40' ) 31/01/2025 02:43:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '252' AND id_document != '95425' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 31/01/2025 02:43:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '252', document_date = '2025-01-24', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '95425' 31/01/2025 02:43: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 = '95425' 31/01/2025 02:43:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '95425' 31/01/2025 02:43:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95425' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '55' , '-55' , '1' , '1' , '0.81967213114754' , '22' , '0' , '55.00' ) 31/01/2025 02:45:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '273' AND id_document != '95456' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27') 31/01/2025 02:45:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '273', document_date = '2025-01-27', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '95456' 31/01/2025 02:45:12 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 = '95456' 31/01/2025 02:45:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95456' 31/01/2025 02:45:12 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 ( '95456' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 31/01/2025 02:45:12 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 ( '95456' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 31/01/2025 02:45:12 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 ( '95456' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 31/01/2025 02:45:12 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 ( '95456' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 31/01/2025 02:47:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '95349' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 31/01/2025 02:47:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '193', document_date = '2025-01-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'SAN LEONARDO 84090 GIFFONI SEI CASALI', 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 = '255.00', price_tax_excluded = '223.37', date_upd = NOW() WHERE id_document = '95349' 31/01/2025 02:47:10 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 = '95349' 31/01/2025 02:47:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95349' 31/01/2025 02:47:10 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 ( '95349' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '4.64' , '4.64' , '0' , '0' , '4.64' ) 31/01/2025 02:47:10 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 ( '95349' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 31/01/2025 02:47:10 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 ( '95349' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 31/01/2025 02:47:10 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 ( '95349' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '24' , '-24' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '24.00' ) 31/01/2025 02:47:10 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 ( '95349' , '19231' , 'CARD CARLO ACUTIS - RN93' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 31/01/2025 02:47:10 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 ( '95349' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 31/01/2025 02:47:10 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 ( '95349' , '18131' , 'TAU MEDIO CM3 - T6/t5' , '12' , '-12' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '12.00' ) 31/01/2025 02:47:10 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 ( '95349' , '22923' , 'ROLL UP GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 31/01/2025 02:47:10 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 ( '95349' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 31/01/2025 02:47:10 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 ( '95349' , '23120' , 'AMEN - GEN 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 31/01/2025 02:47:10 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 ( '95349' , '23119' , 'AMEN - FEB 25' , '4' , '-4' , '4' , '3.9000' , '3.9' , '0' , '5' , '14.84' ) 31/01/2025 02:47:10 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 ( '95349' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 31/01/2025 02:48:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '327' AND id_document != '95522' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 02:48:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '327', document_date = '2025-01-31', 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 = '70.00', price_tax_excluded = '70.00', date_upd = NOW() WHERE id_document = '95522' 31/01/2025 02:48:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95522' 31/01/2025 02:48:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95522' 31/01/2025 02:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95522' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '35.6' , '35.6' , '0' , '0' , '35.60' ) 31/01/2025 02:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95522' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '3' , '-3' , '4' , '4.5' , '4.5' , '0' , '0' , '13.50' ) 31/01/2025 02:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95522' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 31/01/2025 03:12:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 03:12:24 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' , '332' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 31/01/2025 03:12:24 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 = '95532' 31/01/2025 03:12:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '95532' 31/01/2025 03:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95532' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 31/01/2025 03:48:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 03:48:27 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' , '333' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.23' , NOW() , NOW() ) 31/01/2025 03:48:27 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 = '95533' 31/01/2025 03:48:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '95533' 31/01/2025 03:48:27 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 ( '95533' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/01/2025 03:56:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '95275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-14') 31/01/2025 03:56:36 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2025-01-14', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '142.90', price_tax_excluded = '134.82', date_upd = NOW() WHERE id_document = '95275' 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95275' 31/01/2025 03:56:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95275' 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '30' , '-30' , '4' , '0.7000' , '0.7' , '0' , '0' , '21.00' ) 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '2' , '-2' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '34.00' ) 31/01/2025 03:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '' , 'CANDELE' , '1' , '-1' , '0' , '70' , '70' , '' , '0' , '70.00' ) 31/01/2025 04:46:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 04:46:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '334' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.50' , '78.16' , NOW() , NOW() ) 31/01/2025 04:46: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 = '95534' 31/01/2025 04:46:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95534' 31/01/2025 04:46: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 ( '95534' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 31/01/2025 04:46: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 ( '95534' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 31/01/2025 04:46: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 ( '95534' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '40' , '-40' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '76.00' ) 31/01/2025 04:49:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 04:49:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '335' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.30' , '7.62' , NOW() , NOW() ) 31/01/2025 04:49: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 = '95535' 31/01/2025 04:49:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '95535' 31/01/2025 04:49: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 ( '95535' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 31/01/2025 04:49: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 ( '95535' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 31/01/2025 05:04:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 05:04: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 ( '11' , '336' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.70' , '69.43' , NOW() , NOW() ) 31/01/2025 05:04: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 = '95536' 31/01/2025 05:04:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95536' 31/01/2025 05:04: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 ( '95536' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 31/01/2025 05:04: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 ( '95536' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 31/01/2025 05:39:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '337' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 05:39:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '337' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 31/01/2025 05:39:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95537' 31/01/2025 05:39:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '95537' 31/01/2025 05:39:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95537' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 31/01/2025 05:39:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 05:39:24 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' , '338' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 31/01/2025 05:39:24 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 = '95538' 31/01/2025 05:39:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '95538' 31/01/2025 05:39:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95538' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/01/2025 05:39:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95538' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 31/01/2025 06:06:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 06:06:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '339' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 31/01/2025 06:06:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95539' 31/01/2025 06:06:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '95539' 31/01/2025 06:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95539' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 31/01/2025 06:23:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 06:23:28 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' , '340' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 31/01/2025 06:23:28 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 = '95540' 31/01/2025 06:23:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '95540' 31/01/2025 06:23:28 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 ( '95540' , '10119' , 'SPE SALVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 31/01/2025 06:36:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 06:36:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '341' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 31/01/2025 06:36:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95541' 31/01/2025 06:36:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '95541' 31/01/2025 06:36:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95541' , '15088' , 'QUADRETTO EFFETTO PIETRA - MIRACOLOSA - 2952' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 31/01/2025 06:36:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95541' , '17465' , 'QUADRETTO EFFETTO PIETRA MIRACOLOSA E MEDAGLIA 2952/M4' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 31/01/2025 06:36:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95541' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 31/01/2025 07:10:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 07:10:52 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' , '342' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 31/01/2025 07:10:52 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 = '95542' 31/01/2025 07:10:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '95542' 31/01/2025 07:10:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95542' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 31/01/2025 07:52:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '95453' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-27') 31/01/2025 07:52:05 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '15', document_date = '2025-01-27', document_letter = '', id_customer = '4158', id_supplier = '', id_address = '4679457', address1 = 'VIA ANTONIO BENNICELLI 71 000151 ROMA', address2 = '', note = '', price_shipping = '3.10', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '19.25', price_tax_excluded = '19.25', date_upd = NOW() WHERE id_document = '95453' 31/01/2025 07:52: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 = '95453' 31/01/2025 07:52:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '95453' 31/01/2025 07:52: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 ( '95453' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3.80' , '3.8' , '0' , '15' , '16.15' ) 31/01/2025 07:57:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 31/01/2025 07:57:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '343' , '2025-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 31/01/2025 07:57:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95543' 31/01/2025 07:57:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '95543' 31/01/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95543' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 31/01/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95543' , '19362' , 'LUMINO DIAMANTE VARI COLORI' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' )