31/10/2023 08:37:14 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/10/2023 08:37:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21735' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 08:37:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21735' , '1' , '1' , '2' , NOW() , NOW() ) 31/10/2023 08:37:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21735' , '0' , '1' , '0' , '0' ) 31/10/2023 08:38:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068665' AND id_product != '21735' AND ean13 != '' 31/10/2023 08:38:13 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801068665', date_upd = NOW() WHERE id_product = '21735' 31/10/2023 08:38:13 am >> UPDATE ps_product_lang SET name = 'IMPRONTE DI MISERICORDIA - GUIDA 2', description = '' WHERE id_product = '21735' 31/10/2023 08:38:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21735' 31/10/2023 08:38:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '56', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21735' 31/10/2023 08:38:13 am >> DELETE FROM ps_specific_price WHERE id_product = '21735' 31/10/2023 08:38:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068665' AND id_product != '21735' AND ean13 != '' 31/10/2023 08:38:13 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801068665', date_upd = NOW() WHERE id_product = '21735' 31/10/2023 08:38:13 am >> UPDATE ps_product_lang SET name = 'IMPRONTE DI MISERICORDIA - GUIDA 2', description = '' WHERE id_product = '21735' 31/10/2023 08:38:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21735' 31/10/2023 08:38:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '56', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21735' 31/10/2023 08:38:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21735' 31/10/2023 08:38:16 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 = '21735' 31/10/2023 08:38:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21736' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 08:38:16 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 '21736' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21735' 31/10/2023 08:38:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21736' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21735' 31/10/2023 08:40:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983720' AND id_product != '21736' AND ean13 != '' 31/10/2023 08:40:25 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788872983720', date_upd = NOW() WHERE id_product = '21736' 31/10/2023 08:40:25 am >> UPDATE ps_product_lang SET name = 'NOVE GIORNI CON MARIA - M. GATTAFONI', description = '' WHERE id_product = '21736' 31/10/2023 08:40:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '21736' 31/10/2023 08:40:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '518', 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 = '21736' 31/10/2023 08:40:25 am >> DELETE FROM ps_specific_price WHERE id_product = '21736' 31/10/2023 08:40:27 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 = '21736' 31/10/2023 08:40:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21737' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 08:40:27 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 '21737' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21736' 31/10/2023 08:40:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21737' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21736' 31/10/2023 08:41:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253384' AND id_product != '21737' AND ean13 != '' 31/10/2023 08:41:25 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791281253384', date_upd = NOW() WHERE id_product = '21737' 31/10/2023 08:41:25 am >> UPDATE ps_product_lang SET name = 'NOVENA ALL\'IMMACOLATA - BENEDETTO XVI', description = '' WHERE id_product = '21737' 31/10/2023 08:41:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '21737' 31/10/2023 08:41:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '518', 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 = '21737' 31/10/2023 08:41:25 am >> DELETE FROM ps_specific_price WHERE id_product = '21737' 31/10/2023 08:41:26 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 = '21737' 31/10/2023 08:41:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21738' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 08:41:26 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 '21738' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21737' 31/10/2023 08:41:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21738' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21737' 31/10/2023 08:42:40 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' , '646444' , '2023-10-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.48' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.60' , '158.60' , NOW() , NOW() ) 31/10/2023 08:42:40 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 = '88637' 31/10/2023 08:42:40 am >> DELETE FROM ps_document_detail WHERE id_document = '88637' 31/10/2023 08:42:40 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 ( '88637' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 31/10/2023 08:42:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '7' 31/10/2023 08:42:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '7' , '1' ) 31/10/2023 08:42:40 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 ( '88637' , '18667' , 'SCOPRIAMO LA CRESIMA' , '14' , '14' , '4' , '4.90' , '4.9' , '0' , '30' , '48.0200' ) 31/10/2023 08:42:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '7' 31/10/2023 08:42:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '7' , '1' ) 31/10/2023 08:42:40 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 ( '88637' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '100' , '0.0000' ) 31/10/2023 08:42:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '7' 31/10/2023 08:42:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '7' , '1' ) 31/10/2023 08:42:40 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 ( '88637' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 31/10/2023 08:42:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '21436' AND id_supplier = '7' 31/10/2023 08:42:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21436' , '7' , '1' ) 31/10/2023 08:42:40 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 ( '88637' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 31/10/2023 08:42:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '21437' AND id_supplier = '7' 31/10/2023 08:42:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21437' , '7' , '1' ) 31/10/2023 08:42:40 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 ( '88637' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 31/10/2023 08:42:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '21735' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21735' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21484' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21484' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '19618' , 'CARLO ACUTIS' , '5' , '5' , '4' , '4.90' , '4.9' , '0' , '30' , '17.1500' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19618' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19618' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '12' , '12' , '4' , '2.00' , '2' , '0' , '30' , '16.8000' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21736' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21736' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21736' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21736' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '21737' , 'NOVENA ALLIMMACOLATA - BENEDETTO XVI' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '30' , '5.2500' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21737' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21737' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '893' , 'AVVENTO LECTIO BREVIS' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '30' , '6.6500' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '893' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '893' , '7' , '1' ) 31/10/2023 08:42:41 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 ( '88637' , '6894' , 'NATALE LECTIO BREVIS' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '30' , '5.9500' ) 31/10/2023 08:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '6894' AND id_supplier = '7' 31/10/2023 08:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6894' , '7' , '1' ) 31/10/2023 08:42: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 ( '88637' , '21627' , 'AVVENTO E NATALE 2023' , '5' , '5' , '4' , '2.90' , '2.9' , '0' , '33' , '9.7150' ) 31/10/2023 08:42:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21627' AND id_supplier = '7' 31/10/2023 08:42:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21627' , '7' , '1' ) 31/10/2023 08:42: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 ( '88637' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 31/10/2023 08:42:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21708' AND id_supplier = '7' 31/10/2023 08:42:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21708' , '7' , '1' ) 31/10/2023 09:07:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253131' AND id_product != '21738' AND ean13 != '' 31/10/2023 09:07:29 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9791281253131', date_upd = NOW() WHERE id_product = '21738' 31/10/2023 09:07:29 am >> UPDATE ps_product_lang SET name = 'HANNO LASCIATO UN SEGNO... E TU? - A. COMASTRI', description = '' WHERE id_product = '21738' 31/10/2023 09:07:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '21738' 31/10/2023 09:07:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21738' 31/10/2023 09:07:30 am >> DELETE FROM ps_specific_price WHERE id_product = '21738' 31/10/2023 09:07: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 = '21738' 31/10/2023 09:07:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21739' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:07: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 '21739' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21738' 31/10/2023 09:07:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21739' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21738' 31/10/2023 09:08:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870925' AND id_product != '21739' AND ean13 != '' 31/10/2023 09:08:35 am >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788892870925', date_upd = NOW() WHERE id_product = '21739' 31/10/2023 09:08:35 am >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO', description = '' WHERE id_product = '21739' 31/10/2023 09:08:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '21739' 31/10/2023 09:08:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '26', 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 = '21739' 31/10/2023 09:08:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21739' 31/10/2023 09:08:36 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 = '21739' 31/10/2023 09:08:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21740' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:08:36 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 '21740' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21739' 31/10/2023 09:08:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21740' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21739' 31/10/2023 09:09:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832047998' AND id_product != '21740' AND ean13 != '' 31/10/2023 09:09:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832047998', date_upd = NOW() WHERE id_product = '21740' 31/10/2023 09:09:36 am >> UPDATE ps_product_lang SET name = 'ILLUMINA IL CAMMINO', description = '' WHERE id_product = '21740' 31/10/2023 09:09:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.9' WHERE id_product = '21740' 31/10/2023 09:09:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.9', id_tax_rules_group = '4', id_category_default = '57', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21740' 31/10/2023 09:09:36 am >> DELETE FROM ps_specific_price WHERE id_product = '21740' 31/10/2023 09:09:37 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21740' 31/10/2023 09:09:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21741' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:09:37 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21741' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21740' 31/10/2023 09:09:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21741' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21740' 31/10/2023 09:10:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832047967' AND id_product != '21741' AND ean13 != '' 31/10/2023 09:10:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832047967', date_upd = NOW() WHERE id_product = '21741' 31/10/2023 09:10:23 am >> UPDATE ps_product_lang SET name = 'ALL\'AVVENTURA', description = '' WHERE id_product = '21741' 31/10/2023 09:10:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '21741' 31/10/2023 09:10:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '57', 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 = '21741' 31/10/2023 09:10:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21741' 31/10/2023 09:10: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 = '21741' 31/10/2023 09:10:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21742' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:10: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 '21742' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21741' 31/10/2023 09:10:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21742' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21741' 31/10/2023 09:11:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242951' AND id_product != '21742' AND ean13 != '' 31/10/2023 09:11:24 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892242951', date_upd = NOW() WHERE id_product = '21742' 31/10/2023 09:11:24 am >> UPDATE ps_product_lang SET name = 'MARIA, LA DONNA PIU\' BELLA - A. COMASTRI', description = '' WHERE id_product = '21742' 31/10/2023 09:11:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21742' 31/10/2023 09:11:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21742' 31/10/2023 09:11:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21742' 31/10/2023 09:11:26 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 = '21742' 31/10/2023 09:11:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21743' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:11:26 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 '21743' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21742' 31/10/2023 09:11:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21743' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21742' 31/10/2023 09:11:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242951' AND id_product != '21742' AND ean13 != '' 31/10/2023 09:11:37 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892242951', date_upd = NOW() WHERE id_product = '21742' 31/10/2023 09:11:37 am >> UPDATE ps_product_lang SET name = 'MARIA, LA DONNA PIU\' BELLA - A. COMASTRI', description = '' WHERE id_product = '21742' 31/10/2023 09:11:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '21742' 31/10/2023 09:11:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21742' 31/10/2023 09:11:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21742' 31/10/2023 09:12:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243095' AND id_product != '21743' AND ean13 != '' 31/10/2023 09:12:28 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788892243095', date_upd = NOW() WHERE id_product = '21743' 31/10/2023 09:12:28 am >> UPDATE ps_product_lang SET name = 'CAMMINANDO VERSO IL PRESEPE - E. FORTUNATO', description = '' WHERE id_product = '21743' 31/10/2023 09:12:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21743' 31/10/2023 09:12:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '30', 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 = '21743' 31/10/2023 09:12:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21743' 31/10/2023 09:12:29 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 = '21743' 31/10/2023 09:12:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21744' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:12:29 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 '21744' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21743' 31/10/2023 09:12:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21744' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21743' 31/10/2023 09:13:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242142' AND id_product != '21744' AND ean13 != '' 31/10/2023 09:13:17 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788892242142', date_upd = NOW() WHERE id_product = '21744' 31/10/2023 09:13:17 am >> UPDATE ps_product_lang SET name = 'GIOCA CON SAN FRANCESCO', description = '' WHERE id_product = '21744' 31/10/2023 09:13:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21744' 31/10/2023 09:13:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '30', 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 = '21744' 31/10/2023 09:13:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21744' 31/10/2023 09:13:18 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 = '21744' 31/10/2023 09:13:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21745' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:13:18 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 '21745' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21744' 31/10/2023 09:13:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21745' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21744' 31/10/2023 09:14:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932792' AND id_product != '21745' AND ean13 != '' 31/10/2023 09:14:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839932792', date_upd = NOW() WHERE id_product = '21745' 31/10/2023 09:14:08 am >> UPDATE ps_product_lang SET name = 'VENUTA DI DIO - F. KAMPHAUS', description = '' WHERE id_product = '21745' 31/10/2023 09:14:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21745' 31/10/2023 09:14:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '111', 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 = '21745' 31/10/2023 09:14:08 am >> DELETE FROM ps_specific_price WHERE id_product = '21745' 31/10/2023 09:14:09 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 = '21745' 31/10/2023 09:14:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21746' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:14:09 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 '21746' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21745' 31/10/2023 09:14:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21746' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21745' 31/10/2023 09:15:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118025111' AND id_product != '21746' AND ean13 != '' 31/10/2023 09:15:59 am >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '8019118025111', date_upd = NOW() WHERE id_product = '21746' 31/10/2023 09:15:59 am >> UPDATE ps_product_lang SET name = 'FIORE DEL CARMELO - CD', description = '' WHERE id_product = '21746' 31/10/2023 09:15:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '21746' 31/10/2023 09:15:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21746' 31/10/2023 09:15:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21746' 31/10/2023 09:16:00 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 = '21746' 31/10/2023 09:16:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21747' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:16: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 '21747' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21746' 31/10/2023 09:16:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21747' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21746' 31/10/2023 09:16:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118035905' AND id_product != '21747' AND ean13 != '' 31/10/2023 09:16:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8019118035905', date_upd = NOW() WHERE id_product = '21747' 31/10/2023 09:16:25 am >> UPDATE ps_product_lang SET name = 'FIORE DEL CARMELO - SPARTITO', description = '' WHERE id_product = '21747' 31/10/2023 09:16:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.346153846153847' WHERE id_product = '21747' 31/10/2023 09:16:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.346153846153847', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21747' 31/10/2023 09:16:25 am >> DELETE FROM ps_specific_price WHERE id_product = '21747' 31/10/2023 09:16:26 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 = '21747' 31/10/2023 09:16:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21748' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:16:26 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 '21748' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21747' 31/10/2023 09:16:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21748' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21747' 31/10/2023 09:17:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242975' AND id_product != '21748' AND ean13 != '' 31/10/2023 09:17:38 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892242975', date_upd = NOW() WHERE id_product = '21748' 31/10/2023 09:17:38 am >> UPDATE ps_product_lang SET name = 'DI PASQUA IN PASQUA - ROSINI', description = '' WHERE id_product = '21748' 31/10/2023 09:17:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21748' 31/10/2023 09:17:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', 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 = '21748' 31/10/2023 09:17:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21748' 31/10/2023 09:17:40 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 = '21748' 31/10/2023 09:17:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21749' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:17:40 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 '21749' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21748' 31/10/2023 09:17:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21749' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21748' 31/10/2023 09:18:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118025104' AND id_product != '21749' AND ean13 != '' 31/10/2023 09:18:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8019118025104', date_upd = NOW() WHERE id_product = '21749' 31/10/2023 09:18:59 am >> UPDATE ps_product_lang SET name = 'NINNA NANNA SOGNI D\'ORO - CD', description = '' WHERE id_product = '21749' 31/10/2023 09:18:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.065573770491804' WHERE id_product = '21749' 31/10/2023 09:18:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21749' 31/10/2023 09:18:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21749' 31/10/2023 09:19:00 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 = '21749' 31/10/2023 09:19:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21750' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:19:00 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 '21750' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21749' 31/10/2023 09:19:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21750' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21749' 31/10/2023 09:19:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068498' AND id_product != '21750' AND ean13 != '' 31/10/2023 09:19:44 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788801068498', date_upd = NOW() WHERE id_product = '21750' 31/10/2023 09:19:44 am >> UPDATE ps_product_lang SET name = 'SEGRETO DEL BAMBU\' - B. FERRERO', description = '' WHERE id_product = '21750' 31/10/2023 09:19:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21750' 31/10/2023 09:19:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21750' 31/10/2023 09:19:45 am >> DELETE FROM ps_specific_price WHERE id_product = '21750' 31/10/2023 09:19: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 = '21750' 31/10/2023 09:19:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21751' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:19: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 '21751' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21750' 31/10/2023 09:19:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21751' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21750' 31/10/2023 09:24:47 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' , '645930' , '2023-10-25' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.25' , '129.02' , NOW() , NOW() ) 31/10/2023 09:24:47 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 = '88638' 31/10/2023 09:24:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88638' 31/10/2023 09:24:47 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 ( '88638' , '21738' , 'HANNO LASCIATO UN SEGNO... E TU? - A. COMASTRI' , '1' , '1' , '4' , '4.00' , '4' , '0' , '30' , '2.8000' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21738' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21738' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21739' , 'PADRE NOSTRO' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '30' , '21.0000' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21739' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21739' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21739' , 'PADRE NOSTRO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '100' , '0.0000' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21739' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21739' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21740' , 'ILLUMINA IL CAMMINO' , '2' , '2' , '4' , '7.90' , '7.9' , '0' , '30' , '11.0600' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21740' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21740' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21741' , 'ALLAVVENTURA' , '5' , '5' , '4' , '3.50' , '3.5' , '0' , '30' , '12.2500' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21741' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21741' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21742' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21742' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21743' , 'CAMMINANDO VERSO IL PRESEPE - E. FORTUNATO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21743' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21743' , '7' , '1' ) 31/10/2023 09:24:47 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 ( '88638' , '21744' , 'GIOCA CON SAN FRANCESCO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 31/10/2023 09:24:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21744' AND id_supplier = '7' 31/10/2023 09:24:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21744' , '7' , '1' ) 31/10/2023 09:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21745' , 'VENUTA DI DIO - F. KAMPHAUS' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 31/10/2023 09:24:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21745' AND id_supplier = '7' 31/10/2023 09:24:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21745' , '7' , '1' ) 31/10/2023 09:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21746' , 'FIORE DEL CARMELO - CD' , '1' , '1' , '1' , '11.47' , '9.4016393442623' , '22' , '30' , '9.7954' ) 31/10/2023 09:24:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21746' AND id_supplier = '7' 31/10/2023 09:24:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21746' , '7' , '1' ) 31/10/2023 09:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21747' , 'FIORE DEL CARMELO - SPARTITO' , '1' , '1' , '3' , '16.34' , '15.711538461538' , '4' , '30' , '11.8955' ) 31/10/2023 09:24:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21747' AND id_supplier = '7' 31/10/2023 09:24:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21747' , '7' , '1' ) 31/10/2023 09:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21748' , 'DI PASQUA IN PASQUA - ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 31/10/2023 09:24:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21748' AND id_supplier = '7' 31/10/2023 09:24:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21748' , '7' , '1' ) 31/10/2023 09:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21750' , 'SEGRETO DEL BAMBU - B. FERRERO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 31/10/2023 09:24:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21750' AND id_supplier = '7' 31/10/2023 09:24:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21750' , '7' , '1' ) 31/10/2023 09:29:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 09:29:28 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' , '3399' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.89' , '32.89' , NOW() , NOW() ) 31/10/2023 09:29:28 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 = '88639' 31/10/2023 09:29:28 am >> DELETE FROM ps_document_detail WHERE id_document = '88639' 31/10/2023 09:29:28 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 ( '88639' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/10/2023 09:29:28 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 ( '88639' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 31/10/2023 09:29:28 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 ( '88639' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 31/10/2023 09:29:28 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 ( '88639' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 31/10/2023 09:29:28 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 ( '88639' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 31/10/2023 09:29:28 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 ( '88639' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 31/10/2023 09:38:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 09:38:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3400' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 31/10/2023 09:38: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 = '88640' 31/10/2023 09:38:33 am >> DELETE FROM ps_document_detail WHERE id_document = '88640' 31/10/2023 09:38: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 ( '88640' , '8248' , 'PREGATE, PREGATE, PREGATE - CART. - 8101' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 31/10/2023 09:40:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 09:40: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 ( '11' , '3401' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '380.00' , '311.48' , NOW() , NOW() ) 31/10/2023 09:40: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 = '88641' 31/10/2023 09:40:58 am >> DELETE FROM ps_document_detail WHERE id_document = '88641' 31/10/2023 09:40: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 ( '88641' , '13160' , 'CASULA MOD. CRISTOGRAMMA - CS12271' , '1' , '-1' , '1' , '380' , '311.47540983607' , '22' , '0' , '380.00' ) 31/10/2023 09:44:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253421' AND id_product != '21751' AND ean13 != '' 31/10/2023 09:44:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281253421', date_upd = NOW() WHERE id_product = '21751' 31/10/2023 09:44:16 am >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024', description = '' WHERE id_product = '21751' 31/10/2023 09:44:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '21751' 31/10/2023 09:44:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '29', 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 = '21751' 31/10/2023 09:44:16 am >> DELETE FROM ps_specific_price WHERE id_product = '21751' 31/10/2023 09:44: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 = '21751' 31/10/2023 09:44:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21752' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:44: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 '21752' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21751' 31/10/2023 09:44:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21752' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21751' 31/10/2023 09:45:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457254' AND id_product != '21752' AND ean13 != '' 31/10/2023 09:45:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457254', date_upd = NOW() WHERE id_product = '21752' 31/10/2023 09:45:08 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - GEN 2024', description = '' WHERE id_product = '21752' 31/10/2023 09:45:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '21752' 31/10/2023 09:45:08 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 = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21752' 31/10/2023 09:45:08 am >> DELETE FROM ps_specific_price WHERE id_product = '21752' 31/10/2023 09:45:08 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 = '21752' 31/10/2023 09:45:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21753' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:45:08 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 '21753' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21752' 31/10/2023 09:45:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21753' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21752' 31/10/2023 09:45:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457377' AND id_product != '21753' AND ean13 != '' 31/10/2023 09:45:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457377', date_upd = NOW() WHERE id_product = '21753' 31/10/2023 09:45:30 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - GEN 2024', description = '' WHERE id_product = '21753' 31/10/2023 09:45:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '21753' 31/10/2023 09:45:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', 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 = '21753' 31/10/2023 09:45:30 am >> DELETE FROM ps_specific_price WHERE id_product = '21753' 31/10/2023 09:45:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21753' 31/10/2023 09:45:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21754' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:45:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21754' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21753' 31/10/2023 09:45:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21754' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21753' 31/10/2023 09:47:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546692' AND id_product != '21754' AND ean13 != '' 31/10/2023 09:47:00 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9791280546692', date_upd = NOW() WHERE id_product = '21754' 31/10/2023 09:47:00 am >> UPDATE ps_product_lang SET name = 'PRESEPE PATRIMONIO DELL\'UMANITA\' - P. PELLEGRINO', description = '' WHERE id_product = '21754' 31/10/2023 09:47:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21754' 31/10/2023 09:47:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '21754' 31/10/2023 09:47:00 am >> DELETE FROM ps_specific_price WHERE id_product = '21754' 31/10/2023 09:47: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 = '21754' 31/10/2023 09:47:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21755' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:47: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 '21755' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21754' 31/10/2023 09:47:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21755' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21754' 31/10/2023 09:47:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242968' AND id_product != '21755' AND ean13 != '' 31/10/2023 09:47:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892242968', date_upd = NOW() WHERE id_product = '21755' 31/10/2023 09:47:46 am >> UPDATE ps_product_lang SET name = 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA', description = '' WHERE id_product = '21755' 31/10/2023 09:47:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '21755' 31/10/2023 09:47:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '30', 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 = '21755' 31/10/2023 09:47:46 am >> DELETE FROM ps_specific_price WHERE id_product = '21755' 31/10/2023 09:47:47 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 = '21755' 31/10/2023 09:47:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21756' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:47:47 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 '21756' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21755' 31/10/2023 09:47:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21756' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21755' 31/10/2023 09:48:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253278' AND id_product != '21756' AND ean13 != '' 31/10/2023 09:48:53 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9791281253278', date_upd = NOW() WHERE id_product = '21756' 31/10/2023 09:48:53 am >> UPDATE ps_product_lang SET name = 'PANE PER VIVERE LA FESTA - ANNNO B - U. TERRINONI', description = '' WHERE id_product = '21756' 31/10/2023 09:48:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21756' 31/10/2023 09:48:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '21756' 31/10/2023 09:48:53 am >> DELETE FROM ps_specific_price WHERE id_product = '21756' 31/10/2023 09:48:54 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 = '21756' 31/10/2023 09:48:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21757' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:48:54 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 '21757' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21756' 31/10/2023 09:48:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21757' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21756' 31/10/2023 09:49:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253278' AND id_product != '21756' AND ean13 != '' 31/10/2023 09:49:10 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9791281253278', date_upd = NOW() WHERE id_product = '21756' 31/10/2023 09:49:10 am >> UPDATE ps_product_lang SET name = 'PANE PER VIVERE LA FESTA - ANNNO B - U. TERRINONI', description = '' WHERE id_product = '21756' 31/10/2023 09:49:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21756' 31/10/2023 09:49:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '30', 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 = '21756' 31/10/2023 09:49:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21756' 31/10/2023 09:49: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 = '21756' 31/10/2023 09:49:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21758' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:49: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 '21758' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21756' 31/10/2023 09:49:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21758' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21756' 31/10/2023 09:50:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247056' AND id_product != '21757' AND ean13 != '' 31/10/2023 09:50:17 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788884247056', date_upd = NOW() WHERE id_product = '21757' 31/10/2023 09:50:17 am >> UPDATE ps_product_lang SET name = 'LECTIO DIVINA CON IL VANGELO DI MARCO', description = '' WHERE id_product = '21757' 31/10/2023 09:50:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21757' 31/10/2023 09:50:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21757' 31/10/2023 09:50:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21757' 31/10/2023 09:50:18 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 = '21757' 31/10/2023 09:50:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21759' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 09:50:18 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 '21759' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21757' 31/10/2023 09:50:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21759' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21757' 31/10/2023 09:50:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247056' AND id_product != '21757' AND ean13 != '' 31/10/2023 09:50:30 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788884247056', date_upd = NOW() WHERE id_product = '21757' 31/10/2023 09:50:30 am >> UPDATE ps_product_lang SET name = 'LECTIO DIVINA CON IL VANGELO DI MARCO', description = '' WHERE id_product = '21757' 31/10/2023 09:50:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '21757' 31/10/2023 09:50:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21757' 31/10/2023 09:50:30 am >> DELETE FROM ps_specific_price WHERE id_product = '21757' 31/10/2023 09:53:25 am >> UPDATE ps_document SET id_document_type = '33', document_num = '645930', document_date = '2023-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '7.2', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '254.96', price_tax_excluded = '251.04', date_upd = NOW() WHERE id_document = '88638' 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88638' 31/10/2023 09:53:25 am >> DELETE FROM ps_document_detail WHERE id_document = '88638' 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21738' , 'HANNO LASCIATO UN SEGNO... E TU? - A. COMASTRI' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '30' , '2.80' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21739' , 'PADRE NOSTRO' , '12' , '12' , '4' , '2.5000' , '2.5' , '0' , '30' , '21.00' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21739' , 'PADRE NOSTRO' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '100' , '0.00' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21740' , 'ILLUMINA IL CAMMINO' , '2' , '2' , '4' , '7.9000' , '7.9' , '0' , '30' , '11.06' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21741' , 'ALLAVVENTURA' , '5' , '5' , '4' , '3.5000' , '3.5' , '0' , '30' , '12.25' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '33' , '16.75' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21743' , 'CAMMINANDO VERSO IL PRESEPE - E. FORTUNATO' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 31/10/2023 09:53:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88638' , '21744' , 'GIOCA CON SAN FRANCESCO' , '1' , '1' , '4' , '9.9000' , '9.9' , '0' , '35' , '6.44' ) 31/10/2023 09:53:26 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 ( '88638' , '21745' , 'VENUTA DI DIO - F. KAMPHAUS' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.0000' ) 31/10/2023 09:53:26 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 ( '88638' , '21746' , 'FIORE DEL CARMELO - CD' , '1' , '1' , '1' , '11.4700' , '9.4016393442623' , '22' , '30' , '9.80' ) 31/10/2023 09:53:26 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 ( '88638' , '21747' , 'FIORE DEL CARMELO - SPARTITO' , '1' , '1' , '3' , '16.3400' , '15.711538461538' , '4' , '30' , '11.90' ) 31/10/2023 09:53:26 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 ( '88638' , '21748' , 'DI PASQUA IN PASQUA - ROSINI' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 31/10/2023 09:53:26 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 ( '88638' , '21750' , 'SEGRETO DEL BAMBU - B. FERRERO' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 31/10/2023 09:53:26 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 ( '88638' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '12' , '12' , '4' , '6.00' , '6' , '0' , '30' , '50.4000' ) 31/10/2023 09:53:26 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 ( '88638' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '1' , '4' , '6.00' , '6' , '0' , '100' , '0.0000' ) 31/10/2023 09:53:26 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 ( '88638' , '21752' , 'PAROLA E PREGHIERA - GEN 2024' , '4' , '4' , '4' , '2.90' , '2.9' , '0' , '33' , '7.7720' ) 31/10/2023 09:53:26 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 ( '88638' , '21753' , 'INSIEME NELLA MESSA - GEN 2024' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 31/10/2023 09:53:26 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 ( '88638' , '21754' , 'PRESEPE PATRIMONIO DELLUMANITA - P. PELLEGRINO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 31/10/2023 09:53:26 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 ( '88638' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '2' , '2' , '4' , '22.00' , '22' , '0' , '33' , '29.4800' ) 31/10/2023 09:53:26 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 ( '88638' , '21756' , 'PANE PER VIVERE LA FESTA - ANNNO B - U. TERRINONI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 31/10/2023 09:53:26 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 ( '88638' , '21757' , 'LECTIO DIVINA CON IL VANGELO DI MARCO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30' , '6.3000' ) 31/10/2023 09:53:26 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 ( '88638' , '21749' , 'NINNA NANNA SOGNI DORO - CD' , '1' , '1' , '1' , '11.06' , '9.0655737704918' , '22' , '30' , '9.4452' ) 31/10/2023 09:57:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 09:57:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3402' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/10/2023 09:57:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88642' 31/10/2023 09:57:05 am >> DELETE FROM ps_document_detail WHERE id_document = '88642' 31/10/2023 09:57:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88642' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2023 11:05:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3286' AND id_document != '88472' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-23') 31/10/2023 11:05:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3286', document_date = '2023-10-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '88472' 31/10/2023 11:05:52 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 = '88472' 31/10/2023 11:05:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88472' 31/10/2023 11:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88472' , '21712' , 'SUL CORPO - C.M. MARTINI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 31/10/2023 11:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88472' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/10/2023 11:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88472' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2023 11:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88472' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/10/2023 11:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88472' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 31/10/2023 11:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88472' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.38' , '8.38' , '0' , '0' , '8.38' ) 31/10/2023 11:24:48 am >> SELECT document_num FROM ps_document WHERE document_num = '218' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 11:24:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '218' , '2023-10-31' , '' , '4034' , '0' , '4679121' , 'P. ZZA SAN MARCO 84039 TEGGIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.70' , '86.70' , NOW() , NOW() ) 31/10/2023 11:24:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88643' 31/10/2023 11:24:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88643' 31/10/2023 11:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '4154' , 'FESTA DEL PERDONO' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '15' , '30.60' ) 31/10/2023 11:24:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '8408' , 'PRENDETE E MANGIATE' , '8' , '-8' , '4' , '3.00' , '3' , '0' , '15' , '20.40' ) 31/10/2023 11:24:49 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 ( '88643' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:24:49 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 ( '88643' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:24:49 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 ( '88643' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 31/10/2023 11:24:49 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 ( '88643' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:24:49 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 ( '88643' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:24:49 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 ( '88643' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2023 11:24:49 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 ( '88643' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2023 11:42:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 11:42:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3403' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '453.30' , '409.79' , NOW() , NOW() ) 31/10/2023 11:42: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 = '88644' 31/10/2023 11:42:36 am >> DELETE FROM ps_document_detail WHERE id_document = '88644' 31/10/2023 11:42: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 ( '88644' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 31/10/2023 11:42: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 ( '88644' , '11193' , 'VENITE CON ME CAT.' , '22' , '-22' , '4' , '5' , '5' , '0' , '0' , '110.00' ) 31/10/2023 11:42: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 ( '88644' , '19020' , 'TEOLOGIA SPIRITUALE - C.A. BERNARD' , '1' , '-1' , '4' , '50.00' , '50' , '0' , '5' , '47.50' ) 31/10/2023 11:42: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 ( '88644' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2023 11:42: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 ( '88644' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/10/2023 11:42: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 ( '88644' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 31/10/2023 11:42: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 ( '88644' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.72' , '3.72' , '0' , '0' , '3.72' ) 31/10/2023 11:42: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 ( '88644' , '20010' , 'E LO ADORARONO - S. SAVAGLIA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 31/10/2023 11:42: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 ( '88644' , '21377' , 'CASULA POLIESTERE IHS' , '4' , '-4' , '1' , '60' , '49.180327868852' , '22' , '0' , '240.00' ) 31/10/2023 11:43:40 am >> DELETE FROM ps_document WHERE id_document = '88196' 31/10/2023 11:43:41 am >> DELETE FROM ps_document_detail WHERE id_document = '88196' 31/10/2023 11:45:44 am >> SELECT document_num FROM ps_document WHERE document_num = '218' AND id_document != '88643' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 11:45:44 am >> UPDATE ps_document SET id_document_type = '21', document_num = '218', document_date = '2023-10-31', document_letter = '', id_customer = '4034', id_supplier = '', id_address = '4679121', address1 = 'P. ZZA SAN MARCO 84039 TEGGIANO', 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 = '86.70', price_tax_excluded = '86.70', date_upd = NOW() WHERE id_document = '88643' 31/10/2023 11:45:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88643' 31/10/2023 11:45:44 am >> DELETE FROM ps_document_detail WHERE id_document = '88643' 31/10/2023 11:45:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '4154' , 'FESTA DEL PERDONO' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '15' , '30.60' ) 31/10/2023 11:45:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '8408' , 'PRENDETE E MANGIATE' , '8' , '-8' , '4' , '3.0000' , '3' , '0' , '15' , '20.40' ) 31/10/2023 11:45:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:45:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 31/10/2023 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2023 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88643' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2023 11:55:30 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 ( '32' , '2023-FV001615' , '2023-10-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '29' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '2454.25' , '2454.25' , NOW() , NOW() ) 31/10/2023 11:55:30 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 = '88645' 31/10/2023 11:55:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88645' 31/10/2023 11:55:30 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 ( '88645' , '21645' , 'LAUDATE DEUM' , '180' , '0' , '4' , '1.9000' , '1.9' , '0' , '45' , '188.10' ) 31/10/2023 11:55:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21645' AND id_supplier = '79' 31/10/2023 11:55:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21645' , '79' , '1' ) 31/10/2023 11:55:30 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 ( '88645' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '5' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '65.00' ) 31/10/2023 11:55:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21656' AND id_supplier = '79' 31/10/2023 11:55:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21656' , '79' , '1' ) 31/10/2023 11:55:30 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 ( '88645' , '21655' , 'BENEDIZIONALE N. E. ' , '20' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '520.00' ) 31/10/2023 11:55:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 31/10/2023 11:55:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 31/10/2023 11:55:30 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 ( '88645' , '21645' , 'LAUDATE DEUM' , '80' , '0' , '4' , '1.9000' , '1.9' , '0' , '45' , '83.60' ) 31/10/2023 11:55:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21645' AND id_supplier = '79' 31/10/2023 11:55:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21645' , '79' , '1' ) 31/10/2023 11:55:30 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 ( '88645' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 31/10/2023 11:55:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21656' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21656' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '21684' , 'CEST LA CONFIANCE ' , '50' , '0' , '4' , '1.9000' , '1.9' , '0' , '45' , '52.25' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21684' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21684' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '32.50' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 31/10/2023 11:55:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 31/10/2023 11:55:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '16.80' ) 31/10/2023 11:55:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 31/10/2023 11:55:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '0' , '4' , '150.0000' , '150' , '0' , '35' , '97.50' ) 31/10/2023 11:55:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '5757' AND id_supplier = '79' 31/10/2023 11:55:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5757' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '5754' , 'LEZIONARI KIT CELEBRAZIONE DEI SANTI' , '1' , '0' , '4' , '250.0000' , '250' , '0' , '35' , '162.50' ) 31/10/2023 11:55:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '5754' AND id_supplier = '79' 31/10/2023 11:55:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5754' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '5444' , 'IO SONO CON VOI - CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.00' ) 31/10/2023 11:55:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 31/10/2023 11:55:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '11193' , 'VENITE CON ME CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.00' ) 31/10/2023 11:55:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 31/10/2023 11:55:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 31/10/2023 11:55: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 ( '88645' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 31/10/2023 11:55:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 31/10/2023 11:55:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 31/10/2023 12:00:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 12:00:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3404' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.69' , '15.69' , NOW() , NOW() ) 31/10/2023 12:00:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88646' 31/10/2023 12:00:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88646' 31/10/2023 12:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88646' , '11193' , 'VENITE CON ME CAT.' , '3' , '-3' , '4' , '5.50' , '5.5' , '0' , '5' , '15.69' ) 31/10/2023 12:07:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879624299' AND id_product != '21759' AND ean13 != '' 31/10/2023 12:07:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788879624299', date_upd = NOW() WHERE id_product = '21759' 31/10/2023 12:07:41 pm >> UPDATE ps_product_lang SET name = 'CINQUE PORTE DELLO SPIRITO - F.M. TEDOLDI', description = '' WHERE id_product = '21759' 31/10/2023 12:07:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '21759' 31/10/2023 12:07:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '110', 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 = '21759' 31/10/2023 12:07:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21759' 31/10/2023 12:07:42 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21759' 31/10/2023 12:07:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21760' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 12:07:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21760' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21759' 31/10/2023 12:07:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21760' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21759' 31/10/2023 12:08:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832235616' AND id_product != '21760' AND ean13 != '' 31/10/2023 12:08:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788832235616', date_upd = NOW() WHERE id_product = '21760' 31/10/2023 12:08:43 pm >> UPDATE ps_product_lang SET name = 'QUANDO L\'AMORE E\' PER SEMPRE - B. BAFFETTI', description = '' WHERE id_product = '21760' 31/10/2023 12:08:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '21760' 31/10/2023 12:08:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '472', id_argoment_default = '243', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21760' 31/10/2023 12:08:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '21760' 31/10/2023 12:08:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21760' 31/10/2023 12:08:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21761' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 12:08:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21761' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21760' 31/10/2023 12:08:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21761' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21760' 31/10/2023 12:09:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788894442403' AND id_product != '21761' AND ean13 != '' 31/10/2023 12:09:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788894442403', date_upd = NOW() WHERE id_product = '21761' 31/10/2023 12:09:52 pm >> UPDATE ps_product_lang SET name = 'VIA MATRIS - OLIVA G.', description = '' WHERE id_product = '21761' 31/10/2023 12:09:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '21761' 31/10/2023 12:09:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '427', 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 = '21761' 31/10/2023 12:09:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21761' 31/10/2023 12:09:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21761' 31/10/2023 12:09:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21762' , '1' , '' , 'nuovo-prodotto' ) 31/10/2023 12:09:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21762' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21761' 31/10/2023 12:09:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21762' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21761' 31/10/2023 12:10:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254821176' AND id_product != '21074' AND ean13 != '' 31/10/2023 12:10:41 pm >> UPDATE ps_product SET id_supplier = '107', reference = '13/7', ean13 = '9791254821176', date_upd = NOW() WHERE id_product = '21074' 31/10/2023 12:10:41 pm >> UPDATE ps_product_lang SET name = 'SACERDOZIO MINISTERO E VITA ', description = '' WHERE id_product = '21074' 31/10/2023 12:10:42 pm >> UPDATE ps_product SET wholesale_price = '19.50', on_sale = '0', price = '30.0000' WHERE id_product = '21074' 31/10/2023 12:10:42 pm >> UPDATE ps_product_shop SET wholesale_price = '19.50', price = '30.0000', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21074' 31/10/2023 12:10:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '21074' 31/10/2023 12:11:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000005897' , '2023-10-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '166.53' , '166.53' , NOW() , NOW() ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88647' 31/10/2023 12:11:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '88647' 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '21759' , 'CINQUE PORTE DELLO SPIRITO - F.M. TEDOLDI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '35' , '14.3000' ) 31/10/2023 12:11:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21759' AND id_supplier = '107' 31/10/2023 12:11:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21759' , '107' , '1' ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 31/10/2023 12:11:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 31/10/2023 12:11:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '21761' , 'VIA MATRIS - OLIVA G.' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '35' , '4.8750' ) 31/10/2023 12:11:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21761' AND id_supplier = '107' 31/10/2023 12:11:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21761' , '107' , '1' ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '3' , '3' , '4' , '15.00' , '15' , '0' , '35' , '29.2500' ) 31/10/2023 12:11:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21467' AND id_supplier = '107' 31/10/2023 12:11:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21467' , '107' , '1' ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 31/10/2023 12:11:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 31/10/2023 12:11:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 31/10/2023 12:11:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 31/10/2023 12:11:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 31/10/2023 12:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88647' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '1' , '4' , '99.00' , '99' , '0' , '35' , '64.3500' ) 31/10/2023 12:11:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20151' AND id_supplier = '107' 31/10/2023 12:11:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20151' , '107' , '1' ) 31/10/2023 12:16:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 12:16:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3405' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '49.04' , NOW() , NOW() ) 31/10/2023 12:16: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 = '88648' 31/10/2023 12:16:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '88648' 31/10/2023 12:16: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 ( '88648' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/10/2023 12:16: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 ( '88648' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 31/10/2023 12:17:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '75582' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-05') 31/10/2023 12:17:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2022-12-05', document_letter = 'A', id_customer = '1192', id_supplier = '', id_address = '1192', address1 = 'VIA ROMA 84020 RICIGLIANO', address2 = '', note = 'ACCONTO € 100,00 - € 500,00 29/3 € 50 10/07/23 + 200 € 13/09 pos - 250,00 31/10 - ', 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 = '2350.00', price_tax_excluded = '2350.00', date_upd = NOW() WHERE id_document = '75582' 31/10/2023 12:17:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75582' 31/10/2023 12:17:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '75582' 31/10/2023 12:17:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75582' , '0' , 'CASULA MARIANA' , '1' , '-1' , '0' , '2350.0000' , '2350' , '0' , '0' , '2350.00' ) 31/10/2023 12:20:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 12:20:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3406' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 31/10/2023 12:20:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88649' 31/10/2023 12:20:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '88649' 31/10/2023 12:20:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88649' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 31/10/2023 12:20:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88649' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '-2' , '1' , '10.50' , '8.6065573770492' , '22' , '0' , '21.00' ) 31/10/2023 12:23:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '116/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 12:23:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '116/A' , '2023-10-31' , 'A' , '1207' , '0' , '4672082' , 'VIA SS. SALVATORE, 2 84080 CALVANICO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '238.43' , '238.43' , NOW() , NOW() ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88650' 31/10/2023 12:23:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88650' 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.40' , '3.4' , '0' , '15' , '28.90' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '15' , '47.60' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '15' , '47.60' ) 31/10/2023 12:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88650' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '15' , '-15' , '4' , '2.40' , '2.4' , '0' , '15' , '30.60' ) 31/10/2023 12:33:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '219' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 12:33:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '219' , '2023-10-31' , '' , '3990' , '0' , '4677725' , 'VIA DE AMICIS 38 21050 CAIRATE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '79.80' , '79.80' , NOW() , NOW() ) 31/10/2023 12:33:30 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 = '88651' 31/10/2023 12:33:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '88651' 31/10/2023 12:33:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88651' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 31/10/2023 12:33:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88651' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/10/2023 12:33:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88651' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/10/2023 12:33:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88651' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/10/2023 12:33:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88651' , '14487' , 'PREGHIERA DELLE 5 DITA' , '10' , '-10' , '4' , '1.80' , '1.8' , '0' , '5' , '17.10' ) 31/10/2023 12:53:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 12:53:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3407' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '271.00' , '222.13' , NOW() , NOW() ) 31/10/2023 12:53:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88652' 31/10/2023 12:53:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '88652' 31/10/2023 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88652' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '10' , '-10' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '40.00' ) 31/10/2023 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88652' , '922' , 'BALZA RICAMATA CM 9,6 - VERDE - KOM/030 - OGGETTI' , '3' , '-3' , '1' , '20' , '16.393442622951' , '22' , '0' , '60.00' ) 31/10/2023 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88652' , '20466' , 'PIZZO MACRAME CM 10 - P529' , '5.7' , '-5.7' , '1' , '30' , '24.590163934426' , '22' , '0' , '171.00' ) 31/10/2023 03:01:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 03:01:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3408' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 31/10/2023 03:01:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88653' 31/10/2023 03:01:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '88653' 31/10/2023 03:01:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88653' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 31/10/2023 03:21:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '65' 31/10/2023 03:21:53 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '65' , '10' , '145' , '' , 'D\'ERRICO ' , 'GIUSEPPE' , 'VIA SAN MARCO, 1' , '' , '81016' , 'CASTELLO DEL MATESE' , '' , '3891029585' , '' , '' , '' , NOW() , NOW() ) 31/10/2023 03:21:53 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '65' 31/10/2023 03:25:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '220' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 03:25:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '220' , '2023-10-31' , '' , '65' , '0' , '4679171' , 'VIA SAN MARCO, 1 81016 CASTELLO DEL MATESE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '67.03' , '67.03' , NOW() , NOW() ) 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88654' 31/10/2023 03:25:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88654' 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88654' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88654' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88654' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88654' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88654' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 31/10/2023 03:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88654' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 31/10/2023 03:31:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '51/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-02') 31/10/2023 03:31:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '51/E' , '2023-11-02' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1827.14' , '1827.14' , NOW() , NOW() ) 31/10/2023 03:31:15 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 = '88655' 31/10/2023 03:31:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '88655' 31/10/2023 03:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88655' , '2679' , 'CONOSCERE GESU\'' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '38' , '108.50' ) 31/10/2023 03:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88655' , '5457' , 'IO SONO CON VOI 1 PARTE' , '350' , '-350' , '4' , '2.80' , '2.8' , '0' , '38' , '607.60' ) 31/10/2023 03:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88655' , '5458' , 'IO SONO CON VOI 2 PARTE' , '360' , '-360' , '4' , '2.80' , '2.8' , '0' , '38' , '624.96' ) 31/10/2023 03:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88655' , '11191' , 'VENITE CON ME 1 PARTE' , '280' , '-280' , '4' , '2.80' , '2.8' , '0' , '38' , '486.08' ) 31/10/2023 03:40:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 03:40:21 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' , '3409' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 31/10/2023 03:40:21 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 = '88656' 31/10/2023 03:40:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '88656' 31/10/2023 03:40:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88656' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 31/10/2023 03:45: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 ( '31' , '985/2023' , '2023-10-26' , '2023' , '0' , '23' , '2618' , 'V.LE ISONZO, 52 20135 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '340.84' , '279.38' , NOW() , NOW() ) 31/10/2023 03:45: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 = '88657' 31/10/2023 03:45:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '88657' 31/10/2023 03:45: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 ( '88657' , '17617' , 'IMMAGINI ISONZO X 100' , '130' , '130' , '1' , '2.25' , '1.844262295082' , '22' , '25' , '267.6375' ) 31/10/2023 03:45:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '23' 31/10/2023 03:45:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '23' , '1' ) 31/10/2023 03:45: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 ( '88657' , '19222' , 'CROCE 9X13' , '50' , '50' , '1' , '1.6' , '1.3114754098361' , '22' , '25' , '73.2000' ) 31/10/2023 03:45:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19222' AND id_supplier = '23' 31/10/2023 03:45:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19222' , '23' , '1' ) 31/10/2023 04:12:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '46' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 04:12:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '46' , '2023-10-31' , '' , '3821' , '0' , '4672560' , 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.37' , '143.37' , NOW() , NOW() ) 31/10/2023 04:12:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88658' 31/10/2023 04:12:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '88658' 31/10/2023 04:12:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88658' , '10751' , 'TU MI PERDONI' , '12' , '-12' , '4' , '5.90' , '5.9' , '0' , '10' , '63.72' ) 31/10/2023 04:12:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88658' , '14719' , 'TU MI AMI DAVVERO' , '15' , '-15' , '4' , '5.90' , '5.9' , '0' , '10' , '79.65' ) 31/10/2023 04:33:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '221' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 04:33:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '221' , '2023-10-31' , '' , '346' , '0' , '4674403' , 'P.ZZETTA S. NICOLA DI BARI 83010 CAPRIGLIA IRPINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.04' , '79.04' , NOW() , NOW() ) 31/10/2023 04:33:31 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 = '88659' 31/10/2023 04:33:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '88659' 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '13' , '-13' , '4' , '3.40' , '3.4' , '0' , '15' , '37.57' ) 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 31/10/2023 04:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '10' , '4.50' ) 31/10/2023 05:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:08:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '117/A' , '2023-10-31' , 'A' , '31' , '0' , '4670717' , 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.40' , '129.84' , NOW() , NOW() ) 31/10/2023 05:08:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88660' 31/10/2023 05:08:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '88660' 31/10/2023 05:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88660' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '72.00' ) 31/10/2023 05:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88660' , '12817' , 'LIBRO DEI MATRIMONI' , '3' , '-3' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '72.00' ) 31/10/2023 05:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88660' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '40' , '14.40' ) 31/10/2023 05:18:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:18:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3410' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 31/10/2023 05:18: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 = '88661' 31/10/2023 05:18:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '88661' 31/10/2023 05:18: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 ( '88661' , '20005' , 'GESU BAMBINO CON AUREOLA CM 20 - BJ148-20' , '3' , '-3' , '1' , '20' , '16.393442622951' , '22' , '0' , '60.00' ) 31/10/2023 05:22:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:22:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3411' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 31/10/2023 05:22:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88662' 31/10/2023 05:22:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '88662' 31/10/2023 05:22:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88662' , '7647' , 'PAROLE DI GESÙ MISERICORDIOSO - SUOR FAUSTINA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 31/10/2023 05:22:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88662' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 31/10/2023 05:24:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:24:25 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' , '3412' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 31/10/2023 05:24:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88663' 31/10/2023 05:24:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '88663' 31/10/2023 05:24:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88663' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2023010002108' , '2023-10-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.56' , '280.56' , NOW() , NOW() ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88664' 31/10/2023 05:30:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '88664' 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21672' , 'sono venuto perche abbiano la vita - m. bergamasco' , '3' , '0' , '4' , '6.0000' , '6' , '0' , '35' , '11.70' ) 31/10/2023 05:30:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21672' AND id_supplier = '107' 31/10/2023 05:30:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21672' , '107' , '1' ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '20395' , 'SANTA FAMIGLIA ' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 31/10/2023 05:30:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20395' AND id_supplier = '107' 31/10/2023 05:30:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20395' , '107' , '1' ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '5868' , 'LINEAMENTI DI PATROLOGIA - L. DATTRINO' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35' , '14.30' ) 31/10/2023 05:30:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5868' AND id_supplier = '107' 31/10/2023 05:30:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5868' , '107' , '1' ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 31/10/2023 05:30:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '107' 31/10/2023 05:30:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '107' , '1' ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 31/10/2023 05:30:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 31/10/2023 05:30:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 31/10/2023 05:30:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21673' , 'PARTECIPARE LA BIBBIA - AAVV' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21673' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21673' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '26' , '0' , '4' , '1.2000' , '1.2' , '0' , '35' , '20.28' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21621' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21621' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21759' , 'CINQUE PORTE DELLO SPIRITO - F.M. TEDOLDI' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35' , '14.30' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21759' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21759' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '5.85' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21761' , 'VIA MATRIS - OLIVA G.' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '35' , '4.88' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21761' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21761' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '3' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '29.25' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21467' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21467' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '30' , '22.40' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 31/10/2023 05:30:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88664' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '0' , '4' , '99.0000' , '99' , '0' , '35' , '64.35' ) 31/10/2023 05:30:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20151' AND id_supplier = '107' 31/10/2023 05:30:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20151' , '107' , '1' ) 31/10/2023 05:31:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3302' AND id_document != '88495' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-24') 31/10/2023 05:31:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3302', document_date = '2023-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '309.95', price_tax_excluded = '260.72', date_upd = NOW() WHERE id_document = '88495' 31/10/2023 05:31: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 = '88495' 31/10/2023 05:31:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '88495' 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '21698' , 'FASCIA PER TALARE - 88/0384490XL' , '1' , '-1' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '270.00' ) 31/10/2023 05:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88495' , '21715' , 'CARLO ACUTIS 15 ANNI DI AMORE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 31/10/2023 05:46:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:46: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' , '3413' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/10/2023 05:46: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 = '88665' 31/10/2023 05:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '88665' 31/10/2023 05:46: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 ( '88665' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2023 05:53:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:53:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3414' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 31/10/2023 05:53:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88666' 31/10/2023 05:53:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '88666' 31/10/2023 05:53:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88666' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '20' , '-20' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '12.00' ) 31/10/2023 05:56:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:56:21 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' , '3415' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 31/10/2023 05:56:21 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 = '88667' 31/10/2023 05:56:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '88667' 31/10/2023 05:56:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88667' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 31/10/2023 05:58:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 05:58:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3416' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '9.62' , NOW() , NOW() ) 31/10/2023 05:58:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88668' 31/10/2023 05:58:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '88668' 31/10/2023 05:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88668' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 31/10/2023 06:18:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3417' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 06:18:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3417' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.48' , '60.51' , NOW() , NOW() ) 31/10/2023 06:18:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88669' 31/10/2023 06:18:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88669' 31/10/2023 06:18:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88669' , '14687' , 'CROCE DELL\'AMICIZIA IN ULIVO CM 18 - 2842' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 31/10/2023 06:18:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88669' , '15283' , 'DIARIO DELLA FELICITA ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 31/10/2023 06:18:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88669' , '14259' , 'ARCA DI NOE - GIOCO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 31/10/2023 06:18:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88669' , '17953' , 'GIOCHIAMO CON LA BIBBIA - 4/7 ANNI' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 31/10/2023 06:18:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88669' , '17954' , 'GIOCHIAMO CON LA BIBBIA - 7+' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 31/10/2023 06:33:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 06:33:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3418' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 31/10/2023 06:33:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88670' 31/10/2023 06:33:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '88670' 31/10/2023 06:33:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88670' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/10/2023 06:33:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88670' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/10/2023 06:55:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '87540' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 31/10/2023 06:55:04 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '131', document_date = '2023-10-03', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', 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 = '150.28', price_tax_excluded = '150.28', date_upd = NOW() WHERE id_document = '87540' 31/10/2023 06:55:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87540' 31/10/2023 06:55:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87540' 31/10/2023 06:55:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 31/10/2023 06:55:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.5000' , '3.5' , '0' , '15' , '68.42' ) 31/10/2023 06:55:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 31/10/2023 06:55:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 31/10/2023 06:56:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '138' AND id_document != '87646' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-09') 31/10/2023 06:56:51 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '138', document_date = '2023-10-09', document_letter = '', id_customer = '2881', id_supplier = '', id_address = '2487808', address1 = 'VIA MASON 20 33080 SAN QUIRINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '78.38', price_tax_excluded = '78.38', date_upd = NOW() WHERE id_document = '87646' 31/10/2023 06:56:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87646' 31/10/2023 06:56:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '87646' 31/10/2023 06:56:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87646' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/10/2023 06:56:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87646' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 31/10/2023 06:56:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87646' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '5' , '57.00' ) 31/10/2023 06:56:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87646' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '3' , '-3' , '4' , '2.85' , '2.85' , '0' , '0' , '8.55' ) 31/10/2023 06:57:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '142' AND id_document != '88168' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-09') 31/10/2023 06:57:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '142', document_date = '2023-10-09', document_letter = '', id_customer = '3838', id_supplier = '', id_address = '4674892', address1 = 'VIA MONS. MENEGAZZI 3 44022 COMACCHIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '159.55', price_tax_excluded = '159.55', date_upd = NOW() WHERE id_document = '88168' 31/10/2023 06:57:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88168' 31/10/2023 06:57:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88168' 31/10/2023 06:57:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88168' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 31/10/2023 06:57:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88168' , '4154' , 'FESTA DEL PERDONO' , '26' , '-26' , '4' , '3.0000' , '3' , '0' , '15' , '66.30' ) 31/10/2023 06:57:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88168' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 31/10/2023 06:59:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '149' AND id_document != '88207' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-10') 31/10/2023 06:59:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '149', document_date = '2023-10-10', document_letter = '', id_customer = '3455', id_supplier = '', id_address = '4672079', address1 = 'C. DA SANTA DOMENICA, SNC 84031 AULETTA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '101.59', price_tax_excluded = '101.59', date_upd = NOW() WHERE id_document = '88207' 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88207' 31/10/2023 06:59:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88207' 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '8408' , 'PRENDETE E MANGIATE' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '5' , '37.05' ) 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '13' , '-13' , '4' , '1.9000' , '1.9' , '0' , '5' , '23.46' ) 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 31/10/2023 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 31/10/2023 07:01:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '88292' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-14') 31/10/2023 07:01:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '155', document_date = '2023-10-14', document_letter = '', id_customer = '2878', id_supplier = '', id_address = '4672788', address1 = 'VIA FERROVIA VALLE, 20 84085 COSTA - 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 = '195.33', price_tax_excluded = '195.33', date_upd = NOW() WHERE id_document = '88292' 31/10/2023 07:01:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88292' 31/10/2023 07:01:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '88292' 31/10/2023 07:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '13397' , 'MIO GESU\'' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 31/10/2023 07:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '17' , '-17' , '4' , '3.4000' , '3.4' , '0' , '15' , '49.13' ) 31/10/2023 07:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '18' , '-18' , '4' , '3.5000' , '3.5' , '0' , '15' , '53.55' ) 31/10/2023 07:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 31/10/2023 07:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 31/10/2023 07:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88292' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.55' , '2.55' , '0' , '0' , '5.10' ) 31/10/2023 07:01:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '88293' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-14') 31/10/2023 07:01:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '156', document_date = '2023-10-14', document_letter = '', id_customer = '132', id_supplier = '', id_address = '4672790', address1 = 'L. GO S. MICHELE 84085 ACQUAROLA - 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 = '142.64', price_tax_excluded = '142.64', date_upd = NOW() WHERE id_document = '88293' 31/10/2023 07:01: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 = '88293' 31/10/2023 07:01:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88293' 31/10/2023 07:01: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 ( '88293' , '13397' , 'MIO GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 07:01: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 ( '88293' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '7' , '-7' , '4' , '3.4000' , '3.4' , '0' , '15' , '20.23' ) 31/10/2023 07:01: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 ( '88293' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:01: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 ( '88293' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '15' , '26.78' ) 31/10/2023 07:01: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 ( '88293' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '15' , '26.78' ) 31/10/2023 07:01: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 ( '88293' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 07:01: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 ( '88293' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.55' , '2.55' , '0' , '0' , '5.10' ) 31/10/2023 07:02:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '88301' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-14') 31/10/2023 07:02:12 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '157', document_date = '2023-10-14', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4670958', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', 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 = '113.78', price_tax_excluded = '113.78', date_upd = NOW() WHERE id_document = '88301' 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88301' 31/10/2023 07:02:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '88301' 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88301' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88301' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88301' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88301' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.8000' , '2.8' , '0' , '15' , '35.70' ) 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88301' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 31/10/2023 07:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88301' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 31/10/2023 07:03:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '161' AND id_document != '88315' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 31/10/2023 07:03:56 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '161', document_date = '2023-10-16', document_letter = '', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'da pagare', 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 = '354.46', price_tax_excluded = '354.46', date_upd = NOW() WHERE id_document = '88315' 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88315' 31/10/2023 07:03:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '88315' 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88315' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88315' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88315' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '37' , '-37' , '4' , '3.5000' , '3.5' , '0' , '15' , '110.08' ) 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88315' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88315' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 31/10/2023 07:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88315' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 31/10/2023 07:04:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 07:04:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3419' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/10/2023 07:04:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88671' 31/10/2023 07:04:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '88671' 31/10/2023 07:04:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88671' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2023 07:07:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '164' AND id_document != '88322' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 31/10/2023 07:07:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '164', document_date = '2023-10-16', document_letter = '', id_customer = '364', id_supplier = '', id_address = '4674529', address1 = 'VIA LAGO LACENO 84098 PONTECAGNANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '297.65', price_tax_excluded = '297.65', date_upd = NOW() WHERE id_document = '88322' 31/10/2023 07:07:26 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 = '88322' 31/10/2023 07:07:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '88322' 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '5458' , 'IO SONO CON VOI 2 PARTE' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '11191' , 'VENITE CON ME 1 PARTE' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 31/10/2023 07:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '4120' , 'FEDE NELLO ZAINETTO' , '5' , '-5' , '4' , '6.0000' , '6' , '0' , '15' , '25.50' ) 31/10/2023 07:07:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 31/10/2023 07:15:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '182' AND id_document != '88441' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-20') 31/10/2023 07:15:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '182', document_date = '2023-10-20', document_letter = '', id_customer = '1175', id_supplier = '', id_address = '4672789', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '207.40', price_tax_excluded = '207.40', date_upd = NOW() WHERE id_document = '88441' 31/10/2023 07:15:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88441' 31/10/2023 07:15:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '88441' 31/10/2023 07:15:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.4000' , '3.4' , '0' , '15' , '28.90' ) 31/10/2023 07:15:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:15:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 07:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 31/10/2023 07:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 07:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 31/10/2023 07:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2023 07:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 31/10/2023 07:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88441' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '4.25' , '4.25' , '0' , '0' , '8.50' ) 31/10/2023 07:20:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '88524' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-25') 31/10/2023 07:20:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '192', document_date = '2023-10-25', document_letter = '', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '45.05', price_tax_excluded = '45.05', date_upd = NOW() WHERE id_document = '88524' 31/10/2023 07:20: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 = '88524' 31/10/2023 07:20:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88524' 31/10/2023 07:20: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 ( '88524' , '4154' , 'FESTA DEL PERDONO' , '16' , '-16' , '4' , '3.0000' , '3' , '0' , '15' , '40.80' ) 31/10/2023 07:20: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 ( '88524' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:23:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '198' AND id_document != '88540' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-25') 31/10/2023 07:23:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '198', document_date = '2023-10-25', document_letter = '', id_customer = '3152', id_supplier = '', id_address = '4670974', address1 = 'L.GO GARIBALDI, 5 64034 CASTIGLIONE MESSER RAIMONDO', 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 = '594.53', price_tax_excluded = '594.53', date_upd = NOW() WHERE id_document = '88540' 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88540' 31/10/2023 07:23:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '88540' 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '4154' , 'FESTA DEL PERDONO' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '2448' , 'COLUI IN CUI CREDO' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '3443' , 'DIECI PAROLE D\'AMORE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '20' , '-20' , '4' , '6.0000' , '6' , '0' , '15' , '102.00' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '20' , '-20' , '4' , '6.0000' , '6' , '0' , '15' , '102.00' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '5251' , 'INCONTRI EUCARISTICI' , '5' , '-5' , '4' , '4.5000' , '4.5' , '0' , '15' , '19.13' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '3' , '-3' , '4' , '13.0000' , '13' , '0' , '10' , '35.10' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '20' , '-20' , '4' , '2.1000' , '2.1' , '0' , '15' , '35.70' ) 31/10/2023 07:23:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88540' , '9996' , 'SIGNORE, TI PREGO' , '4' , '-4' , '4' , '4' , '4' , '0' , '0' , '16.00' ) 31/10/2023 07:25:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '206' AND id_document != '88602' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 31/10/2023 07:25:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '206', document_date = '2023-10-28', document_letter = '', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '197.50', price_tax_excluded = '197.50', date_upd = NOW() WHERE id_document = '88602' 31/10/2023 07:25:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88602' 31/10/2023 07:25:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '88602' 31/10/2023 07:25:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '60' , '-60' , '4' , '3.5000' , '3.5' , '0' , '15' , '178.50' ) 31/10/2023 07:25:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 31/10/2023 07:25:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 31/10/2023 07:25:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '118/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 07:25: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 ( '24' , '118/A' , '2023-10-31' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA BATTIPAGLIA' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 31/10/2023 07:25: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 = '88672' 31/10/2023 07:25:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '88672' 31/10/2023 07:25: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 ( '88672' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 31/10/2023 07:25: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 ( '88672' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1148' , '22' , '0' , '3.80' ) 31/10/2023 07:25: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 ( '88672' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3654' , '4' , '0' , '10.50' ) 31/10/2023 07:25: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 ( '88672' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 31/10/2023 07:26:17 pm >> DELETE FROM ps_document WHERE id_document = '88593' 31/10/2023 07:26:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '88593' 31/10/2023 07:27:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '88603' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 31/10/2023 07:27:20 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '207', document_date = '2023-10-28', document_letter = '', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '261.25', price_tax_excluded = '261.25', date_upd = NOW() WHERE id_document = '88603' 31/10/2023 07:27:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88603' 31/10/2023 07:27:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '88603' 31/10/2023 07:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88603' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 31/10/2023 07:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88603' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 31/10/2023 07:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88603' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '50' , '-50' , '4' , '3.4000' , '3.4' , '0' , '15' , '144.50' ) 31/10/2023 07:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88603' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 31/10/2023 07:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88603' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 31/10/2023 07:29:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '221' AND id_document != '88659' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 07:29:52 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '221', document_date = '2023-10-31', document_letter = '', id_customer = '346', id_supplier = '', id_address = '4674403', address1 = 'P.ZZETTA S. NICOLA DI BARI 83010 CAPRIGLIA IRPINA', 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 = '79.04', price_tax_excluded = '79.04', date_upd = NOW() WHERE id_document = '88659' 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88659' 31/10/2023 07:29:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '88659' 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '13' , '-13' , '4' , '3.4000' , '3.4' , '0' , '15' , '37.57' ) 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2023 07:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88659' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '10' , '4.50' ) 31/10/2023 07:55:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 31/10/2023 07:55:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3420' , '2023-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '8.40' , NOW() , NOW() ) 31/10/2023 07:55:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88673' 31/10/2023 07:55:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '88673' 31/10/2023 07:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88673' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '12' , '-12' , '4' , '0.70' , '0.7' , '0' , '0' , '8.40' )