27/12/2024 09:25:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 09:25:37 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' , '4089' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.20' , '13.89' , NOW() , NOW() ) 27/12/2024 09:25:37 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 = '95039' 27/12/2024 09:25:37 am >> DELETE FROM ps_document_detail WHERE id_document = '95039' 27/12/2024 09:25: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 ( '95039' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '1' , '-1' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '11.90' ) 27/12/2024 09:25: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 ( '95039' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 27/12/2024 09:36:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 09:36:46 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' , '4090' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 27/12/2024 09:36:46 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 = '95040' 27/12/2024 09:36:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95040' 27/12/2024 09:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95040' , '1199' , 'BIBBIA TOB - SOFTEN' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 27/12/2024 09:46:01 am >> SELECT document_num FROM ps_document WHERE document_num = '4091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 09:46:01 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' , '4091' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.90' , '58.86' , NOW() , NOW() ) 27/12/2024 09:46:01 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 = '95041' 27/12/2024 09:46:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95041' 27/12/2024 09:46:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95041' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 27/12/2024 09:46:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95041' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/12/2024 09:46:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95041' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/12/2024 09:46:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95041' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '50' , '-50' , '1' , '1' , '0.81967213114754' , '22' , '0' , '50.00' ) 27/12/2024 09:54:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 09:54:02 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' , '4092' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 27/12/2024 09:54: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 = '95042' 27/12/2024 09:54:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95042' 27/12/2024 09:54: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 ( '95042' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 27/12/2024 10:08:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4072' AND id_document != '95022' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-23') 27/12/2024 10:08:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4072', document_date = '2024-12-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '95022' 27/12/2024 10:08:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95022' 27/12/2024 10:08:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95022' 27/12/2024 10:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95022' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 27/12/2024 10:09:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793163' AND id_product != '23331' AND ean13 != '' 27/12/2024 10:09:39 am >> UPDATE ps_product SET id_supplier = '40', reference = '', ean13 = '9788878793163', date_upd = NOW() WHERE id_product = '23331' 27/12/2024 10:09:39 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - FEB/MAR 25', description = '' WHERE id_product = '23331' 27/12/2024 10:09:39 am >> UPDATE ps_product SET wholesale_price = '4.80', on_sale = '0', price = '8.0000' WHERE id_product = '23331' 27/12/2024 10:09:39 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 = '23331' 27/12/2024 10:09:39 am >> DELETE FROM ps_specific_price WHERE id_product = '23331' 27/12/2024 10:18:26 am >> UPDATE ps_document SET id_document_type = '32', document_num = '2024010002210', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '12', id_causal = '0', price_tax_included = '61.83', price_tax_excluded = '61.83', date_upd = NOW() WHERE id_document = '94617' 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94617' 27/12/2024 10:18:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94617' 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '23193' , 'ACCOMPAGNARE NEL CAMMINO MATRIMONIALE ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '35' , '4.55' ) 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '23269' , 'SIMOLISMO EUCARISTICO NELLAPOCALISSE - A. POMPILI' , '1' , '0' , '4' , '19.5000' , '19.5' , '0' , '35' , '12.68' ) 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '35' , '2.60' ) 27/12/2024 10:18:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '3.25' ) 27/12/2024 10:24: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 ( '32' , '2024010002434' , '2024-12-24' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '149.25' , '149.25' , NOW() , NOW() ) 27/12/2024 10:24: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 = '95043' 27/12/2024 10:24:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95043' 27/12/2024 10:24: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 ( '95043' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '26' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '50.70' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23328' , 'CONOSCERE MARIA E AFFIDARSI A LEI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23328' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23328' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23324' , 'PELLEGRINI DI SPERANZA' , '12' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '23.40' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23324' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23324' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23324' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23324' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '0' , '4' , '6' , '6' , '0' , '50' , '3.0000' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '15515' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15515' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23152' , 'MARIA NEL CANTO DEI POPOLI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23152' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23152' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23326' , 'ASCOLTARE, CONDIVIDERE, ORIENTARSI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23326' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23326' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23325' , 'AMARE E INSEGNARE AD AMARE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23325' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23325' , '107' , '1' ) 27/12/2024 10:24: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 ( '95043' , '23327' , 'ABBIAMO CONOSCIUTO LAMORE' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '35' , '10.40' ) 27/12/2024 10:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '23327' AND id_supplier = '107' 27/12/2024 10:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23327' , '107' , '1' ) 27/12/2024 10:30:25 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 ( '32' , '2024010001963' , '2024-10-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '203.36' , '202.19' , NOW() , NOW() ) 27/12/2024 10:30:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95044' 27/12/2024 10:30:25 am >> DELETE FROM ps_document_detail WHERE id_document = '95044' 27/12/2024 10:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '2' , '0' , '4' , '7.0000' , '7' , '0' , '35' , '9.10' ) 27/12/2024 10:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '22995' AND id_supplier = '107' 27/12/2024 10:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22995' , '107' , '1' ) 27/12/2024 10:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '22996' , 'MAESTRO DELLA MISERICORDIA - L. CRIPPA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 27/12/2024 10:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '22996' AND id_supplier = '107' 27/12/2024 10:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22996' , '107' , '1' ) 27/12/2024 10:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 27/12/2024 10:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '22998' AND id_supplier = '107' 27/12/2024 10:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22998' , '107' , '1' ) 27/12/2024 10:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '22997' , 'CALENDARIO DAVVENTO 2024' , '1' , '0' , '1' , '5.33' , '4.3688524590164' , '22' , '0' , '6.5026' ) 27/12/2024 10:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '22997' AND id_supplier = '107' 27/12/2024 10:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22997' , '107' , '1' ) 27/12/2024 10:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '22999' , 'PREGHIERA GRATUITA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 27/12/2024 10:30:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '22999' AND id_supplier = '107' 27/12/2024 10:30:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22999' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '23000' , 'CANTICO DELLE CREATURE SECONDO VAN GOGH' , '1' , '0' , '4' , '7.5000' , '7.5' , '0' , '35' , '4.88' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23000' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23000' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '23001' , 'MISTERO DI UN DIO TRINO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23001' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23001' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '23151' , 'GENERATI DALLA PAROLA - P. ZECCHINI' , '1' , '0' , '4' , '18.5000' , '18.5' , '0' , '35' , '12.03' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23151' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23151' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '23152' , 'MARIA NEL CANTO DEI POPOLI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23152' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23152' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '23153' , 'CANTICO DELLE CREATURE' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '35' , '5.20' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23153' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23153' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22998' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22998' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '13780' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13780' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '20191' , 'LITURGIA UNINTRODUZIONE' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20191' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20191' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '23154' , 'SAN FRANCESCO STIMMATIZZATO' , '1' , '0' , '4' , '42.0000' , '42' , '0' , '35' , '27.30' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23154' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23154' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '4' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '7.80' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 27/12/2024 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95044' , '18183' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - G. DE VIRGILIO' , '1' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '26.00' ) 27/12/2024 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '18183' AND id_supplier = '107' 27/12/2024 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18183' , '107' , '1' ) 27/12/2024 10:39:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 10:39:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4093' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 27/12/2024 10:39:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95045' 27/12/2024 10:39:54 am >> DELETE FROM ps_document_detail WHERE id_document = '95045' 27/12/2024 10:39:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95045' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 27/12/2024 10:42:26 am >> SELECT document_num FROM ps_document WHERE document_num = '4094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 10:42:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4094' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 27/12/2024 10:42:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95046' 27/12/2024 10:42:26 am >> DELETE FROM ps_document_detail WHERE id_document = '95046' 27/12/2024 10:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95046' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/12/2024 10:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95046' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/12/2024 10:47:21 am >> SELECT document_num FROM ps_document WHERE document_num = '4095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 10:47: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' , '4095' , '2024-12-27' , '' , '0' , '0' , '0' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1079.80' , '885.08' , NOW() , NOW() ) 27/12/2024 10:47: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 = '95047' 27/12/2024 10:47:21 am >> DELETE FROM ps_document_detail WHERE id_document = '95047' 27/12/2024 10:47: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 ( '95047' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.1803' , '22' , '0' , '975.00' ) 27/12/2024 10:47: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 ( '95047' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.0164' , '22' , '0' , '9.80' ) 27/12/2024 10:47: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 ( '95047' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.2787' , '22' , '0' , '65.00' ) 27/12/2024 10:47: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 ( '95047' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475' , '22' , '0' , '7.50' ) 27/12/2024 10:47: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 ( '95047' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.5000' , '6.1475' , '22' , '0' , '22.50' ) 27/12/2024 10:56:38 am >> SELECT document_num FROM ps_document WHERE document_num = '140/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 10:56:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '140/A' , '2024-12-27' , 'A' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '335.83' , '301.57' , NOW() , NOW() ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95048' 27/12/2024 10:56:38 am >> DELETE FROM ps_document_detail WHERE id_document = '95048' 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.75' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23324' , 'PELLEGRINI DI SPERANZA' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '3' , '-3' , '4' , '42.00' , '42' , '0' , '5' , '119.70' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 27/12/2024 10:56:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95048' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 27/12/2024 11:18:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:18:02 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' , '4096' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.50' , '79.02' , NOW() , NOW() ) 27/12/2024 11:18: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 = '95049' 27/12/2024 11:18:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95049' 27/12/2024 11:18: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 ( '95049' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/12/2024 11:18: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 ( '95049' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 27/12/2024 11:18: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 ( '95049' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 27/12/2024 11:18: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 ( '95049' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 27/12/2024 11:18:42 am >> SELECT document_num FROM ps_document WHERE document_num = '4097' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:18: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' , '4097' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.05' , '14.05' , NOW() , NOW() ) 27/12/2024 11:18: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 = '95050' 27/12/2024 11:18:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95050' 27/12/2024 11:18: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 ( '95050' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 27/12/2024 11:18: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 ( '95050' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '0' , '6.00' ) 27/12/2024 11:18: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 ( '95050' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 27/12/2024 11:19:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4098' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:19:25 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' , '4098' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 27/12/2024 11:19:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95051' 27/12/2024 11:19:25 am >> DELETE FROM ps_document_detail WHERE id_document = '95051' 27/12/2024 11:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95051' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 27/12/2024 11:22:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4095' AND id_document != '95047' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:22:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4095', document_date = '2024-12-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '1079.80', price_tax_excluded = '885.08', date_upd = NOW() WHERE id_document = '95047' 27/12/2024 11:22:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95047' 27/12/2024 11:22:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95047' 27/12/2024 11:22:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95047' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 27/12/2024 11:22:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95047' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 27/12/2024 11:22:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95047' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 27/12/2024 11:22:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95047' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/12/2024 11:22:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95047' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '22.50' ) 27/12/2024 11:31:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:31:06 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' , '4099' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.30' , '16.87' , NOW() , NOW() ) 27/12/2024 11:31:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95052' 27/12/2024 11:31:06 am >> DELETE FROM ps_document_detail WHERE id_document = '95052' 27/12/2024 11:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95052' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 27/12/2024 11:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95052' , '23196' , 'DILEXIT NOS' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 27/12/2024 11:36:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:36: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' , '4100' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 27/12/2024 11:36: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 = '95053' 27/12/2024 11:36:49 am >> DELETE FROM ps_document_detail WHERE id_document = '95053' 27/12/2024 11:36: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 ( '95053' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 27/12/2024 11:41:07 am >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '94951' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-19') 27/12/2024 11:41:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2024-12-19', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 50,00 - € 110', 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 = '314.90', price_tax_excluded = '280.01', date_upd = NOW() WHERE id_document = '94951' 27/12/2024 11:41:07 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 = '94951' 27/12/2024 11:41:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94951' 27/12/2024 11:41:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '16795' , 'LUMINO 5F ROSSO' , '30' , '-30' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '9.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '40.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '23189' , 'GRUPPO NATIVITA STILIZZATA - PB18073' , '48' , '-48' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '86.40' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '0' , '24/12' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '0' , 'campana vetro natività' , '1' , '-1' , '0' , '110.0000' , '110' , '0' , '0' , '110.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 27/12/2024 11:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94951' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/12/2024 11:48:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 11:48:13 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' , '4101' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.62' , '22.62' , NOW() , NOW() ) 27/12/2024 11:48:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95054' 27/12/2024 11:48:13 am >> DELETE FROM ps_document_detail WHERE id_document = '95054' 27/12/2024 11:48: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 ( '95054' , '23142' , 'MESSA MEDITAZIONE - GEN/FEB 2025' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/12/2024 11:48: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 ( '95054' , '23331' , 'MESSA MEDITAZIONE - FEB/MAR 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/12/2024 11:48: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 ( '95054' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/12/2024 11:48: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 ( '95054' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/12/2024 12:13:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 12:13:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4102' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.30' , '46.72' , NOW() , NOW() ) 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95055' 27/12/2024 12:13:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '95055' 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95055' , '22630' , 'BRACCIALE ARG - ASB925-0711S' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95055' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95055' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95055' , '7290' , 'SCATOLA CONFETTI CON CALAMITA' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95055' , '23142' , 'MESSA MEDITAZIONE - GEN/FEB 2025' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/12/2024 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95055' , '23331' , 'MESSA MEDITAZIONE - FEB/MAR 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/12/2024 12:15:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 12:15: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' , '4103' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 27/12/2024 12:15: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 = '95056' 27/12/2024 12:15:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95056' 27/12/2024 12:15: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 ( '95056' , '2824' , 'COSTITUZIONI DEL VATICANO II - CONCILIO VATICANO II' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 27/12/2024 12:36:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 12:36:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4104' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/12/2024 12:36:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95057' 27/12/2024 12:36:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95057' 27/12/2024 12:36:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95057' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/12/2024 12:43:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4070' AND id_document != '95019' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-23') 27/12/2024 12:43:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4070', document_date = '2024-12-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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '95019' 27/12/2024 12:43:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95019' 27/12/2024 12:43:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '95019' 27/12/2024 12:43:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95019' , '19883' , 'ALBERO DELLA VITA LUMINOSO - 4425' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/12/2024 12:43:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95019' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/12/2024 12:43:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95019' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 27/12/2024 12:43:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '4069' AND id_document != '95018' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-23') 27/12/2024 12:43:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4069', document_date = '2024-12-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 = '6.20', price_tax_excluded = '5.08', date_upd = NOW() WHERE id_document = '95018' 27/12/2024 12:43:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95018' 27/12/2024 12:43:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '95018' 27/12/2024 12:43:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95018' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 27/12/2024 12:43:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95018' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 27/12/2024 12:43:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95018' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/12/2024 12:43:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95018' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/12/2024 12:49:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '4105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 12:49:28 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' , '4105' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.60' , '23.44' , NOW() , NOW() ) 27/12/2024 12:49:28 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 = '95058' 27/12/2024 12:49:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '95058' 27/12/2024 12:49:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95058' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 27/12/2024 12:49:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95058' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 27/12/2024 02:36:24 pm >> DELETE FROM ps_document WHERE id_document = '93088' 27/12/2024 02:36:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93088' 27/12/2024 05:14:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 05:14: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' , '4106' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 27/12/2024 05:14: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 = '95059' 27/12/2024 05:14:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '95059' 27/12/2024 05:14: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 ( '95059' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 27/12/2024 05:14: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 ( '95059' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 27/12/2024 05:54:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '4107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 05:54:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4107' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.00' , '63.93' , NOW() , NOW() ) 27/12/2024 05:54:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95060' 27/12/2024 05:54:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95060' 27/12/2024 05:54:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95060' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '40.00' ) 27/12/2024 05:54:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95060' , '23150' , 'LEGGIO IN PLEX - L7' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 27/12/2024 05:55:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 05:55:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4108' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.65' , '8.65' , NOW() , NOW() ) 27/12/2024 05:55:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95061' 27/12/2024 05:55:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '95061' 27/12/2024 05:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95061' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 27/12/2024 05:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95061' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/12/2024 05:56:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 27/12/2024 05:56:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = 'ACCONTO € 165,00 / 25-10-2024 - € 100,00 07/11/2024 + 60,00 27/12', 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 = '688.16', price_tax_excluded = '581.46', date_upd = NOW() WHERE id_document = '90734' 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90734' 27/12/2024 05:56:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90734' 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '6629' , 'MIA PREGHIERA' , '3' , '-3' , '4' , '0.9000' , '0.9' , '0' , '0' , '2.70' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22099' , 'YOUCAT' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '23003' , 'SANTA MESSA - M. MIRTILLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '13086' , 'VENTI SABATI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22981' , 'CALENDARIO PARROCCHIALE 2025' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '5' , '11.31' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '4' , '-4' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '32.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '1515' , 'CALICE CM 15 INT.ORO IHS' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '1251' , 'BOLO CM 14 INT. ORO IHS ' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '8048' , 'PISSIDE CM 14 INT. ORO IHS ' , '1' , '-1' , '1' , '169.0000' , '138.52459016393' , '22' , '0' , '169.00' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/12/2024 05:56:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '7730' , 'PATENA CM 15 IHS - 015BIZ0575' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 27/12/2024 06:07:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '4109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 06:07:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4109' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '13.85' , NOW() , NOW() ) 27/12/2024 06:07:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95062' 27/12/2024 06:07:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95062' 27/12/2024 06:07:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95062' , '13609' , 'APPENDICHIAVI 12X12' , '1' , '-1' , '1' , '15.90' , '13.032786885246' , '22' , '0' , '15.90' ) 27/12/2024 06:07:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95062' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/12/2024 06:25:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '4110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 06:25:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4110' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '780.00' , '639.34' , NOW() , NOW() ) 27/12/2024 06:25:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95063' 27/12/2024 06:25:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95063' 27/12/2024 06:25:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95063' , '20229' , 'BAMBINELLO PASTA DI LEGNO CM 50 - AC289E/50' , '1' , '-1' , '1' , '780' , '639.34426229508' , '22' , '0' , '780.00' ) 27/12/2024 06:44:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '4111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 06:44:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4111' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 27/12/2024 06:44:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95064' 27/12/2024 06:44:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '95064' 27/12/2024 06:44:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95064' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 27/12/2024 07:12:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 07:12:45 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' , '4112' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.90' , '40.08' , NOW() , NOW() ) 27/12/2024 07:12:45 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 = '95065' 27/12/2024 07:12:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '95065' 27/12/2024 07:12:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95065' , '22343' , 'LAMPADA IN CRISTALLO LAVORATA' , '' , '0' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 27/12/2024 07:12:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95065' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/12/2024 07:12:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 07:13:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 07:13: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' , '4113' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.90' , '40.08' , NOW() , NOW() ) 27/12/2024 07:13: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 = '95066' 27/12/2024 07:13:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95066' 27/12/2024 07:13: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 ( '95066' , '22343' , 'LAMPADA IN CRISTALLO LAVORATA' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 27/12/2024 07:13: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 ( '95066' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/12/2024 07:43:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 27/12/2024 07:43:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4114' , '2024-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 27/12/2024 07:43: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 = '95067' 27/12/2024 07:43:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '95067' 27/12/2024 07:43: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 ( '95067' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' )