01/04/2023 08:43:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859002719' AND id_product != '4962' AND ean13 != '' 01/04/2023 08:43:42 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '8018859002719', date_upd = NOW() WHERE id_product = '4962' 01/04/2023 08:43:42 am >> UPDATE ps_product_lang SET name = 'IMMAGINE ECCE HOMO ', description = '' WHERE id_product = '4962' 01/04/2023 08:43:42 am >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '2.8689' WHERE id_product = '4962' 01/04/2023 08:43:42 am >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '2.8689', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '91', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4962' 01/04/2023 08:43:42 am >> DELETE FROM ps_specific_price WHERE id_product = '4962' 01/04/2023 09:20:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:20:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1076' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 01/04/2023 09:20:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82583' 01/04/2023 09:20:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82583' 01/04/2023 09:20:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82583' , '18239' , 'SERVIZIO MESSA - MARIANO M/l - 7051' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 01/04/2023 09:20:36 am >> DELETE FROM ps_document WHERE id_document = '82583' 01/04/2023 09:20:36 am >> DELETE FROM ps_document_detail WHERE id_document = '82583' 01/04/2023 09:21:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:21:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1076' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 01/04/2023 09:21:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82584' 01/04/2023 09:21:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82584' 01/04/2023 09:21:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82584' , '18239' , 'SERVIZIO MESSA - MARIANO M/l - 7051' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 01/04/2023 09:21:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1077' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:21:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1077' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 01/04/2023 09:21:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82585' 01/04/2023 09:21:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82585' 01/04/2023 09:21:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82585' , '18239' , 'SERVIZIO MESSA - MARIANO M/l - 7051' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 01/04/2023 09:32:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1078' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:32:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1078' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 01/04/2023 09:32:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82586' 01/04/2023 09:32:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82586' 01/04/2023 09:32:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82586' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 01/04/2023 09:34:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1079' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:34:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1079' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 01/04/2023 09:34:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82587' 01/04/2023 09:34:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82587' 01/04/2023 09:34:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82587' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 01/04/2023 09:35:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1080' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:35:45 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' , '1080' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 01/04/2023 09:35:45 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 = '82588' 01/04/2023 09:35:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82588' 01/04/2023 09:35: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 ( '82588' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 01/04/2023 09:35: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 ( '82588' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/04/2023 09:35:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1081' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:35:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1081' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 01/04/2023 09:35:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82589' 01/04/2023 09:35:55 am >> DELETE FROM ps_document_detail WHERE id_document = '82589' 01/04/2023 09:35:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82589' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 01/04/2023 09:45:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1082' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:45:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1082' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '43.66' , NOW() , NOW() ) 01/04/2023 09:45:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82590' 01/04/2023 09:45:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82590' 01/04/2023 09:45:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82590' , '17904' , 'CELEBRIAMO LA PASQUA - N.E.' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 01/04/2023 09:45:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82590' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '21.16' , '17.344262295082' , '22' , '0' , '21.16' ) 01/04/2023 09:45:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82590' , '8928' , 'RESURREZIONE - 353 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 01/04/2023 09:45:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82590' , '8928' , 'RESURREZIONE - 353 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 01/04/2023 09:45:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82590' , '14135' , 'RESURREZIONE - 369' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 01/04/2023 09:48:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1078' AND id_document != '82586' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:48:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1078', document_date = '2023-04-01', 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 = '7.00', price_tax_excluded = '7.00', date_upd = NOW() WHERE id_document = '82586' 01/04/2023 09:48:34 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 = '82586' 01/04/2023 09:48:34 am >> DELETE FROM ps_document_detail WHERE id_document = '82586' 01/04/2023 09:48:34 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 ( '82586' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 01/04/2023 09:48:34 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 ( '82586' , '20765' , 'AMEN - MAG 23' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 01/04/2023 09:53:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1083' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 09:53:57 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' , '1083' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 01/04/2023 09:53: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 = '82591' 01/04/2023 09:53:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82591' 01/04/2023 09:53:57 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 ( '82591' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 01/04/2023 10:00:12 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '74912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 01/04/2023 10:00:12 am >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'parrocchia', 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 = '800.40', price_tax_excluded = '670.92', date_upd = NOW() WHERE id_document = '74912' 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74912' 01/04/2023 10:00:12 am >> DELETE FROM ps_document_detail WHERE id_document = '74912' 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '0' , 'candele' , '1' , '-1' , '0' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '0' , 'CUSCINO' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0400' , '0.04' , '0' , '0' , '38.40' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '30' , '-30' , '4' , '1.0000' , '1' , '0' , '15' , '25.50' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '13712' , 'SERIE VIA CRUCIS - 22X30 ' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '20177' , 'ANGELO SU CUORE CM 6,5 - AR112' , '4' , '-4' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '12.00' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '270.00' , '221.31147540984' , '22' , '0' , '270.00' ) 01/04/2023 10:00:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74912' , '15734' , 'CASULA COLOMBA - POL. LANA - 7/F' , '1' , '-1' , '1' , '350.00' , '286.88524590164' , '22' , '0' , '350.00' ) 01/04/2023 10:12:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1084' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 10:12:10 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' , '1084' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 01/04/2023 10:12:10 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 = '82592' 01/04/2023 10:12:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82592' 01/04/2023 10:12:10 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 ( '82592' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '15' , '-15' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '45.00' ) 01/04/2023 10:23:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1085' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 10:23:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1085' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 01/04/2023 10:23:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82593' 01/04/2023 10:23:55 am >> DELETE FROM ps_document_detail WHERE id_document = '82593' 01/04/2023 10:23:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82593' , '9948' , 'SFERA DIAMETRO MM 100' , '2' , '-2' , '1' , '6' , '4.9180327868852' , '22' , '0' , '12.00' ) 01/04/2023 10:27:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 10:27:04 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' , '1086' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.48' , '19.48' , NOW() , NOW() ) 01/04/2023 10:27:04 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 = '82594' 01/04/2023 10:27:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82594' 01/04/2023 10:27:04 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 ( '82594' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 01/04/2023 10:27:04 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 ( '82594' , '20818' , 'VERITA CHE SALVA - C.L. ROSSETTI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 01/04/2023 10:40:45 am >> SELECT document_num FROM ps_document WHERE document_num = '36/A' AND id_document != '82448' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-24') 01/04/2023 10:40:45 am >> UPDATE ps_document SET id_document_type = '24', document_num = '36/A', document_date = '2023-03-24', 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 = '1377.00', price_tax_excluded = '1133.49', date_upd = NOW() WHERE id_document = '82448' 01/04/2023 10:40:45 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 = '82448' 01/04/2023 10:40:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82448' 01/04/2023 10:40: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 ( '82448' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '72.00' ) 01/04/2023 10:40: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 ( '82448' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '22.00' ) 01/04/2023 10:40: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 ( '82448' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '3' , '10.0000' , '9.6153846153846' , '4' , '0' , '30.00' ) 01/04/2023 10:40: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 ( '82448' , '11376' , 'VIENI SPIRITO SANTO' , '15' , '-15' , '4' , '0.2000' , '0.2' , '0' , '0' , '3.00' ) 01/04/2023 10:40: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 ( '82448' , '20091' , 'CALICE IN OTT. ARGENTATO H 27 - 166A' , '1' , '-1' , '1' , '1250' , '1024.5901639344' , '22' , '0' , '1250.00' ) 01/04/2023 11:00:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 11:00: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' , '1087' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '50.08' , NOW() , NOW() ) 01/04/2023 11:00: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 = '82595' 01/04/2023 11:00:59 am >> DELETE FROM ps_document_detail WHERE id_document = '82595' 01/04/2023 11:00: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 ( '82595' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 01/04/2023 11:00: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 ( '82595' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 01/04/2023 11:00: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 ( '82595' , '475' , 'AMICO GESÙ - FIGURINE' , '6' , '-6' , '4' , '0.50' , '0.5' , '0' , '0' , '3.00' ) 01/04/2023 11:06:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 11:06: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' , '1088' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.80' , '53.69' , NOW() , NOW() ) 01/04/2023 11:06: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 = '82596' 01/04/2023 11:06:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82596' 01/04/2023 11:06: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 ( '82596' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/04/2023 11:06: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 ( '82596' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 01/04/2023 11:06: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 ( '82596' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 01/04/2023 11:06: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 ( '82596' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '40' , '-40' , '4' , '0.65' , '0.65' , '0' , '0' , '26.00' ) 01/04/2023 11:36:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 11:36:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1089' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.10' , '8.78' , NOW() , NOW() ) 01/04/2023 11:36:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82597' 01/04/2023 11:36:55 am >> DELETE FROM ps_document_detail WHERE id_document = '82597' 01/04/2023 11:36:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82597' , '19310' , 'SACCHETTO CON CORONCINA E SEGNALIBRO - 1315/K182' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 01/04/2023 11:36:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82597' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 01/04/2023 11:36:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82597' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/04/2023 11:46:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 11:46:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1090' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.56' , NOW() , NOW() ) 01/04/2023 11:46:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82598' 01/04/2023 11:46:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82598' 01/04/2023 11:46:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82598' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 01/04/2023 11:46:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82598' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 01/04/2023 11:46:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82598' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/04/2023 11:57:00 am >> SELECT document_num FROM ps_document WHERE document_num = '5/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 11:57:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '5/L' , '2023-04-01' , 'L' , '178' , '0' , '4670851' , 'VIA S. MARGHERITA, 1 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '114.00' , '114.00' , NOW() , NOW() ) 01/04/2023 11:57:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82599' 01/04/2023 11:57:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82599' 01/04/2023 11:57:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82599' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 01/04/2023 11:57:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82599' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 01/04/2023 12:03:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/L' AND id_document != '82599' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 12:03:05 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '5/L', document_date = '2023-04-01', document_letter = 'L', id_customer = '178', id_supplier = '', id_address = '4670851', address1 = 'VIA S. MARGHERITA, 1 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '128.00', price_tax_excluded = '125.48', date_upd = NOW() WHERE id_document = '82599' 01/04/2023 12:03:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82599' 01/04/2023 12:03:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82599' 01/04/2023 12:03:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82599' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 01/04/2023 12:03:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82599' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 01/04/2023 12:03:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82599' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 01/04/2023 12:14:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 12:14:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1091' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.50' , '66.80' , NOW() , NOW() ) 01/04/2023 12:14:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82600' 01/04/2023 12:14:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82600' 01/04/2023 12:14:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82600' , '19776' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '-1' , '1' , '20.50' , '16.803278688525' , '22' , '0' , '20.50' ) 01/04/2023 12:14:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82600' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '50' , '50' , '0' , '0' , '50.00' ) 01/04/2023 12:23:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 12:23:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1092' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '212.10' , '176.94' , NOW() , NOW() ) 01/04/2023 12:23:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82601' 01/04/2023 12:23:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '82601' 01/04/2023 12:23:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82601' , '20778' , 'PASSIO N.E.' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 01/04/2023 12:23:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82601' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '195' , '159.83606557377' , '22' , '0' , '195.00' ) 01/04/2023 12:47:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 12:47: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' , '1093' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '82.82' , NOW() , NOW() ) 01/04/2023 12:47: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 = '82602' 01/04/2023 12:47:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '82602' 01/04/2023 12:47: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 ( '82602' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '1' , '-1' , '1' , '72.75' , '59.631147540984' , '22' , '0' , '72.75' ) 01/04/2023 12:47: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 ( '82602' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 01/04/2023 12:47: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 ( '82602' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/04/2023 12:49:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000885' AND id_product != '1370' AND ean13 != '' 01/04/2023 12:49:04 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2016', ean13 = '000885', date_upd = NOW() WHERE id_product = '1370' 01/04/2023 12:49:04 pm >> UPDATE ps_product_lang SET name = 'BROCCHETTE RICAMBIO PER ART. 523 - 500', description = '' WHERE id_product = '1370' 01/04/2023 12:49:04 pm >> UPDATE ps_product SET wholesale_price = '4.75', on_sale = '0', price = '10.655737704918034' WHERE id_product = '1370' 01/04/2023 12:49:04 pm >> UPDATE ps_product_shop SET wholesale_price = '4.75', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1370' 01/04/2023 12:49:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '1370' 01/04/2023 12:52:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 12:52:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1094' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 01/04/2023 12:52:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82603' 01/04/2023 12:52:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82603' 01/04/2023 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82603' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' ) 01/04/2023 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82603' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 01/04/2023 12:52:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82603' , '12582' , 'VETRO ANTIVENTO PER F. CANDELA DIAM 3,2 - 73/32' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 01/04/2023 01:01:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 01/04/2023 01:01:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1095' , '2023-04-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 01/04/2023 01:01:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82604' 01/04/2023 01:01:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82604' 01/04/2023 01:01:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82604' , '13750' , 'TUNICA DUE PIEGONI' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' )