13/11/2024 08:55:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042286' AND id_product != '7108' AND ean13 != '' 13/11/2024 08:55:14 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884042286', date_upd = NOW() WHERE id_product = '7108' 13/11/2024 08:55:14 am >> UPDATE ps_product_lang SET name = 'NOVENA AL SANTO NATALE - 8521', description = '' WHERE id_product = '7108' 13/11/2024 08:55:14 am >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '2.0000' WHERE id_product = '7108' 13/11/2024 08:55:14 am >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '2.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7108' 13/11/2024 08:55:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7108' 13/11/2024 08:56:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/11/2024 08:56:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23194' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 08:56:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23194' , '1' , '1' , '2' , NOW() , NOW() ) 13/11/2024 08:56:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23194' , '0' , '1' , '0' , '0' ) 13/11/2024 08:56:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391851' AND id_product != '23194' AND ean13 != '' 13/11/2024 08:56:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256391851', date_upd = NOW() WHERE id_product = '23194' 13/11/2024 08:56:44 am >> UPDATE ps_product_lang SET name = 'DILEXIT NOS - 8992', description = '' WHERE id_product = '23194' 13/11/2024 08:56:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23194' 13/11/2024 08:56:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23194' 13/11/2024 08:56:44 am >> DELETE FROM ps_specific_price WHERE id_product = '23194' 13/11/2024 08:56:51 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 = '23194' 13/11/2024 08:56:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23195' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 08:56:51 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 '23195' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23194' 13/11/2024 08:56:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23195' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23194' 13/11/2024 08:57: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 ( '31' , '16948/00/2024' , '2024-11-11' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '123.61' , '118.85' , NOW() , NOW() ) 13/11/2024 08:57: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 = '94220' 13/11/2024 08:57:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94220' 13/11/2024 08:57: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 ( '94220' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '5' , '5' , '4' , '5.00' , '5' , '0' , '40' , '15.0000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22845' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22845' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '10' , '10' , '4' , '5.00' , '5' , '0' , '40' , '30.0000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '23104' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23104' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '2761' , 'CORONA DI CENTO REQUIEM - 8181' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '40' , '1.8000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '2761' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2761' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '3' , '3' , '4' , '4.00' , '4' , '0' , '40' , '7.2000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '9105' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9105' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '5' , '5' , '4' , '2.00' , '2' , '0' , '40' , '6.0000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '7108' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7108' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '15' , '15' , '4' , '1.00' , '1' , '0' , '40' , '9.0000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22846' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22846' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '22987' , 'GIUSEPPE MOSCATI - 8744' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22987' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22987' , '38' , '1' ) 13/11/2024 08:57: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 ( '94220' , '23163' , 'SANTA FILOMENA - 8841' , '2' , '2' , '4' , '7.00' , '7' , '0' , '40' , '8.4000' ) 13/11/2024 08:57:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '23163' AND id_supplier = '38' 13/11/2024 08:57:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23163' , '38' , '1' ) 13/11/2024 08:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94220' , '23194' , 'DILEXIT NOS - 8992' , '5' , '5' , '4' , '3.00' , '3' , '0' , '40' , '9.0000' ) 13/11/2024 08:57:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23194' AND id_supplier = '38' 13/11/2024 08:57:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23194' , '38' , '1' ) 13/11/2024 08:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94220' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '2' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '14.4058' ) 13/11/2024 08:57:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22911' AND id_supplier = '38' 13/11/2024 08:57:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22911' , '38' , '1' ) 13/11/2024 08:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94220' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '2' , '2' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '12.0048' ) 13/11/2024 08:57:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22910' AND id_supplier = '38' 13/11/2024 08:57:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22910' , '38' , '1' ) 13/11/2024 09:44:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069259' AND id_product != '23195' AND ean13 != '' 13/11/2024 09:44:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788801069259', date_upd = NOW() WHERE id_product = '23195' 13/11/2024 09:44:22 am >> UPDATE ps_product_lang SET name = 'SALE E PEPE NELLA LITURGIA - E. MASSINI', description = '' WHERE id_product = '23195' 13/11/2024 09:44:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23195' 13/11/2024 09:44:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23195' 13/11/2024 09:44:22 am >> DELETE FROM ps_specific_price WHERE id_product = '23195' 13/11/2024 09:44:23 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 = '23195' 13/11/2024 09:44:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23196' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 09:44:23 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 '23196' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23195' 13/11/2024 09:44:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23196' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23195' 13/11/2024 09:45:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246775' AND id_product != '23196' AND ean13 != '' 13/11/2024 09:45:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892246775', date_upd = NOW() WHERE id_product = '23196' 13/11/2024 09:45:00 am >> UPDATE ps_product_lang SET name = 'DILEXIT NOS', description = '' WHERE id_product = '23196' 13/11/2024 09:45:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '23196' 13/11/2024 09:45:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23196' 13/11/2024 09:45:01 am >> DELETE FROM ps_specific_price WHERE id_product = '23196' 13/11/2024 09:45:01 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 = '23196' 13/11/2024 09:45:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23197' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 09:45:01 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 '23197' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23196' 13/11/2024 09:45:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23197' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23196' 13/11/2024 09:46:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259754295' AND id_product != '23197' AND ean13 != '' 13/11/2024 09:46:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259754295', date_upd = NOW() WHERE id_product = '23197' 13/11/2024 09:46:06 am >> UPDATE ps_product_lang SET name = 'AIUTAMI A PREGARE', description = '' WHERE id_product = '23197' 13/11/2024 09:46:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23197' 13/11/2024 09:46:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23197' 13/11/2024 09:46:06 am >> DELETE FROM ps_specific_price WHERE id_product = '23197' 13/11/2024 09:46:07 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 = '23197' 13/11/2024 09:46:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23198' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 09:46:07 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 '23198' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23197' 13/11/2024 09:46:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23198' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23197' 13/11/2024 09:46:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '681368' , '2024-11-11' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.74' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.36' , '126.36' , NOW() , NOW() ) 13/11/2024 09:46:31 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 = '94221' 13/11/2024 09:46:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94221' 13/11/2024 09:46:31 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 ( '94221' , '23195' , 'SALE E PEPE NELLA LITURGIA - E. MASSINI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 13/11/2024 09:46:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '23195' AND id_supplier = '7' 13/11/2024 09:46:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23195' , '7' , '1' ) 13/11/2024 09:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94221' , '23196' , 'DILEXIT NOS' , '12' , '12' , '4' , '2.90' , '2.9' , '0' , '33' , '23.3160' ) 13/11/2024 09:46:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '23196' AND id_supplier = '7' 13/11/2024 09:46:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23196' , '7' , '1' ) 13/11/2024 09:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94221' , '23196' , 'DILEXIT NOS' , '1' , '1' , '4' , '2.90' , '2.9' , '0' , '100' , '0.0000' ) 13/11/2024 09:46:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '23196' AND id_supplier = '7' 13/11/2024 09:46:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23196' , '7' , '1' ) 13/11/2024 09:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94221' , '23169' , 'DILEXIT NOS ' , '60' , '60' , '4' , '2.20' , '2.2' , '0' , '35' , '85.8000' ) 13/11/2024 09:46:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 13/11/2024 09:46:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 13/11/2024 09:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94221' , '23169' , 'DILEXIT NOS ' , '5' , '5' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 13/11/2024 09:46:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 13/11/2024 09:46:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 13/11/2024 09:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94221' , '23197' , 'AIUTAMI A PREGARE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 13/11/2024 09:46:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '23197' AND id_supplier = '7' 13/11/2024 09:46:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23197' , '7' , '1' ) 13/11/2024 09:49:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3452' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 09:49:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3452' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 13/11/2024 09:49:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94222' 13/11/2024 09:49:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94222' 13/11/2024 09:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94222' , '23120' , 'AMEN - GEN 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 13/11/2024 09:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94222' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 13/11/2024 10:07:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '681369' , '2024-11-11' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '23.27' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '759.19' , '759.19' , NOW() , NOW() ) 13/11/2024 10:07:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94223' 13/11/2024 10:07:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94223' 13/11/2024 10:07:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 13/11/2024 10:07:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '7' 13/11/2024 10:07:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '7' , '1' ) 13/11/2024 10:07:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '20' , '20' , '4' , '3.00' , '3' , '0' , '35+7' , '36.2700' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '9679' , 'SARETE MIEI TESTIMONI - GUIDA - G. MORANTE' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35+7' , '8.4630' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '9679' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9679' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '11186' , 'VENITE CON ME - GUIDA - M. FILIPPI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35+7' , '8.4630' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11186' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11186' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '21591' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 1' , '20' , '20' , '4' , '6.90' , '6.9' , '0' , '30+7' , '89.8380' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '21591' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21591' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '25' , '25' , '4' , '5.00' , '5' , '0' , '35+7' , '75.5625' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '3' , '3' , '4' , '15.00' , '15' , '0' , '35+7' , '27.2025' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22803' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22803' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '19953' , 'FELIZ CITTA - GIOCO CARLO ACUTIS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30+7' , '9.7650' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19953' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19953' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33+7' , '8.7234' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '20043' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20043' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '30' , '30' , '4' , '3.00' , '3' , '0' , '35+7' , '54.4050' ) 13/11/2024 10:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 13/11/2024 10:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 13/11/2024 10:07:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30+7' , '6.5100' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '22230' , 'GIOCHIAMO CON LA BIBBIA' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35+7' , '7.7981' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22230' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22230' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '2' , '2' , '4' , '7.90' , '7.9' , '0' , '35+7' , '9.5511' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '23143' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23143' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '10' , '10' , '4' , '5.90' , '5.9' , '0' , '30+7' , '38.4090' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17244' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17244' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '6' , '6' , '4' , '1.90' , '1.9' , '0' , '35+7' , '6.8913' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '12712' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12712' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '11' , '11' , '4' , '5.90' , '5.9' , '0' , '30+7' , '42.2499' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17245' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17245' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '25' , '25' , '4' , '1.00' , '1' , '0' , '30+7' , '16.2750' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22893' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22893' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '3' , '3' , '4' , '6.90' , '6.9' , '0' , '30+7' , '13.4757' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16129' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16129' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '10748' , 'TU MI CHIAMI PER NOME' , '20' , '20' , '4' , '6.90' , '6.9' , '0' , '30+7' , '89.8380' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '14719' , 'TU MI AMI DAVVERO' , '10' , '10' , '4' , '6.90' , '6.9' , '0' , '30+7' , '44.9190' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 13/11/2024 10:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94223' , '10751' , 'TU MI PERDONI' , '25' , '25' , '4' , '6.90' , '6.9' , '0' , '30+7' , '112.2975' ) 13/11/2024 10:07:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 13/11/2024 10:07:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 13/11/2024 10:13:58 am >> SELECT document_num FROM ps_document WHERE document_num = '226' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 10:13:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '226' , '2024-11-13' , '' , '1155' , '0' , '4672061' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '198.48' , '198.48' , NOW() , NOW() ) 13/11/2024 10:13:58 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 = '94224' 13/11/2024 10:13:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94224' 13/11/2024 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '11191' , 'VENITE CON ME 1 PARTE' , '22' , '-22' , '4' , '2.80' , '2.8' , '0' , '15' , '52.36' ) 13/11/2024 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '15' , '20.40' ) 13/11/2024 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '38' , '-38' , '4' , '3.80' , '3.8' , '0' , '15' , '122.74' ) 13/11/2024 10:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 13/11/2024 10:15:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3453' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 10:15:15 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' , '3453' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.80' , '74.57' , NOW() , NOW() ) 13/11/2024 10:15:15 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 = '94225' 13/11/2024 10:15:15 am >> DELETE FROM ps_document_detail WHERE id_document = '94225' 13/11/2024 10:15:15 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 ( '94225' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 13/11/2024 10:15:15 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 ( '94225' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '' , '0.80' ) 13/11/2024 10:22:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3454' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 10:22:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3454' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 13/11/2024 10:22:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94226' 13/11/2024 10:22:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94226' 13/11/2024 10:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94226' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '25' , '20.491803278689' , '22' , '0' , '50.00' ) 13/11/2024 10:32:13 am >> SELECT document_num FROM ps_document WHERE document_num = '227' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 10:32:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '227' , '2024-11-13' , '' , '2823' , '0' , '4672634' , 'VIA ROMA, 1 83028 SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '143.99' , '143.99' , NOW() , NOW() ) 13/11/2024 10:32:13 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 = '94227' 13/11/2024 10:32:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94227' 13/11/2024 10:32:13 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 ( '94227' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '7' , '-7' , '4' , '3.40' , '3.4' , '0' , '15' , '20.23' ) 13/11/2024 10:32:13 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 ( '94227' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 13/11/2024 10:32:13 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 ( '94227' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '7' , '-7' , '4' , '3.80' , '3.8' , '0' , '15' , '22.61' ) 13/11/2024 10:32:14 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 ( '94227' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.80' , '3.8' , '0' , '15' , '48.45' ) 13/11/2024 10:32:14 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 ( '94227' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '15' , '-15' , '4' , '3.80' , '3.8' , '0' , '15' , '48.45' ) 13/11/2024 10:34:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3455' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 10:34:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3455' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.88' , '11.88' , NOW() , NOW() ) 13/11/2024 10:34:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94228' 13/11/2024 10:34:59 am >> DELETE FROM ps_document_detail WHERE id_document = '94228' 13/11/2024 10:34:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94228' , '23194' , 'DILEXIT NOS - 8992' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 13/11/2024 10:34:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94228' , '21892' , 'MANGIATOIA GREMBO DELLAMORE DI DIO - P. STANCARI' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 13/11/2024 10:34:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94228' , '18804' , 'NOVENA AL NATALE - 8045' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 13/11/2024 10:49:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3456' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 10:49:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3456' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '490.00' , '465.01' , NOW() , NOW() ) 13/11/2024 10:49:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94229' 13/11/2024 10:49:23 am >> DELETE FROM ps_document_detail WHERE id_document = '94229' 13/11/2024 10:49:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '22' , '-22' , '4' , '5.00' , '5' , '0' , '5' , '104.50' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '21591' , 'GESU\' VIENE AD ABITARE CON NOI - SCHEDE 1' , '18' , '-18' , '4' , '6.90' , '6.9' , '0' , '5' , '118.08' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '14' , '-14' , '4' , '6.90' , '6.9' , '0' , '5' , '91.84' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.1' , '6.1' , '0' , '0' , '6.10' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '22293' , 'RELIQUIARIO CM 25 ' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '21823' , 'DI MARIA UNA VERA IMMAGINE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 13/11/2024 10:49:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94229' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 13/11/2024 11:08:21 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1656' 13/11/2024 11:08:21 am >> 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 ( '1656' , '10' , '210' , 'PARROCCHIA S. ANTONIO DA PADOVA' , 'MARONE ' , ' DON LUIGI' , 'VIA NAZIONALE' , '' , '84060' , 'OMIGNANO SCALO' , '' , '333 3078088' , '' , '' , '93001570659' , NOW() , NOW() ) 13/11/2024 11:08:21 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1656' 13/11/2024 11:11:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3457' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 11:11:42 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' , '3457' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '265.00' , '217.21' , NOW() , NOW() ) 13/11/2024 11:11:42 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 = '94230' 13/11/2024 11:11:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94230' 13/11/2024 11:11:42 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 ( '94230' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '265' , '217.2131147541' , '22' , '0' , '265.00' ) 13/11/2024 11:22:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3458' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 11:22: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 ( '11' , '3458' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.96' , '23.96' , NOW() , NOW() ) 13/11/2024 11:22: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 = '94231' 13/11/2024 11:22:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94231' 13/11/2024 11:22: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 ( '94231' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '4' , '-4' , '4' , '3.00' , '3' , '0' , '5' , '11.40' ) 13/11/2024 11:22: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 ( '94231' , '2679' , 'CONOSCERE GESU' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 13/11/2024 11:22: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 ( '94231' , '22751' , 'BIBBIA PER IL CATECHISMO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 13/11/2024 11:28:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2907/24' , '2024-11-07' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1547.67' , '1488.14' , NOW() , NOW() ) 13/11/2024 11:28:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94232' 13/11/2024 11:28:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94232' 13/11/2024 11:28:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94232' , '7311' , 'OSTIA SOTTILE 74MM' , '200' , '200' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '223.9536' ) 13/11/2024 11:28:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 13/11/2024 11:28:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 13/11/2024 11:28:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94232' , '16689' , 'OSTIA PAN DI CENA mm80' , '200' , '200' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '242.1120' ) 13/11/2024 11:28:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 13/11/2024 11:28:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 13/11/2024 11:28:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94232' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '520' , '520' , '3' , '2' , '1.9230769230769' , '4' , '0' , '1081.6000' ) 13/11/2024 11:28:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 13/11/2024 11:28:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 13/11/2024 11:31:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259754295' AND id_product != '23197' AND ean13 != '' 13/11/2024 11:31:45 am >> UPDATE ps_product SET id_supplier = '7', reference = '13/3', ean13 = '9791259754295', date_upd = NOW() WHERE id_product = '23197' 13/11/2024 11:31:45 am >> UPDATE ps_product_lang SET name = 'AIUTAMI A PREGARE', description = '' WHERE id_product = '23197' 13/11/2024 11:31:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.0000' WHERE id_product = '23197' 13/11/2024 11:31:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23197' 13/11/2024 11:31:45 am >> DELETE FROM ps_specific_price WHERE id_product = '23197' 13/11/2024 11:44:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243897' AND id_product != '23198' AND ean13 != '' 13/11/2024 11:44:19 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892243897', date_upd = NOW() WHERE id_product = '23198' 13/11/2024 11:44:19 am >> UPDATE ps_product_lang SET name = 'CINQUE MINUTI DELLO SPIRITO SANTO - V.M. FERNANDEZ', description = '' WHERE id_product = '23198' 13/11/2024 11:44:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '23198' 13/11/2024 11:44:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23198' 13/11/2024 11:44:19 am >> DELETE FROM ps_specific_price WHERE id_product = '23198' 13/11/2024 11:44:20 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 = '23198' 13/11/2024 11:44:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23199' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:44:20 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 '23199' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23198' 13/11/2024 11:44:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23199' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23198' 13/11/2024 11:45:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871786' AND id_product != '23199' AND ean13 != '' 13/11/2024 11:45:00 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788892871786', date_upd = NOW() WHERE id_product = '23199' 13/11/2024 11:45:00 am >> UPDATE ps_product_lang SET name = 'VERBUM CARO FACTUM EST', description = '' WHERE id_product = '23199' 13/11/2024 11:45:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23199' 13/11/2024 11:45:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23199' 13/11/2024 11:45:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23199' 13/11/2024 11:45:01 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 = '23199' 13/11/2024 11:45:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23200' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:45:01 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 '23200' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23199' 13/11/2024 11:45:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23200' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23199' 13/11/2024 11:45:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871663' AND id_product != '23200' AND ean13 != '' 13/11/2024 11:45:44 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788892871663', date_upd = NOW() WHERE id_product = '23200' 13/11/2024 11:45:44 am >> UPDATE ps_product_lang SET name = 'VANGELO AL CONTRARIO ANNO C- S. RESCA', description = '' WHERE id_product = '23200' 13/11/2024 11:45:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23200' 13/11/2024 11:45:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23200' 13/11/2024 11:45:44 am >> DELETE FROM ps_specific_price WHERE id_product = '23200' 13/11/2024 11:45:45 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 = '23200' 13/11/2024 11:45:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23201' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:45:45 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 '23201' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23200' 13/11/2024 11:45:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23201' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23200' 13/11/2024 11:46:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871816' AND id_product != '23201' AND ean13 != '' 13/11/2024 11:46:16 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892871816', date_upd = NOW() WHERE id_product = '23201' 13/11/2024 11:46:16 am >> UPDATE ps_product_lang SET name = 'TI VOGLIO BENE - TONINO BELLO', description = '' WHERE id_product = '23201' 13/11/2024 11:46:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23201' 13/11/2024 11:46:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23201' 13/11/2024 11:46:16 am >> DELETE FROM ps_specific_price WHERE id_product = '23201' 13/11/2024 11:46:17 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 = '23201' 13/11/2024 11:46:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23202' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:46:17 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 '23202' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23201' 13/11/2024 11:46:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23202' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23201' 13/11/2024 11:47:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871489' AND id_product != '23202' AND ean13 != '' 13/11/2024 11:47:16 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788892871489', date_upd = NOW() WHERE id_product = '23202' 13/11/2024 11:47:16 am >> UPDATE ps_product_lang SET name = 'CHIAMATA - C. D\'ALESIO', description = '' WHERE id_product = '23202' 13/11/2024 11:47:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23202' 13/11/2024 11:47:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '245', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23202' 13/11/2024 11:47:16 am >> DELETE FROM ps_specific_price WHERE id_product = '23202' 13/11/2024 11:47:17 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 = '23202' 13/11/2024 11:47:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23203' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:47:17 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 '23203' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23202' 13/11/2024 11:47:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23203' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23202' 13/11/2024 11:48:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871793' AND id_product != '23203' AND ean13 != '' 13/11/2024 11:48:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892871793', date_upd = NOW() WHERE id_product = '23203' 13/11/2024 11:48:04 am >> UPDATE ps_product_lang SET name = 'STO ALLA PORTA E BUSSO', description = '' WHERE id_product = '23203' 13/11/2024 11:48:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '23203' 13/11/2024 11:48:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23203' 13/11/2024 11:48:04 am >> DELETE FROM ps_specific_price WHERE id_product = '23203' 13/11/2024 11:48:05 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 = '23203' 13/11/2024 11:48:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23204' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:48:05 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 '23204' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23203' 13/11/2024 11:48:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23204' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23203' 13/11/2024 11:48:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281917088' AND id_product != '23204' AND ean13 != '' 13/11/2024 11:48:57 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9791281917088', date_upd = NOW() WHERE id_product = '23204' 13/11/2024 11:48:57 am >> UPDATE ps_product_lang SET name = 'VIZIO DI SPERARE - P. PELLEGRINO', description = '' WHERE id_product = '23204' 13/11/2024 11:48:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '23204' 13/11/2024 11:48:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '483', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23204' 13/11/2024 11:48:57 am >> DELETE FROM ps_specific_price WHERE id_product = '23204' 13/11/2024 11:48:58 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 = '23204' 13/11/2024 11:48:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23205' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:48:58 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 '23205' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23204' 13/11/2024 11:48:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23205' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23204' 13/11/2024 11:49:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248664' AND id_product != '23205' AND ean13 != '' 13/11/2024 11:49:47 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788884248664', date_upd = NOW() WHERE id_product = '23205' 13/11/2024 11:49:47 am >> UPDATE ps_product_lang SET name = 'STRADE DEGLI UOMINI SENTIERI DI DIO - P. ZAGO', description = '' WHERE id_product = '23205' 13/11/2024 11:49:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23205' 13/11/2024 11:49:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23205' 13/11/2024 11:49:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23205' 13/11/2024 11:49:48 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 = '23205' 13/11/2024 11:49:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23206' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:49:48 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 '23206' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23205' 13/11/2024 11:49:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23206' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23205' 13/11/2024 11:50:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450299' AND id_product != '23206' AND ean13 != '' 13/11/2024 11:50:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256450299', date_upd = NOW() WHERE id_product = '23206' 13/11/2024 11:50:36 am >> UPDATE ps_product_lang SET name = 'GIUBILEO DELLA SPERANZA - U. TERRINONI', description = '' WHERE id_product = '23206' 13/11/2024 11:50:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23206' 13/11/2024 11:50:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23206' 13/11/2024 11:50:36 am >> DELETE FROM ps_specific_price WHERE id_product = '23206' 13/11/2024 11:50: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 = '23206' 13/11/2024 11:50:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23207' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:50: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 '23207' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23206' 13/11/2024 11:50:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23207' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23206' 13/11/2024 11:51:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882276485' AND id_product != '23207' AND ean13 != '' 13/11/2024 11:51:30 am >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788882276485', date_upd = NOW() WHERE id_product = '23207' 13/11/2024 11:51:30 am >> UPDATE ps_product_lang SET name = 'GESU\', ECO L\'UOMO - B. SESBOUE', description = '' WHERE id_product = '23207' 13/11/2024 11:51:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '23207' 13/11/2024 11:51:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '248', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23207' 13/11/2024 11:51:30 am >> DELETE FROM ps_specific_price WHERE id_product = '23207' 13/11/2024 11:51:31 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 = '23207' 13/11/2024 11:51:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23208' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:51:31 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 '23208' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23207' 13/11/2024 11:51:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23208' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23207' 13/11/2024 11:52:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788880713920' AND id_product != '23208' AND ean13 != '' 13/11/2024 11:52:18 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788880713920', date_upd = NOW() WHERE id_product = '23208' 13/11/2024 11:52:18 am >> UPDATE ps_product_lang SET name = 'SPERANZA NELLA TRADIZIONE EBRAICA - AAVV', description = '' WHERE id_product = '23208' 13/11/2024 11:52:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23208' 13/11/2024 11:52:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '52', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23208' 13/11/2024 11:52:18 am >> DELETE FROM ps_specific_price WHERE id_product = '23208' 13/11/2024 11:52:19 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 = '23208' 13/11/2024 11:52:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23209' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:52:19 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 '23209' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23208' 13/11/2024 11:52:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23209' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23208' 13/11/2024 11:53:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827012642' AND id_product != '23209' AND ean13 != '' 13/11/2024 11:53:06 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788827012642', date_upd = NOW() WHERE id_product = '23209' 13/11/2024 11:53:06 am >> UPDATE ps_product_lang SET name = 'FRANCESCO HA UN CUORE GIOVANE - G. SCARLATO', description = '' WHERE id_product = '23209' 13/11/2024 11:53:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23209' 13/11/2024 11:53:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '186', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23209' 13/11/2024 11:53:06 am >> DELETE FROM ps_specific_price WHERE id_product = '23209' 13/11/2024 11:53:11 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 = '23209' 13/11/2024 11:53:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23210' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:53:11 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 '23210' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23209' 13/11/2024 11:53:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23210' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23209' 13/11/2024 11:54:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868947231' AND id_product != '23210' AND ean13 != '' 13/11/2024 11:54:09 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788868947231', date_upd = NOW() WHERE id_product = '23210' 13/11/2024 11:54:09 am >> UPDATE ps_product_lang SET name = 'ETA\' DELLA VITA - C. M. MARTINI', description = '' WHERE id_product = '23210' 13/11/2024 11:54:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '23210' 13/11/2024 11:54:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23210' 13/11/2024 11:54:09 am >> DELETE FROM ps_specific_price WHERE id_product = '23210' 13/11/2024 11:54:10 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 = '23210' 13/11/2024 11:54:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23211' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:54:10 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 '23211' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23210' 13/11/2024 11:54:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23211' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23210' 13/11/2024 11:54:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245594' AND id_product != '23211' AND ean13 != '' 13/11/2024 11:54:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892245594', date_upd = NOW() WHERE id_product = '23211' 13/11/2024 11:54:48 am >> UPDATE ps_product_lang SET name = 'VIVERE IL GIUBILEO - E. FORTUNATO', description = '' WHERE id_product = '23211' 13/11/2024 11:54:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23211' 13/11/2024 11:54:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23211' 13/11/2024 11:54:48 am >> DELETE FROM ps_specific_price WHERE id_product = '23211' 13/11/2024 11:54:49 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 = '23211' 13/11/2024 11:54:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23212' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:54:49 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 '23212' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23211' 13/11/2024 11:54:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23212' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23211' 13/11/2024 11:55:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246768' AND id_product != '23212' AND ean13 != '' 13/11/2024 11:55:15 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788892246768', date_upd = NOW() WHERE id_product = '23212' 13/11/2024 11:55:15 am >> UPDATE ps_product_lang SET name = 'AVVENTURE DI PINOCCHIO', description = '' WHERE id_product = '23212' 13/11/2024 11:55:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '23212' 13/11/2024 11:55:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23212' 13/11/2024 11:55:15 am >> DELETE FROM ps_specific_price WHERE id_product = '23212' 13/11/2024 11:55:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246768' AND id_product != '23212' AND ean13 != '' 13/11/2024 11:55:23 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788892246768', date_upd = NOW() WHERE id_product = '23212' 13/11/2024 11:55:23 am >> UPDATE ps_product_lang SET name = 'AVVENTURE DI PINOCCHIO', description = '' WHERE id_product = '23212' 13/11/2024 11:55:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '23212' 13/11/2024 11:55:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '90', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23212' 13/11/2024 11:55:23 am >> DELETE FROM ps_specific_price WHERE id_product = '23212' 13/11/2024 11:55:25 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 = '23212' 13/11/2024 11:55:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23213' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:55:25 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 '23213' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23212' 13/11/2024 11:55:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23213' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23212' 13/11/2024 11:56:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245617' AND id_product != '23213' AND ean13 != '' 13/11/2024 11:56:00 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892245617', date_upd = NOW() WHERE id_product = '23213' 13/11/2024 11:56:00 am >> UPDATE ps_product_lang SET name = 'BEATI VOI - G. MATINO', description = '' WHERE id_product = '23213' 13/11/2024 11:56:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23213' 13/11/2024 11:56:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23213' 13/11/2024 11:56:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23213' 13/11/2024 11:56:01 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 = '23213' 13/11/2024 11:56:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23214' , '1' , '' , 'nuovo-prodotto' ) 13/11/2024 11:56:01 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 '23214' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23213' 13/11/2024 11:56:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23214' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23213' 13/11/2024 11:58:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871816' AND id_product != '23201' AND ean13 != '' 13/11/2024 11:58:18 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892871816', date_upd = NOW() WHERE id_product = '23201' 13/11/2024 11:58:18 am >> UPDATE ps_product_lang SET name = 'VI VOGLIO BENE - TONINO BELLO', description = '' WHERE id_product = '23201' 13/11/2024 11:58:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0000' WHERE id_product = '23201' 13/11/2024 11:58:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23201' 13/11/2024 11:58:18 am >> DELETE FROM ps_specific_price WHERE id_product = '23201' 13/11/2024 12:01:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '680627' , '2024-11-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.23' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.97' , '185.97' , NOW() , NOW() ) 13/11/2024 12:01:01 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 = '94233' 13/11/2024 12:01:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94233' 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23212' , 'AVVENTURE DI PINOCCHIO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35' , '10.4000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23212' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23212' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23202' , 'CHIAMATA - C. DALESIO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23202' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23202' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23205' , 'STRADE DEGLI UOMINI SENTIERI DI DIO - P. ZAGO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23205' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23205' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23206' , 'GIUBILEO DELLA SPERANZA - U. TERRINONI' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23206' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23206' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23208' , 'SPERANZA NELLA TRADIZIONE EBRAICA - AAVV' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23208' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23208' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23209' , 'FRANCESCO HA UN CUORE GIOVANE - G. SCARLATO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23209' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23209' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23201' , 'VI VOGLIO BENE - TONINO BELLO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23201' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23201' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23199' , 'VERBUM CARO FACTUM EST' , '12' , '12' , '4' , '3.00' , '3' , '0' , '30' , '25.2000' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23199' AND id_supplier = '7' 13/11/2024 12:01:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23199' , '7' , '1' ) 13/11/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23203' , 'STO ALLA PORTA E BUSSO' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '30' , '4.8300' ) 13/11/2024 12:01:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23203' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23203' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23204' , 'VIZIO DI SPERARE - P. PELLEGRINO' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '30' , '3.1500' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23204' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23204' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23200' , 'VANGELO AL CONTRARIO ANNO C- S. RESCA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23200' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23200' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23211' , 'VIVERE IL GIUBILEO - E. FORTUNATO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23211' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23211' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23198' , 'CINQUE MINUTI DELLO SPIRITO SANTO - V.M. FERNANDEZ' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23198' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23198' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23213' , 'BEATI VOI - G. MATINO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23213' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23213' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23210' , 'ETA DELLA VITA - C. M. MARTINI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '30' , '15.4000' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23210' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23210' , '7' , '1' ) 13/11/2024 12:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94233' , '23207' , 'GESU, ECO LUOMO - B. SESBOUE' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 13/11/2024 12:01:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23207' AND id_supplier = '7' 13/11/2024 12:01:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23207' , '7' , '1' ) 13/11/2024 12:19:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '121/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:19: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 ( '24' , '121/A' , '2024-11-13' , 'A' , '3821' , '0' , '4672560' , 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '461.55' , '461.55' , NOW() , NOW() ) 13/11/2024 12:19: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 = '94234' 13/11/2024 12:19:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '94234' 13/11/2024 12:19: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 ( '94234' , '10748' , 'TU MI CHIAMI PER NOME' , '26' , '-26' , '4' , '6.3' , '6.3' , '0' , '0' , '163.80' ) 13/11/2024 12:19: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 ( '94234' , '10751' , 'TU MI PERDONI' , '27' , '-27' , '4' , '6.3' , '6.3' , '0' , '0' , '170.10' ) 13/11/2024 12:19: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 ( '94234' , '14719' , 'TU MI AMI DAVVERO' , '18' , '-18' , '4' , '6.3' , '6.3' , '0' , '0' , '113.40' ) 13/11/2024 12:19: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 ( '94234' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 13/11/2024 12:21:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '122/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:21: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 ( '24' , '122/A' , '2024-11-13' , 'A' , '3821' , '0' , '4672560' , 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.16' , '76.16' , NOW() , NOW() ) 13/11/2024 12:21: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 = '94235' 13/11/2024 12:21:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94235' 13/11/2024 12:21: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 ( '94235' , '13397' , 'MIO GESU\'' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 13/11/2024 12:21: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 ( '94235' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '14' , '-14' , '4' , '3.40' , '3.4' , '0' , '15' , '40.46' ) 13/11/2024 12:24:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '226' AND id_document != '94224' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:24:01 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '226', document_date = '2024-11-13', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '4672061', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '198.48', price_tax_excluded = '198.48', date_upd = NOW() WHERE id_document = '94224' 13/11/2024 12:24:01 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 = '94224' 13/11/2024 12:24:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94224' 13/11/2024 12:24:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '11191' , 'VENITE CON ME 1 PARTE' , '22' , '-22' , '4' , '2.8000' , '2.8' , '0' , '15' , '52.36' ) 13/11/2024 12:24:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 13/11/2024 12:24:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '38' , '-38' , '4' , '3.8000' , '3.8' , '0' , '15' , '122.74' ) 13/11/2024 12:24:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94224' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 13/11/2024 12:31:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3459' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:31: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' , '3459' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 13/11/2024 12:31: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 = '94236' 13/11/2024 12:31:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '94236' 13/11/2024 12:31: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 ( '94236' , '6335' , 'MEDAGLIA OVALE DECORATA - S.LUCIA - G291-D' , '50' , '-50' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '35.00' ) 13/11/2024 12:33:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3460' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:33:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3460' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.50' , '39.67' , NOW() , NOW() ) 13/11/2024 12:33:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94237' 13/11/2024 12:33:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94237' 13/11/2024 12:33:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94237' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 13/11/2024 12:33:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94237' , '23193' , 'ACCOMPAGNARE NEL CAMMINO MATRIMONIALE ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 13/11/2024 12:33:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94237' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '100' , '0.00' ) 13/11/2024 12:33:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94237' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 13/11/2024 12:35:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3461' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:35: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' , '3461' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 13/11/2024 12:35: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 = '94238' 13/11/2024 12:35:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94238' 13/11/2024 12:35: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 ( '94238' , '23195' , 'SALE E PEPE NELLA LITURGIA - E. MASSINI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 13/11/2024 12:37:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:37:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3462' , '2024-11-13' , '' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.42' , '74.21' , NOW() , NOW() ) 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94239' 13/11/2024 12:37:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94239' 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2024 12:37:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 13/11/2024 12:41:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3462' AND id_document != '94239' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:41:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3462', document_date = '2024-11-13', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '81.42', price_tax_excluded = '74.21', date_upd = NOW() WHERE id_document = '94239' 13/11/2024 12:41:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94239' 13/11/2024 12:41:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94239' 13/11/2024 12:41:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/11/2024 12:41:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 13/11/2024 12:41: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 ( '94239' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 13/11/2024 12:41: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 ( '94239' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2024 12:41: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 ( '94239' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2024 12:41: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 ( '94239' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 13/11/2024 12:41: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 ( '94239' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/11/2024 12:42:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-642' AND id_product != '22293' AND ean13 != '' 13/11/2024 12:42:15 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-642', date_upd = NOW() WHERE id_product = '22293' 13/11/2024 12:42:15 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO CM 25 ', description = '' WHERE id_product = '22293' 13/11/2024 12:42:15 pm >> UPDATE ps_product SET wholesale_price = '52.60', on_sale = '0', price = '110.6557' WHERE id_product = '22293' 13/11/2024 12:42:15 pm >> UPDATE ps_product_shop SET wholesale_price = '52.60', price = '110.6557', id_tax_rules_group = '1', id_category_default = '394', 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 = '22293' 13/11/2024 12:42:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22293' 13/11/2024 12:43:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3457' AND id_document != '94230' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 12:43:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3457', document_date = '2024-11-13', 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 = '3', id_causal = '0', price_tax_included = '265.00', price_tax_excluded = '217.21', date_upd = NOW() WHERE id_document = '94230' 13/11/2024 12:43: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 = '94230' 13/11/2024 12:43:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94230' 13/11/2024 12:43: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 ( '94230' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '265.0000' , '217.2131147541' , '22' , '0' , '265.00' ) 13/11/2024 12:44:20 pm >> DELETE FROM ps_document WHERE id_document = '94168' 13/11/2024 12:44:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94168' 13/11/2024 12:45:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '93792' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-23') 13/11/2024 12:45:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2024-10-23', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '232.80', price_tax_excluded = '200.82', date_upd = NOW() WHERE id_document = '93792' 13/11/2024 12:45: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 = '93792' 13/11/2024 12:45:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93792' 13/11/2024 12:45: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 ( '93792' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 13/11/2024 12:45: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 ( '93792' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 13/11/2024 12:45: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 ( '93792' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 13/11/2024 12:45: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 ( '93792' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 13/11/2024 12:45: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 ( '93792' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 13/11/2024 12:45: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 ( '93792' , '2168' , 'CLERGY BASIC - ML - B&P' , '2' , '-2' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '72.00' ) 13/11/2024 12:45: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 ( '93792' , '23082' , 'CAMICE REGLAN CERNIERA DAVANTI - CA01' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 13/11/2024 12:45: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 ( '93792' , '' , 'MAGLIA' , '1' , '-1' , '0' , '30' , '30' , '' , '0' , '30.00' ) 13/11/2024 02:52:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '123/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 02:52:47 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' , '123/A' , '2024-11-13' , 'A' , '559' , '0' , '4677368' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1647.20' , '1647.20' , NOW() , NOW() ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94240' 13/11/2024 02:52:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '94240' 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '10748' , 'TU MI CHIAMI PER NOME' , '61' , '-61' , '4' , '6.3' , '6.3' , '0' , '0' , '384.30' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '69' , '-69' , '4' , '5.4' , '5.4' , '0' , '0' , '372.60' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '71' , '-71' , '4' , '5.4' , '5.4' , '0' , '0' , '383.40' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '34' , '-34' , '4' , '4.5' , '4.5' , '0' , '0' , '153.00' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '17229' , 'FELICI SUI PASSI DI GESU\' - 5 - SUSSIDIO' , '25' , '-25' , '4' , '4.5' , '4.5' , '0' , '0' , '112.50' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '142' , '-142' , '4' , '1.00' , '1' , '0' , '5' , '134.90' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '22450' , 'DIO E\' SEMPRE CON NOI' , '25' , '-25' , '4' , '1.90' , '1.9' , '0' , '5' , '45.13' ) 13/11/2024 02:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94240' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '34' , '-34' , '4' , '1.90' , '1.9' , '0' , '5' , '61.37' ) 13/11/2024 04:01:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3463' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 04:01: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 ( '11' , '3463' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.11' , '13.11' , NOW() , NOW() ) 13/11/2024 04:01: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 = '94241' 13/11/2024 04:01:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94241' 13/11/2024 04:01: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 ( '94241' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 13/11/2024 04:01: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 ( '94241' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 13/11/2024 04:01:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3464' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 04:01:37 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' , '3464' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.66' , '2.66' , NOW() , NOW() ) 13/11/2024 04:01:37 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 = '94242' 13/11/2024 04:01:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '94242' 13/11/2024 04:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94242' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 13/11/2024 04:25:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3465' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 04:25:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3465' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 13/11/2024 04:25:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94243' 13/11/2024 04:25:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94243' 13/11/2024 04:25:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94243' , '23169' , 'DILEXIT NOS ' , '50' , '-50' , '4' , '2.20' , '2.2' , '0' , '5' , '104.50' ) 13/11/2024 05:17:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 05:17:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3466' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 13/11/2024 05:17:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94244' 13/11/2024 05:17:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '94244' 13/11/2024 05:17:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94244' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 13/11/2024 06:46:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 13/11/2024 06:46: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' , '3467' , '2024-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 13/11/2024 06:46: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 = '94245' 13/11/2024 06:46:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94245' 13/11/2024 06:46: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 ( '94245' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' )