28/12/2022 08:27:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3316' AND id_document != '70337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-03') 28/12/2022 08:27:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3316', document_date = '2022-11-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 = '750.00', price_tax_excluded = '614.75', date_upd = NOW() WHERE id_document = '70337' 28/12/2022 08:27:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70337' 28/12/2022 08:27:56 am >> DELETE FROM ps_document_detail WHERE id_document = '70337' 28/12/2022 08:27:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70337' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '750' , '614.75409836066' , '22' , '0' , '750.00' ) 28/12/2022 08:37:18 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/12/2022 08:37:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20592' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:37:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20592' , '1' , '1' , '2' , NOW() , NOW() ) 28/12/2022 08:37:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20592' , '0' , '1' , '0' , '0' ) 28/12/2022 08:37:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048080' AND id_product != '20592' AND ean13 != '' 28/12/2022 08:37:56 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048080', date_upd = NOW() WHERE id_product = '20592' 28/12/2022 08:37:56 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA MAR/APR 23', description = '' WHERE id_product = '20592' 28/12/2022 08:37:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '20592' 28/12/2022 08:37:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', 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 = '20592' 28/12/2022 08:37:56 am >> DELETE FROM ps_specific_price WHERE id_product = '20592' 28/12/2022 08:37:56 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 = '20592' 28/12/2022 08:37:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20593' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:37:57 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 '20593' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20592' 28/12/2022 08:37:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20593' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20592' 28/12/2022 08:38:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048325' AND id_product != '20593' AND ean13 != '' 28/12/2022 08:38:52 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048325', date_upd = NOW() WHERE id_product = '20593' 28/12/2022 08:38:52 am >> UPDATE ps_product_lang SET name = 'CHIESA E\' PER L\'AVANGELIZZAZIONE', description = '' WHERE id_product = '20593' 28/12/2022 08:38:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20593' 28/12/2022 08:38:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20593' 28/12/2022 08:38:52 am >> DELETE FROM ps_specific_price WHERE id_product = '20593' 28/12/2022 08:38:54 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 = '20593' 28/12/2022 08:38:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20594' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:38:54 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 '20594' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20593' 28/12/2022 08:38:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20594' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20593' 28/12/2022 08:39:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048325' AND id_product != '20593' AND ean13 != '' 28/12/2022 08:39:20 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048325', date_upd = NOW() WHERE id_product = '20593' 28/12/2022 08:39:20 am >> UPDATE ps_product_lang SET name = 'CHIESA E\' PER L\'AVANGELIZZAZIONE - 19', description = '' WHERE id_product = '20593' 28/12/2022 08:39:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0000' WHERE id_product = '20593' 28/12/2022 08:39:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20593' 28/12/2022 08:39:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20593' 28/12/2022 08:39:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048349' AND id_product != '20594' AND ean13 != '' 28/12/2022 08:39:46 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048349', date_upd = NOW() WHERE id_product = '20594' 28/12/2022 08:39:46 am >> UPDATE ps_product_lang SET name = 'LAICI - 21', description = '' WHERE id_product = '20594' 28/12/2022 08:39:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20594' 28/12/2022 08:39:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20594' 28/12/2022 08:39:47 am >> DELETE FROM ps_specific_price WHERE id_product = '20594' 28/12/2022 08:39:48 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 = '20594' 28/12/2022 08:39:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20595' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:39:48 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 '20595' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20594' 28/12/2022 08:39:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20595' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20594' 28/12/2022 08:40:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048363' AND id_product != '20595' AND ean13 != '' 28/12/2022 08:40:15 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048363', date_upd = NOW() WHERE id_product = '20595' 28/12/2022 08:40:15 am >> UPDATE ps_product_lang SET name = 'SANTITA\' UNA VOCAZIONE - 23', description = '' WHERE id_product = '20595' 28/12/2022 08:40:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20595' 28/12/2022 08:40:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20595' 28/12/2022 08:40:15 am >> DELETE FROM ps_specific_price WHERE id_product = '20595' 28/12/2022 08:40:16 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 = '20595' 28/12/2022 08:40:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20596' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:40:16 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 '20596' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20595' 28/12/2022 08:40:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20596' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20595' 28/12/2022 08:40:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048387' AND id_product != '20596' AND ean13 != '' 28/12/2022 08:40:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048387', date_upd = NOW() WHERE id_product = '20596' 28/12/2022 08:40:49 am >> UPDATE ps_product_lang SET name = 'MARIA LA PRIMA DI CREDENTI - 25', description = '' WHERE id_product = '20596' 28/12/2022 08:40:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20596' 28/12/2022 08:40:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20596' 28/12/2022 08:40:49 am >> DELETE FROM ps_specific_price WHERE id_product = '20596' 28/12/2022 08:40:50 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 = '20596' 28/12/2022 08:40:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20597' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:40:50 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 '20597' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20596' 28/12/2022 08:40:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20597' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20596' 28/12/2022 08:41:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048394' AND id_product != '20597' AND ean13 != '' 28/12/2022 08:41:15 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048394', date_upd = NOW() WHERE id_product = '20597' 28/12/2022 08:41:15 am >> UPDATE ps_product_lang SET name = 'CHIESA NEL MONDO DI OGGI - 26', description = '' WHERE id_product = '20597' 28/12/2022 08:41:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20597' 28/12/2022 08:41:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20597' 28/12/2022 08:41:15 am >> DELETE FROM ps_specific_price WHERE id_product = '20597' 28/12/2022 08:41:16 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 = '20597' 28/12/2022 08:41:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20598' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:41:16 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 '20598' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20597' 28/12/2022 08:41:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20598' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20597' 28/12/2022 08:41:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048400' AND id_product != '20598' AND ean13 != '' 28/12/2022 08:41:44 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048400', date_upd = NOW() WHERE id_product = '20598' 28/12/2022 08:41:44 am >> UPDATE ps_product_lang SET name = 'GRANDE TEMA DEL SENSO DELLA VITA - 27', description = '' WHERE id_product = '20598' 28/12/2022 08:41:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20598' 28/12/2022 08:41:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20598' 28/12/2022 08:41:44 am >> DELETE FROM ps_specific_price WHERE id_product = '20598' 28/12/2022 08:41:45 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 = '20598' 28/12/2022 08:41:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20599' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:41:45 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 '20599' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20598' 28/12/2022 08:41:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20599' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20598' 28/12/2022 08:42:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048417' AND id_product != '20599' AND ean13 != '' 28/12/2022 08:42:05 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048417', date_upd = NOW() WHERE id_product = '20599' 28/12/2022 08:42:05 am >> UPDATE ps_product_lang SET name = 'SOCIETA\' DEGLI UOMINI - 28', description = '' WHERE id_product = '20599' 28/12/2022 08:42:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20599' 28/12/2022 08:42:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20599' 28/12/2022 08:42:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20599' 28/12/2022 08:42:06 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 = '20599' 28/12/2022 08:42:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20600' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:42:06 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 '20600' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20599' 28/12/2022 08:42:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20600' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20599' 28/12/2022 08:42:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048424' AND id_product != '20600' AND ean13 != '' 28/12/2022 08:42:30 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048424', date_upd = NOW() WHERE id_product = '20600' 28/12/2022 08:42:30 am >> UPDATE ps_product_lang SET name = 'AUTONOMIA E SERVIZIO - 29', description = '' WHERE id_product = '20600' 28/12/2022 08:42:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20600' 28/12/2022 08:42:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20600' 28/12/2022 08:42:30 am >> DELETE FROM ps_specific_price WHERE id_product = '20600' 28/12/2022 08:42:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20600' 28/12/2022 08:42:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20601' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:42:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20601' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20600' 28/12/2022 08:42:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20601' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20600' 28/12/2022 08:42:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048431' AND id_product != '20601' AND ean13 != '' 28/12/2022 08:42:48 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048431', date_upd = NOW() WHERE id_product = '20601' 28/12/2022 08:42:48 am >> UPDATE ps_product_lang SET name = 'FAMIGLIA -30', description = '' WHERE id_product = '20601' 28/12/2022 08:42:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20601' 28/12/2022 08:42:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20601' 28/12/2022 08:42:48 am >> DELETE FROM ps_specific_price WHERE id_product = '20601' 28/12/2022 08:42:49 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 = '20601' 28/12/2022 08:42:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20602' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:42:50 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 '20602' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20601' 28/12/2022 08:42:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20602' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20601' 28/12/2022 08:43:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048448' AND id_product != '20602' AND ean13 != '' 28/12/2022 08:43:07 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048448', date_upd = NOW() WHERE id_product = '20602' 28/12/2022 08:43:07 am >> UPDATE ps_product_lang SET name = 'CULTURA - 31', description = '' WHERE id_product = '20602' 28/12/2022 08:43:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20602' 28/12/2022 08:43:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20602' 28/12/2022 08:43:07 am >> DELETE FROM ps_specific_price WHERE id_product = '20602' 28/12/2022 08:43:08 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 = '20602' 28/12/2022 08:43:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20603' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:43: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 '20603' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20602' 28/12/2022 08:43:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20603' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20602' 28/12/2022 08:43:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9722824042455' AND id_product != '20603' AND ean13 != '' 28/12/2022 08:43:29 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9722824042455', date_upd = NOW() WHERE id_product = '20603' 28/12/2022 08:43:29 am >> UPDATE ps_product_lang SET name = 'ECONOMIA E LA FINANZA', description = '' WHERE id_product = '20603' 28/12/2022 08:43:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20603' 28/12/2022 08:43:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20603' 28/12/2022 08:43:29 am >> DELETE FROM ps_specific_price WHERE id_product = '20603' 28/12/2022 08:43:30 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 = '20603' 28/12/2022 08:43:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20604' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:43:30 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 '20604' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20603' 28/12/2022 08:43:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20604' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20603' 28/12/2022 08:43:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048462' AND id_product != '20604' AND ean13 != '' 28/12/2022 08:43:46 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048462', date_upd = NOW() WHERE id_product = '20604' 28/12/2022 08:43:46 am >> UPDATE ps_product_lang SET name = 'POLITICA - 33', description = '' WHERE id_product = '20604' 28/12/2022 08:43:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20604' 28/12/2022 08:43:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20604' 28/12/2022 08:43:46 am >> DELETE FROM ps_specific_price WHERE id_product = '20604' 28/12/2022 08:43:47 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 = '20604' 28/12/2022 08:43:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20605' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:43:47 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 '20605' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20604' 28/12/2022 08:43:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20605' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20604' 28/12/2022 08:44:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048479' AND id_product != '20605' AND ean13 != '' 28/12/2022 08:44:07 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048479', date_upd = NOW() WHERE id_product = '20605' 28/12/2022 08:44:07 am >> UPDATE ps_product_lang SET name = 'DIALOGO COME STRUMENTO - 34', description = '' WHERE id_product = '20605' 28/12/2022 08:44:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20605' 28/12/2022 08:44:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20605' 28/12/2022 08:44:07 am >> DELETE FROM ps_specific_price WHERE id_product = '20605' 28/12/2022 08:44:08 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 = '20605' 28/12/2022 08:44:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20606' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:44:08 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 '20606' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20605' 28/12/2022 08:44:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20606' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20605' 28/12/2022 08:44:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048486' AND id_product != '20606' AND ean13 != '' 28/12/2022 08:44:24 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788884048486', date_upd = NOW() WHERE id_product = '20606' 28/12/2022 08:44:24 am >> UPDATE ps_product_lang SET name = 'PACE - 35', description = '' WHERE id_product = '20606' 28/12/2022 08:44:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20606' 28/12/2022 08:44:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20606' 28/12/2022 08:44:24 am >> DELETE FROM ps_specific_price WHERE id_product = '20606' 28/12/2022 08:44:25 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 = '20606' 28/12/2022 08:44:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20607' , '1' , '' , 'nuovo-prodotto' ) 28/12/2022 08:44:25 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 '20607' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20606' 28/12/2022 08:44:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20607' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20606' 28/12/2022 08:47:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '22107/00/2022' , '2022-12-28' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '125.40' , '123.67' , NOW() , NOW() ) 28/12/2022 08:47:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77563' 28/12/2022 08:47:01 am >> DELETE FROM ps_document_detail WHERE id_document = '77563' 28/12/2022 08:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77563' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '10' , '10' , '4' , '5.00' , '5' , '0' , '40' , '30.0000' ) 28/12/2022 08:47:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '38' 28/12/2022 08:47:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '38' , '1' ) 28/12/2022 08:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77563' , '20592' , 'SULLA TUA PAROLA MAR/APR 23' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 28/12/2022 08:47:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20592' AND id_supplier = '38' 28/12/2022 08:47:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20592' , '38' , '1' ) 28/12/2022 08:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77563' , '20593' , 'CHIESA E PER LAVANGELIZZAZIONE' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20593' AND id_supplier = '38' 28/12/2022 08:47:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20593' , '38' , '1' ) 28/12/2022 08:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77563' , '20595' , 'SANTITA UNA VOCAZIONE - 23' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20595' AND id_supplier = '38' 28/12/2022 08:47:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20595' , '38' , '1' ) 28/12/2022 08:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77563' , '20594' , 'LAICI - 21' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20594' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20594' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20596' , 'MARIA LA PRIMA DI CREDENTI - 25' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20596' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20596' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20597' , 'CHIESA NEL MONDO DI OGGI - 26' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20597' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20597' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20598' , 'GRANDE TEMA DEL SENSO DELLA VITA - 27' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20598' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20598' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20599' , 'SOCIETA DEGLI UOMINI - 28' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20599' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20599' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20600' , 'AUTONOMIA E SERVIZIO - 29' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20600' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20600' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20601' , 'FAMIGLIA -30' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20601' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20601' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20602' , 'CULTURA - 31' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20602' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20602' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20603' , 'ECONOMIA E LA FINANZA' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20603' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20603' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20604' , 'POLITICA - 33' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20604' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20604' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20605' , 'DIALOGO COME STRUMENTO - 34' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20605' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20605' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20606' , 'PACE - 35' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20606' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20606' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '8398' , 'PREGHIERE PRIMA E DOPO LA COMUNIONE - 8276' , '3' , '3' , '4' , '4.00' , '4' , '0' , '40' , '7.2000' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '8398' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8398' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '3' , '3' , '1' , '1.64' , '1.344262295082' , '22' , '40' , '3.6014' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20089' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20089' , '38' , '1' ) 28/12/2022 08:47: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 ( '77563' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '1' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '6.0024' ) 28/12/2022 08:47:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '38' 28/12/2022 08:47:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '38' , '1' ) 28/12/2022 09:12:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2455' AND id_document != '59934' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-05') 28/12/2022 09:12:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2455', document_date = '2022-08-05', 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 = '365.00', price_tax_excluded = '299.18', date_upd = NOW() WHERE id_document = '59934' 28/12/2022 09:12:36 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 = '59934' 28/12/2022 09:12:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59934' 28/12/2022 09:12:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59934' , '19097' , 'CINGOLO - CING04' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 28/12/2022 09:12:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59934' , '20226' , 'BAMBINELLO IN GESSO CM 50 STILE ANTICO - J202/50' , '1' , '-1' , '1' , '336' , '275.40983606557' , '22' , '0' , '336.00' ) 28/12/2022 09:13:12 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 28/12/2022 09:13:12 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 200,00 - ', 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 = '390.90', price_tax_excluded = '323.37', date_upd = NOW() WHERE id_document = '57793' 28/12/2022 09:13:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57793' 28/12/2022 09:13:12 am >> DELETE FROM ps_document_detail WHERE id_document = '57793' 28/12/2022 09:13:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '11' , '-11' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '20.90' ) 28/12/2022 09:13:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '0' , '15/12/2022' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 28/12/2022 09:13:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '20226' , 'BAMBINELLO IN GESSO CM 50 STILE ANTICO - J202/50 ***' , '1' , '-1' , '1' , '370.0000' , '303.27868852459' , '22' , '0' , '370.00' ) 28/12/2022 09:16:15 am >> SELECT document_num FROM ps_document WHERE document_num = '4109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 09:16:15 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' , '4109' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '800.00' , '655.74' , NOW() , NOW() ) 28/12/2022 09:16:15 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 = '77564' 28/12/2022 09:16:15 am >> DELETE FROM ps_document_detail WHERE id_document = '77564' 28/12/2022 09:16:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77564' , '19912' , 'CASULA AGNELLO - L/S/ MOIRE - 8219-8249LS' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 28/12/2022 09:40:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4069' AND id_document != '77514' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 28/12/2022 09:40:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4069', document_date = '2022-12-23', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '77514' 28/12/2022 09:40: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 = '77514' 28/12/2022 09:40:48 am >> DELETE FROM ps_document_detail WHERE id_document = '77514' 28/12/2022 09:40: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 ( '77514' , '5095' , 'IMMAGINI ASSORTITE X 100' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 28/12/2022 10:17:16 am >> SELECT document_num FROM ps_document WHERE document_num = '334' AND id_document != '77214' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 28/12/2022 10:17:16 am >> UPDATE ps_document SET id_document_type = '21', document_num = '334', document_date = '2022-12-12', document_letter = '', id_customer = '3991', id_supplier = '', id_address = '4677900', address1 = 'Via Giuseppe Giusti , 68 74028 Sava ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '13.00', price_tax_excluded = '13.00', date_upd = NOW() WHERE id_document = '77214' 28/12/2022 10:17:16 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 = '77214' 28/12/2022 10:17:16 am >> DELETE FROM ps_document_detail WHERE id_document = '77214' 28/12/2022 10:17:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77214' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 28/12/2022 10:17:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77214' , '13397' , 'MIO GESU\'' , '2' , '-2' , '4' , '2.55' , '2.55' , '0' , '0' , '5.10' ) 28/12/2022 10:25:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2905' AND id_document != '63585' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 28/12/2022 10:25:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2905', 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 = '24.80', price_tax_excluded = '24.65', date_upd = NOW() WHERE id_document = '63585' 28/12/2022 10:25:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63585' 28/12/2022 10:25:55 am >> DELETE FROM ps_document_detail WHERE id_document = '63585' 28/12/2022 10:25:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63585' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 28/12/2022 10:25:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63585' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '5' , '17.58' ) 28/12/2022 10:25:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63585' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '1.71' , '1.71' , '0' , '0' , '3.42' ) 28/12/2022 10:26:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2999' AND id_document != '65772' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 28/12/2022 10:26:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2999', document_date = '2022-10-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.30', price_tax_excluded = '5.31', date_upd = NOW() WHERE id_document = '65772' 28/12/2022 10:26:14 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 = '65772' 28/12/2022 10:26:14 am >> DELETE FROM ps_document_detail WHERE id_document = '65772' 28/12/2022 10:26:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65772' , '9118' , 'ROSARIO IN LEGNO FRANCESCANO - 7/P - RL348' , '1' , '-1' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '5.50' ) 28/12/2022 10:26:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65772' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 28/12/2022 10:26:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3000' AND id_document != '65773' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 28/12/2022 10:26:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3000', document_date = '2022-10-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.00', price_tax_excluded = '18.21', date_upd = NOW() WHERE id_document = '65773' 28/12/2022 10:26: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 = '65773' 28/12/2022 10:26:32 am >> DELETE FROM ps_document_detail WHERE id_document = '65773' 28/12/2022 10:26:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65773' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '5.50' ) 28/12/2022 10:26:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65773' , '19753' , 'INCENSO GLORIA' , '1' , '-1' , '1' , '15.5000' , '12.704918032787' , '22' , '0' , '15.50' ) 28/12/2022 10:26:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65773' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.5' , '0.5' , '0' , '0' , '1.00' ) 28/12/2022 10:26:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3045' AND id_document != '66348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 28/12/2022 10:26:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3045', document_date = '2022-10-14', 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 = '18.75', price_tax_excluded = '18.25', date_upd = NOW() WHERE id_document = '66348' 28/12/2022 10:26:50 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 = '66348' 28/12/2022 10:26:50 am >> DELETE FROM ps_document_detail WHERE id_document = '66348' 28/12/2022 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '3' , '-3' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.75' ) 28/12/2022 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 28/12/2022 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 28/12/2022 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.25' ) 28/12/2022 10:26:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '11880' , 'ANNO CON LA BIBBIA - 8829' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 28/12/2022 10:26:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.2500' , '1.0245901639344' , '22' , '0' , '1.25' ) 28/12/2022 10:27:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3050' AND id_document != '66353' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 28/12/2022 10:27:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3050', document_date = '2022-10-14', 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 = '73.85', price_tax_excluded = '70.08', date_upd = NOW() WHERE id_document = '66353' 28/12/2022 10:27: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 = '66353' 28/12/2022 10:27:21 am >> DELETE FROM ps_document_detail WHERE id_document = '66353' 28/12/2022 10:27: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 ( '66353' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '3' , '-3' , '4' , '1.4000' , '1.4' , '0' , '0' , '4.20' ) 28/12/2022 10:27: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 ( '66353' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 28/12/2022 10:27: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 ( '66353' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 28/12/2022 10:27: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 ( '66353' , '3438' , 'DIECI COMANDAMENTI SPIEGATI AI RAGAZZI - BOCCI VALERIO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 28/12/2022 10:27: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 ( '66353' , '4168' , 'FIGLI DEL VENTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/12/2022 10:27: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 ( '66353' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 28/12/2022 10:27: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 ( '66353' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/12/2022 10:27: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 ( '66353' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '2.85' , '2.85' , '0' , '0' , '28.50' ) 28/12/2022 10:27:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2947' AND id_document != '65183' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-06') 28/12/2022 10:27:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2947', document_date = '2022-10-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '117.30', price_tax_excluded = '101.29', date_upd = NOW() WHERE id_document = '65183' 28/12/2022 10:27:46 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 = '65183' 28/12/2022 10:27:46 am >> DELETE FROM ps_document_detail WHERE id_document = '65183' 28/12/2022 10:27: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 ( '65183' , '1290' , 'BRACCIALE 7 DONI' , '24' , '-24' , '1' , '3.7000' , '3.0327868852459' , '22' , '0' , '88.80' ) 28/12/2022 10:27: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 ( '65183' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '2.85' , '2.85' , '0' , '0' , '28.50' ) 28/12/2022 10:28:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3158' AND id_document != '68064' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 28/12/2022 10:28:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3158', document_date = '2022-10-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '77.65', price_tax_excluded = '75.49', date_upd = NOW() WHERE id_document = '68064' 28/12/2022 10:28:15 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 = '68064' 28/12/2022 10:28:15 am >> DELETE FROM ps_document_detail WHERE id_document = '68064' 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '8387' , 'PREGHIERE PER LE ANIME DEI DEFUNTI - 8147' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 28/12/2022 10:28:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '14991' , 'PRESEPE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 28/12/2022 10:28:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3152' AND id_document != '68054' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 28/12/2022 10:28:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3152', document_date = '2022-10-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '59.10', price_tax_excluded = '51.41', date_upd = NOW() WHERE id_document = '68054' 28/12/2022 10:28: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 = '68054' 28/12/2022 10:28:49 am >> DELETE FROM ps_document_detail WHERE id_document = '68054' 28/12/2022 10:28: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 ( '68054' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 28/12/2022 10:28: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 ( '68054' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 28/12/2022 10:28: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 ( '68054' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 28/12/2022 10:28: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 ( '68054' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '5' , '-5' , '4' , '2.1' , '2.1' , '0' , '0' , '10.50' ) 28/12/2022 10:29:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3163' AND id_document != '68070' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-24') 28/12/2022 10:29:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3163', document_date = '2022-10-24', 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 = '247.50', price_tax_excluded = '244.25', date_upd = NOW() WHERE id_document = '68070' 28/12/2022 10:29:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68070' 28/12/2022 10:29:13 am >> DELETE FROM ps_document_detail WHERE id_document = '68070' 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '23' , '-23' , '4' , '2.7000' , '2.7' , '0' , '0' , '62.10' ) 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '37' , '-37' , '4' , '2.7000' , '2.7' , '0' , '0' , '99.90' ) 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '18' , '-18' , '4' , '2.7000' , '2.7' , '0' , '0' , '48.60' ) 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '-2' , '4' , '5.4000' , '5.4' , '0' , '0' , '10.80' ) 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '12819' , 'REGISTRO DEL CATECHISTA ' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '10' , '18.00' ) 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.35' , '3.35' , '0' , '0' , '3.35' ) 28/12/2022 10:29:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68070' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/12/2022 10:29:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3165' AND id_document != '68072' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-24') 28/12/2022 10:29:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3165', document_date = '2022-10-24', 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 = '73.80', price_tax_excluded = '66.95', date_upd = NOW() WHERE id_document = '68072' 28/12/2022 10:29:33 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 = '68072' 28/12/2022 10:29:33 am >> DELETE FROM ps_document_detail WHERE id_document = '68072' 28/12/2022 10:29: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 ( '68072' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.55' , '2.55' , '0' , '0' , '2.55' ) 28/12/2022 10:29: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 ( '68072' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 28/12/2022 10:29: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 ( '68072' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '7' , '-7' , '4' , '5.0000' , '5' , '0' , '5' , '33.25' ) 28/12/2022 10:30:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3175' AND id_document != '68599' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 28/12/2022 10:30:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3175', document_date = '2022-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '44.00', price_tax_excluded = '44.00', date_upd = NOW() WHERE id_document = '68599' 28/12/2022 10:30:03 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 = '68599' 28/12/2022 10:30:03 am >> DELETE FROM ps_document_detail WHERE id_document = '68599' 28/12/2022 10:30: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 ( '68599' , '15122' , 'PREGHIERE PER OGNI GIORNO DELLANNO - 8738' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 28/12/2022 10:30: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 ( '68599' , '19745' , 'BUON COMPLEANNO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 28/12/2022 10:30: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 ( '68599' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '100' , '0.00' ) 28/12/2022 10:30: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 ( '68599' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.55' ) 28/12/2022 10:30: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 ( '68599' , '3511' , 'DIO PARLA ALL\'UOMO' , '2' , '-2' , '4' , '7.7' , '7.7' , '0' , '0' , '15.40' ) 28/12/2022 10:30:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3228' AND id_document != '69700' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-28') 28/12/2022 10:30:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3228', document_date = '2022-10-28', 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 = '135.00', price_tax_excluded = '132.83', date_upd = NOW() WHERE id_document = '69700' 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69700' 28/12/2022 10:30:29 am >> DELETE FROM ps_document_detail WHERE id_document = '69700' 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69700' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69700' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69700' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '5' , '85.50' ) 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69700' , '12819' , 'REGISTRO DEL CATECHISTA ' , '7' , '-7' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '7.00' ) 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69700' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '1.9' , '1.9' , '0' , '0' , '3.80' ) 28/12/2022 10:30:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69700' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 28/12/2022 10:30:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3278' AND id_document != '70281' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 28/12/2022 10:30:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3278', document_date = '2022-10-31', 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 = '134.60', price_tax_excluded = '134.60', date_upd = NOW() WHERE id_document = '70281' 28/12/2022 10:30: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 = '70281' 28/12/2022 10:30:48 am >> DELETE FROM ps_document_detail WHERE id_document = '70281' 28/12/2022 10:30: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 ( '70281' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '24' , '-24' , '4' , '2.7000' , '2.7' , '0' , '0' , '64.80' ) 28/12/2022 10:30: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 ( '70281' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '22' , '-22' , '4' , '2.7000' , '2.7' , '0' , '0' , '59.40' ) 28/12/2022 10:30: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 ( '70281' , '20055' , 'NON TEMERE - AVVENTO 2022' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '0' , '3.40' ) 28/12/2022 10:30: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 ( '70281' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/12/2022 10:30: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 ( '70281' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 28/12/2022 10:31:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3272' AND id_document != '70273' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 28/12/2022 10:31:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3272', document_date = '2022-10-31', 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 = '100.00', price_tax_excluded = '86.99', date_upd = NOW() WHERE id_document = '70273' 28/12/2022 10:31: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 = '70273' 28/12/2022 10:31:17 am >> DELETE FROM ps_document_detail WHERE id_document = '70273' 28/12/2022 10:31: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 ( '70273' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 28/12/2022 10:31: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 ( '70273' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/12/2022 10:31: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 ( '70273' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.45' , '1.45' , '0' , '0' , '1.45' ) 28/12/2022 10:31: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 ( '70273' , '20057' , 'CINQUE PANI DORZO 2023' , '2' , '-2' , '4' , '6.9000' , '6.9' , '0' , '5' , '13.12' ) 28/12/2022 10:31: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 ( '70273' , '17416' , 'RETINA RICAMBIO ART 355' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 28/12/2022 10:31: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 ( '70273' , '18031' , 'BRUCIAINCENSO H 8' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 28/12/2022 10:31: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 ( '70273' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '29.6300' , '24.286885245902' , '22' , '0' , '29.63' ) 28/12/2022 10:31: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 ( '70273' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 28/12/2022 10:31: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 ( '70273' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 28/12/2022 10:31: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 ( '70273' , '17713' , 'FARSI SANTI CON CIO CHE C\'E\' - L. EPICOCO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 28/12/2022 10:31:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3365' AND id_document != '70918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-07') 28/12/2022 10:31:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3365', document_date = '2022-11-07', 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 = '130.00', price_tax_excluded = '120.08', date_upd = NOW() WHERE id_document = '70918' 28/12/2022 10:31: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 = '70918' 28/12/2022 10:31:35 am >> DELETE FROM ps_document_detail WHERE id_document = '70918' 28/12/2022 10:31: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 ( '70918' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 28/12/2022 10:31: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 ( '70918' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 28/12/2022 10:31: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 ( '70918' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.1' , '2.1' , '0' , '0' , '4.20' ) 28/12/2022 10:31: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 ( '70918' , '20492' , 'AMORE IN UNO SGUARDO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 28/12/2022 10:31: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 ( '70918' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/12/2022 10:31: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 ( '70918' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/12/2022 10:31: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 ( '70918' , '20443' , 'PAROLA E PREGHIERA - GEN. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 28/12/2022 10:31: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 ( '70918' , '20024' , 'PER LETERNITA - R. SARAH' , '1' , '-1' , '4' , '23.0000' , '23' , '0' , '5' , '21.85' ) 28/12/2022 10:31: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 ( '70918' , '20527' , 'AMEN - APR 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/12/2022 10:31: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 ( '70918' , '20528' , 'AMEN - MAR 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/12/2022 10:32:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3390' AND id_document != '71477' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-09') 28/12/2022 10:32:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3390', document_date = '2022-11-09', 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 = '57.50', price_tax_excluded = '47.85', date_upd = NOW() WHERE id_document = '71477' 28/12/2022 10:32: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 = '71477' 28/12/2022 10:32:02 am >> DELETE FROM ps_document_detail WHERE id_document = '71477' 28/12/2022 10:32: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 ( '71477' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '26.00' ) 28/12/2022 10:32: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 ( '71477' , '4953' , 'IMMACOLATA CONCEZIONE - 151 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 28/12/2022 10:32: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 ( '71477' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 28/12/2022 10:32: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 ( '71477' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 28/12/2022 10:32: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 ( '71477' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 28/12/2022 10:32: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 ( '71477' , '19750' , 'INCENSO LUCAS' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 28/12/2022 10:32: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 ( '71477' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 28/12/2022 10:32:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3415' AND id_document != '71511' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 28/12/2022 10:32:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3415', document_date = '2022-11-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '8.00', date_upd = NOW() WHERE id_document = '71511' 28/12/2022 10:32: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 = '71511' 28/12/2022 10:32:21 am >> DELETE FROM ps_document_detail WHERE id_document = '71511' 28/12/2022 10:32: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 ( '71511' , '8439' , 'PRESEPE COMPONIBILE IN MDF CON 5 PZ - OGGETTI' , '1' , '-1' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '2.80' ) 28/12/2022 10:32: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 ( '71511' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 28/12/2022 10:32: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 ( '71511' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 28/12/2022 10:32:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3416' AND id_document != '71515' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-11') 28/12/2022 10:32:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3416', document_date = '2022-11-11', 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 = '2.75', price_tax_excluded = '2.67', date_upd = NOW() WHERE id_document = '71515' 28/12/2022 10:32:37 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 = '71515' 28/12/2022 10:32:37 am >> DELETE FROM ps_document_detail WHERE id_document = '71515' 28/12/2022 10:32:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71515' , '6019' , 'LUMINO ROSSO - 10B' , '1' , '-1' , '1' , '0.4500' , '0.36885245901639' , '22' , '0' , '0.45' ) 28/12/2022 10:32:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71515' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 28/12/2022 10:33:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3469' AND id_document != '73128' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 28/12/2022 10:33:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3469', document_date = '2022-11-15', 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 = '14.98', price_tax_excluded = '14.98', date_upd = NOW() WHERE id_document = '73128' 28/12/2022 10:33:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73128' 28/12/2022 10:33:05 am >> DELETE FROM ps_document_detail WHERE id_document = '73128' 28/12/2022 10:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73128' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.07' , '3.07' , '0' , '0' , '6.14' ) 28/12/2022 10:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73128' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' , '9.3000' , '9.3' , '0' , '5' , '8.84' ) 28/12/2022 10:33:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3475' AND id_document != '73138' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-16') 28/12/2022 10:33:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3475', document_date = '2022-11-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 = '11.78', price_tax_excluded = '11.78', date_upd = NOW() WHERE id_document = '73138' 28/12/2022 10:33:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73138' 28/12/2022 10:33:20 am >> DELETE FROM ps_document_detail WHERE id_document = '73138' 28/12/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73138' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 28/12/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73138' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/12/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73138' , '19542' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/12/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73138' , '19693' , 'CALENDARIO LITURGICO 2023' , '10' , '-10' , '4' , '0.5000' , '0.5' , '0' , '0' , '5.00' ) 28/12/2022 10:33:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3479' AND id_document != '73145' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-16') 28/12/2022 10:33:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3479', document_date = '2022-11-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 = '19.60', price_tax_excluded = '19.60', date_upd = NOW() WHERE id_document = '73145' 28/12/2022 10:33:38 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 = '73145' 28/12/2022 10:33:38 am >> DELETE FROM ps_document_detail WHERE id_document = '73145' 28/12/2022 10:33:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73145' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.0300' , '0.03' , '0' , '0' , '16.80' ) 28/12/2022 10:33:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73145' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 28/12/2022 10:33:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3666' AND id_document != '75458' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 28/12/2022 10:33:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3666', document_date = '2022-11-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 = '12.50', price_tax_excluded = '12.50', date_upd = NOW() WHERE id_document = '75458' 28/12/2022 10:33:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75458' 28/12/2022 10:33:56 am >> DELETE FROM ps_document_detail WHERE id_document = '75458' 28/12/2022 10:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75458' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/12/2022 10:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75458' , '16254' , 'STORIE DI NATALE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 28/12/2022 10:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75458' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 28/12/2022 10:34:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3495' AND id_document != '73176' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 28/12/2022 10:34:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3495', document_date = '2022-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2.80', price_tax_excluded = '2.80', date_upd = NOW() WHERE id_document = '73176' 28/12/2022 10:34:19 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 = '73176' 28/12/2022 10:34:19 am >> DELETE FROM ps_document_detail WHERE id_document = '73176' 28/12/2022 10:34:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73176' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 28/12/2022 10:34:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3704' AND id_document != '75509' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 28/12/2022 10:34:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3704', document_date = '2022-12-01', 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 = '29.10', price_tax_excluded = '26.30', date_upd = NOW() WHERE id_document = '75509' 28/12/2022 10:34: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 = '75509' 28/12/2022 10:34:35 am >> DELETE FROM ps_document_detail WHERE id_document = '75509' 28/12/2022 10:34: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 ( '75509' , '20243' , 'VIVA LA PARROCCHIA! ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 28/12/2022 10:34: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 ( '75509' , '16314' , 'BAMBINO CM 6' , '5' , '-5' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '8.50' ) 28/12/2022 10:34: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 ( '75509' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 28/12/2022 10:34: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 ( '75509' , '4373' , 'GESÙ BAMBINO - 266' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 28/12/2022 10:35:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3782' AND id_document != '76139' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 28/12/2022 10:35:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3782', document_date = '2022-12-07', 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 = '25.90', price_tax_excluded = '25.90', date_upd = NOW() WHERE id_document = '76139' 28/12/2022 10:35:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76139' 28/12/2022 10:35:04 am >> DELETE FROM ps_document_detail WHERE id_document = '76139' 28/12/2022 10:35:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76139' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '3' , '-3' , '4' , '2.3' , '2.3' , '0' , '0' , '6.90' ) 28/12/2022 10:35:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76139' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '5' , '19.00' ) 28/12/2022 10:35:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3785' AND id_document != '76143' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 28/12/2022 10:35:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3785', document_date = '2022-12-07', 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.01', price_tax_excluded = '37.01', date_upd = NOW() WHERE id_document = '76143' 28/12/2022 10:35:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76143' 28/12/2022 10:35:51 am >> DELETE FROM ps_document_detail WHERE id_document = '76143' 28/12/2022 10:35: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 ( '76143' , '20496' , 'KYRIE BAMBINO' , '1' , '-1' , '4' , '2.7000' , '2.7' , '0' , '5' , '2.57' ) 28/12/2022 10:35: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 ( '76143' , '16206' , 'INCONTRARE DIO NEL SILENZIO DEL CUORE - A. CANOPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/12/2022 10:35: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 ( '76143' , '17487' , 'TU SCENDI DALLE STELLE ...- A. COMASTRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 28/12/2022 10:35: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 ( '76143' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '-3' , '4' , '3' , '3' , '0' , '0' , '9.00' ) 28/12/2022 10:35: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 ( '76143' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '3' , '-3' , '4' , '2.78' , '2.78' , '0' , '0' , '8.34' ) 28/12/2022 10:36:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3791' AND id_document != '76153' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 28/12/2022 10:36:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3791', document_date = '2022-12-07', 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 = '5.50', price_tax_excluded = '5.05', date_upd = NOW() WHERE id_document = '76153' 28/12/2022 10:36:14 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 = '76153' 28/12/2022 10:36:14 am >> DELETE FROM ps_document_detail WHERE id_document = '76153' 28/12/2022 10:36:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76153' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 28/12/2022 10:36:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76153' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 28/12/2022 10:36:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3830' AND id_document != '77221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 28/12/2022 10:36:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3830', document_date = '2022-12-12', 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 = '171.20', price_tax_excluded = '152.86', date_upd = NOW() WHERE id_document = '77221' 28/12/2022 10:36:33 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 = '77221' 28/12/2022 10:36:33 am >> DELETE FROM ps_document_detail WHERE id_document = '77221' 28/12/2022 10:36: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 ( '77221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 28/12/2022 10:36: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 ( '77221' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 28/12/2022 10:36: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 ( '77221' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 28/12/2022 10:36: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 ( '77221' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/12/2022 10:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 28/12/2022 10:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 28/12/2022 10:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '16' , '-16' , '4' , '4.0000' , '4' , '0' , '0' , '64.00' ) 28/12/2022 10:36:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3859' AND id_document != '77261' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 28/12/2022 10:36:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3859', document_date = '2022-12-14', 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 = '72.00', price_tax_excluded = '63.52', date_upd = NOW() WHERE id_document = '77261' 28/12/2022 10:36: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 = '77261' 28/12/2022 10:36:48 am >> DELETE FROM ps_document_detail WHERE id_document = '77261' 28/12/2022 10:36: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 ( '77261' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 28/12/2022 10:36: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 ( '77261' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 28/12/2022 10:36: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 ( '77261' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 28/12/2022 10:36: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 ( '77261' , '20320' , 'MESSA MEDITAZIONE - GEN/FEB 2022' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '5' , '15.20' ) 28/12/2022 10:37:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3858' AND id_document != '77260' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 28/12/2022 10:37:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3858', document_date = '2022-12-14', 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 = '43.50', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '77260' 28/12/2022 10:37: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 = '77260' 28/12/2022 10:37:32 am >> DELETE FROM ps_document_detail WHERE id_document = '77260' 28/12/2022 10:37:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77260' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '16.50' ) 28/12/2022 10:37:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77260' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 28/12/2022 10:37:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77260' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '2.8' , '2.8' , '0' , '0' , '5.60' ) 28/12/2022 10:37:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77260' , '20201' , 'MIO PRIMO NATALE' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '0' , '11.90' ) 28/12/2022 10:37:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3901' AND id_document != '77320' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 28/12/2022 10:37:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3901', document_date = '2022-12-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 = '27.50', price_tax_excluded = '26.98', date_upd = NOW() WHERE id_document = '77320' 28/12/2022 10:37: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 = '77320' 28/12/2022 10:37:53 am >> DELETE FROM ps_document_detail WHERE id_document = '77320' 28/12/2022 10:37: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 ( '77320' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 28/12/2022 10:37: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 ( '77320' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 28/12/2022 10:37: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 ( '77320' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 28/12/2022 10:37: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 ( '77320' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '3' , '-3' , '4' , '4.5000' , '4.5' , '0' , '' , '13.50' ) 28/12/2022 10:38:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3936' AND id_document != '77358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-19') 28/12/2022 10:38:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3936', document_date = '2022-12-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.60', price_tax_excluded = '28.31', date_upd = NOW() WHERE id_document = '77358' 28/12/2022 10:38:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77358' 28/12/2022 10:38:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77358' 28/12/2022 10:38:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77358' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/12/2022 10:38:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77358' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 28/12/2022 10:38:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77358' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '5' , '19.00' ) 28/12/2022 10:38:31 am >> SELECT document_num FROM ps_document WHERE document_num = '4020' AND id_document != '77457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-21') 28/12/2022 10:38:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4020', document_date = '2022-12-21', 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 = '39.00', price_tax_excluded = '34.67', date_upd = NOW() WHERE id_document = '77457' 28/12/2022 10:38:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77457' 28/12/2022 10:38:31 am >> DELETE FROM ps_document_detail WHERE id_document = '77457' 28/12/2022 10:38:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77457' , '17568' , 'BAMBINO IN RESINA FASCIA ORO - PB13629' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 28/12/2022 10:38:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77457' , '14621' , 'SANTA RITA BABY - 023 SR/9 BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 28/12/2022 10:38:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77457' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3' , '3' , '0' , '0' , '15.00' ) 28/12/2022 10:38:50 am >> SELECT document_num FROM ps_document WHERE document_num = '4023' AND id_document != '77462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-21') 28/12/2022 10:38:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4023', document_date = '2022-12-21', 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 = '225.60', price_tax_excluded = '186.72', date_upd = NOW() WHERE id_document = '77462' 28/12/2022 10:38:50 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 = '77462' 28/12/2022 10:38:50 am >> DELETE FROM ps_document_detail WHERE id_document = '77462' 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '570' , 'ANELLO FASCIA AVE BRUNITO ROSE' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '13275' , 'NATIVITA CON LED CM 12' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '16289' , 'ANELLO IN ARG. ' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '14835' , 'STELLA COMETA - P581' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 28/12/2022 10:38:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77462' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '4' , '-4' , '4' , '2.5' , '2.5' , '0' , '0' , '10.00' ) 28/12/2022 10:39:19 am >> SELECT document_num FROM ps_document WHERE document_num = '4092' AND id_document != '77542' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 28/12/2022 10:39:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4092', document_date = '2022-12-27', 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 = '29.00', price_tax_excluded = '24.49', date_upd = NOW() WHERE id_document = '77542' 28/12/2022 10:39:19 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 = '77542' 28/12/2022 10:39:19 am >> DELETE FROM ps_document_detail WHERE id_document = '77542' 28/12/2022 10:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '2' , '-2' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '19.00' ) 28/12/2022 10:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 28/12/2022 10:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 28/12/2022 10:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2' , '2' , '0' , '0' , '4.00' ) 28/12/2022 10:39:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4093' AND id_document != '77543' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 28/12/2022 10:39:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4093', document_date = '2022-12-27', 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 = '18.50', price_tax_excluded = '15.34', date_upd = NOW() WHERE id_document = '77543' 28/12/2022 10:39: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 = '77543' 28/12/2022 10:39:35 am >> DELETE FROM ps_document_detail WHERE id_document = '77543' 28/12/2022 10:39: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 ( '77543' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/12/2022 10:39: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 ( '77543' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/12/2022 10:39: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 ( '77543' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 28/12/2022 10:39: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 ( '77543' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 28/12/2022 10:39: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 ( '77543' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 28/12/2022 10:39:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '77546' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 28/12/2022 10:39:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4096', document_date = '2022-12-27', 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.80', price_tax_excluded = '7.57', date_upd = NOW() WHERE id_document = '77546' 28/12/2022 10:39:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77546' 28/12/2022 10:39:59 am >> DELETE FROM ps_document_detail WHERE id_document = '77546' 28/12/2022 10:39:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77546' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.8000' , '5.5737704918033' , '22' , '0' , '6.80' ) 28/12/2022 10:39:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77546' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/12/2022 10:40:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4042' AND id_document != '77483' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-22') 28/12/2022 10:40:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4042', document_date = '2022-12-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.00', price_tax_excluded = '11.91', date_upd = NOW() WHERE id_document = '77483' 28/12/2022 10:40:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77483' 28/12/2022 10:40:30 am >> DELETE FROM ps_document_detail WHERE id_document = '77483' 28/12/2022 10:40:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77483' , '14624' , 'SANTA TERESA BABY - 023 STH/9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 28/12/2022 10:40:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77483' , '20003' , 'GESU BAMBINO CM 4 - BJ140-4E' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 28/12/2022 10:40:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77483' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '3' , '-3' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.60' ) 28/12/2022 10:40:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77483' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO- P762' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 28/12/2022 10:40:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77483' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 28/12/2022 11:36:16 am >> SELECT document_num FROM ps_document WHERE document_num = '4110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 11:36:16 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' , '4110' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/12/2022 11:36:16 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 = '77565' 28/12/2022 11:36:16 am >> DELETE FROM ps_document_detail WHERE id_document = '77565' 28/12/2022 11:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77565' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 11:53:54 am >> SELECT document_num FROM ps_document WHERE document_num = '4111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 11:53:54 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' , '4111' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.11' , '22.62' , NOW() , NOW() ) 28/12/2022 11:53:54 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 = '77566' 28/12/2022 11:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '77566' 28/12/2022 11:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77566' , '20320' , 'MESSA MEDITAZIONE - GEN/FEB 2022' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/12/2022 11:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77566' , '20478' , 'PANE QUOTIDIANO - GEN FEB 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/12/2022 11:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77566' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 28/12/2022 11:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77566' , '14876' , 'ANGELO IN RESINA PREGHIERA CM 9 - KS124-P' , '1' , '-1' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '7.80' ) 28/12/2022 11:56:08 am >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 11:56:08 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' , '4112' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 28/12/2022 11:56:08 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 = '77567' 28/12/2022 11:56:08 am >> DELETE FROM ps_document_detail WHERE id_document = '77567' 28/12/2022 11:56:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77567' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 28/12/2022 11:56:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77567' , '4840' , 'HOLY CARD - MISERICORDIOSO - M0100/G001' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 28/12/2022 11:56:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77567' , '6154' , 'MAGNETI IMBUSTATI CM 4X6 - OGGETTI' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/12/2022 11:57:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 11:57:13 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' , '4113' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 28/12/2022 11:57:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77568' 28/12/2022 11:57:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77568' 28/12/2022 11:57:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77568' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 11:57:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77568' , '20592' , 'SULLA TUA PAROLA MAR/APR 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 12:03:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 12:03:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4114' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '18.93' , NOW() , NOW() ) 28/12/2022 12:03: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 = '77569' 28/12/2022 12:03:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '77569' 28/12/2022 12:03: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 ( '77569' , '20592' , 'SULLA TUA PAROLA MAR/APR 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 12:03: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 ( '77569' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 12:03: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 ( '77569' , '19723' , 'ROSARIO COPPIGLIATO MM8 - RE1715-SM' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '11.50' ) 28/12/2022 12:10:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 12:10:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4115' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '187.85' , '159.63' , NOW() , NOW() ) 28/12/2022 12:10:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77570' 28/12/2022 12:10:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '77570' 28/12/2022 12:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77570' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/12/2022 12:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77570' , '19805' , 'DESIDERIO DESIDERAVI' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 28/12/2022 12:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77570' , '14103' , 'PROFUMO DELLO SPOSO - G. PICCOLO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 28/12/2022 12:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77570' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 28/12/2022 12:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77570' , '16834' , 'LITURGICO CARTA 8GG' , '48' , '-48' , '1' , '3' , '2.4590163934426' , '22' , '0' , '144.00' ) 28/12/2022 12:11:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '4116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 12:11: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' , '4116' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '5.90' , NOW() , NOW() ) 28/12/2022 12:11: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 = '77571' 28/12/2022 12:11:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '77571' 28/12/2022 12:11: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 ( '77571' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 28/12/2022 12:11: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 ( '77571' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/12/2022 12:11: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 ( '77571' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 28/12/2022 12:23:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '77567' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 12:23:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4112', document_date = '2022-12-28', 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 = '15.50', price_tax_excluded = '12.70', date_upd = NOW() WHERE id_document = '77567' 28/12/2022 12:23:41 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 = '77567' 28/12/2022 12:23:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '77567' 28/12/2022 12:23: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 ( '77567' , '4840' , 'HOLY CARD - MISERICORDIOSO - M0100/G001' , '3' , '-3' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.50' ) 28/12/2022 12:23: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 ( '77567' , '6154' , 'MAGNETI IMBUSTATI CM 4X6 - OGGETTI' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/12/2022 12:23: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 ( '77567' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 28/12/2022 12:26:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 12:26:49 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' , '4117' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 28/12/2022 12:26: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 = '77572' 28/12/2022 12:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '77572' 28/12/2022 12:26: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 ( '77572' , '20441' , 'AMEN - GEN. 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 28/12/2022 12:26: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 ( '77572' , '20440' , 'AMEN - FEB. 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 28/12/2022 12:40:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002108' AND id_product != '20607' AND ean13 != '' 28/12/2022 12:40:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002108', date_upd = NOW() WHERE id_product = '20607' 28/12/2022 12:40:50 pm >> UPDATE ps_product_lang SET name = 'CASULA LINO - CS10001', description = '' WHERE id_product = '20607' 28/12/2022 12:40:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0' WHERE id_product = '20607' 28/12/2022 12:40:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0', id_tax_rules_group = '1', id_category_default = '414', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20607' 28/12/2022 12:40:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20607' 28/12/2022 12:41:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'E/137' , '2022-12-28' , '137' , '0' , '101' , '4663858' , 'VIA NUOVA PONENTE, 11 41012 CARPI' , '' , '' , '5' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '335.09' , '274.66' , NOW() , NOW() ) 28/12/2022 12:41:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77573' 28/12/2022 12:41:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '77573' 28/12/2022 12:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77573' , '20607' , 'CASULA LINO - CS10001' , '4' , '4' , '1' , '69.5' , '56.967213114754' , '22' , '3' , '328.9852' ) 28/12/2022 12:41:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20607' AND id_supplier = '101' 28/12/2022 12:41:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20607' , '101' , '1' ) 28/12/2022 12:43:08 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 ( '34' , 'E152' , '2022-10-11' , '' , '0' , '101' , '4663858' , 'VIA NUOVA PONENTE, 11 41012 CARPI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 28/12/2022 12:43:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77574' 28/12/2022 12:43:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '77574' 28/12/2022 12:43:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77574' , '20607' , 'CASULA LINO - CS10001' , '4' , '0' , '1' , '0.00' , '0' , '22' , '0' , '0.0000' ) 28/12/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20607' AND id_supplier = '101' 28/12/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20607' , '101' , '1' ) 28/12/2022 12:43:26 pm >> UPDATE ps_document SET id_document_type = '31', document_num = 'E/137', document_date = '2022-09-23', document_letter = '137', id_customer = '0', id_supplier = '', id_address = '4663858', address1 = 'VIA NUOVA PONENTE, 11 41012 CARPI', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '335.09', price_tax_excluded = '274.66', date_upd = NOW() WHERE id_document = '77573' 28/12/2022 12:43:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77573' 28/12/2022 12:43:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '77573' 28/12/2022 12:43:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77573' , '20607' , 'CASULA LINO - CS10001' , '4' , '4' , '1' , '69.5000' , '56.967213114754' , '22' , '3' , '328.99' ) 28/12/2022 12:43:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '37' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 12:43: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 ( '24' , '37' , '2022-12-28' , '' , '0' , '101' , '4663858' , 'VIA NUOVA PONENTE, 11 41012 CARPI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 28/12/2022 12:43: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 = '77575' 28/12/2022 12:43:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '77575' 28/12/2022 12:43: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 ( '77575' , '20607' , 'CASULA LINO - CS10001' , '4' , '-4' , '1' , '0.00' , '0' , '22' , '0' , '0.00' ) 28/12/2022 12:43:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20607' AND id_supplier = '101' 28/12/2022 12:43:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20607' , '101' , '1' ) 28/12/2022 03:02:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 03:02:13 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' , '4118' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 28/12/2022 03:02:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77576' 28/12/2022 03:02:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '77576' 28/12/2022 03:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77576' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 28/12/2022 03:36: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 ( '32' , '3145' , '2022-12-28' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.38' , '4' , '-2' , '0' , '0' , '' , '0' , '0' , '80.95' , '80.95' , NOW() , NOW() ) 28/12/2022 03:36: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 = '77577' 28/12/2022 03:36:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '77577' 28/12/2022 03:36: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 ( '77577' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '47' , '1' ) 28/12/2022 03:36: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 ( '77577' , '20579' , 'TU SEI UNICO E SPECIALE - G. CELLI' , '1' , '0' , '4' , '14.5000' , '14.5' , '0' , '30' , '10.15' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20579' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20579' , '47' , '1' ) 28/12/2022 03:36: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 ( '77577' , '20426' , 'PERCHE CREDERE? - F. SHEEN' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20426' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20426' , '47' , '1' ) 28/12/2022 03:36: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 ( '77577' , '20580' , 'PREGHIERE DI GUARIGIONE NELLA MALATTIA' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20580' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20580' , '47' , '1' ) 28/12/2022 03:36: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 ( '77577' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '47' , '1' ) 28/12/2022 03:36: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 ( '77577' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '27' , '9.42' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '47' , '1' ) 28/12/2022 03:36: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 ( '77577' , '20581' , 'GRANDE TEMPESTA - B. VESPA' , '1' , '0' , '4' , '21.0000' , '21' , '0' , '30' , '14.70' ) 28/12/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20581' AND id_supplier = '47' 28/12/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20581' , '47' , '1' ) 28/12/2022 04:15:58 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16951' 28/12/2022 04:15:58 pm >> UPDATE ps_stock_available SET quantity = quantity + '-110' WHERE id_product = '16951' 28/12/2022 04:52:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 04:52: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' , '4119' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 28/12/2022 04:52: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 = '77578' 28/12/2022 04:52:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77578' 28/12/2022 04:52: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 ( '77578' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/12/2022 04:57:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2022010002404' , '2022-12-28' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '3.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '161.99' , '161.99' , NOW() , NOW() ) 28/12/2022 04:57:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77579' 28/12/2022 04:57:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '77579' 28/12/2022 04:57:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77579' , '20415' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 9' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 28/12/2022 04:57:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20415' AND id_supplier = '107' 28/12/2022 04:57:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20415' , '107' , '1' ) 28/12/2022 04:57:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77579' , '20498' , 'RIFORMA DELLA LITURGIA E RIFORMA DELLA CHIESA - P. SORCI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 28/12/2022 04:57:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20498' AND id_supplier = '107' 28/12/2022 04:57:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20498' , '107' , '1' ) 28/12/2022 04:57:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77579' , '20499' , 'SEGRETO SOTTILE - SUSSIDIO 2023' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '5.85' ) 28/12/2022 04:57:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20499' AND id_supplier = '107' 28/12/2022 04:57:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20499' , '107' , '1' ) 28/12/2022 04:57: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 ( '77579' , '20414' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 28/12/2022 04:57:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20414' AND id_supplier = '107' 28/12/2022 04:57:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20414' , '107' , '1' ) 28/12/2022 05:16:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 05:16:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4120' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 28/12/2022 05:16: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 = '77580' 28/12/2022 05:16:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '77580' 28/12/2022 05:16: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 ( '77580' , '1312' , 'BRACCIALE DECINA' , '2' , '-2' , '1' , '1.25' , '1.0245901639344' , '22' , '0' , '2.50' ) 28/12/2022 05:18:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2757' AND id_document != '61829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 28/12/2022 05:18:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2757', 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 = '27.50', price_tax_excluded = '22.54', date_upd = NOW() WHERE id_document = '61829' 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61829' 28/12/2022 05:18:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '61829' 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '17998' , 'MIRACOLOSA CM 13 - 023 MIR/13E' , '1' , '-1' , '1' , '10.5000' , '8.6065573770492' , '22' , '0' , '10.50' ) 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 28/12/2022 05:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '6354' , 'MEDAGLIA S. MICHELE - 1796' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 28/12/2022 05:18:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2715' AND id_document != '61774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 28/12/2022 05:18:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2715', document_date = '2022-09-13', 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 = '19.80', price_tax_excluded = '16.23', date_upd = NOW() WHERE id_document = '61774' 28/12/2022 05:18: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 = '61774' 28/12/2022 05:18:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '61774' 28/12/2022 05:18: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 ( '61774' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 28/12/2022 05:18: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 ( '61774' , '1312' , 'BRACCIALE DECINA' , '4' , '-4' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '4.80' ) 28/12/2022 05:19:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3283' AND id_document != '70287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 28/12/2022 05:19:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3283', document_date = '2022-10-31', 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 = '2.40', price_tax_excluded = '1.97', date_upd = NOW() WHERE id_document = '70287' 28/12/2022 05:19:09 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 = '70287' 28/12/2022 05:19:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '70287' 28/12/2022 05:19:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70287' , '1312' , 'BRACCIALE DECINA' , '2' , '-2' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '2.40' ) 28/12/2022 05:19:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3371' AND id_document != '70927' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-07') 28/12/2022 05:19:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3371', document_date = '2022-11-07', 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 = '9.00', price_tax_excluded = '8.64', date_upd = NOW() WHERE id_document = '70927' 28/12/2022 05:19:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70927' 28/12/2022 05:19:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '70927' 28/12/2022 05:19:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70927' , '16253' , 'ASPETTANDO NATALE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 28/12/2022 05:19:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70927' , '1312' , 'BRACCIALE DECINA' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 28/12/2022 06:14:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2911' AND id_document != '63592' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 28/12/2022 06:14:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2911', 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 = '145.00', price_tax_excluded = '127.28', date_upd = NOW() WHERE id_document = '63592' 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63592' 28/12/2022 06:14:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '63592' 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.09' , '9.09' , '0' , '0' , '9.09' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '19.00' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '1' , '1.0000' , '0.81967213114754' , '22' , '5' , '3.80' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.9000' , '1.9' , '0' , '0' , '3.80' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '45.2000' , '37.049180327869' , '22' , '0' , '45.20' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 28/12/2022 06:14:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63592' , '16970' , 'PELLEGRINI DI MARIA - GIOCO' , '1' , '-1' , '4' , '19.90' , '19.9' , '0' , '5' , '18.91' ) 28/12/2022 06:29:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '4121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 06:29:42 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' , '4121' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 28/12/2022 06:29:42 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 = '77581' 28/12/2022 06:29:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '77581' 28/12/2022 06:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77581' , '20592' , 'SULLA TUA PAROLA MAR/APR 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 06:29:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77581' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/12/2022 06:32:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '4122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 06:32:40 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' , '4122' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 28/12/2022 06:32: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 = '77582' 28/12/2022 06:32:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '77582' 28/12/2022 06:32: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 ( '77582' , '15871' , 'FINTA CANDELA 4X100 - 143' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 28/12/2022 07:11:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '4123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-28') 28/12/2022 07:11:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4123' , '2022-12-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 28/12/2022 07:11:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77583' 28/12/2022 07:11:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '77583' 28/12/2022 07:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77583' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' )