05/10/2022 08:52:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/10/2022 08:52:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20054' , '1' , '' , 'nuovo-prodotto' ) 05/10/2022 08:52:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20054' , '1' , '1' , '2' , NOW() , NOW() ) 05/10/2022 08:52:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20054' , '0' , '1' , '0' , '0' ) 05/10/2022 08:53:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872984666' AND id_product != '20054' AND ean13 != '' 05/10/2022 08:53:40 am >> UPDATE ps_product SET id_supplier = '', reference = '11/2', ean13 = '9788872984666', date_upd = NOW() WHERE id_product = '20054' 05/10/2022 08:53:40 am >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - NOV DIC GEN 2023', description = '' WHERE id_product = '20054' 05/10/2022 08:53:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '20054' 05/10/2022 08:53:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '29', 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 = '20054' 05/10/2022 08:53:40 am >> DELETE FROM ps_specific_price WHERE id_product = '20054' 05/10/2022 08:53:41 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20054' 05/10/2022 08:53:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20055' , '1' , '' , 'nuovo-prodotto' ) 05/10/2022 08:53:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20055' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20054' 05/10/2022 08:53:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20055' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20054' 05/10/2022 08:54:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278737' AND id_product != '20055' AND ean13 != '' 05/10/2022 08:54:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831278737', date_upd = NOW() WHERE id_product = '20055' 05/10/2022 08:54:32 am >> UPDATE ps_product_lang SET name = 'NON TEMERE - AVVENTO 2022', description = '' WHERE id_product = '20055' 05/10/2022 08:54:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.4' WHERE id_product = '20055' 05/10/2022 08:54:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.4', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20055' 05/10/2022 08:54:32 am >> DELETE FROM ps_specific_price WHERE id_product = '20055' 05/10/2022 08:54:33 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 = '20055' 05/10/2022 08:54:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20056' , '1' , '' , 'nuovo-prodotto' ) 05/10/2022 08:54:33 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 '20056' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20055' 05/10/2022 08:54:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20056' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20055' 05/10/2022 08:55:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278744' AND id_product != '20056' AND ean13 != '' 05/10/2022 08:55:20 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788831278744', date_upd = NOW() WHERE id_product = '20056' 05/10/2022 08:55:20 am >> UPDATE ps_product_lang SET name = 'BEATA COLEI CHE HA CREDUTO', description = '' WHERE id_product = '20056' 05/10/2022 08:55:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.7' WHERE id_product = '20056' 05/10/2022 08:55:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.7', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20056' 05/10/2022 08:55:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20056' 05/10/2022 08:55:22 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20056' 05/10/2022 08:55:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20057' , '1' , '' , 'nuovo-prodotto' ) 05/10/2022 08:55:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20057' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20056' 05/10/2022 08:55:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20057' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20056' 05/10/2022 08:56:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895060873' AND id_product != '20057' AND ean13 != '' 05/10/2022 08:56:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788895060873', date_upd = NOW() WHERE id_product = '20057' 05/10/2022 08:56:08 am >> UPDATE ps_product_lang SET name = 'CINQUE PANI D\'ORZO 2023', description = '' WHERE id_product = '20057' 05/10/2022 08:56:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '20057' 05/10/2022 08:56:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '250', 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 = '20057' 05/10/2022 08:56:08 am >> DELETE FROM ps_specific_price WHERE id_product = '20057' 05/10/2022 08:56:09 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 = '20057' 05/10/2022 08:56:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20058' , '1' , '' , 'nuovo-prodotto' ) 05/10/2022 08:56:09 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 '20058' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20057' 05/10/2022 08:56:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20058' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20057' 05/10/2022 08:56:52 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' , '610098' , '2022-10-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '6.66' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '239.62' , '239.62' , NOW() , NOW() ) 05/10/2022 08:56:52 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 = '64114' 05/10/2022 08:56:52 am >> DELETE FROM ps_document_detail WHERE id_document = '64114' 05/10/2022 08:56:52 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 ( '64114' , '20054' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2023' , '12' , '12' , '4' , '5.00' , '5' , '0' , '30' , '42.0000' ) 05/10/2022 08:56:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '7' 05/10/2022 08:56:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '7' , '1' ) 05/10/2022 08:56:52 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 ( '64114' , '20054' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2023' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 05/10/2022 08:56:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '7' 05/10/2022 08:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '7' , '1' ) 05/10/2022 08:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64114' , '20055' , 'NON TEMERE - AVVENTO 2022' , '5' , '5' , '4' , '3.40' , '3.4' , '0' , '30' , '11.9000' ) 05/10/2022 08:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20055' AND id_supplier = '7' 05/10/2022 08:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20055' , '7' , '1' ) 05/10/2022 08:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64114' , '20056' , 'BEATA COLEI CHE HA CREDUTO' , '2' , '2' , '4' , '3.70' , '3.7' , '0' , '30' , '5.1800' ) 05/10/2022 08:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20056' AND id_supplier = '7' 05/10/2022 08:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20056' , '7' , '1' ) 05/10/2022 08:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64114' , '20057' , 'CINQUE PANI DORZO 2023' , '36' , '36' , '4' , '6.90' , '6.9' , '0' , '30' , '173.8800' ) 05/10/2022 08:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '7' 05/10/2022 08:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '7' , '1' ) 05/10/2022 08:56:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64114' , '20057' , 'CINQUE PANI DORZO 2023' , '3' , '3' , '4' , '6.90' , '6.9' , '0' , '100' , '0.0000' ) 05/10/2022 08:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '7' 05/10/2022 08:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '7' , '1' ) 05/10/2022 09:07:23 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-10-04' WHERE id_order = '377' 05/10/2022 09:07:23 am >> DELETE FROM ps_document WHERE document_num = '377' AND id_document_type = '28' 05/10/2022 09:12:06 am >> SELECT document_num FROM ps_document WHERE document_num = '144' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 09:12:06 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' , '144' , '2022-10-05' , '' , '3727' , '' , '4671518' , 'francesco gallo , 10 12084 mondovi ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '432.25' , '432.25' , NOW() , NOW() ) 05/10/2022 09:12:06 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 = '64626' 05/10/2022 09:12:06 am >> DELETE FROM ps_document_detail WHERE id_document = '64626' 05/10/2022 09:12:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '5' , '38.00' ) 05/10/2022 09:12:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 05/10/2022 09:12:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 05/10/2022 09:12:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.75' ) 05/10/2022 09:12:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 05/10/2022 09:12:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 05/10/2022 09:12:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '5' , '19.00' ) 05/10/2022 09:12:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 05/10/2022 09:12:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 05/10/2022 09:12:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.75' ) 05/10/2022 09:12:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 05/10/2022 09:12:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 05/10/2022 09:12:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '5' , '28.50' ) 05/10/2022 09:12:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 05/10/2022 09:12:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 05/10/2022 09:12: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 ( '64626' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.75' ) 05/10/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 05/10/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 05/10/2022 09:12: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 ( '64626' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '0' , '0.5' , '0.5' , '' , '5' , '23.75' ) 05/10/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 05/10/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 05/10/2022 09:12: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 ( '64626' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '0' , '0.5' , '0.5' , '' , '5' , '23.75' ) 05/10/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 05/10/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 05/10/2022 09:15:41 am >> SELECT document_num FROM ps_document WHERE document_num = '144' AND id_document != '64626' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 09:15:41 am >> UPDATE ps_document SET id_document_type = '21', document_num = '144', document_date = '2022-10-05', document_letter = '', id_customer = '3727', id_supplier = '', id_address = '4671518', address1 = 'francesco gallo , 10 12084 mondovi ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '440.60', price_tax_excluded = '440.60', date_upd = NOW() WHERE id_document = '64626' 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64626' 05/10/2022 09:15:41 am >> DELETE FROM ps_document_detail WHERE id_document = '64626' 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '5' , '38.00' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 05/10/2022 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.90' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 05/10/2022 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '5' , '19.00' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 05/10/2022 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.90' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 05/10/2022 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '5' , '28.50' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 05/10/2022 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.90' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 05/10/2022 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 05/10/2022 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.5002' , '0.41' , '22' , '5' , '24.00' ) 05/10/2022 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 05/10/2022 09:15:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 05/10/2022 09:15:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.4098' , '22' , '5' , '23.50' ) 05/10/2022 09:15:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 05/10/2022 09:15:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 05/10/2022 09:15:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64626' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 05/10/2022 09:15:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 05/10/2022 09:15:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 05/10/2022 09:21:02 am >> SELECT document_num FROM ps_document WHERE document_num = '144' AND id_document != '64626' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 09:21:02 am >> UPDATE ps_document SET id_document_type = '21', document_num = '144', document_date = '2022-10-05', document_letter = '', id_customer = '3727', id_supplier = '', id_address = '4671518', address1 = 'francesco gallo , 10 12084 mondovi ', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '432.25', price_tax_excluded = '432.25', date_upd = NOW() WHERE id_document = '64626' 05/10/2022 09:21:02 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 = '64626' 05/10/2022 09:21:02 am >> DELETE FROM ps_document_detail WHERE id_document = '64626' 05/10/2022 09:21:02 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 ( '64626' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '5' , '38.00' ) 05/10/2022 09:21:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 05/10/2022 09:21:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 05/10/2022 09:21:02 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 ( '64626' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.75' ) 05/10/2022 09:21:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 05/10/2022 09:21:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 05/10/2022 09:21:02 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 ( '64626' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '5' , '19.00' ) 05/10/2022 09:21:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 05/10/2022 09:21:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 05/10/2022 09:21:02 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 ( '64626' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.75' ) 05/10/2022 09:21:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 05/10/2022 09:21:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 05/10/2022 09:21:02 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 ( '64626' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '5' , '28.50' ) 05/10/2022 09:21:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 05/10/2022 09:21:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 05/10/2022 09:21:03 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 ( '64626' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '5' , '99.75' ) 05/10/2022 09:21:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 05/10/2022 09:21:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 05/10/2022 09:21:03 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 ( '64626' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '0' , '0.5' , '0.5' , '' , '5' , '23.75' ) 05/10/2022 09:21:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 05/10/2022 09:21:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 05/10/2022 09:21:03 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 ( '64626' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '0' , '0.5000' , '0.5' , '' , '5' , '23.75' ) 05/10/2022 09:21:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 05/10/2022 09:21:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 05/10/2022 09:30:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 09:30:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2917' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '50.26' , NOW() , NOW() ) 05/10/2022 09:30:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64627' 05/10/2022 09:30:25 am >> DELETE FROM ps_document_detail WHERE id_document = '64627' 05/10/2022 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '35.00' ) 05/10/2022 09:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 09:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 05/10/2022 09:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 05/10/2022 09:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 05/10/2022 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 05/10/2022 09:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/10/2022 09:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/10/2022 09:30:26 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 ( '64627' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 09:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 05/10/2022 09:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 05/10/2022 09:30:26 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 ( '64627' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 05/10/2022 09:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 05/10/2022 09:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 05/10/2022 09:32:48 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1738' 05/10/2022 09:32:48 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 ( '1738' , '10' , '123' , 'PARR. SS. SALVATORE' , 'DE SOUZA ' , 'DON ANTONIO' , 'VIA VECCHIO N. 4' , '' , '92020' , 'CAMASTRA' , '' , '3203457224' , '' , '' , '' , NOW() , NOW() ) 05/10/2022 09:32:48 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1738' 05/10/2022 09:34:21 am >> SELECT document_num FROM ps_document WHERE document_num = '145' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 09:34:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '145' , '2022-10-05' , '' , '1738' , '0' , '4675308' , 'VIA VECCHIO N. 4 92020 CAMASTRA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '35.64' , '35.64' , NOW() , NOW() ) 05/10/2022 09:34:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64628' 05/10/2022 09:34:21 am >> DELETE FROM ps_document_detail WHERE id_document = '64628' 05/10/2022 09:34:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64628' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '8' , '-8' , '4' , '2.40' , '2.4' , '0' , '5' , '18.24' ) 05/10/2022 09:34:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64628' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '0' , '1.00' , '1' , '' , '5' , '9.50' ) 05/10/2022 09:34:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64628' , '' , 'contrassegno' , '1' , '-1' , '0' , '2.9' , '2.9' , '' , '0' , '2.90' ) 05/10/2022 09:35:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 09:35:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2918' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/10/2022 09:35:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64629' 05/10/2022 09:35:44 am >> DELETE FROM ps_document_detail WHERE id_document = '64629' 05/10/2022 09:35:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64629' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/10/2022 09:35:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 05/10/2022 09:35:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 05/10/2022 10:06:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:06:35 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' , '2919' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 05/10/2022 10:06:35 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 = '64630' 05/10/2022 10:06:35 am >> DELETE FROM ps_document_detail WHERE id_document = '64630' 05/10/2022 10:06:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64630' , '3898' , 'ESCATOLOGIA CRISTIANA - G. ANCONA' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 05/10/2022 10:06:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '3898' AND id_supplier = '' 05/10/2022 10:06:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3898' , '' , '1' ) 05/10/2022 10:07:35 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'CUSlNBzvm4Irct1H' , NOW() , NOW() ) 05/10/2022 10:07:35 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3925' , '1' ) 05/10/2022 10:07:35 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3925' , '2' ) 05/10/2022 10:07:35 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3925' , '3' ) 05/10/2022 10:09:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3925' 05/10/2022 10:09:53 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 ( '3925' , '10' , '168' , 'PARROCCHIA SANTA MARIA GORETTI' , 'MAZZER' , 'DON ANSELMO' , 'VIALE 18 DICEMBRE' , '' , '04100' , 'LATINA ' , '' , '0773693788' , '' , '' , '91015710592' , NOW() , NOW() ) 05/10/2022 10:09:53 am >> UPDATE ps_customer SET email = 'parsmgoretti@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3925' 05/10/2022 10:11:29 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3925' 05/10/2022 10:11:29 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 ( '3925' , '10' , '168' , 'PARROCCHIA SANTA MARIA GORETTI' , 'MAZZER' , 'DON ANSELMO' , 'VIALE 18 DICEMBRE' , '' , '04100' , 'LATINA ' , '' , '0773693788' , '' , '' , '91015710592' , NOW() , NOW() ) 05/10/2022 10:11:29 am >> UPDATE ps_customer SET email = 'parsmgoretti@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3925' 05/10/2022 10:12:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:12:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2920' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 05/10/2022 10:12:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64631' 05/10/2022 10:12:25 am >> DELETE FROM ps_document_detail WHERE id_document = '64631' 05/10/2022 10:12:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64631' , '18223' , 'CORONA MISSIONARIA - R102' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 05/10/2022 10:12:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18223' AND id_supplier = '' 05/10/2022 10:12:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18223' , '' , '1' ) 05/10/2022 10:13:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2921' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:13:02 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' , '2921' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.37' , '12.03' , NOW() , NOW() ) 05/10/2022 10:13:02 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 = '64632' 05/10/2022 10:13:02 am >> DELETE FROM ps_document_detail WHERE id_document = '64632' 05/10/2022 10:13:02 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 ( '64632' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 05/10/2022 10:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 05/10/2022 10:13:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 05/10/2022 10:13:03 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 ( '64632' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '1.90' ) 05/10/2022 10:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 05/10/2022 10:13:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 05/10/2022 10:13:03 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 ( '64632' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 05/10/2022 10:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 05/10/2022 10:13:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 05/10/2022 10:13:03 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 ( '64632' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 05/10/2022 10:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 05/10/2022 10:13:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 05/10/2022 10:13:03 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 ( '64632' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 05/10/2022 10:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 05/10/2022 10:13:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 05/10/2022 10:18:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2922' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:18:26 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' , '2922' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.06' , '47.06' , NOW() , NOW() ) 05/10/2022 10:18:26 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 = '64633' 05/10/2022 10:18:26 am >> DELETE FROM ps_document_detail WHERE id_document = '64633' 05/10/2022 10:18:26 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 ( '64633' , '15725' , 'SARA - L. INVERNIZZI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/10/2022 10:18:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '15725' AND id_supplier = '' 05/10/2022 10:18:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15725' , '' , '1' ) 05/10/2022 10:18:26 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 ( '64633' , '19969' , 'BRECCIA NEL TEMPO - L. INVERNIZZI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 05/10/2022 10:18:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19969' AND id_supplier = '' 05/10/2022 10:18:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19969' , '' , '1' ) 05/10/2022 10:18:26 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 ( '64633' , '19968' , 'PAURE CHE CI ABITANO - A. CASATI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/10/2022 10:18:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19968' AND id_supplier = '' 05/10/2022 10:18:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19968' , '' , '1' ) 05/10/2022 10:18:26 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 ( '64633' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.56' , '0.56' , '0' , '0' , '14.00' ) 05/10/2022 10:18:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 05/10/2022 10:18:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 05/10/2022 10:18:26 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 ( '64633' , '20037' , 'INSIEME NELLA MESSA - DIC 2022' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 05/10/2022 10:18:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20037' AND id_supplier = '' 05/10/2022 10:18:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20037' , '' , '1' ) 05/10/2022 10:19:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2923' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:19:24 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' , '2923' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.50' , '86.87' , NOW() , NOW() ) 05/10/2022 10:19:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64634' 05/10/2022 10:19:24 am >> DELETE FROM ps_document_detail WHERE id_document = '64634' 05/10/2022 10:19:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64634' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '150' , '-150' , '4' , '0.56' , '0.56' , '0' , '0' , '84.00' ) 05/10/2022 10:19:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 05/10/2022 10:19:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 05/10/2022 10:19:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64634' , '12139' , 'SANTA FAUSTINA - 336' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 05/10/2022 10:19:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12139' AND id_supplier = '' 05/10/2022 10:19:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12139' , '' , '1' ) 05/10/2022 10:38:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2924' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:38:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2924' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '452.88' , '377.00' , NOW() , NOW() ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64635' 05/10/2022 10:38:53 am >> DELETE FROM ps_document_detail WHERE id_document = '64635' 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '138.00' , '113.11475409836' , '22' , '0' , '138.00' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '' , '1' ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '19799' , 'CAMICE MARIANO IN LANA - 0774/06' , '1' , '-1' , '1' , '265.00' , '217.2131147541' , '22' , '0' , '265.00' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19799' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19799' , '' , '1' ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '8260' , 'PREGHIAMO INSIEME E DICIAMO - M. BARZIZZA' , '1' , '-1' , '4' , '32.50' , '32.5' , '0' , '5' , '30.88' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '8260' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8260' , '' , '1' ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '18102' , 'CROCE ULIVO DELLAMICIZIA - PG748 ' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18102' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18102' , '' , '1' ) 05/10/2022 10:38:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64635' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 05/10/2022 10:38:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11683' AND id_supplier = '' 05/10/2022 10:38:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11683' , '' , '1' ) 05/10/2022 10:49:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 10:49:48 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' , '2925' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.09' , '48.09' , NOW() , NOW() ) 05/10/2022 10:49:48 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 = '64636' 05/10/2022 10:49:48 am >> DELETE FROM ps_document_detail WHERE id_document = '64636' 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '20031' , 'AVVENTO E NATALE 2022/2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20031' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20031' , '' , '1' ) 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '19302' , 'SOFFERENZA MALATTIA E MORTE - 8069' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19302' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19302' , '' , '1' ) 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '13034' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13034' , '' , '1' ) 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20036' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20036' , '' , '1' ) 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '' , '1' ) 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19929' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19929' , '' , '1' ) 05/10/2022 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64636' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 05/10/2022 10:49:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 05/10/2022 10:49:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 05/10/2022 10:56:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2772' AND id_document != '61846' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 05/10/2022 10:56:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2772', document_date = '2022-09-17', 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 = '52.99', price_tax_excluded = '46.59', date_upd = NOW() WHERE id_document = '61846' 05/10/2022 10:56:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61846' 05/10/2022 10:56:33 am >> DELETE FROM ps_document_detail WHERE id_document = '61846' 05/10/2022 10:56:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61846' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 05/10/2022 10:56:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 10:56:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 10:56:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61846' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 05/10/2022 10:56:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 05/10/2022 10:56:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 05/10/2022 10:56:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61846' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 05/10/2022 10:56:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 05/10/2022 10:56:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 05/10/2022 10:56:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61846' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '5' , '7.13' ) 05/10/2022 10:56:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '14330' AND id_supplier = '' 05/10/2022 10:56:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14330' , '' , '1' ) 05/10/2022 10:56:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61846' , '19887' , 'FAMIGLIA SEDUTA 10X10 TORTORA - 4241/786' , '1' , '-1' , '1' , '18.50' , '15.16393442623' , '22' , '0' , '18.50' ) 05/10/2022 10:56:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19887' AND id_supplier = '' 05/10/2022 10:56:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19887' , '' , '1' ) 05/10/2022 11:00:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2909' AND id_document != '63590' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 05/10/2022 11:00:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2909', document_date = '2022-10-04', 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 = '153.00', price_tax_excluded = '125.41', date_upd = NOW() WHERE id_document = '63590' 05/10/2022 11:00:17 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 = '63590' 05/10/2022 11:00:17 am >> DELETE FROM ps_document_detail WHERE id_document = '63590' 05/10/2022 11:00:17 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 ( '63590' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '18' , '-18' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '144.00' ) 05/10/2022 11:00:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '739' AND id_supplier = '' 05/10/2022 11:00:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '739' , '' , '1' ) 05/10/2022 11:00:17 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 ( '63590' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/10/2022 11:00:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 05/10/2022 11:00:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 05/10/2022 11:00:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63590' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 05/10/2022 11:00:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 11:00:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 11:00:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63590' , '12139' , 'SANTA FAUSTINA - 336' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 05/10/2022 11:00:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '12139' AND id_supplier = '' 05/10/2022 11:00:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12139' , '' , '1' ) 05/10/2022 11:01:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2754' AND id_document != '61826' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 05/10/2022 11:01:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2754', document_date = '2022-09-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '61826' 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61826' 05/10/2022 11:01:39 am >> DELETE FROM ps_document_detail WHERE id_document = '61826' 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '5.50' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '12528' , 'LAMPADA A SFERA BLU' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12528' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12528' , '' , '1' ) 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '7484' , 'PAPA FRANCESCO - FOTO UFF. 25X35 ' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7484' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7484' , '' , '1' ) 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '2.80' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12833' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12833' , '' , '1' ) 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '2424' , 'COLLETTO DOPPIO - CM 3,5 ' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '2424' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2424' , '' , '1' ) 05/10/2022 11:01:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '16508' , 'ANGELO BIANCO IN RESINA CAMPANA - 4218' , '1' , '-1' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '4.70' ) 05/10/2022 11:01:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16508' AND id_supplier = '' 05/10/2022 11:01:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16508' , '' , '1' ) 05/10/2022 11:30:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2926' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 11:30:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2926' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '34.04' , NOW() , NOW() ) 05/10/2022 11:30:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64637' 05/10/2022 11:30:11 am >> DELETE FROM ps_document_detail WHERE id_document = '64637' 05/10/2022 11:30: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 ( '64637' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 05/10/2022 11:30:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 05/10/2022 11:30:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 05/10/2022 11:30: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 ( '64637' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/10/2022 11:30:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 05/10/2022 11:30:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 05/10/2022 11:30: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 ( '64637' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 05/10/2022 11:30:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 05/10/2022 11:30:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 05/10/2022 11:30: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 ( '64637' , '801' , 'ASTUCCIO STOPPINO - MT 2 - 117' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 05/10/2022 11:30:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '801' AND id_supplier = '' 05/10/2022 11:30:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '801' , '' , '1' ) 05/10/2022 11:30: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 ( '64637' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 05/10/2022 11:30:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 05/10/2022 11:30:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 05/10/2022 11:40:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2927' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 11:40:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2927' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.70' , '25.98' , NOW() , NOW() ) 05/10/2022 11:40:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64638' 05/10/2022 11:40:11 am >> DELETE FROM ps_document_detail WHERE id_document = '64638' 05/10/2022 11:40: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 ( '64638' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '31.70' , '25.983606557377' , '22' , '0' , '31.70' ) 05/10/2022 11:40:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 05/10/2022 11:40:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 05/10/2022 11:48:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2928' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 11:48:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2928' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '2' , '0' , '677.00' , '560.13' , NOW() , NOW() ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64639' 05/10/2022 11:48:45 am >> DELETE FROM ps_document_detail WHERE id_document = '64639' 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 05/10/2022 11:48:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 05/10/2022 11:48:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.15' , '9.1393442622951' , '22' , '0' , '11.15' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 05/10/2022 11:48:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 05/10/2022 11:48:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 05/10/2022 11:48:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '1951' AND id_supplier = '' 05/10/2022 11:48:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1951' , '' , '1' ) 05/10/2022 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64639' , '19866' , 'CASULA CROCE UVA - CSL111' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 05/10/2022 11:48:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19866' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19866' , '' , '1' ) 05/10/2022 11:48:46 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 ( '64639' , '18400' , 'CAMICE DUE PIEGONI POL. CERNIERA SPALLA - 405TPAS' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 05/10/2022 11:48:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18400' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18400' , '' , '1' ) 05/10/2022 11:48:46 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 ( '64639' , '19856' , 'CAMICE ARGENTO F/LANA - 8087 ' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 05/10/2022 11:48:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19856' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19856' , '' , '1' ) 05/10/2022 11:48:46 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 ( '64639' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 05/10/2022 11:48:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 05/10/2022 11:48:46 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 ( '64639' , '4948' , 'IMITAZIONE DI CRISTO - TASC - 8818' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 05/10/2022 11:48:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '4948' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4948' , '' , '1' ) 05/10/2022 11:48:46 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 ( '64639' , '4943' , 'IMITAZIONE DI CRISTO - 8123' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/10/2022 11:48:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '4943' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4943' , '' , '1' ) 05/10/2022 11:48:46 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 ( '64639' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 05/10/2022 11:48:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 05/10/2022 11:48:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 05/10/2022 11:55:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2904' AND id_document != '63584' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-03') 05/10/2022 11:55:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2904', document_date = '2022-10-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.75', price_tax_excluded = '7.17', date_upd = NOW() WHERE id_document = '63584' 05/10/2022 11:55:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63584' 05/10/2022 11:55:23 am >> DELETE FROM ps_document_detail WHERE id_document = '63584' 05/10/2022 11:55:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63584' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.95' , '2.4180327868852' , '22' , '0' , '2.95' ) 05/10/2022 11:55:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 11:55:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 11:55:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63584' , '17604' , 'ROSARIO 100 REQUIEM - RE1018' , '1' , '-1' , '1' , '5.80' , '4.7540983606557' , '22' , '0' , '5.80' ) 05/10/2022 11:55:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '17604' AND id_supplier = '' 05/10/2022 11:55:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17604' , '' , '1' ) 05/10/2022 11:56:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2912' AND id_document != '63593' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 05/10/2022 11:56:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2912', document_date = '2022-10-04', 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 = '28.20', price_tax_excluded = '25.13', date_upd = NOW() WHERE id_document = '63593' 05/10/2022 11:56: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 = '63593' 05/10/2022 11:56:10 am >> DELETE FROM ps_document_detail WHERE id_document = '63593' 05/10/2022 11:56: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 ( '63593' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.7000' , '0.7' , '0' , '0' , '4.20' ) 05/10/2022 11:56:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 05/10/2022 11:56:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 05/10/2022 11:56: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 ( '63593' , '14129' , 'SANTO STEFANO PROTO MARTIRE - 57' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 05/10/2022 11:56:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '14129' AND id_supplier = '' 05/10/2022 11:56:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14129' , '' , '1' ) 05/10/2022 11:56: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 ( '63593' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 11:56:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 05/10/2022 11:56:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 05/10/2022 11:56: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 ( '63593' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.6' , '3.6' , '0' , '0' , '3.60' ) 05/10/2022 11:56:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/10/2022 11:56:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/10/2022 11:56: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 ( '63593' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 05/10/2022 11:56:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '' 05/10/2022 11:56:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '' , '1' ) 05/10/2022 11:56: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 ( '63593' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 05/10/2022 11:56:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 05/10/2022 11:56:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 05/10/2022 11:57:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2929' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 11:57:49 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' , '2929' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.60' , '14.31' , NOW() , NOW() ) 05/10/2022 11:57:49 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 = '64640' 05/10/2022 11:57:49 am >> DELETE FROM ps_document_detail WHERE id_document = '64640' 05/10/2022 11:57:49 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 ( '64640' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 05/10/2022 11:57:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 05/10/2022 11:57:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 05/10/2022 11:57:49 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 ( '64640' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 05/10/2022 11:57:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/10/2022 11:57:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/10/2022 03:21:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 03:21:50 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' , '11' , '2022-10-05' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1400.00' , '1400.00' , NOW() , NOW() ) 05/10/2022 03:21:50 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 = '7137' 05/10/2022 03:21:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '7137' 05/10/2022 03:21:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7137' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '360' , '-360' , '4' , '2.50' , '2.5' , '0' , '0' , '900.00' ) 05/10/2022 03:21:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7137' , '17' , 'LA FEDE NELLO ZAINETTO' , '100' , '-100' , '4' , '5.00' , '5' , '0' , '0' , '500.00' ) 05/10/2022 03:23:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 03:23:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '34/E' , '2022-10-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '576.00' , '472.13' , NOW() , NOW() ) 05/10/2022 03:23:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64641' 05/10/2022 03:23:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '64641' 05/10/2022 03:23:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64641' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 05/10/2022 03:23:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64641' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 05/10/2022 03:26:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 03:26:38 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' , '28' , '2022-10-05' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7600.00' , '7600.00' , NOW() , NOW() ) 05/10/2022 03:26:38 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 = '64642' 05/10/2022 03:26:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '64642' 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '5446' , 'IO SONO CON VOI - GUIDA' , '10' , '-10' , '4' , '6.00' , '6' , '0' , '0' , '60.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '11183' , 'VENITE CON ME - GUIDA' , '50' , '-50' , '4' , '6.00' , '6' , '0' , '0' , '300.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '42' , '-42' , '4' , '10.00' , '10' , '0' , '0' , '420.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '30' , '-30' , '4' , '6.00' , '6' , '0' , '0' , '180.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '8408' , 'PRENDETE E MANGIATE' , '1120' , '-1120' , '4' , '3.00' , '3' , '0' , '0' , '3360.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '40' , '-40' , '4' , '12.00' , '12' , '0' , '0' , '480.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '17257' , 'IO TI BATTEZZO ' , '500' , '-500' , '4' , '1.80' , '1.8' , '0' , '0' , '900.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '40' , '-40' , '4' , '35.00' , '35' , '0' , '0' , '1400.00' ) 05/10/2022 03:26:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '200' , '-200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.00' ) 05/10/2022 03:48:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245884' AND id_product != '14719' AND ean13 != '' 05/10/2022 03:48:17 pm >> UPDATE ps_product SET id_supplier = '7', reference = '4/2', ean13 = '9788861245884', date_upd = NOW() WHERE id_product = '14719' 05/10/2022 03:48:17 pm >> UPDATE ps_product_lang SET name = 'TU MI AMI DAVVERO', description = '' WHERE id_product = '14719' 05/10/2022 03:48:17 pm >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '5.9' WHERE id_product = '14719' 05/10/2022 03:48:17 pm >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '5.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14719' 05/10/2022 03:48:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '14719' 05/10/2022 03:48:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245877' AND id_product != '10751' AND ean13 != '' 05/10/2022 03:48:45 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788861245877', date_upd = NOW() WHERE id_product = '10751' 05/10/2022 03:48:45 pm >> UPDATE ps_product_lang SET name = 'TU MI PERDONI', description = '' WHERE id_product = '10751' 05/10/2022 03:48:45 pm >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '5.9' WHERE id_product = '10751' 05/10/2022 03:48:45 pm >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '5.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10751' 05/10/2022 03:48:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '10751' 05/10/2022 03:50:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240018' AND id_product != '20058' AND ean13 != '' 05/10/2022 03:50:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892240018', date_upd = NOW() WHERE id_product = '20058' 05/10/2022 03:50:25 pm >> UPDATE ps_product_lang SET name = 'DESIDERIO DESIDERAVI', description = '' WHERE id_product = '20058' 05/10/2022 03:50:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '20058' 05/10/2022 03:50:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20058' 05/10/2022 03:50:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20058' 05/10/2022 03:50:26 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 = '20058' 05/10/2022 03:50:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20059' , '1' , '' , 'nuovo-prodotto' ) 05/10/2022 03:50:26 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 '20059' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20058' 05/10/2022 03:50:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20059' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20058' 05/10/2022 03:51:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244535' AND id_product != '5832' AND ean13 != '' 05/10/2022 03:51:21 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788861244535', date_upd = NOW() WHERE id_product = '5832' 05/10/2022 03:51:21 pm >> UPDATE ps_product_lang SET name = 'LIBRO DEI SANTI', description = '' WHERE id_product = '5832' 05/10/2022 03:51:21 pm >> UPDATE ps_product SET wholesale_price = '6.93', on_sale = '0', price = '12.9' WHERE id_product = '5832' 05/10/2022 03:51:21 pm >> UPDATE ps_product_shop SET wholesale_price = '6.93', price = '12.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '5832' 05/10/2022 03:51:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '5832' 05/10/2022 03:52:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571635' AND id_product != '17554' AND ean13 != '' 05/10/2022 03:52:13 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788867571635', date_upd = NOW() WHERE id_product = '17554' 05/10/2022 03:52:13 pm >> UPDATE ps_product_lang SET name = 'GRANDI SANTI AMICI DI GESU\'', description = '' WHERE id_product = '17554' 05/10/2022 03:52:13 pm >> UPDATE ps_product SET wholesale_price = '6.93', on_sale = '0', price = '12' WHERE id_product = '17554' 05/10/2022 03:52:13 pm >> UPDATE ps_product_shop SET wholesale_price = '6.93', price = '12', id_tax_rules_group = '4', id_category_default = '51', 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 = '17554' 05/10/2022 03:52:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '17554' 05/10/2022 03:53:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '610031' , '2022-10-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '36.14' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1160.40' , '1160.40' , NOW() , NOW() ) 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64643' 05/10/2022 03:53:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '64643' 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '3603' , 'DOCAT' , '12' , '12' , '4' , '12.90' , '12.9' , '0' , '33+7' , '96.4559' ) 05/10/2022 03:53:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3603' AND id_supplier = '7' 05/10/2022 03:53:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3603' , '7' , '1' ) 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '3603' , 'DOCAT' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3603' AND id_supplier = '7' 05/10/2022 03:53:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3603' , '7' , '1' ) 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '12908' , 'Y BIBBIA' , '5' , '5' , '4' , '14.90' , '14.9' , '0' , '33+7' , '46.4210' ) 05/10/2022 03:53:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12908' AND id_supplier = '7' 05/10/2022 03:53:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12908' , '7' , '1' ) 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 05/10/2022 03:53:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '7' 05/10/2022 03:53:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '7' , '1' ) 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 05/10/2022 03:53:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 05/10/2022 03:53:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 05/10/2022 03:53:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '14529' , 'PANE E VINO - SUSSIDIO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15927' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15927' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '3' , '3' , '4' , '15.00' , '15' , '0' , '35+7' , '27.2025' ) 05/10/2022 03:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '7' 05/10/2022 03:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '7' , '1' ) 05/10/2022 03:53:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64643' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '48' , '48' , '4' , '3' , '3' , '0' , '35+7' , '87.0480' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '4' , '4' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '48' , '48' , '4' , '3.00' , '3' , '0' , '35+7' , '87.0480' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '4' , '4' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '48' , '48' , '4' , '3.00' , '3' , '0' , '35+7' , '87.0480' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '4' , '4' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '48' , '48' , '4' , '3.00' , '3' , '0' , '35+7' , '87.0480' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '4' , '4' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '14719' , 'TU MI AMI DAVVERO' , '36' , '36' , '4' , '5.90' , '5.9' , '0' , '30+7' , '138.2724' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '10751' , 'TU MI PERDONI' , '36' , '36' , '4' , '5.90' , '5.9' , '0' , '30+7' , '138.2724' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '2' , '2' , '4' , '12.00' , '12' , '0' , '33+7' , '14.9544' ) 05/10/2022 03:53:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '7' 05/10/2022 03:53:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '11839' , 'IRADIDDIO - M. POZZA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11839' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11839' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '20058' , 'DESIDERIO DESIDERAVI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '33' , '2.3450' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20058' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20058' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '322' , 'AGGUATO DI DIO - M. POZZA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '322' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '322' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '19326' , 'SUL DOLORE - P. CURTAZ' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33' , '21.4400' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19326' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19326' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '17554' , 'GRANDI SANTI AMICI DI GESU' , '1' , '1' , '4' , '12' , '12' , '0' , '30' , '8.4000' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17554' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17554' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '5832' , 'LIBRO DEI SANTI' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5832' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5832' , '7' , '1' ) 05/10/2022 03:53: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 ( '64643' , '17073' , 'DIRETTORIO PER LA CATECHESI' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33' , '21.4400' ) 05/10/2022 03:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17073' AND id_supplier = '7' 05/10/2022 03:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17073' , '7' , '1' ) 05/10/2022 03:58:42 pm >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '3925' 05/10/2022 04:02:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '146' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:02: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 ( '21' , '146' , '2022-10-05' , '' , '326' , '0' , '4671618' , 'VIALE 18 DICEMBRE 04100 LATINA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '29.00' , '29.00' , NOW() , NOW() ) 05/10/2022 04:02: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 = '64644' 05/10/2022 04:02:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '64644' 05/10/2022 04:02: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 ( '64644' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/10/2022 04:02: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 ( '64644' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 05/10/2022 04:02: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 ( '64644' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/10/2022 04:02: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 ( '64644' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/10/2022 04:02: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 ( '64644' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.20' , '6.2' , '0' , '5' , '5.89' ) 05/10/2022 04:02: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 ( '64644' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 05/10/2022 04:02: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 ( '64644' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '5' , '0.95' ) 05/10/2022 04:02: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 ( '64644' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 05/10/2022 04:04:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '147' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:04:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '147' , '2022-10-05' , '' , '1746' , '0' , '4670977' , 'VIA S. SILVIANO 04019 TERRACINA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '45.80' , '45.80' , NOW() , NOW() ) 05/10/2022 04:04:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64645' 05/10/2022 04:04:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '64645' 05/10/2022 04:04:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64645' , '4154' , 'FESTA DEL PERDONO' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '15' , '30.60' ) 05/10/2022 04:04:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64645' , '8408' , 'PRENDETE E MANGIATE' , '4' , '-4' , '4' , '3.00' , '3' , '0' , '15' , '10.20' ) 05/10/2022 04:13:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571628' AND id_product != '17553' AND ean13 != '' 05/10/2022 04:13:54 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788867571628', date_upd = NOW() WHERE id_product = '17553' 05/10/2022 04:13:54 pm >> UPDATE ps_product_lang SET name = 'GRANDI SANTE AMICHE DI GESU\'', description = '' WHERE id_product = '17553' 05/10/2022 04:13:54 pm >> UPDATE ps_product SET wholesale_price = '6.93', on_sale = '0', price = '12' WHERE id_product = '17553' 05/10/2022 04:13:54 pm >> UPDATE ps_product_shop SET wholesale_price = '6.93', price = '12', id_tax_rules_group = '4', id_category_default = '51', 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 = '17553' 05/10/2022 04:13:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '17553' 05/10/2022 04:16:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:16: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 ( '23' , '21/S' , '2022-10-05' , 'S' , '3487' , '0' , '4670192' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.75' , '43.75' , NOW() , NOW() ) 05/10/2022 04:16: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 = '7138' 05/10/2022 04:16:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '7138' 05/10/2022 04:16: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 ( '7138' , '75' , 'IL SEGNO DELLA CROCE' , '25' , '-25' , '4' , '1.50' , '1.5' , '0' , '50' , '18.75' ) 05/10/2022 04:16: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 ( '7138' , '50' , 'PERDONAMI SIGNORE' , '25' , '-25' , '4' , '2.00' , '2' , '0' , '50' , '25.00' ) 05/10/2022 04:17:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '35/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:17: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 ( '23' , '35/E' , '2022-10-05' , 'E' , '3546' , '0' , '4671004' , 'VIA TORQUATO TASSO, 10 24020 GORLE ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 05/10/2022 04:17: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 = '64646' 05/10/2022 04:17:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '64646' 05/10/2022 04:17: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 ( '64646' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '40' , '15.00' ) 05/10/2022 04:20:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2930' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:20:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2930' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.81' , '29.33' , NOW() , NOW() ) 05/10/2022 04:20:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64647' 05/10/2022 04:20:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '64647' 05/10/2022 04:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64647' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 05/10/2022 04:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 05/10/2022 04:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 05/10/2022 04:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64647' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/10/2022 04:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 05/10/2022 04:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 05/10/2022 04:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64647' , '2867' , 'CREDO SPIEGATO AI RAGAZZI - N.E.' , '2' , '-2' , '4' , '4.90' , '4.9' , '0' , '5' , '9.32' ) 05/10/2022 04:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2867' AND id_supplier = '' 05/10/2022 04:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2867' , '' , '1' ) 05/10/2022 04:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64647' , '18448' , 'SCOPRIAMO INSIEME IL CREDO ' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 05/10/2022 04:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18448' AND id_supplier = '' 05/10/2022 04:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18448' , '' , '1' ) 05/10/2022 04:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64647' , '20058' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 05/10/2022 04:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20058' AND id_supplier = '' 05/10/2022 04:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20058' , '' , '1' ) 05/10/2022 04:20:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2931' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:20:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2931' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 05/10/2022 04:20:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64648' 05/10/2022 04:20:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '64648' 05/10/2022 04:20:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64648' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '19' , '15.573770491803' , '22' , '0' , '38.00' ) 05/10/2022 04:20:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 04:20:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 04:41:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:41:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '90' , '2022-10-05' , '' , '1043' , '0' , '4670286' , 'VIA REANO, 1 10090 BUTTIGLIERA ALTA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '54.00' , '54.00' , NOW() , NOW() ) 05/10/2022 04:41:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7139' 05/10/2022 04:41:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '7139' 05/10/2022 04:41: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 ( '7139' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '0' , '54.00' ) 05/10/2022 04:43:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2932' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 04:43: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' , '2932' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 05/10/2022 04:43: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 = '64649' 05/10/2022 04:43:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '64649' 05/10/2022 04:43: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 ( '64649' , '19306' , 'VITA SPIRITUALE - GARRIGOU - LANGRANGE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/10/2022 04:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19306' AND id_supplier = '' 05/10/2022 04:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19306' , '' , '1' ) 05/10/2022 05:32:06 pm >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-10-04' WHERE id_order = '378' 05/10/2022 05:32:06 pm >> DELETE FROM ps_document WHERE document_num = '378' AND id_document_type = '28' 05/10/2022 05:33:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '148' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 05:33:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '148' , '2022-10-05' , '' , '3926' , '' , '4675443' , 'largo pieve, 5 casa parrocchiale, , 5 25034 orzinuovi ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '6' , '0' , '126.97' , '126.97' , NOW() , NOW() ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65161' 05/10/2022 05:33:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '65161' 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '5' , '33.30' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '9' , '-9' , '4' , '2.5000' , '2.5' , '0' , '5' , '21.42' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '4154' , 'FESTA DEL PERDONO' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '5' , '28.50' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '8408' , 'PRENDETE E MANGIATE' , '9' , '-9' , '4' , '3.0000' , '3' , '0' , '5' , '25.65' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 05/10/2022 05:33:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 05/10/2022 05:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65161' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 05/10/2022 05:33:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 05/10/2022 05:33:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 05/10/2022 05:37:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2933' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 05:37:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2933' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/10/2022 05:37: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 = '65162' 05/10/2022 05:37:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '65162' 05/10/2022 05:37: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 ( '65162' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 05:37:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 05/10/2022 05:37:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 05/10/2022 05:43:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2934' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 05:43:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2934' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.39' , '29.39' , NOW() , NOW() ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65163' 05/10/2022 05:43:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '65163' 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '13129' , 'ESAME DI COSCIENZA SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13129' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13129' , '' , '1' ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '7550' , 'PARABOLE SPIEGATE AI BAMBINI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7550' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7550' , '' , '1' ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '2636' , 'CONFESSIONE SPIEGATA AI BAMBINI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2636' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2636' , '' , '1' ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15318' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15318' , '' , '1' ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16199' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16199' , '' , '1' ) 05/10/2022 05:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65163' , '13879' , 'FORTISSIMI GIOVANI - P. PELLEGRINO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 05/10/2022 05:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13879' AND id_supplier = '' 05/10/2022 05:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13879' , '' , '1' ) 05/10/2022 05:46:37 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9307' 05/10/2022 05:46:37 pm >> UPDATE ps_stock_available SET quantity = quantity + '-5' WHERE id_product = '9307' 05/10/2022 05:51:42 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3727' 05/10/2022 05:51:42 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 ( '3727' , '10' , '153' , '' , 'ROSSO' , 'ANDREA' , 'VIA FRANCESCO GALLO 10' , '' , '12084' , 'MONDOVI\'' , '' , '' , '3387327942' , '' , '' , NOW() , NOW() ) 05/10/2022 05:51:42 pm >> UPDATE ps_customer SET email = 'andrearosso21@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3727' 05/10/2022 06:03:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2399' AND id_document != '59848' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-29') 05/10/2022 06:03:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2399', document_date = '2022-07-29', 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 = '36.00', price_tax_excluded = '29.51', date_upd = NOW() WHERE id_document = '59848' 05/10/2022 06:03:49 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 = '59848' 05/10/2022 06:03:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '59848' 05/10/2022 06:03:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59848' , '19770' , 'BRACCIALE ARGENTO/ULIVO S. BENEDETTO' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 05/10/2022 06:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19770' AND id_supplier = '' 05/10/2022 06:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19770' , '' , '1' ) 05/10/2022 06:03:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59848' , '801' , 'ASTUCCIO STOPPINO - MT 2 - 117' , '2' , '-2' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '13.00' ) 05/10/2022 06:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '801' AND id_supplier = '' 05/10/2022 06:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '801' , '' , '1' ) 05/10/2022 06:07:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 06:07:57 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' , '2935' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 05/10/2022 06:07:57 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 = '65164' 05/10/2022 06:07:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '65164' 05/10/2022 06:07:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65164' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/10/2022 06:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6404' AND id_supplier = '' 05/10/2022 06:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6404' , '' , '1' ) 05/10/2022 06:11:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 06:11: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' , '2936' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 05/10/2022 06:11: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 = '65165' 05/10/2022 06:11:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '65165' 05/10/2022 06:11: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 ( '65165' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 05/10/2022 06:11:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 05/10/2022 06:11:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 05/10/2022 06:23:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2937' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 06:23:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2937' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 05/10/2022 06:23:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65166' 05/10/2022 06:23:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '65166' 05/10/2022 06:23:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65166' , '19772' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 05/10/2022 06:23:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19772' AND id_supplier = '' 05/10/2022 06:23:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19772' , '' , '1' ) 05/10/2022 06:32:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2938' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 06:32:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2938' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '33.24' , NOW() , NOW() ) 05/10/2022 06:32: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 = '65167' 05/10/2022 06:32:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '65167' 05/10/2022 06:32: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 ( '65167' , '18557' , 'MADRE TERESA BABY - 023 MT/ 9 BB' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/10/2022 06:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18557' AND id_supplier = '' 05/10/2022 06:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18557' , '' , '1' ) 05/10/2022 06:32: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 ( '65167' , '13113' , 'GUADALUPE BABY - 023 GUA 9 BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 06:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13113' AND id_supplier = '' 05/10/2022 06:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13113' , '' , '1' ) 05/10/2022 06:32: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 ( '65167' , '18556' , 'SAN BENEDETTO BABY - 023 SB/9 BB' , '1' , '-1' , '1' , '9.94' , '8.1475409836066' , '22' , '0' , '9.94' ) 05/10/2022 06:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18556' AND id_supplier = '' 05/10/2022 06:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18556' , '' , '1' ) 05/10/2022 06:32: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 ( '65167' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 05/10/2022 06:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 05/10/2022 06:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 05/10/2022 06:32: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 ( '65167' , '20057' , 'CINQUE PANI DORZO 2023' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 05/10/2022 06:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '' 05/10/2022 06:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '' , '1' ) 05/10/2022 06:42:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2939' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 06:42:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2939' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 05/10/2022 06:42:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65168' 05/10/2022 06:42:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '65168' 05/10/2022 06:42:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65168' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 05/10/2022 06:42:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 06:42:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 06:43:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2940' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 06:43:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2940' , '2022-10-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 05/10/2022 06:43:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65169' 05/10/2022 06:43:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '65169' 05/10/2022 06:43:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65169' , '2421' , 'COLLANA GIROCOLLO 5 POSTE' , '48' , '-48' , '1' , '4' , '3.2786885245902' , '22' , '0' , '192.00' ) 05/10/2022 06:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2421' AND id_supplier = '' 05/10/2022 06:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2421' , '' , '1' ) 05/10/2022 06:43:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65169' , '12936' , 'SCATOLA 4X4' , '40' , '-40' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '8.00' ) 05/10/2022 06:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12936' AND id_supplier = '' 05/10/2022 06:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12936' , '' , '1' ) 05/10/2022 07:00:52 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ajocnpNqLYUJE8kI' , NOW() , NOW() ) 05/10/2022 07:00:52 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6990' , '1' ) 05/10/2022 07:00:52 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6990' , '2' ) 05/10/2022 07:00:52 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6990' , '3' ) 05/10/2022 07:01:49 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6990' 05/10/2022 07:01:49 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 ( '6990' , '10' , '148' , '' , 'MORGIONE' , 'CAMILLO' , 'VIA FONTE SANT\'ANGELO 1' , '' , '66020' , 'SCHERNI' , '' , '' , '3284095818' , '' , '' , NOW() , NOW() ) 05/10/2022 07:01:49 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6990' 05/10/2022 07:02:36 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6990' 05/10/2022 07:02:36 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 ( '6990' , '10' , '148' , '' , 'MORGIONE' , 'CAMILLO' , 'VIA FONTE SANT\'ANGELO 1' , '' , '66020' , 'SCHERNI' , '' , '' , '3284095818' , '' , '' , NOW() , NOW() ) 05/10/2022 07:02:36 pm >> UPDATE ps_customer SET email = 'camillomorgione@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6990' 05/10/2022 07:04:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 07:04:04 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' , '91' , '2022-10-05' , '' , '6990' , '0' , '84014827' , 'VIA FONTE SANT\\\'ANGELO 1 66020 SCHERNI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 05/10/2022 07:04:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7140' 05/10/2022 07:04:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '7140' 05/10/2022 07:04:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7140' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/10/2022 07:09:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2616' AND id_document != '61141' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-02') 05/10/2022 07:09:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2616', document_date = '2022-09-02', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '61141' 05/10/2022 07:09: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 = '61141' 05/10/2022 07:09:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '61141' 05/10/2022 07:09: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 ( '61141' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/10/2022 07:09:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 05/10/2022 07:09:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 05/10/2022 07:10:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2613' AND id_document != '61137' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-02') 05/10/2022 07:10:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2613', document_date = '2022-09-02', 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 = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '61137' 05/10/2022 07:10:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61137' 05/10/2022 07:10:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '61137' 05/10/2022 07:10:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61137' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 05/10/2022 07:10:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/10/2022 07:10:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/10/2022 07:10:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61137' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 05/10/2022 07:10:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 05/10/2022 07:10:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 05/10/2022 07:10:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61137' , '12490' , 'CROCE SAN BENEDETTO ULIVO COL' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 05/10/2022 07:10:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12490' AND id_supplier = '' 05/10/2022 07:10:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12490' , '' , '1' ) 05/10/2022 07:10:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61137' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '2.60' ) 05/10/2022 07:10:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 05/10/2022 07:10:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 05/10/2022 07:19:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/S' AND id_document != '7138' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 07:19:34 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '21/S', document_date = '2022-10-05', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '4670192', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '43.75', price_tax_excluded = '43.75', date_upd = NOW() WHERE id_document = '7138' 05/10/2022 07:19: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 = '7138' 05/10/2022 07:19:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '7138' 05/10/2022 07:19: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 ( '7138' , '75' , 'IL SEGNO DELLA CROCE' , '25' , '-25' , '4' , '1.5000' , '1.5' , '0' , '50' , '18.75' ) 05/10/2022 07:19:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '75' AND id_supplier = '' 05/10/2022 07:19:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '75' , '' , '1' ) 05/10/2022 07:19: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 ( '7138' , '50' , 'PERDONAMI SIGNORE' , '25' , '-25' , '4' , '2.0000' , '2' , '0' , '50' , '25.00' ) 05/10/2022 07:19:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '50' AND id_supplier = '' 05/10/2022 07:19:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '50' , '' , '1' ) 05/10/2022 07:32:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243095' AND id_product != '11315' AND ean13 != '' 05/10/2022 07:32:55 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/3', ean13 = '9788861243095', date_upd = NOW() WHERE id_product = '11315' 05/10/2022 07:32:55 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS SPIEGATA AI BAMBINI', description = '' WHERE id_product = '11315' 05/10/2022 07:32:55 pm >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.9' WHERE id_product = '11315' 05/10/2022 07:32:55 pm >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '11315' 05/10/2022 07:32:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '11315' 05/10/2022 07:34:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243149' AND id_product != '8728' AND ean13 != '' 05/10/2022 07:34:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788861243149', date_upd = NOW() WHERE id_product = '8728' 05/10/2022 07:34:12 pm >> UPDATE ps_product_lang SET name = 'QUARESIMA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '8728' 05/10/2022 07:34:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '8728' 05/10/2022 07:34:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '8728' 05/10/2022 07:34:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '8728' 05/10/2022 07:34:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245990' AND id_product != '7550' AND ean13 != '' 05/10/2022 07:34:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788861245990', date_upd = NOW() WHERE id_product = '7550' 05/10/2022 07:34:27 pm >> UPDATE ps_product_lang SET name = 'PARABOLE SPIEGATE AI BAMBINI', description = '' WHERE id_product = '7550' 05/10/2022 07:34:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '7550' 05/10/2022 07:34:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '7550' 05/10/2022 07:34:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '7550' 05/10/2022 07:35:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244092' AND id_product != '7682' AND ean13 != '' 05/10/2022 07:35:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788861244092', date_upd = NOW() WHERE id_product = '7682' 05/10/2022 07:35:25 pm >> UPDATE ps_product_lang SET name = 'PASQUA SPIEGATA AI BAMBINI ', description = '' WHERE id_product = '7682' 05/10/2022 07:35:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '7682' 05/10/2022 07:35:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '7682' 05/10/2022 07:35:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '7682' 05/10/2022 07:35:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242661' AND id_product != '2636' AND ean13 != '' 05/10/2022 07:35:50 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/3', ean13 = '9788861242661', date_upd = NOW() WHERE id_product = '2636' 05/10/2022 07:35:50 pm >> UPDATE ps_product_lang SET name = 'CONFESSIONE SPIEGATA AI BAMBINI', description = '' WHERE id_product = '2636' 05/10/2022 07:35:50 pm >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.9' WHERE id_product = '2636' 05/10/2022 07:35:50 pm >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2636' 05/10/2022 07:35:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '2636' 05/10/2022 07:36:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861246881' AND id_product != '13129' AND ean13 != '' 05/10/2022 07:36:02 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/3', ean13 = '9788861246881', date_upd = NOW() WHERE id_product = '13129' 05/10/2022 07:36:02 pm >> UPDATE ps_product_lang SET name = 'ESAME DI COSCIENZA SPIEGATO AI BAMBINI', description = '' WHERE id_product = '13129' 05/10/2022 07:36:02 pm >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.9' WHERE id_product = '13129' 05/10/2022 07:36:02 pm >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '13129' 05/10/2022 07:36:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '13129' 05/10/2022 07:43:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2770' AND id_document != '61844' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 05/10/2022 07:43:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2770', document_date = '2022-09-17', 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 = '37.50', price_tax_excluded = '37.50', date_upd = NOW() WHERE id_document = '61844' 05/10/2022 07:43:46 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 = '61844' 05/10/2022 07:43:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '61844' 05/10/2022 07:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61844' , '12353' , 'VERITA E SINTETICA - M. GAGLIARDI' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 05/10/2022 07:43:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12353' AND id_supplier = '' 05/10/2022 07:43:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12353' , '' , '1' ) 05/10/2022 07:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61844' , '14642' , 'FIDES ET RATIO - GIOVANNI PAOLO II' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 05/10/2022 07:43:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14642' AND id_supplier = '' 05/10/2022 07:43:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14642' , '' , '1' ) 05/10/2022 07:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61844' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.2' , '5.2' , '0' , '0' , '5.20' ) 05/10/2022 07:43:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/10/2022 07:43:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/10/2022 08:02:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '36/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-05') 05/10/2022 08:02:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '36/E' , '2022-10-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '17326.90' , '17265.68' , NOW() , NOW() ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65170' 05/10/2022 08:02:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '65170' 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '418' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '501.60' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '113' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '141.25' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5446' , 'IO SONO CON VOI - GUIDA' , '14' , '0' , '4' , '6.00' , '6' , '0' , '50' , '42.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11183' , 'VENITE CON ME - GUIDA' , '10' , '0' , '4' , '6.00' , '6' , '0' , '50' , '30.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '6.20' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '9675' , 'SARETE MIEI TESTIMONI' , '234' , '0' , '4' , '3.00' , '3' , '0' , '50' , '351.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1822' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2277.50' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1668' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2085.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11191' , 'VENITE CON ME 1 PARTE' , '1783' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2228.75' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11192' , 'VENITE CON ME 2 PARTE' , '1275' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1593.75' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '140' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '245.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '6' , '0' , '4' , '8.00' , '8' , '0' , '50' , '24.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '8' , '0' , '4' , '10.00' , '10' , '0' , '50' , '40.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5251' , 'INCONTRI EUCARISTICI' , '3' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '6.75' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '3' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '5.10' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '14' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '23.80' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '9996' , 'SIGNORE, TI PREGO' , '3' , '0' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '25' , '0' , '4' , '6.00' , '6' , '0' , '50' , '75.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '6629' , 'MIA PREGHIERA' , '249' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '112.05' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8408' , 'PRENDETE E MANGIATE' , '420' , '0' , '4' , '3.00' , '3' , '0' , '50' , '630.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '12' , '0' , '4' , '5.00' , '5' , '0' , '50' , '30.00' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4154' , 'FESTA DEL PERDONO' , '375' , '0' , '4' , '3.00' , '3' , '0' , '50' , '562.50' ) 05/10/2022 08:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '2679' , 'CONOSCERE GESU' , '317' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '554.75' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '2680' , 'CONOSCERE GESU - GUIDA' , '17' , '0' , '4' , '6.00' , '6' , '0' , '50' , '51.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '4.25' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '22' , '0' , '4' , '5.00' , '5' , '0' , '50' , '55.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '166' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '132.80' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '9' , '0' , '4' , '12.00' , '12' , '0' , '50' , '54.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '172' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '137.60' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '16' , '0' , '4' , '3.00' , '3' , '0' , '50' , '24.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '7543' , 'PARABOLE DI GESÙ' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '214' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '374.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '209' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '365.75' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '172' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '301.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '573' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '458.40' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '12819' , 'REGISTRO DEL CATECHISTA ' , '679' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '339.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '12' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '21.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '8' , '0' , '4' , '6.00' , '6' , '0' , '50' , '24.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '13397' , 'MIO GESU' , '26' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '45.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '13956' , 'MIRACOLI DI GESU' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '45' , '0' , '4' , '1.00' , '1' , '0' , '50' , '22.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '15019' , 'PREGHIAMO CON MARIA' , '46' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '18.40' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '15020' , 'PREGARE OGNI GIORNO' , '76' , '0' , '4' , '1.00' , '1' , '0' , '50' , '38.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '6' , '0' , '4' , '6.00' , '6' , '0' , '50' , '18.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '11' , '0' , '4' , '1.00' , '1' , '0' , '50' , '5.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '16667' , 'VIA CRUCIS' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '0' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '17257' , 'IO TI BATTEZZO ' , '37' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '33.30' ) 05/10/2022 08:02:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '6' , '0' , '4' , '1.00' , '1' , '0' , '50' , '3.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '20' , '0' , '4' , '2.00' , '2' , '0' , '50' , '20.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '39' , '0' , '4' , '2.00' , '2' , '0' , '50' , '39.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '14' , '0' , '4' , '7.00' , '7' , '0' , '50' , '49.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '12' , '0' , '4' , '9.00' , '9' , '0' , '50' , '54.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '17' , '0' , '4' , '9.00' , '9' , '0' , '50' , '76.50' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '8' , '0' , '4' , '9.00' , '9' , '0' , '50' , '36.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '5' , '0' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '2' , '0' , '4' , '18.00' , '18' , '0' , '50' , '18.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '5' , '0' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '36' , '0' , '4' , '12.00' , '12' , '0' , '50' , '216.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '5' , '0' , '4' , '20.00' , '20' , '0' , '50' , '50.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '434' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '542.50' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '85' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '191.25' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '84' , '0' , '4' , '35.00' , '35' , '0' , '50' , '1470.00' ) 05/10/2022 08:02:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65170' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '176' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '220.00' )