27/08/2024 08:44:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '577/24' , '2024-08-09' , '24' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '832.00' , '800.00' , NOW() , NOW() ) 27/08/2024 08:44:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92881' 27/08/2024 08:44:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92881' 27/08/2024 08:44:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92881' , '22809' , 'O LUCE BEATISSIMA' , '3000' , '3000' , '3' , '0.266667' , '0.25641057692308' , '4' , '0' , '832.0010' ) 27/08/2024 08:44:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22809' AND id_supplier = '159' 27/08/2024 08:44:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22809' , '159' , '1' ) 27/08/2024 09:10:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2474' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 09:10:03 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' , '2474' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 27/08/2024 09:10:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92882' 27/08/2024 09:10:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92882' 27/08/2024 09:10:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92882' , '22551' , 'VOTIVE 16X300 - ART. 500 - 1630' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 27/08/2024 09:10:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2475' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 09:10:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2475' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 27/08/2024 09:10:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92883' 27/08/2024 09:10:24 am >> DELETE FROM ps_document_detail WHERE id_document = '92883' 27/08/2024 09:10:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92883' , '22753' , 'MESSA MEDITAZIONE - SETT/OTT 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/08/2024 09:13:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1979' AND id_document != '92284' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-14') 27/08/2024 09:13:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1979', document_date = '2024-06-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.60', price_tax_excluded = '13.68', date_upd = NOW() WHERE id_document = '92284' 27/08/2024 09:13: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 = '92284' 27/08/2024 09:13:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92284' 27/08/2024 09:13: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 ( '92284' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 27/08/2024 09:13: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 ( '92284' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/08/2024 09:13: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 ( '92284' , '16601' , 'PREGHIERE NELLA MALATTIA - 8201' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 27/08/2024 09:13: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 ( '92284' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '2.85' , '2.85' , '0' , '0' , '2.85' ) 27/08/2024 09:18:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2476' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 09:18:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2476' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 27/08/2024 09:18:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92884' 27/08/2024 09:18:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92884' 27/08/2024 09:18:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92884' , '12904' , 'NOVENA DELLE ROSE A S. TERESA LISIEUX' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 27/08/2024 09:38:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2477' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 09:38:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2477' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.10' , '53.04' , NOW() , NOW() ) 27/08/2024 09:38: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 = '92885' 27/08/2024 09:38:53 am >> DELETE FROM ps_document_detail WHERE id_document = '92885' 27/08/2024 09:38: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 ( '92885' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 27/08/2024 09:38: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 ( '92885' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 27/08/2024 09:38: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 ( '92885' , '22707' , 'CUORI INQUIETI - G. RAVASI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 27/08/2024 09:38: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 ( '92885' , '22705' , 'NUDE DOMANDE DEL VANGELO - E. RONCHI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 27/08/2024 10:06:23 am >> SELECT document_num FROM ps_document WHERE document_num = '33/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 10:06:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '33/E' , '2024-08-27' , 'E' , '4112' , '0' , '4679340' , 'VIA ALLENDE 8 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 27/08/2024 10:06:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92886' 27/08/2024 10:06:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92886' 27/08/2024 10:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92886' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 27/08/2024 10:07:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1827' AND id_document != '92095' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 27/08/2024 10:07:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1827', document_date = '2024-05-31', 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 = '91.00', price_tax_excluded = '74.59', date_upd = NOW() WHERE id_document = '92095' 27/08/2024 10:07:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92095' 27/08/2024 10:07:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92095' 27/08/2024 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92095' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/08/2024 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92095' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '30' , '-30' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '36.00' ) 27/08/2024 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92095' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.00' ) 27/08/2024 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92095' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 27/08/2024 10:07:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2110' AND id_document != '92437' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-27') 27/08/2024 10:07:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2110', document_date = '2024-06-27', 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 = '190.00', price_tax_excluded = '155.74', date_upd = NOW() WHERE id_document = '92437' 27/08/2024 10:07:59 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 = '92437' 27/08/2024 10:07:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92437' 27/08/2024 10:07:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92437' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 27/08/2024 10:07:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92437' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 27/08/2024 10:07:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92437' , '22463' , 'CAMICE LEGGERO - 020/06' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 27/08/2024 10:07:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92437' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 27/08/2024 10:07:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92437' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/08/2024 10:09:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2064' AND id_document != '92381' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-22') 27/08/2024 10:09:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2064', document_date = '2024-06-22', 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 = '129.00', price_tax_excluded = '105.74', date_upd = NOW() WHERE id_document = '92381' 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92381' 27/08/2024 10:09:16 am >> DELETE FROM ps_document_detail WHERE id_document = '92381' 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '100' , '0.00' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '1' , '-1' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '1.10' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '100' , '0.00' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '16249' , 'PROFUMATORE' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '22584' , 'CATENINA DORATA CON CROCE - WKSS-0136G' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '22622' , 'BRACCIALE ARG CON CROCI - CRB-003S' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 27/08/2024 10:09:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92381' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 27/08/2024 10:09:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2105' AND id_document != '92430' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-27') 27/08/2024 10:09:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2105', document_date = '2024-06-27', 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.70', price_tax_excluded = '21.57', date_upd = NOW() WHERE id_document = '92430' 27/08/2024 10:09:59 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 = '92430' 27/08/2024 10:09:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92430' 27/08/2024 10:09:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92430' , '13609' , 'APPENDICHIAVI 12X12' , '1' , '-1' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '15.90' ) 27/08/2024 10:09:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92430' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/08/2024 10:09:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92430' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.7000' , '0.7' , '0' , '0' , '2.80' ) 27/08/2024 10:09:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92430' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/08/2024 10:11:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2291' AND id_document != '92654' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-18') 27/08/2024 10:11:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2291', document_date = '2024-07-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '133.00', price_tax_excluded = '110.86', date_upd = NOW() WHERE id_document = '92654' 27/08/2024 10:11:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92654' 27/08/2024 10:11:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92654' 27/08/2024 10:11: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 ( '92654' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 27/08/2024 10:11: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 ( '92654' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '75.00' ) 27/08/2024 10:11: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 ( '92654' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 27/08/2024 10:11: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 ( '92654' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '7' , '6.7307692307692' , '4' , '0' , '7.00' ) 27/08/2024 10:25:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2478' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 10:25:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2478' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.90' , '45.82' , NOW() , NOW() ) 27/08/2024 10:25: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 = '92887' 27/08/2024 10:25:53 am >> DELETE FROM ps_document_detail WHERE id_document = '92887' 27/08/2024 10:25: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 ( '92887' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/08/2024 10:25: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 ( '92887' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 27/08/2024 10:31:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2130' AND id_document != '92466' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-29') 27/08/2024 10:31:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2130', document_date = '2024-06-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '145.00', price_tax_excluded = '124.67', date_upd = NOW() WHERE id_document = '92466' 27/08/2024 10:31: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 = '92466' 27/08/2024 10:31:07 am >> DELETE FROM ps_document_detail WHERE id_document = '92466' 27/08/2024 10:31: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 ( '92466' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '18' , '17.307692307692' , '4' , '0' , '18.00' ) 27/08/2024 10:31: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 ( '92466' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 27/08/2024 10:31: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 ( '92466' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 27/08/2024 10:31: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 ( '92466' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 27/08/2024 10:31: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 ( '92466' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '14.00' ) 27/08/2024 10:31: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 ( '92466' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 27/08/2024 10:47:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2479' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 10:47:09 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' , '2479' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/08/2024 10:47:09 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 = '92888' 27/08/2024 10:47:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92888' 27/08/2024 10:47:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92888' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/08/2024 10:54:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2480' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 10:54:17 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' , '2480' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 27/08/2024 10:54:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92889' 27/08/2024 10:54:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92889' 27/08/2024 10:54:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92889' , '22388' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2024' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 27/08/2024 11:02:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2481' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 11:02:17 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' , '2481' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 27/08/2024 11:02:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92890' 27/08/2024 11:02:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92890' 27/08/2024 11:02:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92890' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 27/08/2024 11:11:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2482' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 11:11:57 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' , '2482' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.43' , NOW() , NOW() ) 27/08/2024 11:11:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92891' 27/08/2024 11:11:57 am >> DELETE FROM ps_document_detail WHERE id_document = '92891' 27/08/2024 11:11:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92891' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 27/08/2024 11:11:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92891' , '17998' , 'MIRACOLOSA CM 13 - 023 MIR/13E' , '1' , '-1' , '1' , '10.3' , '8.4426229508197' , '22' , '0' , '10.30' ) 27/08/2024 12:16:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 12:16: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' , '2483' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 27/08/2024 12:16: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 = '92892' 27/08/2024 12:16:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92892' 27/08/2024 12:16: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 ( '92892' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/08/2024 12:21:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 12:21:43 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' , '2484' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 27/08/2024 12:21:43 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 = '92893' 27/08/2024 12:21:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92893' 27/08/2024 12:21:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92893' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 27/08/2024 12:27:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-27') 27/08/2024 12:27:41 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' , '2485' , '2024-08-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.41' , '28.41' , NOW() , NOW() ) 27/08/2024 12:27:41 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 = '92894' 27/08/2024 12:27:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '92894' 27/08/2024 12:27:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92894' , '12937' , 'CATECHISMO DELLA CHIESA CATTOLICA' , '1' , '-1' , '4' , '29.90' , '29.9' , '0' , '5' , '28.41' ) 27/08/2024 12:36:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '89371' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 27/08/2024 12:36:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '52', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca del Convento dei Padri minimi di Santa Maria della Stella\r\nv. Stella 25 - 80137 Napoli \r\n', 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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '89371' 27/08/2024 12:36:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89371' 27/08/2024 12:36:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89371' 27/08/2024 12:36: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 ( '89371' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 27/08/2024 12:36: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 ( '89371' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 27/08/2024 12:36: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 ( '89371' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 27/08/2024 12:36: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 ( '89371' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/08/2024 12:36: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 ( '89371' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/08/2024 12:36: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 ( '89371' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36: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 ( '89371' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36: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 ( '89371' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/08/2024 12:36: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 ( '89371' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 27/08/2024 12:36: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 ( '89371' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 27/08/2024 12:36: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 ( '89371' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/08/2024 12:36: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 ( '89371' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 27/08/2024 12:36: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 ( '89371' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 27/08/2024 12:36: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 ( '89371' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 27/08/2024 12:36: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 ( '89371' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 27/08/2024 12:36: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 ( '89371' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 27/08/2024 12:36: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 ( '89371' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 27/08/2024 12:36: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 ( '89371' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 27/08/2024 12:36: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 ( '89371' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 27/08/2024 12:36: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 ( '89371' , '20610' , 'SOLE ANCHE DI NOTTE - D. BLAIN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/08/2024 12:36: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 ( '89371' , '22039' , 'VANGELO DI LUCA - G. ROSSE' , '1' , '-1' , '4' , '69.5000' , '69.5' , '0' , '0' , '69.50' ) 27/08/2024 12:36: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 ( '89371' , '22043' , 'MATTEO - R. FABRIS' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 27/08/2024 12:36: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 ( '89371' , '22044' , 'GIOVANNI - R.E. BROWN' , '1' , '-1' , '4' , '66.5000' , '66.5' , '0' , '0' , '66.50' ) 27/08/2024 12:36: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 ( '89371' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36: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 ( '89371' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 27/08/2024 12:36: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 ( '89371' , '3596' , 'DIZIONARIO DI OMILETICA - SODI/TRICCA' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 27/08/2024 12:36: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 ( '89371' , '20985' , 'BIBBIA E LITURGIA - O. VEZZOLI' , '1' , '-1' , '4' , '33.0000' , '33' , '0' , '0' , '33.00' ) 27/08/2024 12:36: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 ( '89371' , '17421' , 'DIALOGO DELLA DIVINA PROVVIDENZA ' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 27/08/2024 12:36: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 ( '89371' , '19054' , 'GRANDE LIBRO DELLE FIABE' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '0' , '39.00' ) 27/08/2024 12:36: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 ( '89371' , '10565' , 'TEOLOGIA DELLA LITURGIA - J. RATZINGER' , '1' , '-1' , '4' , '55.0000' , '55' , '0' , '0' , '55.00' ) 27/08/2024 12:36: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 ( '89371' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/08/2024 12:36: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 ( '89371' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 27/08/2024 12:36: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 ( '89371' , '15122' , 'PREGHIERE PER OGNI GIORNO DELL\'ANNO - 8738' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/08/2024 12:36: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 ( '89371' , '19326' , 'SUL DOLORE - P. CURTAZ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/08/2024 12:36: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 ( '89371' , '13132' , 'IDEA DI RIVELAZIONE - OPERA OMNIA - RATZINGER' , '1' , '-1' , '4' , '75.00' , '75' , '0' , '0' , '75.00' ) 27/08/2024 12:36: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 ( '89371' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1105.5' , '1105.5' , '0' , '0' , '1105.50' ) 27/08/2024 12:36:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2463' AND id_document != '92868' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-26') 27/08/2024 12:36:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2463', document_date = '2024-08-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '71.25', price_tax_excluded = '71.25', date_upd = NOW() WHERE id_document = '92868' 27/08/2024 12:36:52 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 = '92868' 27/08/2024 12:36:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '92868' 27/08/2024 12:36:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92868' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '71.25' , '71.25' , '0' , '0' , '71.25' )