20/12/2024 09:17:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793156' AND id_product != '23142' AND ean13 != '' 20/12/2024 09:17:00 am >> UPDATE ps_product SET id_supplier = '40', reference = '7/4', ean13 = '9788878793156', date_upd = NOW() WHERE id_product = '23142' 20/12/2024 09:17:00 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - GEN/FEB 2025', description = '' WHERE id_product = '23142' 20/12/2024 09:17:00 am >> UPDATE ps_product SET wholesale_price = '4.80', on_sale = '0', price = '8.0000' WHERE id_product = '23142' 20/12/2024 09:17:00 am >> UPDATE ps_product_shop SET wholesale_price = '4.80', price = '8.0000', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23142' 20/12/2024 09:17:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23142' 20/12/2024 09:24:52 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/12/2024 09:24:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23324' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 09:24:52 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23324' , '1' , '1' , '2' , NOW() , NOW() ) 20/12/2024 09:24:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23324' , '0' , '1' , '0' , '0' ) 20/12/2024 09:26:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500099' AND id_product != '23324' AND ean13 != '' 20/12/2024 09:26:04 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791281500099', date_upd = NOW() WHERE id_product = '23324' 20/12/2024 09:26:04 am >> UPDATE ps_product_lang SET name = 'PELLEGRINI DI SPERANZA', description = '' WHERE id_product = '23324' 20/12/2024 09:26:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23324' 20/12/2024 09:26:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '356', id_argoment_default = '54', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23324' 20/12/2024 09:26:04 am >> DELETE FROM ps_specific_price WHERE id_product = '23324' 20/12/2024 09:26:06 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23324' 20/12/2024 09:26:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23325' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 09:26:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23325' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23324' 20/12/2024 09:26:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23325' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23324' 20/12/2024 09:29:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788883337765' AND id_product != '23325' AND ean13 != '' 20/12/2024 09:29:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788883337765', date_upd = NOW() WHERE id_product = '23325' 20/12/2024 09:29:26 am >> UPDATE ps_product_lang SET name = 'AMARE E INSEGNARE AD AMARE', description = '' WHERE id_product = '23325' 20/12/2024 09:29:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '23325' 20/12/2024 09:29:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23325' 20/12/2024 09:29:26 am >> DELETE FROM ps_specific_price WHERE id_product = '23325' 20/12/2024 09:29:28 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23325' 20/12/2024 09:29:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23326' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 09:29:28 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23326' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23325' 20/12/2024 09:29:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23326' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23325' 20/12/2024 09:30:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192059' AND id_product != '23326' AND ean13 != '' 20/12/2024 09:30:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280192059', date_upd = NOW() WHERE id_product = '23326' 20/12/2024 09:30:33 am >> UPDATE ps_product_lang SET name = 'ASCOLTARE, CONDIVIDERE, ORIENTARSI', description = '' WHERE id_product = '23326' 20/12/2024 09:30:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '23326' 20/12/2024 09:30:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '356', id_argoment_default = '54', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23326' 20/12/2024 09:30:33 am >> DELETE FROM ps_specific_price WHERE id_product = '23326' 20/12/2024 09:30:34 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 = '23326' 20/12/2024 09:30:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23327' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 09:30:34 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 '23327' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23326' 20/12/2024 09:30:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23327' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23326' 20/12/2024 09:31:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577331' AND id_product != '23327' AND ean13 != '' 20/12/2024 09:31:38 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788873577331', date_upd = NOW() WHERE id_product = '23327' 20/12/2024 09:31:38 am >> UPDATE ps_product_lang SET name = 'ABBIAMO CONOSCIUTO L\'AMORE', description = '' WHERE id_product = '23327' 20/12/2024 09:31:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23327' 20/12/2024 09:31:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '54', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23327' 20/12/2024 09:31:38 am >> DELETE FROM ps_specific_price WHERE id_product = '23327' 20/12/2024 09:31:39 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 = '23327' 20/12/2024 09:31:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23328' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 09:31:39 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 '23328' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23327' 20/12/2024 09:31:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23328' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23327' 20/12/2024 09:33:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898573639' AND id_product != '23328' AND ean13 != '' 20/12/2024 09:33:00 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788898573639', date_upd = NOW() WHERE id_product = '23328' 20/12/2024 09:33:00 am >> UPDATE ps_product_lang SET name = 'CONOSCERE MARIA E AFFIDARSI A LEI', description = '' WHERE id_product = '23328' 20/12/2024 09:33:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23328' 20/12/2024 09:33:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23328' 20/12/2024 09:33:01 am >> DELETE FROM ps_specific_price WHERE id_product = '23328' 20/12/2024 09:36:34 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' , '2024000006827' , '2024-12-18' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '156.15' , '156.15' , NOW() , NOW() ) 20/12/2024 09:36:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94956' 20/12/2024 09:36:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94956' 20/12/2024 09:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '26' , '26' , '4' , '3.00' , '3' , '0' , '35' , '50.7000' ) 20/12/2024 09:36:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 20/12/2024 09:36:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 20/12/2024 09:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23328' , 'CONOSCERE MARIA E AFFIDARSI A LEI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 20/12/2024 09:36:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23328' AND id_supplier = '107' 20/12/2024 09:36:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23328' , '107' , '1' ) 20/12/2024 09:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23324' , 'PELLEGRINI DI SPERANZA' , '12' , '12' , '4' , '3.00' , '3' , '0' , '35' , '23.4000' ) 20/12/2024 09:36:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23324' AND id_supplier = '107' 20/12/2024 09:36:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23324' , '107' , '1' ) 20/12/2024 09:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '1' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23324' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23324' , '107' , '1' ) 20/12/2024 09:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '35' , '3.9000' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '15515' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15515' , '107' , '1' ) 20/12/2024 09:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 20/12/2024 09:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23152' , 'MARIA NEL CANTO DEI POPOLI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23152' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23152' , '107' , '1' ) 20/12/2024 09:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23326' , 'ASCOLTARE, CONDIVIDERE, ORIENTARSI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23326' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23326' , '107' , '1' ) 20/12/2024 09:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23325' , 'AMARE E INSEGNARE AD AMARE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23325' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23325' , '107' , '1' ) 20/12/2024 09:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94956' , '23327' , 'ABBIAMO CONOSCIUTO LAMORE' , '2' , '2' , '4' , '8.00' , '8' , '0' , '35' , '10.4000' ) 20/12/2024 09:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23327' AND id_supplier = '107' 20/12/2024 09:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23327' , '107' , '1' ) 20/12/2024 09:58:29 am >> SELECT document_num FROM ps_document WHERE document_num = '4021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 09:58:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4021' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 20/12/2024 09:58:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94957' 20/12/2024 09:58:29 am >> DELETE FROM ps_document_detail WHERE id_document = '94957' 20/12/2024 09:58:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94957' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 20/12/2024 10:15:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 10:15: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' , '4022' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.80' , '71.00' , NOW() , NOW() ) 20/12/2024 10:15: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 = '94958' 20/12/2024 10:15:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94958' 20/12/2024 10:15: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 ( '94958' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/12/2024 10:15: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 ( '94958' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 20/12/2024 10:15: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 ( '94958' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/12/2024 10:15: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 ( '94958' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 20/12/2024 10:17:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 10:17: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' , '4023' , '2024-12-20' , '' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.30' , '119.03' , NOW() , NOW() ) 20/12/2024 10:17: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 = '94959' 20/12/2024 10:17:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94959' 20/12/2024 10:17: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 ( '94959' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 20/12/2024 10:17: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 ( '94959' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 20/12/2024 10:17:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.459' , '22' , '0' , '6.00' ) 20/12/2024 10:17:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 20/12/2024 10:17:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 20/12/2024 10:17:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.3000' , '2.7049' , '22' , '0' , '6.60' ) 20/12/2024 10:17:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.4000' , '2.7869' , '22' , '0' , '3.40' ) 20/12/2024 10:17:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 20/12/2024 10:26:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 10:26:49 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' , '4024' , '2024-12-20' , '' , '0' , '0' , '0' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '208.50' , '179.27' , NOW() , NOW() ) 20/12/2024 10:26:49 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 = '94960' 20/12/2024 10:26:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94960' 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '50' , '-50' , '1' , '0.4000' , '0.3279' , '22' , '0' , '20.00' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3654' , '4' , '0' , '17.50' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '17257' , 'IO TI BATTEZZO ' , '10' , '-10' , '4' , '1.8000' , '1.8' , '0' , '0' , '18.00' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '65.0000' , '53.2787' , '22' , '0' , '65.00' ) 20/12/2024 10:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 20/12/2024 10:35:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 10:35:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4025' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 20/12/2024 10:35:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94961' 20/12/2024 10:35:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94961' 20/12/2024 10:35:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94961' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/12/2024 10:41:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3889' AND id_document != '94791' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 20/12/2024 10:41:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3889', document_date = '2024-12-10', 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 = '45.90', price_tax_excluded = '40.85', date_upd = NOW() WHERE id_document = '94791' 20/12/2024 10: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 = '94791' 20/12/2024 10:41:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94791' 20/12/2024 10: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 ( '94791' , '20157' , 'ALBERO DI NATALE - MIX' , '10' , '-10' , '1' , '2.3000' , '1.8852459016393' , '22' , '0' , '23.00' ) 20/12/2024 10: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 ( '94791' , '22907' , 'AGENDINA 2025 - 40827' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 20/12/2024 10: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 ( '94791' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 20/12/2024 10:46:21 am >> SELECT document_num FROM ps_document WHERE document_num = '4026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 10:46:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4026' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '46.15' , NOW() , NOW() ) 20/12/2024 10:46: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 = '94962' 20/12/2024 10:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '94962' 20/12/2024 10:46: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 ( '94962' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/12/2024 10:46: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 ( '94962' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 20/12/2024 10:46:42 am >> SELECT document_num FROM ps_document WHERE document_num = '4027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 10:46: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' , '4027' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 20/12/2024 10:46: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 = '94963' 20/12/2024 10:46:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94963' 20/12/2024 10:46: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 ( '94963' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 20/12/2024 10:50:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3519' AND id_document != '94319' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 20/12/2024 10:50:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3519', document_date = '2024-11-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.00', price_tax_excluded = '3.28', date_upd = NOW() WHERE id_document = '94319' 20/12/2024 10:50: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 = '94319' 20/12/2024 10:50:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94319' 20/12/2024 10:50: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 ( '94319' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 20/12/2024 10:51:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3814' AND id_document != '94708' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 20/12/2024 10:51:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3814', document_date = '2024-12-05', 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 = '10.40', price_tax_excluded = '9.58', date_upd = NOW() WHERE id_document = '94708' 20/12/2024 10:51:02 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 = '94708' 20/12/2024 10:51:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94708' 20/12/2024 10:51:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94708' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 20/12/2024 10:51:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94708' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/12/2024 10:51:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94708' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/12/2024 10:51:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94708' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 20/12/2024 10:52:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3619' AND id_document != '94460' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-23') 20/12/2024 10:52:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3619', document_date = '2024-11-23', 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 = '18.00', price_tax_excluded = '16.54', date_upd = NOW() WHERE id_document = '94460' 20/12/2024 10:52:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94460' 20/12/2024 10:52:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94460' 20/12/2024 10:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94460' , '22519' , 'ALBUM DEL MIO BATTESIMO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 20/12/2024 10:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94460' , '2653' , 'CONFEZIONE CARTONCINO CON BAMBINO - P391' , '7' , '-7' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '4.90' ) 20/12/2024 10:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94460' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 20/12/2024 10:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94460' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '10' , '-10' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '2.00' ) 20/12/2024 10:53:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3776' AND id_document != '94657' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-03') 20/12/2024 10:53:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3776', document_date = '2024-12-03', 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 = '86.90', price_tax_excluded = '71.23', date_upd = NOW() WHERE id_document = '94657' 20/12/2024 10:53: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 = '94657' 20/12/2024 10:53:20 am >> DELETE FROM ps_document_detail WHERE id_document = '94657' 20/12/2024 10:53: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 ( '94657' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 20/12/2024 10:53: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 ( '94657' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 20/12/2024 10:53: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 ( '94657' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 20/12/2024 10:53: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 ( '94657' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '12' , '-12' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '2.40' ) 20/12/2024 10:54:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3699' AND id_document != '94558' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 20/12/2024 10:54:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3699', document_date = '2024-11-28', 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 = '33.00', price_tax_excluded = '27.05', date_upd = NOW() WHERE id_document = '94558' 20/12/2024 10:54:12 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 = '94558' 20/12/2024 10:54:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94558' 20/12/2024 10:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 20/12/2024 10:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '6' , '-6' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '1.80' ) 20/12/2024 10:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' , '4.4' , '3.6065573770492' , '22' , '0' , '4.40' ) 20/12/2024 10:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '23041' , 'CORONA SANTA RITA - 10944' , '1' , '-1' , '1' , '8.8000' , '7.2131147540984' , '22' , '0' , '8.80' ) 20/12/2024 10:54:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3822' AND id_document != '94718' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 20/12/2024 10:54:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3822', document_date = '2024-12-05', 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 = '21.00', price_tax_excluded = '17.57', date_upd = NOW() WHERE id_document = '94718' 20/12/2024 10:54:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94718' 20/12/2024 10:54:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94718' 20/12/2024 10:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/12/2024 10:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/12/2024 10:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '5' , '-5' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '1.00' ) 20/12/2024 10:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 20/12/2024 10:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 20/12/2024 10:55:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '94752' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-07') 20/12/2024 10:55:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3854', document_date = '2024-12-07', 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 = '31.40', price_tax_excluded = '25.74', date_upd = NOW() WHERE id_document = '94752' 20/12/2024 10:55:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94752' 20/12/2024 10:55:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94752' 20/12/2024 10:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '22302' , 'BRUCIA INCENSO CM 11 REGOLABILE' , '1' , '-1' , '1' , '16.5000' , '13.524590163934' , '22' , '0' , '16.50' ) 20/12/2024 10:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '4.70' ) 20/12/2024 10:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.4' , '4.4262295081967' , '22' , '0' , '5.40' ) 20/12/2024 10:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '24' , '-24' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '4.80' ) 20/12/2024 10:56:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '94920' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 20/12/2024 10:56:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3992', document_date = '2024-12-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.30', price_tax_excluded = '7.62', date_upd = NOW() WHERE id_document = '94920' 20/12/2024 10:56:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94920' 20/12/2024 10:56:23 am >> DELETE FROM ps_document_detail WHERE id_document = '94920' 20/12/2024 10:56:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94920' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 20/12/2024 10:56:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94920' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '9' , '-9' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '1.80' ) 20/12/2024 10:57:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '94752' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-07') 20/12/2024 10:57:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3854', document_date = '2024-12-07', 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 = '26.70', price_tax_excluded = '21.89', date_upd = NOW() WHERE id_document = '94752' 20/12/2024 10:57:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94752' 20/12/2024 10:57:03 am >> DELETE FROM ps_document_detail WHERE id_document = '94752' 20/12/2024 10:57:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '22302' , 'BRUCIA INCENSO CM 11 REGOLABILE' , '1' , '-1' , '1' , '16.5000' , '13.524590163934' , '22' , '0' , '16.50' ) 20/12/2024 10:57:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.4000' , '4.4262295081967' , '22' , '0' , '5.40' ) 20/12/2024 10:57:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94752' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '24' , '-24' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '4.80' ) 20/12/2024 10:57:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3979' AND id_document != '94904' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 20/12/2024 10:57:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3979', document_date = '2024-12-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1568.66', price_tax_excluded = '1290.73', date_upd = NOW() WHERE id_document = '94904' 20/12/2024 10:57:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94904' 20/12/2024 10:57:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94904' 20/12/2024 10:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/12/2024 10:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 20/12/2024 10:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 20/12/2024 10:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '6538' , 'MESSA SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/12/2024 10:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '22982' , 'MESSA IN CHIESA INSIEME AI GRANDI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '18370' , 'CAMICE MISTO LANA - 70/000214' , '1' , '-1' , '1' , '315.0000' , '258.19672131148' , '22' , '0' , '315.00' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '22464' , 'CASULA LEGGERA - 1212' , '8' , '-8' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '560.00' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '80.0000' , '65.573770491803' , '22' , '0' , '80.00' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '23168' , 'CAMICE IN MICROFIBRA COCOLLE - 434TPMA' , '3' , '-3' , '1' , '66.6700' , '54.647540983607' , '22' , '0' , '200.01' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 20/12/2024 10:57:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94904' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '25' , '-25' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '5.00' ) 20/12/2024 10:58:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3999' AND id_document != '94933' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 20/12/2024 10:58:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3999', document_date = '2024-12-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '94933' 20/12/2024 10:58:57 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 = '94933' 20/12/2024 10:58:57 am >> DELETE FROM ps_document_detail WHERE id_document = '94933' 20/12/2024 10:58:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94933' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 20/12/2024 10:58:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94933' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 20/12/2024 10:58:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94933' , '22305' , 'NAVETTA CM 13' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 20/12/2024 10:58:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94933' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '9' , '-9' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '1.80' ) 20/12/2024 11:00:44 am >> DELETE FROM ps_document WHERE id_document = '93818' 20/12/2024 11:00:44 am >> DELETE FROM ps_document_detail WHERE id_document = '93818' 20/12/2024 11:00:55 am >> DELETE FROM ps_document WHERE id_document = '94845' 20/12/2024 11:00:55 am >> DELETE FROM ps_document_detail WHERE id_document = '94845' 20/12/2024 11:01:14 am >> SELECT document_num FROM ps_document WHERE document_num = '4023' AND id_document != '94959' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:01:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4023', document_date = '2024-12-20', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA DALMAZIA 6 84121 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 = '136.30', price_tax_excluded = '119.03', date_upd = NOW() WHERE id_document = '94959' 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94959' 20/12/2024 11:01:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94959' 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '6.60' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.4000' , '2.7868852459016' , '22' , '0' , '3.40' ) 20/12/2024 11:01:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94959' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/12/2024 11:04:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '94889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 20/12/2024 11:04:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3966', document_date = '2024-12-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '694.20', price_tax_excluded = '569.02', date_upd = NOW() WHERE id_document = '94889' 20/12/2024 11:04:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94889' 20/12/2024 11:04:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94889' 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '19626' , 'STATUA S .ESPEDITO CM 30 - 642 ' , '1' , '-1' , '1' , '88.0000' , '72.131147540984' , '22' , '0' , '88.00' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '22920' , 'SERVIZIO MESSA GIUBILEO 2025' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '43.5' , '35.655737704918' , '22' , '0' , '43.50' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 20/12/2024 11:04:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94889' , '12749' , 'DALMATICA - 3512/TP' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 20/12/2024 11:19:52 am >> SELECT document_num FROM ps_document WHERE document_num = '4028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:19:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4028' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.70' , '34.18' , NOW() , NOW() ) 20/12/2024 11:19:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94964' 20/12/2024 11:19:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94964' 20/12/2024 11:19:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94964' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO - P762' , '50' , '-50' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '30.00' ) 20/12/2024 11:19:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94964' , '10475' , 'TEALIGHTS X 50 ' , '3' , '-3' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '11.70' ) 20/12/2024 11:25:00 am >> SELECT document_num FROM ps_document WHERE document_num = '4029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:25: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' , '4029' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 20/12/2024 11:25: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 = '94965' 20/12/2024 11:25:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94965' 20/12/2024 11:25: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 ( '94965' , '19970' , 'CALICE - ART 715' , '1' , '-1' , '1' , '290' , '237.70491803279' , '22' , '0' , '290.00' ) 20/12/2024 11:25: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 ( '94965' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 20/12/2024 11:25: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 ( '94965' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 20/12/2024 11:32:05 am >> SELECT document_num FROM ps_document WHERE document_num = '24/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:32:05 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 ( '23' , '24/L' , '2024-12-20' , 'L' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '157.20' , '133.76' , NOW() , NOW() ) 20/12/2024 11:32:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94966' 20/12/2024 11:32:05 am >> DELETE FROM ps_document_detail WHERE id_document = '94966' 20/12/2024 11:32:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94966' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '10' , '-10' , '4' , '3.40' , '3.4' , '0' , '20' , '27.20' ) 20/12/2024 11:32:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94966' , '22923' , 'ROLL UP GIUBILEO 2025' , '2' , '-2' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '130.00' ) 20/12/2024 11:34:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3584' AND id_document != '94409' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 20/12/2024 11:34:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3584', document_date = '2024-11-21', 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 = '68.20', price_tax_excluded = '56.48', date_upd = NOW() WHERE id_document = '94409' 20/12/2024 11:34:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94409' 20/12/2024 11:34:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94409' 20/12/2024 11:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94409' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 20/12/2024 11:34:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94409' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.0400' , '0.04' , '0' , '0' , '3.20' ) 20/12/2024 11:35:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3442' AND id_document != '94209' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-12') 20/12/2024 11:35:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3442', document_date = '2024-11-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '94209' 20/12/2024 11:35:17 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 = '94209' 20/12/2024 11:35:17 am >> DELETE FROM ps_document_detail WHERE id_document = '94209' 20/12/2024 11:35:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94209' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 20/12/2024 11:36:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3987' AND id_document != '94915' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-18') 20/12/2024 11:36:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3987', document_date = '2024-12-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.40', price_tax_excluded = '35.57', date_upd = NOW() WHERE id_document = '94915' 20/12/2024 11:36:12 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 = '94915' 20/12/2024 11:36:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94915' 20/12/2024 11:36:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94915' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 20/12/2024 11:36:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94915' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.3500' , '2.7459016393443' , '22' , '0' , '13.40' ) 20/12/2024 11:36:52 am >> SELECT document_num FROM ps_document WHERE document_num = '4029' AND id_document != '94965' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:36:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4029', document_date = '2024-12-20', 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 = '400.00', price_tax_excluded = '327.87', date_upd = NOW() WHERE id_document = '94965' 20/12/2024 11:36:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94965' 20/12/2024 11:36:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94965' 20/12/2024 11:36:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94965' , '19970' , 'CALICE - ART 715' , '1' , '-1' , '1' , '290.0000' , '237.70491803279' , '22' , '0' , '290.00' ) 20/12/2024 11:36:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94965' , '20116' , 'FATIMA CM 70 - 1037' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 20/12/2024 11:42:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:42:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4030' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 20/12/2024 11:42:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94967' 20/12/2024 11:42:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94967' 20/12/2024 11:42:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94967' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 20/12/2024 11:49:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:49:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4031' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.50' , '85.55' , NOW() , NOW() ) 20/12/2024 11:49:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94968' 20/12/2024 11:49:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94968' 20/12/2024 11:49:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94968' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/12/2024 11:49:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94968' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '13' , '-13' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '45.50' ) 20/12/2024 11:52:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:52:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4032' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '100.00' , NOW() , NOW() ) 20/12/2024 11:52:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94969' 20/12/2024 11:52:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94969' 20/12/2024 11:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94969' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '0' , '100.00' ) 20/12/2024 11:53:10 am >> SELECT document_num FROM ps_document WHERE document_num = '4033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:53:10 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' , '4033' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 20/12/2024 11:53:10 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 = '94970' 20/12/2024 11:53:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94970' 20/12/2024 11:53:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94970' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 20/12/2024 11:53:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94970' , '23142' , 'MESSA MEDITAZIONE - GEN/FEB 2025' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 20/12/2024 11:53:47 am >> DELETE FROM ps_document WHERE id_document = '94970' 20/12/2024 11:53:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94970' 20/12/2024 11:53:53 am >> DELETE FROM ps_document WHERE id_document = '94969' 20/12/2024 11:53:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94969' 20/12/2024 11:56:16 am >> SELECT document_num FROM ps_document WHERE document_num = '4032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 11:56:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4032' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.10' , '56.22' , NOW() , NOW() ) 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94971' 20/12/2024 11:56:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94971' 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94971' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94971' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94971' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94971' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94971' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/12/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94971' , '23142' , 'MESSA MEDITAZIONE - GEN/FEB 2025' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 20/12/2024 11:59:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3313' AND id_document != '94018' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-04') 20/12/2024 11:59:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3313', document_date = '2024-11-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.90', price_tax_excluded = '11.20', date_upd = NOW() WHERE id_document = '94018' 20/12/2024 11:59:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94018' 20/12/2024 11:59:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94018' 20/12/2024 11:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94018' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '3.90' ) 20/12/2024 11:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94018' , '23142' , 'MESSA MEDITAZIONE - GEN/FEB 2025' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 20/12/2024 12:00:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3272' AND id_document != '93964' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-30') 20/12/2024 12:00:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3272', document_date = '2024-10-30', 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 = '151.80', price_tax_excluded = '148.27', date_upd = NOW() WHERE id_document = '93964' 20/12/2024 12:00:14 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 = '93964' 20/12/2024 12:00:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '93964' 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '13310' , 'MARIA BAMBINA - 145' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '14000' , 'GALATEO IN CHIESA' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '11193' , 'VENITE CON ME CAT.' , '10' , '-10' , '4' , '5.5000' , '5.5' , '0' , '5' , '52.30' ) 20/12/2024 12:00:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93964' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '10' , '-10' , '4' , '3.61' , '3.61' , '0' , '0' , '36.10' ) 20/12/2024 12:00:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 12:00:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4033' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.25' , '71.25' , NOW() , NOW() ) 20/12/2024 12:00:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94972' 20/12/2024 12:00:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '94972' 20/12/2024 12:00:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94972' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '5' , '71.25' ) 20/12/2024 12:02:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '4257/2024' , '2024-12-20' , '2024' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '371.49' , '304.50' , NOW() , NOW() ) 20/12/2024 12:02:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94973' 20/12/2024 12:02:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94973' 20/12/2024 12:02:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94973' , '22835' , 'PALLA - 50/361.' , '1' , '0' , '1' , '68' , '55.737704918033' , '22' , '0' , '82.9600' ) 20/12/2024 12:02:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22835' AND id_supplier = '129' 20/12/2024 12:02:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22835' , '129' , '1' ) 20/12/2024 12:02:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94973' , '22836' , 'PALLA - 75/1634' , '3' , '0' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '144.5700' ) 20/12/2024 12:02:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22836' AND id_supplier = '129' 20/12/2024 12:02:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22836' , '129' , '1' ) 20/12/2024 12:02:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94973' , '22838' , 'STOLA LANA/LUREX - 70/5322' , '1' , '0' , '1' , '118' , '96.72131147541' , '22' , '0' , '143.9600' ) 20/12/2024 12:02:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22838' AND id_supplier = '129' 20/12/2024 12:02:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22838' , '129' , '1' ) 20/12/2024 12:02:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3996' AND id_document != '94930' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 20/12/2024 12:02:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3996', document_date = '2024-12-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '34.40', price_tax_excluded = '32.87', date_upd = NOW() WHERE id_document = '94930' 20/12/2024 12:02: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 = '94930' 20/12/2024 12:02:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '94930' 20/12/2024 12:02: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 ( '94930' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 20/12/2024 12:02: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 ( '94930' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/12/2024 12:02: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 ( '94930' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 20/12/2024 12:02: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 ( '94930' , '21800' , 'LAUDATO SI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 20/12/2024 12:02: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 ( '94930' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 20/12/2024 12:02: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 ( '94930' , '22907' , 'AGENDINA 2025 - 40827' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 20/12/2024 12:05:36 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/12/2024 12:05:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23329' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 12:05:36 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23329' , '1' , '1' , '2' , NOW() , NOW() ) 20/12/2024 12:05:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23329' , '0' , '1' , '0' , '0' ) 20/12/2024 12:07:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892247055' AND id_product != '23329' AND ean13 != '' 20/12/2024 12:07:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892247055', date_upd = NOW() WHERE id_product = '23329' 20/12/2024 12:07:03 pm >> UPDATE ps_product_lang SET name = 'GIUBILEO DELLA SPERANZA - FISICHELLA', description = '' WHERE id_product = '23329' 20/12/2024 12:07:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23329' 20/12/2024 12:07:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23329' 20/12/2024 12:07:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '23329' 20/12/2024 12:07:04 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23329' 20/12/2024 12:07:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23330' , '1' , '' , 'nuovo-prodotto' ) 20/12/2024 12:07:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23330' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23329' 20/12/2024 12:07:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23330' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23329' 20/12/2024 12:07:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '685922' , '2024-12-19' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.38' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.71' , '82.71' , NOW() , NOW() ) 20/12/2024 12:07:34 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 = '94974' 20/12/2024 12:07:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94974' 20/12/2024 12:07:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94974' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 20/12/2024 12:07:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16019' AND id_supplier = '7' 20/12/2024 12:07:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16019' , '7' , '1' ) 20/12/2024 12:07:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94974' , '17503' , 'PAROLA DI CRISTO - R. CANTALAMESSA' , '1' , '1' , '4' , '45.00' , '45' , '0' , '33' , '30.1500' ) 20/12/2024 12:07:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17503' AND id_supplier = '7' 20/12/2024 12:07:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17503' , '7' , '1' ) 20/12/2024 12:07:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94974' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 20/12/2024 12:07:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23126' AND id_supplier = '7' 20/12/2024 12:07:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23126' , '7' , '1' ) 20/12/2024 12:07:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94974' , '23329' , 'GIUBILEO DELLA SPERANZA - FISICHELLA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 20/12/2024 12:07:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23329' AND id_supplier = '7' 20/12/2024 12:07:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23329' , '7' , '1' ) 20/12/2024 12:07:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94974' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 20/12/2024 12:07:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23247' AND id_supplier = '7' 20/12/2024 12:07:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23247' , '7' , '1' ) 20/12/2024 12:10:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 12:10:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4034' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 20/12/2024 12:10:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94975' 20/12/2024 12:10:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94975' 20/12/2024 12:10:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94975' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' , '-150' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '45.00' ) 20/12/2024 12:10:13 pm >> DELETE FROM ps_document WHERE id_document = '94902' 20/12/2024 12:10:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94902' 20/12/2024 12:27:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '60/E' AND id_document != '94926' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 20/12/2024 12:27:02 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '60/E', document_date = '2024-12-18', document_letter = 'E', id_customer = '2938', id_supplier = '', id_address = '4678844', address1 = 'VIA ARCIVESCOVATO 31 55100 LUCCA', address2 = '', note = '', price_shipping = '0', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '98.20', date_upd = NOW() WHERE id_document = '94926' 20/12/2024 12:27: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 = '94926' 20/12/2024 12:27:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94926' 20/12/2024 12:27: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 ( '94926' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '15' , '-15' , '4' , '10.0000' , '10' , '0' , '40' , '90.00' ) 20/12/2024 12:27: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 ( '94926' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/12/2024 12:31:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '4034' AND id_document != '94975' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 12:31:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4034', document_date = '2024-12-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '94975' 20/12/2024 12:31:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94975' 20/12/2024 12:31:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94975' 20/12/2024 12:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94975' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' , '-150' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '45.00' ) 20/12/2024 12:39:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-18') 20/12/2024 12:39:34 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2024-12-18', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '143.90', price_tax_excluded = '118.23', date_upd = NOW() WHERE id_document = '94912' 20/12/2024 12:39:34 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 = '94912' 20/12/2024 12:39:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 20/12/2024 12:39:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 20/12/2024 12:39:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '120.00' ) 20/12/2024 12:39:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/12/2024 12:39:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 20/12/2024 12:50:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '4035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 12:50:31 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' , '4035' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '95.21' , NOW() , NOW() ) 20/12/2024 12:50:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94976' 20/12/2024 12:50:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94976' 20/12/2024 12:50:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94976' , '23191' , 'GRUPPO NATIVITA\' CM 20 - PB17025' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 20/12/2024 12:50:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94976' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 20/12/2024 12:50:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94976' , '17415' , 'BIBBIA - SCRUTATE LE SCRITTURE' , '1' , '-1' , '4' , '28' , '28' , '0' , '' , '28.00' ) 20/12/2024 03:39:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '4036' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 03:39:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4036' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 20/12/2024 03:39:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94977' 20/12/2024 03:39:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '94977' 20/12/2024 03:39: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 ( '94977' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 20/12/2024 03:39: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 ( '94977' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 20/12/2024 03:41:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '4037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 03:41:01 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' , '4037' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 20/12/2024 03:41:01 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 = '94978' 20/12/2024 03:41:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94978' 20/12/2024 03:41:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94978' , '19997' , 'GESU BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 20/12/2024 05:01:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 05:01:14 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' , '4038' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 20/12/2024 05:01:14 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 = '94979' 20/12/2024 05:01:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94979' 20/12/2024 05:01:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94979' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 20/12/2024 05:01:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94979' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 20/12/2024 05:05:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 05:05:33 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' , '4039' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 20/12/2024 05:05:33 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 = '94980' 20/12/2024 05:05:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94980' 20/12/2024 05:05:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94980' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 20/12/2024 05:05:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4039' AND id_document != '94980' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 05:05:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4039', document_date = '2024-12-20', 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 = '16.06', price_tax_excluded = '16.06', date_upd = NOW() WHERE id_document = '94980' 20/12/2024 05:05:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94980' 20/12/2024 05:05:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94980' 20/12/2024 05:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94980' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.06' ) 20/12/2024 05:06:04 pm >> DELETE FROM ps_document WHERE id_document = '94980' 20/12/2024 05:06:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94980' 20/12/2024 05:06:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 05:06:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4039' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 20/12/2024 05:06:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94981' 20/12/2024 05:06:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94981' 20/12/2024 05:06:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94981' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 20/12/2024 05:27:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '4040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 05:27:30 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' , '4040' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.30' , '50.11' , NOW() , NOW() ) 20/12/2024 05:27:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94982' 20/12/2024 05:27:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94982' 20/12/2024 05:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94982' , '18353' , 'PORTA ROSARIO IN VELLUTO PICCOLO - 313-NT 4' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 20/12/2024 05:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94982' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.50' , '27.459016393443' , '22' , '0' , '33.50' ) 20/12/2024 05:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94982' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 20/12/2024 05:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94982' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 20/12/2024 05:43:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '138/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 05:43: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 ( '24' , '138/A' , '2024-12-20' , 'A' , '3812' , '0' , '4679440' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '22.73' , NOW() , NOW() ) 20/12/2024 05:43: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 = '94983' 20/12/2024 05:43:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94983' 20/12/2024 05:43: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 ( '94983' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/12/2024 05:43: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 ( '94983' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 20/12/2024 06:24:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '4041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 20/12/2024 06:24:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4041' , '2024-12-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 20/12/2024 06:24:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94984' 20/12/2024 06:24:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '94984' 20/12/2024 06:24:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94984' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' )