19/11/2024 09:05:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3516' AND id_document != '94316' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 19/11/2024 09:05:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3516', document_date = '2024-11-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 = '3', id_causal = '0', price_tax_included = '593.00', price_tax_excluded = '486.07', date_upd = NOW() WHERE id_document = '94316' 19/11/2024 09:05:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94316' 19/11/2024 09:05:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94316' 19/11/2024 09:05:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94316' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '593.0000' , '486.06557377049' , '22' , '0' , '593.00' ) 19/11/2024 09:23:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 09:23:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3528' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.33' , '22.33' , NOW() , NOW() ) 19/11/2024 09:23: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 = '94332' 19/11/2024 09:23:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94332' 19/11/2024 09:23: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 ( '94332' , '22943' , 'AVVENTO 2024' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 19/11/2024 09:23: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 ( '94332' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 19/11/2024 09:29:14 am >> DELETE FROM ps_product WHERE id_product = '4722' 19/11/2024 09:29:14 am >> DELETE FROM ps_product_shop WHERE id_product = '4722' 19/11/2024 09:29:14 am >> DELETE FROM ps_product_lang WHERE id_product = '4722' 19/11/2024 09:29:14 am >> DELETE FROM ps_stock_available WHERE id_product = '4722' 19/11/2024 09:29:58 am >> DELETE FROM ps_product WHERE id_product = '8773' 19/11/2024 09:29:58 am >> DELETE FROM ps_product_shop WHERE id_product = '8773' 19/11/2024 09:29:58 am >> DELETE FROM ps_product_lang WHERE id_product = '8773' 19/11/2024 09:29:58 am >> DELETE FROM ps_stock_available WHERE id_product = '8773' 19/11/2024 09:32:03 am >> DELETE FROM ps_product WHERE id_product = '785' 19/11/2024 09:32:03 am >> DELETE FROM ps_product_shop WHERE id_product = '785' 19/11/2024 09:32:03 am >> DELETE FROM ps_product_lang WHERE id_product = '785' 19/11/2024 09:32:03 am >> DELETE FROM ps_stock_available WHERE id_product = '785' 19/11/2024 09:32:54 am >> DELETE FROM ps_product WHERE id_product = '9639' 19/11/2024 09:32:54 am >> DELETE FROM ps_product_shop WHERE id_product = '9639' 19/11/2024 09:32:54 am >> DELETE FROM ps_product_lang WHERE id_product = '9639' 19/11/2024 09:32:54 am >> DELETE FROM ps_stock_available WHERE id_product = '9639' 19/11/2024 09:33:36 am >> DELETE FROM ps_product WHERE id_product = '14445' 19/11/2024 09:33:36 am >> DELETE FROM ps_product_shop WHERE id_product = '14445' 19/11/2024 09:33:36 am >> DELETE FROM ps_product_lang WHERE id_product = '14445' 19/11/2024 09:33:36 am >> DELETE FROM ps_stock_available WHERE id_product = '14445' 19/11/2024 09:57:32 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '1F5ps4T8qACqkA8C' , NOW() , NOW() ) 19/11/2024 09:57:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7113' , '1' ) 19/11/2024 09:57:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7113' , '2' ) 19/11/2024 09:57:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7113' , '3' ) 19/11/2024 10:05:44 am >> UPDATE ps_address SET id_state = '204', lastname = 'GIUSMARY CONFEZIONI - DI MACRI NATALE GIUSEPPE', address1 = 'CONTRADA MANCA snc', address2 = '', postcode = '89040', dni = 'MCRNLG82T16D976S', vat_number = '02118800800', city = 'CIRELLA ', phone = '', phone_mobile = '3200733844', date_upd = NOW() WHERE id_supplier = '179' 19/11/2024 10:05:44 am >> UPDATE ps_supplier SET email = 'info@giusmeryconfezioni.it', name = 'GIUSMARY CONFEZIONI - DI MACRI NATALE GIUSEPPE', date_upd = NOW() WHERE id_supplier = '179' 19/11/2024 10:05:44 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '179' 19/11/2024 10:06:40 am >> UPDATE ps_address SET id_state = '204', lastname = 'GIUSMERY CONFEZIONI - DI MACRI NATALE GIUSEPPE', address1 = 'CONTRADA MANCA snc', address2 = '', postcode = '89040', dni = 'MCRNLG82T16D976S', vat_number = '02118800800', city = 'CIRELLA ', phone = '', phone_mobile = '3200733844', date_upd = NOW() WHERE id_supplier = '179' 19/11/2024 10:06:40 am >> UPDATE ps_supplier SET email = 'info@giusmeryconfezioni.it', name = 'GIUSMERY CONFEZIONI - DI MACRI NATALE GIUSEPPE', date_upd = NOW() WHERE id_supplier = '179' 19/11/2024 10:06:40 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '179' 19/11/2024 10:08:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002163' AND id_product != '21376' AND ean13 != '' 19/11/2024 10:08:22 am >> UPDATE ps_product SET id_supplier = '179', reference = '', ean13 = '002163', date_upd = NOW() WHERE id_product = '21376' 19/11/2024 10:08:22 am >> UPDATE ps_product_lang SET name = 'CASULA POL. LEGGERO - CS25L', description = '' WHERE id_product = '21376' 19/11/2024 10:08:22 am >> UPDATE ps_product SET wholesale_price = '25.00', on_sale = '0', price = '65.57377049180327' WHERE id_product = '21376' 19/11/2024 10:08:22 am >> UPDATE ps_product_shop SET wholesale_price = '25.00', price = '65.57377049180327', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21376' 19/11/2024 10:08:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21376' 19/11/2024 10:08:49 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/11/2024 10:08:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23223' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:08:49 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23223' , '1' , '1' , '2' , NOW() , NOW() ) 19/11/2024 10:08:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23223' , '0' , '1' , '0' , '0' ) 19/11/2024 10:09:21 am >> UPDATE ps_category SET active = '00' , id_parent = '4' , date_upd = NOW() WHERE id_category = '523' 19/11/2024 10:09:22 am >> UPDATE ps_category_lang SET name = 'GIUSMERY' , description = '' , link_rewrite = 'gius-mary' , meta_title = '' , meta_description = '' , meta_keywords = '' WHERE id_category = '523' 19/11/2024 10:11:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002320' AND id_product != '23223' AND ean13 != '' 19/11/2024 10:11:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002320', date_upd = NOW() WHERE id_product = '23223' 19/11/2024 10:11:20 am >> UPDATE ps_product_lang SET name = 'COPRILEGGIO - CL10', description = '' WHERE id_product = '23223' 19/11/2024 10:11:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '45.08196721311476' WHERE id_product = '23223' 19/11/2024 10:11:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '45.08196721311476', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23223' 19/11/2024 10:11:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23223' 19/11/2024 10:13: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 = '23223' 19/11/2024 10:13:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23224' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:13: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 '23224' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23223' 19/11/2024 10:13:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23224' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23223' 19/11/2024 10:14:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 10:14:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3529' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 19/11/2024 10:14:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94333' 19/11/2024 10:14:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94333' 19/11/2024 10:14:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94333' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/11/2024 10:16:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002321' AND id_product != '23224' AND ean13 != '' 19/11/2024 10:16:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002321', date_upd = NOW() WHERE id_product = '23224' 19/11/2024 10:16:14 am >> UPDATE ps_product_lang SET name = 'STOLA MARIANA - ST07', description = '' WHERE id_product = '23224' 19/11/2024 10:16:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '65.57377049180327' WHERE id_product = '23224' 19/11/2024 10:16:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '65.57377049180327', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23224' 19/11/2024 10:16:14 am >> DELETE FROM ps_specific_price WHERE id_product = '23224' 19/11/2024 10:16:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23224' 19/11/2024 10:16:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23225' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:16:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23225' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23224' 19/11/2024 10:16:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23225' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23224' 19/11/2024 10:17:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002322' AND id_product != '23225' AND ean13 != '' 19/11/2024 10:17:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002322', date_upd = NOW() WHERE id_product = '23225' 19/11/2024 10:17:17 am >> UPDATE ps_product_lang SET name = 'STOLA MARIANA - ST08', description = '' WHERE id_product = '23225' 19/11/2024 10:17:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98.36065573770492' WHERE id_product = '23225' 19/11/2024 10:17:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98.36065573770492', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23225' 19/11/2024 10:17:17 am >> DELETE FROM ps_specific_price WHERE id_product = '23225' 19/11/2024 10:21:13 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 = '23225' 19/11/2024 10:21:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23226' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:21:13 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 '23226' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23225' 19/11/2024 10:21:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23226' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23225' 19/11/2024 10:23:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002323' AND id_product != '23226' AND ean13 != '' 19/11/2024 10:23:02 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002323', date_upd = NOW() WHERE id_product = '23226' 19/11/2024 10:23:02 am >> UPDATE ps_product_lang SET name = 'STOLA GIUBILEO RICAMATA - ST15GBR', description = '' WHERE id_product = '23226' 19/11/2024 10:23:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28.688524590163937' WHERE id_product = '23226' 19/11/2024 10:23:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28.688524590163937', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23226' 19/11/2024 10:23:02 am >> DELETE FROM ps_specific_price WHERE id_product = '23226' 19/11/2024 10:23:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 10:23:22 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' , '3530' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 19/11/2024 10:23:22 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 = '94334' 19/11/2024 10:23:22 am >> DELETE FROM ps_document_detail WHERE id_document = '94334' 19/11/2024 10:23:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94334' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/11/2024 10:24:58 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23226' 19/11/2024 10:24:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23227' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:24:58 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23227' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23226' 19/11/2024 10:24:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23227' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23226' 19/11/2024 10:25:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002324' AND id_product != '23227' AND ean13 != '' 19/11/2024 10:25:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002324', date_upd = NOW() WHERE id_product = '23227' 19/11/2024 10:25:41 am >> UPDATE ps_product_lang SET name = 'STOLA GIUBILEO STAMPATA - ST16GBR', description = '' WHERE id_product = '23227' 19/11/2024 10:25:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '23227' 19/11/2024 10:25:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23227' 19/11/2024 10:25:41 am >> DELETE FROM ps_specific_price WHERE id_product = '23227' 19/11/2024 10:31:05 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7113' 19/11/2024 10:31:05 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 ( '7113' , '10' , '210' , 'PARROCCHIA SAN PIETRO AP.' , 'TUFANO' , 'DON LUCA' , 'VIA PAOLO VI 4' , '' , '84018' , 'SCAFATI' , 'SPEDIZIONE: BORRIELLO MARIANNA VIA LO PORTO CORTILE ATTRUIA 5 Tel 3349051930\r\nborriello.marianna80@gmail.com' , '' , '' , '' , '80031900659' , NOW() , NOW() ) 19/11/2024 10:31:05 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7113' 19/11/2024 10:31:15 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7113' 19/11/2024 10:31:15 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 ( '7113' , '10' , '210' , 'PARROCCHIA SAN PIETRO AP.' , 'TUFANO' , 'DON LUCA' , 'VIA PAOLO VI 55' , '' , '84018' , 'SCAFATI' , 'SPEDIZIONE: BORRIELLO MARIANNA VIA LO PORTO CORTILE ATTRUIA 5 Tel 3349051930\r\nborriello.marianna80@gmail.com' , '' , '' , '' , '80031900659' , NOW() , NOW() ) 19/11/2024 10:31:15 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7113' 19/11/2024 10:32:56 am >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 10:32: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 ( '21' , '43' , '2024-11-19' , '' , '7113' , '0' , '177359060' , 'VIA PAOLO VI 55 84018 SCAFATI' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '145.35' , '145.35' , NOW() , NOW() ) 19/11/2024 10:32: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 = '14770' 19/11/2024 10:32:56 am >> DELETE FROM ps_document_detail WHERE id_document = '14770' 19/11/2024 10:32: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 ( '14770' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '65' , '-65' , '4' , '2.13' , '2.13' , '0' , '0' , '138.45' ) 19/11/2024 10:39:28 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 = '23227' 19/11/2024 10:39:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23228' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:39:28 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 '23228' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23227' 19/11/2024 10:39:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23228' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23227' 19/11/2024 10:40:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002325' AND id_product != '23228' AND ean13 != '' 19/11/2024 10:40:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002325', date_upd = NOW() WHERE id_product = '23228' 19/11/2024 10:40:32 am >> UPDATE ps_product_lang SET name = 'casula giubileo ricamata - cs64', description = '' WHERE id_product = '23228' 19/11/2024 10:40:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '57.37704918032787' WHERE id_product = '23228' 19/11/2024 10:40:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '57.37704918032787', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23228' 19/11/2024 10:40:32 am >> DELETE FROM ps_specific_price WHERE id_product = '23228' 19/11/2024 10:40:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002325' AND id_product != '23228' AND ean13 != '' 19/11/2024 10:40:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002325', date_upd = NOW() WHERE id_product = '23228' 19/11/2024 10:40:54 am >> UPDATE ps_product_lang SET name = 'CASULA GIUBILEO RICAMATA - CS64', description = '' WHERE id_product = '23228' 19/11/2024 10:40:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '57.3770' WHERE id_product = '23228' 19/11/2024 10:40:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '57.3770', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23228' 19/11/2024 10:40:54 am >> DELETE FROM ps_specific_price WHERE id_product = '23228' 19/11/2024 10:41:22 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 = '23228' 19/11/2024 10:41:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23229' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 10:41:22 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 '23229' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23228' 19/11/2024 10:41:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23229' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23228' 19/11/2024 10:42:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002326' AND id_product != '23229' AND ean13 != '' 19/11/2024 10:42:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002326', date_upd = NOW() WHERE id_product = '23229' 19/11/2024 10:42:08 am >> UPDATE ps_product_lang SET name = 'COPRILEGGIO GIUBILEO RICAMATO - CL18GBR', description = '' WHERE id_product = '23229' 19/11/2024 10:42:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '46.721311475409834' WHERE id_product = '23229' 19/11/2024 10:42:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '46.721311475409834', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23229' 19/11/2024 10:42:08 am >> DELETE FROM ps_specific_price WHERE id_product = '23229' 19/11/2024 10:43:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002326' AND id_product != '23229' AND ean13 != '' 19/11/2024 10:43:03 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002326', date_upd = NOW() WHERE id_product = '23229' 19/11/2024 10:43:03 am >> UPDATE ps_product_lang SET name = 'COPRILEGGIO GIUBILEO RICAMATO - CL18GBR', description = '' WHERE id_product = '23229' 19/11/2024 10:43:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '46.721311475409834' WHERE id_product = '23229' 19/11/2024 10:43:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '46.721311475409834', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23229' 19/11/2024 10:43:03 am >> DELETE FROM ps_specific_price WHERE id_product = '23229' 19/11/2024 10:43: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 ( '31' , '1115/EL' , '2024-11-14' , 'EL' , '0' , '179' , '4679060' , 'CONTRADA MANCA snc 89040 CIRELLA ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '706.34' , '578.97' , NOW() , NOW() ) 19/11/2024 10:43: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 = '94335' 19/11/2024 10:43:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94335' 19/11/2024 10:43: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 ( '94335' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '8' , '8' , '1' , '33' , '27.049180327869' , '22' , '3' , '312.4176' ) 19/11/2024 10:43:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21376' AND id_supplier = '179' 19/11/2024 10:43:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21376' , '179' , '1' ) 19/11/2024 10:43: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 ( '94335' , '23223' , 'COPRILEGGIO - CL10' , '4' , '4' , '1' , '22' , '18.032786885246' , '22' , '3' , '104.1392' ) 19/11/2024 10:43:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23223' AND id_supplier = '179' 19/11/2024 10:43:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23223' , '179' , '1' ) 19/11/2024 10:43: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 ( '94335' , '23224' , 'STOLA MARIANA - ST07' , '1' , '1' , '1' , '33' , '27.049180327869' , '22' , '3' , '39.0522' ) 19/11/2024 10:43:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23224' AND id_supplier = '179' 19/11/2024 10:43:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23224' , '179' , '1' ) 19/11/2024 10:43: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 ( '94335' , '23225' , 'STOLA MARIANA - ST08' , '1' , '1' , '1' , '49.5' , '40.573770491803' , '22' , '3' , '58.5783' ) 19/11/2024 10:43:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23225' AND id_supplier = '179' 19/11/2024 10:43:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23225' , '179' , '1' ) 19/11/2024 10:43: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 ( '94335' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '4' , '4' , '1' , '14' , '11.475409836066' , '22' , '10' , '61.4880' ) 19/11/2024 10:43:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23226' AND id_supplier = '179' 19/11/2024 10:43:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23226' , '179' , '1' ) 19/11/2024 10:43: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 ( '94335' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '4' , '4' , '1' , '10' , '8.1967213114754' , '22' , '10' , '43.9200' ) 19/11/2024 10:43:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23227' AND id_supplier = '179' 19/11/2024 10:43:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23227' , '179' , '1' ) 19/11/2024 10:43:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '2' , '2' , '1' , '28' , '22.950819672131' , '22' , '10' , '61.4880' ) 19/11/2024 10:43:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23228' AND id_supplier = '179' 19/11/2024 10:43:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23228' , '179' , '1' ) 19/11/2024 10:43:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23229' , 'COPRILEGGIO GIUBILEO RICAMATO - CL18GBR' , '1' , '1' , '1' , '23' , '18.852459016393' , '22' , '10' , '25.2540' ) 19/11/2024 10:43:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23229' AND id_supplier = '179' 19/11/2024 10:43:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23229' , '179' , '1' ) 19/11/2024 11:05:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 11:05:11 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' , '3531' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 19/11/2024 11:05:11 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 = '94336' 19/11/2024 11:05:11 am >> DELETE FROM ps_document_detail WHERE id_document = '94336' 19/11/2024 11:05:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94336' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 19/11/2024 11:13:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 11:13: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' , '3532' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.42' , '121.84' , NOW() , NOW() ) 19/11/2024 11:13: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 = '94337' 19/11/2024 11:13:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94337' 19/11/2024 11:13: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 ( '94337' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '42' , '-42' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '67.20' ) 19/11/2024 11:13: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 ( '94337' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '10' , '-10' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '16.00' ) 19/11/2024 11:13: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 ( '94337' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '5' , '7.22' ) 19/11/2024 11:13: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 ( '94337' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 19/11/2024 11:13: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 ( '94337' , '7938' , 'PERGAMENE - MATRIMONIO-B' , '20' , '-20' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '10.00' ) 19/11/2024 11:13:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94337' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 19/11/2024 11:17:17 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23229' 19/11/2024 11:17:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23230' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 11:17:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23230' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23229' 19/11/2024 11:17:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23230' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23229' 19/11/2024 11:18:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002327' AND id_product != '23230' AND ean13 != '' 19/11/2024 11:18:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002327', date_upd = NOW() WHERE id_product = '23230' 19/11/2024 11:18:20 am >> UPDATE ps_product_lang SET name = 'COPRILEGGIO GIUBILEO STAMPATO - CL19GBS', description = '' WHERE id_product = '23230' 19/11/2024 11:18:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '23230' 19/11/2024 11:18:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23230' 19/11/2024 11:18:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23230' 19/11/2024 11:20:32 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 = '23230' 19/11/2024 11:20:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23231' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 11:20:32 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 '23231' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23230' 19/11/2024 11:20:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23231' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23230' 19/11/2024 11:23:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002328' AND id_product != '23231' AND ean13 != '' 19/11/2024 11:23:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002328', date_upd = NOW() WHERE id_product = '23231' 19/11/2024 11:23:19 am >> UPDATE ps_product_lang SET name = 'CLERGY MISTO ML', description = '' WHERE id_product = '23231' 19/11/2024 11:23:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '23231' 19/11/2024 11:23:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '523', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23231' 19/11/2024 11:23:19 am >> DELETE FROM ps_specific_price WHERE id_product = '23231' 19/11/2024 11:23:41 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 = '23231' 19/11/2024 11:23:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23232' , '1' , '' , 'nuovo-prodotto' ) 19/11/2024 11:23:41 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 '23232' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23231' 19/11/2024 11:23:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23232' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23231' 19/11/2024 11:33:24 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1115/EL', document_date = '2024-11-14', document_letter = 'EL', id_customer = '0', id_supplier = '', id_address = '4679060', address1 = 'CONTRADA MANCA snc 89040 CIRELLA ', 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 = '726.10', price_tax_excluded = '595.17', date_upd = NOW() WHERE id_document = '94335' 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94335' 19/11/2024 11:33:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94335' 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '8' , '8' , '1' , '33.0000' , '27.049180327869' , '22' , '3' , '312.42' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23223' , 'COPRILEGGIO - CL10' , '4' , '4' , '1' , '22.0000' , '18.032786885246' , '22' , '3' , '104.14' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23224' , 'STOLA MARIANA - ST07' , '1' , '1' , '1' , '33.0000' , '27.049180327869' , '22' , '3' , '39.05' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23225' , 'STOLA MARIANA - ST08' , '1' , '1' , '1' , '49.5000' , '40.573770491803' , '22' , '3' , '58.58' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '4' , '4' , '1' , '14.0000' , '11.475409836066' , '22' , '10' , '61.49' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '4' , '4' , '1' , '10.0000' , '8.1967213114754' , '22' , '10' , '43.92' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '2' , '2' , '1' , '28.0000' , '22.950819672131' , '22' , '10' , '61.49' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23229' , 'COPRILEGGIO GIUBILEO RICAMATO - CL18GBR' , '1' , '1' , '1' , '23.0000' , '18.852459016393' , '22' , '10' , '25.25' ) 19/11/2024 11:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94335' , '23230' , 'COPRILEGGIO GIUBILEO STAMPATO - CL19GBS' , '1' , '1' , '1' , '18' , '14.754098360656' , '22' , '10' , '19.7640' ) 19/11/2024 11:49:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 11:49:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3533' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.40' , '45.33' , NOW() , NOW() ) 19/11/2024 11:49:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94338' 19/11/2024 11:49:51 am >> DELETE FROM ps_document_detail WHERE id_document = '94338' 19/11/2024 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '7' , '5.7377049180328' , '22' , '0' , '28.00' ) 19/11/2024 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '12' , '-12' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '14.40' ) 19/11/2024 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/11/2024 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/11/2024 11:53:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 11:53:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3534' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 19/11/2024 11:53:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94339' 19/11/2024 11:53:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94339' 19/11/2024 11:53:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94339' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 19/11/2024 11:56:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 11:56:00 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' , '3535' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.09' , '79.84' , NOW() , NOW() ) 19/11/2024 11:56:00 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 = '94340' 19/11/2024 11:56:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94340' 19/11/2024 11:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94340' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 19/11/2024 11:56:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94340' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/11/2024 11:56:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94340' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/11/2024 11:56:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94340' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '5' , '2.09' ) 19/11/2024 11:56:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94340' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/11/2024 11:59:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 11:59:21 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' , '3536' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '21.00' , NOW() , NOW() ) 19/11/2024 11:59:21 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 = '94341' 19/11/2024 11:59:21 am >> DELETE FROM ps_document_detail WHERE id_document = '94341' 19/11/2024 11:59:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94341' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '21' , '21' , '0' , '0' , '21.00' ) 19/11/2024 12:01:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 12:01:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3537' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.00' , '136.89' , NOW() , NOW() ) 19/11/2024 12:01:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94342' 19/11/2024 12:01:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '94342' 19/11/2024 12:01:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94342' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '108.00' ) 19/11/2024 12:01:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94342' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '26.00' ) 19/11/2024 12:01:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94342' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 19/11/2024 12:01:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94342' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 19/11/2024 12:03:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 12:03:26 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' , '3538' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '275.00' , '225.41' , NOW() , NOW() ) 19/11/2024 12:03:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94343' 19/11/2024 12:03:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '94343' 19/11/2024 12:03:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94343' , '1914' , 'CERA DELLA LITURGIA' , '48' , '-48' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '216.00' ) 19/11/2024 12:03:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94343' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '26.00' ) 19/11/2024 12:03:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94343' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 19/11/2024 12:03:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94343' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 19/11/2024 12:04:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 12:04:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3539' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.10' , '89.75' , NOW() , NOW() ) 19/11/2024 12:04:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94344' 19/11/2024 12:04:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94344' 19/11/2024 12:04: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 ( '94344' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 19/11/2024 12:04: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 ( '94344' , '23169' , 'DILEXIT NOS ' , '40' , '-40' , '4' , '2.20' , '2.2' , '0' , '5' , '83.60' ) 19/11/2024 12:08:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 12:08: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' , '3540' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 19/11/2024 12:08: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 = '94345' 19/11/2024 12:08:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94345' 19/11/2024 12:08: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 ( '94345' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 19/11/2024 12:38:40 pm >> DELETE FROM ps_document WHERE id_document = '94335' 19/11/2024 12:38:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94335' 19/11/2024 12:43:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1115/EL' , '2024-11-14' , 'EL' , '0' , '179' , '4679060' , 'CONTRADA MANCA snc 89040 CIRELLA ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1133.70' , '929.26' , NOW() , NOW() ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94346' 19/11/2024 12:43:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94346' 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '8' , '8' , '1' , '33' , '27.049180327869' , '22' , '3' , '312.4176' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21376' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21376' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23223' , 'COPRILEGGIO - CL10' , '4' , '4' , '1' , '22' , '18.032786885246' , '22' , '3' , '104.1392' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23223' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23223' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23224' , 'STOLA MARIANA - ST07' , '1' , '1' , '1' , '33' , '27.049180327869' , '22' , '3' , '39.0522' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23224' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23224' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23225' , 'STOLA MARIANA - ST08' , '1' , '1' , '1' , '49.5' , '40.573770491803' , '22' , '3' , '58.5783' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23225' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23225' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '4' , '4' , '1' , '14' , '11.475409836066' , '22' , '10' , '61.4880' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23226' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23226' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '2' , '2' , '1' , '28' , '22.950819672131' , '22' , '10' , '61.4880' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23228' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23228' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23229' , 'COPRILEGGIO GIUBILEO RICAMATO - CL18GBR' , '1' , '1' , '1' , '23' , '18.852459016393' , '22' , '10' , '25.2540' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23229' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23229' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '4' , '4' , '1' , '10' , '8.1967213114754' , '22' , '10' , '43.9200' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23227' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23227' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23230' , 'COPRILEGGIO GIUBILEO STAMPATO - CL19GBS' , '1' , '1' , '1' , '18' , '14.754098360656' , '22' , '10' , '19.7640' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23230' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23230' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '23231' , 'CLERGY MISTO ML' , '33' , '33' , '1' , '9.9' , '8.1147540983607' , '22' , '3' , '386.6168' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23231' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23231' , '179' , '1' ) 19/11/2024 12:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94346' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '17.2' , '14.098360655738' , '22' , '0' , '20.9840' ) 19/11/2024 12:43:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '179' 19/11/2024 12:43:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '179' , '1' ) 19/11/2024 12:46:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '54/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 12:46: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 ( '23' , '54/E' , '2024-11-19' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1453.00' , '1357.79' , NOW() , NOW() ) 19/11/2024 12:46: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 = '94347' 19/11/2024 12:46:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94347' 19/11/2024 12:46: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 ( '94347' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 19/11/2024 12:46: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 ( '94347' , '12849' , 'LIBRO DELLE SS. MESSE' , '20' , '-20' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '240.00' ) 19/11/2024 12:46: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 ( '94347' , '21899' , 'SACRA BIBBIA cei/uelci ' , '100' , '-100' , '4' , '18.50' , '18.5' , '0' , '50' , '925.00' ) 19/11/2024 12:48:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '55/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 12:48:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '55/E' , '2024-11-19' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '3' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '284.08' , '281.92' , NOW() , NOW() ) 19/11/2024 12:48:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94348' 19/11/2024 12:48:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '94348' 19/11/2024 12:48:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94348' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '70' , '-70' , '4' , '3.40' , '3.4' , '0' , '38' , '147.56' ) 19/11/2024 12:48:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94348' , '11191' , 'VENITE CON ME 1 PARTE' , '70' , '-70' , '4' , '2.80' , '2.8' , '0' , '38' , '121.52' ) 19/11/2024 12:48:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94348' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/11/2024 02:36:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '241' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 02:36: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 ( '21' , '241' , '2024-11-19' , '' , '1237' , '0' , '4679207' , 'VIA MILANO 11 97019 VITTORIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '411.40' , '411.40' , NOW() , NOW() ) 19/11/2024 02:36: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 = '94349' 19/11/2024 02:36:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94349' 19/11/2024 02:36: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 ( '94349' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' , '-35' , '4' , '3.80' , '3.8' , '0' , '15' , '113.05' ) 19/11/2024 02:36: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 ( '94349' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '35' , '-35' , '4' , '3.80' , '3.8' , '0' , '15' , '113.05' ) 19/11/2024 02:36: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 ( '94349' , '12813' , 'MARIA MADRE NOSTRA' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 19/11/2024 02:36: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 ( '94349' , '12253' , 'MIO LIBRO DI PREGHIERE' , '35' , '-35' , '4' , '2.80' , '2.8' , '0' , '15' , '83.30' ) 19/11/2024 02:36: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 ( '94349' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '-10' , '4' , '6.00' , '6' , '0' , '15' , '51.00' ) 19/11/2024 03:33:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-07') 19/11/2024 03:33:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2024-11-07', document_letter = 'A', id_customer = '2893', id_supplier = '', id_address = '4672074', address1 = 'VIA CONVENTO 83025 MONTORO', 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 = '321.56', price_tax_excluded = '281.89', date_upd = NOW() WHERE id_document = '94115' 19/11/2024 03:33:17 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 = '94115' 19/11/2024 03:33:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94115' 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '5446' , 'IO SONO CON VOI - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 19/11/2024 03:33:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 19/11/2024 03:35:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 03:35:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3541' , '2024-11-19' , '' , '2893' , '0' , '4672074' , 'VIA CONVENTO 83025 MONTORO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '100.00' , NOW() , NOW() ) 19/11/2024 03:35:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94350' 19/11/2024 03:35:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94350' 19/11/2024 03:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 19/11/2024 03:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 19/11/2024 03:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '5446' , 'IO SONO CON VOI - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 19/11/2024 03:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 19/11/2024 03:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.8' , '3.8' , '0' , '' , '3.80' ) 19/11/2024 03:35:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-07') 19/11/2024 03:35:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2024-11-07', document_letter = 'A', id_customer = '2893', id_supplier = '', id_address = '4672074', address1 = 'VIA CONVENTO 83025 MONTORO', 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 = '220.00', price_tax_excluded = '180.33', date_upd = NOW() WHERE id_document = '94115' 19/11/2024 03:35: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 = '94115' 19/11/2024 03:35:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94115' 19/11/2024 03:36:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 19/11/2024 03:40:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 03:40:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3542' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 19/11/2024 03:40: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 = '94351' 19/11/2024 03:40:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94351' 19/11/2024 03:40: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 ( '94351' , '23223' , 'COPRILEGGIO - CL10' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 19/11/2024 03:45:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '682222' , '2024-11-18' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.22' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.89' , '120.89' , NOW() , NOW() ) 19/11/2024 03:45: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 = '94352' 19/11/2024 03:45:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '94352' 19/11/2024 03:45: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 ( '94352' , '19618' , 'CARLO ACUTIS' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 19/11/2024 03:45:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19618' AND id_supplier = '7' 19/11/2024 03:45:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19618' , '7' , '1' ) 19/11/2024 03:45: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 ( '94352' , '5892' , 'LITURGIA DELLE ORE II - FRANCESCANA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '25' , '28.5000' ) 19/11/2024 03:45:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5892' AND id_supplier = '7' 19/11/2024 03:45:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5892' , '7' , '1' ) 19/11/2024 03:45: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 ( '94352' , '5894' , 'LITURGIA DELLE ORE IV - FRANCESCANA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '25' , '28.5000' ) 19/11/2024 03:45:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5894' AND id_supplier = '7' 19/11/2024 03:45:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5894' , '7' , '1' ) 19/11/2024 03:45: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 ( '94352' , '5893' , 'LITURGIA DELLE ORE III - FRANCESCANA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '25' , '28.5000' ) 19/11/2024 03:45:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5893' AND id_supplier = '7' 19/11/2024 03:45:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5893' , '7' , '1' ) 19/11/2024 03:45: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 ( '94352' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 19/11/2024 03:45:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21541' AND id_supplier = '7' 19/11/2024 03:45:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21541' , '7' , '1' ) 19/11/2024 03:45: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 ( '94352' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 19/11/2024 03:45:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23069' AND id_supplier = '7' 19/11/2024 03:45:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23069' , '7' , '1' ) 19/11/2024 04:16:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 04:16:18 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' , '3543' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.60' , '34.10' , NOW() , NOW() ) 19/11/2024 04:16:18 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 = '94353' 19/11/2024 04:16:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94353' 19/11/2024 04:16:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94353' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '13' , '-13' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '41.60' ) 19/11/2024 04:31:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 04:31:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3544' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '600.00' , '491.80' , NOW() , NOW() ) 19/11/2024 04:31:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94354' 19/11/2024 04:31:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '94354' 19/11/2024 04:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94354' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '8' , '-8' , '1' , '75' , '61.475409836066' , '22' , '0' , '600.00' ) 19/11/2024 04:37:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 04:37:17 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' , '3545' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.64' , '12.64' , NOW() , NOW() ) 19/11/2024 04:37:17 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 = '94355' 19/11/2024 04:37:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94355' 19/11/2024 04:37:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94355' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2024 04:37:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94355' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 19/11/2024 04:37:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94355' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 19/11/2024 04:49:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3546' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 04:49: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' , '3546' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.90' , '10.57' , NOW() , NOW() ) 19/11/2024 04:49: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 = '94356' 19/11/2024 04:49:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94356' 19/11/2024 04:49: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 ( '94356' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '1' , '-1' , '1' , '12.90' , '10.573770491803' , '22' , '0' , '12.90' ) 19/11/2024 04:54:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3544' AND id_document != '94354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 04:54:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3544', document_date = '2024-11-19', 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 = '600.00', price_tax_excluded = '491.80', date_upd = NOW() WHERE id_document = '94354' 19/11/2024 04:54:53 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 = '94354' 19/11/2024 04:54:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '94354' 19/11/2024 04:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94354' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '8' , '-8' , '1' , '60' , '49.180327868852' , '22' , '0' , '480.00' ) 19/11/2024 04:54:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94354' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 19/11/2024 04:55:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3541' AND id_document != '94350' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 04:55:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3541', document_date = '2024-11-19', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA CONVENTO 83025 MONTORO', 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 = '100.00', date_upd = NOW() WHERE id_document = '94350' 19/11/2024 04:55:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94350' 19/11/2024 04:55:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94350' 19/11/2024 04:55:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 19/11/2024 04:55:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 19/11/2024 04:55:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '5446' , 'IO SONO CON VOI - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 19/11/2024 04:55:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 19/11/2024 04:55:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94350' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '' , '3.80' ) 19/11/2024 05:52:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3547' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 05:52:17 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' , '3547' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '260.00' , '224.04' , NOW() , NOW() ) 19/11/2024 05:52:17 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 = '94357' 19/11/2024 05:52:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94357' 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '21522' , 'MASSIME ETERNE' , '3' , '-3' , '4' , '5.50' , '5.5' , '0' , '5' , '15.69' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '15387' , 'VESTINA BATTESIMALE ' , '6' , '-6' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '15.00' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/11/2024 05:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94357' , '22756' , 'CROCIFISSO SAGOMATO nazareno 30X19 - 1030161' , '1' , '-1' , '1' , '77.42' , '63.459016393443' , '22' , '0' , '77.42' ) 19/11/2024 06:00:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3548' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:00:39 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' , '3548' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 19/11/2024 06:00:39 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 = '94358' 19/11/2024 06:00:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94358' 19/11/2024 06:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94358' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '5' , '8.55' ) 19/11/2024 06:05:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3549' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:05:39 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' , '3549' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.24' , '62.24' , NOW() , NOW() ) 19/11/2024 06:05:39 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 = '94359' 19/11/2024 06:05:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94359' 19/11/2024 06:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94359' , '11186' , 'VENITE CON ME - GUIDA - M. FILIPPI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 19/11/2024 06:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94359' , '9679' , 'SARETE MIEI TESTIMONI - GUIDA - G. MORANTE' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 19/11/2024 06:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94359' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 19/11/2024 06:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94359' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 19/11/2024 06:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94359' , '22457' , 'GRANDE SINFONIA DI PREGHIERA - L. MAROTTA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 19/11/2024 06:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94359' , '23206' , 'GIUBILEO DELLA SPERANZA - U. TERRINONI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/11/2024 06:08:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:08:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '242' , '2024-11-19' , '' , '344' , '0' , '4679249' , 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.13' , '83.13' , NOW() , NOW() ) 19/11/2024 06:08:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94360' 19/11/2024 06:08:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94360' 19/11/2024 06:08:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 19/11/2024 06:08:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 19/11/2024 06:08:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '27' , '-27' , '4' , '2.40' , '2.4' , '0' , '15' , '55.08' ) 19/11/2024 06:08:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '5' , '-5' , '4' , '3.40' , '3.4' , '0' , '15' , '14.45' ) 19/11/2024 06:10:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '94360' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:10:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '242', document_date = '2024-11-19', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '83.13', price_tax_excluded = '83.13', date_upd = NOW() WHERE id_document = '94360' 19/11/2024 06:10:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94360' 19/11/2024 06:10:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94360' 19/11/2024 06:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 19/11/2024 06:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 19/11/2024 06:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '27' , '-27' , '4' , '2.4000' , '2.4' , '0' , '15' , '55.08' ) 19/11/2024 06:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94360' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '5' , '-5' , '4' , '3.4000' , '3.4' , '0' , '15' , '14.45' ) 19/11/2024 06:43:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3550' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:43:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3550' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 19/11/2024 06:43:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94361' 19/11/2024 06:43:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '94361' 19/11/2024 06:43:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94361' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/11/2024 06:54:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3551' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:54:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3551' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.40' , '17.54' , NOW() , NOW() ) 19/11/2024 06:54:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94362' 19/11/2024 06:54:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94362' 19/11/2024 06:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94362' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/11/2024 06:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94362' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 19/11/2024 06:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94362' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/11/2024 06:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94362' , '20956' , 'BEATO CARLO ACUTIS - 64' , '2' , '-2' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.40' ) 19/11/2024 06:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94362' , '15393' , 'TELA 18X25 - SANTA RITA' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 19/11/2024 06:57:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3552' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 06:57:02 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' , '3552' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '17.00' , NOW() , NOW() ) 19/11/2024 06:57:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94363' 19/11/2024 06:57:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94363' 19/11/2024 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94363' , '18635' , 'NASCOSTO IN UN PEZZETTO DI PANE - 8038' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 19/11/2024 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94363' , '22555' , 'RITA DA CASCIA - 8658' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/11/2024 07:00:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3553' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 07:00:52 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' , '3553' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.10' , '6.64' , NOW() , NOW() ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94364' 19/11/2024 07:00:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94364' 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '4965' , 'IMMAGINE GIOVANNI XXIII' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '4996' , 'IMMAGINE SAN PIO - OGGETTI' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '4967' , 'IMMAGINE IMMACOLATA CONCEZIONE - 9' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '4977' , 'IMMAGINE MADONNA DI POMPEI' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '16714' , 'SACRO CUORE DI MARIA' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '13715' , 'SANTA TERESA' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94364' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/11/2024 07:03:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3553' AND id_document != '94364' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 07:03:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3553', document_date = '2024-11-19', 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 = '8.10', price_tax_excluded = '6.64', date_upd = NOW() WHERE id_document = '94364' 19/11/2024 07:03: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 = '94364' 19/11/2024 07:03:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '94364' 19/11/2024 07:03: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 ( '94364' , '4965' , 'IMMAGINE GIOVANNI XXIII' , '4' , '-4' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '3.20' ) 19/11/2024 07:03: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 ( '94364' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:03: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 ( '94364' , '4967' , 'IMMAGINE IMMACOLATA CONCEZIONE - 9' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:03: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 ( '94364' , '16714' , 'SACRO CUORE DI MARIA' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:03: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 ( '94364' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:03: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 ( '94364' , '13715' , 'SANTA TERESA' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/11/2024 07:03: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 ( '94364' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '0.90' ) 19/11/2024 07:15:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3554' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 07:15:56 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' , '3554' , '2024-11-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '2.20' , NOW() , NOW() ) 19/11/2024 07:15:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94365' 19/11/2024 07:15:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '94365' 19/11/2024 07:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94365' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 19/11/2024 07:16:46 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'h24rz0IijVkrsIT6' , NOW() , NOW() ) 19/11/2024 07:16:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4143' , '1' ) 19/11/2024 07:16:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4143' , '2' ) 19/11/2024 07:16:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4143' , '3' ) 19/11/2024 07:19:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4143' 19/11/2024 07:19:32 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 ( '4143' , '10' , '179' , 'PARROCCHIA SACRO CUORE DI GESU\'' , 'VITANZA' , 'DON VINCENZO' , 'VIA G. MEDICI 411A' , '' , '98076' , 'SANT\'AGATA DI MILITELLO' , 'MONS. MARIO RANIERI 3494262658' , '' , '3494262658' , '' , '' , NOW() , NOW() ) 19/11/2024 07:19:32 pm >> UPDATE ps_customer SET email = 'mario.raneri@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4143' 19/11/2024 07:19:43 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4143' 19/11/2024 07:19:43 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 ( '4143' , '10' , '179' , 'PARROCCHIA SACRO CUORE DI GESU\'' , 'VITANZA' , 'DON VINCENZO' , 'VIA G. MEDICI 411A' , '' , '98076' , 'SANT\'AGATA DI MILITELLO' , 'MONS. MARIO RANIERI 3494262658' , '' , '3494262658' , '' , '' , NOW() , NOW() ) 19/11/2024 07:19:43 pm >> UPDATE ps_customer SET email = 'mario.raneri@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4143' 19/11/2024 07:20:02 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4143' 19/11/2024 07:20:02 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 ( '4143' , '10' , '179' , 'PARROCCHIA SACRO CUORE DI GESU\'' , 'VITANZA' , 'DON VINCENZO' , 'VIA G. MEDICI 411A' , '' , '98076' , 'SANT\'AGATA DI MILITELLO' , 'MONS. MARIO RANERI 3494262658' , '' , '3494262658' , '' , '' , NOW() , NOW() ) 19/11/2024 07:20:02 pm >> UPDATE ps_customer SET email = 'mario.raneri@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4143' 19/11/2024 07:21:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '243' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 07:21: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 ( '21' , '243' , '2024-11-19' , '' , '4143' , '0' , '4679432' , 'VIA G. MEDICI 411A 98076 SANT\\\'AGATA DI MILITELLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '146.30' , '146.30' , NOW() , NOW() ) 19/11/2024 07:21: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 = '94366' 19/11/2024 07:21:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94366' 19/11/2024 07:21: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 ( '94366' , '4154' , 'FESTA DEL PERDONO' , '23' , '-23' , '4' , '3.00' , '3' , '0' , '5' , '65.55' ) 19/11/2024 07:21: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 ( '94366' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 19/11/2024 07:21: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 ( '94366' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 19/11/2024 07:21: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 ( '94366' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 19/11/2024 07:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3547' AND id_document != '94357' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 19/11/2024 07:35:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3547', document_date = '2024-11-19', 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 = '260.00', price_tax_excluded = '224.04', date_upd = NOW() WHERE id_document = '94357' 19/11/2024 07:35: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 = '94357' 19/11/2024 07:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94357' 19/11/2024 07:35: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 ( '94357' , '21522' , 'MASSIME ETERNE' , '3' , '-3' , '4' , '5.5000' , '5.5' , '0' , '5' , '15.69' ) 19/11/2024 07:35: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 ( '94357' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '15.00' ) 19/11/2024 07:35: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 ( '94357' , '15387' , 'VESTINA BATTESIMALE ' , '6' , '-6' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '15.00' ) 19/11/2024 07:35: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 ( '94357' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 19/11/2024 07:35: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 ( '94357' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 19/11/2024 07:35: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 ( '94357' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 19/11/2024 07:35: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 ( '94357' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 19/11/2024 07:35: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 ( '94357' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 19/11/2024 07:35: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 ( '94357' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 19/11/2024 07:35: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 ( '94357' , '22870' , 'AGENDA SAN PAOLO 2025' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/11/2024 07:35: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 ( '94357' , '22756' , 'CROCIFISSO SAGOMATO nazareno 30X19 - 1030161' , '1' , '-1' , '1' , '67.42' , '55.262295081967' , '22' , '0' , '67.42' )