14/12/2023 08:10:24 am >> SELECT document_num FROM ps_document WHERE document_num = '116' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 08:10: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 ( '21' , '116' , '2023-12-14' , '' , '7023' , '0' , '107350752' , 'VIA SETTE FRATELLI CERVI 16 15040 PECETTO DI VALENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '72.00' , '72.00' , NOW() , NOW() ) 14/12/2023 08:10: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 = '13766' 14/12/2023 08:10:24 am >> DELETE FROM ps_document_detail WHERE id_document = '13766' 14/12/2023 08:10: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 ( '13766' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '4' , '-4' , '4' , '18.00' , '18' , '0' , '0' , '72.00' ) 14/12/2023 09:00:06 am >> SELECT document_num FROM ps_document WHERE document_num = '139/A' AND id_document != '89347' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 14/12/2023 09:00:06 am >> UPDATE ps_document SET id_document_type = '24', document_num = '139/A', document_date = '2023-12-05', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.30', price_tax_excluded = '18.30', date_upd = NOW() WHERE id_document = '89347' 14/12/2023 09:00:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89347' 14/12/2023 09:00:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89347' 14/12/2023 09:00:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89347' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 14/12/2023 09:00:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89347' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 14/12/2023 09:39:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3971' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 09:39:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3971' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 14/12/2023 09:39:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89469' 14/12/2023 09:39:42 am >> DELETE FROM ps_document_detail WHERE id_document = '89469' 14/12/2023 09:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89469' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/12/2023 09:41:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3972' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 09:41:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3972' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 14/12/2023 09:41:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89470' 14/12/2023 09:41:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89470' 14/12/2023 09:41:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89470' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 14/12/2023 09:44:32 am >> SELECT document_num FROM ps_document WHERE document_num = '130/A' AND id_document != '89028' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-18') 14/12/2023 09:44:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '130/A', document_date = '2023-11-18', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = 'ACCONTO € 68,50', 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 = '187.70', price_tax_excluded = '162.72', date_upd = NOW() WHERE id_document = '89028' 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89028' 14/12/2023 09:44:32 am >> DELETE FROM ps_document_detail WHERE id_document = '89028' 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89028' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89028' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '17.80' ) 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89028' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89028' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89028' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 14/12/2023 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89028' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 14/12/2023 10:40:06 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/12/2023 10:40:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21991' , '1' , '' , 'nuovo-prodotto' ) 14/12/2023 10:40:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21991' , '1' , '1' , '2' , NOW() , NOW() ) 14/12/2023 10:40:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21991' , '0' , '1' , '0' , '0' ) 14/12/2023 10:40:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856691061' AND id_product != '21991' AND ean13 != '' 14/12/2023 10:40:58 am >> UPDATE ps_product SET id_supplier = '', reference = 'gondola', ean13 = '9788856691061', date_upd = NOW() WHERE id_product = '21991' 14/12/2023 10:40:58 am >> UPDATE ps_product_lang SET name = 'MIO PRESEPE - PAPA FRANCESCO', description = '' WHERE id_product = '21991' 14/12/2023 10:40:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.9' WHERE id_product = '21991' 14/12/2023 10:40:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.9', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21991' 14/12/2023 10:40:58 am >> DELETE FROM ps_specific_price WHERE id_product = '21991' 14/12/2023 10:40:59 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 = '21991' 14/12/2023 10:40:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21992' , '1' , '' , 'nuovo-prodotto' ) 14/12/2023 10:40:59 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 '21992' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21991' 14/12/2023 10:40:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21992' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21991' 14/12/2023 10:41:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842085706' AND id_product != '21992' AND ean13 != '' 14/12/2023 10:41:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842085706', date_upd = NOW() WHERE id_product = '21992' 14/12/2023 10:41:55 am >> UPDATE ps_product_lang SET name = 'VITA LIQUIDA', description = '' WHERE id_product = '21992' 14/12/2023 10:41:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21992' 14/12/2023 10:41:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '350', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21992' 14/12/2023 10:41:56 am >> DELETE FROM ps_specific_price WHERE id_product = '21992' 14/12/2023 10:41:56 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21992' 14/12/2023 10:41:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21993' , '1' , '' , 'nuovo-prodotto' ) 14/12/2023 10:41:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21993' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21992' 14/12/2023 10:41:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21993' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21992' 14/12/2023 10:42:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804755210' AND id_product != '21993' AND ean13 != '' 14/12/2023 10:42:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804755210', date_upd = NOW() WHERE id_product = '21993' 14/12/2023 10:42:22 am >> UPDATE ps_product_lang SET name = 'CALIFORNIA', description = '' WHERE id_product = '21993' 14/12/2023 10:42:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.5' WHERE id_product = '21993' 14/12/2023 10:42:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.5', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21993' 14/12/2023 10:42:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21993' 14/12/2023 10:42: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 = '21993' 14/12/2023 10:42:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21994' , '1' , '' , 'nuovo-prodotto' ) 14/12/2023 10:42: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 '21994' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21993' 14/12/2023 10:42:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21994' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21993' 14/12/2023 10:42:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804766087' AND id_product != '21994' AND ean13 != '' 14/12/2023 10:42:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804766087', date_upd = NOW() WHERE id_product = '21994' 14/12/2023 10:42:59 am >> UPDATE ps_product_lang SET name = 'DIECI COSE CHE HO IMPARATO', description = '' WHERE id_product = '21994' 14/12/2023 10:42:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '21994' 14/12/2023 10:42:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21994' 14/12/2023 10:42:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21994' 14/12/2023 10:43:00 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21994' 14/12/2023 10:43:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21995' , '1' , '' , 'nuovo-prodotto' ) 14/12/2023 10:43:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21995' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21994' 14/12/2023 10:43:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21995' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21994' 14/12/2023 10:43:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804740254' AND id_product != '21995' AND ean13 != '' 14/12/2023 10:43:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804740254', date_upd = NOW() WHERE id_product = '21995' 14/12/2023 10:43:29 am >> UPDATE ps_product_lang SET name = 'TUTTE LE POESIE - G. GIUDICI', description = '' WHERE id_product = '21995' 14/12/2023 10:43:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '21995' 14/12/2023 10:43:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21995' 14/12/2023 10:43:29 am >> DELETE FROM ps_specific_price WHERE id_product = '21995' 14/12/2023 10:43:30 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 = '21995' 14/12/2023 10:43:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21996' , '1' , '' , 'nuovo-prodotto' ) 14/12/2023 10:43:30 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 '21996' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21995' 14/12/2023 10:43:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21996' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21995' 14/12/2023 10:47:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1246617' , '2023-12-12' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '169.00' , '169.00' , NOW() , NOW() ) 14/12/2023 10:47: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 = '89471' 14/12/2023 10:47:27 am >> DELETE FROM ps_document_detail WHERE id_document = '89471' 14/12/2023 10:47: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 ( '89471' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '4' , '4' , '4' , '17.90' , '17.9' , '0' , '0' , '71.6000' ) 14/12/2023 10:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21991' AND id_supplier = '177' 14/12/2023 10:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21991' , '177' , '1' ) 14/12/2023 10:47: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 ( '89471' , '21993' , 'CALIFORNIA' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 14/12/2023 10:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21993' AND id_supplier = '177' 14/12/2023 10:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21993' , '177' , '1' ) 14/12/2023 10:47: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 ( '89471' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 14/12/2023 10:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21994' AND id_supplier = '177' 14/12/2023 10:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21994' , '177' , '1' ) 14/12/2023 10:47: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 ( '89471' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '1' , '1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 14/12/2023 10:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21991' AND id_supplier = '177' 14/12/2023 10:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21991' , '177' , '1' ) 14/12/2023 10:47: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 ( '89471' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 14/12/2023 10:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21995' AND id_supplier = '177' 14/12/2023 10:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21995' , '177' , '1' ) 14/12/2023 10:47: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 ( '89471' , '21992' , 'VITA LIQUIDA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/12/2023 10:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21992' AND id_supplier = '177' 14/12/2023 10:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21992' , '177' , '1' ) 14/12/2023 11:02:20 am >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '89441' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-12') 14/12/2023 11:02:20 am >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2023-12-12', document_letter = 'A', id_customer = '4073', id_supplier = '', id_address = '4679226', address1 = 'PIAZZA B. GERMANO 84029 SICIGNANO DEGLI ALBURNI', 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 = '1008.70', price_tax_excluded = '1008.70', date_upd = NOW() WHERE id_document = '89441' 14/12/2023 11:02:20 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 = '89441' 14/12/2023 11:02:20 am >> DELETE FROM ps_document_detail WHERE id_document = '89441' 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '0' , 'DETERMINA N. 118 DEL 21/11/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '0' , 'FORNITURA LIBRI PER LA BIBLIOTECA COMUNALE A SEGUITO DI ASSEGNAZIONE CONTRIBUTO - DECRETO MINISTERO ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21983' , 'ORA DARTE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21972' , 'AUTO DA FE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21973' , 'HOMO SACER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21975' , 'ARARAT' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21979' , 'IRIS SELVATICO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21967' , 'MODERNITA LIQUIDA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21969' , 'IO NON SONO UN POETA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21974' , 'FASCISMO ETERNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 14/12/2023 11:02:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 14/12/2023 11:02: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 ( '89441' , '21910' , 'ITALO CALVINO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 11:02: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 ( '89441' , '21911' , 'GEOPOLITICA UMANA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 14/12/2023 11:02: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 ( '89441' , '21913' , 'VITA 3.0' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 14/12/2023 11:02: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 ( '89441' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 14/12/2023 11:02: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 ( '89441' , '21944' , 'APPUNTI 1942-1993' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02: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 ( '89441' , '21948' , 'BUCHI BIANCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/12/2023 11:02: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 ( '89441' , '21946' , 'SALUTZ 1984-1986' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 11:02: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 ( '89441' , '21951' , 'VERSO IL PARADISO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 11:02: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 ( '89441' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02: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 ( '89441' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 11:02: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 ( '89441' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 11:02: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 ( '89441' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 11:02: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 ( '89441' , '21936' , 'KITCHEN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 11:02: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 ( '89441' , '21935' , 'MARIGOLD E ROSE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 11:02: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 ( '89441' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 11:02: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 ( '89441' , '21939' , 'HOMO DEUS' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 14/12/2023 11:02: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 ( '89441' , '21941' , 'SACRO MINORE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 11:02: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 ( '89441' , '21940' , 'CARO PIER PAOLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02: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 ( '89441' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 14/12/2023 11:02: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 ( '89441' , '21952' , 'METAFISICA CONCRETA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 14/12/2023 11:02: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 ( '89441' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 11:02: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 ( '89441' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 14/12/2023 11:02: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 ( '89441' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 11:02: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 ( '89441' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '0' , '18.90' ) 14/12/2023 11:02: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 ( '89441' , '21953' , 'FA BENE O FA MALE?' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 11:02: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 ( '89441' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 14/12/2023 11:02: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 ( '89441' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 11:02: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 ( '89441' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 14/12/2023 11:02: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 ( '89441' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 11:02: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 ( '89441' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 14/12/2023 11:02: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 ( '89441' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 14/12/2023 11:02: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 ( '89441' , '21993' , 'CALIFORNIA' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 14/12/2023 11:02: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 ( '89441' , '21992' , 'VITA LIQUIDA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/12/2023 11:03:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3973' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 11:03:22 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' , '3973' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '80.57' , NOW() , NOW() ) 14/12/2023 11:03:22 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 = '89472' 14/12/2023 11:03:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89472' 14/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89472' , '11328' , 'VIA DELLA FIDUCIA E DELLAMORE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '' , '15.00' ) 14/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89472' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '20' , '16.393442622951' , '22' , '0' , '80.00' ) 14/12/2023 11:18:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3967' AND id_document != '89465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-13') 14/12/2023 11:18:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3967', document_date = '2023-12-13', 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 = '17.80', price_tax_excluded = '14.59', date_upd = NOW() WHERE id_document = '89465' 14/12/2023 11:18: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 = '89465' 14/12/2023 11:18:21 am >> DELETE FROM ps_document_detail WHERE id_document = '89465' 14/12/2023 11:18: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 ( '89465' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 14/12/2023 11:23:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '3474/23' , '2023-12-07' , '23' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '3135.96' , '3015.35' , NOW() , NOW() ) 14/12/2023 11:23:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89473' 14/12/2023 11:23:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89473' 14/12/2023 11:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '16689' , 'OSTIA PAN DI CENA mm80' , '300' , '300' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '363.1680' ) 14/12/2023 11:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 14/12/2023 11:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 14/12/2023 11:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '100' , '100' , '3' , '1.7' , '1.6346153846154' , '4' , '0' , '176.8000' ) 14/12/2023 11:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '22' 14/12/2023 11:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '22' , '1' ) 14/12/2023 11:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '560' , '560' , '3' , '2' , '1.9230769230769' , '4' , '0' , '1164.8000' ) 14/12/2023 11:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 14/12/2023 11:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 14/12/2023 11:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '505' , '505' , '3' , '2.2' , '2.1153846153846' , '4' , '3' , '1120.7768' ) 14/12/2023 11:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '20433' AND id_supplier = '22' 14/12/2023 11:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20433' , '22' , '1' ) 14/12/2023 11:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '7311' , 'OSTIA SOTTILE 74MM' , '250' , '250' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '279.9420' ) 14/12/2023 11:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 14/12/2023 11:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 14/12/2023 11:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '5' , '5' , '3' , '2.5' , '2.4038461538462' , '4' , '0' , '13.0000' ) 14/12/2023 11:23:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '22' 14/12/2023 11:23:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '22' , '1' ) 14/12/2023 11:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '5' , '5' , '3' , '2.1' , '2.0192307692308' , '4' , '0' , '10.9200' ) 14/12/2023 11:23:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '22' 14/12/2023 11:23:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '22' , '1' ) 14/12/2023 11:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89473' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '3' , '3' , '3' , '2.1' , '2.0192307692308' , '4' , '0' , '6.5520' ) 14/12/2023 11:23:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '22' 14/12/2023 11:23:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '22' , '1' ) 14/12/2023 11:47:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3974' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 11:47:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3974' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.02' , '34.02' , NOW() , NOW() ) 14/12/2023 11:47:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89474' 14/12/2023 11:47:48 am >> DELETE FROM ps_document_detail WHERE id_document = '89474' 14/12/2023 11:47:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89474' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '2' , '-2' , '4' , '17.90' , '17.9' , '0' , '5' , '34.02' ) 14/12/2023 11:50:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3975' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 11:50: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 ( '11' , '3975' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 14/12/2023 11:50: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 = '89475' 14/12/2023 11:50:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89475' 14/12/2023 11:50: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 ( '89475' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 14/12/2023 11:57:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3975' AND id_document != '89475' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 11:57:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3975', document_date = '2023-12-14', 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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '89475' 14/12/2023 11:57:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89475' 14/12/2023 11:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89475' 14/12/2023 11:57:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89475' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 14/12/2023 11:57:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89475' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 14/12/2023 11:59:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3976' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 11:59:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3976' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 14/12/2023 11:59:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89476' 14/12/2023 11:59:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89476' 14/12/2023 11:59:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89476' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '2' , '-2' , '1' , '41.90' , '34.344262295082' , '22' , '0' , '83.80' ) 14/12/2023 11:59:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89476' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.2' , '29.672131147541' , '22' , '0' , '36.20' ) 14/12/2023 12:05:57 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7079' 14/12/2023 12:05:57 pm >> 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 ( '7079' , '10' , '200' , '' , 'Carlomagno' , 'Giuseppe' , 'via Varcovalle 5' , '' , '85040' , 'Nemoli ' , '' , '' , '3925036612' , '' , 'crlgpp81l26e409v' , NOW() , NOW() ) 14/12/2023 12:05:57 pm >> UPDATE ps_customer SET email = 'carlomagnogiuseppe81@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7079' 14/12/2023 12:06:14 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7079' 14/12/2023 12:06:14 pm >> 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 ( '7079' , '10' , '200' , '' , 'Carlomagno' , 'Giuseppe' , 'via Varcovalle 5' , '' , '85040' , 'Nemoli ' , '' , '' , '3925036612' , '' , 'crlgpp81l26e409v' , NOW() , NOW() ) 14/12/2023 12:06:14 pm >> UPDATE ps_customer SET email = 'carlomagnogiuseppe81@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7079' 14/12/2023 12:07:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 12:07:03 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' , '117' , '2023-12-14' , '' , '7079' , '0' , '168024543' , 'via Varcovalle 5 85040 Nemoli ' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '56.88' , '56.88' , NOW() , NOW() ) 14/12/2023 12:07:03 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 = '14022' 14/12/2023 12:07:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '14022' 14/12/2023 12:07:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14022' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '21' , '-21' , '4' , '2.38' , '2.38' , '0' , '0' , '49.98' ) 14/12/2023 12:31:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3977' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 12:31:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3977' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '39.42' , NOW() , NOW() ) 14/12/2023 12:31:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89477' 14/12/2023 12:31:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89477' 14/12/2023 12:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89477' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 14/12/2023 12:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89477' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 14/12/2023 02:28:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '89080' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 14/12/2023 02:28:27 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '135/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI - SCONTO 10%', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '686.50', price_tax_excluded = '682.89', date_upd = NOW() WHERE id_document = '89080' 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89080' 14/12/2023 02:28:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89080' 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '0' , '11.90' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18732' , 'CREA IL TUO POPUP CON BABBO NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21661' , 'MIO NATALE DA SCOPRIRE' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21877' , 'CALENDARIO DAVVENTO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21818' , 'GIOCHIAMO CON IL PRESEPE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 14/12/2023 02:28:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21204' , 'MIO GRANDE LIBRO DA COLORARE - FAVOLOSO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '1' , '-1' , '4' , '10.9000' , '10.9' , '0' , '0' , '10.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17511' , 'BIBBIA DEI RAGAZZI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18783' , 'MIA BIBBIA PREFERITA ' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16185' , 'DON BOSCO UN SACERDOTE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14662' , 'GRANDE LIBRO DEI NONNI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16442' , 'CARLO ACUTIS LAMICO DI GESU - 8865' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15431' , 'INSEGNAMI A PREGARE' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17431' , 'DON BOSCO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19831' , 'GENERALE DALLA CHIESA - C. VIRZI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17430' , 'MADRE TERESA - LANGELO DEI POVERI' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17429' , 'DON MILANI - UNA VITA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17428' , 'BADEN- POWELL - UN GENERALE TRA GLI SCOUT' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18742' , 'VIAGGIO DEI TRE RE - B. MASINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21571' , 'BETLEHEM' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '0' , '42.00' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21515' , 'CINQUE PANI D\'ORZO 2024' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 14/12/2023 02:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 14/12/2023 03:00:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 03:00:32 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 ( '25' , '25/L' , '2023-12-14' , 'L' , '3975' , '0' , '4678464' , 'VIA VESCOVADO 4 84014 NOCERA INFERIORE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1878.00' , '1878.00' , NOW() , NOW() ) 14/12/2023 03:00: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 = '89478' 14/12/2023 03:00:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89478' 14/12/2023 03:00: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 ( '89478' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '2' , '4' , '29.0000' , '29' , '0' , '0' , '58.00' ) 14/12/2023 03:00: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 ( '89478' , '21725' , 'GIOVANNI AMENDOLA UNA VITA ....' , '1' , '1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 03:00: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 ( '89478' , '21675' , 'ITALIANI IN GUERRA - UTET' , '1' , '1' , '4' , '1300.0000' , '1300' , '0' , '0' , '1300.00' ) 14/12/2023 03:00: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 ( '89478' , '21676' , 'CRISTIANESIMO 5 VOL. - UTET' , '1' , '1' , '4' , '500.0000' , '500' , '0' , '0' , '500.00' ) 14/12/2023 03:05:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 03:05:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '26/L' , '2023-12-14' , 'L' , '3975' , '0' , '4678464' , 'VIA VESCOVADO 4 84014 NOCERA INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1878.00' , '1878.00' , NOW() , NOW() ) 14/12/2023 03:05:02 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 = '89479' 14/12/2023 03:05:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89479' 14/12/2023 03:05:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89479' , '' , 'FORNITURA LIBRI. CONTRIBUTO ALLE BIBLIOTECHE PER ACQUISTO LIBRI. SOSTEGNO ALL\'EDITORIA LIBRARIA ANNUALITA\' 2023' , '1' , '-1' , '4' , '1878' , '1878' , '0' , '0' , '1878.00' ) 14/12/2023 03:07:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/L' AND id_document != '89479' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 03:07:04 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '26/L', document_date = '2023-12-14', document_letter = 'L', id_customer = '3975', id_supplier = '', id_address = '4678464', address1 = 'VIA VESCOVADO 4 84014 NOCERA INFERIORE', 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 = '1878.00', price_tax_excluded = '1878.00', date_upd = NOW() WHERE id_document = '89479' 14/12/2023 03:07:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89479' 14/12/2023 03:07:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89479' 14/12/2023 03:07:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89479' , '0' , 'FORNITURA LIBRI. CONTRIBUTO ALLE BIBLIOTECHE PER ACQUISTO LIBRI. SOSTEGNO ALL\'EDITORIA LIBRARIA ANNUALITA\' 2023' , '1' , '-1' , '4' , '1878.0000' , '1878' , '0' , '0' , '1878.00' ) 14/12/2023 03:11:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/L' AND id_document != '89479' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 03:11:21 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '26/L', document_date = '2023-12-14', document_letter = 'L', id_customer = '3975', id_supplier = '', id_address = '4678464', address1 = 'VIA VESCOVADO 4 84014 NOCERA INFERIORE', 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 = '1878.00', price_tax_excluded = '1878.00', date_upd = NOW() WHERE id_document = '89479' 14/12/2023 03:11: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 = '89479' 14/12/2023 03:11:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '89479' 14/12/2023 03:11: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 ( '89479' , '' , 'FORNITURA LIBRI CONTRIBUTO ALLE BIBLIOTECHE PER ACQUISTO LIBRI' , '0' , '0' , '4' , '0' , '0' , '0' , '0' , '0.00' ) 14/12/2023 03:11: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 ( '89479' , '' , 'SOSTEGNO ALL\'EDITORIA LIBRARIA ANNUALITA\' 2023.' , '1' , '-1' , '4' , '1878' , '1878' , '0' , '0' , '1878.00' ) 14/12/2023 03:58:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3978' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 03:58: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' , '3978' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.10' , '10.56' , NOW() , NOW() ) 14/12/2023 03:58: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 = '89480' 14/12/2023 03:58:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89480' 14/12/2023 03:58: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 ( '89480' , '21515' , 'CINQUE PANI DORZO 2024' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 14/12/2023 03:58: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 ( '89480' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 14/12/2023 03:58: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 ( '89480' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 14/12/2023 03:58: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 ( '89480' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 14/12/2023 04:14:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3979' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 04:14:09 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' , '3979' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '12.50' , NOW() , NOW() ) 14/12/2023 04:14:09 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 = '89481' 14/12/2023 04:14:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89481' 14/12/2023 04:14: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 ( '89481' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 14/12/2023 04:14: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 ( '89481' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 14/12/2023 04:20:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 04:20:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3980' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '650.00' , '540.84' , NOW() , NOW() ) 14/12/2023 04:20: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 = '89482' 14/12/2023 04:20:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89482' 14/12/2023 04:20: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 ( '89482' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 14/12/2023 04:20: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 ( '89482' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '-2' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '70.00' ) 14/12/2023 04:20: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 ( '89482' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 14/12/2023 04:20: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 ( '89482' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 14/12/2023 04:20: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 ( '89482' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 14/12/2023 04:20: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 ( '89482' , '16960' , 'PALLA CANAPA LINO- 6763C' , '1' , '-1' , '1' , '35.85' , '29.385245901639' , '22' , '0' , '35.85' ) 14/12/2023 04:20: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 ( '89482' , '15874' , 'CARTUCCIA VETRO DIAM. 4 - 1455' , '2' , '-2' , '1' , '10.5' , '8.6065573770492' , '22' , '0' , '21.00' ) 14/12/2023 04:20: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 ( '89482' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '3' , '-3' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '40.50' ) 14/12/2023 04:20: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 ( '89482' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '4' , '-4' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '48.00' ) 14/12/2023 04:20: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 ( '89482' , '6405' , 'MENSA DIAM 40X250 - M4025' , '6' , '-6' , '1' , '2' , '1.6393442622951' , '22' , '0' , '12.00' ) 14/12/2023 04:20: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 ( '89482' , '19643' , 'ENIGMI DELLA BIBBIA - A.A. VALDES' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 14/12/2023 04:20: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 ( '89482' , '18210' , 'QOHELET E GESU - L. MONTI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 14/12/2023 04:22:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '144/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 04:22:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '144/A' , '2023-12-14' , 'A' , '2311' , '0' , '2311' , 'VIA S. PIO X 84043 AGROPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '110.00' , NOW() , NOW() ) 14/12/2023 04:22:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89483' 14/12/2023 04:22:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '89483' 14/12/2023 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89483' , '' , 'tunica greche oro' , '1' , '-1' , '0' , '55' , '55' , '' , '0' , '55.00' ) 14/12/2023 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89483' , '' , 'tunica greche rosso' , '1' , '-1' , '0' , '55' , '55' , '' , '0' , '55.00' ) 14/12/2023 04:45:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3980' AND id_document != '89482' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 04:45:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3980', document_date = '2023-12-14', 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 = '2', id_causal = '0', price_tax_included = '650.00', price_tax_excluded = '540.84', date_upd = NOW() WHERE id_document = '89482' 14/12/2023 04:45: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 = '89482' 14/12/2023 04:45:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89482' 14/12/2023 04:45: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 ( '89482' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 14/12/2023 04:45: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 ( '89482' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '-2' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '70.00' ) 14/12/2023 04:45: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 ( '89482' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 14/12/2023 04:45: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 ( '89482' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 14/12/2023 04:45: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 ( '89482' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '28.00' ) 14/12/2023 04:45: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 ( '89482' , '16960' , 'PALLA CANAPA LINO- 6763C' , '1' , '-1' , '1' , '35.8500' , '29.385245901639' , '22' , '0' , '35.85' ) 14/12/2023 04:45: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 ( '89482' , '15874' , 'CARTUCCIA VETRO DIAM. 4 - 1455' , '2' , '-2' , '1' , '10.5000' , '8.6065573770492' , '22' , '0' , '21.00' ) 14/12/2023 04:45: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 ( '89482' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '3' , '-3' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '40.50' ) 14/12/2023 04:45: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 ( '89482' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '4' , '-4' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '48.00' ) 14/12/2023 04:45: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 ( '89482' , '6405' , 'MENSA DIAM 40X250 - M4025' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 14/12/2023 04:45: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 ( '89482' , '19643' , 'ENIGMI DELLA BIBBIA - A.A. VALDES' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 14/12/2023 04:45: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 ( '89482' , '18210' , 'QOHELET E GESU - L. MONTI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 14/12/2023 04:56:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 04:56:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3981' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 14/12/2023 04:56: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 = '89484' 14/12/2023 04:56:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '89484' 14/12/2023 04:56: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 ( '89484' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 14/12/2023 05:09:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 05:09: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' , '3982' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 14/12/2023 05:09: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 = '89485' 14/12/2023 05:09:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89485' 14/12/2023 05:09: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 ( '89485' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 14/12/2023 05:09: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 ( '89485' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 14/12/2023 05:58:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7079' 14/12/2023 05:58:10 pm >> 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 ( '7079' , '10' , '200' , '' , 'Carlomagno' , 'Giuseppe' , 'via Varco Valle 5' , '' , '85040' , 'Nemoli ' , '' , '' , '3925036612' , '' , 'crlgpp81l26e409v' , NOW() , NOW() ) 14/12/2023 05:58:10 pm >> UPDATE ps_customer SET email = 'carlomagnogiuseppe81@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7079' 14/12/2023 06:25:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 06:25:53 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' , '3983' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '205.20' , '183.02' , NOW() , NOW() ) 14/12/2023 06:25:53 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 = '89486' 14/12/2023 06:25:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89486' 14/12/2023 06:25:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89486' , '20513' , 'QUADRETTO CANDELA - 22/109-NAT04' , '39' , '-39' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '50.70' ) 14/12/2023 06:25:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89486' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '21' , '-21' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '27.30' ) 14/12/2023 06:25:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89486' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '10' , '-10' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '45.00' ) 14/12/2023 06:25:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89486' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '5' , '-5' , '4' , '13.00' , '13' , '0' , '5' , '61.75' ) 14/12/2023 06:25:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89486' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 14/12/2023 06:25:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89486' , '21867' , 'PICCOLO PRINCIPE' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 14/12/2023 06:28:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 06:28:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3984' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.20' , NOW() , NOW() ) 14/12/2023 06:28:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89487' 14/12/2023 06:28:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89487' 14/12/2023 06:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89487' , '20158' , 'CASETTA NATIVITA - 23/97NAT04' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 14/12/2023 06:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89487' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 14/12/2023 06:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89487' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 14/12/2023 06:31:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 06:31:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3985' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.40' , '125.40' , NOW() , NOW() ) 14/12/2023 06:31:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89488' 14/12/2023 06:31:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89488' 14/12/2023 06:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89488' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '10' , '-10' , '4' , '9.00' , '9' , '0' , '5' , '85.50' ) 14/12/2023 06:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89488' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 14/12/2023 06:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89488' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 14/12/2023 06:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89488' , '21987' , 'PENSARE ALLEVOLUZIONE - U. FASOL' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 14/12/2023 06:38:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 06:38:02 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' , '3986' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 14/12/2023 06:38:02 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 = '89489' 14/12/2023 06:38:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89489' 14/12/2023 06:38:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89489' , '13275' , 'NATIVITA CON LED CM 12' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/12/2023 06:40:30 pm >> DELETE FROM ps_document WHERE id_document = '88187' 14/12/2023 06:40:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '88187' 14/12/2023 06:47:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '135/A' AND id_document != '89080' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 14/12/2023 06:47:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '135/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI - SCONTO 10%', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '287.00', price_tax_excluded = '283.39', date_upd = NOW() WHERE id_document = '89080' 14/12/2023 06:47:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89080' 14/12/2023 06:47:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89080' 14/12/2023 06:47:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 06:47:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 06:47:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18732' , 'CREA IL TUO POPUP CON BABBO NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21661' , 'MIO NATALE DA SCOPRIRE' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21877' , 'CALENDARIO DAVVENTO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21818' , 'GIOCHIAMO CON IL PRESEPE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '1' , '-1' , '4' , '10.9000' , '10.9' , '0' , '0' , '10.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '17511' , 'BIBBIA DEI RAGAZZI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '18783' , 'MIA BIBBIA PREFERITA ' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16442' , 'CARLO ACUTIS LAMICO DI GESU - 8865' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21571' , 'BETLEHEM' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/12/2023 06:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89080' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 14/12/2023 06:49:13 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7023' 14/12/2023 06:49:13 pm >> 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 ( '7023' , '10' , '124' , '' , 'CRAVERA' , 'GIANCARLO' , 'VIA SETTE FRATELLI CERVI 16' , '' , '15040' , 'PECETTO DI VALENZA' , '' , '' , '3669329218' , '' , '' , NOW() , NOW() ) 14/12/2023 06:49:13 pm >> UPDATE ps_customer SET email = 'graziacravera@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7023' 14/12/2023 06:53:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '89079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 14/12/2023 06:53:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '831.40', price_tax_excluded = '812.10', date_upd = NOW() WHERE id_document = '89079' 14/12/2023 06:53: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 = '89079' 14/12/2023 06:53:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 14/12/2023 06:53: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 ( '89079' , '20002' , 'GESU BAMBINO DORATO CM 20 - BJ146-20D' , '1' , '-1' , '0' , '21.0000' , '21' , '0' , '0' , '21.00' ) 14/12/2023 06:53: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 ( '89079' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 14/12/2023 06:53: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 ( '89079' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '0' , '34.0000' , '34' , '0' , '0' , '34.00' ) 14/12/2023 06:53: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 ( '89079' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '2' , '-2' , '0' , '18.0000' , '18' , '0' , '0' , '36.00' ) 14/12/2023 06:53: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 ( '89079' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '0' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 14/12/2023 06:53: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 ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 06:53: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 ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 06:53: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 ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '2' , '-2' , '0' , '12.9000' , '12.9' , '0' , '0' , '25.80' ) 14/12/2023 06:53: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 ( '89079' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 14/12/2023 06:53: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 ( '89079' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 14/12/2023 06:53: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 ( '89079' , '16508' , 'ANGELO BIANCO IN RESINA CAMPANA - 4218' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 14/12/2023 06:53: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 ( '89079' , '0' , 'ANGELO 4232' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 14/12/2023 06:53: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 ( '89079' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 14/12/2023 06:53: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 ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 14/12/2023 06:53: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 ( '89079' , '15591' , 'ANGELO CON CAMPANA ARG. - 4216' , '1' , '-1' , '0' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 14/12/2023 06:53: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 ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 14/12/2023 06:53: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 ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 06:53: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 ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '4' , '-4' , '0' , '6.0000' , '6' , '0' , '0' , '24.00' ) 14/12/2023 06:53: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 ( '89079' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '2' , '-2' , '0' , '4.8000' , '4.8' , '0' , '0' , '9.60' ) 14/12/2023 06:53: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 ( '89079' , '20169' , 'croce corpo resina 30x21 - 671/3' , '1' , '-1' , '0' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/12/2023 06:53: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 ( '89079' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 06:53: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 ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 06:53: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 ( '89079' , '20168' , 'croce corpo resina 22x15 - 671/2' , '1' , '-1' , '0' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/12/2023 06:53: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 ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 06:53: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 ( '89079' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.0000' , '28' , '0' , '0' , '28.00' ) 14/12/2023 06:53: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 ( '89079' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB ***immacolata' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 14/12/2023 06:53: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 ( '89079' , '0' , 'QUADRO NUVOLA - QUADRI E QUADRI - € 15,00 CAD****' , '2' , '-2' , '0' , '20.0000' , '20' , '' , '0' , '40.00' ) 14/12/2023 06:53: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 ( '89079' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 14/12/2023 06:53: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 ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 06:53: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 ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 06:53: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 ( '89079' , '13112' , 'SACRO CUORE BABY- 023 SH 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 06:53: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 ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 06:53: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 ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 06:53: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 ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 06:53: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 ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 06:53: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 ( '89079' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '0' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/12/2023 06:53: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 ( '89079' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '0' , '2.0000' , '2' , '0' , '0' , '4.00' ) 14/12/2023 06:53: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 ( '89079' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '0' , '1.0000' , '1' , '' , '0' , '3.00' ) 14/12/2023 06:53: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 ( '89079' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '0' , '12.5000' , '12.5' , '0' , '0' , '25.00' ) 14/12/2023 06:53: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 ( '89079' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '0' , '5.0000' , '5' , '0' , '0' , '10.00' ) 14/12/2023 06:53: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 ( '89079' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '2' , '-2' , '0' , '4.0000' , '4' , '' , '0' , '8.00' ) 14/12/2023 06:53: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 ( '89079' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '0' , '3.0000' , '3' , '' , '0' , '3.00' ) 14/12/2023 06:53: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 ( '89079' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 14/12/2023 06:53: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 ( '89079' , '0' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 14/12/2023 06:53: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 ( '89079' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' , '87.0000' , '71.311475409836' , '22' , '0' , '87.00' ) 14/12/2023 06:55:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 06:55:46 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' , '3987' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 14/12/2023 06:55:46 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 = '89490' 14/12/2023 06:55:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89490' 14/12/2023 06:55:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89490' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 14/12/2023 06:55:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 14/12/2023 06:55:59 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' , '3988' , '2023-12-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 14/12/2023 06:55:59 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 = '89491' 14/12/2023 06:55:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89491' 14/12/2023 06:55:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89491' , '20646' , 'STOLA DIACONALE - 881D' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 14/12/2023 07:08:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '89079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 14/12/2023 07:08:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '279.40', price_tax_excluded = '277.60', date_upd = NOW() WHERE id_document = '89079' 14/12/2023 07:08:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89079' 14/12/2023 07:08:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '1' , '-1' , '0' , '12.9000' , '12.9' , '' , '0' , '12.90' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'ANGELO 4232' , '1' , '-1' , '0' , '9.0000' , '9' , '' , '0' , '9.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '1' , '-1' , '0' , '9.0000' , '9' , '' , '0' , '9.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '2' , '-2' , '0' , '6.0000' , '6' , '' , '0' , '12.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB ***immacolata' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '0' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '0' , '2.0000' , '2' , '0' , '0' , '4.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '0' , '1.0000' , '1' , '0' , '0' , '3.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '0' , '12.5000' , '12.5' , '0' , '0' , '25.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '0' , '5.0000' , '5' , '0' , '0' , '10.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '2' , '-2' , '0' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '0' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/12/2023 07:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 14/12/2023 07:15:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '89079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 14/12/2023 07:15:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '279.40', price_tax_excluded = '277.60', date_upd = NOW() WHERE id_document = '89079' 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89079' 14/12/2023 07:15:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '1' , '-1' , '0' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'ANGELO 4232' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB ***immacolata' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '0' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '0' , '2.0000' , '2' , '0' , '0' , '4.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '0' , '1.0000' , '1' , '0' , '0' , '3.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '0' , '12.5000' , '12.5' , '0' , '0' , '25.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '0' , '5.0000' , '5' , '0' , '0' , '10.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '2' , '-2' , '0' , '4.0000' , '4' , '0' , '0' , '8.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '0' , '3.0000' , '3' , '0' , '0' , '3.00' ) 14/12/2023 07:15:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 14/12/2023 07:25:48 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18271' 14/12/2023 07:25:48 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '18271'