14/11/2024 08:38:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '455' , '2024-11-12' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 14/11/2024 08: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 = '94246' 14/11/2024 08:38:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94246' 14/11/2024 08: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 ( '94246' , '18369' , 'CAMICE MISTO COT. - 70/005212' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 14/11/2024 08:38:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '18369' AND id_supplier = '143' 14/11/2024 08:38:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18369' , '143' , '1' ) 14/11/2024 09:16:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/11/2024 09:16:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23215' , '1' , '' , 'nuovo-prodotto' ) 14/11/2024 09:16:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23215' , '1' , '1' , '2' , NOW() , NOW() ) 14/11/2024 09:16:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23215' , '0' , '1' , '0' , '0' ) 14/11/2024 09:17:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016109' AND id_product != '23215' AND ean13 != '' 14/11/2024 09:17:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016109', date_upd = NOW() WHERE id_product = '23215' 14/11/2024 09:17:00 am >> UPDATE ps_product_lang SET name = 'AMPOLLA RICAMBIO ART. 1509 - 70/M', description = '' WHERE id_product = '23215' 14/11/2024 09:17:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '23215' 14/11/2024 09:17:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23215' 14/11/2024 09:17:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23215' 14/11/2024 09:17:01 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 = '23215' 14/11/2024 09:17:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23216' , '1' , '' , 'nuovo-prodotto' ) 14/11/2024 09:17:01 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 '23216' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23215' 14/11/2024 09:17:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23216' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23215' 14/11/2024 09:18:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000018042' AND id_product != '12065' AND ean13 != '' 14/11/2024 09:18:27 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000018042', date_upd = NOW() WHERE id_product = '12065' 14/11/2024 09:18:27 am >> UPDATE ps_product_lang SET name = 'COPPIA BOTTIGLIE A/V CORAZZATE - 847', description = '' WHERE id_product = '12065' 14/11/2024 09:18:27 am >> UPDATE ps_product SET wholesale_price = '17.58', on_sale = '0', price = '38.52459016393443' WHERE id_product = '12065' 14/11/2024 09:18:27 am >> UPDATE ps_product_shop SET wholesale_price = '17.58', price = '38.52459016393443', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12065' 14/11/2024 09:18:27 am >> DELETE FROM ps_specific_price WHERE id_product = '12065' 14/11/2024 09:26:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001253' AND id_product != '15871' AND ean13 != '' 14/11/2024 09:26:24 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001253', date_upd = NOW() WHERE id_product = '15871' 14/11/2024 09:26:24 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X100 - 143', description = '' WHERE id_product = '15871' 14/11/2024 09:26:24 am >> UPDATE ps_product SET wholesale_price = '12.35', on_sale = '0', price = '27.049180327868854' WHERE id_product = '15871' 14/11/2024 09:26:24 am >> UPDATE ps_product_shop SET wholesale_price = '12.35', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15871' 14/11/2024 09:26:24 am >> DELETE FROM ps_specific_price WHERE id_product = '15871' 14/11/2024 09:27:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000032680' AND id_product != '23216' AND ean13 != '' 14/11/2024 09:27:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000032680', date_upd = NOW() WHERE id_product = '23216' 14/11/2024 09:27:22 am >> UPDATE ps_product_lang SET name = 'CANDELA ELETTRICA - 326', description = '' WHERE id_product = '23216' 14/11/2024 09:27:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '23216' 14/11/2024 09:27:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23216' 14/11/2024 09:27:22 am >> DELETE FROM ps_specific_price WHERE id_product = '23216' 14/11/2024 09:27: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 = '23216' 14/11/2024 09:27:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23217' , '1' , '' , 'nuovo-prodotto' ) 14/11/2024 09:27: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 '23217' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23216' 14/11/2024 09:27:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23217' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23216' 14/11/2024 09:28:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000032680' AND id_product != '23216' AND ean13 != '' 14/11/2024 09:28:09 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000032680', date_upd = NOW() WHERE id_product = '23216' 14/11/2024 09:28:09 am >> UPDATE ps_product_lang SET name = 'CANDELA ELETTRICA - 326', description = '' WHERE id_product = '23216' 14/11/2024 09:28:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '23216' 14/11/2024 09:28:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23216' 14/11/2024 09:28:09 am >> DELETE FROM ps_specific_price WHERE id_product = '23216' 14/11/2024 09:35: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 ( '31' , '3515' , '2024-11-11' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '211.75' , '173.57' , NOW() , NOW() ) 14/11/2024 09:35: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 = '94247' 14/11/2024 09:35:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 09:35: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 ( '94247' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4' , '3.2786885245902' , '22' , '5' , '9.2720' ) 14/11/2024 09:35:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23215' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23215' , '12' , '1' ) 14/11/2024 09:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '10' , '10' , '1' , '6' , '4.9180327868852' , '22' , '5' , '69.5400' ) 14/11/2024 09:35:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '12' , '1' ) 14/11/2024 09:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '1' , '1' , '19.5' , '15.983606557377' , '22' , '5' , '22.6005' ) 14/11/2024 09:35:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '12065' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12065' , '12' , '1' ) 14/11/2024 09:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '1' , '1' , '48' , '39.344262295082' , '22' , '5' , '55.6320' ) 14/11/2024 09:35:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '803' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '803' , '12' , '1' ) 14/11/2024 09:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '3' , '3' , '1' , '4.4' , '3.6065573770492' , '22' , '5' , '15.2988' ) 14/11/2024 09:35:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18271' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18271' , '12' , '1' ) 14/11/2024 09:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '15871' , 'FINTA CANDELA 4X100 - 143' , '2' , '2' , '1' , '13' , '10.655737704918' , '22' , '5' , '30.1340' ) 14/11/2024 09:35:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '15871' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15871' , '12' , '1' ) 14/11/2024 09:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23216' , 'CANDELA ELETTRICA - 326' , '2' , '2' , '1' , '4' , '3.2786885245902' , '22' , '5' , '9.2720' ) 14/11/2024 09:35:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '23216' AND id_supplier = '12' 14/11/2024 09:35:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23216' , '12' , '1' ) 14/11/2024 09:37:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 09:37:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3468' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.78' , '96.35' , NOW() , NOW() ) 14/11/2024 09:37:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94248' 14/11/2024 09:37:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94248' 14/11/2024 09:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94248' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 14/11/2024 09:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94248' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 14/11/2024 09:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94248' , '17257' , 'IO TI BATTEZZO ' , '18' , '-18' , '4' , '1.80' , '1.8' , '0' , '5' , '30.78' ) 14/11/2024 09:40:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000457' AND id_product != '781' AND ean13 != '' 14/11/2024 09:40:03 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000457', date_upd = NOW() WHERE id_product = '781' 14/11/2024 09:40:03 am >> UPDATE ps_product_lang SET name = 'ASPERGES MIGNON - 807', description = '' WHERE id_product = '781' 14/11/2024 09:40:03 am >> UPDATE ps_product SET wholesale_price = '8.55', on_sale = '0', price = '19.672131147540984' WHERE id_product = '781' 14/11/2024 09:40:03 am >> UPDATE ps_product_shop SET wholesale_price = '8.55', price = '19.672131147540984', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '781' 14/11/2024 09:40:03 am >> DELETE FROM ps_specific_price WHERE id_product = '781' 14/11/2024 09:49:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 09:49:28 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' , '3469' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.50' , '180.50' , NOW() , NOW() ) 14/11/2024 09:49:28 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 = '94249' 14/11/2024 09:49:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94249' 14/11/2024 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94249' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65' , '65' , '0' , '5' , '61.75' ) 14/11/2024 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94249' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '5' , '61.75' ) 14/11/2024 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94249' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 14/11/2024 09:50:58 am >> UPDATE ps_document SET id_document_type = '31', document_num = '3515', document_date = '2024-11-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '305.04', price_tax_excluded = '250.03', date_upd = NOW() WHERE id_document = '94247' 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 09:50:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '15' , '15' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '104.3100' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '1' , '1' , '19.5000' , '15.983606557377' , '22' , '5' , '22.60' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '1' , '1' , '48.0000' , '39.344262295082' , '22' , '5' , '55.63' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '3' , '3' , '1' , '4.4000' , '3.6065573770492' , '22' , '5' , '15.30' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '15871' , 'FINTA CANDELA 4X100 - 143' , '2' , '2' , '1' , '13.0000' , '10.655737704918' , '22' , '5' , '30.13' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23216' , 'CANDELA ELETTRICA - 326' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '5' , '5' , '1' , '8' , '6.5573770491803' , '22' , '5' , '46.3600' ) 14/11/2024 09:50:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '781' , 'ASPERGES MIGNON - 807' , '1' , '1' , '1' , '10.5' , '8.6065573770492' , '22' , '5' , '12.1695' ) 14/11/2024 09:54:13 am >> UPDATE ps_document SET id_document_type = '31', document_num = '3515', document_date = '2024-11-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '305.04', price_tax_excluded = '250.03', date_upd = NOW() WHERE id_document = '94247' 14/11/2024 09:54:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 09:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '15' , '15' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '104.31' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '1' , '1' , '19.5000' , '15.983606557377' , '22' , '5' , '22.60' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '1' , '1' , '48.0000' , '39.344262295082' , '22' , '5' , '55.63' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '3' , '3' , '1' , '4.4000' , '3.6065573770492' , '22' , '5' , '15.30' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '15871' , 'FINTA CANDELA 4X100 - 143' , '2' , '2' , '1' , '13.0000' , '10.655737704918' , '22' , '5' , '30.13' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23216' , 'CANDELA ELETTRICA - 326' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '5' , '5' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '46.36' ) 14/11/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '781' , 'ASPERGES MIGNON - 807' , '1' , '1' , '1' , '10.5000' , '8.6065573770492' , '22' , '5' , '12.17' ) 14/11/2024 09:55:50 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '93088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-11') 14/11/2024 09:55:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2024-09-11', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO € 200 25/9/24 + € 140,00 29/10/24', 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 = '1124.80', price_tax_excluded = '921.97', date_upd = NOW() WHERE id_document = '93088' 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93088' 14/11/2024 09:55:50 am >> DELETE FROM ps_document_detail WHERE id_document = '93088' 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 14/11/2024 09:55:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '45.00' ) 14/11/2024 09:59:25 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '93088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-11') 14/11/2024 09:59:25 am >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2024-09-11', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO € 200 25/9/24 + € 140,00 29/10/24', 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 = '1229.30', price_tax_excluded = '1026.47', date_upd = NOW() WHERE id_document = '93088' 14/11/2024 09:59:25 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 = '93088' 14/11/2024 09:59:25 am >> DELETE FROM ps_document_detail WHERE id_document = '93088' 14/11/2024 09:59:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 14/11/2024 09:59:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 14/11/2024 09:59:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 14/11/2024 09:59:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 14/11/2024 09:59:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 14/11/2024 09:59:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '45.00' ) 14/11/2024 09:59: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 ( '93088' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '-2' , '4' , '30.00' , '30' , '0' , '5' , '57.00' ) 14/11/2024 09:59: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 ( '93088' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '5' , '47.50' ) 14/11/2024 10:01:55 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3215' 14/11/2024 10:01:55 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3215' , '10' , '130' , 'RETTORIA DI SAN DOMENICO' , 'GROSSANO' , 'PADRE VINCENZO' , 'VIA CASA PAPA' , '' , '83029' , 'SOLOFRA' , '' , '' , '3491872560' , '' , '92074270643' , NOW() , NOW() ) 14/11/2024 10:01:55 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3215' 14/11/2024 10:02:19 am >> SELECT document_num FROM ps_document WHERE document_num = '228' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:02:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '228' , '2024-11-14' , '' , '3215' , '0' , '4669544' , 'VIA CASA PAPA 83029 SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '83.81' , '83.81' , NOW() , NOW() ) 14/11/2024 10:02:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94250' 14/11/2024 10:02:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94250' 14/11/2024 10:02:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94250' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '29' , '-29' , '4' , '3.40' , '3.4' , '0' , '15' , '83.81' ) 14/11/2024 10:08:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:08:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3470' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '66.85' , NOW() , NOW() ) 14/11/2024 10:08:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94251' 14/11/2024 10:08:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94251' 14/11/2024 10:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94251' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '22.00' ) 14/11/2024 10:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94251' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '10' , '-10' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '39.00' ) 14/11/2024 10:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94251' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/11/2024 10:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94251' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 14/11/2024 10:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94251' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/11/2024 10:10:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3471' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:10:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3471' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 14/11/2024 10:10:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94252' 14/11/2024 10:10:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94252' 14/11/2024 10:10:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94252' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 14/11/2024 10:37:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3472' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:37:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3472' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.13' , '70.19' , NOW() , NOW() ) 14/11/2024 10:37: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 = '94253' 14/11/2024 10:37:54 am >> DELETE FROM ps_document_detail WHERE id_document = '94253' 14/11/2024 10:37: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 ( '94253' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 14/11/2024 10:37: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 ( '94253' , '18117' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 14/11/2024 10:37: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 ( '94253' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '22.80' ) 14/11/2024 10:37: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 ( '94253' , '20515' , 'DECINA ULIVO - 04/7-D' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 14/11/2024 10:37: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 ( '94253' , '8319' , 'PREGHIERA SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 14/11/2024 10:37: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 ( '94253' , '16130' , 'QUADRETTO EFFETTO PIETRA - SAN MICHELE- 2952/S0063' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 14/11/2024 10:41:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3473' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:41:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3473' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 14/11/2024 10:41:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94254' 14/11/2024 10:41:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94254' 14/11/2024 10:41:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94254' , '22782' , 'STOLA - GRECA 2' , '1' , '-1' , '1' , '130.00' , '106.55737704918' , '22' , '0' , '130.00' ) 14/11/2024 10:47:05 am >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 14/11/2024 10:47:05 am >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23 + 40,00 22/11 - 110,00 07/12- 200,00 11/01 - 50,00 04/04/2024 + € 42,00 29/8/24 - € 100,00 01/10/2024', 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 = '1150.00', price_tax_excluded = '942.62', date_upd = NOW() WHERE id_document = '82607' 14/11/2024 10:47:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82607' 14/11/2024 10:47:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82607' 14/11/2024 10:47:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 14/11/2024 10:47:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82607' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '550.0000' , '450.81967213115' , '22' , '0' , '550.00' ) 14/11/2024 10:47:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82607' , '18369' , 'CAMICE MISTO COT. - 70/005212' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 14/11/2024 10:51:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2997' AND id_document != '93559' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 14/11/2024 10:51:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2997', document_date = '2024-10-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '93559' 14/11/2024 10:51:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93559' 14/11/2024 10:51:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93559' 14/11/2024 10:51:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93559' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 14/11/2024 10:51:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93559' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '80.0000' , '65.573770491803' , '22' , '0' , '80.00' ) 14/11/2024 10:51:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93559' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 14/11/2024 10:51:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3474' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:51:41 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' , '3474' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.90' , NOW() , NOW() ) 14/11/2024 10:51:41 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 = '94255' 14/11/2024 10:51:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94255' 14/11/2024 10: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 ( '94255' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 14/11/2024 10:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 10:56: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 ( '24' , '124/A' , '2024-11-14' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '553.18' , '553.18' , NOW() , NOW() ) 14/11/2024 10:56: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 = '94256' 14/11/2024 10:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94256' 14/11/2024 10:56: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 ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 14/11/2024 10:56: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 ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.40' , '3.4' , '0' , '15' , '86.70' ) 14/11/2024 10:56: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 ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '15' , '161.50' ) 14/11/2024 10:56: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 ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.80' , '3.8' , '0' , '15' , '164.73' ) 14/11/2024 10:56: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 ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.80' , '3.8' , '0' , '15' , '80.75' ) 14/11/2024 11:13:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3475' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 11:13:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3475' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.30' , '42.00' , NOW() , NOW() ) 14/11/2024 11:13:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94257' 14/11/2024 11:13:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94257' 14/11/2024 11:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94257' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '-2' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '19.00' ) 14/11/2024 11:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94257' , '23165' , 'DILEXIT NOS' , '10' , '-10' , '4' , '2.20' , '2.2' , '0' , '5' , '20.90' ) 14/11/2024 11:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94257' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' , '4.40' , '3.6065573770492' , '22' , '0' , '4.40' ) 14/11/2024 11:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94257' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/11/2024 11:15:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3476' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 11:15:24 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' , '3476' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 14/11/2024 11:15:24 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 = '94258' 14/11/2024 11:15:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94258' 14/11/2024 11:15:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94258' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 14/11/2024 11:23:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3477' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 11:23:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3477' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 14/11/2024 11:23: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 = '94259' 14/11/2024 11:23:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94259' 14/11/2024 11:23: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 ( '94259' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6' , '4.9180327868852' , '22' , '0' , '24.00' ) 14/11/2024 11:23: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 ( '94259' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '6' , '4.9180327868852' , '22' , '0' , '24.00' ) 14/11/2024 11:38:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000005271' AND id_product != '23217' AND ean13 != '' 14/11/2024 11:38:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000005271', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:38:06 am >> UPDATE ps_product_lang SET name = 'scatola porta ostia con lunetta - ', description = '' WHERE id_product = '23217' 14/11/2024 11:38:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '122.95081967213115' WHERE id_product = '23217' 14/11/2024 11:38:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '122.95081967213115', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:38:06 am >> DELETE FROM ps_specific_price WHERE id_product = '23217' 14/11/2024 11:38:11 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23217' 14/11/2024 11:38:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23218' , '1' , '' , 'nuovo-prodotto' ) 14/11/2024 11:38:11 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23218' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23217' 14/11/2024 11:38:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23218' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23217' 14/11/2024 11:38:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000005271' AND id_product != '23217' AND ean13 != '' 14/11/2024 11:38:43 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000005271', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:38:43 am >> UPDATE ps_product_lang SET name = 'SCATOLA PORTA OSTIA CON LUNETTA - 1355', description = '' WHERE id_product = '23217' 14/11/2024 11:38:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '122.9508' WHERE id_product = '23217' 14/11/2024 11:38:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '122.9508', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:38:43 am >> DELETE FROM ps_specific_price WHERE id_product = '23217' 14/11/2024 11:39:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000005271' AND id_product != '23217' AND ean13 != '' 14/11/2024 11:39:02 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000005271', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:39:02 am >> UPDATE ps_product_lang SET name = 'SCATOLA PORTA OSTIA CON LUNETTA - 1355', description = '' WHERE id_product = '23217' 14/11/2024 11:39:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '122.9508' WHERE id_product = '23217' 14/11/2024 11:39:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '122.9508', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:39:02 am >> DELETE FROM ps_specific_price WHERE id_product = '23217' 14/11/2024 11:41:11 am >> UPDATE ps_document SET id_document_type = '31', document_num = '3515', document_date = '2024-11-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '15.02', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '615.43', price_tax_excluded = '504.45', date_upd = NOW() WHERE id_document = '94247' 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 11:41:11 am >> DELETE FROM ps_document_detail WHERE id_document = '94247' 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '15' , '15' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '104.31' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '1' , '1' , '19.5000' , '15.983606557377' , '22' , '5' , '22.60' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '1' , '1' , '48.0000' , '39.344262295082' , '22' , '5' , '55.63' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '3' , '3' , '1' , '4.4000' , '3.6065573770492' , '22' , '5' , '15.30' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '15871' , 'FINTA CANDELA 4X100 - 143' , '2' , '2' , '1' , '13.0000' , '10.655737704918' , '22' , '5' , '30.13' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23216' , 'CANDELA ELETTRICA - 326' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '5' , '5' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '46.36' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '781' , 'ASPERGES MIGNON - 807' , '1' , '1' , '1' , '10.5000' , '8.6065573770492' , '22' , '5' , '12.17' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '23217' , 'SCATOLA PORTA OSTIA CON LUNETTA - 1355' , '1' , '1' , '1' , '64' , '52.459016393443' , '22' , '5' , '74.1760' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '797' , 'ASTUCCIO CON 3 VASETTI - 1759/3' , '1' , '1' , '1' , '160' , '131.14754098361' , '22' , '5' , '185.4400' ) 14/11/2024 11:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94247' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '4' , '4' , '1' , '7' , '5.7377049180328' , '22' , '5' , '32.4520' ) 14/11/2024 11:41:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000005271' AND id_product != '23217' AND ean13 != '' 14/11/2024 11:41:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000005271', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:41:15 am >> UPDATE ps_product_lang SET name = 'SCATOLA PORTA OSTIA CON LUNETTA - 1355', description = '' WHERE id_product = '23217' 14/11/2024 11:41:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '122.9508' WHERE id_product = '23217' 14/11/2024 11:41:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '122.9508', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23217' 14/11/2024 11:41:15 am >> DELETE FROM ps_specific_price WHERE id_product = '23217' 14/11/2024 11:45:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3478' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 11:45:21 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' , '3478' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.89' , NOW() , NOW() ) 14/11/2024 11:45:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94260' 14/11/2024 11:45:21 am >> DELETE FROM ps_document_detail WHERE id_document = '94260' 14/11/2024 11:45:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94260' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '22.80' ) 14/11/2024 11:45:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94260' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 14/11/2024 12:04:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3479' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 12:04:55 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' , '3479' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 14/11/2024 12:04:55 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 = '94261' 14/11/2024 12:04:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94261' 14/11/2024 12:04:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94261' , '23171' , 'CODICE DELLANIMA - J. HILLMAN' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 14/11/2024 12:07:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3480' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 12:07: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' , '3480' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.35' , '117.95' , NOW() , NOW() ) 14/11/2024 12:07: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 = '94262' 14/11/2024 12:07:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '94262' 14/11/2024 12:07: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 ( '94262' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 14/11/2024 12:07: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 ( '94262' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 14/11/2024 12:07: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 ( '94262' , '23165' , 'DILEXIT NOS' , '2' , '-2' , '4' , '2.20' , '2.2' , '0' , '0' , '4.40' ) 14/11/2024 12:07: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 ( '94262' , '5444' , 'IO SONO CON VOI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.15' ) 14/11/2024 12:07:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94262' , '11193' , 'VENITE CON ME CAT.' , '10' , '-10' , '4' , '5.50' , '5.5' , '0' , '5' , '52.30' ) 14/11/2024 12:15:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3481' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 12:15:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3481' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.80' , '92.46' , NOW() , NOW() ) 14/11/2024 12:15:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94263' 14/11/2024 12:15:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '94263' 14/11/2024 12:15:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94263' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 14/11/2024 12:36:00 pm >> DELETE FROM ps_document WHERE id_document = '94246' 14/11/2024 12:36:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94246' 14/11/2024 12:36:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '401' , '2024-11-12' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '178.69' , '146.47' , NOW() , NOW() ) 14/11/2024 12:36:36 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 = '94264' 14/11/2024 12:36:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94264' 14/11/2024 12:36:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94264' , '18369' , 'CAMICE MISTO COT. - 70/005212' , '1' , '1' , '1' , '151' , '123.77049180328' , '22' , '3' , '178.6934' ) 14/11/2024 12:36:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18369' AND id_supplier = '143' 14/11/2024 12:36:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18369' , '143' , '1' ) 14/11/2024 12:39:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '4677' , '2024-11-08' , '' , '0' , '134' , '4670785' , 'VIA ROMA 44 00053 CIVITAVECCHIA' , '' , '' , '37.79' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1582.87' , '1297.44' , NOW() , NOW() ) 14/11/2024 12:39:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94265' 14/11/2024 12:39:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '94265' 14/11/2024 12:39:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23192' , 'GRUPPO NATIVITA\' CM 52 STOFFA - PB20717' , '2' , '0' , '1' , '119.8000' , '98.1967' , '22' , '20+5' , '222.16' ) 14/11/2024 12:39:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23192' AND id_supplier = '134' 14/11/2024 12:39:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23192' , '134' , '1' ) 14/11/2024 12:39:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23180' , 'GRUPPO NATIVITA\' IN STOFFA CM 26 - PB20710' , '4' , '0' , '1' , '58.9000' , '48.2787' , '22' , '20+5' , '218.45' ) 14/11/2024 12:39:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23180' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23180' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23188' , 'GRUPPO NATIVITA\' CAMPANA CON LUCI - PB20515' , '12' , '0' , '1' , '10.8000' , '8.8525' , '22' , '20+5' , '120.17' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23188' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23188' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23187' , 'SET NATIVITA\' CM 10 - PB20513' , '48' , '0' , '1' , '3.4800' , '2.8525' , '22' , '20+5' , '154.88' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23187' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23187' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23190' , 'SET PRESEPE CM 30- PB19573' , '1' , '0' , '1' , '84.5000' , '69.2623' , '22' , '5' , '97.94' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23190' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23190' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23181' , 'PRESEPE CON CAPANNA CM 8 - PB18545' , '1' , '0' , '1' , '29.8000' , '24.4262' , '22' , '5' , '34.54' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23181' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23181' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '240' , '0' , '1' , '0.7500' , '0.6148' , '22' , '5' , '208.62' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23189' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23189' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23184' , 'SET PRESEPE 16 PZ CM 10 STOFFA - PB17105' , '1' , '0' , '1' , '58.5000' , '47.9508' , '22' , '5' , '67.80' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23184' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23184' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23182' , 'GRUPPO NATIVITA\' ALBERO CM 10 - PB16997' , '6' , '0' , '1' , '3.4800' , '2.8525' , '22' , '5' , '24.20' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23182' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23182' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23185' , 'GRUPPO NATIVITA\' CM 30 - PB16104' , '1' , '0' , '1' , '34.9000' , '28.6066' , '22' , '5' , '40.45' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23185' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23185' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '19076' , 'NATIVITA\' 5 PEZZI CM 30 - PB8026' , '2' , '0' , '1' , '52.5000' , '43.0328' , '22' , '20+5' , '97.36' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19076' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19076' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23186' , 'PRESEPE CON CAPANNA E LUCE - PB18544' , '1' , '0' , '1' , '24.8000' , '20.3279' , '22' , '5' , '28.74' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23186' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23186' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23191' , 'GRUPPO NATIVITA\' CM 20 - PB17025' , '12' , '0' , '1' , '16.8000' , '13.7705' , '22' , '20+5' , '186.92' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23191' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23191' , '134' , '1' ) 14/11/2024 12:39:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94265' , '23183' , 'GRUPPO NATIVITA\' CM 28 - PB18076' , '1' , '0' , '1' , '29.8000' , '24.4262' , '22' , '5' , '34.54' ) 14/11/2024 12:39:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23183' AND id_supplier = '134' 14/11/2024 12:39:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23183' , '134' , '1' ) 14/11/2024 12:47:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 12:47:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '229' , '2024-11-14' , '' , '541' , '0' , '4671522' , 'VIA GALLIANO 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '125.50' , '125.50' , NOW() , NOW() ) 14/11/2024 12:47:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94266' 14/11/2024 12:47:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '94266' 14/11/2024 12:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94266' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '50' , '-50' , '4' , '2.80' , '2.8' , '0' , '15' , '119.00' ) 14/11/2024 12:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94266' , '1747' , 'CARTONCINO PADRE NOSTRO' , '50' , '-50' , '4' , '0.13' , '0.13' , '0' , '0' , '6.50' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '681500' , '2024-11-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.32' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '80.67' , '80.67' , NOW() , NOW() ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94267' 14/11/2024 12:50:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94267' 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '23195' , 'SALE E PEPE NELLA LITURGIA - E. MASSINI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23195' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23195' , '7' , '1' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '17377' , 'SAMARITANUS BONUS' , '1' , '1' , '4' , '2.20' , '2.2' , '0' , '33' , '1.4740' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17377' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17377' , '7' , '1' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '23138' , 'VIZI E VIRTU - PAPA FRANCESCO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23138' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23138' , '7' , '1' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '22875' , 'AMEN - DIC 24' , '3' , '3' , '4' , '3.90' , '3.9' , '0' , '33' , '7.8390' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22875' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22875' , '7' , '1' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' , '3' , '4' , '16.00' , '16' , '0' , '33' , '32.1600' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23131' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23131' , '7' , '1' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '23017' , 'GRIDIAMO IL VANGELO - ANNO C - COMASTRI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23017' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23017' , '7' , '1' ) 14/11/2024 12:50:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94267' , '22091' , '10 OTTIMI MOTIVI PER CONFESSARSI - A. COMASTRI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '30' , '3.5000' ) 14/11/2024 12:50:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22091' AND id_supplier = '7' 14/11/2024 12:50:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22091' , '7' , '1' ) 14/11/2024 03:53:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3482' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 03:53:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3482' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.53' , '184.88' , NOW() , NOW() ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94268' 14/11/2024 03:53:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '94268' 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22708' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22705' , 'NUDE DOMANDE DEL VANGELO - E. RONCHI' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22703' , 'UNA LOTTA PER LA VITA - E. BIANCHI' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22707' , 'CUORI INQUIETI - G. RAVASI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22704' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '23194' , 'DILEXIT NOS - 8992' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '23062' , 'SCANDALO DELLA SPERANZA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '21646' , 'PERDONATI - QUADERNO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 14/11/2024 03:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94268' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 14/11/2024 03:57:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '116/A' AND id_document != '93939' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-29') 14/11/2024 03:57:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '116/A', document_date = '2024-10-29', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '473.70', price_tax_excluded = '473.70', date_upd = NOW() WHERE id_document = '93939' 14/11/2024 03:57:31 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 = '93939' 14/11/2024 03:57:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93939' 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '0' , '5.50' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '0' , '98.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '0' , '11.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.8000' , '2.8' , '0' , '0' , '70.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '0' , '39.20' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '0' , '11.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5457' , 'IO SONO CON VOI 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '0' , '64.40' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '0' , '53.20' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '13397' , 'MIO GESU' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '0' , '70.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '0' , '2.40' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 14/11/2024 03:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93939' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/11/2024 04:07:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3447' AND id_document != '94215' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-12') 14/11/2024 04:07:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3447', document_date = '2024-11-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '94215' 14/11/2024 04:07:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94215' 14/11/2024 04:07:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94215' 14/11/2024 04:07:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94215' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 14/11/2024 04:10:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2891' AND id_document != '93417' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-02') 14/11/2024 04:10:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2891', document_date = '2024-10-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '93417' 14/11/2024 04:10:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93417' 14/11/2024 04:10:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '93417' 14/11/2024 04:10:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93417' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 14/11/2024 04:10:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93417' , '12631' , 'QUADRO DECORATO SAGOMATO 83X60' , '1' , '-1' , '1' , '145' , '118.85245901639' , '22' , '0' , '145.00' ) 14/11/2024 04:18:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 04:18:17 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' , '3483' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.40' , '17.40' , NOW() , NOW() ) 14/11/2024 04:18:17 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 = '94269' 14/11/2024 04:18:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94269' 14/11/2024 04:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94269' , '23196' , 'DILEXIT NOS' , '6' , '-6' , '4' , '2.90' , '2.9' , '0' , '0' , '17.40' ) 14/11/2024 04:39:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 04:39: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' , '3484' , '2024-11-14' , '' , '0' , '0' , '0' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1647.20' , '1647.20' , NOW() , NOW() ) 14/11/2024 04:39: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 = '94270' 14/11/2024 04:39:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94270' 14/11/2024 04:39: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 ( '94270' , '10748' , 'TU MI CHIAMI PER NOME' , '61' , '-61' , '4' , '6.3000' , '6.3' , '0' , '0' , '384.30' ) 14/11/2024 04:39: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 ( '94270' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '69' , '-69' , '4' , '5.4000' , '5.4' , '0' , '0' , '372.60' ) 14/11/2024 04:39: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 ( '94270' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '71' , '-71' , '4' , '5.4000' , '5.4' , '0' , '0' , '383.40' ) 14/11/2024 04:39: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 ( '94270' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '34' , '-34' , '4' , '4.5000' , '4.5' , '0' , '0' , '153.00' ) 14/11/2024 04:39: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 ( '94270' , '17229' , 'FELICI SUI PASSI DI GESU\' - 5 - SUSSIDIO' , '25' , '-25' , '4' , '4.5000' , '4.5' , '0' , '0' , '112.50' ) 14/11/2024 04:39: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 ( '94270' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '142' , '-142' , '4' , '1.0000' , '1' , '0' , '5' , '134.90' ) 14/11/2024 04:39: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 ( '94270' , '22450' , 'DIO E\' SEMPRE CON NOI' , '25' , '-25' , '4' , '1.9000' , '1.9' , '0' , '5' , '45.13' ) 14/11/2024 04:39: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 ( '94270' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '34' , '-34' , '4' , '1.9000' , '1.9' , '0' , '5' , '61.37' ) 14/11/2024 04:51:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2355' AND id_document != '92732' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 14/11/2024 04:51:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2355', document_date = '2024-07-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '92732' 14/11/2024 04:51:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92732' 14/11/2024 04:51:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '92732' 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '15133' , 'CAMICE IN CANAPA BIANCO' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '19795' , 'STOLA IN ASSISI CON RICAMO - 633' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '18390' , 'BRACCIALE 10 ESSENZE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '22317' , 'CASULA PERSONALIZZATA' , '4' , '-4' , '1' , '85' , '69.672131147541' , '22' , '0' , '340.00' ) 14/11/2024 04:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92732' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 14/11/2024 04:53:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2605' AND id_document != '93033' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-06') 14/11/2024 04:53:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2605', document_date = '2024-09-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '430.00', price_tax_excluded = '352.46', date_upd = NOW() WHERE id_document = '93033' 14/11/2024 04:53:16 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 = '93033' 14/11/2024 04:53:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93033' 14/11/2024 04:53:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93033' , '22317' , 'CASULA PERSONALIZZATA' , '5' , '-5' , '1' , '85' , '69.672131147541' , '22' , '0' , '425.00' ) 14/11/2024 04:53:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93033' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 14/11/2024 04:54:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3077' AND id_document != '93669' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-17') 14/11/2024 04:54:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3077', document_date = '2024-10-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '113.36', price_tax_excluded = '101.42', date_upd = NOW() WHERE id_document = '93669' 14/11/2024 04:54:06 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 = '93669' 14/11/2024 04:54:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93669' 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '22202' , 'MANUALE DEL PERFETTO CHIERICHETTO - D. COSO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '2' , '-2' , '4' , '19.5000' , '19.5' , '0' , '5' , '37.06' ) 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '16' , '-16' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '4.00' ) 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 14/11/2024 04:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93669' , '17986' , 'PATENA 15,5 - 1900' , '1' , '-1' , '1' , '51.00' , '41.803278688525' , '22' , '0' , '51.00' ) 14/11/2024 04:54:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3184' AND id_document != '93837' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 14/11/2024 04:54:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3184', document_date = '2024-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '167.00', price_tax_excluded = '136.89', date_upd = NOW() WHERE id_document = '93837' 14/11/2024 04:54:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93837' 14/11/2024 04:54:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93837' 14/11/2024 04:54:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93837' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '30' , '-30' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '96.00' ) 14/11/2024 04:54:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93837' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '71' , '58.196721311475' , '22' , '0' , '71.00' ) 14/11/2024 04:58:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2743' AND id_document != '93213' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 14/11/2024 04:58:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2743', document_date = '2024-09-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '290.00', price_tax_excluded = '237.70', date_upd = NOW() WHERE id_document = '93213' 14/11/2024 04:58:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93213' 14/11/2024 04:58:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '93213' 14/11/2024 04:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93213' , '22317' , 'CASULA PERSONALIZZATA' , '3' , '-3' , '1' , '96' , '78.688524590164' , '22' , '0' , '288.00' ) 14/11/2024 04:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93213' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 14/11/2024 05:01:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 05:01:15 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' , '3485' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 14/11/2024 05:01:15 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 = '94271' 14/11/2024 05:01:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94271' 14/11/2024 05:01:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94271' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 14/11/2024 05:02:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3089' AND id_document != '93693' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-18') 14/11/2024 05:02:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3089', document_date = '2024-10-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '300.00', price_tax_excluded = '251.04', date_upd = NOW() WHERE id_document = '93693' 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93693' 14/11/2024 05:02:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93693' 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93693' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93693' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93693' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93693' , '18947' , 'CLERGY COMODA MISTO - ML' , '1' , '-1' , '1' , '42.9000' , '35.16393442623' , '22' , '0' , '42.90' ) 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93693' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 14/11/2024 05:02:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93693' , '8163' , 'ASTUCCIO PORTA VIATICO DAMASCATO - 23' , '1' , '-1' , '1' , '52.3' , '42.868852459016' , '22' , '0' , '52.30' ) 14/11/2024 05:02:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3307' AND id_document != '94011' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-04') 14/11/2024 05:02:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3307', document_date = '2024-11-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '94011' 14/11/2024 05:02:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94011' 14/11/2024 05:02:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94011' 14/11/2024 05:02:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94011' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 14/11/2024 05:02:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94011' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 14/11/2024 05:02:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94011' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 14/11/2024 05:02:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94011' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 14/11/2024 06:02:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 06:02:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3486' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.84' , '29.84' , NOW() , NOW() ) 14/11/2024 06:02:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94272' 14/11/2024 06:02:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94272' 14/11/2024 06:02:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94272' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 14/11/2024 06:02:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94272' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 14/11/2024 06:02:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94272' , '19618' , 'CARLO ACUTIS' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 14/11/2024 06:02:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94272' , '19953' , 'FELIZ CITTA - GIOCO CARLO ACUTIS' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/11/2024 06:04:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 06:04:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3487' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 14/11/2024 06:04:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94273' 14/11/2024 06:04:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '94273' 14/11/2024 06:04:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94273' , '22363' , 'PRESEPE - 08.F83213' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 14/11/2024 06:15:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 06:15:38 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' , '3488' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 14/11/2024 06:15:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94274' 14/11/2024 06:15:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '94274' 14/11/2024 06:15:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94274' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '7' , '-7' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '5.60' ) 14/11/2024 06:15:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94274' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.00' ) 14/11/2024 06:15:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94274' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 14/11/2024 06:22:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 06:22:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3489' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 14/11/2024 06:22:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94275' 14/11/2024 06:22:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94275' 14/11/2024 06:22:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94275' , '23163' , 'SANTA FILOMENA - 8841' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 14/11/2024 06:45:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 06:45:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3490' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '480.00' , '393.44' , NOW() , NOW() ) 14/11/2024 06:45:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94276' 14/11/2024 06:45:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '94276' 14/11/2024 06:45:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94276' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '10' , '-10' , '1' , '48' , '39.344262295082' , '22' , '0' , '480.00' ) 14/11/2024 07:10:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2364' AND id_document != '92744' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 14/11/2024 07:10:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2364', document_date = '2024-07-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '92744' 14/11/2024 07:10:35 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 = '92744' 14/11/2024 07:10:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '92744' 14/11/2024 07:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92744' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20.1' , '16.475409836066' , '22' , '0' , '20.10' ) 14/11/2024 07:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92744' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 14/11/2024 07:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92744' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 14/11/2024 07:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92744' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.90' , '16.311475409836' , '22' , '0' , '19.90' ) 14/11/2024 07:25:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 07:25:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '230' , '2024-11-14' , '' , '2912' , '0' , '4672779' , 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '110.84' , '110.84' , NOW() , NOW() ) 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94277' 14/11/2024 07:25:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94277' 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94277' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94277' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '15' , '6.38' ) 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94277' , '4120' , 'FEDE NELLO ZAINETTO' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94277' , '12813' , 'MARIA MADRE NOSTRA' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '15' , '12.75' ) 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94277' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '11' , '-11' , '4' , '2.40' , '2.4' , '0' , '15' , '22.44' ) 14/11/2024 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94277' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 14/11/2024 07:25:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3491' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 14/11/2024 07:25:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3491' , '2024-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.25' , '4.30' , NOW() , NOW() ) 14/11/2024 07:25:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94278' 14/11/2024 07:25:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94278' 14/11/2024 07:25:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94278' , '8855' , 'REGISTRO DEL CATECHISTA' , '7' , '-7' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '5.25' )