28/01/2025 09:04:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002016' AND id_product != '19912' AND ean13 != '' 28/01/2025 09:04:01 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '002016', date_upd = NOW() WHERE id_product = '19912' 28/01/2025 09:04:01 am >> UPDATE ps_product_lang SET name = 'CASULA AGNELLO - L/S/ MOIRE - 8219-8249LS', description = '' WHERE id_product = '19912' 28/01/2025 09:04:01 am >> UPDATE ps_product SET wholesale_price = '440.00', on_sale = '0', price = '975.4098360655738' WHERE id_product = '19912' 28/01/2025 09:04:01 am >> UPDATE ps_product_shop SET wholesale_price = '440.00', price = '975.4098360655738', id_tax_rules_group = '1', id_category_default = '448', 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 = '19912' 28/01/2025 09:04:01 am >> DELETE FROM ps_specific_price WHERE id_product = '19912' 28/01/2025 09:38:04 am >> SELECT document_num FROM ps_document WHERE document_num = '275' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 09:38: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' , '275' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '281.21' , '251.80' , NOW() , NOW() ) 28/01/2025 09:38: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 = '95458' 28/01/2025 09:38:04 am >> DELETE FROM ps_document_detail WHERE id_document = '95458' 28/01/2025 09:38: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 ( '95458' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '4' , '-4' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '40.00' ) 28/01/2025 09:38: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 ( '95458' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/01/2025 09:38: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 ( '95458' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/01/2025 09:38: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 ( '95458' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 28/01/2025 09:38: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 ( '95458' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 28/01/2025 09:38: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 ( '95458' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 28/01/2025 09:38: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 ( '95458' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 28/01/2025 09:38: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 ( '95458' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 28/01/2025 09:38: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 ( '95458' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 28/01/2025 09:38: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 ( '95458' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 28/01/2025 09:38: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 ( '95458' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 28/01/2025 09:38: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 ( '95458' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 28/01/2025 09:38: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 ( '95458' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 28/01/2025 09:38: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 ( '95458' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 28/01/2025 09:38: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 ( '95458' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 28/01/2025 09:38: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 ( '95458' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 28/01/2025 09:39:33 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'G7DXWHQhHiVqyUIP' , NOW() , NOW() ) 28/01/2025 09:39:33 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4159' , '1' ) 28/01/2025 09:39:33 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4159' , '2' ) 28/01/2025 09:39:33 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4159' , '3' ) 28/01/2025 09:51:33 am >> SELECT document_num FROM ps_document WHERE document_num = '276' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 09:51:33 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' , '276' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '174.15' , '144.56' , NOW() , NOW() ) 28/01/2025 09:51:33 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 = '95459' 28/01/2025 09:51:33 am >> DELETE FROM ps_document_detail WHERE id_document = '95459' 28/01/2025 09:51:33 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 ( '95459' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 28/01/2025 09:51:33 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 ( '95459' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '6' , '-6' , '1' , '15' , '12.295081967213' , '22' , '0' , '90.00' ) 28/01/2025 09:51:33 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 ( '95459' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '4' , '-4' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '15.60' ) 28/01/2025 09:51:33 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 ( '95459' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 28/01/2025 09:51:33 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 ( '95459' , '15867' , 'LETTERA AI MINISTRI STRAORDINARI DELLA COMUNIONE - 8964' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 28/01/2025 09:51:33 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 ( '95459' , '11743' , 'MINISTERO STRAORDINARIO DELLA COMUNIONE' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 28/01/2025 10:25:17 am >> DELETE FROM ps_document WHERE id_document = '95350' 28/01/2025 10:25:17 am >> DELETE FROM ps_document_detail WHERE id_document = '95350' 28/01/2025 10:26:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820568' AND id_product != '1147' AND ean13 != '' 28/01/2025 10:26:40 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820568', date_upd = NOW() WHERE id_product = '1147' 28/01/2025 10:26:40 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME X STUDIO', description = '' WHERE id_product = '1147' 28/01/2025 10:26:40 am >> UPDATE ps_product SET wholesale_price = '26.10', on_sale = '0', price = '49' WHERE id_product = '1147' 28/01/2025 10:26:40 am >> UPDATE ps_product_shop SET wholesale_price = '26.10', price = '49', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1147' 28/01/2025 10:26:40 am >> DELETE FROM ps_specific_price WHERE id_product = '1147' 28/01/2025 10:28:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820346' AND id_product != '1142' AND ean13 != '' 28/01/2025 10:28:11 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820346', date_upd = NOW() WHERE id_product = '1142' 28/01/2025 10:28:11 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME - TASC.', description = '' WHERE id_product = '1142' 28/01/2025 10:28:11 am >> UPDATE ps_product SET wholesale_price = '21.16', on_sale = '0', price = '35' WHERE id_product = '1142' 28/01/2025 10:28:11 am >> UPDATE ps_product_shop SET wholesale_price = '21.16', price = '35', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1142' 28/01/2025 10:28:11 am >> DELETE FROM ps_specific_price WHERE id_product = '1142' 28/01/2025 11:58:18 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/01/2025 11:58:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23391' , '1' , '' , 'nuovo-prodotto' ) 28/01/2025 11:58:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23391' , '1' , '1' , '2' , NOW() , NOW() ) 28/01/2025 11:58:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23391' , '0' , '1' , '0' , '0' ) 28/01/2025 12:00:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002341' AND id_product != '23391' AND ean13 != '' 28/01/2025 12:00:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002341', date_upd = NOW() WHERE id_product = '23391' 28/01/2025 12:00:12 pm >> UPDATE ps_product_lang SET name = 'DALMATICA - 86/D16212', description = '' WHERE id_product = '23391' 28/01/2025 12:00:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '270.4918032786885' WHERE id_product = '23391' 28/01/2025 12:00:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '468', 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 = '23391' 28/01/2025 12:00:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '23391' 28/01/2025 12:01:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '277' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 12:01:57 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' , '277' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.60' , '12.79' , NOW() , NOW() ) 28/01/2025 12:01:57 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 = '95460' 28/01/2025 12:01:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '95460' 28/01/2025 12:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95460' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '15.60' ) 28/01/2025 12:02:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002341' AND id_product != '23391' AND ean13 != '' 28/01/2025 12:02:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002341', date_upd = NOW() WHERE id_product = '23391' 28/01/2025 12:02:34 pm >> UPDATE ps_product_lang SET name = 'DALMATICA - 86/D16212', description = '' WHERE id_product = '23391' 28/01/2025 12:02:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '270.4918032786885' WHERE id_product = '23391' 28/01/2025 12:02:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '468', 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 = '23391' 28/01/2025 12:02:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23391' 28/01/2025 12:02:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23391' 28/01/2025 12:02:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23392' , '1' , '' , 'nuovo-prodotto' ) 28/01/2025 12:02:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23392' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23391' 28/01/2025 12:02:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23392' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23391' 28/01/2025 12:03:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002342' AND id_product != '23392' AND ean13 != '' 28/01/2025 12:03:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002342', date_upd = NOW() WHERE id_product = '23392' 28/01/2025 12:03:49 pm >> UPDATE ps_product_lang SET name = 'DALMATICA - 86/D16418', description = '' WHERE id_product = '23392' 28/01/2025 12:03:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '229.5081967213115' WHERE id_product = '23392' 28/01/2025 12:03:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '229.5081967213115', id_tax_rules_group = '1', id_category_default = '468', 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 = '23392' 28/01/2025 12:03:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '23392' 28/01/2025 12:04: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 ( '31' , '18' , '2025-01-24' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1310.02' , '1073.79' , NOW() , NOW() ) 28/01/2025 12:04: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 = '95461' 28/01/2025 12:04:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95461' 28/01/2025 12:04: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 ( '95461' , '23391' , 'DALMATICA - 86/D16212' , '4' , '4' , '1' , '133' , '109.01639344262' , '22' , '3' , '629.5688' ) 28/01/2025 12:04:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23391' AND id_supplier = '143' 28/01/2025 12:04:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23391' , '143' , '1' ) 28/01/2025 12:04: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 ( '95461' , '23392' , 'DALMATICA - 86/D16418' , '5' , '5' , '1' , '115' , '94.262295081967' , '22' , '3' , '680.4550' ) 28/01/2025 12:04:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23392' AND id_supplier = '143' 28/01/2025 12:04:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23392' , '143' , '1' ) 28/01/2025 12:45:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '278' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 12:45:36 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' , '278' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 28/01/2025 12:45:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95462' 28/01/2025 12:45:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95462' 28/01/2025 12:45:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95462' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 28/01/2025 12:55:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '279' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 12:55:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '279' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 28/01/2025 12:55:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95463' 28/01/2025 12:55:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '95463' 28/01/2025 12:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95463' , '23321' , 'FEDE E SACRAMENTALITA DEL MATRIMONIO - A. ACRI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 28/01/2025 12:58:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '280' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 12:58:07 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' , '280' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 28/01/2025 12:58:07 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 = '95464' 28/01/2025 12:58:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '95464' 28/01/2025 12:58:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95464' , '10119' , 'SPE SALVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/01/2025 04:09:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 04:09:10 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' , '281' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.40' , '8.52' , NOW() , NOW() ) 28/01/2025 04:09:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95465' 28/01/2025 04:09:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95465' 28/01/2025 04:09:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95465' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 28/01/2025 04:09:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95465' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 28/01/2025 04:53:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '209' AND id_document != '95368' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-21') 28/01/2025 04:53:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '209', document_date = '2025-01-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '95368' 28/01/2025 04:53: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 = '95368' 28/01/2025 04:53:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '95368' 28/01/2025 04:53: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 ( '95368' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 28/01/2025 04:53: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 ( '95368' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/01/2025 04:54:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '120' AND id_document != '95250' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-11') 28/01/2025 04:54:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '120', document_date = '2025-01-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '95250' 28/01/2025 04:54:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95250' 28/01/2025 04:54:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95250' 28/01/2025 04:54:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95250' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/01/2025 05:10:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '282' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 05:10: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' , '282' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 28/01/2025 05:10: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 = '95466' 28/01/2025 05:10:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '95466' 28/01/2025 05:10: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 ( '95466' , '23344' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2025' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 28/01/2025 05:26:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 05:26:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '283' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 28/01/2025 05:26: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 = '95467' 28/01/2025 05:26:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95467' 28/01/2025 05:26: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 ( '95467' , '16308' , 'PORTACHIAVI SAN BENEDETTO' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 28/01/2025 05:38:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 05:38:14 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' , '284' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 28/01/2025 05:38:14 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 = '95468' 28/01/2025 05:38:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95468' 28/01/2025 05:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95468' , '23344' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2025' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 28/01/2025 06:07:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 06:07: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' , '285' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 28/01/2025 06:07: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 = '95469' 28/01/2025 06:07:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '95469' 28/01/2025 06:07: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 ( '95469' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/01/2025 06:17:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 28/01/2025 06:17:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '272.00', price_tax_excluded = '232.19', date_upd = NOW() WHERE id_document = '94912' 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 28/01/2025 06:17:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '120.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23169' , 'DILEXIT NOS ****' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 28/01/2025 06:17:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 28/01/2025 06:30:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '286' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 06:30:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '286' , '2025-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 28/01/2025 06:30:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95470' 28/01/2025 06:30:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '95470' 28/01/2025 06:30:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95470' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 28/01/2025 07:03:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '29/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-28') 28/01/2025 07:03:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '29/A' , '2025-01-28' , 'A' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 28/01/2025 07:03:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95471' 28/01/2025 07:03:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '95471' 28/01/2025 07:03:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95471' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' )