20/02/2024 08:30:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2693/00/2024' , '2024-02-16' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '238.80' , '238.80' , NOW() , NOW() ) 20/02/2024 08:30:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90419' 20/02/2024 08:30:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90419' 20/02/2024 08:30:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90419' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '76' , '76' , '4' , '5.00' , '5' , '0' , '40' , '228.0000' ) 20/02/2024 08:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22023' AND id_supplier = '38' 20/02/2024 08:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22023' , '38' , '1' ) 20/02/2024 08:30:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90419' , '11283' , 'VIA CRUCIS - 8137' , '2' , '2' , '4' , '9.00' , '9' , '0' , '40' , '10.8000' ) 20/02/2024 08:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '11283' AND id_supplier = '38' 20/02/2024 08:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11283' , '38' , '1' ) 20/02/2024 08:40:17 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/02/2024 08:40:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22159' , '1' , '' , 'nuovo-prodotto' ) 20/02/2024 08:40:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22159' , '1' , '1' , '2' , NOW() , NOW() ) 20/02/2024 08:40:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22159' , '0' , '1' , '0' , '0' ) 20/02/2024 08:42:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002220' AND id_product != '22159' AND ean13 != '' 20/02/2024 08:42:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002220', date_upd = NOW() WHERE id_product = '22159' 20/02/2024 08:42:37 am >> UPDATE ps_product_lang SET name = 'CALICE NODO APOSTOLI - 756', description = '' WHERE id_product = '22159' 20/02/2024 08:42:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '309.8360655737705' WHERE id_product = '22159' 20/02/2024 08:42:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '309.8360655737705', id_tax_rules_group = '1', id_category_default = '481', 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 = '22159' 20/02/2024 08:42:37 am >> DELETE FROM ps_specific_price WHERE id_product = '22159' 20/02/2024 08:42:38 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22159' 20/02/2024 08:42:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22160' , '1' , '' , 'nuovo-prodotto' ) 20/02/2024 08:42:38 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22160' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22159' 20/02/2024 08:42:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22160' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22159' 20/02/2024 08:44:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002221' AND id_product != '22160' AND ean13 != '' 20/02/2024 08:44:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002221', date_upd = NOW() WHERE id_product = '22160' 20/02/2024 08:44:29 am >> UPDATE ps_product_lang SET name = 'PISSIDE NODO APOSTOLI - 757', description = '' WHERE id_product = '22160' 20/02/2024 08:44:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '336.0655737704918' WHERE id_product = '22160' 20/02/2024 08:44:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '336.0655737704918', id_tax_rules_group = '1', id_category_default = '481', 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 = '22160' 20/02/2024 08:44:29 am >> DELETE FROM ps_specific_price WHERE id_product = '22160' 20/02/2024 08:44:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22160' 20/02/2024 08:44:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22161' , '1' , '' , 'nuovo-prodotto' ) 20/02/2024 08:44:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22161' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22160' 20/02/2024 08:44:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22161' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22160' 20/02/2024 08:47:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002222' AND id_product != '22161' AND ean13 != '' 20/02/2024 08:47:43 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002222', date_upd = NOW() WHERE id_product = '22161' 20/02/2024 08:47:43 am >> UPDATE ps_product_lang SET name = 'CALICE PIETRE BLU - 750', description = '' WHERE id_product = '22161' 20/02/2024 08:47:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '651.6393442622951' WHERE id_product = '22161' 20/02/2024 08:47:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '651.6393442622951', id_tax_rules_group = '1', id_category_default = '481', 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 = '22161' 20/02/2024 08:47:43 am >> DELETE FROM ps_specific_price WHERE id_product = '22161' 20/02/2024 08:48:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002222' AND id_product != '22161' AND ean13 != '' 20/02/2024 08:48:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002222', date_upd = NOW() WHERE id_product = '22161' 20/02/2024 08:48:13 am >> UPDATE ps_product_lang SET name = 'CALICE PIETRE BLU - 750', description = '' WHERE id_product = '22161' 20/02/2024 08:48:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '651.6393442622951' WHERE id_product = '22161' 20/02/2024 08:48:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '651.6393442622951', id_tax_rules_group = '1', id_category_default = '481', 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 = '22161' 20/02/2024 08:48:13 am >> DELETE FROM ps_specific_price WHERE id_product = '22161' 20/02/2024 08:48:15 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22161' 20/02/2024 08:48:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22162' , '1' , '' , 'nuovo-prodotto' ) 20/02/2024 08:48:15 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22162' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22161' 20/02/2024 08:48:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22162' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22161' 20/02/2024 08:50:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002223' AND id_product != '22162' AND ean13 != '' 20/02/2024 08:50:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002223', date_upd = NOW() WHERE id_product = '22162' 20/02/2024 08:50:35 am >> UPDATE ps_product_lang SET name = 'CALICE SPIGHE - 516', description = '' WHERE id_product = '22162' 20/02/2024 08:50:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '376.2295081967213' WHERE id_product = '22162' 20/02/2024 08:50:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '376.2295081967213', id_tax_rules_group = '1', id_category_default = '481', 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 = '22162' 20/02/2024 08:50:35 am >> DELETE FROM ps_specific_price WHERE id_product = '22162' 20/02/2024 08:50:37 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22162' 20/02/2024 08:50:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22163' , '1' , '' , 'nuovo-prodotto' ) 20/02/2024 08:50:37 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22163' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22162' 20/02/2024 08:50:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22163' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22162' 20/02/2024 08:54:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002224' AND id_product != '22163' AND ean13 != '' 20/02/2024 08:54:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002224', date_upd = NOW() WHERE id_product = '22163' 20/02/2024 08:54:13 am >> UPDATE ps_product_lang SET name = 'CALICE CLASSICO - 155', description = '' WHERE id_product = '22163' 20/02/2024 08:54:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '376.2295081967213' WHERE id_product = '22163' 20/02/2024 08:54:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '376.2295081967213', id_tax_rules_group = '1', id_category_default = '481', 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 = '22163' 20/02/2024 08:54:13 am >> DELETE FROM ps_specific_price WHERE id_product = '22163' 20/02/2024 08:54:14 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22163' 20/02/2024 08:54:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22164' , '1' , '' , 'nuovo-prodotto' ) 20/02/2024 08:54:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22164' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22163' 20/02/2024 08:54:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22164' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22163' 20/02/2024 08:55:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '17' , '2024-02-16' , '' , '0' , '150' , '4671103' , 'VIA MATTEOTTI 16 26838 TAVAZZANO CON VILLAVESCO' , '' , '' , '20' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1223.97' , '1003.25' , NOW() , NOW() ) 20/02/2024 08:55:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90420' 20/02/2024 08:55:02 am >> DELETE FROM ps_document_detail WHERE id_document = '90420' 20/02/2024 08:55:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90420' , '22159' , 'CALICE NODO APOSTOLI - 756' , '1' , '1' , '1' , '155' , '127.04918032787' , '22' , '5' , '179.6450' ) 20/02/2024 08:55:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '22159' AND id_supplier = '150' 20/02/2024 08:55:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22159' , '150' , '1' ) 20/02/2024 08:55:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90420' , '22160' , 'PISSIDE NODO APOSTOLI - 757' , '1' , '1' , '1' , '170' , '139.34426229508' , '22' , '5' , '197.0300' ) 20/02/2024 08:55:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '22160' AND id_supplier = '150' 20/02/2024 08:55:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22160' , '150' , '1' ) 20/02/2024 08:55:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90420' , '22161' , 'CALICE PIETRE BLU - 750' , '1' , '1' , '1' , '330' , '270.49180327869' , '22' , '5' , '382.4700' ) 20/02/2024 08:55:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '22161' AND id_supplier = '150' 20/02/2024 08:55:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22161' , '150' , '1' ) 20/02/2024 08:55:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90420' , '22162' , 'CALICE SPIGHE - 516' , '1' , '1' , '1' , '190' , '155.73770491803' , '22' , '5' , '220.2100' ) 20/02/2024 08:55:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '22162' AND id_supplier = '150' 20/02/2024 08:55:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22162' , '150' , '1' ) 20/02/2024 08:55:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90420' , '22163' , 'CALICE CLASSICO - 155' , '1' , '1' , '1' , '190' , '155.73770491803' , '22' , '5' , '220.2100' ) 20/02/2024 08:55:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '22163' AND id_supplier = '150' 20/02/2024 08:55:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22163' , '150' , '1' ) 20/02/2024 10:10:17 am >> SELECT document_num FROM ps_document WHERE document_num = '505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 10:10:17 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' , '505' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/02/2024 10:10:17 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 = '90421' 20/02/2024 10:10:17 am >> DELETE FROM ps_document_detail WHERE id_document = '90421' 20/02/2024 10:10:17 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 ( '90421' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/02/2024 10:42:20 am >> SELECT document_num FROM ps_document WHERE document_num = '506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 10:42:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '506' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 20/02/2024 10:42:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90422' 20/02/2024 10:42:20 am >> DELETE FROM ps_document_detail WHERE id_document = '90422' 20/02/2024 10:42:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90422' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '12.00' ) 20/02/2024 11:07:48 am >> SELECT document_num FROM ps_document WHERE document_num = '507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 11:07:48 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' , '507' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 20/02/2024 11:07:48 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 = '90423' 20/02/2024 11:07:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90423' 20/02/2024 11:07:48 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 ( '90423' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 20/02/2024 12:35:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 12:35:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '508' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.25' , '26.55' , NOW() , NOW() ) 20/02/2024 12:35:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90424' 20/02/2024 12:35:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '90424' 20/02/2024 12:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90424' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 20/02/2024 12:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90424' , '20751' , 'QUARESIMA OMELIE BENEDETTO XVI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/02/2024 03:27:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 03:27:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '509' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 20/02/2024 03:27:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90425' 20/02/2024 03:27:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '90425' 20/02/2024 03:27:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90425' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '0' , '85.00' ) 20/02/2024 03:28:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 03:28: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' , '510' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 20/02/2024 03:28: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 = '90426' 20/02/2024 03:28:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90426' 20/02/2024 03:28: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 ( '90426' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 20/02/2024 03:28:16 pm >> DELETE FROM ps_document WHERE id_document = '90426' 20/02/2024 03:28:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90426' 20/02/2024 03:28:19 pm >> DELETE FROM ps_document WHERE id_document = '90425' 20/02/2024 03:28:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90425' 20/02/2024 03:36:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 03:36:51 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' , '509' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.50' , '49.79' , NOW() , NOW() ) 20/02/2024 03:36:51 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 = '90427' 20/02/2024 03:36:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '90427' 20/02/2024 03:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90427' , '19910' , 'LUCERNA COLORATA - 1490/KIT' , '2' , '-2' , '1' , '16' , '13.114754098361' , '22' , '0' , '32.00' ) 20/02/2024 03:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90427' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 20/02/2024 03:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90427' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/02/2024 03:45:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 03:45:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '510' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 20/02/2024 03:45:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90428' 20/02/2024 03:45:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90428' 20/02/2024 03:45:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90428' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 20/02/2024 03:45:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90428' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 20/02/2024 03:59:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 03:59: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' , '511' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '244.00' , '200.00' , NOW() , NOW() ) 20/02/2024 03:59: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 = '90429' 20/02/2024 03:59:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90429' 20/02/2024 03:59: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 ( '90429' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 20/02/2024 03:59: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 ( '90429' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 20/02/2024 03:59: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 ( '90429' , '16271' , 'FERMAGLIO ORO - B18/FE' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 20/02/2024 03:59: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 ( '90429' , '20272' , 'CASULA CROCE - 652' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 20/02/2024 04:04:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 04:04: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' , '512' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.75' , '80.75' , NOW() , NOW() ) 20/02/2024 04:04: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 = '90430' 20/02/2024 04:04:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90430' 20/02/2024 04:04: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 ( '90430' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 20/02/2024 04:05:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '261' AND id_document != '90101' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-25') 20/02/2024 04:05:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '261', document_date = '2024-01-25', 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 = '40.00', price_tax_excluded = '36.39', date_upd = NOW() WHERE id_document = '90101' 20/02/2024 04:05:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90101' 20/02/2024 04:05:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90101' 20/02/2024 04:05:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90101' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/02/2024 04:05:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90101' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/02/2024 04:05:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90101' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 20/02/2024 04:05:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90101' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 20/02/2024 04:05:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90101' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '4' , '-4' , '4' , '4.75' , '4.75' , '0' , '0' , '19.00' ) 20/02/2024 04:07:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '90157' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 20/02/2024 04:07:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '308', document_date = '2024-01-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '90157' 20/02/2024 04:07: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 = '90157' 20/02/2024 04:07:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '90157' 20/02/2024 04:07: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 ( '90157' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '21.75' , '21.75' , '0' , '0' , '21.75' ) 20/02/2024 04:07: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 ( '90157' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 20/02/2024 04:07: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 ( '90157' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/02/2024 04:18:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '513' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 04:18:03 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' , '513' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '7.87' , NOW() , NOW() ) 20/02/2024 04:18: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 = '90431' 20/02/2024 04:18:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90431' 20/02/2024 04:18: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 ( '90431' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '3' , '-3' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '9.60' ) 20/02/2024 04:18:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '514' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 04:18:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '514' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 20/02/2024 04:18:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90432' 20/02/2024 04:18:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90432' 20/02/2024 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90432' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 20/02/2024 04:20:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '515' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 04:20:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '515' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '33.20' , NOW() , NOW() ) 20/02/2024 04:20: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 = '90433' 20/02/2024 04:20:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90433' 20/02/2024 04:20: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 ( '90433' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26.6' , '21.803278688525' , '22' , '0' , '26.60' ) 20/02/2024 04:20: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 ( '90433' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 20/02/2024 05:10:30 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'z5SHwLVIH8A6Qr7l' , NOW() , NOW() ) 20/02/2024 05:10:30 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4087' , '1' ) 20/02/2024 05:10:30 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4087' , '2' ) 20/02/2024 05:10:30 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4087' , '3' ) 20/02/2024 05:16:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4087' 20/02/2024 05:16:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4087' , '10' , '208' , 'SUORE MISSIONARIE DI GESU\' ETERNO SACERDOTE' , '' , '' , 'VIA TRIONFALE 7585' , '' , '00135' , 'ROMA' , '' , '0635510452' , '' , '' , '82006190027' , NOW() , NOW() ) 20/02/2024 05:16:19 pm >> UPDATE ps_customer SET email = 'segreteriamges@gmail.com', sdi = '0000000', pec = 'suoremges@pec.legalzone.it', date_upd = NOW() WHERE id_customer = '4087' 20/02/2024 05:17:27 pm >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '4087' 20/02/2024 05:24:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '7/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 05:24:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '7/E' , '2024-02-20' , 'E' , '4086' , '0' , '4679277' , 'VIA TRIONFALE 7585 00135 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '5019.60' , '4980.00' , NOW() , NOW() ) 20/02/2024 05:24: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 = '90434' 20/02/2024 05:24:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90434' 20/02/2024 05:24: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 ( '90434' , '22153' , 'UNA VITA CONSUMATA NELL\'AMORE' , '3000' , '-3000' , '4' , '1.6' , '1.6' , '0' , '0' , '4800.00' ) 20/02/2024 05:24: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 ( '90434' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '1' , '122' , '100' , '22' , '0' , '122.00' ) 20/02/2024 05:24: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 ( '90434' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '1' , '97.6' , '80' , '22' , '0' , '97.60' ) 20/02/2024 05:33:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '406' AND id_document != '90299' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 20/02/2024 05:33:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '406', document_date = '2024-02-08', 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 = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '90299' 20/02/2024 05:33:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90299' 20/02/2024 05:33:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90299' 20/02/2024 05:33:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90299' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.82' , '4.82' , '0' , '0' , '4.82' ) 20/02/2024 05:33:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90299' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '5' , '9.98' ) 20/02/2024 05:33:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90299' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 20/02/2024 06:31:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 06:31:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '516' , '2024-02-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.55' , '10.55' , NOW() , NOW() ) 20/02/2024 06:31:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90435' 20/02/2024 06:31:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90435' 20/02/2024 06:31:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90435' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/02/2024 06:31:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90435' , '21810' , 'AMEN - FEB 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 20/02/2024 06:31:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90435' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 20/02/2024 07:59:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '511' AND id_document != '90429' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 20/02/2024 07:59:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '511', document_date = '2024-02-20', 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 = '244.00', price_tax_excluded = '200.00', date_upd = NOW() WHERE id_document = '90429' 20/02/2024 07:59:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90429' 20/02/2024 07:59:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90429' 20/02/2024 07:59:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90429' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '80' , '65.573770491803' , '22' , '0' , '160.00' ) 20/02/2024 07:59:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90429' , '16271' , 'FERMAGLIO ORO - B18/FE' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 20/02/2024 07:59:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90429' , '20272' , 'CASULA CROCE - 652' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' )