01/10/2024 09:07:20 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/10/2024 09:07:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22975' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:07:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22975' , '1' , '1' , '2' , NOW() , NOW() ) 01/10/2024 09:07:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22975' , '0' , '1' , '0' , '0' ) 01/10/2024 09:08:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244115' AND id_product != '22975' AND ean13 != '' 01/10/2024 09:08:17 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892244115', date_upd = NOW() WHERE id_product = '22975' 01/10/2024 09:08:17 am >> UPDATE ps_product_lang SET name = 'VERGINITA\' DELLA MADRE DI GESU\' - S.M. PERRELLA', description = '' WHERE id_product = '22975' 01/10/2024 09:08:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '55' WHERE id_product = '22975' 01/10/2024 09:08:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '55', 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 = '22975' 01/10/2024 09:08:17 am >> DELETE FROM ps_specific_price WHERE id_product = '22975' 01/10/2024 09:08:19 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22975' 01/10/2024 09:08:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22976' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:08:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22976' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22975' 01/10/2024 09:08:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22976' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22975' 01/10/2024 09:09:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228627' AND id_product != '22976' AND ean13 != '' 01/10/2024 09:09:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892228627', date_upd = NOW() WHERE id_product = '22976' 01/10/2024 09:09:05 am >> UPDATE ps_product_lang SET name = 'MARIA STELLA DELLA SPERANZA - BENEDETTO XVI', description = '' WHERE id_product = '22976' 01/10/2024 09:09:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '22976' 01/10/2024 09:09:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22976' 01/10/2024 09:09:05 am >> DELETE FROM ps_specific_price WHERE id_product = '22976' 01/10/2024 09:09:07 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22976' 01/10/2024 09:09:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22977' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:09:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22977' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22976' 01/10/2024 09:09:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22977' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22976' 01/10/2024 09:09:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557191' AND id_product != '22977' AND ean13 != '' 01/10/2024 09:09:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831557191', date_upd = NOW() WHERE id_product = '22977' 01/10/2024 09:09:50 am >> UPDATE ps_product_lang SET name = 'VANGELO SECONDO LUCA - L. BRUNI', description = '' WHERE id_product = '22977' 01/10/2024 09:09:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '22977' 01/10/2024 09:09:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22977' 01/10/2024 09:09:50 am >> DELETE FROM ps_specific_price WHERE id_product = '22977' 01/10/2024 09:09:51 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22977' 01/10/2024 09:09:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22978' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:09:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22978' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22977' 01/10/2024 09:09:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22978' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22977' 01/10/2024 09:10:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928085' AND id_product != '22978' AND ean13 != '' 01/10/2024 09:10:51 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839928085', date_upd = NOW() WHERE id_product = '22978' 01/10/2024 09:10:51 am >> UPDATE ps_product_lang SET name = 'MISTERO PASQUALE E LITURGIA DELLE ORE - A.J. LAMBERT', description = '' WHERE id_product = '22978' 01/10/2024 09:10:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22978' 01/10/2024 09:10:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '111', 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 = '22978' 01/10/2024 09:10:51 am >> DELETE FROM ps_specific_price WHERE id_product = '22978' 01/10/2024 09:10:52 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 = '22978' 01/10/2024 09:10:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22979' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:10:52 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 '22979' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22978' 01/10/2024 09:10:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22979' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22978' 01/10/2024 09:12:53 am >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 09:12:53 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' , '132' , '2024-10-01' , '' , '84' , '0' , '4679076' , 'VIA MANFREDI 30 29122 PIACENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '214.20' , '214.20' , NOW() , NOW() ) 01/10/2024 09:12:53 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 = '93365' 01/10/2024 09:12:53 am >> DELETE FROM ps_document_detail WHERE id_document = '93365' 01/10/2024 09:12:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93365' , '5457' , 'IO SONO CON VOI 1 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 01/10/2024 09:12:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93365' , '11191' , 'VENITE CON ME 1 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 01/10/2024 09:12:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93365' , '11192' , 'VENITE CON ME 2 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 01/10/2024 09:13:32 am >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '93365' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 09:13:32 am >> UPDATE ps_document SET id_document_type = '21', document_num = '132', document_date = '2024-10-01', document_letter = '', id_customer = '84', id_supplier = '', id_address = '4679076', address1 = 'VIA MANFREDI 30 29122 PIACENZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '214.20', price_tax_excluded = '214.20', date_upd = NOW() WHERE id_document = '93365' 01/10/2024 09:13:32 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 = '93365' 01/10/2024 09:13:32 am >> DELETE FROM ps_document_detail WHERE id_document = '93365' 01/10/2024 09:13: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 ( '93365' , '5457' , 'IO SONO CON VOI 1 PARTE' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 01/10/2024 09:13: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 ( '93365' , '11191' , 'VENITE CON ME 1 PARTE' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 01/10/2024 09:13: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 ( '93365' , '11192' , 'VENITE CON ME 2 PARTE' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 01/10/2024 09:16:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '84' 01/10/2024 09:16:33 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '84' , '10' , '196' , 'PARROCCHIA SS. TRINITA\'' , 'UFFICIO CATECHISTICO ' , '' , 'VIA MANFREDI 30' , '' , '29122' , 'PIACENZA' , 'Ordina \r\nore 9,00/12,00 - 15,00/18,00' , '0523/458204' , '3386496632 vittoria' , '' , '91016370339' , NOW() , NOW() ) 01/10/2024 09:16:33 am >> UPDATE ps_customer SET email = 'parrocchia@sstrinita.org', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '84' 01/10/2024 09:16:39 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '84' 01/10/2024 09:16:39 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '84' , '10' , '196' , 'PARROCCHIA SS. TRINITA\'' , 'UFFICIO CATECHISTICO ' , '' , 'VIA MANFREDI 30' , '' , '29122' , 'PIACENZA' , 'Ordina \r\nore 9,00/12,00 - 15,00/18,00' , '0523/458204' , '' , '' , '91016370339' , NOW() , NOW() ) 01/10/2024 09:16:39 am >> UPDATE ps_customer SET email = 'parrocchia@sstrinita.org', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '84' 01/10/2024 09:17:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572465' AND id_product != '22979' AND ean13 != '' 01/10/2024 09:17:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788867572465', date_upd = NOW() WHERE id_product = '22979' 01/10/2024 09:17:36 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME IL GIUBILEO', description = '' WHERE id_product = '22979' 01/10/2024 09:17:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '22979' 01/10/2024 09:17:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '22979' 01/10/2024 09:17:36 am >> DELETE FROM ps_specific_price WHERE id_product = '22979' 01/10/2024 09:17: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 = '22979' 01/10/2024 09:17:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22980' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:17: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 '22980' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22979' 01/10/2024 09:17:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22980' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22979' 01/10/2024 09:30:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 09:30:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2855' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '53.39' , NOW() , NOW() ) 01/10/2024 09:30:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93366' 01/10/2024 09:30:29 am >> DELETE FROM ps_document_detail WHERE id_document = '93366' 01/10/2024 09:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93366' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/10/2024 09:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93366' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 01/10/2024 09:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93366' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/10/2024 09:34:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 09:34:12 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' , '2856' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 01/10/2024 09:34:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93367' 01/10/2024 09:34:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93367' 01/10/2024 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93367' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 01/10/2024 09:36:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 09:36:34 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' , '2857' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 01/10/2024 09:36:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93368' 01/10/2024 09:36:34 am >> DELETE FROM ps_document_detail WHERE id_document = '93368' 01/10/2024 09:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93368' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 01/10/2024 09:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93368' , '16461' , 'CLERGY NIDO D\'APE ML - C22' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 01/10/2024 09:39:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069082' AND id_product != '22980' AND ean13 != '' 01/10/2024 09:39:26 am >> UPDATE ps_product SET id_supplier = '', reference = '5/7', ean13 = '9788801069082', date_upd = NOW() WHERE id_product = '22980' 01/10/2024 09:39:26 am >> UPDATE ps_product_lang SET name = 'UOMO CHE SI FUMO\' LA BIBBIA - B. FERRERO', description = '' WHERE id_product = '22980' 01/10/2024 09:39:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22980' 01/10/2024 09:39:26 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 = '22980' 01/10/2024 09:39:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22980' 01/10/2024 09:39: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 = '22980' 01/10/2024 09:39:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22981' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:39: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 '22981' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22980' 01/10/2024 09:39:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22981' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22980' 01/10/2024 09:40:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8017009004375' AND id_product != '22981' AND ean13 != '' 01/10/2024 09:40:19 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '8017009004375', date_upd = NOW() WHERE id_product = '22981' 01/10/2024 09:40:19 am >> UPDATE ps_product_lang SET name = 'CALENDARIO PARROCCHIALE 2025', description = '' WHERE id_product = '22981' 01/10/2024 09:40:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.754098360655739' WHERE id_product = '22981' 01/10/2024 09:40:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.754098360655739', id_tax_rules_group = '1', id_category_default = '19', 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 = '22981' 01/10/2024 09:40:19 am >> DELETE FROM ps_specific_price WHERE id_product = '22981' 01/10/2024 09:40:19 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22981' 01/10/2024 09:40:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22982' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:40:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22982' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22981' 01/10/2024 09:40:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22982' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22981' 01/10/2024 09:41:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572298' AND id_product != '22982' AND ean13 != '' 01/10/2024 09:41:01 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788867572298', date_upd = NOW() WHERE id_product = '22982' 01/10/2024 09:41:01 am >> UPDATE ps_product_lang SET name = 'MESSA IN CHIESA INSIEME AI GRANDI', description = '' WHERE id_product = '22982' 01/10/2024 09:41:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '22982' 01/10/2024 09:41:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '22982' 01/10/2024 09:41:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22982' 01/10/2024 09:41:02 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 = '22982' 01/10/2024 09:41:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22983' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 09:41:02 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 '22983' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22982' 01/10/2024 09:41:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22983' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22982' 01/10/2024 09:41:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 01/10/2024 09:41:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. 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 = '0', id_causal = '0', price_tax_included = '44.30', price_tax_excluded = '44.30', date_upd = NOW() WHERE id_document = '89846' 01/10/2024 09:41: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 = '89846' 01/10/2024 09:41:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 01/10/2024 09:41: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 ( '89846' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 01/10/2024 09:41: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 01/10/2024 09:41: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 ( '89846' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '2' , '-2' , '4' , '7.0000' , '7' , '0' , '0' , '14.00' ) 01/10/2024 09:41: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 ( '89846' , '22977' , 'VANGELO SECONDO LUCA - L. BRUNI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 01/10/2024 10:16:27 am >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 10:16:27 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' , '133' , '2024-10-01' , '' , '1246' , '0' , '4675590' , 'L.GO MARGHERITA DI SAVOIA 85021 AVIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '198.80' , '198.80' , NOW() , NOW() ) 01/10/2024 10:16:27 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 = '93369' 01/10/2024 10:16:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93369' 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '15020' , 'PREGARE OGNI GIORNO' , '100' , '-100' , '4' , '1.00' , '1' , '0' , '15' , '85.00' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '15' , '3.83' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '15' , '5.95' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '15' , '3.83' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '15' , '21.25' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '15' , '12.75' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '4' , '0.50' , '0.5' , '0' , '10' , '22.50' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '12819' , 'REGISTRO DEL CATECHISTA ' , '20' , '-20' , '0' , '1.00' , '1' , '' , '15' , '17.00' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '15' , '15.72' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '15' , '2.89' ) 01/10/2024 10:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 01/10/2024 10:38:56 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' , '674992' , '2024-09-24' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.1' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.30' , '105.91' , NOW() , NOW() ) 01/10/2024 10:38:56 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 = '93370' 01/10/2024 10:38:56 am >> DELETE FROM ps_document_detail WHERE id_document = '93370' 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22982' , 'MESSA IN CHIESA INSIEME AI GRANDI' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22982' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22982' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22975' , 'VERGINITA DELLA MADRE DI GESU - S.M. PERRELLA' , '1' , '1' , '4' , '55.00' , '55' , '0' , '33' , '36.8500' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22975' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22975' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22979' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22979' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22980' , 'UOMO CHE SI FUMO LA BIBBIA - B. FERRERO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22980' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22980' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22977' , 'VANGELO SECONDO LUCA - L. BRUNI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '33' , '17.4200' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22977' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22977' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22978' , 'MISTERO PASQUALE E LITURGIA DELLE ORE - A.J. LAMBERT' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22978' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22978' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22981' , 'CALENDARIO PARROCCHIALE 2025' , '1' , '1' , '1' , '9.75' , '7.9918032786885' , '22' , '35' , '7.7317' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22981' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22981' , '7' , '1' ) 01/10/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93370' , '22976' , 'MARIA STELLA DELLA SPERANZA - BENEDETTO XVI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 01/10/2024 10:38:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '22976' AND id_supplier = '7' 01/10/2024 10:38:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22976' , '7' , '1' ) 01/10/2024 10:46:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 10:46:38 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' , '2858' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.75' , '6.39' , NOW() , NOW() ) 01/10/2024 10:46:38 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 = '93371' 01/10/2024 10:46:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93371' 01/10/2024 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93371' , '19231' , 'CARD CARLO ACUTIS - RN93' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 01/10/2024 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93371' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/10/2024 10:50:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 10:50:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2859' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 01/10/2024 10:50:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93372' 01/10/2024 10:50:45 am >> DELETE FROM ps_document_detail WHERE id_document = '93372' 01/10/2024 10:50: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 ( '93372' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 01/10/2024 10:56:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2772' AND id_document != '93257' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-23') 01/10/2024 10:56:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2772', document_date = '2024-09-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 = '9.00', price_tax_excluded = '7.92', date_upd = NOW() WHERE id_document = '93257' 01/10/2024 10:56:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93257' 01/10/2024 10:56:23 am >> DELETE FROM ps_document_detail WHERE id_document = '93257' 01/10/2024 10:56:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93257' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/10/2024 10:56:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93257' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 01/10/2024 10:59:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 10:59:19 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' , '2860' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 01/10/2024 10:59:19 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 = '93373' 01/10/2024 10:59:19 am >> DELETE FROM ps_document_detail WHERE id_document = '93373' 01/10/2024 10:59:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93373' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 01/10/2024 11:03:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 11:03:39 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' , '2861' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 01/10/2024 11:03:39 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 = '93374' 01/10/2024 11:03:39 am >> DELETE FROM ps_document_detail WHERE id_document = '93374' 01/10/2024 11:03:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93374' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/10/2024 11:03:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93374' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/10/2024 11:10:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 11:10:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2862' , '2024-10-01' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '148.64' , NOW() , NOW() ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93375' 01/10/2024 11:10:55 am >> DELETE FROM ps_document_detail WHERE id_document = '93375' 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967' , '22' , '0' , '20.00' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508' , '22' , '0' , '3.60' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '22040' , 'LOTTANDO INSIEME A GIOBBE - P. RIBET' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3654' , '4' , '0' , '35.00' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346' , '4' , '0' , '4.30' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '29.1' , '23.852459016393' , '22' , '0' , '29.10' ) 01/10/2024 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 01/10/2024 11:11:11 am >> DELETE FROM ps_document WHERE id_document = '92610' 01/10/2024 11:11:11 am >> DELETE FROM ps_document_detail WHERE id_document = '92610' 01/10/2024 11:11:13 am >> DELETE FROM ps_document WHERE id_document = '91941' 01/10/2024 11:11:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91941' 01/10/2024 11:11:40 am >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 01/10/2024 11:11:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23 + 40,00 22/11 - 110,00 07/12- 200,00 11/01 - 50,00 04/04/2024 + € 42,00 29/8/24 - € 100,00 01/10/2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '82607' 01/10/2024 11:11:41 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 = '82607' 01/10/2024 11:11:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82607' 01/10/2024 11:11: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 ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 01/10/2024 11:11: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 ( '82607' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '550.0000' , '450.81967213115' , '22' , '0' , '550.00' ) 01/10/2024 11:20:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2589' AND id_document != '93013' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 01/10/2024 11:20:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2589', document_date = '2024-09-05', 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 = '100.00', price_tax_excluded = '87.88', date_upd = NOW() WHERE id_document = '93013' 01/10/2024 11:20: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 = '93013' 01/10/2024 11:20:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93013' 01/10/2024 11:20: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 ( '93013' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 01/10/2024 11:20: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 ( '93013' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 01/10/2024 11:20: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 ( '93013' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 01/10/2024 11:20: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 ( '93013' , '18391' , 'CATENINA ACCIAIO 10 ESSENZE' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 01/10/2024 11:20: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 ( '93013' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 01/10/2024 11:20: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 ( '93013' , '22182' , 'INFLUENCER DI DIO - R. DE STEFANO' , '1' , '-1' , '4' , '14' , '14' , '0' , '0' , '14.00' ) 01/10/2024 11:42:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 11:42:19 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' , '2863' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 01/10/2024 11:42:19 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 = '93376' 01/10/2024 11:42:19 am >> DELETE FROM ps_document_detail WHERE id_document = '93376' 01/10/2024 11:42:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93376' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 01/10/2024 11:48:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 11:48: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 ( '11' , '2864' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.02' , '8.83' , NOW() , NOW() ) 01/10/2024 11:48: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 = '93377' 01/10/2024 11:48:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93377' 01/10/2024 11:48: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 ( '93377' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '3' , '-3' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '6.60' ) 01/10/2024 11:48: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 ( '93377' , '17257' , 'IO TI BATTEZZO ' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '5' , '3.42' ) 01/10/2024 12:08:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3775' 01/10/2024 12:08:37 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 ( '3775' , '10' , '208' , 'CONGREGAZIONE SUORE DI SAN GIOVANNI BATTISTA' , 'ROMANO' , 'SUOR MIRIAM' , 'VIA DEL CASALE DI SAN PIO V, 11/13' , '' , '00165' , 'ROMA ' , '' , '' , '3351432955 ' , '00993241009' , '01405490580' , NOW() , NOW() ) 01/10/2024 12:08:37 pm >> UPDATE ps_customer SET email = 'segreteria.sgb@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3775' 01/10/2024 12:11:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 12:11: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' , '134' , '2024-10-01' , '' , '3775' , '0' , '4679370' , 'VIA DEL CASALE DI SAN PIO V, 11/13 00165 ROMA ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '708.70' , '708.70' , NOW() , NOW() ) 01/10/2024 12:11: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 = '93378' 01/10/2024 12:11:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93378' 01/10/2024 12:11: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 ( '93378' , '5444' , 'IO SONO CON VOI - CAT.' , '22' , '-22' , '4' , '5.50' , '5.5' , '0' , '5' , '114.95' ) 01/10/2024 12:11: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 ( '93378' , '5457' , 'IO SONO CON VOI 1 PARTE' , '36' , '-36' , '4' , '2.80' , '2.8' , '0' , '5' , '95.76' ) 01/10/2024 12:11: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 ( '93378' , '5458' , 'IO SONO CON VOI 2 PARTE' , '36' , '-36' , '4' , '2.80' , '2.8' , '0' , '5' , '95.76' ) 01/10/2024 12:11: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 ( '93378' , '11191' , 'VENITE CON ME 1 PARTE' , '44' , '-44' , '4' , '2.80' , '2.8' , '0' , '5' , '117.04' ) 01/10/2024 12:11: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 ( '93378' , '11192' , 'VENITE CON ME 2 PARTE' , '44' , '-44' , '4' , '2.80' , '2.8' , '0' , '5' , '117.04' ) 01/10/2024 12:11: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 ( '93378' , '11193' , 'VENITE CON ME CAT.' , '22' , '-22' , '4' , '5.50' , '5.5' , '0' , '5' , '114.95' ) 01/10/2024 12:11: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 ( '93378' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '5' , '53.20' ) 01/10/2024 12:36:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2661' AND id_document != '93107' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-12') 01/10/2024 12:36:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2661', document_date = '2024-09-12', 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 = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '93107' 01/10/2024 12:36:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93107' 01/10/2024 12:36:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93107' 01/10/2024 12:36:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93107' , '22856' , 'DALLALBA AL TRAMONTO - OTT 2024' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 01/10/2024 12:37:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 12:37: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' , '2865' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 01/10/2024 12:37: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 = '93379' 01/10/2024 12:37:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93379' 01/10/2024 12:37: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 ( '93379' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 01/10/2024 12:37: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 ( '93379' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 01/10/2024 12:47:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 12:47: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' , '2866' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 01/10/2024 12:47: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 = '93380' 01/10/2024 12:47:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93380' 01/10/2024 12:47: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 ( '93380' , '4534' , 'GIOCA E COLORA - IO SONO I' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 01/10/2024 12:47: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 ( '93380' , '4535' , 'GIOCA E COLORA - IO SONO II' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 01/10/2024 12:49:18 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'w1OydK9u2taPzdai' , NOW() , NOW() ) 01/10/2024 12:49:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4119' , '1' ) 01/10/2024 12:49:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4119' , '2' ) 01/10/2024 12:49:19 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4119' , '3' ) 01/10/2024 12:52:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4119' 01/10/2024 12:52:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4119' , '10' , '210' , 'PARROCCHIA SANTA MARIA DEGLI ANGELI' , 'ROSSI' , 'DON ANDREA' , 'PIAZZA MICHELE D\'ASTE 2' , '' , '84042' , 'ACERNO' , '' , '' , '3803293746' , '' , '95020150652' , NOW() , NOW() ) 01/10/2024 12:52:19 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4119' 01/10/2024 01:01:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 01:01:20 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' , '2867' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.39' , NOW() , NOW() ) 01/10/2024 01:01: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 = '93381' 01/10/2024 01:01:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93381' 01/10/2024 01:01: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 ( '93381' , '14773' , 'BRACCIALE RIGATO - 0825N' , '6' , '-6' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '7.80' ) 01/10/2024 01:01: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 ( '93381' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 01/10/2024 03:07:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2868' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 03:07:19 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' , '2868' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 01/10/2024 03:07: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 = '93382' 01/10/2024 03:07:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93382' 01/10/2024 03:07: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 ( '93382' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/10/2024 03:07: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 ( '93382' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/10/2024 03:07:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2869' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 03:07:40 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' , '2869' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.12' , '13.12' , NOW() , NOW() ) 01/10/2024 03:07:40 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 = '93383' 01/10/2024 03:07:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93383' 01/10/2024 03:07:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93383' , '22973' , 'PREGHIERE DELLA FRATERNITA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 01/10/2024 03:07:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93383' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/10/2024 03:07:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93383' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/10/2024 03:17:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868983918' AND id_product != '22983' AND ean13 != '' 01/10/2024 03:17:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788868983918', date_upd = NOW() WHERE id_product = '22983' 01/10/2024 03:17:42 pm >> UPDATE ps_product_lang SET name = 'DAVANTI A DIO - P. RICCA', description = '' WHERE id_product = '22983' 01/10/2024 03:17:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22983' 01/10/2024 03:17:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '257', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22983' 01/10/2024 03:17:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22983' 01/10/2024 03:17:43 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 = '22983' 01/10/2024 03:17:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22984' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 03:17:43 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 '22984' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22983' 01/10/2024 03:17:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22984' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22983' 01/10/2024 03:27:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869293306' AND id_product != '22984' AND ean13 != '' 01/10/2024 03:27:31 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1 ', ean13 = '9788869293306', date_upd = NOW() WHERE id_product = '22984' 01/10/2024 03:27:31 pm >> UPDATE ps_product_lang SET name = 'GIUBILEO DELLA SPERANZA - D. COSO', description = '' WHERE id_product = '22984' 01/10/2024 03:27:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22984' 01/10/2024 03:27:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '45', 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 = '22984' 01/10/2024 03:27:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22984' 01/10/2024 03:28:55 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/10/2024 03:28:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22985' , '1' , '' , 'nuovo-prodotto' ) 01/10/2024 03:28:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22985' , '1' , '1' , '2' , NOW() , NOW() ) 01/10/2024 03:28:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22985' , '0' , '1' , '0' , '0' ) 01/10/2024 03:29:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714449' AND id_product != '22985' AND ean13 != '' 01/10/2024 03:29:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714449', date_upd = NOW() WHERE id_product = '22985' 01/10/2024 03:29:39 pm >> UPDATE ps_product_lang SET name = 'CHE PESCI PIGLIARE ', description = '' WHERE id_product = '22985' 01/10/2024 03:29:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.5' WHERE id_product = '22985' 01/10/2024 03:29:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22985' 01/10/2024 03:29:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '22985' 01/10/2024 03:32: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 ( '33' , '269548' , '2024-09-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '187.00' , '187.00' , NOW() , NOW() ) 01/10/2024 03:32: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 = '93384' 01/10/2024 03:32:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '93384' 01/10/2024 03:32: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 ( '93384' , '22983' , 'DAVANTI A DIO - P. RICCA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 01/10/2024 03:32:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22983' AND id_supplier = '109' 01/10/2024 03:32:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22983' , '109' , '1' ) 01/10/2024 03:32: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 ( '93384' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 01/10/2024 03:32:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109' 01/10/2024 03:32:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' ) 01/10/2024 03:32: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 ( '93384' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '3' , '3' , '4' , '19.50' , '19.5' , '0' , '0' , '58.5000' ) 01/10/2024 03:32:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109' 01/10/2024 03:32:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' ) 01/10/2024 03:32: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 ( '93384' , '22187' , 'SETTE SACRAMENTI CREATIVI - A. QUEIROLO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 01/10/2024 03:32:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22187' AND id_supplier = '109' 01/10/2024 03:32:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22187' , '109' , '1' ) 01/10/2024 03:32: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 ( '93384' , '21554' , 'CATECHESI CREATIVA 2 - A. QUEIROLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 01/10/2024 03:32:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21554' AND id_supplier = '109' 01/10/2024 03:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21554' , '109' , '1' ) 01/10/2024 03:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93384' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 01/10/2024 03:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 01/10/2024 03:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 01/10/2024 03:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93384' , '22984' , 'GIUBILEO DELLA SPERANZA - D. COSO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '0' , '24.0000' ) 01/10/2024 03:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22984' AND id_supplier = '109' 01/10/2024 03:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22984' , '109' , '1' ) 01/10/2024 03:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93384' , '19840' , 'PERLE DI DON DOLINDO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 01/10/2024 03:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19840' AND id_supplier = '109' 01/10/2024 03:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19840' , '109' , '1' ) 01/10/2024 03:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93384' , '22985' , 'CHE PESCI PIGLIARE ' , '2' , '2' , '4' , '11.50' , '11.5' , '0' , '0' , '23.0000' ) 01/10/2024 03:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22985' AND id_supplier = '109' 01/10/2024 03:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22985' , '109' , '1' ) 01/10/2024 04:09:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2870' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 04:09: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' , '2870' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 01/10/2024 04:09: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 = '93385' 01/10/2024 04:09:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93385' 01/10/2024 04:09: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 ( '93385' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 01/10/2024 05:42:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2871' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 05:42:12 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' , '2871' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 01/10/2024 05:42: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 = '93386' 01/10/2024 05:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93386' 01/10/2024 05:42: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 ( '93386' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '45' , '-45' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '27.00' ) 01/10/2024 05:43:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2872' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 05:43:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2872' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 01/10/2024 05:43:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93387' 01/10/2024 05:43:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93387' 01/10/2024 05:43:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93387' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/10/2024 05:45:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2651' AND id_document != '93095' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-11') 01/10/2024 05:45:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2651', document_date = '2024-09-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '2.46', date_upd = NOW() WHERE id_document = '93095' 01/10/2024 05:45:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93095' 01/10/2024 05:45:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93095' 01/10/2024 05:45:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93095' , '16312' , 'DECINA LEGNO CHIARO' , '5' , '-5' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '3.00' ) 01/10/2024 05:47:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '93378' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 05:47:40 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '134', document_date = '2024-10-01', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4679370', address1 = 'VIA DEL CASALE DI SAN PIO V, 11/13 00165 ROMA ', 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 = '658.30', price_tax_excluded = '658.30', date_upd = NOW() WHERE id_document = '93378' 01/10/2024 05:47:40 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 = '93378' 01/10/2024 05:47:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93378' 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '5444' , 'IO SONO CON VOI - CAT.' , '22' , '-22' , '4' , '5.5000' , '5.5' , '0' , '5' , '114.95' ) 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '5457' , 'IO SONO CON VOI 1 PARTE' , '36' , '-36' , '4' , '2.8000' , '2.8' , '0' , '15' , '85.68' ) 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '5458' , 'IO SONO CON VOI 2 PARTE' , '36' , '-36' , '4' , '2.8000' , '2.8' , '0' , '15' , '85.68' ) 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '11191' , 'VENITE CON ME 1 PARTE' , '44' , '-44' , '4' , '2.8000' , '2.8' , '0' , '15' , '104.72' ) 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '11192' , 'VENITE CON ME 2 PARTE' , '44' , '-44' , '4' , '2.8000' , '2.8' , '0' , '15' , '104.72' ) 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '11193' , 'VENITE CON ME CAT.' , '22' , '-22' , '4' , '5.5000' , '5.5' , '0' , '5' , '114.95' ) 01/10/2024 05:47:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93378' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 01/10/2024 05:49:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '93369' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 05:49:24 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '133', document_date = '2024-10-01', document_letter = '', id_customer = '1246', id_supplier = '', id_address = '4675590', address1 = 'L.GO MARGHERITA DI SAVOIA 85021 AVIGLIANO', 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 = '198.80', price_tax_excluded = '198.80', date_upd = NOW() WHERE id_document = '93369' 01/10/2024 05:49: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 = '93369' 01/10/2024 05:49:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93369' 01/10/2024 05:49: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 ( '93369' , '15020' , 'PREGARE OGNI GIORNO' , '100' , '-100' , '4' , '1.0000' , '1' , '0' , '15' , '85.00' ) 01/10/2024 05:49: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 ( '93369' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '15' , '3.83' ) 01/10/2024 05:49: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 ( '93369' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '15' , '5.95' ) 01/10/2024 05:49: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 ( '93369' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 01/10/2024 05:49: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 ( '93369' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '15' , '3.83' ) 01/10/2024 05:49: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 ( '93369' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '0' , '0.5000' , '0.5' , '0' , '15' , '21.25' ) 01/10/2024 05:49: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 ( '93369' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '15' , '12.75' ) 01/10/2024 05:49: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 ( '93369' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '4' , '0.5000' , '0.5' , '0' , '10' , '22.50' ) 01/10/2024 05:49: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 ( '93369' , '12819' , 'REGISTRO DEL CATECHISTA ' , '20' , '-20' , '0' , '1.0000' , '1' , '0' , '15' , '17.00' ) 01/10/2024 05:49: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 ( '93369' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '15' , '15.72' ) 01/10/2024 05:49: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 ( '93369' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 01/10/2024 05:49: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 ( '93369' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 01/10/2024 05:54:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '135' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 05:54: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 ( '21' , '135' , '2024-10-01' , '' , '284' , '0' , '4671723' , 'VIA GUIDO D\\\'AREZZO snc 92027 LICATA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '282.20' , '282.20' , NOW() , NOW() ) 01/10/2024 05:54: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 = '93388' 01/10/2024 05:54:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93388' 01/10/2024 05:54: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 ( '93388' , '5458' , 'IO SONO CON VOI 2 PARTE' , '50' , '-50' , '4' , '2.80' , '2.8' , '0' , '15' , '119.00' ) 01/10/2024 05:54: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 ( '93388' , '11192' , 'VENITE CON ME 2 PARTE' , '60' , '-60' , '4' , '2.80' , '2.8' , '0' , '15' , '142.80' ) 01/10/2024 05:54: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 ( '93388' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '15' , '13.60' ) 01/10/2024 05:54: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 ( '93388' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 01/10/2024 05:58:50 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'zDtDprLJKMl2fFKH' , NOW() , NOW() ) 01/10/2024 05:58:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4120' , '1' ) 01/10/2024 05:58:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4120' , '2' ) 01/10/2024 05:58:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4120' , '3' ) 01/10/2024 06:01:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4120' 01/10/2024 06:01:44 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 ( '4120' , '10' , '145' , '' , 'DE ROBBIO' , 'TERESA' , 'VIA ROMA 54' , '' , '81051' , 'PIETRAMELARA' , 'Massimo Di Sarno l\'edicola del borgo di Di Sarno Massimo\r\nvia Roma 54 Pietramelara\r\n81051 Caserta' , '' , '3281910999' , '' , '' , NOW() , NOW() ) 01/10/2024 06:01:44 pm >> UPDATE ps_customer SET email = 'teresaderobbio@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4120' 01/10/2024 06:02:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2873' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 06:02:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2873' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.70' , '7.28' , NOW() , NOW() ) 01/10/2024 06:02: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 = '93389' 01/10/2024 06:02:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '93389' 01/10/2024 06:02: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 ( '93389' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 01/10/2024 06:02: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 ( '93389' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 01/10/2024 06:03:25 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4120' 01/10/2024 06:03:25 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 ( '4120' , '10' , '145' , '' , 'DE ROBBIO' , 'TERESA' , 'VIA ROMA 54' , '' , '81051' , 'PIETRAMELARA' , 'Massimo Di Sarno l\'edicola del borgo di Di Sarno Massimo\r\nvia Roma 54 Pietramelara\r\n81051 Caserta' , '' , '3281910999' , '' , '' , NOW() , NOW() ) 01/10/2024 06:03:25 pm >> UPDATE ps_customer SET email = 'teresaderobbio@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4120' 01/10/2024 06:07:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '136' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 06:07: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' , '136' , '2024-10-01' , '' , '4120' , '0' , '4679373' , 'VIA ROMA 54 81051 PIETRAMELARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '222.87' , '222.87' , NOW() , NOW() ) 01/10/2024 06:07: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 = '93390' 01/10/2024 06:07:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93390' 01/10/2024 06:07: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 ( '93390' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '5' , '47.50' ) 01/10/2024 06:07: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 ( '93390' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3.80' , '3.8' , '0' , '5' , '18.05' ) 01/10/2024 06:07: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 ( '93390' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '5' , '-5' , '4' , '3.80' , '3.8' , '0' , '5' , '18.05' ) 01/10/2024 06:07: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 ( '93390' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '5' , '47.50' ) 01/10/2024 06:07: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 ( '93390' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '7' , '-7' , '4' , '3.80' , '3.8' , '0' , '5' , '25.27' ) 01/10/2024 06:07: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 ( '93390' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '7' , '-7' , '4' , '10.00' , '10' , '0' , '5' , '66.50' ) 01/10/2024 06:18:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 06:18: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' , '2874' , '2024-10-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 01/10/2024 06:18: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 = '93391' 01/10/2024 06:18:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93391' 01/10/2024 06:18: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 ( '93391' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/10/2024 06:18: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 ( '93391' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/10/2024 06:31:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2862' AND id_document != '93375' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 01/10/2024 06:31:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2862', document_date = '2024-10-01', document_letter = '', id_customer = '', id_supplier = '', id_address = '', 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 = '0', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '148.64', date_upd = NOW() WHERE id_document = '93375' 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93375' 01/10/2024 06:31:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93375' 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '22040' , 'LOTTANDO INSIEME A GIOBBE - P. RIBET' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '29.1000' , '23.852459016393' , '22' , '0' , '29.10' ) 01/10/2024 06:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93375' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/10/2024 07:33:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2725' AND id_document != '93190' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-18') 01/10/2024 07:33:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2725', document_date = '2024-09-18', 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 = '15.20', price_tax_excluded = '12.46', date_upd = NOW() WHERE id_document = '93190' 01/10/2024 07:33:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93190' 01/10/2024 07:33:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '93190' 01/10/2024 07:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93190' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.2000' , '5.0819672131148' , '22' , '0' , '6.20' ) 01/10/2024 07:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93190' , '7290' , 'SCATOLA CONFETTI CON CALAMITA' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 01/10/2024 07:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93190' , '20515' , 'DECINA ULIVO - 04/7-D' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 01/10/2024 07:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93190' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/10/2024 07:55:58 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '675379', document_date = '2024-09-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '3.39', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '129.26', price_tax_excluded = '129.26', date_upd = NOW() WHERE id_document = '93356' 01/10/2024 07:55: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 = '93356' 01/10/2024 07:55:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '93356' 01/10/2024 07:55: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 ( '93356' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '12' , '12' , '4' , '6.0000' , '6' , '0' , '30' , '50.40' ) 01/10/2024 07:55: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 ( '93356' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '100' , '0.00' ) 01/10/2024 07:55: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 ( '93356' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 01/10/2024 07:55: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 ( '93356' , '22973' , 'PREGHIERE DELLA FRATERNITA' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '30' , '4.20' ) 01/10/2024 07:55: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 ( '93356' , '2048' , 'CHRISTIFIDELES LAICI' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '33' , '2.6800' ) 01/10/2024 07:55: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 ( '93356' , '8327' , 'PREGHIERE A CARATTERI GRANDI' , '2' , '2' , '4' , '7.0000' , '7' , '0' , '30' , '9.80' ) 01/10/2024 07:55: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 ( '93356' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '3' , '3' , '4' , '7.0000' , '7' , '0' , '30' , '14.70' ) 01/10/2024 07:55: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 ( '93356' , '22881' , 'ADORAZIONE EUCARISTICA ALLA SCUOLA DELLA LITURGIA - POLI/ZOTTELE' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 01/10/2024 07:55: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 ( '93356' , '22564' , 'PAOLO E LEVANGELO DELLA SPERANZA' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 01/10/2024 07:55: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 ( '93356' , '22905' , 'DESTINATI ALLA VITA - V. PAGLIA' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 01/10/2024 07:55: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 ( '93356' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '2' , '2' , '4' , '3.9000' , '3.9' , '0' , '30' , '5.46' ) 01/10/2024 07:55: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 ( '93356' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '3' , '3' , '4' , '1.0000' , '1' , '0' , '30' , '2.10' )