24/03/2025 10:30:08 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 24/03/2025 10:30:08 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 ( '4060' , '10' , '229' , 'PARROCCHIA DI CA DEGLI OPPI' , 'MANARA' , 'DON FILIPPO' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CA DEGLI OPPI DI OPPEANO ' , 'ha credito € 33.82' , '' , '349 0871619' , '' , '' , NOW() , NOW() ) 24/03/2025 10:30:08 am >> UPDATE ps_customer SET email = 'donfilippomanara@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 24/03/2025 10:48:00 am >> SELECT document_num FROM ps_document WHERE document_num = '956' AND id_document != '96340' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 24/03/2025 10:48:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '956', document_date = '2025-03-22', 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 = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '96340' 24/03/2025 10:48: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 = '96340' 24/03/2025 10:48:00 am >> DELETE FROM ps_document_detail WHERE id_document = '96340' 24/03/2025 10:48: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 ( '96340' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '9' , '7.3770491803279' , '22' , '0' , '36.00' ) 24/03/2025 10:48: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 ( '96340' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '24.5000' , '20.081967213115' , '22' , '0' , '49.00' ) 24/03/2025 11:54:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000110' AND id_product != '3179' AND ean13 != '' 24/03/2025 11:54:09 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '000110', date_upd = NOW() WHERE id_product = '3179' 24/03/2025 11:54:09 am >> UPDATE ps_product_lang SET name = 'CROCIFISSO - CM 40 - 1003', description = '' WHERE id_product = '3179' 24/03/2025 11:54:09 am >> UPDATE ps_product SET wholesale_price = '19.00', on_sale = '0', price = '42.622950819672134' WHERE id_product = '3179' 24/03/2025 11:54:09 am >> UPDATE ps_product_shop SET wholesale_price = '19.00', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3179' 24/03/2025 11:54:09 am >> DELETE FROM ps_specific_price WHERE id_product = '3179' 24/03/2025 11:54:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000095' AND id_product != '6728' AND ean13 != '' 24/03/2025 11:54:50 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '000095', date_upd = NOW() WHERE id_product = '6728' 24/03/2025 11:54:50 am >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA - CM 20 - 326', description = '' WHERE id_product = '6728' 24/03/2025 11:54:50 am >> UPDATE ps_product SET wholesale_price = '13.30', on_sale = '0', price = '29.508196721311474' WHERE id_product = '6728' 24/03/2025 11:54:50 am >> UPDATE ps_product_shop SET wholesale_price = '13.30', price = '29.508196721311474', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6728' 24/03/2025 11:54:50 am >> DELETE FROM ps_specific_price WHERE id_product = '6728' 24/03/2025 11:55:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002201' AND id_product != '21786' AND ean13 != '' 24/03/2025 11:55:47 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002201', date_upd = NOW() WHERE id_product = '21786' 24/03/2025 11:55:47 am >> UPDATE ps_product_lang SET name = 'MADONNA DEL CARMINE CM 30 - 621', description = '' WHERE id_product = '21786' 24/03/2025 11:55:47 am >> UPDATE ps_product SET wholesale_price = '21.66', on_sale = '0', price = '49.18032786885246' WHERE id_product = '21786' 24/03/2025 11:55:47 am >> UPDATE ps_product_shop SET wholesale_price = '21.66', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '165', 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 = '21786' 24/03/2025 11:55:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21786' 24/03/2025 11:56:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002202' AND id_product != '21787' AND ean13 != '' 24/03/2025 11:56:35 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002202', date_upd = NOW() WHERE id_product = '21787' 24/03/2025 11:56:35 am >> UPDATE ps_product_lang SET name = 'STATUA M. AUSILIATRICE CM 30 - 623', description = '' WHERE id_product = '21787' 24/03/2025 11:56:35 am >> UPDATE ps_product SET wholesale_price = '21.66', on_sale = '0', price = '49.18032786885246' WHERE id_product = '21787' 24/03/2025 11:56:35 am >> UPDATE ps_product_shop SET wholesale_price = '21.66', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '165', 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 = '21787' 24/03/2025 11:56:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21787' 24/03/2025 11:57:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002243' AND id_product != '22255' AND ean13 != '' 24/03/2025 11:57:36 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002243', date_upd = NOW() WHERE id_product = '22255' 24/03/2025 11:57:36 am >> UPDATE ps_product_lang SET name = 'STATUA SAN GIUSEPPE CM 40 - 804', description = '' WHERE id_product = '22255' 24/03/2025 11:57:36 am >> UPDATE ps_product SET wholesale_price = '38.00', on_sale = '0', price = '86.06557377049181' WHERE id_product = '22255' 24/03/2025 11:57:36 am >> UPDATE ps_product_shop SET wholesale_price = '38.00', price = '86.06557377049181', id_tax_rules_group = '1', id_category_default = '165', 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 = '22255' 24/03/2025 11:57:36 am >> DELETE FROM ps_specific_price WHERE id_product = '22255' 24/03/2025 12:00:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002354' AND id_product != '16512' AND ean13 != '' 24/03/2025 12:00:44 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002354', date_upd = NOW() WHERE id_product = '16512' 24/03/2025 12:00:44 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN GIUSEPPE CM 60 - PA612', description = '' WHERE id_product = '16512' 24/03/2025 12:00:44 pm >> UPDATE ps_product SET wholesale_price = '83.60', on_sale = '0', price = '211.47540983606558' WHERE id_product = '16512' 24/03/2025 12:00:44 pm >> UPDATE ps_product_shop SET wholesale_price = '83.60', price = '211.47540983606558', id_tax_rules_group = '1', id_category_default = '165', 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 = '16512' 24/03/2025 12:00:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '16512' 24/03/2025 12:01:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002197' AND id_product != '23334' AND ean13 != '' 24/03/2025 12:01:46 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002197', date_upd = NOW() WHERE id_product = '23334' 24/03/2025 12:01:46 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN FRANCESCO CM 25 - 411', description = '' WHERE id_product = '23334' 24/03/2025 12:01:46 pm >> UPDATE ps_product SET wholesale_price = '16.76', on_sale = '0', price = '35.24590163934426' WHERE id_product = '23334' 24/03/2025 12:01:46 pm >> UPDATE ps_product_shop SET wholesale_price = '16.76', price = '35.24590163934426', id_tax_rules_group = '1', id_category_default = '165', 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 = '23334' 24/03/2025 12:01:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '23334' 24/03/2025 12:01:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002197' AND id_product != '23334' AND ean13 != '' 24/03/2025 12:01:57 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002197', date_upd = NOW() WHERE id_product = '23334' 24/03/2025 12:01:57 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN FRANCESCO CM 25 - 411', description = '' WHERE id_product = '23334' 24/03/2025 12:01:57 pm >> UPDATE ps_product SET wholesale_price = '16.76', on_sale = '0', price = '37.704918032786885' WHERE id_product = '23334' 24/03/2025 12:01:57 pm >> UPDATE ps_product_shop SET wholesale_price = '16.76', price = '37.704918032786885', id_tax_rules_group = '1', id_category_default = '165', 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 = '23334' 24/03/2025 12:01:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '23334' 24/03/2025 12:03:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000382' AND id_product != '15666' AND ean13 != '' 24/03/2025 12:03:03 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '000382', date_upd = NOW() WHERE id_product = '15666' 24/03/2025 12:03:03 pm >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA CM 60 - PA602', description = '' WHERE id_product = '15666' 24/03/2025 12:03:03 pm >> UPDATE ps_product SET wholesale_price = '79.94', on_sale = '0', price = '180.32786885245903' WHERE id_product = '15666' 24/03/2025 12:03:03 pm >> UPDATE ps_product_shop SET wholesale_price = '79.94', price = '180.32786885245903', id_tax_rules_group = '1', id_category_default = '165', 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 = '15666' 24/03/2025 12:03:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '15666' 24/03/2025 12:03:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001583' AND id_product != '17400' AND ean13 != '' 24/03/2025 12:03:44 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001583', date_upd = NOW() WHERE id_product = '17400' 24/03/2025 12:03:44 pm >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA CM 40 - 805', description = '' WHERE id_product = '17400' 24/03/2025 12:03:44 pm >> UPDATE ps_product SET wholesale_price = '30.78', on_sale = '0', price = '69.67213114754098' WHERE id_product = '17400' 24/03/2025 12:03:44 pm >> UPDATE ps_product_shop SET wholesale_price = '30.78', price = '69.67213114754098', id_tax_rules_group = '1', id_category_default = '165', 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 = '17400' 24/03/2025 12:03:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '17400' 24/03/2025 12:05: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 ( '31' , '84/2025' , '2025-03-21' , '2025' , '0' , '130' , '4670548' , 'VIA CARRAIA,4/6/8 55025 COREGLIA ANTELMINELLI' , '' , '' , '43.001' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '573.90' , '470.41' , NOW() , NOW() ) 24/03/2025 12:05: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 = '96346' 24/03/2025 12:05:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '96346' 24/03/2025 12:05: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 ( '96346' , '3179' , 'CROCIFISSO - CM 40 - 1003' , '1' , '1' , '1' , '21.6' , '17.704918032787' , '22' , '5' , '25.0344' ) 24/03/2025 12:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3179' AND id_supplier = '130' 24/03/2025 12:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3179' , '130' , '1' ) 24/03/2025 12:05: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 ( '96346' , '6728' , 'STATUA MIRACOLOSA - CM 20 - 326' , '1' , '1' , '1' , '15.12' , '12.393442622951' , '22' , '5' , '17.5241' ) 24/03/2025 12:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6728' AND id_supplier = '130' 24/03/2025 12:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6728' , '130' , '1' ) 24/03/2025 12:05: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 ( '96346' , '21786' , 'MADONNA DEL CARMINE CM 30 - 621' , '1' , '1' , '1' , '24.62' , '20.180327868852' , '22' , '5' , '28.5346' ) 24/03/2025 12:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21786' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21786' , '130' , '1' ) 24/03/2025 12:05:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96346' , '21787' , 'STATUA M. AUSILIATRICE CM 30 - 623' , '1' , '1' , '1' , '24.62' , '20.180327868852' , '22' , '5' , '28.5346' ) 24/03/2025 12:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21787' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21787' , '130' , '1' ) 24/03/2025 12:05:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96346' , '22255' , 'STATUA SAN GIUSEPPE CM 40 - 804' , '1' , '1' , '1' , '43.2' , '35.409836065574' , '22' , '5' , '50.0688' ) 24/03/2025 12:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22255' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22255' , '130' , '1' ) 24/03/2025 12:05:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96346' , '16512' , 'STATUA SAN GIUSEPPE CM 60 - PA612' , '1' , '1' , '1' , '105.84' , '86.754098360656' , '22' , '5' , '122.6686' ) 24/03/2025 12:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16512' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16512' , '130' , '1' ) 24/03/2025 12:05:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96346' , '23334' , 'STATUA SAN FRANCESCO CM 25 - 411' , '1' , '1' , '1' , '19.05' , '15.614754098361' , '22' , '5' , '22.0789' ) 24/03/2025 12:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23334' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23334' , '130' , '1' ) 24/03/2025 12:05:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96346' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '1' , '1' , '90.88' , '74.491803278689' , '22' , '5' , '105.3299' ) 24/03/2025 12:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '130' , '1' ) 24/03/2025 12:05:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96346' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '3' , '3' , '1' , '34.99' , '28.680327868852' , '22' , '5' , '121.6602' ) 24/03/2025 12:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17400' AND id_supplier = '130' 24/03/2025 12:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17400' , '130' , '1' ) 24/03/2025 12:08:04 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'QPLZ1iix1HBIR3zD' , NOW() , NOW() ) 24/03/2025 12:08:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4200' , '1' ) 24/03/2025 12:08:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4200' , '2' ) 24/03/2025 12:08:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4200' , '3' ) 24/03/2025 12:09:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4200' 24/03/2025 12:09:44 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4200' , '10' , '208' , '' , 'ROMANO' , 'ALBERTO ' , 'VIA DANTE ALIGHIERI 16' , '' , '00010' , 'SAN PAOLO DEI CAVALIERI' , '' , '' , '3388241704' , '' , '' , NOW() , NOW() ) 24/03/2025 12:09:44 pm >> UPDATE ps_customer SET email = 'albertoromano52@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4200' 24/03/2025 12:10:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 12:10:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '51' , '2025-03-24' , '' , '4200' , '0' , '4679491' , 'VIA DANTE ALIGHIERI 16 00010 SAN PAOLO DEI CAVALIERI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 24/03/2025 12:10: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 = '96347' 24/03/2025 12:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '96347' 24/03/2025 12:10: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 ( '96347' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '5' , '19.00' ) 24/03/2025 12:13:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '96347' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 12:13:36 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2025-03-24', document_letter = '', id_customer = '4200', id_supplier = '', id_address = '4679491', address1 = 'VIA DANTE ALIGHIERI 16 00010 SAN PAOLO DEI CAVALIERI', 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 = '19.00', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '96347' 24/03/2025 12:13:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96347' 24/03/2025 12:13:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '96347' 24/03/2025 12:13:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96347' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '-20' , '4' , '1.0000' , '1' , '0' , '5' , '19.00' ) 24/03/2025 12:23:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 12:23: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' , '961' , '2025-03-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.87' , '60.87' , NOW() , NOW() ) 24/03/2025 12:23: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 = '96348' 24/03/2025 12:23:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '96348' 24/03/2025 12:23: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 ( '96348' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/03/2025 12:23: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 ( '96348' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 24/03/2025 12:23: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 ( '96348' , '23464' , 'SALVE CROCE UNICA SPERANZA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 24/03/2025 12:23: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 ( '96348' , '23482' , 'VIA CRUCIS DELLA SPERANZA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 24/03/2025 12:23: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 ( '96348' , '23417' , 'VIA CRUCIS FONTE DI SPERANZA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 24/03/2025 12:23: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 ( '96348' , '23498' , 'SPERANZA NELLA VIA DELLA CROCE' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 24/03/2025 12:23: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 ( '96348' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/03/2025 12:23: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 ( '96348' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '22372' , 'VOLTO DI GESU IL SERVO CROCIFISSO - E. BIANCHI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '22080' , 'LI AMO SINO ALLA FINE - QA. RAMINA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '15019' , 'PREGHIAMO CON MARIA' , '10' , '-10' , '4' , '0.80' , '0.8' , '0' , '5' , '7.60' ) 24/03/2025 12:23:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 24/03/2025 12:49:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 12:49:10 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' , '962' , '2025-03-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '65.00' , NOW() , NOW() ) 24/03/2025 12:49:10 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 = '96349' 24/03/2025 12:49:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '96349' 24/03/2025 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96349' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '65' , '65' , '0' , '0' , '65.00' ) 24/03/2025 02:35:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983653' AND id_product != '16667' AND ean13 != '' 24/03/2025 02:35:36 pm >> UPDATE ps_product SET id_supplier = '53', reference = '13/3', ean13 = '9788895983653', date_upd = NOW() WHERE id_product = '16667' 24/03/2025 02:35:36 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS', description = '

“Perché cercate tra i morti colui che\r\nè vivo? Non è qui, è risuscitato”, con questa frase del Vangelo di Luca\r\n(24,5-6) scopriamo la vera finalità della nostra esistenza che non è\r\nterrena ma aspira all’eternità.

\r\n\r\n

Celebriamo la Via Crucis, ricordando\r\nla strada percorsa da Gesù verso il Calvario, ma tante volte sperimentiamo\r\nquesta via dolorosa anche per noi stessi. Ma preghiamo anche per le persone\r\nche ancora oggi sono chiamate ad affrontare situazioni di vita dolorose.

' WHERE id_product = '16667' 24/03/2025 02:35:36 pm >> UPDATE ps_product SET wholesale_price = '0.48', on_sale = '0', price = '3.0000' WHERE id_product = '16667' 24/03/2025 02:35:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.48', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16667' 24/03/2025 02:35:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '16667' 24/03/2025 02:35:36 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '16667' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 24/03/2025 02:35:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810711125' AND id_product != '22372' AND ean13 != '' 24/03/2025 02:35:56 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/3', ean13 = '9788810711125', date_upd = NOW() WHERE id_product = '22372' 24/03/2025 02:35:56 pm >> UPDATE ps_product_lang SET name = 'VOLTO DI GESU\' IL SERVO CROCIFISSO - E. BIANCHI', description = '' WHERE id_product = '22372' 24/03/2025 02:35:56 pm >> UPDATE ps_product SET wholesale_price = '2.21', on_sale = '0', price = '3.9000' WHERE id_product = '22372' 24/03/2025 02:35:56 pm >> UPDATE ps_product_shop SET wholesale_price = '2.21', price = '3.9000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22372' 24/03/2025 02:35:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22372' 24/03/2025 02:40:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '746' AND id_document != '96073' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-06') 24/03/2025 02:40:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '746', document_date = '2025-03-06', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96073' 24/03/2025 02:40:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96073' 24/03/2025 02:40:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '96073' 24/03/2025 02:40: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 ( '96073' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '4' , '-4' , '1' , '11.25' , '9.2213114754098' , '22' , '0' , '45.00' ) 24/03/2025 02:40:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '798' AND id_document != '96141' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 24/03/2025 02:40:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '798', document_date = '2025-03-10', 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 = '184.40', price_tax_excluded = '156.63', date_upd = NOW() WHERE id_document = '96141' 24/03/2025 02:40:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96141' 24/03/2025 02:40:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96141' 24/03/2025 02:40:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96141' , '22201' , 'UN TEMPO PER PIANTARE E UN TEMPO PER SDRAIARE - T. HALIK' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 24/03/2025 02:40:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96141' , '23449' , 'TENTATI MA NON VINTI - L. PASQUA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 24/03/2025 02:40:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96141' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '139.0000' , '113.93442622951' , '22' , '0' , '139.00' ) 24/03/2025 02:40:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96141' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/03/2025 02:40:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96141' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/03/2025 03:38:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 03:38: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' , '963' , '2025-03-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 24/03/2025 03:38: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 = '96350' 24/03/2025 03:38:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '96350' 24/03/2025 03:38: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 ( '96350' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' , '-3' , '4' , '16.00' , '16' , '0' , '5' , '45.60' ) 24/03/2025 03:38: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 ( '96350' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '2' , '-2' , '4' , '7.2' , '7.2' , '0' , '' , '14.40' ) 24/03/2025 03:57:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '96095' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-07') 24/03/2025 03:57:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2025-03-07', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'mariani francesco', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '96095' 24/03/2025 03:57:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96095' 24/03/2025 03:57:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '96095' 24/03/2025 03:57:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96095' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 24/03/2025 03:57:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - FOGLIA ORO' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 24/03/2025 03:57:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96095' , '0' , 'CERO PASQUALE API 80X 120 da fare disegni' , '4' , '-4' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/03/2025 04:12:43 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4197' 24/03/2025 04:12: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 ( '4197' , '10' , '210' , '' , 'GARGANO' , 'AVV. SAVERIO' , 'VIA PERGOLA 73' , '' , '84010' , 'MINORI' , '' , '' , '3393701234' , '02939930653' , '' , NOW() , NOW() ) 24/03/2025 04:12:43 pm >> UPDATE ps_customer SET email = 'garganosaverio@gmail.com', sdi = 'SU9YNJA', pec = '', date_upd = NOW() WHERE id_customer = '4197' 24/03/2025 04:13:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '96327' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-21') 24/03/2025 04:13:06 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '8/L', document_date = '2025-03-21', document_letter = 'L', id_customer = '4197', id_supplier = '0', id_address = '4679492', address1 = 'VIA PERGOLA 73 84010 MINORI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '96327' 24/03/2025 04:13:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96327' 24/03/2025 04:13:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '96327' 24/03/2025 04:13:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96327' , '23403' , 'CAMPANA CON MARTELLINO - 4026' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 24/03/2025 04:13:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96327' , '23088' , 'CAMPANA DEL GIUBILEO' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 24/03/2025 04:14:47 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4197' 24/03/2025 04:14:47 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 ( '4197' , '10' , '210' , 'AVV. SAVERIO GARGANO' , '' , '' , 'VIA PERGOLA 73' , '' , '84010' , 'MINORI' , '' , '' , '3393701234' , '02939930653' , '' , NOW() , NOW() ) 24/03/2025 04:14:47 pm >> UPDATE ps_customer SET email = 'garganosaverio@gmail.com', sdi = 'SU9YNJA', pec = '', date_upd = NOW() WHERE id_customer = '4197' 24/03/2025 04:15:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '96327' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-21') 24/03/2025 04:15:04 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '8/L', document_date = '2025-03-21', document_letter = 'L', id_customer = '4197', id_supplier = '0', id_address = '4679493', address1 = 'VIA PERGOLA 73 84010 MINORI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '96327' 24/03/2025 04:15:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96327' 24/03/2025 04:15:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96327' 24/03/2025 04:15:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96327' , '23403' , 'CAMPANA CON MARTELLINO - 4026' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 24/03/2025 04:15:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96327' , '23088' , 'CAMPANA DEL GIUBILEO' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 24/03/2025 05:13:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 05:13:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '63/A' , '2025-03-24' , 'A' , '3812' , '0' , '4679440' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '1900.00' , '1557.38' , NOW() , NOW() ) 24/03/2025 05:13:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96351' 24/03/2025 05:13:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '96351' 24/03/2025 05:13:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96351' , '' , 'ostensorio - os27' , '1' , '-1' , '1' , '1900' , '1557.3770491803' , '22' , '0' , '1900.00' ) 24/03/2025 05:18:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 05:18:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '964' , '2025-03-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 24/03/2025 05:18:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96352' 24/03/2025 05:18:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96352' 24/03/2025 05:18:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96352' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 24/03/2025 05:24:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 24/03/2025 05:24:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '965' , '2025-03-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.90' , '11.14' , NOW() , NOW() ) 24/03/2025 05:24:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96353' 24/03/2025 05:24:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96353' 24/03/2025 05:24: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 ( '96353' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/03/2025 05:24: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 ( '96353' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' )