23/12/2022 08:46:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839921451' AND id_product != '5599' AND ean13 != '' 23/12/2022 08:46:49 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/7', ean13 = '9788839921451', date_upd = NOW() WHERE id_product = '5599' 23/12/2022 08:46:49 am >> UPDATE ps_product_lang SET name = 'LECTIO DIVINA OGNI GIORNO - 9', description = '' WHERE id_product = '5599' 23/12/2022 08:46:49 am >> UPDATE ps_product SET wholesale_price = '13.30', on_sale = '0', price = '20' WHERE id_product = '5599' 23/12/2022 08:46:49 am >> UPDATE ps_product_shop SET wholesale_price = '13.30', price = '20', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5599' 23/12/2022 08:46:49 am >> DELETE FROM ps_specific_price WHERE id_product = '5599' 23/12/2022 09:38:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 09:38:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4044' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 23/12/2022 09:38:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77485' 23/12/2022 09:38:59 am >> DELETE FROM ps_document_detail WHERE id_document = '77485' 23/12/2022 09:38:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77485' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 23/12/2022 09:39:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/12/2022 09:39:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/12/2022 09:50:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 09:50: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' , '4045' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 23/12/2022 09:50: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 = '77486' 23/12/2022 09:50:05 am >> DELETE FROM ps_document_detail WHERE id_document = '77486' 23/12/2022 09:50: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 ( '77486' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/12/2022 09:50:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/12/2022 09:50:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/12/2022 10:18:51 am >> SELECT document_num FROM ps_document WHERE document_num = '4046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:18:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4046' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '34.32' , NOW() , NOW() ) 23/12/2022 10:18:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77487' 23/12/2022 10:18:51 am >> DELETE FROM ps_document_detail WHERE id_document = '77487' 23/12/2022 10:18: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 ( '77487' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '9.2' , '7.5409836065574' , '22' , '0' , '9.20' ) 23/12/2022 10:18:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/12/2022 10:18:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/12/2022 10:18: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 ( '77487' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 23/12/2022 10:18:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 23/12/2022 10:18:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 23/12/2022 10:18: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 ( '77487' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/12/2022 10:18:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/12/2022 10:18:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/12/2022 10:18: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 ( '77487' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 23/12/2022 10:18:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/12/2022 10:18:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/12/2022 10:21:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:21:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4047' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 23/12/2022 10:21:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77488' 23/12/2022 10:21:59 am >> DELETE FROM ps_document_detail WHERE id_document = '77488' 23/12/2022 10:21:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77488' , '20222' , 'BAMBINO IN GESSO CM 20 - IE76/20' , '1' , '-1' , '1' , '140.00' , '114.75409836066' , '22' , '0' , '140.00' ) 23/12/2022 10:21:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '20222' AND id_supplier = '' 23/12/2022 10:21:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20222' , '' , '1' ) 23/12/2022 10:34:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:34: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' , '4048' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 23/12/2022 10:34: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 = '77489' 23/12/2022 10:34:05 am >> DELETE FROM ps_document_detail WHERE id_document = '77489' 23/12/2022 10:34: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 ( '77489' , '19998' , 'GESU\' BAMBINO CM 28 - BJ142-28E' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 23/12/2022 10:34:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19998' AND id_supplier = '' 23/12/2022 10:34:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19998' , '' , '1' ) 23/12/2022 10:34:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77489' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 23/12/2022 10:34:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/12/2022 10:34:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/12/2022 10:44:51 am >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '76115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-06') 23/12/2022 10:44:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '109/A', document_date = '2022-12-06', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA SAN LEONARDO', 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 = '275.44', price_tax_excluded = '240.41', date_upd = NOW() WHERE id_document = '76115' 23/12/2022 10:44:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76115' 23/12/2022 10:44:51 am >> DELETE FROM ps_document_detail WHERE id_document = '76115' 23/12/2022 10:44:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '20440' , 'AMEN - FEB. 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '20441' , 'AMEN - GEN. 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 23/12/2022 10:44: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 ( '76115' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.56' , '0.56' , '0' , '0' , '28.00' ) 23/12/2022 10:44:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 23/12/2022 10:44:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 23/12/2022 10:45:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:45:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4049' , '2022-12-23' , '' , '' , '' , '' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '275.44' , '240.41' , NOW() , NOW() ) 23/12/2022 10:45:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77490' 23/12/2022 10:45:36 am >> DELETE FROM ps_document_detail WHERE id_document = '77490' 23/12/2022 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77490' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5574' , '22' , '0' , '48.00' ) 23/12/2022 10:45:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 23/12/2022 10:45:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 23/12/2022 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77490' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.459' , '22' , '0' , '75.00' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3654' , '4' , '0' , '10.50' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8689' , '22' , '0' , '3.50' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8689' , '22' , '0' , '7.00' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '20440' , 'AMEN - FEB. 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '20441' , 'AMEN - GEN. 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 23/12/2022 10:45: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 ( '77490' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 23/12/2022 10:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 23/12/2022 10:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 23/12/2022 10:46:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:46: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 ( '11' , '4050' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 23/12/2022 10:46: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 = '77491' 23/12/2022 10:46:37 am >> DELETE FROM ps_document_detail WHERE id_document = '77491' 23/12/2022 10:46: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 ( '77491' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 23/12/2022 10:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77491' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 23/12/2022 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 10:52:43 am >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '68029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-21') 23/12/2022 10:52:43 am >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2022-10-21', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'CATECHESI', 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 = '519.96', price_tax_excluded = '515.18', date_upd = NOW() WHERE id_document = '68029' 23/12/2022 10:52:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68029' 23/12/2022 10:52:43 am >> DELETE FROM ps_document_detail WHERE id_document = '68029' 23/12/2022 10:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '14.50' ) 23/12/2022 10:52:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 23/12/2022 10:52:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 23/12/2022 10:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '12.00' ) 23/12/2022 10:52:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 23/12/2022 10:52:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 23/12/2022 10:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 23/12/2022 10:52:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 23/12/2022 10:52:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 23/12/2022 10:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 23/12/2022 10:52:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 23/12/2022 10:52:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 23/12/2022 10:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '40' , '-40' , '4' , '1.6000' , '1.6' , '0' , '15' , '54.40' ) 23/12/2022 10:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 23/12/2022 10:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 23/12/2022 10:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 23/12/2022 10:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 23/12/2022 10:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 23/12/2022 10:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 23/12/2022 10:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 23/12/2022 10:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 23/12/2022 10:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 23/12/2022 10:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 23/12/2022 10:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 23/12/2022 10:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '32' , '-32' , '4' , '3.5000' , '3.5' , '0' , '15' , '95.20' ) 23/12/2022 10:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 23/12/2022 10:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 23/12/2022 10:54:20 am >> SELECT document_num FROM ps_document WHERE document_num = '337' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:54:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '337' , '2022-12-23' , '' , '371' , '' , '4670910' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '493.46' , '493.46' , NOW() , NOW() ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77492' 23/12/2022 10:54:20 am >> DELETE FROM ps_document_detail WHERE id_document = '77492' 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '40' , '-40' , '4' , '1.6000' , '1.6' , '0' , '15' , '54.40' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 23/12/2022 10:54:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77492' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '32' , '-32' , '4' , '3.5000' , '3.5' , '0' , '15' , '95.20' ) 23/12/2022 10:54:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 23/12/2022 10:54:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 23/12/2022 10:55:16 am >> SELECT document_num FROM ps_document WHERE document_num = '4051' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:55:16 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' , '4051' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.40' , '22.46' , NOW() , NOW() ) 23/12/2022 10:55:16 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 = '77493' 23/12/2022 10:55:16 am >> DELETE FROM ps_document_detail WHERE id_document = '77493' 23/12/2022 10:55:16 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 ( '77493' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '17.40' ) 23/12/2022 10:55:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 23/12/2022 10:55:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 23/12/2022 10:55:16 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 ( '77493' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '10.00' ) 23/12/2022 10:55:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 23/12/2022 10:55:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 23/12/2022 10:55:57 am >> SELECT document_num FROM ps_document WHERE document_num = '337' AND id_document != '77492' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 10:55:57 am >> UPDATE ps_document SET id_document_type = '21', document_num = '337', document_date = '2022-12-23', document_letter = '', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '493.46', price_tax_excluded = '493.46', date_upd = NOW() WHERE id_document = '77492' 23/12/2022 10:55:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77492' 23/12/2022 10:55:58 am >> DELETE FROM ps_document_detail WHERE id_document = '77492' 23/12/2022 10:55: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 ( '77492' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 23/12/2022 10:55: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 ( '77492' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 23/12/2022 10:55: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 ( '77492' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '40' , '-40' , '4' , '1.6000' , '1.6' , '0' , '15' , '54.40' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 23/12/2022 10:55: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 ( '77492' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 23/12/2022 10:55: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 ( '77492' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 23/12/2022 10:55: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 ( '77492' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 23/12/2022 10:55: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 ( '77492' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '32' , '-32' , '4' , '3.5000' , '3.5' , '0' , '15' , '95.20' ) 23/12/2022 10:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 23/12/2022 10:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 23/12/2022 10:57:42 am >> DELETE FROM ps_document WHERE id_document = '68029' 23/12/2022 10:57:42 am >> DELETE FROM ps_document_detail WHERE id_document = '68029' 23/12/2022 10:58:26 am >> SELECT document_num FROM ps_document WHERE document_num = '35/A' AND id_document != '28276' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-04-23') 23/12/2022 10:58:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '35/A', document_date = '2021-04-23', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO CASULA € 950,00 + 100,00 23/12 +', 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 = '1400.00', price_tax_excluded = '1147.54', date_upd = NOW() WHERE id_document = '28276' 23/12/2022 10:58:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '28276' 23/12/2022 10:58:26 am >> DELETE FROM ps_document_detail WHERE id_document = '28276' 23/12/2022 10:58:27 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 ( '28276' , '14716' , 'CASULA - COT/VISCOSA CON TESSUTI A TELAIO******' , '1' , '-1' , '1' , '1400.0000' , '1147.5409836066' , '22' , '0' , '1400.00' ) 23/12/2022 10:58:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '14716' AND id_supplier = '' 23/12/2022 10:58:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14716' , '' , '1' ) 23/12/2022 11:07:25 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/12/2022 11:07:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20587' , '1' , '' , 'nuovo-prodotto' ) 23/12/2022 11:07:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20587' , '1' , '1' , '2' , NOW() , NOW() ) 23/12/2022 11:07:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20587' , '0' , '1' , '0' , '0' ) 23/12/2022 11:08:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299087' AND id_product != '20587' AND ean13 != '' 23/12/2022 11:08:41 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788869299087', date_upd = NOW() WHERE id_product = '20587' 23/12/2022 11:08:41 am >> UPDATE ps_product_lang SET name = 'CATECHESI CREATIVA - A. QUEIROLO', description = '' WHERE id_product = '20587' 23/12/2022 11:08:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20587' 23/12/2022 11:08:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20587' 23/12/2022 11:08:41 am >> DELETE FROM ps_specific_price WHERE id_product = '20587' 23/12/2022 11:09:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '352841' , '2022-12-20' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.40' , '92.40' , NOW() , NOW() ) 23/12/2022 11:09:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77494' 23/12/2022 11:09:23 am >> DELETE FROM ps_document_detail WHERE id_document = '77494' 23/12/2022 11:09:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77494' , '13841' , 'PADRE MIO MI ABBANDONO A TE - C. CARRETTO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 23/12/2022 11:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '13841' AND id_supplier = '109' 23/12/2022 11:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13841' , '109' , '1' ) 23/12/2022 11:09:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77494' , '20298' , 'COFANETTO STORIE PER BAMBINI VOL 1 E 2' , '1' , '1' , '4' , '29.90' , '29.9' , '0' , '0' , '29.90' ) 23/12/2022 11:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20298' AND id_supplier = '109' 23/12/2022 11:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20298' , '109' , '1' ) 23/12/2022 11:09:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77494' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 23/12/2022 11:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 23/12/2022 11:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 23/12/2022 11:09:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77494' , '20355' , 'TEOLOGIA DELLE RELIGIONI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 23/12/2022 11:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20355' AND id_supplier = '109' 23/12/2022 11:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20355' , '109' , '1' ) 23/12/2022 11:09:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77494' , '3988' , 'EVANGELII GAUDIUM ' , '3' , '3' , '4' , '3.50' , '3.5' , '0' , '0' , '10.5000' ) 23/12/2022 11:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '3988' AND id_supplier = '109' 23/12/2022 11:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3988' , '109' , '1' ) 23/12/2022 11:12:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3957' AND id_document != '77382' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-19') 23/12/2022 11:12:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3957', document_date = '2022-12-19', 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 = '124.00', price_tax_excluded = '101.64', date_upd = NOW() WHERE id_document = '77382' 23/12/2022 11:12:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77382' 23/12/2022 11:12:23 am >> DELETE FROM ps_document_detail WHERE id_document = '77382' 23/12/2022 11:12:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77382' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 23/12/2022 11:12:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18128' AND id_supplier = '' 23/12/2022 11:12:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18128' , '' , '1' ) 23/12/2022 11:12:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77382' , '20174' , 'ANGELI MUSICANTI - AR81' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 23/12/2022 11:12:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20174' AND id_supplier = '' 23/12/2022 11:12:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20174' , '' , '1' ) 23/12/2022 11:12:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77382' , '15656' , 'CLERGY BLU - 100% - 44 - 160/10' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 23/12/2022 11:12:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '15656' AND id_supplier = '' 23/12/2022 11:12:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15656' , '' , '1' ) 23/12/2022 11:12:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77382' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' ) 23/12/2022 11:12:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16535' AND id_supplier = '' 23/12/2022 11:12:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16535' , '' , '1' ) 23/12/2022 11:30:44 am >> SELECT document_num FROM ps_document WHERE document_num = '4052' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 11:30:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4052' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '245.90' , '225.74' , NOW() , NOW() ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77495' 23/12/2022 11:30:44 am >> DELETE FROM ps_document_detail WHERE id_document = '77495' 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '11151' , 'LIBRI' , '30' , '-30' , '4' , '1.3' , '1.3' , '0' , '0' , '39.00' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20578' AND id_supplier = '' 23/12/2022 11:30:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20578' , '' , '1' ) 23/12/2022 11:30:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 23/12/2022 11:30:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20534' AND id_supplier = '' 23/12/2022 11:30:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20534' , '' , '1' ) 23/12/2022 11:30:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 23/12/2022 11:30:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 23/12/2022 11:30:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 23/12/2022 11:59:32 am >> SELECT document_num FROM ps_document WHERE document_num = '4053' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 11:59:32 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' , '4053' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 23/12/2022 11:59:32 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 = '77496' 23/12/2022 11:59:32 am >> DELETE FROM ps_document_detail WHERE id_document = '77496' 23/12/2022 11:59:32 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 ( '77496' , '14133' , 'NATIVITA DI GESU BAMBINO - 281' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 23/12/2022 11:59:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '14133' AND id_supplier = '' 23/12/2022 11:59:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14133' , '' , '1' ) 23/12/2022 11:59:32 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 ( '77496' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 23/12/2022 11:59:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 23/12/2022 11:59:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 23/12/2022 12:01:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4054' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:01:19 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' , '4054' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.18' , '63.18' , NOW() , NOW() ) 23/12/2022 12:01:19 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 = '77497' 23/12/2022 12:01:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '77497' 23/12/2022 12:01:19 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 ( '77497' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 23/12/2022 12:01:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1134' AND id_supplier = '' 23/12/2022 12:01:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1134' , '' , '1' ) 23/12/2022 12:01:19 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 ( '77497' , '1136' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' , '34.50' , '34.5' , '0' , '5' , '32.78' ) 23/12/2022 12:01:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1136' AND id_supplier = '' 23/12/2022 12:01:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1136' , '' , '1' ) 23/12/2022 12:02:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '4055' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:02: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' , '4055' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.20' , '16.81' , NOW() , NOW() ) 23/12/2022 12:02: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 = '77498' 23/12/2022 12:02:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '77498' 23/12/2022 12:02: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 ( '77498' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 23/12/2022 12:02:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/12/2022 12:02:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/12/2022 12:02: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 ( '77498' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/12/2022 12:02:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/12/2022 12:02:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/12/2022 12:02: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 ( '77498' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 23/12/2022 12:02:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20578' AND id_supplier = '' 23/12/2022 12:02:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20578' , '' , '1' ) 23/12/2022 12:02: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 ( '77498' , '18847' , 'QUADRETTO NATIVITA ORO A CALDO - P662' , '2' , '-2' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '5.40' ) 23/12/2022 12:02:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18847' AND id_supplier = '' 23/12/2022 12:02:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18847' , '' , '1' ) 23/12/2022 12:04:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:04: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 ( '21' , '119/A' , '2022-12-23' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1120.00' , '918.03' , NOW() , NOW() ) 23/12/2022 12:04: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 = '77499' 23/12/2022 12:04:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '77499' 23/12/2022 12:04: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 ( '77499' , '19445' , 'AMPOLLE MARE SU VASSOIO DORATO - 1504' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 23/12/2022 12:04: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 ( '77499' , '19853' , 'CASULA GOTICA L/S LAME\' - 8257' , '1' , '-1' , '1' , '1000' , '819.67213114754' , '22' , '0' , '1000.00' ) 23/12/2022 12:05:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '75582' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-05') 23/12/2022 12:05:49 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2022-12-05', document_letter = 'A', id_customer = '1192', id_supplier = '', id_address = '1192', address1 = 'VIA ROMA 84020 RICIGLIANO', address2 = '', note = 'ACCONTO € 100,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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '75582' 23/12/2022 12:05: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 = '75582' 23/12/2022 12:05:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '75582' 23/12/2022 12:05: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 ( '75582' , '0' , 'CASULA MARIANA' , '1' , '-1' , '0' , '2350.0000' , '2350' , '0' , '0' , '2350.00' ) 23/12/2022 12:05:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 23/12/2022 12:05:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 23/12/2022 12:05: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 ( '75582' , '' , 'BAMBINO CM 30' , '1' , '-1' , '0' , '150' , '150' , '' , '0' , '150.00' ) 23/12/2022 12:05:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 23/12/2022 12:05:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 23/12/2022 12:15:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4056' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:15:12 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' , '4056' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.70' , '5.49' , NOW() , NOW() ) 23/12/2022 12:15: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 = '77500' 23/12/2022 12:15:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '77500' 23/12/2022 12:15: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 ( '77500' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 23/12/2022 12:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20163' AND id_supplier = '' 23/12/2022 12:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20163' , '' , '1' ) 23/12/2022 12:15: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 ( '77500' , '20164' , 'STELLA - 23/SNC' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 23/12/2022 12:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20164' AND id_supplier = '' 23/12/2022 12:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20164' , '' , '1' ) 23/12/2022 12:15: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 ( '77500' , '20521' , 'CASETTA NATIVITA - 23/CAL-NAT04' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/12/2022 12:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '' 23/12/2022 12:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '' , '1' ) 23/12/2022 12:15: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 ( '77500' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 23/12/2022 12:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 23/12/2022 12:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 23/12/2022 12:15: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 ( '77500' , '20164' , 'STELLA - 23/SNC' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 23/12/2022 12:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20164' AND id_supplier = '' 23/12/2022 12:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20164' , '' , '1' ) 23/12/2022 12:16:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4057' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:16:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4057' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 23/12/2022 12:16:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77501' 23/12/2022 12:16:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '77501' 23/12/2022 12:16:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77501' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 23/12/2022 12:16:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10870' AND id_supplier = '' 23/12/2022 12:16:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10870' , '' , '1' ) 23/12/2022 12:23:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 23/12/2022 12:23:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12', 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 = '3395.00', price_tax_excluded = '2782.79', date_upd = NOW() WHERE id_document = '56617' 23/12/2022 12:23:25 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 = '56617' 23/12/2022 12:23:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 23/12/2022 12:23:25 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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 23/12/2022 12:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 23/12/2022 12:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 23/12/2022 12:23:25 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 ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 23/12/2022 12:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 23/12/2022 12:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 23/12/2022 12:23:25 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 ( '56617' , '18984' , 'POLO FELPATO ML + cardigan' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 23/12/2022 12:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 23/12/2022 12:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 23/12/2022 12:23:25 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 ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C' , '1' , '-1' , '1' , '780' , '639.34426229508' , '22' , '0' , '780.00' ) 23/12/2022 12:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19802' AND id_supplier = '' 23/12/2022 12:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19802' , '' , '1' ) 23/12/2022 12:25:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '111/A' AND id_document != '76151' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-07') 23/12/2022 12:25:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '111/A', document_date = '2022-12-07', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1216.00', price_tax_excluded = '996.72', date_upd = NOW() WHERE id_document = '76151' 23/12/2022 12:25:42 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 = '76151' 23/12/2022 12:25:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '76151' 23/12/2022 12:25:42 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 ( '76151' , '14016' , 'BALZA SU TESSUTO AZZURRO' , '2' , '-2' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '96.00' ) 23/12/2022 12:25:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14016' AND id_supplier = '' 23/12/2022 12:25:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14016' , '' , '1' ) 23/12/2022 12:25:42 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 ( '76151' , '19445' , 'AMPOLLE MARE SU VASSOIO DORATO - 1504' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 23/12/2022 12:25:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19445' AND id_supplier = '' 23/12/2022 12:25:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19445' , '' , '1' ) 23/12/2022 12:25:42 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 ( '76151' , '19853' , 'CASULA GOTICA L/S LAME\' - 8257' , '1' , '-1' , '1' , '1000' , '819.67213114754' , '22' , '0' , '1000.00' ) 23/12/2022 12:25:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19853' AND id_supplier = '' 23/12/2022 12:25:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19853' , '' , '1' ) 23/12/2022 12:25:52 pm >> DELETE FROM ps_document WHERE id_document = '77499' 23/12/2022 12:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '77499' 23/12/2022 12:32:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4058' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:32:50 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' , '4058' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 23/12/2022 12:32:50 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 = '77502' 23/12/2022 12:32:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '77502' 23/12/2022 12:32:50 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 ( '77502' , '16125' , 'MARIA CHE SCIOGLIE I NODI BABY - MSN9-BB' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/12/2022 12:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16125' AND id_supplier = '' 23/12/2022 12:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16125' , '' , '1' ) 23/12/2022 12:50:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:50:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '119/A' , '2022-12-23' , 'A' , '3843' , '0' , '4673209' , 'RIONE PIOMBINO 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '879.00' , '720.49' , NOW() , NOW() ) 23/12/2022 12:50: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 = '77503' 23/12/2022 12:50:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '77503' 23/12/2022 12:50: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 ( '77503' , '19607' , 'CLERGY F/F COTONE ML ' , '2' , '-2' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '79.00' ) 23/12/2022 12:50: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 ( '77503' , '15679' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 23/12/2022 12:53:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4059' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:53: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' , '4059' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.40' , '23.70' , NOW() , NOW() ) 23/12/2022 12:53: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 = '77504' 23/12/2022 12:53:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '77504' 23/12/2022 12:53: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 ( '77504' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '3' , '-3' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '3.90' ) 23/12/2022 12:53:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 23/12/2022 12:53:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 23/12/2022 12:53: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 ( '77504' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 23/12/2022 12:53:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 23/12/2022 12:53:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 23/12/2022 12:53: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 ( '77504' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 23/12/2022 12:53:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11882' AND id_supplier = '' 23/12/2022 12:53:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11882' , '' , '1' ) 23/12/2022 12:58:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4060' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:58: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' , '4060' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.57' , '13.57' , NOW() , NOW() ) 23/12/2022 12:58: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 = '77505' 23/12/2022 12:58:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77505' 23/12/2022 12:58: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 ( '77505' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 23/12/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 23/12/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 23/12/2022 12:58: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 ( '77505' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/12/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 23/12/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 23/12/2022 12:58: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 ( '77505' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 23/12/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 23/12/2022 12:58: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 ( '77505' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 23/12/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 23/12/2022 12:59:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 12:59: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' , '4061' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.80' , '43.78' , NOW() , NOW() ) 23/12/2022 12:59: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 = '77506' 23/12/2022 12:59:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77506' 23/12/2022 12:59: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 ( '77506' , '16588' , 'CLERGY DIAGONALE MISTO ML - C06' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 23/12/2022 12:59:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16588' AND id_supplier = '' 23/12/2022 12:59:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16588' , '' , '1' ) 23/12/2022 12:59: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 ( '77506' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 23/12/2022 12:59:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/12/2022 12:59:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/12/2022 12:59: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 ( '77506' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 23/12/2022 12:59:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 23/12/2022 12:59:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 23/12/2022 01:08:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '4062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 01:08:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4062' , '2022-12-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 23/12/2022 01:08:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77507' 23/12/2022 01:08:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '77507' 23/12/2022 01:08:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77507' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '16.50' ) 23/12/2022 01:08:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/12/2022 01:08:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/12/2022 02:55:43 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') 23/12/2022 02:55:43 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', 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' 23/12/2022 02:55: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 = '75504' 23/12/2022 02:55:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '75504' 23/12/2022 02:55: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 ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 23/12/2022 02:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7306' AND id_supplier = '' 23/12/2022 02:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7306' , '' , '1' ) 23/12/2022 02:55: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 ( '75504' , '' , 'ACCONTO 200€' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 23/12/2022 02:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 23/12/2022 02:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 23/12/2022 03:20:10 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9970' 23/12/2022 03:20:10 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '9970' 23/12/2022 03:20:19 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11426' 23/12/2022 03:20:19 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '11426' 23/12/2022 03:32:10 pm >> DELETE FROM ps_document WHERE id_document = '61794' 23/12/2022 03:32:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 23/12/2022 03:33:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4052' AND id_document != '77495' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 03:33:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4052', document_date = '2022-12-23', 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 = '245.90', price_tax_excluded = '225.74', date_upd = NOW() WHERE id_document = '77495' 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77495' 23/12/2022 03:33:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '77495' 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '40.00' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '20' , '-20' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '70.00' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '20462' , 'ASCOLTARLO ERA RIMANERE ACCESI - E. RONCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 23/12/2022 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77495' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '1' , '-1' , '4' , '20' , '20' , '0' , '' , '20.00' ) 23/12/2022 03:34:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4020' AND id_document != '77457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-21') 23/12/2022 03:34:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4020', document_date = '2022-12-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 = '39.00', price_tax_excluded = '34.67', date_upd = NOW() WHERE id_document = '77457' 23/12/2022 03:34: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 = '77457' 23/12/2022 03:34:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '77457' 23/12/2022 03:34: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 ( '77457' , '17568' , 'BAMBINO IN RESINA FASCIA ORO - PB13629' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 23/12/2022 03:34: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 ( '77457' , '14621' , 'SANTA RITA BABY - 023 SR/9 BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/12/2022 03:34: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 ( '77457' , '20492' , 'AMORE IN UNO SGUARDO' , '1' , '-1' , '4' , '15' , '15' , '0' , '' , '15.00' ) 23/12/2022 03:37:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3365' AND id_document != '70918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-07') 23/12/2022 03:37:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3365', document_date = '2022-11-07', 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 = '130.00', price_tax_excluded = '120.08', date_upd = NOW() WHERE id_document = '70918' 23/12/2022 03:37: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 = '70918' 23/12/2022 03:37:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '70918' 23/12/2022 03:37: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 ( '70918' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 23/12/2022 03:37: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 ( '70918' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 23/12/2022 03:37: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 ( '70918' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.2' , '4.2' , '0' , '0' , '4.20' ) 23/12/2022 03:37: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 ( '70918' , '20492' , 'AMORE IN UNO SGUARDO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 23/12/2022 03:37: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 ( '70918' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 03:37: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 ( '70918' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 03:37: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 ( '70918' , '20443' , 'PAROLA E PREGHIERA - GEN. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/12/2022 03:37: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 ( '70918' , '20024' , 'PER LETERNITA - R. SARAH' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 23/12/2022 03:37: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 ( '70918' , '20527' , 'AMEN - APR 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 03:37: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 ( '70918' , '20528' , 'AMEN - MAR 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 04:14:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '4063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 04:14:44 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' , '4063' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.40' , '44.40' , NOW() , NOW() ) 23/12/2022 04:14:44 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 = '77508' 23/12/2022 04:14:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '77508' 23/12/2022 04:14:44 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 ( '77508' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '33' , '33' , '0' , '0' , '33.00' ) 23/12/2022 04:14:44 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 ( '77508' , '12438' , 'MARIETTA E IL SUO CIELO - G. ALBERTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/12/2022 04:18:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '4064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 04:18:54 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' , '4064' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 23/12/2022 04:18:54 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 = '77509' 23/12/2022 04:18:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '77509' 23/12/2022 04:18:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77509' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/12/2022 04:43:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '4065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 04:43: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' , '4065' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '31.28' , NOW() , NOW() ) 23/12/2022 04:43: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 = '77510' 23/12/2022 04:43:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '77510' 23/12/2022 04:43: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 ( '77510' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '28' , '28' , '0' , '0' , '28.00' ) 23/12/2022 04:43: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 ( '77510' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 23/12/2022 04:47:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '78/A' AND id_document != '67994' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 23/12/2022 04:47:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '78/A', document_date = '2022-10-20', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '250.00', price_tax_excluded = '231.97', date_upd = NOW() WHERE id_document = '67994' 23/12/2022 04:47: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 = '67994' 23/12/2022 04:47:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '67994' 23/12/2022 04:47: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 ( '67994' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '5' , '-5' , '4' , '14.8000' , '14.8' , '0' , '5' , '70.30' ) 23/12/2022 04:47: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 ( '67994' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/12/2022 04:47: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 ( '67994' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/12/2022 04:47: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 ( '67994' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '-1' , '4' , '15.10' , '15.1' , '0' , '0' , '15.10' ) 23/12/2022 04:47: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 ( '67994' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 23/12/2022 04:47: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 ( '67994' , '20159' , 'NATIVITA STELLA CON BASE - 22/194-10NAT04' , '50' , '-50' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '100.00' ) 23/12/2022 04:49:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 04:49:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4066' , '2022-12-23' , '' , '0' , '0' , '0' , 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '231.97' , NOW() , NOW() ) 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77511' 23/12/2022 04:49:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77511' 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77511' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '5' , '-5' , '4' , '14.8000' , '14.8' , '0' , '5' , '70.30' ) 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77511' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77511' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77511' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '-1' , '4' , '15.1000' , '15.1' , '0' , '0' , '15.10' ) 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77511' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 23/12/2022 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77511' , '20159' , 'NATIVITA STELLA CON BASE - 22/194-10NAT04' , '50' , '-50' , '1' , '2.0000' , '1.6393' , '22' , '0' , '100.00' ) 23/12/2022 04:49:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4066' AND id_document != '77511' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 04:49:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4066', document_date = '2022-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '2', id_causal = '0', price_tax_included = '250.00', price_tax_excluded = '231.97', date_upd = NOW() WHERE id_document = '77511' 23/12/2022 04:49: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 = '77511' 23/12/2022 04:49:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '77511' 23/12/2022 04:49: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 ( '77511' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '5' , '-5' , '4' , '14.8000' , '14.8' , '0' , '5' , '70.30' ) 23/12/2022 04:49: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 ( '77511' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/12/2022 04:49: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 ( '77511' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/12/2022 04:49: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 ( '77511' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '-1' , '4' , '15.1000' , '15.1' , '0' , '0' , '15.10' ) 23/12/2022 04:49: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 ( '77511' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 23/12/2022 04:49: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 ( '77511' , '20159' , 'NATIVITA STELLA CON BASE - 22/194-10NAT04' , '50' , '-50' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '100.00' ) 23/12/2022 05:31:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '4067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 05:31:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4067' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 23/12/2022 05:31:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77512' 23/12/2022 05:31:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '77512' 23/12/2022 05:31: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 ( '77512' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 23/12/2022 05:31: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 ( '77512' , '18068' , 'SACCO PORTA ELEMOSINA - 1751' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 23/12/2022 05:46:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '4068' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 05:46:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4068' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.20' , '34.20' , NOW() , NOW() ) 23/12/2022 05:46:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77513' 23/12/2022 05:46:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '77513' 23/12/2022 05:46:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77513' , '20212' , 'PACE SIA CON TE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 23/12/2022 05:46:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77513' , '19980' , 'ESSERE FAMIGLIA ' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 23/12/2022 06:01:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 06:01: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' , '4069' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 23/12/2022 06:01: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 = '77514' 23/12/2022 06:01:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '77514' 23/12/2022 06:01: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 ( '77514' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/12/2022 06:02: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 ( '33' , '618409' , '2022-12-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1039.35' , '1039.35' , NOW() , NOW() ) 23/12/2022 06:02: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 = '77515' 23/12/2022 06:02:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '77515' 23/12/2022 06:02: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 ( '77515' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+18' , '159.9000' ) 23/12/2022 06:02:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 23/12/2022 06:02:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+18' , '159.9000' ) 23/12/2022 06:02:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+18' , '159.9000' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+18' , '159.9000' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+18' , '159.9000' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+18' , '159.9000' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+18' , '15.9900' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+18' , '15.9900' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+18' , '15.9900' ) 23/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '7' 23/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+18' , '15.9900' ) 23/12/2022 06:02:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '7' 23/12/2022 06:02:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '7' , '1' ) 23/12/2022 06:02: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 ( '77515' , '6620' , 'MIA IMPRONTA È TUA - GUIDA 1' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+18' , '15.9900' ) 23/12/2022 06:02:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '7' 23/12/2022 06:02:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '7' , '1' ) 23/12/2022 06:09:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '4070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 06:09:46 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' , '4070' , '2022-12-23' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.80' , '115.24' , NOW() , NOW() ) 23/12/2022 06:09:46 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 = '77516' 23/12/2022 06:09:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '77516' 23/12/2022 06:09:46 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 ( '77516' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.7869' , '22' , '10' , '36.00' ) 23/12/2022 06:09:46 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 ( '77516' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.4098' , '22' , '0' , '5.00' ) 23/12/2022 06:09:46 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 ( '77516' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.8000' , '2.2951' , '22' , '0' , '8.40' ) 23/12/2022 06:09:46 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 ( '77516' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475' , '22' , '0' , '4.20' ) 23/12/2022 06:09:46 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 ( '77516' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475' , '22' , '0' , '7.50' ) 23/12/2022 06:09:46 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 ( '77516' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8462' , '4' , '0' , '4.00' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.7000' , '0.5738' , '22' , '0' , '10.50' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '6019' , 'LUMINO ROSSO - 10B' , '1' , '-1' , '1' , '0.4000' , '0.3279' , '22' , '0' , '0.40' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269' , '4' , '0' , '3.80' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8462' , '4' , '0' , '4.00' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '16449' , 'CONFEZIONE CARTONCINO CON BAMBINO - P576' , '30' , '-30' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '18.00' ) 23/12/2022 06:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77516' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 23/12/2022 06:12:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '61878' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 23/12/2022 06:12:33 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2022-09-20', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '135.80', price_tax_excluded = '115.24', date_upd = NOW() WHERE id_document = '61878' 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61878' 23/12/2022 06:12:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '61878' 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '8.40' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '10.50' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '6019' , 'LUMINO ROSSO - 10B' , '1' , '-1' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.40' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '0' , 'ritira diacono' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 23/12/2022 06:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '16449' , 'CONFEZIONE CARTONCINO CON BAMBINO - P576' , '30' , '-30' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '18.00' ) 23/12/2022 06:13:50 pm >> DELETE FROM ps_document WHERE id_document = '61878' 23/12/2022 06:13:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '61878' 23/12/2022 06:27:48 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '618409', document_date = '2022-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '78.56', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2195.34', price_tax_excluded = '2195.34', date_upd = NOW() WHERE id_document = '77515' 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77515' 23/12/2022 06:27:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '77515' 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '6620' , 'MIA IMPRONTA È TUA - GUIDA 1' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '50' , '50' , '4' , '5.00' , '5' , '0' , '35+18' , '133.2500' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '50' , '50' , '4' , '5.00' , '5' , '0' , '35+18' , '133.2500' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '14529' , 'PANE E VINO - SUSSIDIO' , '40' , '40' , '4' , '5.00' , '5' , '0' , '35+18' , '106.6000' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '40' , '40' , '4' , '5.00' , '5' , '0' , '35+18' , '106.6000' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '25' , '4' , '5.00' , '5' , '0' , '35+18' , '66.6250' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '25' , '25' , '4' , '5.00' , '5' , '0' , '35+18' , '66.6250' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '20261' , 'GIOIA - PAPA FRANCESCO' , '2' , '2' , '4' , '14.00' , '14' , '0' , '35+18' , '14.9240' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33+18' , '5.4940' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33+18' , '8.7904' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30+18' , '5.7400' ) 23/12/2022 06:27:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '10751' , 'TU MI PERDONI' , '20' , '20' , '4' , '5.90' , '5.9' , '0' , '30+18' , '67.7320' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '14719' , 'TU MI AMI DAVVERO' , '20' , '20' , '4' , '5.90' , '5.9' , '0' , '30+18' , '67.7320' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '1116' , 'BIBBIA DEI BAMBINI' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '30+18' , '14.8092' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '19953' , 'FELIZ CITTA - GIOCO CARLO ACUTIS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30+18' , '8.6100' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '1' , '4' , '39.00' , '39' , '0' , '33+18' , '21.4266' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33+18' , '8.7904' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '18298' , 'SAN GIUSEPPE - F. ROSINI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33+18' , '7.6916' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30+18' , '9.1840' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '7647' , 'PAROLE DI GESÙ MISERICORDIOSO - SUOR FAUSTINA' , '1' , '1' , '4' , '7.00' , '7' , '0' , '30+18' , '4.0180' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33+18' , '8.2410' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '16686' , 'EVANGELIARIO' , '1' , '1' , '4' , '140.00' , '140' , '0' , '30+18' , '80.3600' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '19291' , 'VANGELO DELLA PRIMA COMUNIONE' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+18' , '6.3960' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '4168' , 'FIGLI DEL VENTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35+18' , '2.6650' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30+18' , '2.8126' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30+18' , '2.8126' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30+18' , '2.8126' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '19294' , 'SCOPRIAMO INSIEME IL VANGELO' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30+18' , '2.8126' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '17767' , 'SCOPRIAMO INSIEME LA QUARESIMA E PASQUA' , '3' , '3' , '4' , '4.90' , '4.9' , '0' , '30+18' , '8.4378' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '3666' , 'DONI DELLO SPIRITO SANTO SPIEGATI AI RAGAZZI - V. BOCCI' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '35+18' , '5.2234' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '5' , '5' , '4' , '4.90' , '4.9' , '0' , '35+18' , '13.0585' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '5592' , 'LECTIO DIVINA OGNI GIORNO - 2' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '30+18' , '7.7490' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33+18' , '10.9880' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '2' , '2' , '4' , '3.00' , '3' , '0' , '33+18' , '3.2964' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '3' , '3' , '4' , '16.00' , '16' , '0' , '33+18' , '26.3712' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '20530' , 'ULTIME PAROLE - TERESA DI GESU BAMBINO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33+18' , '10.9880' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '1410' , 'BUONA NOTIZIA PER TE! - ANNO B - A. COMASTRI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+18' , '7.9950' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '3878' , 'ENTRARE NELLA DOMENICA DALLA PORTA - ANNO A - R. PAGANELLI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+18' , '7.9950' ) 23/12/2022 06:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77515' , '10202' , 'STARE NELLA DOMENICA ALLA MENSA ... - R. PAGANELLI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35+18' , '8.5280' ) 23/12/2022 06:35:39 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' , '2728/2022' , '2022-12-23' , '2022' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '8.55' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '256.90' , '210.58' , NOW() , NOW() ) 23/12/2022 06:35:39 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 = '77517' 23/12/2022 06:35:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '77517' 23/12/2022 06:35:39 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 ( '77517' , '20553' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '0' , '1' , '2.0000' , '1.6393' , '22' , '5+5' , '2.20' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20553' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20553' , '43' , '1' ) 23/12/2022 06:35:39 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 ( '77517' , '20551' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '0' , '1' , '2.0000' , '1.6393' , '22' , '5+5' , '2.20' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20551' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20551' , '43' , '1' ) 23/12/2022 06:35:39 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 ( '77517' , '20550' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '0' , '1' , '2.0000' , '1.6393' , '22' , '5+5' , '2.20' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20550' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20550' , '43' , '1' ) 23/12/2022 06:35:39 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 ( '77517' , '20549' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '0' , '1' , '2.0000' , '1.6393' , '22' , '5+5' , '2.20' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20549' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20549' , '43' , '1' ) 23/12/2022 06:35:39 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 ( '77517' , '20552' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '0' , '1' , '2.0000' , '1.6393' , '22' , '5+5' , '2.20' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20552' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20552' , '43' , '1' ) 23/12/2022 06:35:39 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 ( '77517' , '17605' , 'CATENINA ACCIAIO CON CROCE - AC103C' , '1' , '0' , '1' , '10.4000' , '8.5246' , '22' , '5+5' , '11.45' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17605' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17605' , '43' , '1' ) 23/12/2022 06:35:39 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 ( '77517' , '17606' , 'CATENINA ACCIAIO NERA CON CROCE - AC104C' , '1' , '0' , '1' , '8.4500' , '6.9262' , '22' , '5+5' , '9.30' ) 23/12/2022 06:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17606' AND id_supplier = '43' 23/12/2022 06:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17606' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '18' , '0' , '1' , '1.9700' , '1.6148' , '22' , '5+5' , '39.04' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9184' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9184' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '9183' , 'ROSARIO S. MICHELE - LEGNO RL 753 ' , '18' , '0' , '1' , '1.8200' , '1.4918' , '22' , '5+5' , '36.07' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9183' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9183' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '20554' , 'CROCE ULIVO CORPO BRONZATO CM20 - PG792BR' , '1' , '0' , '1' , '13.5000' , '11.0656' , '22' , '5+5' , '14.86' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20554' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20554' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '6336' , 'MEDAGLIA OVALE DECORATA - S.RITA - G291-D' , '50' , '0' , '1' , '0.3100' , '0.2541' , '22' , '5+5' , '17.07' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6336' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6336' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '50' , '0' , '1' , '0.3100' , '0.2541' , '22' , '5+5' , '17.07' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6337' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6337' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '6335' , 'MEDAGLIA OVALE DECORATA - S.LUCIA - G291-D' , '100' , '0' , '1' , '0.31' , '0.25409836065574' , '22' , '5+5' , '34.1326' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6335' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6335' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '6330' , 'MEDAGLIA OVALE DECORATA - MAD CARMINE - G291-D' , '50' , '0' , '1' , '0.3100' , '0.2541' , '22' , '5+5' , '17.07' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6330' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6330' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '20555' , 'CROCE ULIVO CM 34 - PG038' , '1' , '0' , '1' , '18.3000' , '15' , '22' , '5+5' , '20.15' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20555' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20555' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '20556' , 'CROCE ULIVO CM 22 - PG036' , '1' , '0' , '1' , '11.4700' , '9.4016' , '22' , '5+5' , '12.63' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20556' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20556' , '43' , '1' ) 23/12/2022 06:35: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 ( '77517' , '3042' , 'CROCE METALLO BUON PASTORE CM 10 - G355-G' , '1' , '0' , '1' , '6.0200' , '4.9344' , '22' , '5+5' , '6.63' ) 23/12/2022 06:35:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3042' AND id_supplier = '43' 23/12/2022 06:35:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3042' , '43' , '1' ) 23/12/2022 06:39:42 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' , '22V108193' , '2022-12-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.25' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '77.63' , '77.63' , NOW() , NOW() ) 23/12/2022 06:39:42 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 = '77518' 23/12/2022 06:39:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '77518' 23/12/2022 06:39:42 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 ( '77518' , '3649' , 'DON ERNEST SIMONI - M. MUOLO' , '9' , '0' , '4' , '12.5000' , '12.5' , '0' , '33' , '75.3750' ) 23/12/2022 06:39:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3649' AND id_supplier = '7' 23/12/2022 06:39:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3649' , '7' , '1' ) 23/12/2022 06:46:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2274' AND id_document != '59690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-14') 23/12/2022 06:46:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2274', document_date = '2022-07-14', 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 = '530.00', price_tax_excluded = '434.43', date_upd = NOW() WHERE id_document = '59690' 23/12/2022 06:46:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59690' 23/12/2022 06:46:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '59690' 23/12/2022 06:46:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59690' , '15679' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '530' , '434.4262295082' , '22' , '0' , '530.00' ) 23/12/2022 06:47:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '75459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 23/12/2022 06:47:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3667', document_date = '2022-11-29', 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 = '175.00', price_tax_excluded = '143.44', date_upd = NOW() WHERE id_document = '75459' 23/12/2022 06:47:22 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 = '75459' 23/12/2022 06:47:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '75459' 23/12/2022 06:47:22 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 ( '75459' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3' , '2.4590163934426' , '22' , '0' , '15.00' ) 23/12/2022 06:47:22 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 ( '75459' , '17407' , 'STOLA MARIANA - 80/002005' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 23/12/2022 06:47:22 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 ( '75459' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 23/12/2022 06:49:21 pm >> DELETE FROM ps_document WHERE id_document = '76115' 23/12/2022 06:49:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '76115' 23/12/2022 06:56:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4071' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 06:56:38 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' , '4071' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.75' , '3.07' , NOW() , NOW() ) 23/12/2022 06:56:38 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 = '77519' 23/12/2022 06:56:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '77519' 23/12/2022 06:56:38 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 ( '77519' , '4374' , 'GESÙ BAMBINO - 273' , '10' , '-10' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '1.50' ) 23/12/2022 06:56:38 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 ( '77519' , '1254' , 'BONTÀ - SEGNALIBRO 126' , '15' , '-15' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '2.25' ) 23/12/2022 07:07:15 pm >> DELETE FROM ps_document WHERE id_document = '67994' 23/12/2022 07:07:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '67994' 23/12/2022 07:30:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '4072' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 07:30: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' , '4072' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.01' , '56.01' , NOW() , NOW() ) 23/12/2022 07:30: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 = '77520' 23/12/2022 07:30:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '77520' 23/12/2022 07:30: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 ( '77520' , '18382' , 'MADRE E IL FIGLIO - G. RAVASI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/12/2022 07:30: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 ( '77520' , '18376' , 'NOSTALGIA DEL PANE - L. EPICOCO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/12/2022 07:30: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 ( '77520' , '18381' , 'DIREZIONE PER CUI SI AVANZA - A. CANOPI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/12/2022 07:30: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 ( '77520' , '18378' , 'RAGIONE E IL CORAGGIO - A. COMASTRI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/12/2022 07:30: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 ( '77520' , '10288' , 'STORIA DI MARIA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '12258' , 'STORIA DI SAN DOMENICO SAVIO' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '12257' , 'STORIA DI SAN GIOVANNI EVANGELISTA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '15280' , 'STORIA DI PADRE KOLBE' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '17434' , 'STORIA DI SAN NICOLA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '15279' , 'SAN TARCISIO' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:30: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 ( '77520' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 23/12/2022 07:30: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 ( '77520' , '17305' , 'FIORI RACCOLTI A PRIMAVERA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/12/2022 07:30: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 ( '77520' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 23/12/2022 07:39:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '4073' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 07:39:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4073' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.24' , '7.24' , NOW() , NOW() ) 23/12/2022 07:39: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 = '77521' 23/12/2022 07:39:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '77521' 23/12/2022 07:39: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 ( '77521' , '12257' , 'STORIA DI SAN GIOVANNI EVANGELISTA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:39: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 ( '77521' , '15280' , 'STORIA DI PADRE KOLBE' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:39: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 ( '77521' , '17792' , 'STORIA DI SAN GIUSEPPE' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:39: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 ( '77521' , '15279' , 'SAN TARCISIO' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/12/2022 07:46:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '4074' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 07:46:22 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' , '4074' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 23/12/2022 07:46:22 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 = '77522' 23/12/2022 07:46:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '77522' 23/12/2022 07:46:22 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 ( '77522' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '3' , '-3' , '1' , '4.40' , '3.6065573770492' , '22' , '0' , '13.20' ) 23/12/2022 07:47:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '4075' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 07:47:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4075' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.40' , '19.62' , NOW() , NOW() ) 23/12/2022 07:47:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77523' 23/12/2022 07:47:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '77523' 23/12/2022 07:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77523' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 23/12/2022 07:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77523' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 23/12/2022 07:47: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 ( '77523' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 23/12/2022 07:52:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '4076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 23/12/2022 07:52:11 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' , '4076' , '2022-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.95' , '38.95' , NOW() , NOW() ) 23/12/2022 07:52:11 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 = '77524' 23/12/2022 07:52:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '77524' 23/12/2022 07:52: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 ( '77524' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 23/12/2022 07:52: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 ( '77524' , '20261' , 'GIOIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 23/12/2022 07:52: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 ( '77524' , '20202' , 'GIUDA LA VERA STORIA - S. PANZARELLA' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' )