29/09/2023 09:10:20 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' , '642178' , '2023-09-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0.20' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '6.25' , '6.25' , NOW() , NOW() ) 29/09/2023 09:10:20 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 = '87467' 29/09/2023 09:10:20 am >> DELETE FROM ps_document_detail WHERE id_document = '87467' 29/09/2023 09:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87467' , '21395' , 'CONVERTIRE LA CATECHESI - AAVV' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35+7' , '6.0450' ) 29/09/2023 09:10:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21395' AND id_supplier = '7' 29/09/2023 09:10:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21395' , '7' , '1' ) 29/09/2023 09:21:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2909' AND id_document != '87409' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-25') 29/09/2023 09:21:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2909', document_date = '2023-09-25', 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 = '200.00', price_tax_excluded = '166.81', date_upd = NOW() WHERE id_document = '87409' 29/09/2023 09:21:07 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 = '87409' 29/09/2023 09:21:07 am >> DELETE FROM ps_document_detail WHERE id_document = '87409' 29/09/2023 09:21:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87409' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 29/09/2023 09:21:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87409' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/09/2023 09:21:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87409' , '18166' , 'RELIQUIARIO CON PIETRE H 23' , '1' , '-1' , '1' , '184.08' , '150.88524590164' , '22' , '0' , '184.08' ) 29/09/2023 09:21:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87409' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '8' , '7.36' ) 29/09/2023 09:26:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 09:26:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2954' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 29/09/2023 09:26:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87468' 29/09/2023 09:26:51 am >> DELETE FROM ps_document_detail WHERE id_document = '87468' 29/09/2023 09:26:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87468' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 29/09/2023 09:37:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 09:37:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2955' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 29/09/2023 09:37:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87469' 29/09/2023 09:37:47 am >> DELETE FROM ps_document_detail WHERE id_document = '87469' 29/09/2023 09:37:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87469' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 29/09/2023 09:39:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068580' AND id_product != '21590' AND ean13 != '' 29/09/2023 09:39:24 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/1', ean13 = '9788801068580', date_upd = NOW() WHERE id_product = '21590' 29/09/2023 09:39:24 am >> UPDATE ps_product_lang SET name = 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE', description = '' WHERE id_product = '21590' 29/09/2023 09:39:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.0000' WHERE id_product = '21590' 29/09/2023 09:39:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21590' 29/09/2023 09:39:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21590' 29/09/2023 09:43:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/09/2023 09:43:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21609' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 09:43:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21609' , '1' , '1' , '2' , NOW() , NOW() ) 29/09/2023 09:43:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21609' , '0' , '1' , '0' , '0' ) 29/09/2023 09:45:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253476' AND id_product != '21609' AND ean13 != '' 29/09/2023 09:45:35 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE GIREVOLE', ean13 = '9791281253476', date_upd = NOW() WHERE id_product = '21609' 29/09/2023 09:45:35 am >> UPDATE ps_product_lang SET name = 'CARLO ACUTIS - OMELIA - A. COMASTRI', description = '' WHERE id_product = '21609' 29/09/2023 09:45:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '21609' 29/09/2023 09:45:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21609' 29/09/2023 09:45:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21609' 29/09/2023 09:48:26 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21609' 29/09/2023 09:48:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21610' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 09:48:26 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21610' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21609' 29/09/2023 09:48:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21610' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21609' 29/09/2023 09:49:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242715' AND id_product != '21610' AND ean13 != '' 29/09/2023 09:49:22 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788892242715', date_upd = NOW() WHERE id_product = '21610' 29/09/2023 09:49:22 am >> UPDATE ps_product_lang SET name = 'PAROLA VICINA 2023/2024 ANNO B', description = '' WHERE id_product = '21610' 29/09/2023 09:49:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21610' 29/09/2023 09:49:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21610' 29/09/2023 09:49:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21610' 29/09/2023 09:50:10 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' , '642179' , '2023-09-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.26' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '193.23' , '187.29' , NOW() , NOW() ) 29/09/2023 09:50:10 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 = '87470' 29/09/2023 09:50:10 am >> DELETE FROM ps_document_detail WHERE id_document = '87470' 29/09/2023 09:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87470' , '21594' , 'CARTONCINO 16X23' , '30' , '30' , '1' , '0.10' , '0.081967213114754' , '22' , '0' , '3.6600' ) 29/09/2023 09:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21594' AND id_supplier = '7' 29/09/2023 09:50:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21594' , '7' , '1' ) 29/09/2023 09:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87470' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '96' , '96' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '29.2800' ) 29/09/2023 09:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21597' AND id_supplier = '7' 29/09/2023 09:50:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21597' , '7' , '1' ) 29/09/2023 09:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87470' , '21590' , 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 29/09/2023 09:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21590' AND id_supplier = '7' 29/09/2023 09:50:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21590' , '7' , '1' ) 29/09/2023 09:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87470' , '16185' , 'DON BOSCO UN SACERDOTE' , '12' , '12' , '4' , '5.00' , '5' , '0' , '30' , '42.0000' ) 29/09/2023 09:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16185' AND id_supplier = '7' 29/09/2023 09:50:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16185' , '7' , '1' ) 29/09/2023 09:50:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87470' , '16185' , 'DON BOSCO UN SACERDOTE' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 29/09/2023 09:50:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16185' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16185' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '21609' , 'CARLO ACUTIS - OMELIA - A. COMASTRI' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '30' , '5.2500' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21609' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21609' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '4151' , 'FERIE DEL T. O. - LECTIO BREVIS DISPARI 2' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '4151' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4151' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '21199' , 'AMEN - OTT 23' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '17024' , 'PICCOLO PRINCICE - A. DE S. EXUPERY' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33' , '8.7100' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '17024' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17024' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '21205' , 'MI AMI TU? - CD' , '1' , '1' , '4' , '16.80' , '16.8' , '0' , '30' , '11.7600' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21205' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21205' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '21392' , 'BIBBIA - EDIZIONE SOFT' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21392' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21392' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '8' , '8' , '4' , '9.90' , '9.9' , '0' , '33' , '53.0640' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21610' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21610' , '7' , '1' ) 29/09/2023 09:50: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 ( '87470' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '2' , '2' , '4' , '9.90' , '9.9' , '0' , '100' , '0.0000' ) 29/09/2023 09:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21610' AND id_supplier = '7' 29/09/2023 09:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21610' , '7' , '1' ) 29/09/2023 10:10:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 10:10:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2956' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.89' , '114.89' , NOW() , NOW() ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87471' 29/09/2023 10:10:28 am >> DELETE FROM ps_document_detail WHERE id_document = '87471' 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '16326' , 'ESSENZIALE PER IL CATECHISMO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '21395' , 'CONVERTIRE LA CATECHESI - AAVV' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '21590' , 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '21517' , 'APRIRSI TEMPO DELLA PRIMA EVANGELIZZAZIONE - SCHEDE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '18432' , 'SETTE SACRAMENTI ' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '15815' , 'GLOSSARIO PER IL CATECHISMO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '18729' , 'GIOCHI PER IL CATECHISMO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '16077' , 'CELEBRAZIONI PER IL CATECHISMO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 29/09/2023 10:10:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87471' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 29/09/2023 10:12:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 10:12:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2957' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 29/09/2023 10:12:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87472' 29/09/2023 10:12:29 am >> DELETE FROM ps_document_detail WHERE id_document = '87472' 29/09/2023 10:12:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87472' , '21098' , 'BRACCIALE DECINA PIETRA - BC1885' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/09/2023 11:33:47 am >> SELECT document_num FROM ps_document WHERE document_num = '125' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 11:33:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '125' , '2023-09-29' , '' , '3380' , '0' , '4671703' , 'P. ZZA SAN PIETRO, SNC 00039 ZAGAROLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '341.71' , '341.71' , NOW() , NOW() ) 29/09/2023 11:33:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87473' 29/09/2023 11:33:47 am >> DELETE FROM ps_document_detail WHERE id_document = '87473' 29/09/2023 11:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87473' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '28' , '-28' , '4' , '3.50' , '3.5' , '0' , '15' , '83.30' ) 29/09/2023 11:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87473' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '21' , '-21' , '4' , '3.50' , '3.5' , '0' , '15' , '62.48' ) 29/09/2023 11:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87473' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '55' , '-55' , '4' , '3.50' , '3.5' , '0' , '15' , '163.63' ) 29/09/2023 11:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87473' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 29/09/2023 11:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87473' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '4' , '1.00' , '1' , '0' , '15' , '6.80' ) 29/09/2023 11:58:05 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3434' 29/09/2023 11:58:05 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3434' , '10' , '208' , 'C/O MADRI CANOSSIANE' , 'VESPOLI' , 'DON CIRO' , 'BORGO SAN MARTINO 9' , '' , '00039' , 'ZAGAROLO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 29/09/2023 11:58:05 am >> UPDATE ps_customer SET email = 'cirovespoli@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3434' 29/09/2023 12:11:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '94/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 12:11:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '94/A' , '2023-09-29' , 'A' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1885.00' , '1545.08' , NOW() , NOW() ) 29/09/2023 12:11:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87474' 29/09/2023 12:11:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '87474' 29/09/2023 12:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87474' , '12817' , 'LIBRO DEI MATRIMONI' , '24' , '-24' , '1' , '40.00' , '32.786885245902' , '22' , '35' , '624.00' ) 29/09/2023 12:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87474' , '12814' , 'LIBRO DEI BATTEZZATI' , '24' , '-24' , '1' , '40.00' , '32.786885245902' , '22' , '35' , '624.00' ) 29/09/2023 12:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87474' , '12849' , 'LIBRO DELLE SS. MESSE' , '20' , '-20' , '1' , '20.00' , '16.393442622951' , '22' , '35' , '260.00' ) 29/09/2023 12:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87474' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '20' , '-20' , '1' , '12.00' , '9.8360655737705' , '22' , '35' , '156.00' ) 29/09/2023 12:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87474' , '12819' , 'REGISTRO DEL CATECHISTA ' , '340' , '-340' , '1' , '1.00' , '0.81967213114754' , '22' , '35' , '221.00' ) 29/09/2023 02:11:24 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'qvTDqmgAnrvvOtk1' , NOW() , NOW() ) 29/09/2023 02:11:24 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4029' , '1' ) 29/09/2023 02:11:24 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4029' , '2' ) 29/09/2023 02:11:24 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4029' , '3' ) 29/09/2023 02:11:37 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/09/2023 02:11:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21611' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:11:37 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21611' , '1' , '1' , '2' , NOW() , NOW() ) 29/09/2023 02:11:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21611' , '0' , '1' , '0' , '0' ) 29/09/2023 02:12:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1524D' AND id_product != '21611' AND ean13 != '' 29/09/2023 02:12:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1524D', date_upd = NOW() WHERE id_product = '21611' 29/09/2023 02:12:32 pm >> UPDATE ps_product_lang SET name = 'ROSARIO IMITAZIONE PERLA - 1524D', description = '' WHERE id_product = '21611' 29/09/2023 02:12:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.459016393442623' WHERE id_product = '21611' 29/09/2023 02:12:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '95', 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 = '21611' 29/09/2023 02:12:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21611' 29/09/2023 02:13:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '95/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 02:13:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '95/A' , '2023-09-29' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '503.10' , '412.38' , NOW() , NOW() ) 29/09/2023 02:13:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87475' 29/09/2023 02:13:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '87475' 29/09/2023 02:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87475' , '21611' , 'ROSARIO IMITAZIONE PERLA - 1524D' , '156' , '-156' , '1' , '2.85' , '2.3360655737705' , '22' , '0' , '444.60' ) 29/09/2023 02:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87475' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 29/09/2023 02:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87475' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 29/09/2023 02:18:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'A3681' , '2023-09-28' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '248.20' , '203.44' , NOW() , NOW() ) 29/09/2023 02:18:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87476' 29/09/2023 02:18:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87476' 29/09/2023 02:18: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 ( '87476' , '21611' , 'ROSARIO IMITAZIONE PERLA - 1524D' , '156' , '156' , '1' , '1.24' , '1.016393442623' , '22' , '0' , '235.9968' ) 29/09/2023 02:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21611' AND id_supplier = '28' 29/09/2023 02:18:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21611' , '28' , '1' ) 29/09/2023 02:19:35 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/09/2023 02:19:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21612' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:19:36 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21612' , '1' , '1' , '2' , NOW() , NOW() ) 29/09/2023 02:19:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21612' , '0' , '1' , '0' , '0' ) 29/09/2023 02:21:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500044' AND id_product != '21612' AND ean13 != '' 29/09/2023 02:21:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9791281500044', date_upd = NOW() WHERE id_product = '21612' 29/09/2023 02:21:26 pm >> UPDATE ps_product_lang SET name = 'RITO DELLE ESEQUIE - ED. MIN.- N.E.', description = '' WHERE id_product = '21612' 29/09/2023 02:21:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '21612' 29/09/2023 02:21:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21612' 29/09/2023 02:21:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '21612' 29/09/2023 02:21:28 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 = '21612' 29/09/2023 02:21:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21613' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:21:28 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 '21613' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21612' 29/09/2023 02:21:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21613' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21612' 29/09/2023 02:22:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500051' AND id_product != '21613' AND ean13 != '' 29/09/2023 02:22:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9791281500051', date_upd = NOW() WHERE id_product = '21613' 29/09/2023 02:22:05 pm >> UPDATE ps_product_lang SET name = 'RITO DELLA CONFERMAZIONE N.E.', description = '' WHERE id_product = '21613' 29/09/2023 02:22:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21613' 29/09/2023 02:22:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21613' 29/09/2023 02:22:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '21613' 29/09/2023 02:22:09 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 = '21613' 29/09/2023 02:22:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21614' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:22:09 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 '21614' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21613' 29/09/2023 02:22:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21614' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21613' 29/09/2023 02:22:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500006' AND id_product != '21614' AND ean13 != '' 29/09/2023 02:22:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281500006', date_upd = NOW() WHERE id_product = '21614' 29/09/2023 02:22:51 pm >> UPDATE ps_product_lang SET name = 'RITO DEL BATTESIMO DEI BAMBINI N.E.', description = '' WHERE id_product = '21614' 29/09/2023 02:22:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21614' 29/09/2023 02:22:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21614' 29/09/2023 02:22:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '21614' 29/09/2023 02:22:52 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 = '21614' 29/09/2023 02:22:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21615' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:22:52 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 '21615' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21614' 29/09/2023 02:22:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21615' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21614' 29/09/2023 02:23:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500013' AND id_product != '21615' AND ean13 != '' 29/09/2023 02:23:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9791281500013', date_upd = NOW() WHERE id_product = '21615' 29/09/2023 02:23:39 pm >> UPDATE ps_product_lang SET name = 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.', description = '' WHERE id_product = '21615' 29/09/2023 02:23:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21615' 29/09/2023 02:23:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21615' 29/09/2023 02:23:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '21615' 29/09/2023 02:23:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500013' AND id_product != '21615' AND ean13 != '' 29/09/2023 02:23:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9791281500013', date_upd = NOW() WHERE id_product = '21615' 29/09/2023 02:23:58 pm >> UPDATE ps_product_lang SET name = 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.', description = '' WHERE id_product = '21615' 29/09/2023 02:23:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21615' 29/09/2023 02:23:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21615' 29/09/2023 02:23:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '21615' 29/09/2023 02:23:59 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 = '21615' 29/09/2023 02:23:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21616' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:23:59 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 '21616' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21615' 29/09/2023 02:23:59 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21616' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21615' 29/09/2023 02:25:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788849848038' AND id_product != '21616' AND ean13 != '' 29/09/2023 02:25:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788849848038', date_upd = NOW() WHERE id_product = '21616' 29/09/2023 02:25:39 pm >> UPDATE ps_product_lang SET name = 'CARTEGGIO 1925-1926', description = '' WHERE id_product = '21616' 29/09/2023 02:25:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29' WHERE id_product = '21616' 29/09/2023 02:25:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29', id_tax_rules_group = '4', id_category_default = '173', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21616' 29/09/2023 02:25:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '21616' 29/09/2023 02:25:40 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 = '21616' 29/09/2023 02:25:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21617' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:25:40 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 '21617' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21616' 29/09/2023 02:25:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21617' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21616' 29/09/2023 02:26:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254712122' AND id_product != '21617' AND ean13 != '' 29/09/2023 02:26:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9791254712122', date_upd = NOW() WHERE id_product = '21617' 29/09/2023 02:26:44 pm >> UPDATE ps_product_lang SET name = 'SINFONIA DELLA PAROLA - F. MANNS', description = '' WHERE id_product = '21617' 29/09/2023 02:26:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21617' 29/09/2023 02:26:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21617' 29/09/2023 02:26:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '21617' 29/09/2023 02:26:46 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 = '21617' 29/09/2023 02:26:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21618' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:26:46 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 '21618' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21617' 29/09/2023 02:26:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21618' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21617' 29/09/2023 02:27:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855450881' AND id_product != '21618' AND ean13 != '' 29/09/2023 02:27:35 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788855450881', date_upd = NOW() WHERE id_product = '21618' 29/09/2023 02:27:35 pm >> UPDATE ps_product_lang SET name = 'TRASMETTERE LA FEDE - SALZNO/ACUTIS', description = '' WHERE id_product = '21618' 29/09/2023 02:27:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21618' 29/09/2023 02:27:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '77', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21618' 29/09/2023 02:27:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '21618' 29/09/2023 02:27:36 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 = '21618' 29/09/2023 02:27:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21619' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:27:36 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 '21619' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21618' 29/09/2023 02:27:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21619' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21618' 29/09/2023 02:28:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788828212928' AND id_product != '21619' AND ean13 != '' 29/09/2023 02:28:42 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788828212928', date_upd = NOW() WHERE id_product = '21619' 29/09/2023 02:28:42 pm >> UPDATE ps_product_lang SET name = 'IO AVRO\' CURA DI TE - PAPA FRANCESCO', description = '' WHERE id_product = '21619' 29/09/2023 02:28:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.5' WHERE id_product = '21619' 29/09/2023 02:28:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.5', id_tax_rules_group = '4', id_category_default = '452', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21619' 29/09/2023 02:28:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '21619' 29/09/2023 02:28:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21619' 29/09/2023 02:28:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21620' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 02:28:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21620' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21619' 29/09/2023 02:28:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21620' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21619' 29/09/2023 02:31:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '01093002' , '2023-09-28' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '191.40' , '191.40' , NOW() , NOW() ) 29/09/2023 02:31:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87477' 29/09/2023 02:31:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '87477' 29/09/2023 02:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87477' , '21617' , 'SINFONIA DELLA PAROLA - F. MANNS' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 29/09/2023 02:31:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21617' AND id_supplier = '109' 29/09/2023 02:31:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21617' , '109' , '1' ) 29/09/2023 02:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87477' , '21618' , 'TRASMETTERE LA FEDE - SALZNO/ACUTIS' , '2' , '2' , '4' , '14.00' , '14' , '0' , '0' , '28.0000' ) 29/09/2023 02:31:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21618' AND id_supplier = '109' 29/09/2023 02:31:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21618' , '109' , '1' ) 29/09/2023 02:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87477' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '2' , '4' , '29.00' , '29' , '0' , '0' , '58.0000' ) 29/09/2023 02:31:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21616' AND id_supplier = '109' 29/09/2023 02:31:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21616' , '109' , '1' ) 29/09/2023 02:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87477' , '21619' , 'IO AVRO CURA DI TE - PAPA FRANCESCO' , '1' , '1' , '4' , '14.50' , '14.5' , '0' , '0' , '14.50' ) 29/09/2023 02:31:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21619' AND id_supplier = '109' 29/09/2023 02:31:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21619' , '109' , '1' ) 29/09/2023 02:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87477' , '8769' , 'RACCONTA LA BIBBIA AI TUOI RAGAZZI' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '0' , '14.90' ) 29/09/2023 02:31:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8769' AND id_supplier = '109' 29/09/2023 02:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8769' , '109' , '1' ) 29/09/2023 02:31: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 ( '87477' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '2' , '2' , '4' , '12.50' , '12.5' , '0' , '0' , '25.0000' ) 29/09/2023 02:31:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21475' AND id_supplier = '109' 29/09/2023 02:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21475' , '109' , '1' ) 29/09/2023 02:31: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 ( '87477' , '21476' , 'QUESTA CASA E TUA 3 - 12/14 ANNI' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '0' , '33.0000' ) 29/09/2023 02:31:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21476' AND id_supplier = '109' 29/09/2023 02:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21476' , '109' , '1' ) 29/09/2023 03:26:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861081420' AND id_product != '21620' AND ean13 != '' 29/09/2023 03:26:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788861081420', date_upd = NOW() WHERE id_product = '21620' 29/09/2023 03:26:48 pm >> UPDATE ps_product_lang SET name = 'EVVIVA LA PRIMA COMUNIONE - P. PELLEGRINO', description = '' WHERE id_product = '21620' 29/09/2023 03:26:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.8' WHERE id_product = '21620' 29/09/2023 03:26:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.8', id_tax_rules_group = '4', id_category_default = '15', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21620' 29/09/2023 03:26:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21620' 29/09/2023 03:26:49 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 = '21620' 29/09/2023 03:26:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21621' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 03:26:49 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 '21621' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21620' 29/09/2023 03:26:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21621' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21620' 29/09/2023 03:28:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881991822' AND id_product != '21621' AND ean13 != '' 29/09/2023 03:28:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788881991822', date_upd = NOW() WHERE id_product = '21621' 29/09/2023 03:28:52 pm >> UPDATE ps_product_lang SET name = 'CALENDARIO FRATE INDOVINO 2024', description = '' WHERE id_product = '21621' 29/09/2023 03:28:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21621' 29/09/2023 03:28:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '219', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21621' 29/09/2023 03:28:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21621' 29/09/2023 03:28:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21621' 29/09/2023 03:28:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21622' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 03:28:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21622' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21621' 29/09/2023 03:28:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21622' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21621' 29/09/2023 03:30:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577119' AND id_product != '21622' AND ean13 != '' 29/09/2023 03:30:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788873577119', date_upd = NOW() WHERE id_product = '21622' 29/09/2023 03:30:38 pm >> UPDATE ps_product_lang SET name = 'INVITO ALLA PREGHIERA - O. DE BERTOLIS', description = '' WHERE id_product = '21622' 29/09/2023 03:30:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21622' 29/09/2023 03:30:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21622' 29/09/2023 03:30:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '21622' 29/09/2023 03:30:39 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 = '21622' 29/09/2023 03:30:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21623' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 03:30:39 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 '21623' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21622' 29/09/2023 03:30:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21623' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21622' 29/09/2023 03:31:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577072' AND id_product != '21623' AND ean13 != '' 29/09/2023 03:31:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788873577072', date_upd = NOW() WHERE id_product = '21623' 29/09/2023 03:31:22 pm >> UPDATE ps_product_lang SET name = 'VIDE CHE TUTTO ERA BUONO - R. COLIZZI', description = '' WHERE id_product = '21623' 29/09/2023 03:31:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21623' 29/09/2023 03:31:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21623' 29/09/2023 03:31:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '21623' 29/09/2023 03:31:22 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 = '21623' 29/09/2023 03:31:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21624' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 03:31:22 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 '21624' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21623' 29/09/2023 03:31:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21624' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21623' 29/09/2023 03:32:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577102' AND id_product != '21624' AND ean13 != '' 29/09/2023 03:32:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788873577102', date_upd = NOW() WHERE id_product = '21624' 29/09/2023 03:32:11 pm >> UPDATE ps_product_lang SET name = 'SCRITTI AUTOBIOGRAFICI - M. M. ALACOQUE', description = '' WHERE id_product = '21624' 29/09/2023 03:32:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21624' 29/09/2023 03:32:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21624' 29/09/2023 03:32:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '21624' 29/09/2023 03:32:12 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 = '21624' 29/09/2023 03:32:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21625' , '1' , '' , 'nuovo-prodotto' ) 29/09/2023 03:32:12 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 '21625' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21624' 29/09/2023 03:32:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21625' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21624' 29/09/2023 03:38:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000004868' , '2023-09-28' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '7' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '234.50' , '234.50' , NOW() , NOW() ) 29/09/2023 03:38:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87478' 29/09/2023 03:38:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '87478' 29/09/2023 03:38:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21623' , 'VIDE CHE TUTTO ERA BUONO - R. COLIZZI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 29/09/2023 03:38:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21623' AND id_supplier = '107' 29/09/2023 03:38:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21623' , '107' , '1' ) 29/09/2023 03:38:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21624' , 'SCRITTI AUTOBIOGRAFICI - M. M. ALACOQUE' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 29/09/2023 03:38:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21624' AND id_supplier = '107' 29/09/2023 03:38:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21624' , '107' , '1' ) 29/09/2023 03:38:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21622' , 'INVITO ALLA PREGHIERA - O. DE BERTOLIS' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 29/09/2023 03:38:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21622' AND id_supplier = '107' 29/09/2023 03:38:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21622' , '107' , '1' ) 29/09/2023 03:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 29/09/2023 03:38:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21621' AND id_supplier = '107' 29/09/2023 03:38:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21621' , '107' , '1' ) 29/09/2023 03:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21620' , 'EVVIVA LA PRIMA COMUNIONE - P. PELLEGRINO' , '50' , '50' , '4' , '4.80' , '4.8' , '0' , '35' , '156.0000' ) 29/09/2023 03:38:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21620' AND id_supplier = '107' 29/09/2023 03:38:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21620' , '107' , '1' ) 29/09/2023 03:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 29/09/2023 03:38:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17385' AND id_supplier = '107' 29/09/2023 03:38:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17385' , '107' , '1' ) 29/09/2023 03:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21465' , 'AGIRE SACRAMENTALE - P. CASPANI' , '2' , '2' , '4' , '18.50' , '18.5' , '0' , '35' , '24.0500' ) 29/09/2023 03:38:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21465' AND id_supplier = '107' 29/09/2023 03:38:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21465' , '107' , '1' ) 29/09/2023 03:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87478' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 29/09/2023 03:38:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21467' AND id_supplier = '107' 29/09/2023 03:38:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21467' , '107' , '1' ) 29/09/2023 03:41:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 29/09/2023 03:41:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.90', price_tax_excluded = '19.90', date_upd = NOW() WHERE id_document = '81317' 29/09/2023 03:41: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 = '81317' 29/09/2023 03:41:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 29/09/2023 03:41:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 29/09/2023 03:41:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 29/09/2023 04:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '87461' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-09-28') 29/09/2023 04:06:16 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '38', document_date = '2023-09-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670971', address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO', address2 = '', note = 'MACERO', 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 = '1922.87', price_tax_excluded = '1725.58', date_upd = NOW() WHERE id_document = '87461' 29/09/2023 04:06:16 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 = '87461' 29/09/2023 04:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '87461' 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '8710' , 'QUANDO PREGATE DITE...' , '111' , '-111' , '4' , '0.5500' , '0.55' , '0' , '0' , '61.05' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '67' , '-67' , '4' , '0.5000' , '0.5' , '0' , '0' , '33.50' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '5457' , 'IO SONO CON VOI 1 PARTE' , '350' , '-350' , '4' , '0.5500' , '0.55' , '0' , '0' , '192.50' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '5458' , 'IO SONO CON VOI 2 PARTE' , '340' , '-340' , '4' , '0.5500' , '0.55' , '0' , '0' , '187.00' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '11191' , 'VENITE CON ME 1 PARTE' , '310' , '-310' , '4' , '0.5500' , '0.55' , '0' , '0' , '170.50' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '11192' , 'VENITE CON ME 2 PARTE' , '335' , '-335' , '4' , '0.5500' , '0.55' , '0' , '0' , '184.25' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '12849' , 'LIBRO DELLE SS. MESSE' , '35' , '-35' , '1' , '1.95' , '1.5983606557377' , '22' , '0' , '68.25' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '12817' , 'LIBRO DEI MATRIMONI' , '48' , '-48' , '1' , '8.34' , '6.8360655737705' , '22' , '0' , '400.32' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '12814' , 'LIBRO DEI BATTEZZATI' , '50' , '-50' , '1' , '8.34' , '6.8360655737705' , '22' , '0' , '417.00' ) 29/09/2023 04:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87461' , '12816' , 'LIBRO DEI DEFUNTI' , '25' , '-25' , '1' , '8.34' , '6.8360655737705' , '22' , '' , '208.50' ) 29/09/2023 04:11:18 pm >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '6988' 29/09/2023 04:11:45 pm >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '6904' 29/09/2023 04:23:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 04:23: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' , '2958' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 29/09/2023 04:23: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 = '87479' 29/09/2023 04:23:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '87479' 29/09/2023 04:23: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 ( '87479' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 29/09/2023 04:26:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '002687' , '2023-09-29' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '409.50' , '409.50' , NOW() , NOW() ) 29/09/2023 04:26:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87480' 29/09/2023 04:26:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '87480' 29/09/2023 04:26:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87480' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 29/09/2023 04:26:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 29/09/2023 04:26:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 29/09/2023 04:26:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87480' , '21613' , 'RITO DELLA CONFERMAZIONE N.E.' , '10' , '10' , '4' , '20.00' , '20' , '0' , '35' , '130.0000' ) 29/09/2023 04:26:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21613' AND id_supplier = '79' 29/09/2023 04:26:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21613' , '79' , '1' ) 29/09/2023 04:26:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87480' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '10' , '10' , '4' , '20.00' , '20' , '0' , '35' , '130.0000' ) 29/09/2023 04:26:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 29/09/2023 04:26:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 29/09/2023 04:26:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87480' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '10' , '10' , '4' , '20.00' , '20' , '0' , '35' , '130.0000' ) 29/09/2023 04:26:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21615' AND id_supplier = '79' 29/09/2023 04:26:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21615' , '79' , '1' ) 29/09/2023 04:31:12 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '2631', document_date = '2023-09-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '364.75', price_tax_excluded = '364.75', date_upd = NOW() WHERE id_document = '87440' 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87440' 29/09/2023 04:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '87440' 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '2' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '45' , '8.25' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '1' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 29/09/2023 04:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '1' , '4' , '90.00' , '90' , '0' , '35' , '58.5000' ) 29/09/2023 04:32:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2023-fv001432' , '2023-09-29' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '26.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2591.15' , '2591.15' , NOW() , NOW() ) 29/09/2023 04:32:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87481' 29/09/2023 04:32:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '87481' 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '21.00' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21510' , 'CROCIFISSO DI FRANCESCO DASSISI - C. VALENZIANO' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '45' , '12.10' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21510' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21510' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21511' , 'INSTRUMENTUM LABORIS - SINODO' , '3' , '0' , '4' , '8.0000' , '8' , '0' , '45' , '13.20' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21511' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21511' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '45' , '2.75' ) 29/09/2023 04:32:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13418' AND id_supplier = '79' 29/09/2023 04:32:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13418' , '79' , '1' ) 29/09/2023 04:32:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '8.25' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21512' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21512' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21513' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21513' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21513' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5444' , 'IO SONO CON VOI - CAT.' , '200' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '770.00' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '11193' , 'VENITE CON ME CAT.' , '150' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '577.50' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '8.25' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21512' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21512' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 29/09/2023 04:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 29/09/2023 04:32:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 29/09/2023 04:32:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 29/09/2023 04:32:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 29/09/2023 04:32:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 29/09/2023 04:32:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 29/09/2023 04:32:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 29/09/2023 04:32:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 29/09/2023 04:32:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 29/09/2023 04:32:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21613' , 'RITO DELLA CONFERMAZIONE N.E.' , '10' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '130.00' ) 29/09/2023 04:32:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21613' AND id_supplier = '79' 29/09/2023 04:32:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21613' , '79' , '1' ) 29/09/2023 04:32:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '10' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '130.00' ) 29/09/2023 04:32:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 29/09/2023 04:32:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 29/09/2023 04:32:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '10' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '130.00' ) 29/09/2023 04:32:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21615' AND id_supplier = '79' 29/09/2023 04:32:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21615' , '79' , '1' ) 29/09/2023 04:55:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 04:55:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2959' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 29/09/2023 04:55:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87482' 29/09/2023 04:55:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '87482' 29/09/2023 04:55:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87482' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 29/09/2023 05:03:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 05:03:34 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' , '2960' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 29/09/2023 05:03:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87483' 29/09/2023 05:03:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '87483' 29/09/2023 05:03:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87483' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/09/2023 05:27:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2961' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 05:27:28 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' , '2961' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.77' , NOW() , NOW() ) 29/09/2023 05:27:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87484' 29/09/2023 05:27:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '87484' 29/09/2023 05:27:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87484' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 29/09/2023 05:29:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 05:29:05 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' , '2962' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '340.00' , '292.54' , NOW() , NOW() ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87485' 29/09/2023 05:29:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '87485' 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3' , '4.1346153846154' , '4' , '0' , '4.30' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 29/09/2023 05:29:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87485' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/09/2023 05:29: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 ( '87485' , '17078' , 'STATUA MIRACOLOSA CM 40 - 803' , '1' , '-1' , '1' , '76.7' , '62.868852459016' , '22' , '0' , '76.70' ) 29/09/2023 05:35:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2023010001825' , '2023-09-29' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '7.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '234.50' , '234.50' , NOW() , NOW() ) 29/09/2023 05:35:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87486' 29/09/2023 05:35:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '87486' 29/09/2023 05:35:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21623' , 'VIDE CHE TUTTO ERA BUONO - R. COLIZZI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 29/09/2023 05:35:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21623' AND id_supplier = '107' 29/09/2023 05:35:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21623' , '107' , '1' ) 29/09/2023 05:35:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21624' , 'SCRITTI AUTOBIOGRAFICI - M. M. ALACOQUE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 29/09/2023 05:35:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21624' AND id_supplier = '107' 29/09/2023 05:35:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21624' , '107' , '1' ) 29/09/2023 05:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21622' , 'INVITO ALLA PREGHIERA - O. DE BERTOLIS' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 29/09/2023 05:35:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21622' AND id_supplier = '107' 29/09/2023 05:35:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21622' , '107' , '1' ) 29/09/2023 05:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 29/09/2023 05:35:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21621' AND id_supplier = '107' 29/09/2023 05:35:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21621' , '107' , '1' ) 29/09/2023 05:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21620' , 'EVVIVA LA PRIMA COMUNIONE - P. PELLEGRINO' , '50' , '0' , '4' , '4.8000' , '4.8' , '0' , '35' , '156.00' ) 29/09/2023 05:35:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21620' AND id_supplier = '107' 29/09/2023 05:35:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21620' , '107' , '1' ) 29/09/2023 05:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 29/09/2023 05:35:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17385' AND id_supplier = '107' 29/09/2023 05:35:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17385' , '107' , '1' ) 29/09/2023 05:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21465' , 'AGIRE SACRAMENTALE - P. CASPANI' , '2' , '0' , '4' , '18.5000' , '18.5' , '0' , '35' , '24.05' ) 29/09/2023 05:35:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21465' AND id_supplier = '107' 29/09/2023 05:35:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21465' , '107' , '1' ) 29/09/2023 05:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 29/09/2023 05:35:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21467' AND id_supplier = '107' 29/09/2023 05:35:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21467' , '107' , '1' ) 29/09/2023 05:35:56 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '2023010001825', document_date = '2023-09-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '7.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '12', id_causal = '0', price_tax_included = '234.50', price_tax_excluded = '234.50', date_upd = NOW() WHERE id_document = '87486' 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87486' 29/09/2023 05:35:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '87486' 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21623' , 'VIDE CHE TUTTO ERA BUONO - R. COLIZZI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21624' , 'SCRITTI AUTOBIOGRAFICI - M. M. ALACOQUE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21622' , 'INVITO ALLA PREGHIERA - O. DE BERTOLIS' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21620' , 'EVVIVA LA PRIMA COMUNIONE - P. PELLEGRINO' , '50' , '0' , '4' , '4.8000' , '4.8' , '0' , '35' , '156.00' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21465' , 'AGIRE SACRAMENTALE - P. CASPANI' , '2' , '0' , '4' , '18.5000' , '18.5' , '0' , '35' , '24.05' ) 29/09/2023 05:35:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87486' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 29/09/2023 05:36:08 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '2023-fv001432', document_date = '2023-09-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '26.50', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '2591.15', price_tax_excluded = '2591.15', date_upd = NOW() WHERE id_document = '87481' 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87481' 29/09/2023 05:36:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '87481' 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '21.00' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21510' , 'CROCIFISSO DI FRANCESCO DASSISI - C. VALENZIANO' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '45' , '12.10' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21511' , 'INSTRUMENTUM LABORIS - SINODO' , '3' , '0' , '4' , '8.0000' , '8' , '0' , '45' , '13.20' ) 29/09/2023 05:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '45' , '2.75' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '8.25' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21513' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5444' , 'IO SONO CON VOI - CAT.' , '200' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '770.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '11193' , 'VENITE CON ME CAT.' , '150' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '577.50' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '8.25' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21613' , 'RITO DELLA CONFERMAZIONE N.E.' , '10' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '130.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '10' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '130.00' ) 29/09/2023 05:36:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87481' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '10' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '130.00' ) 29/09/2023 05:38:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 05:38:36 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' , '2963' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 29/09/2023 05:38: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 = '87487' 29/09/2023 05:38:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '87487' 29/09/2023 05:38: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 ( '87487' , '20026' , 'CANDELA VOTIVA 20X30' , '5' , '-5' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '3.50' ) 29/09/2023 05:41:45 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'aA4Ir0RjT5HdJrZe' , NOW() , NOW() ) 29/09/2023 05:41:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7067' , '1' ) 29/09/2023 05:41:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7067' , '2' ) 29/09/2023 05:41:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7067' , '3' ) 29/09/2023 05:45:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7067' 29/09/2023 05:45:22 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 ( '7067' , '10' , '162' , 'PARROCCHIA SANT\'EUFEMIA' , 'NUTARELLI' , 'MONS. PAOLO' , 'VIA GRADENICO 14' , '' , '34071' , 'GRADO' , 'donpimail@gmail.com' , '' , '3922570022 - SOLO SMS' , '' , '00125930313' , NOW() , NOW() ) 29/09/2023 05:45:22 pm >> UPDATE ps_customer SET email = 'pay.parrocchiagrado@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7067' 29/09/2023 05:47:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 05:47: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 ( '21' , '81' , '2023-09-29' , '' , '7067' , '0' , '149355623' , 'VIA GRADENICO 14 34071 GRADO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '382.50' , '382.50' , NOW() , NOW() ) 29/09/2023 05:47: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 = '12947' 29/09/2023 05:47:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '12947' 29/09/2023 05:47: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 ( '12947' , '17' , 'LA FEDE NELLO ZAINETTO' , '50' , '-50' , '4' , '6.00' , '6' , '0' , '15' , '255.00' ) 29/09/2023 05:47: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 ( '12947' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '100' , '-100' , '4' , '1.50' , '1.5' , '0' , '15' , '127.50' ) 29/09/2023 06:20:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 06:20:05 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' , '2964' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 29/09/2023 06:20:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87488' 29/09/2023 06:20:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '87488' 29/09/2023 06:20:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87488' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 29/09/2023 06:22:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 06:22:16 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' , '2965' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 29/09/2023 06:22:16 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 = '87489' 29/09/2023 06:22:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '87489' 29/09/2023 06:22:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87489' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/09/2023 06:30:38 pm >> DELETE FROM ps_document WHERE id_document = '12947' 29/09/2023 06:30:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '12947' 29/09/2023 07:35:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-29') 29/09/2023 07:35:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2966' , '2023-09-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '4.67' , NOW() , NOW() ) 29/09/2023 07:35:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87490' 29/09/2023 07:35:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '87490' 29/09/2023 07:35:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87490' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 29/09/2023 07:35:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87490' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' )