16/01/2025 12:06:11 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'AU7HcFUyWdEo8o1F' , NOW() , NOW() ) 16/01/2025 12:06:11 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4153' , '1' ) 16/01/2025 12:06:11 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4153' , '2' ) 16/01/2025 12:06:11 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4153' , '3' ) 16/01/2025 12:06:23 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/01/2025 12:06:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23344' , '1' , '' , 'nuovo-prodotto' ) 16/01/2025 12:06:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23344' , '1' , '1' , '2' , NOW() , NOW() ) 16/01/2025 12:06:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23344' , '0' , '1' , '0' , '0' ) 16/01/2025 09:36:44 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 09:36:44 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' , '153' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 16/01/2025 09:36:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95297' 16/01/2025 09:36:44 am >> DELETE FROM ps_document_detail WHERE id_document = '95297' 16/01/2025 09:36:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95297' , '12132' , 'SANTA AGNESE - 18' , '5' , '-5' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '17.50' ) 16/01/2025 09:48:42 am >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 09:48:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '154' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.62' , '41.62' , NOW() , NOW() ) 16/01/2025 09:48:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95298' 16/01/2025 09:48:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95298' 16/01/2025 09:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95298' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 16/01/2025 09:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95298' , '4154' , 'FESTA DEL PERDONO' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 16/01/2025 09:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95298' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '2' , '-2' , '4' , '3.40' , '3.4' , '0' , '5' , '6.46' ) 16/01/2025 09:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95298' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 16/01/2025 09:48:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95298' , '22881' , 'ADORAZIONE EUCARISTICA ALLA SCUOLA DELLA LITURGIA - POLI/ZOTTELE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 16/01/2025 10:24:18 am >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 10:24:18 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' , '155' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 16/01/2025 10:24:18 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 = '95299' 16/01/2025 10:24:18 am >> DELETE FROM ps_document_detail WHERE id_document = '95299' 16/01/2025 10:24:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95299' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '22' , '-22' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '11.00' ) 16/01/2025 10:24:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95299' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '25' , '-25' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '35.00' ) 16/01/2025 10:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 10:30:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '156' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 16/01/2025 10:30:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95300' 16/01/2025 10:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95300' 16/01/2025 10:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95300' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 16/01/2025 10:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95300' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/01/2025 10:56:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253483' AND id_product != '23344' AND ean13 != '' 16/01/2025 10:56:27 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791281253483', date_upd = NOW() WHERE id_product = '23344' 16/01/2025 10:56:27 am >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2025', description = '' WHERE id_product = '23344' 16/01/2025 10:56:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '23344' 16/01/2025 10:56:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23344' 16/01/2025 10:56:27 am >> DELETE FROM ps_specific_price WHERE id_product = '23344' 16/01/2025 10:56:35 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 = '23344' 16/01/2025 10:56:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23345' , '1' , '' , 'nuovo-prodotto' ) 16/01/2025 10:56:35 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 '23345' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23344' 16/01/2025 10:56:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23345' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23344' 16/01/2025 10:59:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557870' AND id_product != '23345' AND ean13 != '' 16/01/2025 10:59:08 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE S. PAOLO', ean13 = '9788831557870', date_upd = NOW() WHERE id_product = '23345' 16/01/2025 10:59:08 am >> UPDATE ps_product_lang SET name = 'PAROLA CREA RELAZIONI - L. GUSELLA', description = '' WHERE id_product = '23345' 16/01/2025 10:59:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '23345' 16/01/2025 10:59:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23345' 16/01/2025 10:59:08 am >> DELETE FROM ps_specific_price WHERE id_product = '23345' 16/01/2025 10:59: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 = '23345' 16/01/2025 10:59:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23346' , '1' , '' , 'nuovo-prodotto' ) 16/01/2025 10:59: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 '23346' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23345' 16/01/2025 10:59:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23346' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23345' 16/01/2025 11:00:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557924' AND id_product != '23346' AND ean13 != '' 16/01/2025 11:00:39 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE S. PAOLO', ean13 = '9788831557924', date_upd = NOW() WHERE id_product = '23346' 16/01/2025 11:00:39 am >> UPDATE ps_product_lang SET name = 'PAROLA SI FA CARNE - L. GUSELLA', description = '' WHERE id_product = '23346' 16/01/2025 11:00:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '23346' 16/01/2025 11:00:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23346' 16/01/2025 11:00:39 am >> DELETE FROM ps_specific_price WHERE id_product = '23346' 16/01/2025 11:03:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '686602' , '2025-01-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.76' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '165.66' , '165.66' , NOW() , NOW() ) 16/01/2025 11:03:01 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 = '95301' 16/01/2025 11:03:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95301' 16/01/2025 11:03: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 ( '95301' , '23344' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2025' , '8' , '8' , '4' , '6.00' , '6' , '0' , '30' , '33.6000' ) 16/01/2025 11:03:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '23344' AND id_supplier = '7' 16/01/2025 11:03:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23344' , '7' , '1' ) 16/01/2025 11:03: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 ( '95301' , '23346' , 'PAROLA SI FA CARNE - L. GUSELLA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '33' , '3.3500' ) 16/01/2025 11:03:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '23346' AND id_supplier = '7' 16/01/2025 11:03:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23346' , '7' , '1' ) 16/01/2025 11:03: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 ( '95301' , '23345' , 'PAROLA CREA RELAZIONI - L. GUSELLA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '33' , '3.3500' ) 16/01/2025 11:03:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '23345' AND id_supplier = '7' 16/01/2025 11:03:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23345' , '7' , '1' ) 16/01/2025 11:03: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 ( '95301' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '36' , '36' , '4' , '5.00' , '5' , '0' , '33' , '120.6000' ) 16/01/2025 11:03:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '7' 16/01/2025 11:03:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '7' , '1' ) 16/01/2025 11:03: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 ( '95301' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '3' , '3' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 16/01/2025 11:03:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '7' 16/01/2025 11:03:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '7' , '1' ) 16/01/2025 11:07:30 am >> SELECT document_num FROM ps_document WHERE document_num = '8/A' AND id_document != '93939' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 16/01/2025 11:07:30 am >> UPDATE ps_document SET id_document_type = '24', document_num = '8/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', address2 = '', note = 'DDT 116/A DEL 29/10/2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '398.25', price_tax_excluded = '398.25', date_upd = NOW() WHERE id_document = '93939' 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93939' 16/01/2025 11:07:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93939' 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11192' , 'VENITE CON ME 2 PARTE' , '22' , '-22' , '4' , '2.8000' , '2.8' , '0' , '15' , '52.36' ) 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '15' , '33.32' ) 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 16/01/2025 11:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5457' , 'IO SONO CON VOI 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 16/01/2025 11:07: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 ( '93939' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 16/01/2025 11:07: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 ( '93939' , '13397' , 'MIO GESU' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 16/01/2025 11:07: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 ( '93939' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '15' , '2.04' ) 16/01/2025 11:07: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 ( '93939' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 16/01/2025 11:07: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 ( '93939' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 16/01/2025 11:07: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 ( '93939' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 16/01/2025 11:07: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 ( '93939' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 16/01/2025 11:07: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 ( '93939' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 16/01/2025 11:08:55 am >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:08:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '7' , '2025-01-16' , '' , '2757' , '0' , '4679344' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '398.25' , '398.25' , NOW() , NOW() ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95302' 16/01/2025 11:08:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95302' 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '11192' , 'VENITE CON ME 2 PARTE' , '22' , '-22' , '4' , '2.8000' , '2.8' , '0' , '15' , '52.36' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '15' , '33.32' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '5457' , 'IO SONO CON VOI 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '13397' , 'MIO GESU' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '15' , '2.04' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 16/01/2025 11:08:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 16/01/2025 11:09:40 am >> DELETE FROM ps_document WHERE id_document = '93939' 16/01/2025 11:09:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93939' 16/01/2025 11:21:58 am >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:21:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '157' , '2025-01-16' , '' , '2757' , '0' , '4679344' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.90' , '77.79' , NOW() , NOW() ) 16/01/2025 11:21:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95303' 16/01/2025 11:21:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95303' 16/01/2025 11:21:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 16/01/2025 11:21:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 16/01/2025 11:21:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '59.0000' , '48.3607' , '22' , '0' , '59.00' ) 16/01/2025 11:22:25 am >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:22:25 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' , '158' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.90' , '87.62' , NOW() , NOW() ) 16/01/2025 11:22:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95304' 16/01/2025 11:22:25 am >> DELETE FROM ps_document_detail WHERE id_document = '95304' 16/01/2025 11:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95304' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405/TPAD' , '1' , '-1' , '1' , '74.00' , '60.655737704918' , '22' , '0' , '74.00' ) 16/01/2025 11:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95304' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 16/01/2025 11:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95304' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 16/01/2025 11:25:13 am >> DELETE FROM ps_document WHERE id_document = '95143' 16/01/2025 11:25:13 am >> DELETE FROM ps_document_detail WHERE id_document = '95143' 16/01/2025 11:28:11 am >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:28: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' , '159' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 16/01/2025 11:28: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 = '95305' 16/01/2025 11:28:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95305' 16/01/2025 11:28: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 ( '95305' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '5' , '-5' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '75.00' ) 16/01/2025 11:28:15 am >> DELETE FROM ps_document WHERE id_document = '95199' 16/01/2025 11:28:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95199' 16/01/2025 11:30:27 am >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '95303' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:30:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '157', document_date = '2025-01-16', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '94.90', price_tax_excluded = '77.79', date_upd = NOW() WHERE id_document = '95303' 16/01/2025 11:30:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95303' 16/01/2025 11:30:27 am >> DELETE FROM ps_document_detail WHERE id_document = '95303' 16/01/2025 11:30:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 16/01/2025 11:30:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 16/01/2025 11:30:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 16/01/2025 11:31:32 am >> SELECT document_num FROM ps_document WHERE document_num = '160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:31:32 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' , '160' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 16/01/2025 11:31:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95306' 16/01/2025 11:31:32 am >> DELETE FROM ps_document_detail WHERE id_document = '95306' 16/01/2025 11:31:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95306' , '21457' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 3,2X60 - 1135' , '2' , '-2' , '1' , '25' , '20.491803278689' , '22' , '0' , '50.00' ) 16/01/2025 11:32:56 am >> SELECT document_num FROM ps_document WHERE document_num = '161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11: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 ( '11' , '161' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.69' , '34.69' , NOW() , NOW() ) 16/01/2025 11: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 = '95307' 16/01/2025 11:32:56 am >> DELETE FROM ps_document_detail WHERE id_document = '95307' 16/01/2025 11: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 ( '95307' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 16/01/2025 11: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 ( '95307' , '22024' , 'TRATTATO DELLA VERA DEVOZIONE - MONTFORT - 8576' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 16/01/2025 11: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 ( '95307' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 16/01/2025 11:32:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95307' , '9396' , 'SAN BONAVENTURA - R. RUSSO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 16/01/2025 11:32:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95307' , '9527' , 'SANTAGNESE - A. GOVERNALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 16/01/2025 11:32:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95307' , '9525' , 'SANTAGATA DA CATANIA - G.ZITO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 16/01/2025 11:40:45 am >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '95304' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:40:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '158', document_date = '2025-01-16', 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 = '106.90', price_tax_excluded = '87.62', date_upd = NOW() WHERE id_document = '95304' 16/01/2025 11:40:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95304' 16/01/2025 11:40:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95304' 16/01/2025 11:40:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95304' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405/TPAD' , '1' , '-1' , '1' , '74.0000' , '60.655737704918' , '22' , '0' , '74.00' ) 16/01/2025 11:40:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95304' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 16/01/2025 11:40:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95304' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '17.9' , '14.672131147541' , '22' , '0' , '17.90' ) 16/01/2025 11:41:05 am >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '95303' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 11:41:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '157', document_date = '2025-01-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '94.90', price_tax_excluded = '77.79', date_upd = NOW() WHERE id_document = '95303' 16/01/2025 11:41:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95303' 16/01/2025 11:41:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95303' 16/01/2025 11:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '17.9' , '14.672131147541' , '22' , '0' , '17.90' ) 16/01/2025 11:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 16/01/2025 11:41:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95303' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 16/01/2025 12:00:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 12:00:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '162' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.89' , '109.08' , NOW() , NOW() ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95308' 16/01/2025 12:00:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '95308' 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '6195' , 'MANUALE DELLE INDULGENZE - N.E.' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '16.65' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '17257' , 'IO TI BATTEZZO ' , '4' , '-4' , '4' , '1.80' , '1.8' , '0' , '5' , '6.84' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '23057' , 'PREGHIERA DEGLI OCCHI APERTI - J. METZ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 16/01/2025 12:00:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '20758' , 'SEGNALIBRO 5X15' , '100' , '-100' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '20.00' ) 16/01/2025 12:00:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '6629' , 'MIA PREGHIERA' , '2' , '-2' , '4' , '0.90' , '0.9' , '0' , '0' , '1.80' ) 16/01/2025 12:00:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95308' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 16/01/2025 12:50:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 12:50:23 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' , '163' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 16/01/2025 12:50:23 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 = '95309' 16/01/2025 12:50:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '95309' 16/01/2025 12:50:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95309' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 16/01/2025 12:50:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 16/01/2025 12:50: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' , '164' , '2025-01-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '24.70' , NOW() , NOW() ) 16/01/2025 12:50: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 = '95310' 16/01/2025 12:50:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '95310' 16/01/2025 12:50: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 ( '95310' , '23133' , 'ARTE DELLA PAROLA - K. RAHNER' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 16/01/2025 12:50: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 ( '95310' , '22747' , 'MISTERO UOMO - W. KASPER' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 16/01/2025 03:06:19 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/01/2025 03:06:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23347' , '1' , '' , 'nuovo-prodotto' ) 16/01/2025 03:06:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23347' , '1' , '1' , '2' , NOW() , NOW() ) 16/01/2025 03:06:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23347' , '0' , '1' , '0' , '0' ) 16/01/2025 03:10:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736468' AND id_product != '23347' AND ean13 != '' 16/01/2025 03:10:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280736468', date_upd = NOW() WHERE id_product = '23347' 16/01/2025 03:10:33 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DEL ROSARIO', description = '
il Rosario, da sempre considerato una preghiera popolare dedicata alla Vergine, è molto di più: è la celebrazione di Cristo e dei testi biblici, una preghiera di lode e di intercessione.
E\' una preghiera molto antica. essa deriva dal bisogno di esprimere la propria devozione alla Madonna e di interiorizzare ciò che viene espresso attraverso le parole.
' WHERE id_product = '23347' 16/01/2025 03:10:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '23347' 16/01/2025 03:10:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '28', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23347' 16/01/2025 03:10:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '23347' 16/01/2025 03:10:33 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' , '23347' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 16/01/2025 03:10:34 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23347' 16/01/2025 03:10:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23348' , '1' , '' , 'nuovo-prodotto' ) 16/01/2025 03:10:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23348' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23347' 16/01/2025 03:10:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23348' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23347' 16/01/2025 03:11:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736451' AND id_product != '23348' AND ean13 != '' 16/01/2025 03:11:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280736451', date_upd = NOW() WHERE id_product = '23348' 16/01/2025 03:11:32 pm >> UPDATE ps_product_lang SET name = 'ECCE LIGNUM CRUCIS - V. SIRACUSA', description = '' WHERE id_product = '23348' 16/01/2025 03:11:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23348' 16/01/2025 03:11:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', 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 = '23348' 16/01/2025 03:11:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '23348' 16/01/2025 03:11:32 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' , '23348' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 16/01/2025 03:15:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736451' AND id_product != '23348' AND ean13 != '' 16/01/2025 03:15:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280736451', date_upd = NOW() WHERE id_product = '23348' 16/01/2025 03:15:36 pm >> UPDATE ps_product_lang SET name = 'ECCE LIGNUM CRUCIS - V. SIRACUSA', description = '\"Signore Gesù, il venerdì santo è il giorno dell\'odio senza ragione, il giorno dell\'uccisione del Giusto!
Ma il Venerdì santo non è l\'ultima parola, è la Pasqua il trionfo della vita, la vittoria del bene sul male\".
Card. Angelo Comastri