23/09/2023 08:09:23 am >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '87386' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-22') 23/09/2023 08:09:23 am >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2023-09-22', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '200.09', price_tax_excluded = '200.09', date_upd = NOW() WHERE id_document = '87386' 23/09/2023 08:09: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 = '87386' 23/09/2023 08:09:23 am >> DELETE FROM ps_document_detail WHERE id_document = '87386' 23/09/2023 08:09: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 ( '87386' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.4000' , '3.4' , '0' , '15' , '28.90' ) 23/09/2023 08:09: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 ( '87386' , '5457' , 'IO SONO CON VOI 1 PARTE' , '16' , '-16' , '4' , '2.8000' , '2.8' , '0' , '15' , '38.08' ) 23/09/2023 08:09: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 ( '87386' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '-15' , '4' , '2.8000' , '2.8' , '0' , '15' , '35.70' ) 23/09/2023 08:09:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '11191' , 'VENITE CON ME 1 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 23/09/2023 08:09:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '15' , '14.28' ) 23/09/2023 08:09:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 23/09/2023 08:09:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.4000' , '2.4' , '0' , '30' , '21.84' ) 23/09/2023 08:14:07 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/09/2023 08:14:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21585' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:14:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21585' , '1' , '1' , '2' , NOW() , NOW() ) 23/09/2023 08:14:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21585' , '0' , '1' , '0' , '0' ) 23/09/2023 08:15:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249837' AND id_product != '21585' AND ean13 != '' 23/09/2023 08:15:21 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788861249837', date_upd = NOW() WHERE id_product = '21585' 23/09/2023 08:15:21 am >> UPDATE ps_product_lang SET name = 'ACCOLTI - QUADERNO', description = '' WHERE id_product = '21585' 23/09/2023 08:15:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.5' WHERE id_product = '21585' 23/09/2023 08:15:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21585' 23/09/2023 08:15:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21585' 23/09/2023 08:15: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 = '21585' 23/09/2023 08:15:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21586' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:15: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 '21586' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21585' 23/09/2023 08:15:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21586' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21585' 23/09/2023 08:15:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870161' AND id_product != '21586' AND ean13 != '' 23/09/2023 08:15:45 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788892870161', date_upd = NOW() WHERE id_product = '21586' 23/09/2023 08:15:45 am >> UPDATE ps_product_lang SET name = 'ACCOLTI - GUIDA', description = '' WHERE id_product = '21586' 23/09/2023 08:15:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.5' WHERE id_product = '21586' 23/09/2023 08:15:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21586' 23/09/2023 08:15:45 am >> DELETE FROM ps_specific_price WHERE id_product = '21586' 23/09/2023 08:15: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 = '21586' 23/09/2023 08:15:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21587' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:15: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 '21587' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21586' 23/09/2023 08:15:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21587' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21586' 23/09/2023 08:16:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870178' AND id_product != '21587' AND ean13 != '' 23/09/2023 08:16:48 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788892870178', date_upd = NOW() WHERE id_product = '21587' 23/09/2023 08:16:48 am >> UPDATE ps_product_lang SET name = 'PERDONATI - GUIDA', description = '' WHERE id_product = '21587' 23/09/2023 08:16:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.5' WHERE id_product = '21587' 23/09/2023 08:16:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21587' 23/09/2023 08:16:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21587' 23/09/2023 08:16:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21587' 23/09/2023 08:16:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21588' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:16:49 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 '21588' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21587' 23/09/2023 08:16:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21588' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21587' 23/09/2023 08:18:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248649' AND id_product != '21588' AND ean13 != '' 23/09/2023 08:18:24 am >> UPDATE ps_product SET id_supplier = '', reference = '2/3', ean13 = '9788861248649', date_upd = NOW() WHERE id_product = '21588' 23/09/2023 08:18:24 am >> UPDATE ps_product_lang SET name = 'LA CHIESA - TERZO ANNO', description = '' WHERE id_product = '21588' 23/09/2023 08:18:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5' WHERE id_product = '21588' 23/09/2023 08:18:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21588' 23/09/2023 08:18:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21588' 23/09/2023 08:18:25 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21588' 23/09/2023 08:18:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21589' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:18:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21589' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21588' 23/09/2023 08:18:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21589' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21588' 23/09/2023 08:21:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067743' AND id_product != '21589' AND ean13 != '' 23/09/2023 08:21:16 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788801067743', date_upd = NOW() WHERE id_product = '21589' 23/09/2023 08:21:16 am >> UPDATE ps_product_lang SET name = 'CREAZIONE RACCONTATA AI BAMBINI - FERRERO/PAIRETTO', description = '' WHERE id_product = '21589' 23/09/2023 08:21:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.9' WHERE id_product = '21589' 23/09/2023 08:21:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21589' 23/09/2023 08:21:16 am >> DELETE FROM ps_specific_price WHERE id_product = '21589' 23/09/2023 08:21:17 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 = '21589' 23/09/2023 08:21:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21590' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:21:17 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 '21590' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21589' 23/09/2023 08:21:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21590' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21589' 23/09/2023 08:22:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068580' AND id_product != '21590' AND ean13 != '' 23/09/2023 08:22:34 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801068580', date_upd = NOW() WHERE id_product = '21590' 23/09/2023 08:22:34 am >> UPDATE ps_product_lang SET name = 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE', description = '' WHERE id_product = '21590' 23/09/2023 08:22:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21590' 23/09/2023 08:22:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21590' 23/09/2023 08:22:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21590' 23/09/2023 08:22:35 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21590' 23/09/2023 08:22:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21591' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:22: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 '21591' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21590' 23/09/2023 08:22:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21591' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21590' 23/09/2023 08:23:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572205' AND id_product != '21591' AND ean13 != '' 23/09/2023 08:23:56 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788867572205', date_upd = NOW() WHERE id_product = '21591' 23/09/2023 08:23:56 am >> UPDATE ps_product_lang SET name = 'GESU\' VIENE AD ABITARE CON NOI - SCHEDE 1', description = '' WHERE id_product = '21591' 23/09/2023 08:23:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '21591' 23/09/2023 08:23:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21591' 23/09/2023 08:23:56 am >> DELETE FROM ps_specific_price WHERE id_product = '21591' 23/09/2023 08:23: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 = '21591' 23/09/2023 08:23:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21592' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:23: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 '21592' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21591' 23/09/2023 08:23:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21592' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21591' 23/09/2023 08:24:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572212' AND id_product != '21592' AND ean13 != '' 23/09/2023 08:24:13 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788867572212', date_upd = NOW() WHERE id_product = '21592' 23/09/2023 08:24:13 am >> UPDATE ps_product_lang SET name = 'GESU\' VIENE AD ABITARE CON NOI - SCHEDE 2', description = '' WHERE id_product = '21592' 23/09/2023 08:24:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '21592' 23/09/2023 08:24:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21592' 23/09/2023 08:24:13 am >> DELETE FROM ps_specific_price WHERE id_product = '21592' 23/09/2023 08:24:14 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 = '21592' 23/09/2023 08:24:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21593' , '1' , '' , 'nuovo-prodotto' ) 23/09/2023 08:24:14 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 '21593' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21592' 23/09/2023 08:24:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21593' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21592' 23/09/2023 08:24:33 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' , '641264' , '2023-09-20' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.58' , '171.58' , NOW() , NOW() ) 23/09/2023 08:24:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87394' 23/09/2023 08:24:33 am >> DELETE FROM ps_document_detail WHERE id_document = '87394' 23/09/2023 08:24: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 ( '87394' , '12342' , 'ALBERO DOVE I PICCOLI TROVANO IL NIDO 3 ' , '1' , '1' , '4' , '19.90' , '19.9' , '0' , '35+7' , '12.0295' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '12342' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12342' , '7' , '1' ) 23/09/2023 08:24: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 ( '87394' , '15610' , 'MAMMA E PAPA A CATECHISMO' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '35+7' , '4.7755' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '15610' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15610' , '7' , '1' ) 23/09/2023 08:24: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 ( '87394' , '8844' , 'RECITIAMO A CATECHISMO' , '1' , '1' , '4' , '8.00' , '8' , '0' , '35+7' , '4.8360' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '8844' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8844' , '7' , '1' ) 23/09/2023 08:24: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 ( '87394' , '13431' , 'PASSI VERSO LEUCARISTIA' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '35+7' , '3.5666' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '13431' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13431' , '7' , '1' ) 23/09/2023 08:24: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 ( '87394' , '2573' , 'CON GLI ADOLESCENTI' , '1' , '1' , '4' , '7.00' , '7' , '0' , '35+7' , '4.2315' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '2573' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2573' , '7' , '1' ) 23/09/2023 08:24: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 ( '87394' , '12937' , 'CATECHISMO DELLA CHIESA CATTOLICA' , '1' , '1' , '4' , '29.90' , '29.9' , '0' , '33+7' , '18.6307' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '12937' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12937' , '7' , '1' ) 23/09/2023 08:24: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 ( '87394' , '17073' , 'DIRETTORIO PER LA CATECHESI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33+7' , '9.9696' ) 23/09/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '17073' AND id_supplier = '7' 23/09/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17073' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21586' , 'ACCOLTI - GUIDA' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '30+7' , '4.8825' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21586' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21586' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21585' , 'ACCOLTI - QUADERNO' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '30+7' , '4.8825' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21585' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21585' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21587' , 'PERDONATI - GUIDA' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '30+7' , '4.8825' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21587' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21587' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '15982' , 'ANTICO TESTAMENTO - 1° ANNO' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '30+7' , '4.2315' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '15982' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15982' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '17247' , 'NUOVO TESTAMENTO UNA PROMESSA ....' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '30+7' , '4.2315' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '17247' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17247' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21588' , 'LA CHIESA - TERZO ANNO' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '30+7' , '4.2315' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21588' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21588' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '18432' , 'SETTE SACRAMENTI ' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '30+7' , '4.2315' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18432' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18432' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '18729' , 'GIOCHI PER IL CATECHISMO' , '2' , '2' , '4' , '9.90' , '9.9' , '0' , '30+7' , '12.8898' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18729' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18729' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '16077' , 'CELEBRAZIONI PER IL CATECHISMO' , '2' , '2' , '4' , '6.90' , '6.9' , '0' , '30+7' , '8.9838' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '16077' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16077' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '19931' , '100 IDEE PER IL CATECHISMO' , '2' , '2' , '4' , '14.90' , '14.9' , '0' , '30+7' , '19.3998' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19931' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19931' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '2' , '2' , '4' , '14.90' , '14.9' , '0' , '30+7' , '19.3998' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21589' , 'CREAZIONE RACCONTATA AI BAMBINI - FERRERO/PAIRETTO' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '35' , '3.8350' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21589' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21589' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21590' , 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21590' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21590' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21591' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 1' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '30' , '4.8300' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21591' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21591' , '7' , '1' ) 23/09/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87394' , '21592' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 2' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '30' , '4.8300' ) 23/09/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21592' AND id_supplier = '7' 23/09/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21592' , '7' , '1' ) 23/09/2023 08:31:36 am >> SELECT document_num FROM ps_document WHERE document_num = '55' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 08:31:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '55' , '2023-09-23' , '' , '7065' , '0' , '149355602' , 'Strada Della Val Di Serra , 30 5100 Terni ' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '8.80' , '8.80' , NOW() , NOW() ) 23/09/2023 08:31:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12662' 23/09/2023 08:31:36 am >> DELETE FROM ps_document_detail WHERE id_document = '12662' 23/09/2023 08:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12662' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 23/09/2023 10:42:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 10:42:27 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' , '2896' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 23/09/2023 10:42:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87395' 23/09/2023 10:42:27 am >> DELETE FROM ps_document_detail WHERE id_document = '87395' 23/09/2023 10:42:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87395' , '19744' , 'ASCOLTAMI GESU' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 23/09/2023 10:48:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 10:48:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2897' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.70' , '22.63' , NOW() , NOW() ) 23/09/2023 10:48:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87396' 23/09/2023 10:48:54 am >> DELETE FROM ps_document_detail WHERE id_document = '87396' 23/09/2023 10:48:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87396' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/09/2023 10:48:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87396' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/09/2023 10:48:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87396' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 23/09/2023 10:59:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 10:59:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2898' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 23/09/2023 10:59:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87397' 23/09/2023 10:59:48 am >> DELETE FROM ps_document_detail WHERE id_document = '87397' 23/09/2023 10:59:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87397' , '16818' , 'INCENSO ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 23/09/2023 10:59:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87397' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 23/09/2023 10:59:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87397' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 23/09/2023 11:08:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 11:08: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' , '2899' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 23/09/2023 11:08: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 = '87398' 23/09/2023 11:08:16 am >> DELETE FROM ps_document_detail WHERE id_document = '87398' 23/09/2023 11:08: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 ( '87398' , '20983' , 'CLERGY MM LIMITED 80/20' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '80.00' ) 23/09/2023 11:10:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2900' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 11:10:27 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' , '2900' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 23/09/2023 11:10:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87399' 23/09/2023 11:10:27 am >> DELETE FROM ps_document_detail WHERE id_document = '87399' 23/09/2023 11:10:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87399' , '21044' , 'STOLA IN LANA TESS. TELAIO - 75/1602' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 23/09/2023 12:21:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 12:21:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2901' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.18' , '40.14' , NOW() , NOW() ) 23/09/2023 12:21:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87400' 23/09/2023 12:21:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '87400' 23/09/2023 12:21:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87400' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 23/09/2023 12:21:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87400' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 23/09/2023 12:21:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87400' , '8260' , 'PREGHIAMO INSIEME E DICIAMO - M. BARZIZZA' , '1' , '-1' , '4' , '32.50' , '32.5' , '0' , '5' , '30.88' ) 23/09/2023 12:31:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 23/09/2023 12:31: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' , '2902' , '2023-09-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.00' , '51.64' , NOW() , NOW() ) 23/09/2023 12:31: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 = '87401' 23/09/2023 12:31:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '87401' 23/09/2023 12:31: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 ( '87401' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '63' , '51.639344262295' , '22' , '0' , '63.00' ) 23/09/2023 12:44:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '119' AND id_document != '87343' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-19') 23/09/2023 12:44:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '119', document_date = '2023-09-19', document_letter = '', id_customer = '1832', id_supplier = '', id_address = '4670920', address1 = 'C.DA PANTANO 85010 PIGNOLA', address2 = '', note = 'manca nel pacco guida anno b', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '143.27', price_tax_excluded = '143.27', date_upd = NOW() WHERE id_document = '87343' 23/09/2023 12:44: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 = '87343' 23/09/2023 12:44:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87343' 23/09/2023 12:44: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 ( '87343' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '12' , '-12' , '4' , '2.5000' , '2.5' , '0' , '15' , '25.50' ) 23/09/2023 12:44: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 ( '87343' , '4154' , 'FESTA DEL PERDONO' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '15' , '33.15' ) 23/09/2023 12:44: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 ( '87343' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '15' , '42.50' ) 23/09/2023 12:44: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 ( '87343' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '12' , '-12' , '4' , '3.4000' , '3.4' , '0' , '15' , '34.68' ) 23/09/2023 12:44: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 ( '87343' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 23/09/2023 12:44: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 ( '87343' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '0' , '0.7500' , '0.75' , '0' , '15' , '3.19' )