30/11/2023 09:29:26 am >> SELECT document_num FROM ps_document WHERE document_num = '235' AND id_document != '88761' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-06') 30/11/2023 09:29:26 am >> UPDATE ps_document SET id_document_type = '21', document_num = '235', document_date = '2023-11-06', document_letter = '', id_customer = '90', id_supplier = '', id_address = '4679176', address1 = 'VIA GIANALI 98051 BARCELLONA POZZO DI GOTTO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '122.40', price_tax_excluded = '122.40', date_upd = NOW() WHERE id_document = '88761' 30/11/2023 09:29: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 = '88761' 30/11/2023 09:29:26 am >> DELETE FROM ps_document_detail WHERE id_document = '88761' 30/11/2023 09:29: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 ( '88761' , '3511' , 'DIO PARLA ALL\'UOMO' , '5' , '-5' , '4' , '12.00' , '12' , '0' , '15' , '51.00' ) 30/11/2023 09:29: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 ( '88761' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '3' , '-3' , '4' , '25.00' , '25' , '0' , '15' , '63.75' ) 30/11/2023 09:29: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 ( '88761' , '15020' , 'PREGARE OGNI GIORNO' , '7' , '-7' , '4' , '1.00' , '1' , '0' , '0' , '7.00' ) 30/11/2023 09:29: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 ( '88761' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 30/11/2023 09:31:29 am >> SELECT document_num FROM ps_document WHERE document_num = '237' AND id_document != '88766' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-06') 30/11/2023 09:31:29 am >> UPDATE ps_document SET id_document_type = '21', document_num = '237', document_date = '2023-11-06', document_letter = '', id_customer = '2604', id_supplier = '', id_address = '4679181', address1 = 'Via S. Stefano 5 62015 MONTE SAN GIUSTO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '147.90', price_tax_excluded = '147.90', date_upd = NOW() WHERE id_document = '88766' 30/11/2023 09:31:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88766' 30/11/2023 09:31:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88766' 30/11/2023 09:31:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88766' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '60' , '-60' , '4' , '2.4000' , '2.4' , '0' , '15' , '122.40' ) 30/11/2023 09:31:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88766' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '8' , '-8' , '4' , '3.40' , '3.4' , '0' , '15' , '23.12' ) 30/11/2023 09:31:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88766' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2.38' , '2.38' , '0' , '0' , '2.38' ) 30/11/2023 09:32:54 am >> SELECT document_num FROM ps_document WHERE document_num = '240' AND id_document != '88790' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-07') 30/11/2023 09:32:54 am >> UPDATE ps_document SET id_document_type = '21', document_num = '240', document_date = '2023-11-07', document_letter = '', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '120.10', price_tax_excluded = '120.10', date_upd = NOW() WHERE id_document = '88790' 30/11/2023 09:32: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 = '88790' 30/11/2023 09:32:54 am >> DELETE FROM ps_document_detail WHERE id_document = '88790' 30/11/2023 09:32: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 ( '88790' , '15020' , 'PREGARE OGNI GIORNO' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '15' , '3.40' ) 30/11/2023 09:32: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 ( '88790' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 30/11/2023 09:32: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 ( '88790' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 30/11/2023 09:32: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 ( '88790' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 30/11/2023 09:32: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 ( '88790' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '7' , '-7' , '4' , '3.4000' , '3.4' , '0' , '15' , '20.23' ) 30/11/2023 09:32: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 ( '88790' , '2679' , 'CONOSCERE GESU' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 30/11/2023 09:32: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 ( '88790' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2023 09:32: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 ( '88790' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 30/11/2023 09:32: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 ( '88790' , '18357' , 'MIE PREGHIERINE N.E.' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 30/11/2023 09:38:29 am >> SELECT document_num FROM ps_document WHERE document_num = '250' AND id_document != '88860' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-09') 30/11/2023 09:38:29 am >> UPDATE ps_document SET id_document_type = '21', document_num = '250', document_date = '2023-11-09', document_letter = '', id_customer = '2857', id_supplier = '', id_address = '4676043', address1 = 'R.NE PATERNO 84025 EBOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '237.15', price_tax_excluded = '237.15', date_upd = NOW() WHERE id_document = '88860' 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88860' 30/11/2023 09:38:29 am >> DELETE FROM ps_document_detail WHERE id_document = '88860' 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88860' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '15' , '-15' , '4' , '3.40' , '3.4' , '0' , '15' , '43.35' ) 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88860' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '10' , '-10' , '4' , '3.40' , '3.4' , '0' , '15' , '28.90' ) 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88860' , '3511' , 'DIO PARLA ALL\'UOMO' , '5' , '-5' , '4' , '12.00' , '12' , '0' , '15' , '51.00' ) 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88860' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '4' , '-4' , '4' , '25.00' , '25' , '0' , '15' , '85.00' ) 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88860' , '15020' , 'PREGARE OGNI GIORNO' , '22' , '-22' , '4' , '1.00' , '1' , '0' , '15' , '18.70' ) 30/11/2023 09:38:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88860' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '15' , '10.20' ) 30/11/2023 09:40:48 am >> SELECT document_num FROM ps_document WHERE document_num = '259' AND id_document != '88916' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-13') 30/11/2023 09:40:48 am >> UPDATE ps_document SET id_document_type = '21', document_num = '259', document_date = '2023-11-13', document_letter = '', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '217.18', price_tax_excluded = '217.18', date_upd = NOW() WHERE id_document = '88916' 30/11/2023 09:40: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 = '88916' 30/11/2023 09:40:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88916' 30/11/2023 09:40: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 ( '88916' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 30/11/2023 09:40: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 ( '88916' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 30/11/2023 09:40: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 ( '88916' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '15' , '1.70' ) 30/11/2023 09:40: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 ( '88916' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 30/11/2023 09:40: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 ( '88916' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 30/11/2023 09:40: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 ( '88916' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 30/11/2023 09:49:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 09:49:44 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' , '3801' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '52.10' , NOW() , NOW() ) 30/11/2023 09:49:44 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 = '89231' 30/11/2023 09:49:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89231' 30/11/2023 09:49:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89231' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/11/2023 09:49:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89231' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '10' , '22.50' ) 30/11/2023 09:50:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 09:50:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3802' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.68' , '15.68' , NOW() , NOW() ) 30/11/2023 09:50:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89232' 30/11/2023 09:50:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89232' 30/11/2023 09:50:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89232' , '6620' , 'MIA IMPRONTA È TUA - GUIDA 1' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/11/2023 09:50:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89232' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 30/11/2023 09:58:12 am >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 09:58:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '300' , '2023-11-30' , '' , '2021' , '0' , '4672489' , 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '616.25' , '616.25' , NOW() , NOW() ) 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89233' 30/11/2023 09:58:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89233' 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '2679' , 'CONOSCERE GESU\'' , '70' , '-70' , '4' , '3.50' , '3.5' , '0' , '15' , '208.25' ) 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '13956' , 'MIRACOLI DI GESU\'' , '70' , '-70' , '4' , '3.00' , '3' , '0' , '15' , '178.50' ) 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '8408' , 'PRENDETE E MANGIATE' , '70' , '-70' , '4' , '3.00' , '3' , '0' , '15' , '178.50' ) 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '15' , '25.50' ) 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 30/11/2023 09:58:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '4120' , 'FEDE NELLO ZAINETTO' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '15' , '15.30' ) 30/11/2023 10:01:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 10:01:55 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' , '3803' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.94' , '53.74' , NOW() , NOW() ) 30/11/2023 10:01:55 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 = '89234' 30/11/2023 10:01:55 am >> DELETE FROM ps_document_detail WHERE id_document = '89234' 30/11/2023 10:01:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89234' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '5' , '-5' , '1' , '2.30' , '1.8852459016393' , '22' , '0' , '11.50' ) 30/11/2023 10:01:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89234' , '15103' , 'GIROCOLLO - 870/24' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 30/11/2023 10:01:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89234' , '21154' , 'ROSARIO CRISTALLO COPPIGLIATO DORATO - 18620' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 30/11/2023 10:01:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89234' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '5' , '-5' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '14.50' ) 30/11/2023 10:01:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89234' , '13879' , 'FORTISSIMI GIOVANI - P. PELLEGRINO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 30/11/2023 10:01:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89234' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '12' , '-12' , '4' , '1.20' , '1.2' , '0' , '5' , '13.68' ) 30/11/2023 10:12:07 am >> DELETE FROM ps_document WHERE id_document = '88943' 30/11/2023 10:12:07 am >> DELETE FROM ps_document_detail WHERE id_document = '88943' 30/11/2023 10:13:10 am >> SELECT document_num FROM ps_document WHERE document_num = '261' AND id_document != '88930' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-13') 30/11/2023 10:13:10 am >> UPDATE ps_document SET id_document_type = '21', document_num = '261', document_date = '2023-11-13', document_letter = '', id_customer = '3543', id_supplier = '', id_address = '4677176', address1 = 'VIA ROMA 1478 30015 CHIOGGIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '76.36', price_tax_excluded = '76.36', date_upd = NOW() WHERE id_document = '88930' 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88930' 30/11/2023 10:13:10 am >> DELETE FROM ps_document_detail WHERE id_document = '88930' 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '20' , '20' , '0' , '15' , '17.00' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '9815' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '15' , '1.27' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 30/11/2023 10:13:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 30/11/2023 10:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 30/11/2023 10:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 30/11/2023 10:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 30/11/2023 10:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 30/11/2023 10:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88930' , '0' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/11/2023 10:18:18 am >> SELECT document_num FROM ps_document WHERE document_num = '282' AND id_document != '89078' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-22') 30/11/2023 10:18:18 am >> UPDATE ps_document SET id_document_type = '21', document_num = '282', document_date = '2023-11-22', document_letter = '', id_customer = '2755', id_supplier = '', id_address = '4677545', address1 = 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '56.71', price_tax_excluded = '56.71', date_upd = NOW() WHERE id_document = '89078' 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89078' 30/11/2023 10:18:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89078' 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21836' , 'DONO PER TUTTI' , '1' , '-1' , '4' , '2.7000' , '2.7' , '0' , '5' , '2.57' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21663' , 'CORAGGIO DI UNA DONNA ' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21875' , 'PASSI DELLA PACE' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21876' , 'VIA CRUCIS' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '5' , '3.80' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21845' , 'VIENI SIGNORE GESU!' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '21833' , '5 CIOTTOLI DI DAVIDE ' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 30/11/2023 10:18:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89078' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '3.125' , '3.125' , '0' , '0' , '6.25' ) 30/11/2023 10:32:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 10:32:32 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' , '3804' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '30.36' , NOW() , NOW() ) 30/11/2023 10:32:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89235' 30/11/2023 10:32:32 am >> DELETE FROM ps_document_detail WHERE id_document = '89235' 30/11/2023 10:32:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89235' , '19991' , 'MED. SCAPOLARE ARG. - RA661' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 30/11/2023 10:32:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89235' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '14.25' , '11.680327868852' , '22' , '0' , '14.25' ) 30/11/2023 10:32:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89235' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/11/2023 10:38:47 am >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '89165' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-27') 30/11/2023 10:38:47 am >> UPDATE ps_document SET id_document_type = '21', document_num = '294', document_date = '2023-11-27', document_letter = '', id_customer = '2085', id_supplier = '', id_address = '4677364', address1 = 'VIA COLLEGIATA 84057 LAURINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '93.04', price_tax_excluded = '93.04', date_upd = NOW() WHERE id_document = '89165' 30/11/2023 10:38:47 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 = '89165' 30/11/2023 10:38:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89165' 30/11/2023 10:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89165' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '6' , '-6' , '4' , '3.4000' , '3.4' , '0' , '15' , '17.34' ) 30/11/2023 10:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89165' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 30/11/2023 10:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89165' , '11191' , 'VENITE CON ME 1 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 30/11/2023 10:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89165' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.4000' , '2.4' , '0' , '15' , '20.40' ) 30/11/2023 10:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89165' , '4120' , 'FEDE NELLO ZAINETTO' , '5' , '-5' , '4' , '6.0000' , '6' , '0' , '15' , '25.50' ) 30/11/2023 10:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89165' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '-6' , '4' , '1.00' , '1' , '0' , '0' , '6.00' ) 30/11/2023 10:40:49 am >> SELECT document_num FROM ps_document WHERE document_num = '299' AND id_document != '89227' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-29') 30/11/2023 10:40:49 am >> UPDATE ps_document SET id_document_type = '21', document_num = '299', document_date = '2023-11-29', document_letter = '', id_customer = '1458', id_supplier = '', id_address = '4679206', address1 = 'VIA SILENTINA 7 84045 ALTAVILLA SILENTINA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '27.67', price_tax_excluded = '27.67', date_upd = NOW() WHERE id_document = '89227' 30/11/2023 10:40: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 = '89227' 30/11/2023 10:40:49 am >> DELETE FROM ps_document_detail WHERE id_document = '89227' 30/11/2023 10:40: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 ( '89227' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '-1' , '4' , '5.1600' , '5.16' , '0' , '5' , '4.90' ) 30/11/2023 10:40: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 ( '89227' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.2000' , '6.2' , '0' , '5' , '5.89' ) 30/11/2023 10:40: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 ( '89227' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 30/11/2023 10:40: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 ( '89227' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/11/2023 10:40: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 ( '89227' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '-6' , '4' , '0.75' , '0.75' , '0' , '5' , '4.28' ) 30/11/2023 10:41:04 am >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '89233' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 10:41:04 am >> UPDATE ps_document SET id_document_type = '21', document_num = '300', document_date = '2023-11-30', document_letter = '', id_customer = '2021', id_supplier = '', id_address = '4672489', address1 = 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '616.25', price_tax_excluded = '616.25', date_upd = NOW() WHERE id_document = '89233' 30/11/2023 10:41:04 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 = '89233' 30/11/2023 10:41:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89233' 30/11/2023 10:41:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '2679' , 'CONOSCERE GESU\'' , '70' , '-70' , '4' , '3.5000' , '3.5' , '0' , '15' , '208.25' ) 30/11/2023 10:41:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '13956' , 'MIRACOLI DI GESU\'' , '70' , '-70' , '4' , '3.0000' , '3' , '0' , '15' , '178.50' ) 30/11/2023 10:41:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '8408' , 'PRENDETE E MANGIATE' , '70' , '-70' , '4' , '3.0000' , '3' , '0' , '15' , '178.50' ) 30/11/2023 10:41:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '15' , '25.50' ) 30/11/2023 10:41:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 30/11/2023 10:41:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89233' , '4120' , 'FEDE NELLO ZAINETTO' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 30/11/2023 10:57:08 am >> SELECT document_num FROM ps_document WHERE document_num = '301' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 10:57:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '301' , '2023-11-30' , '' , '2312' , '0' , '4675584' , 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '34.68' , '34.68' , NOW() , NOW() ) 30/11/2023 10:57: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 = '89236' 30/11/2023 10:57:08 am >> DELETE FROM ps_document_detail WHERE id_document = '89236' 30/11/2023 10:57: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 ( '89236' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '12' , '-12' , '4' , '3.40' , '3.4' , '0' , '15' , '34.68' ) 30/11/2023 11:11:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 11:11:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3805' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.25' , '11.81' , NOW() , NOW() ) 30/11/2023 11:11:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89237' 30/11/2023 11:11:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89237' 30/11/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89237' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '20' , '-20' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '8.00' ) 30/11/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89237' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 30/11/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89237' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/11/2023 11:14:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3806' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 11:14:50 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' , '3806' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.70' , '37.70' , NOW() , NOW() ) 30/11/2023 11:14:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89238' 30/11/2023 11:14:50 am >> DELETE FROM ps_document_detail WHERE id_document = '89238' 30/11/2023 11:14:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89238' , '2518' , 'COMMENTO AL VANGELO DI GIOVANNI - SANTAGOSTINO' , '1' , '-1' , '4' , '29.50' , '29.5' , '0' , '0' , '29.50' ) 30/11/2023 11:14:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89238' , '21677' , 'LAUDATE DEUM ' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 30/11/2023 11:14:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89238' , '11864' , 'PER VINO NUOVO OTRI NUOVI' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 30/11/2023 11:41:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3807' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 11:41:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3807' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '418.15' , '342.75' , NOW() , NOW() ) 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89239' 30/11/2023 11:41:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89239' 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89239' , '14401' , 'BALZA CM 19' , '3.5' , '-3.5' , '1' , '14.3' , '11.72131147541' , '22' , '0' , '50.05' ) 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89239' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '1' , '-1' , '1' , '7.40' , '6.0655737704918' , '22' , '0' , '7.40' ) 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89239' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '1' , '-1' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '6.70' ) 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89239' , '21641' , 'SERVIZIO MESSA TAU - 7553' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89239' , '20264' , 'PIZZO MARIANO - PIZ0M419 - M 3,10' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 30/11/2023 11:41:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89239' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '-1' , '1' , '115' , '94.262295081967' , '22' , '0' , '115.00' ) 30/11/2023 11:54:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 11:54:55 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' , '3808' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 30/11/2023 11:54:55 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 = '89240' 30/11/2023 11:54:55 am >> DELETE FROM ps_document_detail WHERE id_document = '89240' 30/11/2023 11:54:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89240' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 30/11/2023 11:59:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3809' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 11:59: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' , '3809' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.25' , '47.25' , NOW() , NOW() ) 30/11/2023 11:59: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 = '89241' 30/11/2023 11:59:54 am >> DELETE FROM ps_document_detail WHERE id_document = '89241' 30/11/2023 11:59: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 ( '89241' , '16911' , 'DIAVOLI CHI SONO - 8991' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/11/2023 11:59: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 ( '89241' , '19586' , 'UNA MAMMA PER TUTTI - NATUZZA EVOLO - 8072' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 30/11/2023 11:59: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 ( '89241' , '6376' , 'MEDITAZIONI SULLEUCARISTIA - 8712' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/11/2023 11:59: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 ( '89241' , '9993' , 'SIGNORE, DACCI OGGI...' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/11/2023 11:59: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 ( '89241' , '2756' , 'CORONA ANGELICA - 8197' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 30/11/2023 11:59: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 ( '89241' , '19585' , 'PREGHIERE AL SACRO CUORE - 8071' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 30/11/2023 11:59: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 ( '89241' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 30/11/2023 12:31:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '172' , '2023-11-30' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '207.40' , '170.00' , NOW() , NOW() ) 30/11/2023 12:31:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89242' 30/11/2023 12:31:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89242' 30/11/2023 12:31:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89242' , '21424' , 'STOLA ROMANA S. MOIRE - 7248S' , '1' , '0' , '1' , '160' , '131.14754098361' , '22' , '0' , '195.2000' ) 30/11/2023 12:31:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21424' AND id_supplier = '126' 30/11/2023 12:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21424' , '126' , '1' ) 30/11/2023 02:46:00 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/11/2023 02:46:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21917' , '1' , '' , 'nuovo-prodotto' ) 30/11/2023 02:46:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21917' , '1' , '1' , '2' , NOW() , NOW() ) 30/11/2023 02:46:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21917' , '0' , '1' , '0' , '0' ) 30/11/2023 02:47:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608396' AND id_product != '21917' AND ean13 != '' 30/11/2023 02:47:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788826608396', date_upd = NOW() WHERE id_product = '21917' 30/11/2023 02:47:00 pm >> UPDATE ps_product_lang SET name = 'ASCOLTARE PER SERVIRE', description = '' WHERE id_product = '21917' 30/11/2023 02:47:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '21917' 30/11/2023 02:47:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21917' 30/11/2023 02:47:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '21917' 30/11/2023 02:47: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 ( '33' , '3507' , '2023-11-29' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '122.25' , '122.25' , NOW() , NOW() ) 30/11/2023 02:47:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89243' 30/11/2023 02:47:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89243' 30/11/2023 02:47:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89243' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '45' , '5.5000' ) 30/11/2023 02:47:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 30/11/2023 02:47:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 30/11/2023 02:47:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89243' , '21917' , 'ASCOLTARE PER SERVIRE' , '1' , '1' , '4' , '22.00' , '22' , '0' , '45' , '12.1000' ) 30/11/2023 02:47:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21917' AND id_supplier = '79' 30/11/2023 02:47:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21917' , '79' , '1' ) 30/11/2023 02:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89243' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 30/11/2023 02:47:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '79' 30/11/2023 02:47:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '79' , '1' ) 30/11/2023 02:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89243' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '1' , '4' , '90.00' , '90' , '0' , '35' , '58.5000' ) 30/11/2023 02:47:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 30/11/2023 02:47:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 30/11/2023 02:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89243' , '2525' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '1' , '1' , '4' , '13.00' , '13' , '0' , '45' , '7.1500' ) 30/11/2023 02:47:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2525' AND id_supplier = '79' 30/11/2023 02:47:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2525' , '79' , '1' ) 30/11/2023 03:05:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '594' , '2023-11-29' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '14.00' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '186.05' , '152.50' , NOW() , NOW() ) 30/11/2023 03:05:23 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 = '89244' 30/11/2023 03:05:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '89244' 30/11/2023 03:05:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89244' , '16374' , 'CASULA ROSA' , '1' , '0' , '1' , '33.5000' , '27.459' , '22' , '0' , '40.87' ) 30/11/2023 03:05:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16374' AND id_supplier = '122' 30/11/2023 03:05:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16374' , '122' , '1' ) 30/11/2023 03:05:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89244' , '18880' , 'COPRILEGGIO MORELLO' , '2' , '0' , '1' , '25.0000' , '20.4918' , '22' , '0' , '61.00' ) 30/11/2023 03:05:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '122' 30/11/2023 03:05:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '122' , '1' ) 30/11/2023 03:05:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89244' , '21916' , 'TOVAGLIA DALTARE MORELLO' , '1' , '0' , '1' , '55.0000' , '45.082' , '22' , '0' , '67.10' ) 30/11/2023 03:05:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21916' AND id_supplier = '122' 30/11/2023 03:05:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21916' , '122' , '1' ) 30/11/2023 03:14:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884046314' AND id_product != '16911' AND ean13 != '' 30/11/2023 03:14:06 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884046314', date_upd = NOW() WHERE id_product = '16911' 30/11/2023 03:14:06 pm >> UPDATE ps_product_lang SET name = 'DIAVOLI CHI SONO - 8991', description = '' WHERE id_product = '16911' 30/11/2023 03:14:06 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '16911' 30/11/2023 03:14:06 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16911' 30/11/2023 03:14:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '16911' 30/11/2023 03:18:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884044242' AND id_product != '9993' AND ean13 != '' 30/11/2023 03:18:32 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884044242', date_upd = NOW() WHERE id_product = '9993' 30/11/2023 03:18:32 pm >> UPDATE ps_product_lang SET name = 'SIGNORE, DACCI OGGI...', description = '' WHERE id_product = '9993' 30/11/2023 03:18:32 pm >> UPDATE ps_product SET wholesale_price = '5.40', on_sale = '0', price = '9.0000' WHERE id_product = '9993' 30/11/2023 03:18:33 pm >> UPDATE ps_product_shop SET wholesale_price = '5.40', price = '9.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9993' 30/11/2023 03:18:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '9993' 30/11/2023 03:43:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3241' AND id_document != '88405' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-19') 30/11/2023 03:43:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3241', document_date = '2023-10-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '78.92', date_upd = NOW() WHERE id_document = '88405' 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88405' 30/11/2023 03:43:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '88405' 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '5' , '23.80' ) 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 30/11/2023 03:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '5' , '-5' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '3.50' ) 30/11/2023 03:43:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88405' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.25' ) 30/11/2023 05:05:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3810' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 05:05:06 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' , '3810' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.01' , '40.59' , NOW() , NOW() ) 30/11/2023 05:05:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89245' 30/11/2023 05:05:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '89245' 30/11/2023 05:05:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89245' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 30/11/2023 05:05:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89245' , '21866' , 'DIO NON VI LASCIA MAI SOLI - M. ZUPPI' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' ) 30/11/2023 05:05:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89245' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 30/11/2023 05:07:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3811' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 05:07:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3811' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.30' , '8.30' , NOW() , NOW() ) 30/11/2023 05:07:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89246' 30/11/2023 05:07:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89246' 30/11/2023 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89246' , '21810' , 'AMEN - FEB 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 30/11/2023 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89246' , '21809' , 'AMEN - GEN 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 30/11/2023 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89246' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 30/11/2023 05:11:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3812' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 05:11:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3812' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '39.42' , NOW() , NOW() ) 30/11/2023 05:11:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89247' 30/11/2023 05:11:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '89247' 30/11/2023 05:11:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89247' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/11/2023 05:11:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89247' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 30/11/2023 05:13:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3813' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 05:13:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3813' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 30/11/2023 05:13:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89248' 30/11/2023 05:13:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89248' 30/11/2023 05:13:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89248' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 30/11/2023 05:35:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3814' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 05:35: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' , '3814' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.60' , '65.94' , NOW() , NOW() ) 30/11/2023 05:35: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 = '89249' 30/11/2023 05:35:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89249' 30/11/2023 05:35: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 ( '89249' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 30/11/2023 05:35: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 ( '89249' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 30/11/2023 05:35: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 ( '89249' , '21574' , 'PAROLA, IL PANE, LA VITA - ANNO B - L. MAZZINGHI' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 30/11/2023 05:45:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 05:45:48 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' , '3815' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.20' , '35.41' , NOW() , NOW() ) 30/11/2023 05:45:48 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 = '89250' 30/11/2023 05:45:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '89250' 30/11/2023 05:45:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89250' , '20523' , 'CROCE - 094 ALV' , '12' , '-12' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '43.20' ) 30/11/2023 05:57:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '1795' , '2023-11-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '13.5' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '377.75' , '377.75' , NOW() , NOW() ) 30/11/2023 05:57: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 = '89251' 30/11/2023 05:57:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89251' 30/11/2023 05:57: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 ( '89251' , '21784' , 'NON DISTOGLIERE LO SGUARDO DAL POVERO' , '200' , '0' , '4' , '2.2000' , '2.2' , '0' , '45' , '242.00' ) 30/11/2023 05:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21784' AND id_supplier = '79' 30/11/2023 05:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21784' , '79' , '1' ) 30/11/2023 05:57: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 ( '89251' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 30/11/2023 05:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 30/11/2023 05:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 30/11/2023 05:57: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 ( '89251' , '21917' , 'ASCOLTARE PER SERVIRE' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '45' , '12.10' ) 30/11/2023 05:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21917' AND id_supplier = '79' 30/11/2023 05:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21917' , '79' , '1' ) 30/11/2023 05:57: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 ( '89251' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 30/11/2023 05:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '79' 30/11/2023 05:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '79' , '1' ) 30/11/2023 05:57:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89251' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 30/11/2023 05:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 30/11/2023 05:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 30/11/2023 05:57:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89251' , '2525' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '45' , '7.15' ) 30/11/2023 05:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2525' AND id_supplier = '79' 30/11/2023 05:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2525' , '79' , '1' ) 30/11/2023 06:01:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2023010002336' , '2023-11-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '162.80' , '161.63' , NOW() , NOW() ) 30/11/2023 06:01: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 = '89252' 30/11/2023 06:01:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '89252' 30/11/2023 06:01: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 ( '89252' , '21825' , 'QUALE CANTO PER LE NOSTRE CELEBRAZIONI LITURGICHE? - A. CIMINI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 30/11/2023 06:01:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21825' AND id_supplier = '107' 30/11/2023 06:01:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21825' , '107' , '1' ) 30/11/2023 06:01: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 ( '89252' , '21823' , 'DI MARIA UNA VERA IMMAGINE' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '35' , '10.40' ) 30/11/2023 06:01:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21823' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21823' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21824' , 'TENEREZZA DEL PADRE - E. LECLERC' , '1' , '0' , '4' , '11.0000' , '11' , '0' , '35' , '7.15' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21824' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21824' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '5.85' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21826' , 'NATALE DI FRANCESCO A GRECCIO - A. CACCIOTTI' , '1' , '0' , '4' , '26.0000' , '26' , '0' , '35' , '16.90' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21826' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21826' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21463' , 'CALENDARIO DELLAVVENTO 2023' , '1' , '0' , '1' , '5.33' , '4.3688524590164' , '22' , '0' , '6.5026' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21463' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21463' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '20' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '39.00' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 30/11/2023 06:01:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89252' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 30/11/2023 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 30/11/2023 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 30/11/2023 06:06:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 06:06:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3816' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '188.52' , NOW() , NOW() ) 30/11/2023 06:06:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89253' 30/11/2023 06:06:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '89253' 30/11/2023 06:06:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89253' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 30/11/2023 06:06:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89253' , '21858' , 'ANELLO S. LUCIA' , '300' , '-300' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '180.00' ) 30/11/2023 06:06:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89253' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '25' , '-25' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '20.00' ) 30/11/2023 06:35:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 06:35:35 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' , '3817' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 30/11/2023 06:35:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89254' 30/11/2023 06:35:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '89254' 30/11/2023 06:35:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89254' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/11/2023 06:35:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89254' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/11/2023 06:40:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-01') 30/11/2023 06:40: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 ( '21' , '111' , '2023-12-01' , '' , '1513' , '0' , '107350754' , 'P.ZZA 4 NOVEMBRE 9 14040 CASTELLETTO MOLINA' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '54.20' , '54.20' , NOW() , NOW() ) 30/11/2023 06:40: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 = '13758' 30/11/2023 06:40:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '13758' 30/11/2023 06:40: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 ( '13758' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '5' , '51.30' ) 30/11/2023 07:06:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '302' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 07:06:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '302' , '2023-11-30' , '' , '4052' , '0' , '4679184' , 'VIA MONTE GRAPPA 2 33039 SEDEGLIANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '32.36' , '32.36' , NOW() , NOW() ) 30/11/2023 07:06:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89255' 30/11/2023 07:06:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89255' 30/11/2023 07:06:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89255' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '7' , '-7' , '4' , '3.40' , '3.4' , '0' , '5' , '22.61' ) 30/11/2023 07:06:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89255' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/11/2023 07:36:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 30/11/2023 07:36:11 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' , '3818' , '2023-11-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 30/11/2023 07:36:11 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 = '89256' 30/11/2023 07:36:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89256' 30/11/2023 07:36:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89256' , '18131' , 'TAU MEDIO CM3 - T6' , '15' , '-15' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '15.00' )