14/07/2023 09:07:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 09:07:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2381' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.84' , '28.84' , NOW() , NOW() ) 14/07/2023 09:07:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86745' 14/07/2023 09:07:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86745' 14/07/2023 09:07:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86745' , '21067' , 'AMEN - AGO 23' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 14/07/2023 09:07:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86745' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '20' , '-20' , '4' , '0.70' , '0.7' , '0' , '0' , '14.00' ) 14/07/2023 09:08:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 09:08: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' , '2382' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.16' , '31.28' , NOW() , NOW() ) 14/07/2023 09:08: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 = '86746' 14/07/2023 09:08:53 am >> DELETE FROM ps_document_detail WHERE id_document = '86746' 14/07/2023 09:08: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 ( '86746' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '38.16' , '31.27868852459' , '22' , '0' , '38.16' ) 14/07/2023 09:10:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 09:10:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2383' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.60' , '61.66' , NOW() , NOW() ) 14/07/2023 09:10:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86747' 14/07/2023 09:10:26 am >> DELETE FROM ps_document_detail WHERE id_document = '86747' 14/07/2023 09:10:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86747' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 14/07/2023 09:10:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86747' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 14/07/2023 09:10:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86747' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 14/07/2023 09:10:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86747' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/07/2023 09:18:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/07/2023 09:18:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21407' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 09:18:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21407' , '1' , '1' , '2' , NOW() , NOW() ) 14/07/2023 09:18:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21407' , '0' , '1' , '0' , '0' ) 14/07/2023 09:19:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831528313' AND id_product != '21407' AND ean13 != '' 14/07/2023 09:19:22 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9788831528313', date_upd = NOW() WHERE id_product = '21407' 14/07/2023 09:19:22 am >> UPDATE ps_product_lang SET name = 'GIORNO DELLA PRIMA COMUNIONE', description = '' WHERE id_product = '21407' 14/07/2023 09:19:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.836065573770492' WHERE id_product = '21407' 14/07/2023 09:19:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '27', 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 = '21407' 14/07/2023 09:19:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21407' 14/07/2023 09:19:23 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21407' 14/07/2023 09:19:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21408' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 09:19:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21408' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21407' 14/07/2023 09:19:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21408' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21407' 14/07/2023 09:20:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831528313' AND id_product != '21407' AND ean13 != '' 14/07/2023 09:20:10 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9788831528313', date_upd = NOW() WHERE id_product = '21407' 14/07/2023 09:20:11 am >> UPDATE ps_product_lang SET name = 'GIORNO DELLA PRIMA COMUNIONE', description = '' WHERE id_product = '21407' 14/07/2023 09:20:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21407' 14/07/2023 09:20:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '27', 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 = '21407' 14/07/2023 09:20:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21407' 14/07/2023 09:20: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 ( '33' , '636588' , '2023-07-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0.24' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '7.88' , '7.88' , NOW() , NOW() ) 14/07/2023 09:20: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 = '86748' 14/07/2023 09:20:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86748' 14/07/2023 09:20: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 ( '86748' , '21407' , 'GIORNO DELLA PRIMA COMUNIONE' , '1' , '1' , '4' , '12' , '12' , '0' , '33+5' , '7.6380' ) 14/07/2023 09:20:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '21407' AND id_supplier = '7' 14/07/2023 09:20:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21407' , '7' , '1' ) 14/07/2023 09:22:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253117' AND id_product != '21408' AND ean13 != '' 14/07/2023 09:22:05 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791281253117', date_upd = NOW() WHERE id_product = '21408' 14/07/2023 09:22:05 am >> UPDATE ps_product_lang SET name = 'CORONA ALLA MADONNA DEI RAGAZZI DELLA STRADA', description = '' WHERE id_product = '21408' 14/07/2023 09:22:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1' WHERE id_product = '21408' 14/07/2023 09:22:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21408' 14/07/2023 09:22:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21408' 14/07/2023 09:22:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21408' 14/07/2023 09:22:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21409' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 09:22:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21409' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21408' 14/07/2023 09:22:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21409' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21408' 14/07/2023 09:22: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 ( '33' , '636589' , '2023-07-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0.06' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '2.16' , '2.16' , NOW() , NOW() ) 14/07/2023 09:22: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 = '86749' 14/07/2023 09:22:53 am >> DELETE FROM ps_document_detail WHERE id_document = '86749' 14/07/2023 09:22: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 ( '86749' , '21408' , 'CORONA ALLA MADONNA DEI RAGAZZI DELLA STRADA' , '3' , '3' , '4' , '1.00' , '1' , '0' , '30' , '2.1000' ) 14/07/2023 09:22:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21408' AND id_supplier = '7' 14/07/2023 09:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21408' , '7' , '1' ) 14/07/2023 09:23:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556910' AND id_product != '21409' AND ean13 != '' 14/07/2023 09:23:46 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831556910', date_upd = NOW() WHERE id_product = '21409' 14/07/2023 09:23:46 am >> UPDATE ps_product_lang SET name = 'SUBLIMITAS ET MISERIA HOMINIS', description = '' WHERE id_product = '21409' 14/07/2023 09:23:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '21409' 14/07/2023 09:23:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21409' 14/07/2023 09:23:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21409' 14/07/2023 09:23: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 = '21409' 14/07/2023 09:23:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21410' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 09:23: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 '21410' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21409' 14/07/2023 09:23:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21410' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21409' 14/07/2023 09:27:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 09:27:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2384' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 14/07/2023 09:27:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86750' 14/07/2023 09:27:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86750' 14/07/2023 09:27:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86750' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 14/07/2023 09:33:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225947' AND id_product != '18289' AND ean13 != '' 14/07/2023 09:33:16 am >> UPDATE ps_product SET id_supplier = '7', reference = '14', ean13 = '9788892225947', date_upd = NOW() WHERE id_product = '18289' 14/07/2023 09:33:16 am >> UPDATE ps_product_lang SET name = 'SANTA MESSA DEGLI SPOSI - N.E.', description = '' WHERE id_product = '18289' 14/07/2023 09:33:16 am >> UPDATE ps_product SET wholesale_price = '1.01', on_sale = '0', price = '1.9' WHERE id_product = '18289' 14/07/2023 09:33:16 am >> UPDATE ps_product_shop SET wholesale_price = '1.01', price = '1.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '242', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18289' 14/07/2023 09:33:16 am >> DELETE FROM ps_specific_price WHERE id_product = '18289' 14/07/2023 09:34:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892213845' AND id_product != '13432' AND ean13 != '' 14/07/2023 09:34:28 am >> UPDATE ps_product SET id_supplier = '7', reference = 'GONDOLA 1', ean13 = '9788892213845', date_upd = NOW() WHERE id_product = '13432' 14/07/2023 09:34:28 am >> UPDATE ps_product_lang SET name = 'ARTE DI RICOMINCIARE - F. ROSINI', description = '' WHERE id_product = '13432' 14/07/2023 09:34:28 am >> UPDATE ps_product SET wholesale_price = '10.72', on_sale = '0', price = '18' WHERE id_product = '13432' 14/07/2023 09:34:28 am >> UPDATE ps_product_shop SET wholesale_price = '10.72', price = '18', id_tax_rules_group = '4', id_category_default = '30', 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 = '13432' 14/07/2023 09:34:28 am >> DELETE FROM ps_specific_price WHERE id_product = '13432' 14/07/2023 09:36:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 09:36:38 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' , '2385' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 14/07/2023 09:36:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86751' 14/07/2023 09:36:38 am >> DELETE FROM ps_document_detail WHERE id_document = '86751' 14/07/2023 09:36:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86751' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 14/07/2023 09:43:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554817' AND id_product != '21410' AND ean13 != '' 14/07/2023 09:43:49 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788831554817', date_upd = NOW() WHERE id_product = '21410' 14/07/2023 09:43:49 am >> UPDATE ps_product_lang SET name = 'IO E CARLO - M. PAPPALARDO', description = '' WHERE id_product = '21410' 14/07/2023 09:43:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.9' WHERE id_product = '21410' 14/07/2023 09:43:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.9', id_tax_rules_group = '4', id_category_default = '27', 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 = '21410' 14/07/2023 09:43:49 am >> DELETE FROM ps_specific_price WHERE id_product = '21410' 14/07/2023 09:43:50 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21410' 14/07/2023 09:43:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21411' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 09:43:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21411' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21410' 14/07/2023 09:43:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21411' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21410' 14/07/2023 09:45:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821530104' AND id_product != '2103' AND ean13 != '' 14/07/2023 09:45:51 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788821530104', date_upd = NOW() WHERE id_product = '2103' 14/07/2023 09:45:51 am >> UPDATE ps_product_lang SET name = 'CIRENEI DELLA GIOIA - TONINO BELLO', description = '' WHERE id_product = '2103' 14/07/2023 09:45:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '2103' 14/07/2023 09:45:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2103' 14/07/2023 09:45:51 am >> DELETE FROM ps_specific_price WHERE id_product = '2103' 14/07/2023 09:47:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821547904' AND id_product != '21411' AND ean13 != '' 14/07/2023 09:47:52 am >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '9788821547904', date_upd = NOW() WHERE id_product = '21411' 14/07/2023 09:47:52 am >> UPDATE ps_product_lang SET name = 'ANNO LITURGICO - A. BERGAMINI', description = '' WHERE id_product = '21411' 14/07/2023 09:47:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21411' 14/07/2023 09:47:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', 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 = '21411' 14/07/2023 09:47:52 am >> DELETE FROM ps_specific_price WHERE id_product = '21411' 14/07/2023 09:47:53 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 = '21411' 14/07/2023 09:47:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21412' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 09:47:53 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 '21412' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21411' 14/07/2023 09:47:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21412' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21411' 14/07/2023 09:50:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892211223' AND id_product != '12705' AND ean13 != '' 14/07/2023 09:50:46 am >> UPDATE ps_product SET id_supplier = '7', reference = 'GONDOLA 1', ean13 = '9788892211223', date_upd = NOW() WHERE id_product = '12705' 14/07/2023 09:50:46 am >> UPDATE ps_product_lang SET name = 'QUELLO CHE SEI PER ME - L. EPICOCO', description = '' WHERE id_product = '12705' 14/07/2023 09:50:46 am >> UPDATE ps_product SET wholesale_price = '6.70', on_sale = '0', price = '12' WHERE id_product = '12705' 14/07/2023 09:50:46 am >> UPDATE ps_product_shop SET wholesale_price = '6.70', price = '12', id_tax_rules_group = '4', id_category_default = '30', 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 = '12705' 14/07/2023 09:50:46 am >> DELETE FROM ps_specific_price WHERE id_product = '12705' 14/07/2023 09:51:40 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' , '636590' , '2023-07-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '28.44' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '731.28' , '731.28' , NOW() , NOW() ) 14/07/2023 09:51:40 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 = '86752' 14/07/2023 09:51:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86752' 14/07/2023 09:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33+26' , '4.9580' ) 14/07/2023 09:51:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17852' AND id_supplier = '7' 14/07/2023 09:51:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17852' , '7' , '1' ) 14/07/2023 09:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33+26' , '7.4370' ) 14/07/2023 09:51:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17488' AND id_supplier = '7' 14/07/2023 09:51:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17488' , '7' , '1' ) 14/07/2023 09:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33+26' , '7.9328' ) 14/07/2023 09:51:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 14/07/2023 09:51:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 14/07/2023 09:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33+26' , '15.8656' ) 14/07/2023 09:51:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '7' 14/07/2023 09:51:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '7' , '1' ) 14/07/2023 09:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '5' , '5' , '4' , '12.90' , '12.9' , '0' , '33+26' , '31.9791' ) 14/07/2023 09:51:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '7' 14/07/2023 09:51:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '7' , '1' ) 14/07/2023 09:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '1090' , 'BIBBIA' , '30' , '30' , '4' , '9.90' , '9.9' , '0' , '33+26' , '147.2526' ) 14/07/2023 09:51:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '7' 14/07/2023 09:51:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '1114' , 'BIBBIA DEGLI SPOSI' , '5' , '5' , '4' , '25.00' , '25' , '0' , '33+26' , '61.9750' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '1114' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1114' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '5' , '5' , '4' , '39.00' , '39' , '0' , '33+26' , '96.6810' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '15722' , 'BIBBIA DEI PICCOLI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+26' , '5.7720' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '15722' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15722' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '33+26' , '0.9420' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33+26' , '7.9328' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '18' , '18' , '0' , '33+26' , '8.9244' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33+26' , '8.9244' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '1' , '4' , '12' , '12' , '0' , '33+26' , '5.9496' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33+26' , '4.9580' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '10060' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10060' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33+26' , '5.9496' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17001' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17001' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '21196' , 'CALENDARIO LITURGICO 2024' , '120' , '120' , '4' , '0.50' , '0.5' , '0' , '33+26' , '29.7480' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21196' AND id_supplier = '7' 14/07/2023 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21196' , '7' , '1' ) 14/07/2023 09:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86752' , '6962' , 'NELLA CASA DEL DEFUNTO' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '33+26' , '3.7185' ) 14/07/2023 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '5' , '5' , '4' , '2.00' , '2' , '0' , '33+26' , '4.9580' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21144' , 'FIORETTI DI SAN FRANCESCO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33+26' , '7.4370' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21144' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21144' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '19654' , 'ALBUM RICORDO PRIMA COMUNIONE' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '33+26' , '6.1975' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19654' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19654' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '4594' , 'GIORNO IN CUI IO E GESÙ ... - ALBUM COMUNIONE' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '33+26' , '6.6933' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '4594' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4594' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '6640' , 'MIA PRIMA COMUNIONE' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '33+26' , '6.6933' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '6640' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6640' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '1177' , 'BIBBIA PER I RAGAZZI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35+26' , '6.7340' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '1177' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1177' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35+26' , '6.2049' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '4487' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4487' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '17186' , 'MIA PRIMA COMUNIONE - ALBUM' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '35+26' , '7.1669' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '17186' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17186' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35+26' , '6.2049' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '15227' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15227' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21065' , 'BIBBIA - SCRUTATE LE SCRITTURE - BIANCA' , '2' , '2' , '4' , '39.00' , '39' , '0' , '33+26' , '38.6724' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21065' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21065' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '2' , '2' , '4' , '11.90' , '11.9' , '0' , '35+26' , '11.4478' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21410' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21410' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '2' , '2' , '4' , '10.90' , '10.9' , '0' , '35+26' , '10.4858' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21398' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21398' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21409' , 'SUBLIMITAS ET MISERIA HOMINIS' , '5' , '5' , '4' , '1.80' , '1.8' , '0' , '33+26' , '4.4622' ) 14/07/2023 09:51:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21409' AND id_supplier = '7' 14/07/2023 09:51:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21409' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '5' , '5' , '4' , '3.00' , '3' , '0' , '33+26' , '7.4370' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '18446' , 'MIA BIBBIA MORBIDA' , '1' , '1' , '4' , '11.90' , '11.9' , '0' , '35+26' , '5.7239' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18446' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18446' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '15563' , 'MIA PRIMA BIBBIA' , '2' , '2' , '4' , '14.00' , '14' , '0' , '35+26' , '13.4680' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '15563' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15563' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '2103' , 'CIRENEI DELLA GIOIA - TONINO BELLO' , '3' , '3' , '4' , '12.00' , '12' , '0' , '33+26' , '17.8488' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '2103' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2103' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '6263' , 'MARIA, DONNA DEI GIORNI NOSTRI - T.BELLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33+26' , '6.9412' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '6263' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6263' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '2' , '2' , '4' , '38.00' , '38' , '0' , '33+26' , '37.6808' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '21003' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21003' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '21411' , 'ANNO LITURGICO - A. BERGAMINI' , '2' , '2' , '4' , '18.00' , '18' , '0' , '33+26' , '17.8488' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '21411' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21411' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '20209' , 'CHIESA CHE FAREMO - P. CURTAZ' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33+26' , '7.9328' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20209' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20209' , '7' , '1' ) 14/07/2023 09:51: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 ( '86752' , '20475' , '50 DOMANDE A DIO - G. BIADER' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35+26' , '7.6960' ) 14/07/2023 09:51:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20475' AND id_supplier = '7' 14/07/2023 09:51:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20475' , '7' , '1' ) 14/07/2023 10:27:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 10:27: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 ( '11' , '2386' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.80' , '51.49' , NOW() , NOW() ) 14/07/2023 10:27: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 = '86753' 14/07/2023 10:27:52 am >> DELETE FROM ps_document_detail WHERE id_document = '86753' 14/07/2023 10:27: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 ( '86753' , '2103' , 'CIRENEI DELLA GIOIA - TONINO BELLO' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '5' , '22.80' ) 14/07/2023 10:27: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 ( '86753' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 14/07/2023 10:34:08 am >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '86725' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-12') 14/07/2023 10:34:08 am >> UPDATE ps_document SET id_document_type = '24', document_num = '74/A', document_date = '2023-07-12', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2769.00', price_tax_excluded = '2748.44', date_upd = NOW() WHERE id_document = '86725' 14/07/2023 10:34: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 = '86725' 14/07/2023 10:34:08 am >> DELETE FROM ps_document_detail WHERE id_document = '86725' 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' , '11.0000' , '11' , '0' , '0' , '77.00' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' , '11.0000' , '11' , '0' , '0' , '33.00' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '18389' , 'CASULA MINIMAL LANA LUREX' , '4' , '-4' , '0' , '625.0000' , '625' , '0' , '0' , '2500.00' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '36.5000' , '36.5' , '0' , '' , '36.50' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 14/07/2023 10:34:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '54.00' ) 14/07/2023 10:35:40 am >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '86725' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-12') 14/07/2023 10:35:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '74/A', document_date = '2023-07-12', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2769.00', price_tax_excluded = '2769.00', date_upd = NOW() WHERE id_document = '86725' 14/07/2023 10:35:40 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 = '86725' 14/07/2023 10:35:41 am >> DELETE FROM ps_document_detail WHERE id_document = '86725' 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' , '11.0000' , '11' , '0' , '0' , '77.00' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' , '11.0000' , '11' , '0' , '0' , '33.00' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '18389' , 'CASULA MINIMAL LANA LUREX' , '4' , '-4' , '0' , '625.0000' , '625' , '0' , '0' , '2500.00' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '36.5000' , '36.5' , '0' , '' , '36.50' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 14/07/2023 10:35:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '4' , '4.5000' , '4.5' , '0' , '0' , '54.00' ) 14/07/2023 10:37:36 am >> SELECT document_num FROM ps_document WHERE document_num = '75/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 10:37:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '75/A' , '2023-07-14' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3863.80' , '3863.80' , NOW() , NOW() ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86754' 14/07/2023 10:37:36 am >> DELETE FROM ps_document_detail WHERE id_document = '86754' 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' , '8.50' , '8.5' , '' , '0' , '8.50' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' , '13.50' , '13.5' , '' , '0' , '94.50' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' , '13.00' , '13' , '' , '0' , '39.00' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '18389' , 'CASULA MINIMAL LANA LUREX' , '4' , '-4' , '0' , '890.00' , '890' , '' , '0' , '3560.00' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '' , '38.00' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '0' , '38.00' , '38' , '' , '0' , '38.00' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '0' , '27.00' , '27' , '' , '0' , '27.00' ) 14/07/2023 10:37:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86754' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '0' , '4.90' , '4.9' , '' , '0' , '58.80' ) 14/07/2023 10:38:18 am >> SELECT document_num FROM ps_document WHERE document_num = '75/A' AND id_document != '86754' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 10:38:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '75/A', document_date = '2023-07-14', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '3891.80', price_tax_excluded = '3891.80', date_upd = NOW() WHERE id_document = '86754' 14/07/2023 10:38: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 = '86754' 14/07/2023 10:38:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86754' 14/07/2023 10:38: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 ( '86754' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/07/2023 10:38: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 ( '86754' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' , '13.5000' , '13.5' , '0' , '0' , '94.50' ) 14/07/2023 10:38: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 ( '86754' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' , '13.0000' , '13' , '0' , '0' , '39.00' ) 14/07/2023 10:38: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 ( '86754' , '18389' , 'CASULA MINIMAL LANA LUREX' , '4' , '-4' , '0' , '890.0000' , '890' , '0' , '0' , '3560.00' ) 14/07/2023 10:38: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 ( '86754' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '' , '38.00' ) 14/07/2023 10:38: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 ( '86754' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 14/07/2023 10:38: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 ( '86754' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '0' , '27.0000' , '27' , '0' , '0' , '27.00' ) 14/07/2023 10:38: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 ( '86754' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '0' , '4.9000' , '4.9' , '0' , '0' , '58.80' ) 14/07/2023 10:38: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 ( '86754' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '0' , '16.00' , '16' , '' , '0' , '16.00' ) 14/07/2023 10:38: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 ( '86754' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '0' , '12.00' , '12' , '' , '0' , '12.00' ) 14/07/2023 10:38:54 am >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '86725' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-12') 14/07/2023 10:38:54 am >> UPDATE ps_document SET id_document_type = '24', document_num = '74/A', document_date = '2023-07-12', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2791.00', price_tax_excluded = '2791.00', date_upd = NOW() WHERE id_document = '86725' 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86725' 14/07/2023 10:38:54 am >> DELETE FROM ps_document_detail WHERE id_document = '86725' 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' , '11.0000' , '11' , '0' , '0' , '77.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' , '11.0000' , '11' , '0' , '0' , '33.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '18389' , 'CASULA MINIMAL LANA LUREX' , '4' , '-4' , '0' , '625.0000' , '625' , '0' , '0' , '2500.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '36.5000' , '36.5' , '0' , '' , '36.50' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '4' , '4.5000' , '4.5' , '0' , '0' , '54.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '0' , '12' , '12' , '' , '0' , '12.00' ) 14/07/2023 10:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86725' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '0' , '10' , '10' , '' , '0' , '10.00' ) 14/07/2023 11:16:56 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 14/07/2023 11:16:56 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '524' , '1' ) 14/07/2023 11:16:56 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '524' , '2' ) 14/07/2023 11:16:56 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '524' , '3' ) 14/07/2023 11:16:56 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '524' , '1' , 'ELLIOT' , LOWER('ELLIOT') ) 14/07/2023 11:16:56 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '524' , '1' , '0' ) 14/07/2023 11:17:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892762459' AND id_product != '21412' AND ean13 != '' 14/07/2023 11:17:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892762459', date_upd = NOW() WHERE id_product = '21412' 14/07/2023 11:17:11 am >> UPDATE ps_product_lang SET name = 'COME D\'ARIA - A. D\'ADAMO', description = '' WHERE id_product = '21412' 14/07/2023 11:17:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21412' 14/07/2023 11:17:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '524', 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 = '21412' 14/07/2023 11:17:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21412' 14/07/2023 11:17:13 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21412' 14/07/2023 11:17:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21413' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 11:17:13 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21413' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21412' 14/07/2023 11:17:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21413' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21412' 14/07/2023 11:18:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872296349' AND id_product != '21413' AND ean13 != '' 14/07/2023 11:18:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788872296349', date_upd = NOW() WHERE id_product = '21413' 14/07/2023 11:18:08 am >> UPDATE ps_product_lang SET name = 'ELOGIO DELLA DEBOLEZZA', description = '' WHERE id_product = '21413' 14/07/2023 11:18:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '21413' 14/07/2023 11:18:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '128', 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 = '21413' 14/07/2023 11:18:08 am >> DELETE FROM ps_specific_price WHERE id_product = '21413' 14/07/2023 11:18:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21413' 14/07/2023 11:18:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21414' , '1' , '' , 'nuovo-prodotto' ) 14/07/2023 11:18:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21414' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21413' 14/07/2023 11:18:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21414' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21413' 14/07/2023 11:20:00 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' , '1127122' , '2023-07-12' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.00' , '124.00' , NOW() , NOW() ) 14/07/2023 11:20:00 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 = '86755' 14/07/2023 11:20:00 am >> DELETE FROM ps_document_detail WHERE id_document = '86755' 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '21412' , 'COME DARIA - A. DADAMO' , '2' , '2' , '4' , '15.00' , '15' , '0' , '0' , '30.0000' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21412' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21412' , '177' , '1' ) 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '21413' , 'ELOGIO DELLA DEBOLEZZA' , '2' , '2' , '4' , '9.00' , '9' , '0' , '0' , '18.0000' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21413' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21413' , '177' , '1' ) 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '5670' , 'LETTERA A UNA PROFESSORESSA - DON MILANI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '5670' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5670' , '177' , '1' ) 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '21259' , 'Prima di andare alle medie. Storie, trucchi e regole di sopravvivenza' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21259' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21259' , '177' , '1' ) 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '21209' , 'IL PRIMO SANGUE DELLE DONNE: IL MENARCA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21209' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21209' , '177' , '1' ) 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '20327' , 'SIGNORE INSEGNACI A PREGARE' , '2' , '2' , '4' , '15.00' , '15' , '0' , '0' , '30.0000' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '20327' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20327' , '177' , '1' ) 14/07/2023 11:20:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86755' , '21265' , 'LAVARO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 14/07/2023 11:20:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21265' AND id_supplier = '177' 14/07/2023 11:20:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21265' , '177' , '1' ) 14/07/2023 12:14:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 12:14:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2387' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '11.54' , NOW() , NOW() ) 14/07/2023 12:14:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86756' 14/07/2023 12:14:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '86756' 14/07/2023 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86756' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 14/07/2023 03:20:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2388' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 03:20:11 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' , '2388' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.70' , '13.48' , NOW() , NOW() ) 14/07/2023 03:20:11 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 = '86757' 14/07/2023 03:20:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '86757' 14/07/2023 03:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86757' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 14/07/2023 03:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86757' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 14/07/2023 03:24:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2389' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 03:24:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2389' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 14/07/2023 03:24:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86758' 14/07/2023 03:24:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '86758' 14/07/2023 03:24:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86758' , '6053' , 'MADONNA DEL CARMELO - CM 13 - 023 CAR/13' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 14/07/2023 03:42:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2390' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 03:42:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2390' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.00' , '113.11' , NOW() , NOW() ) 14/07/2023 03:42:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86759' 14/07/2023 03:42:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '86759' 14/07/2023 03:42:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86759' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 14/07/2023 03:42:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86759' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 14/07/2023 03:47:00 pm >> 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') 14/07/2023 03:47:00 pm >> 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 = '63.60', price_tax_excluded = '63.60', date_upd = NOW() WHERE id_document = '81317' 14/07/2023 03:47: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 = '81317' 14/07/2023 03:47:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 14/07/2023 03:47: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 ( '81317' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 14/07/2023 03:47: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 ( '81317' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 14/07/2023 03:47: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 ( '81317' , '21197' , 'PAROLA E PREGHIERA - SET 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 14/07/2023 03:47: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 ( '81317' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 14/07/2023 03:47: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 ( '81317' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 14/07/2023 03:47:01 pm >> INSERT INTO ps_document_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' , '21192' , 'SULLA TUA PAROLA - SET OTT 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/07/2023 03:47:01 pm >> INSERT INTO ps_document_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' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/07/2023 03:47:01 pm >> INSERT INTO ps_document_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' , '21345' , 'buio oltre la siepe - h. lee' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/07/2023 03:47:01 pm >> INSERT INTO ps_document_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' , '2103' , 'CIRENEI DELLA GIOIA - TONINO BELLO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/07/2023 05:19:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2391' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 05:19:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2391' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 14/07/2023 05:19:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86760' 14/07/2023 05:19:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '86760' 14/07/2023 05:19:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86760' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/07/2023 05:28:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2392' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 05:28: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' , '2392' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '360.25' , NOW() , NOW() ) 14/07/2023 05:28: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 = '86761' 14/07/2023 05:28:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '86761' 14/07/2023 05:28: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 ( '86761' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '143.00' , '117.2131147541' , '22' , '0' , '143.00' ) 14/07/2023 05:28: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 ( '86761' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '1' , '-1' , '1' , '39.9' , '32.704918032787' , '22' , '0' , '39.90' ) 14/07/2023 05:28: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 ( '86761' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37.55' , '30.77868852459' , '22' , '0' , '37.55' ) 14/07/2023 05:28: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 ( '86761' , '12872' , 'LEGGERSI DENTRO - MARCO - G. PICCOLO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 14/07/2023 05:28: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 ( '86761' , '14478' , 'LEGGERSI DENTRO - MATTEO - G. PICCOLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/07/2023 05:28: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 ( '86761' , '14515' , 'LEGGERSI DENTRO - LUCA - G. PICCOLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/07/2023 05:28: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 ( '86761' , '20542' , 'NEL PROPRIO CUORE - A. CANOPI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 14/07/2023 05:28: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 ( '86761' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 14/07/2023 05:28: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 ( '86761' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '-1' , '4' , '48.00' , '48' , '0' , '5' , '45.60' ) 14/07/2023 05:28: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 ( '86761' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '-1' , '4' , '63.00' , '63' , '0' , '5' , '59.85' ) 14/07/2023 07:09:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2393' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-14') 14/07/2023 07:09:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2393' , '2023-07-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '29.00' , NOW() , NOW() ) 14/07/2023 07:09:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86762' 14/07/2023 07:09:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '86762' 14/07/2023 07:09:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86762' , '20327' , 'SIGNORE INSEGNACI A PREGARE' , '2' , '-2' , '4' , '14.5' , '14.5' , '0' , '0' , '29.00' )