22/11/2023 09:11:08 am >> UPDATE ps_document SET id_document_type = '31', document_num = '530', document_date = '2023-11-21', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '84.00', price_tax_excluded = '84.00', date_upd = NOW() WHERE id_document = '89058' 22/11/2023 09:11: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 = '89058' 22/11/2023 09:11:08 am >> DELETE FROM ps_document_detail WHERE id_document = '89058' 22/11/2023 09:11: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 ( '89058' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3200' , '3200' , '4' , '0.0350' , '0.035' , '0' , '25' , '84.00' ) 22/11/2023 09:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 22/11/2023 09:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 22/11/2023 09:20:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '3271/23' , '2023-11-17' , '23' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '564.93' , '543.20' , NOW() , NOW() ) 22/11/2023 09:20:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89062' 22/11/2023 09:20:50 am >> DELETE FROM ps_document_detail WHERE id_document = '89062' 22/11/2023 09:20:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89062' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '280' , '280' , '3' , '2' , '1.9230769230769' , '4' , '3' , '564.9280' ) 22/11/2023 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 22/11/2023 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 22/11/2023 09:22:05 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/11/2023 09:22:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21865' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 09:22:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21865' , '1' , '1' , '2' , NOW() , NOW() ) 22/11/2023 09:22:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21865' , '0' , '1' , '0' , '0' ) 22/11/2023 09:22:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856681345' AND id_product != '21865' AND ean13 != '' 22/11/2023 09:22:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788856681345', date_upd = NOW() WHERE id_product = '21865' 22/11/2023 09:22:46 am >> UPDATE ps_product_lang SET name = 'ETA\' DA INVENTARE - V. PAGLIA', description = '' WHERE id_product = '21865' 22/11/2023 09:22:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.5' WHERE id_product = '21865' 22/11/2023 09:22:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.5', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21865' 22/11/2023 09:22:46 am >> DELETE FROM ps_specific_price WHERE id_product = '21865' 22/11/2023 09:22:47 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21865' 22/11/2023 09:22:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21866' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 09:22:47 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21866' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21865' 22/11/2023 09:22:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21866' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21865' 22/11/2023 09:23:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856694925' AND id_product != '21866' AND ean13 != '' 22/11/2023 09:23:30 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788856694925', date_upd = NOW() WHERE id_product = '21866' 22/11/2023 09:23:30 am >> UPDATE ps_product_lang SET name = 'DIO NON VI LASCIA MAI SOLI - M. ZUPPI', description = '' WHERE id_product = '21866' 22/11/2023 09:23:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.9' WHERE id_product = '21866' 22/11/2023 09:23:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.9', id_tax_rules_group = '4', id_category_default = '70', 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 = '21866' 22/11/2023 09:23:30 am >> DELETE FROM ps_specific_price WHERE id_product = '21866' 22/11/2023 09:23:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21866' 22/11/2023 09:23:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21867' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 09:23:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21867' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21866' 22/11/2023 09:23:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21867' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21866' 22/11/2023 09:24:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788854172388' AND id_product != '21867' AND ean13 != '' 22/11/2023 09:24:14 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788854172388', date_upd = NOW() WHERE id_product = '21867' 22/11/2023 09:24:14 am >> UPDATE ps_product_lang SET name = 'PICCOLO PRINCIPE', description = '' WHERE id_product = '21867' 22/11/2023 09:24:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21867' 22/11/2023 09:24:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '484', id_argoment_default = '90', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21867' 22/11/2023 09:24:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21867' 22/11/2023 09:25:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1225076' , '2023-11-19' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '137.20' , '137.20' , NOW() , NOW() ) 22/11/2023 09:25:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89063' 22/11/2023 09:25:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89063' 22/11/2023 09:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89063' , '21865' , 'ETA DA INVENTARE - V. PAGLIA' , '1' , '1' , '4' , '17.50' , '17.5' , '0' , '0' , '17.50' ) 22/11/2023 09:25:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21865' AND id_supplier = '177' 22/11/2023 09:25:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21865' , '177' , '1' ) 22/11/2023 09:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89063' , '21775' , 'AMORE VINCE - C. AMIRANTE' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '0' , '25.8000' ) 22/11/2023 09:25:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21775' AND id_supplier = '177' 22/11/2023 09:25:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21775' , '177' , '1' ) 22/11/2023 09:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89063' , '21866' , 'DIO NON VI LASCIA MAI SOLI - M. ZUPPI' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '0' , '18.90' ) 22/11/2023 09:25:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21866' AND id_supplier = '177' 22/11/2023 09:25:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21866' , '177' , '1' ) 22/11/2023 09:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89063' , '21780' , 'FRATELLINO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/11/2023 09:25:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21780' AND id_supplier = '177' 22/11/2023 09:25:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21780' , '177' , '1' ) 22/11/2023 09:25:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89063' , '21670' , 'PER CUSTODIRE IL FUOCO - L. EPICOCO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '0' , '24.0000' ) 22/11/2023 09:25:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21670' AND id_supplier = '177' 22/11/2023 09:25:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21670' , '177' , '1' ) 22/11/2023 09:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89063' , '21867' , 'PICCOLO PRINCIPE' , '10' , '10' , '4' , '3.90' , '3.9' , '0' , '0' , '39.0000' ) 22/11/2023 09:25:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21867' AND id_supplier = '177' 22/11/2023 09:25:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21867' , '177' , '1' ) 22/11/2023 10:30:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 10:30:03 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' , '3679' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.33' , '3.33' , NOW() , NOW() ) 22/11/2023 10:30:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89064' 22/11/2023 10:30:03 am >> DELETE FROM ps_document_detail WHERE id_document = '89064' 22/11/2023 10:30:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89064' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 22/11/2023 10:38: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 = '20320' 22/11/2023 10:38:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21868' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 10:38: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 '21868' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20320' 22/11/2023 10:38:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21868' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20320' 22/11/2023 10:38:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793057' AND id_product != '21868' AND ean13 != '' 22/11/2023 10:38:47 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788878793057', date_upd = NOW() WHERE id_product = '21868' 22/11/2023 10:38:47 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - GEN/FEB 2024', description = '' WHERE id_product = '21868' 22/11/2023 10:38:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '21868' 22/11/2023 10:38:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', 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 = '21868' 22/11/2023 10:38:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21868' 22/11/2023 10:38: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 = '21868' 22/11/2023 10:38:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21869' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 10:38:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21869' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21868' 22/11/2023 10:38:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21869' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21868' 22/11/2023 10:39:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793064' AND id_product != '21869' AND ean13 != '' 22/11/2023 10:39:22 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788878793064', date_upd = NOW() WHERE id_product = '21869' 22/11/2023 10:39:22 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - mar/apr 2024', description = '' WHERE id_product = '21869' 22/11/2023 10:39:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '21869' 22/11/2023 10:39:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', 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 = '21869' 22/11/2023 10:39:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21869' 22/11/2023 10:40:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793064' AND id_product != '21869' AND ean13 != '' 22/11/2023 10:40:28 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788878793064', date_upd = NOW() WHERE id_product = '21869' 22/11/2023 10:40:28 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - MAR/APR 2024', description = '' WHERE id_product = '21869' 22/11/2023 10:40:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.0000' WHERE id_product = '21869' 22/11/2023 10:40:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.0000', id_tax_rules_group = '4', id_category_default = '271', 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 = '21869' 22/11/2023 10:40:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21869' 22/11/2023 10:41:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '614/23' , '2023-11-15' , '23' , '0' , '40' , '2635' , 'VIA VIRGINIA AGNELLI, 100 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '86.40' , '86.40' , NOW() , NOW() ) 22/11/2023 10:41:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89065' 22/11/2023 10:41:14 am >> DELETE FROM ps_document_detail WHERE id_document = '89065' 22/11/2023 10:41:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89065' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 22/11/2023 10:41:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21868' AND id_supplier = '40' 22/11/2023 10:41:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21868' , '40' , '1' ) 22/11/2023 10:41:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89065' , '21869' , 'MESSA MEDITAZIONE - mar/apr 2024' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 22/11/2023 10:41:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21869' AND id_supplier = '40' 22/11/2023 10:41:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21869' , '40' , '1' ) 22/11/2023 10:41:21 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/11/2023 10:41:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21870' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 10:41:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21870' , '1' , '1' , '2' , NOW() , NOW() ) 22/11/2023 10:41:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21870' , '0' , '1' , '0' , '0' ) 22/11/2023 10:41:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864097480' AND id_product != '21870' AND ean13 != '' 22/11/2023 10:41:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788864097480', date_upd = NOW() WHERE id_product = '21870' 22/11/2023 10:41:49 am >> UPDATE ps_product_lang SET name = 'FIGLI DI NAGASAKI', description = '' WHERE id_product = '21870' 22/11/2023 10:41:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '21870' 22/11/2023 10:41:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21870' 22/11/2023 10:41:49 am >> DELETE FROM ps_specific_price WHERE id_product = '21870' 22/11/2023 10:41:51 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 = '21870' 22/11/2023 10:41:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21871' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 10:41:51 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 '21871' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21870' 22/11/2023 10:41:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21871' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21870' 22/11/2023 10:43:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299858' AND id_product != '21871' AND ean13 != '' 22/11/2023 10:43:42 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788869299858', date_upd = NOW() WHERE id_product = '21871' 22/11/2023 10:43:42 am >> UPDATE ps_product_lang SET name = '50 DOMANDE SULLA FEDE - R. MACCIONI', description = '' WHERE id_product = '21871' 22/11/2023 10:43:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21871' 22/11/2023 10:43:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '45', 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 = '21871' 22/11/2023 10:43:42 am >> DELETE FROM ps_specific_price WHERE id_product = '21871' 22/11/2023 10:43:44 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 = '21871' 22/11/2023 10:43:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21872' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 10:43:44 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 '21872' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21871' 22/11/2023 10:43:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21872' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21871' 22/11/2023 10:47:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 10:47: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' , '3680' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 22/11/2023 10:47: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 = '89066' 22/11/2023 10:47:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89066' 22/11/2023 10:47: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 ( '89066' , '18139' , 'TAU SNODATO PADRE NOSTRO PICCOLO' , '5' , '-5' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '40.00' ) 22/11/2023 10:47: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 ( '89066' , '18141' , 'TAU SNODATO PADRE NOSTRO GRANDE' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 22/11/2023 10:47: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 ( '89066' , '18131' , 'TAU MEDIO CM3 - T6' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 22/11/2023 10:50:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623690' AND id_product != '21872' AND ean13 != '' 22/11/2023 10:50:56 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9791259623690', date_upd = NOW() WHERE id_product = '21872' 22/11/2023 10:50:56 am >> UPDATE ps_product_lang SET name = 'TU SEI LA MIA ROVINA - A. MUSOLESI', description = '' WHERE id_product = '21872' 22/11/2023 10:50:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '21872' 22/11/2023 10:50:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '143', 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 = '21872' 22/11/2023 10:50:57 am >> DELETE FROM ps_specific_price WHERE id_product = '21872' 22/11/2023 10:51: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 = '21872' 22/11/2023 10:51:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21873' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 10:51:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21873' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21872' 22/11/2023 10:51:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21873' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21872' 22/11/2023 10:52:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254712368' AND id_product != '21873' AND ean13 != '' 22/11/2023 10:52:44 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791254712368', date_upd = NOW() WHERE id_product = '21873' 22/11/2023 10:52:44 am >> UPDATE ps_product_lang SET name = 'IN TERRA SANTA - G. RAVASI', description = '' WHERE id_product = '21873' 22/11/2023 10:52:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '21873' 22/11/2023 10:52:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '259', 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 = '21873' 22/11/2023 10:52:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21873' 22/11/2023 10:59:58 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' , '1149895' , '2023-11-17' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '2107.30' , '2107.30' , NOW() , NOW() ) 22/11/2023 10:59:58 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 = '89067' 22/11/2023 10:59:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89067' 22/11/2023 10:59:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '21873' , 'IN TERRA SANTA - G. RAVASI' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 22/11/2023 10:59:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '21873' AND id_supplier = '109' 22/11/2023 10:59:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21873' , '109' , '1' ) 22/11/2023 10:59:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 22/11/2023 10:59:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20974' AND id_supplier = '109' 22/11/2023 10:59:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20974' , '109' , '1' ) 22/11/2023 10:59:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '21872' , 'TU SEI LA MIA ROVINA - A. MUSOLESI' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '0' , '15.90' ) 22/11/2023 10:59:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '21872' AND id_supplier = '109' 22/11/2023 10:59:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21872' , '109' , '1' ) 22/11/2023 10:59:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 22/11/2023 10:59:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 22/11/2023 10:59:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 22/11/2023 10:59:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '20902' , 'SCIENZIATI DUNQUE CREDENTI - F. AGNOLI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 10:59:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20902' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20902' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '21773' , 'MERAVIGLIA DELLEVENTO CRISTIANO - G. BIFFI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '21773' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21773' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '20974' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20974' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '2518' , 'COMMENTO AL VANGELO DI GIOVANNI - SANTAGOSTINO' , '1' , '1' , '4' , '29.50' , '29.5' , '0' , '0' , '29.50' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '2518' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2518' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '21870' , 'FIGLI DI NAGASAKI' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '21870' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21870' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '21871' , '50 DOMANDE SULLA FEDE - R. MACCIONI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '21871' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21871' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '25' , '25' , '4' , '38.00' , '38' , '0' , '0' , '950.0000' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '8' , '8' , '4' , '45.00' , '45' , '0' , '0' , '360.0000' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '1146' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1146' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '11740' , 'BIBBIA DI GERUSALEMME - GIGANTE DA ALTARE' , '1' , '1' , '4' , '115.00' , '115' , '0' , '0' , '115.00' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '11740' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11740' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '3' , '3' , '4' , '42.00' , '42' , '0' , '0' , '126.0000' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '1145' AND id_supplier = '109' 22/11/2023 10:59:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1145' , '109' , '1' ) 22/11/2023 10:59:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89067' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '8' , '8' , '4' , '46.00' , '46' , '0' , '0' , '368.0000' ) 22/11/2023 10:59:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '1147' AND id_supplier = '109' 22/11/2023 11:00:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1147' , '109' , '1' ) 22/11/2023 11:00:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254712368' AND id_product != '21873' AND ean13 != '' 22/11/2023 11:00:05 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791254712368', date_upd = NOW() WHERE id_product = '21873' 22/11/2023 11:00:05 am >> UPDATE ps_product_lang SET name = 'IN TERRA SANTA - G. RAVASI', description = '' WHERE id_product = '21873' 22/11/2023 11:00:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '21873' 22/11/2023 11:00:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '259', 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 = '21873' 22/11/2023 11:00:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21873' 22/11/2023 11:03:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 11:03:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3681' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 22/11/2023 11:03:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89068' 22/11/2023 11:03:53 am >> DELETE FROM ps_document_detail WHERE id_document = '89068' 22/11/2023 11:03:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89068' , '18561' , 'FORMELLA SAGOMATA 26X26 ' , '1' , '-1' , '1' , '89.00' , '72.950819672131' , '22' , '0' , '89.00' ) 22/11/2023 11:06:35 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/11/2023 11:06:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21874' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:06:35 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21874' , '1' , '1' , '2' , NOW() , NOW() ) 22/11/2023 11:06:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21874' , '0' , '1' , '0' , '0' ) 22/11/2023 11:08:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253377' AND id_product != '21874' AND ean13 != '' 22/11/2023 11:08:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281253377', date_upd = NOW() WHERE id_product = '21874' 22/11/2023 11:08:23 am >> UPDATE ps_product_lang SET name = 'BETLEMME OGGO SEI TU - A. COMASTRI', description = '' WHERE id_product = '21874' 22/11/2023 11:08:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21874' 22/11/2023 11:08:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21874' 22/11/2023 11:08:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21874' 22/11/2023 11:08:24 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 = '21874' 22/11/2023 11:08:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21875' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:08:24 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 '21875' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21874' 22/11/2023 11:08:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21875' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21874' 22/11/2023 11:09:55 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' , '649233' , '2023-11-20' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.87' , '19.87' , NOW() , NOW() ) 22/11/2023 11:09:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89069' 22/11/2023 11:09:55 am >> DELETE FROM ps_document_detail WHERE id_document = '89069' 22/11/2023 11:09:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '21828' , 'VANGELO DI GESU ' , '1' , '1' , '4' , '3.10' , '3.1' , '0' , '30' , '2.1700' ) 22/11/2023 11:09:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21828' AND id_supplier = '7' 22/11/2023 11:09:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21828' , '7' , '1' ) 22/11/2023 11:09:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '3521' , 'DIO SI È FATTO UOMO - K. RAHNER' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '30' , '5.9500' ) 22/11/2023 11:09:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '3521' AND id_supplier = '7' 22/11/2023 11:09:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3521' , '7' , '1' ) 22/11/2023 11:09:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '21874' , 'BETLEMME OGGO SEI TU - A. COMASTRI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 22/11/2023 11:09:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21874' AND id_supplier = '7' 22/11/2023 11:09:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21874' , '7' , '1' ) 22/11/2023 11:09:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '9338' , 'SACROSANCTUM CONCILIUM' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '33' , '3.3500' ) 22/11/2023 11:09:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '9338' AND id_supplier = '7' 22/11/2023 11:09:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9338' , '7' , '1' ) 22/11/2023 11:13:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 11:13:42 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' , '3682' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.40' , '16.80' , NOW() , NOW() ) 22/11/2023 11:13:42 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 = '89070' 22/11/2023 11:13:42 am >> DELETE FROM ps_document_detail WHERE id_document = '89070' 22/11/2023 11:13:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89070' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 22/11/2023 11:13:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89070' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/11/2023 11:13:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89070' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/11/2023 11:13:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89070' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 22/11/2023 11:15:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885952409' AND id_product != '21875' AND ean13 != '' 22/11/2023 11:15:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788885952409', date_upd = NOW() WHERE id_product = '21875' 22/11/2023 11:15:37 am >> UPDATE ps_product_lang SET name = 'PASSI DELLA PACE', description = '' WHERE id_product = '21875' 22/11/2023 11:15:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21875' 22/11/2023 11:15:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '497', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21875' 22/11/2023 11:15:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21875' 22/11/2023 11:15:38 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 = '21875' 22/11/2023 11:15:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21876' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:15:38 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 '21876' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21875' 22/11/2023 11:15:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21876' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21875' 22/11/2023 11:16:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825025330' AND id_product != '21876' AND ean13 != '' 22/11/2023 11:16:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788825025330', date_upd = NOW() WHERE id_product = '21876' 22/11/2023 11:16:16 am >> UPDATE ps_product_lang SET name = 'VIA CRUCIS', description = '' WHERE id_product = '21876' 22/11/2023 11:16:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '21876' 22/11/2023 11:16:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21876' 22/11/2023 11:16:16 am >> DELETE FROM ps_specific_price WHERE id_product = '21876' 22/11/2023 11:16: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 = '21876' 22/11/2023 11:16:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21877' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:16: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 '21877' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21876' 22/11/2023 11:16:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21877' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21876' 22/11/2023 11:18:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572083' AND id_product != '21877' AND ean13 != '' 22/11/2023 11:18:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788867572083', date_upd = NOW() WHERE id_product = '21877' 22/11/2023 11:18:44 am >> UPDATE ps_product_lang SET name = 'CALENDARIO D\'AVVENTO', description = '' WHERE id_product = '21877' 22/11/2023 11:18:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '21877' 22/11/2023 11:18:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21877' 22/11/2023 11:18:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21877' 22/11/2023 11:18:44 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 = '21877' 22/11/2023 11:18:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21878' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:18:44 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 '21878' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21877' 22/11/2023 11:18:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21878' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21877' 22/11/2023 11:20:19 am >> UPDATE ps_document SET id_document_type = '33', document_num = '649233', document_date = '2023-11-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '26.14', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '631.07', price_tax_excluded = '631.07', date_upd = NOW() WHERE id_document = '89069' 22/11/2023 11:20: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 = '89069' 22/11/2023 11:20:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89069' 22/11/2023 11:20: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 ( '89069' , '21828' , 'VANGELO DI GESU ' , '1' , '1' , '4' , '3.1000' , '3.1' , '0' , '30' , '2.17' ) 22/11/2023 11:20: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 ( '89069' , '3521' , 'DIO SI È FATTO UOMO - K. RAHNER' , '1' , '1' , '4' , '8.5000' , '8.5' , '0' , '30' , '5.95' ) 22/11/2023 11:20: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 ( '89069' , '21874' , 'BETLEMME OGGO SEI TU - A. COMASTRI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 22/11/2023 11:20: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 ( '89069' , '9338' , 'SACROSANCTUM CONCILIUM' , '2' , '2' , '4' , '2.5000' , '2.5' , '0' , '33' , '3.35' ) 22/11/2023 11:20: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 ( '89069' , '21483' , 'BIBBIA - SCRUTATE - TELATA' , '1' , '1' , '4' , '35.00' , '35' , '0' , '33' , '23.4500' ) 22/11/2023 11:20: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 ( '89069' , '21875' , 'PASSI DELLA PACE' , '2' , '2' , '4' , '5.00' , '5' , '0' , '30' , '7.0000' ) 22/11/2023 11:20: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 ( '89069' , '21876' , 'VIA CRUCIS' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '30' , '3.5000' ) 22/11/2023 11:20: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 ( '89069' , '21805' , 'DIO SI E FATTO CARNE - AAVV' , '1' , '1' , '4' , '28.00' , '28' , '0' , '33' , '18.7600' ) 22/11/2023 11:20: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 ( '89069' , '21798' , 'ENCICLICA DEI BAMBINI - FORTUNATO / CAGNOLI' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 22/11/2023 11:20: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 ( '89069' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 22/11/2023 11:20: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 ( '89069' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 22/11/2023 11:20: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 ( '89069' , '21713' , 'FEDE SPERANZA E CARITA - R. CANTALAMESSA' , '1' , '1' , '4' , '17.00' , '17' , '0' , '33' , '11.3900' ) 22/11/2023 11:20:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 22/11/2023 11:20:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '21877' , 'CALENDARIO DAVVENTO' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 22/11/2023 11:20:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '39' , '39' , '4' , '15.00' , '15' , '0' , '35+7' , '353.6325' ) 22/11/2023 11:20:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '14529' , 'PANE E VINO - SUSSIDIO' , '26' , '26' , '4' , '5.00' , '5' , '0' , '35+7' , '78.5850' ) 22/11/2023 11:20:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89069' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '3' , '3' , '4' , '15.00' , '15' , '0' , '35+7' , '27.2025' ) 22/11/2023 11:22:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572250' AND id_product != '21878' AND ean13 != '' 22/11/2023 11:22:34 am >> UPDATE ps_product SET id_supplier = '', reference = '4/4', ean13 = '9788867572250', date_upd = NOW() WHERE id_product = '21878' 22/11/2023 11:22:34 am >> UPDATE ps_product_lang SET name = 'CRESIMA INSIEME NELLO SPIRITO', description = '' WHERE id_product = '21878' 22/11/2023 11:22:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '21878' 22/11/2023 11:22:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '21878' 22/11/2023 11:22:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21878' 22/11/2023 11: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 = '21878' 22/11/2023 11:22:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21879' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:22:35 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 '21879' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21878' 22/11/2023 11:22:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21879' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21878' 22/11/2023 11:23:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851427641' AND id_product != '21879' AND ean13 != '' 22/11/2023 11:23:55 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788851427641', date_upd = NOW() WHERE id_product = '21879' 22/11/2023 11:23:56 am >> UPDATE ps_product_lang SET name = 'ATTI DEGLI APOSTOLI COMMENTATI DA SEI BIBLISTE', description = '' WHERE id_product = '21879' 22/11/2023 11:23:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '60' WHERE id_product = '21879' 22/11/2023 11:23:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '60', id_tax_rules_group = '4', id_category_default = '98', 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 = '21879' 22/11/2023 11:23:56 am >> DELETE FROM ps_specific_price WHERE id_product = '21879' 22/11/2023 11:23: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 = '21879' 22/11/2023 11:23:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21880' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:23: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 '21880' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21879' 22/11/2023 11:23:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21880' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21879' 22/11/2023 11:25:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457261' AND id_product != '21880' AND ean13 != '' 22/11/2023 11:25:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457261', date_upd = NOW() WHERE id_product = '21880' 22/11/2023 11:25:24 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - FEB 2024', description = '' WHERE id_product = '21880' 22/11/2023 11:25:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '21880' 22/11/2023 11:25:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21880' 22/11/2023 11:25:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21880' 22/11/2023 11:25: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 = '21880' 22/11/2023 11:25:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21881' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:25: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 '21881' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21880' 22/11/2023 11:25:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21881' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21880' 22/11/2023 11:26:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457384' AND id_product != '21881' AND ean13 != '' 22/11/2023 11:26:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457384', date_upd = NOW() WHERE id_product = '21881' 22/11/2023 11:26:15 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - FEB 2024', description = '' WHERE id_product = '21881' 22/11/2023 11:26:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '21881' 22/11/2023 11:26:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21881' 22/11/2023 11:26:15 am >> DELETE FROM ps_specific_price WHERE id_product = '21881' 22/11/2023 11:26:16 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21881' 22/11/2023 11:26:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21882' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:26:16 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21882' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21881' 22/11/2023 11:26:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21882' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21881' 22/11/2023 11:27:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556392' AND id_product != '21882' AND ean13 != '' 22/11/2023 11:27:34 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788831556392', date_upd = NOW() WHERE id_product = '21882' 22/11/2023 11:27:34 am >> UPDATE ps_product_lang SET name = 'DIO DI GESU\' - P. CURTAZ', description = '' WHERE id_product = '21882' 22/11/2023 11:27:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21882' 22/11/2023 11:27:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '27', 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 = '21882' 22/11/2023 11:27:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21882' 22/11/2023 11:27: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 = '21882' 22/11/2023 11:27:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21883' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:27:35 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 '21883' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21882' 22/11/2023 11:27:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21883' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21882' 22/11/2023 11:29:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243439' AND id_product != '21883' AND ean13 != '' 22/11/2023 11:29:32 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788892243439', date_upd = NOW() WHERE id_product = '21883' 22/11/2023 11:29:32 am >> UPDATE ps_product_lang SET name = 'MEMORIA CHE EDUCA AL BENE - SEGRE/DELPINI', description = '' WHERE id_product = '21883' 22/11/2023 11:29:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21883' 22/11/2023 11:29:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '21883' 22/11/2023 11:29:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21883' 22/11/2023 11:29:33 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21883' 22/11/2023 11:29:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21884' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:29:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21884' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21883' 22/11/2023 11:29:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21884' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21883' 22/11/2023 11:30:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243200' AND id_product != '21884' AND ean13 != '' 22/11/2023 11:30:49 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788892243200', date_upd = NOW() WHERE id_product = '21884' 22/11/2023 11:30:49 am >> UPDATE ps_product_lang SET name = 'ASCOLTARLO ERA RIMANERE - ANNO B - E. RONCHI', description = '' WHERE id_product = '21884' 22/11/2023 11:30:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21884' 22/11/2023 11:30:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21884' 22/11/2023 11:30:49 am >> DELETE FROM ps_specific_price WHERE id_product = '21884' 22/11/2023 11:31:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243200' AND id_product != '21884' AND ean13 != '' 22/11/2023 11:31:28 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788892243200', date_upd = NOW() WHERE id_product = '21884' 22/11/2023 11:31:28 am >> UPDATE ps_product_lang SET name = 'ASCOLTARLO ERA RIMANERE - ANNO B - E. RONCHI', description = '' WHERE id_product = '21884' 22/11/2023 11:31:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21884' 22/11/2023 11:31:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21884' 22/11/2023 11:31:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21884' 22/11/2023 11:31:29 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 = '21884' 22/11/2023 11:31:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21885' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:31:29 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 '21885' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21884' 22/11/2023 11:31:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21885' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21884' 22/11/2023 11:32:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240124' AND id_product != '21885' AND ean13 != '' 22/11/2023 11:32:06 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892240124', date_upd = NOW() WHERE id_product = '21885' 22/11/2023 11:32:06 am >> UPDATE ps_product_lang SET name = 'FARE DEL CRISTIANO - C.M. MARTINI', description = '' WHERE id_product = '21885' 22/11/2023 11:32:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21885' 22/11/2023 11:32:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '21885' 22/11/2023 11:32:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21885' 22/11/2023 11:32:07 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 = '21885' 22/11/2023 11:32:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21886' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:32: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 '21886' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21885' 22/11/2023 11:32:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21886' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21885' 22/11/2023 11:32:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240155' AND id_product != '21886' AND ean13 != '' 22/11/2023 11:32:36 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892240155', date_upd = NOW() WHERE id_product = '21886' 22/11/2023 11:32:36 am >> UPDATE ps_product_lang SET name = 'PER UNA NUOVA PRIMAVERA - C.M. MARTINI', description = '' WHERE id_product = '21886' 22/11/2023 11:32:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21886' 22/11/2023 11:32:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '21886' 22/11/2023 11:32:36 am >> DELETE FROM ps_specific_price WHERE id_product = '21886' 22/11/2023 11:32:37 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 = '21886' 22/11/2023 11:32:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21887' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:32:37 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 '21887' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21886' 22/11/2023 11:32:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21887' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21886' 22/11/2023 11:33:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240148' AND id_product != '21887' AND ean13 != '' 22/11/2023 11:33:03 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892240148', date_upd = NOW() WHERE id_product = '21887' 22/11/2023 11:33:03 am >> UPDATE ps_product_lang SET name = 'PAROLE SULLA CHIESA - C.M. MARTINI', description = '' WHERE id_product = '21887' 22/11/2023 11:33:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21887' 22/11/2023 11:33:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '21887' 22/11/2023 11:33:03 am >> DELETE FROM ps_specific_price WHERE id_product = '21887' 22/11/2023 11:33:04 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 = '21887' 22/11/2023 11:33:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21888' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:33:04 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 '21888' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21887' 22/11/2023 11:33:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21888' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21887' 22/11/2023 11:33:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240131' AND id_product != '21888' AND ean13 != '' 22/11/2023 11:33:27 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892240131', date_upd = NOW() WHERE id_product = '21888' 22/11/2023 11:33:27 am >> UPDATE ps_product_lang SET name = 'FARE DELLA CHIESA - C.M. MARTINI', description = '' WHERE id_product = '21888' 22/11/2023 11:33:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21888' 22/11/2023 11:33:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '21888' 22/11/2023 11:33:27 am >> DELETE FROM ps_specific_price WHERE id_product = '21888' 22/11/2023 11:33: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 = '21888' 22/11/2023 11:33:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21889' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:33: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 '21889' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21888' 22/11/2023 11:33:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21889' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21888' 22/11/2023 11:35:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851427610' AND id_product != '21889' AND ean13 != '' 22/11/2023 11:35:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788851427610', date_upd = NOW() WHERE id_product = '21889' 22/11/2023 11:35:07 am >> UPDATE ps_product_lang SET name = 'UN\'ATTESA SORPRENDENTE - G. GIANOLA', description = '' WHERE id_product = '21889' 22/11/2023 11:35:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21889' 22/11/2023 11:35:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21889' 22/11/2023 11:35:07 am >> DELETE FROM ps_specific_price WHERE id_product = '21889' 22/11/2023 11:35:11 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 = '21889' 22/11/2023 11:35:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21890' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:35:11 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 '21890' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21889' 22/11/2023 11:35:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21890' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21889' 22/11/2023 11:36:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851427825' AND id_product != '21890' AND ean13 != '' 22/11/2023 11:36:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788851427825', date_upd = NOW() WHERE id_product = '21890' 22/11/2023 11:36:11 am >> UPDATE ps_product_lang SET name = 'NATALE CON IL PICCOLO PRINCIPE', description = '' WHERE id_product = '21890' 22/11/2023 11:36:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '21890' 22/11/2023 11:36:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '98', 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 = '21890' 22/11/2023 11:36:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21890' 22/11/2023 11:36:12 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 = '21890' 22/11/2023 11:36:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21891' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:36:12 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 '21891' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21890' 22/11/2023 11:36:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21891' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21890' 22/11/2023 11:37:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278966' AND id_product != '21891' AND ean13 != '' 22/11/2023 11:37:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831278966', date_upd = NOW() WHERE id_product = '21891' 22/11/2023 11:37:30 am >> UPDATE ps_product_lang SET name = 'HO AVUTO PAURA ', description = '' WHERE id_product = '21891' 22/11/2023 11:37:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '21891' 22/11/2023 11:37:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '97', 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 = '21891' 22/11/2023 11:37:30 am >> DELETE FROM ps_specific_price WHERE id_product = '21891' 22/11/2023 11:37:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21891' 22/11/2023 11:37:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21892' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:37:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21892' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21891' 22/11/2023 11:37:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21892' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21891' 22/11/2023 11:40:10 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 22/11/2023 11:40:10 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '527' , '1' ) 22/11/2023 11:40:10 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '527' , '2' ) 22/11/2023 11:40:10 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '527' , '3' ) 22/11/2023 11:40:10 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '527' , '1' , 'FRAMMENTI DI LUCE ED.' , LOWER('FRAMMENTI-DI-LUCE-ED.') ) 22/11/2023 11:40:10 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '527' , '1' , '0' ) 22/11/2023 11:40:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788894762600' AND id_product != '21892' AND ean13 != '' 22/11/2023 11:40:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788894762600', date_upd = NOW() WHERE id_product = '21892' 22/11/2023 11:40:18 am >> UPDATE ps_product_lang SET name = 'MANGIATOIA GREMBO DELL\'AMORE DI DIO - P. STANCARI', description = '' WHERE id_product = '21892' 22/11/2023 11:40:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5' WHERE id_product = '21892' 22/11/2023 11:40:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5', id_tax_rules_group = '4', id_category_default = '527', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21892' 22/11/2023 11:40:18 am >> DELETE FROM ps_specific_price WHERE id_product = '21892' 22/11/2023 11:40:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '648765' , '2023-11-15' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.59' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.34' , '158.34' , NOW() , NOW() ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89071' 22/11/2023 11:40:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89071' 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21878' , 'CRESIMA INSIEME NELLO SPIRITO' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21878' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21878' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21879' , 'ATTI DEGLI APOSTOLI COMMENTATI DA SEI BIBLISTE' , '1' , '1' , '4' , '60.00' , '60' , '0' , '33' , '40.2000' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21879' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21879' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21880' , 'PAROLA E PREGHIERA - FEB 2024' , '4' , '4' , '4' , '2.90' , '2.9' , '0' , '33' , '7.7720' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21880' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21880' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21881' , 'INSIEME NELLA MESSA - FEB 2024' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21881' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21881' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21882' , 'DIO DI GESU - P. CURTAZ' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21882' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21882' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21883' , 'MEMORIA CHE EDUCA AL BENE - SEGRE/DELPINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21883' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21883' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21884' , 'ASCOLTARLO ERA RIMANERE - ANNO B - E. RONCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21884' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21884' , '7' , '1' ) 22/11/2023 11:40:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21885' , 'FARE DEL CRISTIANO - C.M. MARTINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 22/11/2023 11:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21885' AND id_supplier = '7' 22/11/2023 11:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21885' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21887' , 'PAROLE SULLA CHIESA - C.M. MARTINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21887' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21887' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21886' , 'PER UNA NUOVA PRIMAVERA - C.M. MARTINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21886' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21886' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21888' , 'FARE DELLA CHIESA - C.M. MARTINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21888' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21888' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21889' , 'UNATTESA SORPRENDENTE - G. GIANOLA' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33' , '8.7100' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21889' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21889' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21890' , 'NATALE CON IL PICCOLO PRINCIPE' , '2' , '2' , '4' , '4.00' , '4' , '0' , '33' , '5.3600' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21890' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21890' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21891' , 'HO AVUTO PAURA ' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '30' , '6.6500' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21891' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21891' , '7' , '1' ) 22/11/2023 11:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89071' , '21892' , 'MANGIATOIA GREMBO DELLAMORE DI DIO - P. STANCARI' , '3' , '3' , '4' , '6.50' , '6.5' , '0' , '35' , '12.6750' ) 22/11/2023 11:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21892' AND id_supplier = '7' 22/11/2023 11:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21892' , '7' , '1' ) 22/11/2023 11:40:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788894762600' AND id_product != '21892' AND ean13 != '' 22/11/2023 11:40:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788894762600', date_upd = NOW() WHERE id_product = '21892' 22/11/2023 11:40:59 am >> UPDATE ps_product_lang SET name = 'MANGIATOIA GREMBO DELL\'AMORE DI DIO - P. STANCARI', description = '' WHERE id_product = '21892' 22/11/2023 11:40:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5' WHERE id_product = '21892' 22/11/2023 11:40:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5', id_tax_rules_group = '4', id_category_default = '527', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21892' 22/11/2023 11:40:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21892' 22/11/2023 11:41:00 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 = '21892' 22/11/2023 11:41:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21893' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:41:00 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 '21893' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21892' 22/11/2023 11:41:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21893' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21892' 22/11/2023 11:41:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278966' AND id_product != '21891' AND ean13 != '' 22/11/2023 11:41:17 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/7', ean13 = '9788831278966', date_upd = NOW() WHERE id_product = '21891' 22/11/2023 11:41:17 am >> UPDATE ps_product_lang SET name = 'HO AVUTO PAURA ', description = '' WHERE id_product = '21891' 22/11/2023 11:41:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5000' WHERE id_product = '21891' 22/11/2023 11:41:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5000', id_tax_rules_group = '4', id_category_default = '97', 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 = '21891' 22/11/2023 11:41:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21891' 22/11/2023 11:41: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 = '21891' 22/11/2023 11:41:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21894' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 11:41: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 '21894' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21891' 22/11/2023 11:41:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21894' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21891' 22/11/2023 11:41:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278966' AND id_product != '21891' AND ean13 != '' 22/11/2023 11:41:35 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/7', ean13 = '9788831278966', date_upd = NOW() WHERE id_product = '21891' 22/11/2023 11:41:35 am >> UPDATE ps_product_lang SET name = 'HO AVUTO PAURA ', description = '' WHERE id_product = '21891' 22/11/2023 11:41:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5000' WHERE id_product = '21891' 22/11/2023 11:41:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5000', id_tax_rules_group = '4', id_category_default = '97', 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 = '21891' 22/11/2023 11:41:36 am >> DELETE FROM ps_specific_price WHERE id_product = '21891' 22/11/2023 11:44:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572250' AND id_product != '21878' AND ean13 != '' 22/11/2023 11:44:11 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/4', ean13 = '9788867572250', date_upd = NOW() WHERE id_product = '21878' 22/11/2023 11:44:11 am >> UPDATE ps_product_lang SET name = 'CRESIMA INSIEME NELLO SPIRITO', description = '' WHERE id_product = '21878' 22/11/2023 11:44:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9000' WHERE id_product = '21878' 22/11/2023 11:44:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21878' 22/11/2023 11:44:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21878' 22/11/2023 11:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 11:46:18 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' , '3683' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.68' , '42.88' , NOW() , NOW() ) 22/11/2023 11:46:18 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 = '89072' 22/11/2023 11:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89072' 22/11/2023 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89072' , '21830' , 'GESU VIA ALLA LIBERTA - A. GRUN' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 22/11/2023 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89072' , '21831' , 'GUIDA PER LAVVENTO - A. GRUN' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 22/11/2023 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89072' , '3521' , 'DIO SI È FATTO UOMO - K. RAHNER' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 22/11/2023 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89072' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/11/2023 11:48:34 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 22/11/2023 11:48:34 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '142.70', price_tax_excluded = '142.70', date_upd = NOW() WHERE id_document = '81317' 22/11/2023 11:48:34 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 = '81317' 22/11/2023 11:48:34 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 22/11/2023 11:48: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 ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 11:48: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 ( '81317' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 11:48: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 ( '81317' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 22/11/2023 11:48: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 ( '81317' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 22/11/2023 11:48: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 ( '81317' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 22/11/2023 11:48: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 ( '81317' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 22/11/2023 11:48: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 ( '81317' , '21630' , 'PAROLE E PREGHIERA DIC 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/11/2023 11:48: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 ( '81317' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 22/11/2023 11:48: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 ( '81317' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 11:48: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 ( '81317' , '21783' , 'NATALE DEL CUORE - A.M. CANOPI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 22/11/2023 11:48: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 ( '81317' , '21752' , 'PAROLA E PREGHIERA - GEN 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/11/2023 11:48: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 ( '81317' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/11/2023 11:48: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 ( '81317' , '21810' , 'AMEN - FEB 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/11/2023 11:48: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 ( '81317' , '21809' , 'AMEN - GEN 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/11/2023 11:48: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 ( '81317' , '21882' , 'DIO DI GESU - P. CURTAZ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 11:48: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 ( '81317' , '21880' , 'PAROLA E PREGHIERA - FEB 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 22/11/2023 11:49:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 11: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' , '3684' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.80' , '32.80' , NOW() , NOW() ) 22/11/2023 11: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 = '89073' 22/11/2023 11:49:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89073' 22/11/2023 11: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 ( '89073' , '21515' , 'CINQUE PANI DORZO 2024' , '5' , '-5' , '4' , '6.90' , '6.9' , '0' , '5' , '32.80' ) 22/11/2023 11:53:11 am >> SELECT document_num FROM ps_document WHERE document_num = '133/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 11:53:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '133/A' , '2023-11-22' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , 'ACCONTO € 50,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '68.85' , NOW() , NOW() ) 22/11/2023 11:53:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89074' 22/11/2023 11:53:11 am >> DELETE FROM ps_document_detail WHERE id_document = '89074' 22/11/2023 11:53:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89074' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '16.00' ) 22/11/2023 11:53:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89074' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 22/11/2023 12:13:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 22/11/2023 12:13:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23 + 40,00 22/11', 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 = '990.00', price_tax_excluded = '811.48', date_upd = NOW() WHERE id_document = '82607' 22/11/2023 12:13:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82607' 22/11/2023 12:13:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82607' 22/11/2023 12:13: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 ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 22/11/2023 12:13: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 ( '82607' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '550.0000' , '450.81967213115' , '22' , '0' , '550.00' ) 22/11/2023 12:13: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 ( '82607' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 22/11/2023 12:22:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 12:22:20 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' , '3685' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.00' , '156.72' , NOW() , NOW() ) 22/11/2023 12:22:20 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 = '89075' 22/11/2023 12:22:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89075' 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '1' , '-1' , '4' , '1' , '1' , '0' , '5' , '0.95' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '21196' , 'CALENDARIO LITURGICO 2024' , '10' , '-10' , '4' , '0.50' , '0.5' , '0' , '5' , '4.80' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '21892' , 'MANGIATOIA GREMBO DELLAMORE DI DIO - P. STANCARI' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '21805' , 'DIO SI E FATTO CARNE - AAVV' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '19150' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7' , '5.7377049180328' , '22' , '0' , '56.00' ) 22/11/2023 12:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89075' , '21801' , 'CORDONIERA ORO' , '1' , '-1' , '1' , '44.07' , '36.122950819672' , '22' , '0' , '44.07' ) 22/11/2023 12:40:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 12:40:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3686' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 22/11/2023 12:40:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89076' 22/11/2023 12:40:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89076' 22/11/2023 12:40:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89076' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 22/11/2023 02:15:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788876023880' AND id_product != '21894' AND ean13 != '' 22/11/2023 02:15:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788876023880', date_upd = NOW() WHERE id_product = '21894' 22/11/2023 02:15:30 pm >> UPDATE ps_product_lang SET name = 'bene-dici o taci - e. antenucci', description = '' WHERE id_product = '21894' 22/11/2023 02:15:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21894' 22/11/2023 02:15:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '199', 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 = '21894' 22/11/2023 02:15:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21894' 22/11/2023 02:15:30 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 = '21894' 22/11/2023 02:15:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21895' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 02:15:31 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 '21895' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21894' 22/11/2023 02:15:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21895' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21894' 22/11/2023 02:16:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788871988207' AND id_product != '21895' AND ean13 != '' 22/11/2023 02:16:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788871988207', date_upd = NOW() WHERE id_product = '21895' 22/11/2023 02:16:32 pm >> UPDATE ps_product_lang SET name = 'medjugorje e\' la speranza - padre livio', description = '' WHERE id_product = '21895' 22/11/2023 02:16:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21895' 22/11/2023 02:16:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '159', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21895' 22/11/2023 02:16:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21895' 22/11/2023 02:16:33 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 = '21895' 22/11/2023 02:16:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21896' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 02:16:33 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 '21896' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21895' 22/11/2023 02:16:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21896' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21895' 22/11/2023 02:16:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788871988207' AND id_product != '21895' AND ean13 != '' 22/11/2023 02:16:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788871988207', date_upd = NOW() WHERE id_product = '21895' 22/11/2023 02:16:54 pm >> UPDATE ps_product_lang SET name = 'MEDJUGORJE E\' LA SPERANZA - PADRE LIVIO', description = '' WHERE id_product = '21895' 22/11/2023 02:16:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '21895' 22/11/2023 02:16:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', id_tax_rules_group = '4', id_category_default = '159', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21895' 22/11/2023 02:16:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '21895' 22/11/2023 02:17:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788876023880' AND id_product != '21894' AND ean13 != '' 22/11/2023 02:17:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788876023880', date_upd = NOW() WHERE id_product = '21894' 22/11/2023 02:17:12 pm >> UPDATE ps_product_lang SET name = 'BENE-DICI O TACI - E. ANTENUCCI', description = '' WHERE id_product = '21894' 22/11/2023 02:17:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.0000' WHERE id_product = '21894' 22/11/2023 02:17:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '199', 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 = '21894' 22/11/2023 02:17:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '21894' 22/11/2023 02:18:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893183994' AND id_product != '21896' AND ean13 != '' 22/11/2023 02:18:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788893183994', date_upd = NOW() WHERE id_product = '21896' 22/11/2023 02:18:03 pm >> UPDATE ps_product_lang SET name = '365 GIORNI CON L. PICCARETA', description = '' WHERE id_product = '21896' 22/11/2023 02:18:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21896' 22/11/2023 02:18:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '47', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21896' 22/11/2023 02:18:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '21896' 22/11/2023 02:18:04 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 = '21896' 22/11/2023 02:18:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21897' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 02:18:04 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 '21897' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21896' 22/11/2023 02:18:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21897' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21896' 22/11/2023 02:19:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817184724' AND id_product != '21897' AND ean13 != '' 22/11/2023 02:19:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788817184724', date_upd = NOW() WHERE id_product = '21897' 22/11/2023 02:19:30 pm >> UPDATE ps_product_lang SET name = 'OGNUNO FA IL FUOCO CON LA LEGNA CHE HA - M. POZZA', description = '' WHERE id_product = '21897' 22/11/2023 02:19:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '21897' 22/11/2023 02:19:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '113', 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 = '21897' 22/11/2023 02:19:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21897' 22/11/2023 02:19:31 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 = '21897' 22/11/2023 02:19:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21898' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 02:19:31 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 '21898' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21897' 22/11/2023 02:19:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21898' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21897' 22/11/2023 02:20:49 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 22/11/2023 02:20:49 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '528' , '1' ) 22/11/2023 02:20:49 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '528' , '2' ) 22/11/2023 02:20:49 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '528' , '3' ) 22/11/2023 02:20:49 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '528' , '1' , 'EDIZIONI LA SCALA' , LOWER('EDIZIONI-LA-SCALA') ) 22/11/2023 02:20:49 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '528' , '1' , '0' ) 22/11/2023 02:20:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788896688359' AND id_product != '21898' AND ean13 != '' 22/11/2023 02:20:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788896688359', date_upd = NOW() WHERE id_product = '21898' 22/11/2023 02:20:56 pm >> UPDATE ps_product_lang SET name = 'CATESMO DEL CURATO D\'ARS', description = '' WHERE id_product = '21898' 22/11/2023 02:20:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.5' WHERE id_product = '21898' 22/11/2023 02:20:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.5', id_tax_rules_group = '4', id_category_default = '528', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21898' 22/11/2023 02:20:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '21898' 22/11/2023 02:20:56 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 = '21898' 22/11/2023 02:20:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21899' , '1' , '' , 'nuovo-prodotto' ) 22/11/2023 02:20:56 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 '21899' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21898' 22/11/2023 02:20:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21899' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21898' 22/11/2023 02:21:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '5526' , '2023-11-20' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.13' , '68.13' , NOW() , NOW() ) 22/11/2023 02:21:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89077' 22/11/2023 02:21:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89077' 22/11/2023 02:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89077' , '21894' , 'BENE-DICI O TACI - E. ANTENUCCI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 22/11/2023 02:21:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21894' AND id_supplier = '47' 22/11/2023 02:21:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21894' , '47' , '1' ) 22/11/2023 02:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89077' , '21895' , 'MEDJUGORJE E LA SPERANZA - PADRE LIVIO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '27' , '11.6800' ) 22/11/2023 02:21:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21895' AND id_supplier = '47' 22/11/2023 02:21:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21895' , '47' , '1' ) 22/11/2023 02:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89077' , '21896' , '365 GIORNI CON L. PICCARETA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 22/11/2023 02:21:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21896' AND id_supplier = '47' 22/11/2023 02:21:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21896' , '47' , '1' ) 22/11/2023 02:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89077' , '21897' , 'OGNUNO FA IL FUOCO CON LA LEGNA CHE HA - M. POZZA' , '2' , '2' , '4' , '17.00' , '17' , '0' , '30' , '23.8000' ) 22/11/2023 02:21:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21897' AND id_supplier = '47' 22/11/2023 02:21:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21897' , '47' , '1' ) 22/11/2023 02:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89077' , '21898' , 'CATESMO DEL CURATO DARS' , '1' , '1' , '4' , '14.50' , '14.5' , '0' , '30' , '10.1500' ) 22/11/2023 02:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21898' AND id_supplier = '47' 22/11/2023 02:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21898' , '47' , '1' ) 22/11/2023 02:24:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '282' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 02:24:00 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' , '282' , '2023-11-22' , '' , '2755' , '0' , '4677545' , 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '56.71' , '56.71' , NOW() , NOW() ) 22/11/2023 02:24:00 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 = '89078' 22/11/2023 02:24:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89078' 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21836' , 'DONO PER TUTTI' , '1' , '-1' , '4' , '2.70' , '2.7' , '0' , '5' , '2.57' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21663' , 'CORAGGIO DI UNA DONNA ' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21875' , 'PASSI DELLA PACE' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21876' , 'VIA CRUCIS' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21845' , 'VIENI SIGNORE GESU!' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21833' , '5 CIOTTOLI DI DAVIDE ' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 22/11/2023 02:24:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '25' , '-25' , '0' , '0.25' , '0.25' , '' , '0' , '6.25' ) 22/11/2023 03:11:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002053' AND id_product != '20169' AND ean13 != '' 22/11/2023 03:11:07 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002053', date_upd = NOW() WHERE id_product = '20169' 22/11/2023 03:11:07 pm >> UPDATE ps_product_lang SET name = 'croce corpo resina 30x21 - 671/3', description = '' WHERE id_product = '20169' 22/11/2023 03:11:07 pm >> UPDATE ps_product SET wholesale_price = '6.55', on_sale = '0', price = '14.754098360655737' WHERE id_product = '20169' 22/11/2023 03:11:07 pm >> UPDATE ps_product_shop SET wholesale_price = '6.55', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '154', 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 = '20169' 22/11/2023 03:11:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '20169' 22/11/2023 03:25:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 03:25:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '134/A' , '2023-11-22' , 'A' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '620.40' , '620.40' , NOW() , NOW() ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89079' 22/11/2023 03:25:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20002' , 'GESU BAMBINO DORATO CM 20 - BJ146-20D' , '1' , '-1' , '0' , '21.00' , '21' , '' , '0' , '21.00' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.50' , '19.5' , '' , '0' , '19.50' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '0' , '34.00' , '34' , '' , '0' , '34.00' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '2' , '-2' , '0' , '18.00' , '18' , '' , '0' , '36.00' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '0' , '13.50' , '13.5' , '' , '0' , '13.50' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.00' , '12' , '' , '0' , '12.00' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.00' , '12' , '' , '0' , '12.00' ) 22/11/2023 03:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '2' , '-2' , '0' , '12.90' , '12.9' , '' , '0' , '25.80' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.00' , '7' , '' , '0' , '21.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.00' , '6' , '' , '0' , '18.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16508' , 'ANGELO BIANCO IN RESINA CAMPANA - 4218' , '2' , '-2' , '0' , '6.00' , '6' , '' , '0' , '12.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '' , 'ANGELO' , '2' , '-2' , '0' , '9' , '9' , '' , '0' , '18.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '2' , '-2' , '0' , '9.00' , '9' , '' , '0' , '18.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '2' , '-2' , '0' , '9.00' , '9' , '' , '0' , '18.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '15591' , 'ANGELO CON CAMPANA ARG. - 4216' , '1' , '-1' , '0' , '9.50' , '9.5' , '' , '0' , '9.50' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.50' , '11.5' , '' , '0' , '11.50' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.00' , '13' , '' , '0' , '13.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '4' , '-4' , '0' , '6.00' , '6' , '' , '0' , '24.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '2' , '-2' , '0' , '4.80' , '4.8' , '' , '0' , '9.60' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20169' , 'croce corpo resina 30x21 - 671/3' , '1' , '-1' , '0' , '18.00' , '18' , '' , '0' , '18.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '0' , '12.00' , '12' , '' , '0' , '12.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.00' , '16' , '' , '0' , '16.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20168' , 'croce corpo resina 22x15 - 671/2' , '1' , '-1' , '0' , '14.00' , '14' , '' , '0' , '14.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.00' , '22' , '' , '0' , '22.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.00' , '28' , '' , '0' , '28.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '2' , '-2' , '0' , '10.00' , '10' , '' , '0' , '20.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '' , 'QUADRO NUVOLA - QUADRI E QUADRI - € 15,00 CAD****' , '3' , '-3' , '0' , '20' , '20' , '' , '0' , '60.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.00' , '19' , '' , '0' , '19.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.00' , '9' , '' , '0' , '9.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.00' , '9' , '' , '0' , '9.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13112' , 'SACRO CUORE BABY- 023 SH 9 BB' , '1' , '-1' , '0' , '9.00' , '9' , '' , '0' , '9.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '0' , '10.00' , '10' , '' , '0' , '10.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.00' , '9' , '' , '0' , '9.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.00' , '9' , '' , '0' , '9.00' ) 22/11/2023 03:25:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.00' , '10' , '' , '0' , '10.00' ) 22/11/2023 03:31:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '89079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 03:31:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE', 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 = '779.40', price_tax_excluded = '779.40', date_upd = NOW() WHERE id_document = '89079' 22/11/2023 03:31: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 = '89079' 22/11/2023 03:31:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 22/11/2023 03:31: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 ( '89079' , '20002' , 'GESU BAMBINO DORATO CM 20 - BJ146-20D' , '1' , '-1' , '0' , '21.0000' , '21' , '0' , '0' , '21.00' ) 22/11/2023 03:31: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 ( '89079' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 22/11/2023 03:31: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 ( '89079' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '0' , '34.0000' , '34' , '0' , '0' , '34.00' ) 22/11/2023 03:31: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 ( '89079' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '2' , '-2' , '0' , '18.0000' , '18' , '0' , '0' , '36.00' ) 22/11/2023 03:31: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 ( '89079' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '0' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 22/11/2023 03:31: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 ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:31: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 ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:31: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 ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '2' , '-2' , '0' , '12.9000' , '12.9' , '0' , '0' , '25.80' ) 22/11/2023 03:31: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 ( '89079' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 22/11/2023 03:31: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 ( '89079' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 22/11/2023 03:31: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 ( '89079' , '16508' , 'ANGELO BIANCO IN RESINA CAMPANA - 4218' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 22/11/2023 03:31: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 ( '89079' , '0' , 'ANGELO' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 22/11/2023 03:31: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 ( '89079' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 22/11/2023 03:31: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 ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 22/11/2023 03:31: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 ( '89079' , '15591' , 'ANGELO CON CAMPANA ARG. - 4216' , '1' , '-1' , '0' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 22/11/2023 03:31: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 ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 22/11/2023 03:31: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 ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 22/11/2023 03:31: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 ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '4' , '-4' , '0' , '6.0000' , '6' , '0' , '0' , '24.00' ) 22/11/2023 03:31: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 ( '89079' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '2' , '-2' , '0' , '4.8000' , '4.8' , '0' , '0' , '9.60' ) 22/11/2023 03:31: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 ( '89079' , '20169' , 'croce corpo resina 30x21 - 671/3' , '1' , '-1' , '0' , '18.0000' , '18' , '0' , '0' , '18.00' ) 22/11/2023 03:31: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 ( '89079' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:31: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 ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:31: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 ( '89079' , '20168' , 'croce corpo resina 22x15 - 671/2' , '1' , '-1' , '0' , '14.0000' , '14' , '0' , '0' , '14.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.0000' , '28' , '0' , '0' , '28.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'QUADRO NUVOLA - QUADRI E QUADRI - € 15,00 CAD****' , '3' , '-3' , '0' , '20.0000' , '20' , '0' , '0' , '60.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13112' , 'SACRO CUORE BABY- 023 SH 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '0' , '1.50' , '1.5' , '' , '0' , '3.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '0' , '2.00' , '2' , '' , '0' , '4.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18223' , 'CORONA MISSIONARIA - R102' , '5' , '-5' , '0' , '1.00' , '1' , '' , '0' , '5.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '0' , '12.50' , '12.5' , '' , '0' , '25.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '0' , '5.00' , '5' , '' , '0' , '10.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '3' , '-3' , '0' , '4.00' , '4' , '' , '0' , '12.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '4' , '-4' , '0' , '3.00' , '3' , '' , '0' , '12.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '0' , '38.00' , '38' , '' , '0' , '38.00' ) 22/11/2023 03:31:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50' , '50' , '' , '0' , '50.00' ) 22/11/2023 03:34:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 03:34:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '135/A' , '2023-11-22' , 'A' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , 'LIBRI ' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.00' , '165.00' , NOW() , NOW() ) 22/11/2023 03:34:07 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 = '89080' 22/11/2023 03:34:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89080' 22/11/2023 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 22/11/2023 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:47:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '89080' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 03:47:38 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '135/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI - SCONTO 10%', 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 = '659.60', price_tax_excluded = '659.60', date_upd = NOW() WHERE id_document = '89080' 22/11/2023 03:47:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89080' 22/11/2023 03:47:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89080' 22/11/2023 03:47: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 ( '89080' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:47: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 ( '89080' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 22/11/2023 03:47: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 ( '89080' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:47: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 ( '89080' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:47: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 ( '89080' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:47: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 ( '89080' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:47: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 ( '89080' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:47: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 ( '89080' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:47: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 ( '89080' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:47: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 ( '89080' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:47: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 ( '89080' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.90' , '11.9' , '0' , '0' , '11.90' ) 22/11/2023 03:47: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 ( '89080' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:47: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 ( '89080' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 22/11/2023 03:47: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 ( '89080' , '18732' , 'CREA IL TUO POPUP CON BABBO NATALE' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 03:47: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 ( '89080' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 03:47: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 ( '89080' , '21661' , 'MIO NATALE DA SCOPRIRE' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '0' , '14.90' ) 22/11/2023 03:47: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 ( '89080' , '21877' , 'CALENDARIO DAVVENTO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 22/11/2023 03:47: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 ( '89080' , '21818' , 'GIOCHIAMO CON IL PRESEPE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 22/11/2023 03:47: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 ( '89080' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:47: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 ( '89080' , '21204' , 'MIO GRANDE LIBRO DA COLORARE - FAVOLOSO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:47: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 ( '89080' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '0' , '10.90' ) 22/11/2023 03:47: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 ( '89080' , '17511' , 'BIBBIA DEI RAGAZZI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 22/11/2023 03:47: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 ( '89080' , '18783' , 'MIA BIBBIA PREFERITA ' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:47: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 ( '89080' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:47: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 ( '89080' , '16185' , 'DON BOSCO UN SACERDOTE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 22/11/2023 03:47: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 ( '89080' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 22/11/2023 03:47: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 ( '89080' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 22/11/2023 03:47: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 ( '89080' , '14662' , 'GRANDE LIBRO DEI NONNI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 22/11/2023 03:47: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 ( '89080' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:47: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 ( '89080' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:47: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 ( '89080' , '16442' , 'CARLO ACUTIS LAMICO DI GESU - 8865' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 22/11/2023 03:47: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 ( '89080' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 22/11/2023 03:47: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 ( '89080' , '15431' , 'INSEGNAMI A PREGARE' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 22/11/2023 03:47: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 ( '89080' , '17431' , 'DON BOSCO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 22/11/2023 03:47: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 ( '89080' , '19831' , 'GENERALE DALLA CHIESA - C. VIRZI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:47: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 ( '89080' , '17430' , 'MADRE TERESA - LANGELO DEI POVERI' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 22/11/2023 03:47: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 ( '89080' , '17429' , 'DON MILANI - UNA VITA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:47: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 ( '89080' , '17428' , 'BADEN- POWELL - UN GENERALE TRA GLI SCOUT' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:47: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 ( '89080' , '18742' , 'VIAGGIO DEI TRE RE - B. MASINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 22/11/2023 03:47: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 ( '89080' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:47: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 ( '89080' , '21571' , 'BETLEHEM' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 22/11/2023 03:47: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 ( '89080' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 22/11/2023 03:47: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 ( '89080' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 03:47: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 ( '89080' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 22/11/2023 03:47: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 ( '89080' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '0' , '42.00' ) 22/11/2023 03:49:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '89080' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 03:49:41 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '135/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI - SCONTO 10%', 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 = '666.50', price_tax_excluded = '666.50', date_upd = NOW() WHERE id_document = '89080' 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89080' 22/11/2023 03:49:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89080' 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '0' , '11.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18732' , 'CREA IL TUO POPUP CON BABBO NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21661' , 'MIO NATALE DA SCOPRIRE' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21877' , 'CALENDARIO DAVVENTO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21818' , 'GIOCHIAMO CON IL PRESEPE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21204' , 'MIO GRANDE LIBRO DA COLORARE - FAVOLOSO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '1' , '-1' , '4' , '10.9000' , '10.9' , '0' , '0' , '10.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17511' , 'BIBBIA DEI RAGAZZI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18783' , 'MIA BIBBIA PREFERITA ' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16185' , 'DON BOSCO UN SACERDOTE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14662' , 'GRANDE LIBRO DEI NONNI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16442' , 'CARLO ACUTIS LAMICO DI GESU - 8865' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15431' , 'INSEGNAMI A PREGARE' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 22/11/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17431' , 'DON BOSCO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 22/11/2023 03:49: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 ( '89080' , '19831' , 'GENERALE DALLA CHIESA - C. VIRZI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 22/11/2023 03:49: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 ( '89080' , '17430' , 'MADRE TERESA - LANGELO DEI POVERI' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 22/11/2023 03:49: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 ( '89080' , '17429' , 'DON MILANI - UNA VITA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:49: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 ( '89080' , '17428' , 'BADEN- POWELL - UN GENERALE TRA GLI SCOUT' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 22/11/2023 03:49: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 ( '89080' , '18742' , 'VIAGGIO DEI TRE RE - B. MASINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 22/11/2023 03:49: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 ( '89080' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/11/2023 03:49: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 ( '89080' , '21571' , 'BETLEHEM' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 22/11/2023 03:49: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 ( '89080' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 22/11/2023 03:49: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 ( '89080' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 22/11/2023 03:49: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 ( '89080' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 22/11/2023 03:49: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 ( '89080' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '0' , '42.00' ) 22/11/2023 03:49: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 ( '89080' , '21515' , 'CINQUE PANI D\'ORZO 2024' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 22/11/2023 03:51:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 03:51:25 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' , '3687' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 22/11/2023 03:51:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89081' 22/11/2023 03:51:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '89081' 22/11/2023 03:51:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89081' , '616' , 'ANGELI IL BENE VINCE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 22/11/2023 03:51:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89081' , '20196' , 'VANGELO E ATTI DEGLI APOSTOLI A CARATTERI GRANDI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 22/11/2023 04:02:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736246' AND id_product != '21899' AND ean13 != '' 22/11/2023 04:02:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/2', ean13 = '9791280736246', date_upd = NOW() WHERE id_product = '21899' 22/11/2023 04:02:48 pm >> UPDATE ps_product_lang SET name = 'SACRA BIBBIA cei/uelci ', description = '

La Sacra Bibbia CEI UELCI è l’edizione italiana della Sacra Bibbia, condotta sui testi originali, e approvata dalla Presidenza della Conferenza Episcopale Italiana. È coerente con i testi biblici per l’uso liturgico, approvati dalla Assemblea Generale dei Vescovi. Particolare attenzione è stata riservata alla corrispondenza dei testi sinottici, alla varietà degli stili e dei generi letterari nei diversi libri della Scrittura. Sono state scelte modalità espressive di immediata comprensione e comunicative in rapporto al contesto culturale odierno.

' WHERE id_product = '21899' 22/11/2023 04:02:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.5' WHERE id_product = '21899' 22/11/2023 04:02:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.5', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '170', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21899' 22/11/2023 04:02:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21899' 22/11/2023 04:02:48 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '21899' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 22/11/2023 04:03:11 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '9253' 22/11/2023 04:05:14 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '21899' 22/11/2023 04:11:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3688' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 04:11:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3688' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '7.20' , NOW() , NOW() ) 22/11/2023 04:11:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89082' 22/11/2023 04:11:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89082' 22/11/2023 04:11:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89082' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.2' , '7.2' , '0' , '0' , '7.20' ) 22/11/2023 04:13:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 04:13:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '49' , '2023-11-22' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2438.50' , '2438.50' , NOW() , NOW() ) 22/11/2023 04:13:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89083' 22/11/2023 04:13:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89083' 22/11/2023 04:13:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89083' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '320' , '-320' , '4' , '3.40' , '3.4' , '0' , '0' , '1088.00' ) 22/11/2023 04:13:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89083' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '43' , '-43' , '4' , '3.50' , '3.5' , '0' , '0' , '150.50' ) 22/11/2023 04:13:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89083' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '48' , '-48' , '4' , '25.00' , '25' , '0' , '0' , '1200.00' ) 22/11/2023 04:17:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3297' AND id_document != '88489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-24') 22/11/2023 04:17:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3297', document_date = '2023-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.25', price_tax_excluded = '7.25', date_upd = NOW() WHERE id_document = '88489' 22/11/2023 04:17: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 = '88489' 22/11/2023 04:17:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '88489' 22/11/2023 04:17: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 ( '88489' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/11/2023 04:17: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 ( '88489' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 22/11/2023 04:17: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 ( '88489' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 22/11/2023 04:25:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 04:25:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3689' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/11/2023 04:25:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89084' 22/11/2023 04:25:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89084' 22/11/2023 04:25:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89084' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/11/2023 04:38:07 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 22/11/2023 04:38:07 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '183' , '1' ) 22/11/2023 04:38:07 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '183' , '1' ) 22/11/2023 04:38:07 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '183' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 22/11/2023 04:40:25 pm >> UPDATE ps_address SET id_state = '189', lastname = 'MEDIAGRAF', address1 = 'VIALE DELLA NAVIGAZIONE INTERNA 89', address2 = '', postcode = '35027', dni = '', vat_number = '', city = 'NOVENTA PADOVANA ', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '183' 22/11/2023 04:40:25 pm >> UPDATE ps_supplier SET email = 'm.zorzi@mediagrafspa.it', name = 'MEDIAGRAF', date_upd = NOW() WHERE id_supplier = '183' 22/11/2023 04:40:25 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '183' 22/11/2023 04:41: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 ( '33' , '32337577' , '2023-11-10' , '' , '0' , '183' , '4679195' , 'VIALE DELLA NAVIGAZIONE INTERNA 89 35027 NOVENTA PADOVANA ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 22/11/2023 04:41: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 = '89085' 22/11/2023 04:41:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89085' 22/11/2023 04:41: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 ( '89085' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1000' , '1000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 22/11/2023 04:41:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21899' AND id_supplier = '183' 22/11/2023 04:41:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21899' , '183' , '1' ) 22/11/2023 04:44:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '56/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 04:44:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '56/E' , '2023-11-22' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '3700.00' , '3700.00' , NOW() , NOW() ) 22/11/2023 04:44:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89086' 22/11/2023 04:44:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89086' 22/11/2023 04:44:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89086' , '21899' , 'SACRA BIBBIA cei/uelci ' , '400' , '-400' , '4' , '18.50' , '18.5' , '0' , '50' , '3700.00' ) 22/11/2023 04:50:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 04:50:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3690' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 22/11/2023 04:50:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89087' 22/11/2023 04:50:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89087' 22/11/2023 04:50:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89087' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/11/2023 05:05:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '283' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 05:05: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 ( '21' , '283' , '2023-11-22' , '' , '3826' , '0' , '4672780' , 'P. ZZA UMBERTO I 35 - PREPEZZANO 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '66.30' , '66.30' , NOW() , NOW() ) 22/11/2023 05:05: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 = '89088' 22/11/2023 05:05:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '89088' 22/11/2023 05:05: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 ( '89088' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 22/11/2023 05:05: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 ( '89088' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 22/11/2023 05:05: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 ( '89088' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '5' , '-5' , '4' , '3.40' , '3.4' , '0' , '15' , '14.45' ) 22/11/2023 05:05: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 ( '89088' , '2679' , 'CONOSCERE GESU' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 22/11/2023 05:06:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 05:06:00 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' , '3691' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.60' , '8.27' , NOW() , NOW() ) 22/11/2023 05:06:00 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 = '89089' 22/11/2023 05:06:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89089' 22/11/2023 05:06:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89089' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 22/11/2023 05:10:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3692' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 05:10:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3692' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 22/11/2023 05:10:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89090' 22/11/2023 05:10:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89090' 22/11/2023 05:10:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89090' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 22/11/2023 05:36:04 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 22/11/2023 05:36:04 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '184' , '1' ) 22/11/2023 05:36:04 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '184' , '1' ) 22/11/2023 05:36:04 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '184' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 22/11/2023 05:38:08 pm >> UPDATE ps_address SET id_state = '189', lastname = 'MEDIAGRAF SPA', address1 = 'VIALE NAVIGAZIONE INTERNA 89', address2 = '', postcode = '35027', dni = '', vat_number = '02078290281', city = 'NOVENTA PADOVANA', phone = '0498991511', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '184' 22/11/2023 05:38:08 pm >> UPDATE ps_supplier SET email = 'spedizioni@mediagrafspa.it', name = 'MEDIAGRAF SPA', date_upd = NOW() WHERE id_supplier = '184' 22/11/2023 05:38:08 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '184' 22/11/2023 07:26:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 22/11/2023 07:26:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3693' , '2023-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 22/11/2023 07:26:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89091' 22/11/2023 07:26:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89091' 22/11/2023 07:26:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89091' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 22/11/2023 07:49:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000768' AND id_product != '2766' AND ean13 != '' 22/11/2023 07:49:05 pm >> UPDATE ps_product SET id_supplier = '39', reference = '2015', ean13 = '000768', date_upd = NOW() WHERE id_product = '2766' 22/11/2023 07:49:05 pm >> UPDATE ps_product_lang SET name = 'CORONA PLASTICA FOSFORO - 0100F', description = '' WHERE id_product = '2766' 22/11/2023 07:49:05 pm >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '2766' 22/11/2023 07:49:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '187', 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 = '2766' 22/11/2023 07:49:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '2766'