20/03/2023 09:44:00 am >> SELECT document_num FROM ps_document WHERE document_num = '892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 09:44:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '892' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '163.00' , '133.61' , NOW() , NOW() ) 20/03/2023 09:44:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82362' 20/03/2023 09:44:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82362' 20/03/2023 09:44:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82362' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '150.00' ) 20/03/2023 09:44:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82362' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 20/03/2023 09:44:36 am >> SELECT document_num FROM ps_document WHERE document_num = '893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 09:44:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '893' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.00' , '120.49' , NOW() , NOW() ) 20/03/2023 09:44:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82363' 20/03/2023 09:44:36 am >> DELETE FROM ps_document_detail WHERE id_document = '82363' 20/03/2023 09:44:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82363' , '17352' , 'STOLA MARIANA MISTO SETA- 1021 AM' , '1' , '-1' , '1' , '147' , '120.49180327869' , '22' , '0' , '147.00' ) 20/03/2023 10:51:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '828/23' , '2023-03-10' , '23' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1077.55' , '1036.11' , NOW() , NOW() ) 20/03/2023 10:51:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82364' 20/03/2023 10:51:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82364' 20/03/2023 10:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82364' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '350' , '350' , '3' , '2' , '1.9230769230769' , '4' , '0' , '728.0000' ) 20/03/2023 10:51:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 20/03/2023 10:51:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 20/03/2023 10:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82364' , '16689' , 'OSTIA PAN DI CENA mm80' , '150' , '150' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '181.5840' ) 20/03/2023 10:51:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 20/03/2023 10:51:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 20/03/2023 10:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82364' , '7311' , 'OSTIA SOTTILE 74MM' , '150' , '150' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '167.9652' ) 20/03/2023 10:51:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 20/03/2023 10:51:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 20/03/2023 11:03:37 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' , '000110' , '2023-03-20' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , 'INVIATE A BYBLOS' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 20/03/2023 11:03:37 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 = '82365' 20/03/2023 11:03:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82365' 20/03/2023 11:03:37 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 ( '82365' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '1' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/03/2023 11:03:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '20785' AND id_supplier = '145' 20/03/2023 11:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20785' , '145' , '1' ) 20/03/2023 11:04:19 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' , '000111' , '2023-03-20' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 20/03/2023 11:04: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 = '82366' 20/03/2023 11:04:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82366' 20/03/2023 11:04: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 ( '82366' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '400' , '400' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/03/2023 11:04:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '20785' AND id_supplier = '145' 20/03/2023 11:04:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20785' , '145' , '1' ) 20/03/2023 11:27:19 am >> SELECT document_num FROM ps_document WHERE document_num = '803' AND id_document != '82250' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 20/03/2023 11:27:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '803', document_date = '2023-03-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.00', price_tax_excluded = '39.00', date_upd = NOW() WHERE id_document = '82250' 20/03/2023 11:27: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 = '82250' 20/03/2023 11:27:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82250' 20/03/2023 11:27: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 ( '82250' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 20/03/2023 11:27: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 ( '82250' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 20/03/2023 11:27: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 ( '82250' , '18314' , 'FARE DI CRISTO IL CUORE... FESTIVO - E. DELLA CORTE' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 20/03/2023 12:16:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 12:16:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '894' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '383.40' , '330.49' , NOW() , NOW() ) 20/03/2023 12:16:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82367' 20/03/2023 12:16:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '82367' 20/03/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82367' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '30.00' ) 20/03/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82367' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 20/03/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82367' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '150' , '-150' , '4' , '0.6' , '0.6' , '0' , '0' , '90.00' ) 20/03/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82367' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 20/03/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82367' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '29.40' ) 20/03/2023 12:36:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 12:36:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '895' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.35' , '141.32' , NOW() , NOW() ) 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82368' 20/03/2023 12:36:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82368' 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82368' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82368' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '10' , '10' , '0' , '0' , '30.00' ) 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82368' , '11960' , 'PASSIO' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82368' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82368' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 20/03/2023 12:36:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82368' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '-1' , '4' , '1.60' , '1.6' , '0' , '0' , '1.60' ) 20/03/2023 12:54:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '430/TPN' AND id_product != '13932' AND ean13 != '' 20/03/2023 12:54:33 pm >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '430/TPN', date_upd = NOW() WHERE id_product = '13932' 20/03/2023 12:54:33 pm >> UPDATE ps_product_lang SET name = 'CAMICE TALARE NERO', description = '' WHERE id_product = '13932' 20/03/2023 12:54:33 pm >> UPDATE ps_product SET wholesale_price = '36.00', on_sale = '0', price = '90.16393442622952' WHERE id_product = '13932' 20/03/2023 12:54:33 pm >> UPDATE ps_product_shop SET wholesale_price = '36.00', price = '90.16393442622952', id_tax_rules_group = '1', id_category_default = '396', 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 = '13932' 20/03/2023 12:54:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '13932' 20/03/2023 04:09:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 04:09: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' , '896' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 20/03/2023 04:09: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 = '82369' 20/03/2023 04:09:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82369' 20/03/2023 04:09: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 ( '82369' , '16294' , 'ALBUM DEL MIO BATTESIMO CELESTE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 20/03/2023 04:22:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 04:22:06 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' , '897' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.75' , '37.75' , NOW() , NOW() ) 20/03/2023 04:22: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 = '82370' 20/03/2023 04:22:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82370' 20/03/2023 04:22: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 ( '82370' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 20/03/2023 04:22: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 ( '82370' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 20/03/2023 04:28:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 04:28:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '898' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.40' , '21.64' , NOW() , NOW() ) 20/03/2023 04:28:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82371' 20/03/2023 04:28:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '82371' 20/03/2023 04:28:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82371' , '20516' , 'CROCE COMUNIONE - 42/08' , '22' , '-22' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '26.40' ) 20/03/2023 04:43:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/A' AND id_document != '81217' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-03') 20/03/2023 04:43:41 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '17/A', document_date = '2023-02-03', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', address2 = '', note = 'spedito il 6/2 (ricordarsi fattura 5/E)', 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 = '414.00', price_tax_excluded = '339.34', date_upd = NOW() WHERE id_document = '81217' 20/03/2023 04:43: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 = '81217' 20/03/2023 04:43:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '81217' 20/03/2023 04:43: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 ( '81217' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 20/03/2023 04:43: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 ( '81217' , '' , 'spediti il 21/03/2023' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 20/03/2023 04:43: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 ( '81217' , '12816' , 'LIBRO DEI DEFUNTI' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '48.00' ) 20/03/2023 04:43: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 ( '81217' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 20/03/2023 04:43: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 ( '81217' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 20/03/2023 04:43: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 ( '81217' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '72.00' ) 20/03/2023 04:43: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 ( '81217' , '12814' , 'LIBRO DEI BATTEZZATI' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '48.00' ) 20/03/2023 05:12:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 05:12:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '899' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '151.20' , '126.86' , NOW() , NOW() ) 20/03/2023 05:12: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 = '82372' 20/03/2023 05:12:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82372' 20/03/2023 05:12: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 ( '82372' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 20/03/2023 05:12: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 ( '82372' , '20820' , 'CUORE CI PARLA DI DIO - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.2' , '16.2' , '0' , '0' , '16.20' ) 20/03/2023 05:53:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '900' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 05:53:53 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' , '900' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 20/03/2023 05:53:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82373' 20/03/2023 05:53:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '82373' 20/03/2023 05:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82373' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 20/03/2023 06:13:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 06:13: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' , '901' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 20/03/2023 06:13: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 = '82374' 20/03/2023 06:13:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82374' 20/03/2023 06:13: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 ( '82374' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.18' , '0.14754098360656' , '22' , '0' , '36.00' ) 20/03/2023 06:22:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 20/03/2023 06:22:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '902' , '2023-03-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 20/03/2023 06:22: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 = '82375' 20/03/2023 06:22:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82375' 20/03/2023 06:22: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 ( '82375' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 20/03/2023 06:25:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 20/03/2023 06:25:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 200,00 - 27/12 € 200,00 + € 100 ', 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 = '2700.00', price_tax_excluded = '2213.11', date_upd = NOW() WHERE id_document = '75504' 20/03/2023 06:25:40 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 = '75504' 20/03/2023 06:25:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '75504' 20/03/2023 06:25:40 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 ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 20/03/2023 06:25:40 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 ( '75504' , '0' , 'ACCONTO 200€' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/03/2023 06:34:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 20/03/2023 06:34:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 200,00 - 27/12 € 200,00 + € 100 20/3/23', 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 = '2700.00', price_tax_excluded = '2213.11', date_upd = NOW() WHERE id_document = '75504' 20/03/2023 06:34:15 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 = '75504' 20/03/2023 06:34:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '75504' 20/03/2023 06:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 20/03/2023 06:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '0' , 'ACCONTO 220€' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 20/03/2023 06:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '' , 'acconto € 200 27/12/2022' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 20/03/2023 06:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '' , 'acconto € 100,00 20/03/2023' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' )