11/04/2024 08:33:19 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/04/2024 08:33:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22388' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:33:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22388' , '1' , '1' , '2' , NOW() , NOW() ) 11/04/2024 08:33:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22388' , '0' , '1' , '0' , '0' ) 11/04/2024 08:34:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253438' AND id_product != '22388' AND ean13 != '' 11/04/2024 08:34:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281253438', date_upd = NOW() WHERE id_product = '22388' 11/04/2024 08:34:08 am >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - AGO SET OTT', description = '' WHERE id_product = '22388' 11/04/2024 08:34:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '22388' 11/04/2024 08:34:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22388' 11/04/2024 08:34:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22388' 11/04/2024 08:34:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22388' 11/04/2024 08:34:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22389' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:34: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 '22389' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22388' 11/04/2024 08:34:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22389' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22388' 11/04/2024 08:35:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243637' AND id_product != '22389' AND ean13 != '' 11/04/2024 08:35:20 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892243637', date_upd = NOW() WHERE id_product = '22389' 11/04/2024 08:35:20 am >> UPDATE ps_product_lang SET name = 'PREGHIERA NELL\'ANTICO TESTAMENTO - E. BUCCIONI', description = '' WHERE id_product = '22389' 11/04/2024 08:35:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '22389' 11/04/2024 08:35:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22389' 11/04/2024 08:35:20 am >> DELETE FROM ps_specific_price WHERE id_product = '22389' 11/04/2024 08:35:21 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 = '22389' 11/04/2024 08:35:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22390' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:35:21 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 '22390' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22389' 11/04/2024 08:35:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22390' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22389' 11/04/2024 08:35:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825058642' AND id_product != '22390' AND ean13 != '' 11/04/2024 08:35:55 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788825058642', date_upd = NOW() WHERE id_product = '22390' 11/04/2024 08:35:55 am >> UPDATE ps_product_lang SET name = 'ROSARIO DELLA GUARIGIONE', description = '' WHERE id_product = '22390' 11/04/2024 08:35:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22390' 11/04/2024 08:35:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22390' 11/04/2024 08:35:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22390' 11/04/2024 08:35: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 = '22390' 11/04/2024 08:35:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22391' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:35:56 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 '22391' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22390' 11/04/2024 08:35:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22391' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22390' 11/04/2024 08:36:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253704' AND id_product != '22391' AND ean13 != '' 11/04/2024 08:36:55 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9791281253704', date_upd = NOW() WHERE id_product = '22391' 11/04/2024 08:36:55 am >> UPDATE ps_product_lang SET name = 'UN ANNO CON MARIA - BENEDETTO XVI', description = '' WHERE id_product = '22391' 11/04/2024 08:36:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22391' 11/04/2024 08:36:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22391' 11/04/2024 08:36:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22391' 11/04/2024 08:36: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 = '22391' 11/04/2024 08:36:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22392' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:36:56 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 '22392' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22391' 11/04/2024 08:36:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22392' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22391' 11/04/2024 08:37:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9787706240503' AND id_product != '22392' AND ean13 != '' 11/04/2024 08:37:42 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9787706240503', date_upd = NOW() WHERE id_product = '22392' 11/04/2024 08:37:42 am >> UPDATE ps_product_lang SET name = 'DALL\'ALBA AL TRAMONTO - MAG 2024', description = '' WHERE id_product = '22392' 11/04/2024 08:37:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.2' WHERE id_product = '22392' 11/04/2024 08:37:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.2', id_tax_rules_group = '4', id_category_default = '280', 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 = '22392' 11/04/2024 08:37:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22392' 11/04/2024 08:37:43 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 = '22392' 11/04/2024 08:37:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22393' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:37:43 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 '22393' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22392' 11/04/2024 08:37:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22393' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22392' 11/04/2024 08:38:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618084' AND id_product != '22393' AND ean13 != '' 11/04/2024 08:38:27 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281618084', date_upd = NOW() WHERE id_product = '22393' 11/04/2024 08:38:27 am >> UPDATE ps_product_lang SET name = 'BATTESIMO NELLO SPIRITO - R. CANTALAMESSA', description = '' WHERE id_product = '22393' 11/04/2024 08:38:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22393' 11/04/2024 08:38:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '145', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22393' 11/04/2024 08:38:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22393' 11/04/2024 08:38:28 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 = '22393' 11/04/2024 08:38:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22394' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:38:28 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 '22394' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22393' 11/04/2024 08:38:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22394' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22393' 11/04/2024 08:39:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618008' AND id_product != '22394' AND ean13 != '' 11/04/2024 08:39:17 am >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9791281618008', date_upd = NOW() WHERE id_product = '22394' 11/04/2024 08:39:17 am >> UPDATE ps_product_lang SET name = 'NOVISSIMI ... O VECCHISSIMI? - L. ALESSANDRINI', description = '' WHERE id_product = '22394' 11/04/2024 08:39:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22394' 11/04/2024 08:39:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22394' 11/04/2024 08:39:18 am >> DELETE FROM ps_specific_price WHERE id_product = '22394' 11/04/2024 08:39:18 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 = '22394' 11/04/2024 08:39:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22395' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:39:18 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 '22395' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22394' 11/04/2024 08:39:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22395' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22394' 11/04/2024 08:40:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244191' AND id_product != '22395' AND ean13 != '' 11/04/2024 08:40:06 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788892244191', date_upd = NOW() WHERE id_product = '22395' 11/04/2024 08:40:06 am >> UPDATE ps_product_lang SET name = 'DA GERUSALEMME A ROMA - M. SODI', description = '' WHERE id_product = '22395' 11/04/2024 08:40:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22395' 11/04/2024 08:40:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22395' 11/04/2024 08:40:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22395' 11/04/2024 08:40: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 = '22395' 11/04/2024 08:40:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22396' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:40:07 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 '22396' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22395' 11/04/2024 08:40:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22396' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22395' 11/04/2024 08:40:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244412' AND id_product != '22396' AND ean13 != '' 11/04/2024 08:40:56 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892244412', date_upd = NOW() WHERE id_product = '22396' 11/04/2024 08:40:56 am >> UPDATE ps_product_lang SET name = 'PREGARE E VIVERE - L. PACOMIO', description = '' WHERE id_product = '22396' 11/04/2024 08:40:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22396' 11/04/2024 08:40:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22396' 11/04/2024 08:40:56 am >> DELETE FROM ps_specific_price WHERE id_product = '22396' 11/04/2024 08:40:57 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 = '22396' 11/04/2024 08:40:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22397' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:40: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 '22397' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22396' 11/04/2024 08:40:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22397' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22396' 11/04/2024 08:41:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556668' AND id_product != '22397' AND ean13 != '' 11/04/2024 08:41:35 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788831556668', date_upd = NOW() WHERE id_product = '22397' 11/04/2024 08:41:35 am >> UPDATE ps_product_lang SET name = 'AFFERRATI DALL\'AMORE', description = '' WHERE id_product = '22397' 11/04/2024 08:41:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '22397' 11/04/2024 08:41:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22397' 11/04/2024 08:41:35 am >> DELETE FROM ps_specific_price WHERE id_product = '22397' 11/04/2024 08:41:36 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 = '22397' 11/04/2024 08:41:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22398' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:41:36 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 '22398' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22397' 11/04/2024 08:41:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22398' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22397' 11/04/2024 08:42:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9728831222446' AND id_product != '22398' AND ean13 != '' 11/04/2024 08:42:27 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9728831222446', date_upd = NOW() WHERE id_product = '22398' 11/04/2024 08:42:27 am >> UPDATE ps_product_lang SET name = 'CREDERE - R. MAGGI', description = '' WHERE id_product = '22398' 11/04/2024 08:42:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22398' 11/04/2024 08:42:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '302', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22398' 11/04/2024 08:42:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22398' 11/04/2024 08:42:28 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 = '22398' 11/04/2024 08:42:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22399' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:42:28 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 '22399' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22398' 11/04/2024 08:42:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22399' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22398' 11/04/2024 08:43:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465046' AND id_product != '22399' AND ean13 != '' 11/04/2024 08:43:12 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791281465046', date_upd = NOW() WHERE id_product = '22399' 11/04/2024 08:43:12 am >> UPDATE ps_product_lang SET name = 'TUTTO IN UN FRAMMENTO - E. BOLIS', description = '' WHERE id_product = '22399' 11/04/2024 08:43:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '22399' 11/04/2024 08:43:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '97', 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 = '22399' 11/04/2024 08:43:12 am >> DELETE FROM ps_specific_price WHERE id_product = '22399' 11/04/2024 08:43:13 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 = '22399' 11/04/2024 08:43:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22400' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:43:13 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 '22400' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22399' 11/04/2024 08:43:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22400' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22399' 11/04/2024 08:44:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928054' AND id_product != '22400' AND ean13 != '' 11/04/2024 08:44:02 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788839928054', date_upd = NOW() WHERE id_product = '22400' 11/04/2024 08:44:02 am >> UPDATE ps_product_lang SET name = 'ACCOMPAGNARE I CATECUMENI - R. LACROIX', description = '' WHERE id_product = '22400' 11/04/2024 08:44:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22400' 11/04/2024 08:44:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22400' 11/04/2024 08:44:02 am >> DELETE FROM ps_specific_price WHERE id_product = '22400' 11/04/2024 08:44:03 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 = '22400' 11/04/2024 08:44:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22401' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:44:03 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 '22401' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22400' 11/04/2024 08:44:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22401' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22400' 11/04/2024 08:44:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934604' AND id_product != '22401' AND ean13 != '' 11/04/2024 08:44:45 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934604', date_upd = NOW() WHERE id_product = '22401' 11/04/2024 08:44:45 am >> UPDATE ps_product_lang SET name = 'CHRISTIAN DE CHERGE - C. SALENSON', description = '' WHERE id_product = '22401' 11/04/2024 08:44:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32' WHERE id_product = '22401' 11/04/2024 08:44:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22401' 11/04/2024 08:44:45 am >> DELETE FROM ps_specific_price WHERE id_product = '22401' 11/04/2024 08:44:46 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 = '22401' 11/04/2024 08:44:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22402' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:44:46 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 '22402' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22401' 11/04/2024 08:44:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22402' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22401' 11/04/2024 08:45:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248114' AND id_product != '22402' AND ean13 != '' 11/04/2024 08:45:44 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788884248114', date_upd = NOW() WHERE id_product = '22402' 11/04/2024 08:45:45 am >> UPDATE ps_product_lang SET name = 'REGNO DI DIO E\' UNA SFIDA - F.J. SHEEN', description = '' WHERE id_product = '22402' 11/04/2024 08:45:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22402' 11/04/2024 08:45:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22402' 11/04/2024 08:45:45 am >> DELETE FROM ps_specific_price WHERE id_product = '22402' 11/04/2024 08:45: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 = '22402' 11/04/2024 08:45:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22403' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:45: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 '22403' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22402' 11/04/2024 08:45:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22403' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22402' 11/04/2024 08:46:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244375' AND id_product != '22403' AND ean13 != '' 11/04/2024 08:46:23 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788892244375', date_upd = NOW() WHERE id_product = '22403' 11/04/2024 08:46:23 am >> UPDATE ps_product_lang SET name = 'MIO LIBRO DI PREGHIERE - A. COMASTRI', description = '' WHERE id_product = '22403' 11/04/2024 08:46:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22403' 11/04/2024 08:46:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22403' 11/04/2024 08:46:23 am >> DELETE FROM ps_specific_price WHERE id_product = '22403' 11/04/2024 08:46:23 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 = '22403' 11/04/2024 08:46:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22404' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 08:46:23 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 '22404' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22403' 11/04/2024 08:46:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22404' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22403' 11/04/2024 08:47:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9728831222446' AND id_product != '22398' AND ean13 != '' 11/04/2024 08:47:58 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9728831222446', date_upd = NOW() WHERE id_product = '22398' 11/04/2024 08:47:58 am >> UPDATE ps_product_lang SET name = 'CREDERE - R. MAGGI', description = '' WHERE id_product = '22398' 11/04/2024 08:47:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.0000' WHERE id_product = '22398' 11/04/2024 08:47:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '302', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22398' 11/04/2024 08:47:58 am >> DELETE FROM ps_specific_price WHERE id_product = '22398' 11/04/2024 08:52:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '661179' , '2024-04-05' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.68' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '202.03' , '202.03' , NOW() , NOW() ) 11/04/2024 08:52: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 = '91205' 11/04/2024 08:52:32 am >> DELETE FROM ps_document_detail WHERE id_document = '91205' 11/04/2024 08:52: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 ( '91205' , '22398' , 'CREDERE - R. MAGGI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 11/04/2024 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22398' AND id_supplier = '7' 11/04/2024 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22398' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22395' , 'DA GERUSALEMME A ROMA - M. SODI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 11/04/2024 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22395' AND id_supplier = '7' 11/04/2024 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22395' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22397' , 'AFFERRATI DALLAMORE' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '33' , '6.5660' ) 11/04/2024 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22397' AND id_supplier = '7' 11/04/2024 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22397' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22390' , 'ROSARIO DELLA GUARIGIONE' , '2' , '2' , '4' , '3.00' , '3' , '0' , '30' , '4.2000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22390' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22390' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22399' , 'TUTTO IN UN FRAMMENTO - E. BOLIS' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22399' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22399' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22402' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22402' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22391' , 'UN ANNO CON MARIA - BENEDETTO XVI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22391' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22391' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22400' , 'ACCOMPAGNARE I CATECUMENI - R. LACROIX' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22400' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22400' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22401' , 'CHRISTIAN DE CHERGE - C. SALENSON' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22401' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22401' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22394' , 'NOVISSIMI ... O VECCHISSIMI? - L. ALESSANDRINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22394' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22394' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22393' , 'BATTESIMO NELLO SPIRITO - R. CANTALAMESSA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22393' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22393' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '2' , '2' , '4' , '12.00' , '12' , '0' , '33' , '16.0800' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22403' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22403' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22396' , 'PREGARE E VIVERE - L. PACOMIO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22396' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22396' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22389' , 'PREGHIERA NELLANTICO TESTAMENTO - E. BUCCIONI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22389' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22389' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '12' , '12' , '4' , '6.00' , '6' , '0' , '30' , '50.4000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22388' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22388' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '1' , '1' , '4' , '6.00' , '6' , '0' , '100' , '0.0000' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22388' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22388' , '7' , '1' ) 11/04/2024 08:52: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 ( '91205' , '22392' , 'DALLALBA AL TRAMONTO - MAG 2024' , '1' , '1' , '4' , '3.20' , '3.2' , '0' , '30' , '2.2400' ) 11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22392' AND id_supplier = '7' 11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22392' , '7' , '1' ) 11/04/2024 09:27:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 09:27:12 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' , '1100' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '154.80' , '129.63' , NOW() , NOW() ) 11/04/2024 09:27: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 = '91206' 11/04/2024 09:27:12 am >> DELETE FROM ps_document_detail WHERE id_document = '91206' 11/04/2024 09:27: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 ( '91206' , '22336' , 'CALAMITE ' , '14' , '-14' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '68.60' ) 11/04/2024 09:27: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 ( '91206' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' , '51.00' , '41.803278688525' , '22' , '0' , '51.00' ) 11/04/2024 09:27: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 ( '91206' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 11/04/2024 09:27: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 ( '91206' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/04/2024 09:30:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 09:30:19 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' , '1101' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 11/04/2024 09:30: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 = '91207' 11/04/2024 09:30:19 am >> DELETE FROM ps_document_detail WHERE id_document = '91207' 11/04/2024 09:30: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 ( '91207' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 11/04/2024 09:33:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 09:33:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1102' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.76' , '21.76' , NOW() , NOW() ) 11/04/2024 09:33:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91208' 11/04/2024 09:33:06 am >> DELETE FROM ps_document_detail WHERE id_document = '91208' 11/04/2024 09:33:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91208' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 11/04/2024 09:33:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91208' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 11/04/2024 09:49:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 09:49:43 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' , '1103' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 11/04/2024 09:49:43 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 = '91209' 11/04/2024 09:49:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91209' 11/04/2024 09:49:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91209' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 11/04/2024 10:48:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 10:48:39 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' , '1104' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 11/04/2024 10:48:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91210' 11/04/2024 10:48:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91210' 11/04/2024 10:48:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91210' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 11/04/2024 10:51:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 10:51:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1105' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 11/04/2024 10:51: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 = '91211' 11/04/2024 10:51:32 am >> DELETE FROM ps_document_detail WHERE id_document = '91211' 11/04/2024 10:51: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 ( '91211' , '22075' , 'CRISTO TOTALE - G. MUSICO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 11/04/2024 11:06:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 11:06: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' , '1106' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.35' , '135.89' , NOW() , NOW() ) 11/04/2024 11:06: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 = '91212' 11/04/2024 11:06:08 am >> DELETE FROM ps_document_detail WHERE id_document = '91212' 11/04/2024 11:06: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 ( '91212' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '10' , '10' , '0' , '0' , '60.00' ) 11/04/2024 11:06: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 ( '91212' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '10' , '-10' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '13.00' ) 11/04/2024 11:06: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 ( '91212' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 11/04/2024 11:06: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 ( '91212' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 11/04/2024 11:06: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 ( '91212' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 11/04/2024 11:06: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 ( '91212' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 11/04/2024 11:10:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 11:10: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' , '1107' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 11/04/2024 11:10: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 = '91213' 11/04/2024 11:10:16 am >> DELETE FROM ps_document_detail WHERE id_document = '91213' 11/04/2024 11:10: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 ( '91213' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 11/04/2024 11:39:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 11:39:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1108' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 11/04/2024 11: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 = '91214' 11/04/2024 11:39:35 am >> DELETE FROM ps_document_detail WHERE id_document = '91214' 11/04/2024 11: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 ( '91214' , '22199' , 'VINO LIQUOROSO ROSSO ' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 11/04/2024 11: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 ( '91214' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 11/04/2024 11:49:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1338654' , '2024-04-09' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.10' , '72.10' , NOW() , NOW() ) 11/04/2024 11:49:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91215' 11/04/2024 11:49:23 am >> DELETE FROM ps_document_detail WHERE id_document = '91215' 11/04/2024 11:49:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91215' , '21780' , 'FRATELLINO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '30' , '16.8000' ) 11/04/2024 11:49:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21780' AND id_supplier = '177' 11/04/2024 11:49:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21780' , '177' , '1' ) 11/04/2024 11:49:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91215' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '30' , '13.3000' ) 11/04/2024 11:49:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '177' 11/04/2024 11:49:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '177' , '1' ) 11/04/2024 11:49:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91215' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' , '5' , '4' , '12.00' , '12' , '0' , '30' , '42.0000' ) 11/04/2024 11:49:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 11/04/2024 11:49:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 11/04/2024 11:50:04 am >> UPDATE ps_document SET id_document_type = '33', document_num = '1338654', document_date = '2024-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679057', address1 = 'VIA G. VERDI 8 20057 ASSAGO', 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 = '103.00', price_tax_excluded = '103.00', date_upd = NOW() WHERE id_document = '91215' 11/04/2024 11:50: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 = '91215' 11/04/2024 11:50:04 am >> DELETE FROM ps_document_detail WHERE id_document = '91215' 11/04/2024 11:50: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 ( '91215' , '21780' , 'FRATELLINO' , '2' , '2' , '4' , '12.0000' , '12' , '0' , '' , '24.0000' ) 11/04/2024 11:50: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 ( '91215' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '1' , '4' , '19.0000' , '19' , '0' , '' , '19.0000' ) 11/04/2024 11:50: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 ( '91215' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' , '5' , '4' , '12.0000' , '12' , '0' , '' , '60.0000' ) 11/04/2024 12:02:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 11/04/2024 12:02:32 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.90', price_tax_excluded = '50.90', date_upd = NOW() WHERE id_document = '89846' 11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 11/04/2024 12:02:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '13499' , 'VITA CRISTIANA - SANTAGOSTINO - 8742' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22386' , 'CREDO SPIEGATO AI CRISTIANI UN PO SCETTICI ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 11/04/2024 12:04:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243064' AND id_product != '22404' AND ean13 != '' 11/04/2024 12:04:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788892243064', date_upd = NOW() WHERE id_product = '22404' 11/04/2024 12:04:50 pm >> UPDATE ps_product_lang SET name = 'CINQUE DOMANDE CHE AGITANO LA CHIESA - I. INGRAO', description = '' WHERE id_product = '22404' 11/04/2024 12:04:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22404' 11/04/2024 12:04:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22404' 11/04/2024 12:04:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '22404' 11/04/2024 12:04:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22404' 11/04/2024 12:04:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22405' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 12:04:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22405' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22404' 11/04/2024 12:04:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22405' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22404' 11/04/2024 12:05:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831505383' AND id_product != '22405' AND ean13 != '' 11/04/2024 12:05:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831505383', date_upd = NOW() WHERE id_product = '22405' 11/04/2024 12:05:56 pm >> UPDATE ps_product_lang SET name = 'REDEMPTORIS MATER', description = '' WHERE id_product = '22405' 11/04/2024 12:05:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '22405' 11/04/2024 12:05:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22405' 11/04/2024 12:05:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22405' 11/04/2024 12:05:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22405' 11/04/2024 12:05:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22406' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 12:05:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22406' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22405' 11/04/2024 12:05:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22406' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22405' 11/04/2024 12:06: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 ( '33' , '661579' , '2024-04-10' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.69' , '109.69' , NOW() , NOW() ) 11/04/2024 12:06: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 = '91216' 11/04/2024 12:06:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '91216' 11/04/2024 12:06: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 ( '91216' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '2' , '2' , '4' , '12.00' , '12' , '0' , '33' , '16.0800' ) 11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22403' AND id_supplier = '7' 11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22403' , '7' , '1' ) 11/04/2024 12:06: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 ( '91216' , '22404' , 'CINQUE DOMANDE CHE AGITANO LA CHIESA - I. INGRAO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22404' AND id_supplier = '7' 11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22404' , '7' , '1' ) 11/04/2024 12:06: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 ( '91216' , '17529' , 'NUOVO RITO DELLA MESSA' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '33' , '2.0100' ) 11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17529' AND id_supplier = '7' 11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17529' , '7' , '1' ) 11/04/2024 12:06: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 ( '91216' , '22405' , 'REDEMPTORIS MATER' , '10' , '10' , '4' , '3.50' , '3.5' , '0' , '33' , '23.4500' ) 11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22405' AND id_supplier = '7' 11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22405' , '7' , '1' ) 11/04/2024 12:06: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 ( '91216' , '7186' , 'NUOVO TESTAMENTO INTERLINEARE' , '1' , '1' , '4' , '79.00' , '79' , '0' , '33' , '52.9300' ) 11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7186' AND id_supplier = '7' 11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7186' , '7' , '1' ) 11/04/2024 12:10:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 12:10:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1109' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 11/04/2024 12:10:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91217' 11/04/2024 12:10:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '91217' 11/04/2024 12:10:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91217' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 11/04/2024 12:23:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608921' AND id_product != '22406' AND ean13 != '' 11/04/2024 12:23:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788826608921', date_upd = NOW() WHERE id_product = '22406' 11/04/2024 12:23:04 pm >> UPDATE ps_product_lang SET name = 'GESU\' CONFIDO IN TE', description = '' WHERE id_product = '22406' 11/04/2024 12:23:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22406' 11/04/2024 12:23:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22406' 11/04/2024 12:23:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22406' 11/04/2024 12:23:05 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22406' 11/04/2024 12:23:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22407' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 12:23:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22407' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22406' 11/04/2024 12:23:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22407' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22406' 11/04/2024 12:23:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 12:23:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1110' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 11/04/2024 12:23:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91218' 11/04/2024 12:23:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91218' 11/04/2024 12:23:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91218' , '22406' , 'GESU CONFIDO IN TE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 11/04/2024 12:25:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820980306' AND id_product != '22407' AND ean13 != '' 11/04/2024 12:25:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788820980306', date_upd = NOW() WHERE id_product = '22407' 11/04/2024 12:25:42 pm >> UPDATE ps_product_lang SET name = 'CAMMINO DI SANTITA\' DI DON M. SOLOCKO', description = '' WHERE id_product = '22407' 11/04/2024 12:25:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '22407' 11/04/2024 12:25:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22407' 11/04/2024 12:25:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22407' 11/04/2024 12:25:44 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22407' 11/04/2024 12:25:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22408' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 12:25:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22408' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22407' 11/04/2024 12:25:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22408' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22407' 11/04/2024 12:26:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL001228' , '2024-04-10' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.08' , '98.08' , NOW() , NOW() ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91219' 11/04/2024 12:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91219' 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '22406' , 'GESU CONFIDO IN TE' , '5' , '5' , '4' , '3.00' , '3' , '0' , '45' , '8.2500' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22406' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22406' , '79' , '1' ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '22111' , 'PREGARE OGGI' , '3' , '3' , '4' , '8.50' , '8.5' , '0' , '45' , '14.0250' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '22191' , 'PREGARE CON I SALMI' , '3' , '3' , '4' , '8.50' , '8.5' , '0' , '45' , '14.0250' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '22370' , 'DIGNITAS INFINITA' , '5' , '5' , '4' , '3.90' , '3.9' , '0' , '45' , '10.7250' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22370' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22370' , '79' , '1' ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '45' , '5.5000' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '22407' , 'CAMMINO DI SANTITA DI DON M. SOLOCKO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '45' , '3.3000' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22407' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22407' , '79' , '1' ) 11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91219' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '1' , '4' , '65.00' , '65' , '0' , '35' , '42.2500' ) 11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22149' AND id_supplier = '79' 11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22149' , '79' , '1' ) 11/04/2024 12:40:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 12:40:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '71' , '2024-04-11' , '' , '3980' , '0' , '4677356' , 'P. ZZA RISORGIMENTO 1 80047 S. GIUSEPPE VESUVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '114.00' , '93.44' , NOW() , NOW() ) 11/04/2024 12:40:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91220' 11/04/2024 12:40:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '91220' 11/04/2024 12:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91220' , '12815' , 'LIBRO DEI CRESIMATI' , '3' , '-3' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '114.00' ) 11/04/2024 12:51:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400236408' AND id_product != '17275' AND ean13 != '' 11/04/2024 12:51:51 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400236408', date_upd = NOW() WHERE id_product = '17275' 11/04/2024 12:51:51 pm >> UPDATE ps_product_lang SET name = 'TELA 18X25- 2963', description = '' WHERE id_product = '17275' 11/04/2024 12:51:51 pm >> UPDATE ps_product SET wholesale_price = '3.41', on_sale = '0', price = '8.19672131147541' WHERE id_product = '17275' 11/04/2024 12:51:51 pm >> UPDATE ps_product_shop SET wholesale_price = '3.41', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17275' 11/04/2024 12:51:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17275' 11/04/2024 12:52:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400276565' AND id_product != '16983' AND ean13 != '' 11/04/2024 12:52:50 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400276565', date_upd = NOW() WHERE id_product = '16983' 11/04/2024 12:52:50 pm >> UPDATE ps_product_lang SET name = 'TELA 18X25 - SACRO CUORE', description = '' WHERE id_product = '16983' 11/04/2024 12:52:50 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '16983' 11/04/2024 12:52:50 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16983' 11/04/2024 12:52:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '16983' 11/04/2024 12:53:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400276565' AND id_product != '16983' AND ean13 != '' 11/04/2024 12:53:09 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400276565', date_upd = NOW() WHERE id_product = '16983' 11/04/2024 12:53:10 pm >> UPDATE ps_product_lang SET name = 'TELA 18X25 - SACRO CUORE', description = '' WHERE id_product = '16983' 11/04/2024 12:53:10 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '16983' 11/04/2024 12:53:10 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16983' 11/04/2024 12:53:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '16983' 11/04/2024 12:54:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000173' AND id_product != '3144' AND ean13 != '' 11/04/2024 12:54:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000173', date_upd = NOW() WHERE id_product = '3144' 11/04/2024 12:54:24 pm >> UPDATE ps_product_lang SET name = 'CROCE TRILOBATA ', description = '' WHERE id_product = '3144' 11/04/2024 12:54:24 pm >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '3144' 11/04/2024 12:54:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3144' 11/04/2024 12:54:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '3144' 11/04/2024 12:58:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400312232' AND id_product != '19315' AND ean13 != '' 11/04/2024 12:58:44 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400312232', date_upd = NOW() WHERE id_product = '19315' 11/04/2024 12:58:44 pm >> UPDATE ps_product_lang SET name = 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209', description = '' WHERE id_product = '19315' 11/04/2024 12:58:44 pm >> UPDATE ps_product SET wholesale_price = '1.13', on_sale = '0', price = '2.6229508196721314' WHERE id_product = '19315' 11/04/2024 12:58:44 pm >> UPDATE ps_product_shop SET wholesale_price = '1.13', price = '2.6229508196721314', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19315' 11/04/2024 12:58:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19315' 11/04/2024 01:02:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318128' AND id_product != '22408' AND ean13 != '' 11/04/2024 01:02:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400318128', date_upd = NOW() WHERE id_product = '22408' 11/04/2024 01:02:02 pm >> UPDATE ps_product_lang SET name = 'PASTRELLA CRESIMA', description = '' WHERE id_product = '22408' 11/04/2024 01:02:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.377049180327869' WHERE id_product = '22408' 11/04/2024 01:02:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22408' 11/04/2024 01:02:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22408' 11/04/2024 01:02:02 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22408' 11/04/2024 01:02:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22409' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 01:02:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22409' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22408' 11/04/2024 01:02:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22409' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22408' 11/04/2024 01:03:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318128' AND id_product != '22408' AND ean13 != '' 11/04/2024 01:03:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400318128', date_upd = NOW() WHERE id_product = '22408' 11/04/2024 01:03:04 pm >> UPDATE ps_product_lang SET name = 'PASTRELLA CRESIMA - 1302/K178', description = '' WHERE id_product = '22408' 11/04/2024 01:03:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.3770' WHERE id_product = '22408' 11/04/2024 01:03:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.3770', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22408' 11/04/2024 01:03:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22408' 11/04/2024 01:03:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318111' AND id_product != '22409' AND ean13 != '' 11/04/2024 01:03:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400318111', date_upd = NOW() WHERE id_product = '22409' 11/04/2024 01:03:48 pm >> UPDATE ps_product_lang SET name = 'PIASTRELLA COMUNIONE - 1302/K212', description = '' WHERE id_product = '22409' 11/04/2024 01:03:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.377049180327869' WHERE id_product = '22409' 11/04/2024 01:03:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22409' 11/04/2024 01:03:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '22409' 11/04/2024 01:03:49 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22409' 11/04/2024 01:03:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22410' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 01:03:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22410' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22409' 11/04/2024 01:03:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22410' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22409' 11/04/2024 01:05:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400291230' AND id_product != '22410' AND ean13 != '' 11/04/2024 01:05:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400291230', date_upd = NOW() WHERE id_product = '22410' 11/04/2024 01:05:09 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07', description = '' WHERE id_product = '22410' 11/04/2024 01:05:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.1311475409836067' WHERE id_product = '22410' 11/04/2024 01:05:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.1311475409836067', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22410' 11/04/2024 01:05:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '22410' 11/04/2024 01:05:10 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22410' 11/04/2024 01:05:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22411' , '1' , '' , 'nuovo-prodotto' ) 11/04/2024 01:05:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22411' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22410' 11/04/2024 01:05:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22411' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22410' 11/04/2024 01:10:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'A1523' , '2024-04-10' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '460.49' , '377.45' , NOW() , NOW() ) 11/04/2024 01:10: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 = '91221' 11/04/2024 01:10:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91221' 11/04/2024 01:10: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 ( '91221' , '16983' , 'TELA 18X25 - SACRO CUORE' , '1' , '1' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '4.5750' ) 11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16983' AND id_supplier = '28' 11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16983' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '3144' , 'CROCE TRILOBATA ' , '50' , '50' , '1' , '1.79' , '1.4672131147541' , '22' , '0' , '109.1900' ) 11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3144' AND id_supplier = '28' 11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3144' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '30' , '30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '91.5000' ) 11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28' 11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '4' , '4' , '1' , '4.53' , '3.7131147540984' , '22' , '0' , '22.1064' ) 11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '50' , '50' , '1' , '1.19' , '0.97540983606557' , '22' , '0' , '72.5900' ) 11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '28' 11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '22408' , 'PASTRELLA CRESIMA' , '1' , '1' , '1' , '3.29' , '2.6967213114754' , '22' , '0' , '4.0138' ) 11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22408' AND id_supplier = '28' 11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22408' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '1' , '1' , '3.29' , '2.6967213114754' , '22' , '0' , '4.0138' ) 11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22409' AND id_supplier = '28' 11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22409' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '50' , '50' , '1' , '1' , '0.81967213114754' , '22' , '0' , '61.0000' ) 11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22410' AND id_supplier = '28' 11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22410' , '28' , '1' ) 11/04/2024 01:10: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 ( '91221' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '20' , '20' , '1' , '3.15' , '2.5819672131148' , '22' , '0' , '76.8600' ) 11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22198' AND id_supplier = '28' 11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22198' , '28' , '1' ) 11/04/2024 03:21:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 03:21: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' , '1111' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 11/04/2024 03:21: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 = '91222' 11/04/2024 03:21:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91222' 11/04/2024 03:21: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 ( '91222' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 11/04/2024 03:21: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 ( '91222' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 11/04/2024 03:21: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 ( '91222' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 11/04/2024 03:21: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 ( '91222' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 11/04/2024 03:30:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 03:30: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' , '1112' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 11/04/2024 03:30: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 = '91223' 11/04/2024 03:30:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91223' 11/04/2024 03:30: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 ( '91223' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 11/04/2024 03:37:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 03:37:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1113' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 11/04/2024 03:37:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91224' 11/04/2024 03:37:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91224' 11/04/2024 03:37:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91224' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 11/04/2024 04:17:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1106' AND id_document != '91212' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 04:17:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1106', document_date = '2024-04-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 = '140.35', price_tax_excluded = '135.89', date_upd = NOW() WHERE id_document = '91212' 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91212' 11/04/2024 04:17:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '91212' 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91212' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '10.0000' , '10' , '0' , '0' , '60.00' ) 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91212' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '13.00' ) 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91212' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91212' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91212' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 11/04/2024 04:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91212' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU 2024' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 11/04/2024 04:32:59 pm >> DELETE FROM ps_document WHERE id_document = '89735' 11/04/2024 04:32:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89735' 11/04/2024 04:33:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '72' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 04:33: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 ( '21' , '72' , '2024-04-11' , '' , '161' , '0' , '4679291' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '184.30' , '184.30' , NOW() , NOW() ) 11/04/2024 04:33: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 = '91225' 11/04/2024 04:33:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91225' 11/04/2024 04:33: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 ( '91225' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '7' , '-7' , '4' , '12.00' , '12' , '0' , '5' , '79.80' ) 11/04/2024 04:33: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 ( '91225' , '22374' , 'MOGOL' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 11/04/2024 04:33: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 ( '91225' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '5' , '85.50' ) 11/04/2024 05:05:07 pm >> DELETE FROM ps_document WHERE id_document = '91225' 11/04/2024 05:05:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91225' 11/04/2024 06:17:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 06:17:12 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' , '1114' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 11/04/2024 06:17:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91226' 11/04/2024 06:17:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91226' 11/04/2024 06:17:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91226' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 11/04/2024 06:36:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 06:36:30 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' , '1115' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.90' , '9.22' , NOW() , NOW() ) 11/04/2024 06:36:30 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 = '91227' 11/04/2024 06:36:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91227' 11/04/2024 06:36:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91227' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 11/04/2024 06:36:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91227' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/04/2024 06:41:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 06:41:51 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' , '1116' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 11/04/2024 06:41:51 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 = '91228' 11/04/2024 06:41:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91228' 11/04/2024 06:41:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91228' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 11/04/2024 07:15:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 07:15:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1117' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.80' , '12.95' , NOW() , NOW() ) 11/04/2024 07:15:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91229' 11/04/2024 07:15:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91229' 11/04/2024 07:15:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91229' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 11/04/2024 07:23:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 11/04/2024 07:23:45 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' , '1118' , '2024-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 11/04/2024 07:23:45 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 = '91230' 11/04/2024 07:23:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91230' 11/04/2024 07:23:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91230' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 11/04/2024 07:32:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '46/A' AND id_document != '91065' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-03') 11/04/2024 07:32:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '46/A', document_date = '2024-04-03', document_letter = 'A', id_customer = '2912', id_supplier = '', id_address = '4672779', address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO', 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 = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '91065' 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91065' 11/04/2024 07:32:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91065' 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , 'tunica bordo oro' , '1' , '-1' , '0' , '55.0000' , '55' , '0' , '0' , '55.00' ) 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '100 n 1' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '105 - n 2' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '110 - n. 5' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '115 - n 6' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '120 - n 1' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '125 - n 1' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' )