07/07/2022 09:16:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 09:16:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2200' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.60' , '18.89' , NOW() , NOW() ) 07/07/2022 09:16:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59086' 07/07/2022 09:16:21 am >> DELETE FROM ps_document_detail WHERE id_document = '59086' 07/07/2022 09:16:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59086' , '5436' , 'IO MI CONFESSO ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 07/07/2022 09:16:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5436' AND id_supplier = '' 07/07/2022 09:16:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5436' , '' , '1' ) 07/07/2022 09:16:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59086' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 07/07/2022 09:16:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 07/07/2022 09:16:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 07/07/2022 09:16:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59086' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '8.40' ) 07/07/2022 09:16:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 07/07/2022 09:16:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 07/07/2022 09:16:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59086' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 07/07/2022 09:16:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 07/07/2022 09:16:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3128/00' , '2022-05-30' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'resa prodotti guasti' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '644.59' , '644.15' , NOW() , NOW() ) 07/07/2022 09:56:58 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 = '59087' 07/07/2022 09:56:58 am >> DELETE FROM ps_document_detail WHERE id_document = '59087' 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '1' , '4' , '3.40' , '3.4' , '0' , '0' , '3.40' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '8408' , 'PRENDETE E MANGIATE' , '1' , '1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '2679' , 'CONOSCERE GESU\'' , '11' , '11' , '4' , '3.50' , '3.5' , '0' , '0' , '38.5000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '3' , '3' , '4' , '6.00' , '6' , '0' , '0' , '18.0000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '3' , '3' , '4' , '2.00' , '2' , '0' , '0' , '6.0000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '8243' , 'PREGARE OGNI GIORNO' , '2' , '2' , '4' , '1.00' , '1' , '0' , '0' , '2.0000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '6629' , 'MIA PREGHIERA' , '1' , '1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '1' , '1' , '4' , '0.85' , '0.85' , '0' , '0' , '0.85' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '18036' , 'FERITE FERITOIE ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.0000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '4' , '4' , '4' , '3.50' , '3.5' , '0' , '0' , '14.0000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '11' , '11' , '4' , '2.40' , '2.4' , '0' , '0' , '26.4000' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.4400' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 07/07/2022 09:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '6' , '6' , '4' , '3.50' , '3.5' , '0' , '0' , '21.0000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '4' , '4' , '4' , '0.90' , '0.9' , '0' , '0' , '3.6000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '12255' , 'IN CAMMINO CON GESU' , '2' , '2' , '4' , '3.80' , '3.8' , '0' , '0' , '7.6000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '9675' , 'SARETE MIEI TESTIMONI' , '5' , '5' , '4' , '3.00' , '3' , '0' , '0' , '15.0000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '0' , '24.0000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '3' , '3' , '4' , '1.60' , '1.6' , '0' , '0' , '4.8000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '8254' , 'PREGHIAMO CON MARIA' , '11' , '11' , '4' , '0.65' , '0.65' , '0' , '0' , '7.1500' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '9970' , 'SIAMO CHIESA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '1' , '4' , '6.20' , '6.2' , '0' , '0' , '6.20' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '5458' , 'IO SONO CON VOI 2 PARTE' , '34' , '34' , '4' , '2.50' , '2.5' , '0' , '0' , '85.0000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '5457' , 'IO SONO CON VOI 1 PARTE' , '34' , '34' , '4' , '2.50' , '2.5' , '0' , '0' , '85.0000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '11192' , 'VENITE CON ME 2 PARTE' , '19' , '19' , '4' , '2.50' , '2.5' , '0' , '0' , '47.5000' ) 07/07/2022 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59087' , '11191' , 'VENITE CON ME 1 PARTE' , '28' , '28' , '4' , '2.50' , '2.5' , '0' , '0' , '70.0000' ) 07/07/2022 09:57:20 am >> UPDATE ps_document SET id_document_type = '33', document_num = '5408/00', document_date = '2019-09-05', document_letter = '00', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RIENTRO FUORI CATALOGO - edizioni', 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 = '2191.21', price_tax_excluded = '2191.21', date_upd = NOW() WHERE id_document = '20886' 07/07/2022 09:57:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '20886' 07/07/2022 09:57:20 am >> DELETE FROM ps_document_detail WHERE id_document = '20886' 07/07/2022 09:57:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '5547' , 'LAMPADA AI MIEI PASSI - ANNO B' , '7' , '7' , '4' , '10.3300' , '10.33' , '0' , '0' , '72.31' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5547' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5547' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '5548' , 'LAMPADA AI MIEI PASSI - ANNO C' , '59' , '59' , '4' , '10.3300' , '10.33' , '0' , '0' , '609.4700' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5548' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5548' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '8422' , 'PREPARIAMO LA MESSA - ANNO A' , '18' , '18' , '4' , '7.7500' , '7.75' , '0' , '0' , '139.50' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8422' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8422' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '8423' , 'PREPARIAMO LA MESSA - ANNO B' , '9' , '9' , '4' , '12.9100' , '12.91' , '0' , '0' , '116.19' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8423' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8423' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '8424' , 'PREPARIAMO LA MESSA - ANNO C' , '38' , '38' , '4' , '12.9100' , '12.91' , '0' , '0' , '490.58' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8424' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8424' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '8226' , 'PREGARE' , '9' , '9' , '4' , '6.2000' , '6.2' , '0' , '0' , '55.80' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8226' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8226' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '7407' , 'PADRE, PERDONAMI' , '164' , '164' , '4' , '2.5800' , '2.58' , '0' , '0' , '423.12' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7407' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7407' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '8522' , 'PRIMO INCONTRO CON LA BIBBIA' , '8' , '8' , '4' , '10.3300' , '10.33' , '0' , '0' , '82.64' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8522' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8522' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '6701' , 'MIO GESÙ' , '3' , '3' , '4' , '2.6000' , '2.6' , '0' , '0' , '7.80' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '6701' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6701' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 07/07/2022 09:57:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 07/07/2022 09:57:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 07/07/2022 09:57:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE - PER ANIMATORI E CATECHISTI' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1833' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1833' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '1' , '4' , '1.6000' , '1.6' , '0' , '0' , '1.60' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '10364' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10364' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' , '1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11102' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11102' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '11191' , 'VENITE CON ME 1 PARTE' , '24' , '24' , '4' , '2.0000' , '2' , '0' , '0' , '48.00' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '4' , '4' , '2.0000' , '2' , '0' , '0' , '8.00' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '6718' , 'MIRACOLI DI GESÙ' , '14' , '14' , '4' , '2.6000' , '2.6' , '0' , '0' , '36.40' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '6718' AND id_supplier = '' 07/07/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6718' , '' , '1' ) 07/07/2022 09:57: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 ( '20886' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '1' , '4' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 07/07/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 07/07/2022 09:57:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 07/07/2022 09:57:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 07/07/2022 09:57:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 07/07/2022 09:57:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 07/07/2022 09:57:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '1' , '4' , '2.4000' , '2.4' , '0' , '0' , '2.40' ) 07/07/2022 09:57:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 07/07/2022 09:57:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 07/07/2022 09:57:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20886' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '18' , '18' , '4' , '2.4000' , '2.4' , '0' , '0' , '43.20' ) 07/07/2022 09:57:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 07/07/2022 09:57:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 07/07/2022 10:16: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 ( '31' , '6022270616' , '2022-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '328.92' , '328.92' , NOW() , NOW() ) 07/07/2022 10:16: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 = '59088' 07/07/2022 10:16:50 am >> DELETE FROM ps_document_detail WHERE id_document = '59088' 07/07/2022 10:16: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 ( '59088' , '12899' , 'LODE A TE, SIGNORE' , '104' , '104' , '4' , '2.83' , '2.83' , '0' , '0' , '294.3200' ) 07/07/2022 10:16:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '12899' AND id_supplier = '109' 07/07/2022 10:16:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12899' , '109' , '1' ) 07/07/2022 10:16: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 ( '59088' , '19630' , 'bernardette - a. maggi' , '1' , '1' , '4' , '13.15' , '13.15' , '0' , '' , '13.1500' ) 07/07/2022 10:16:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19630' AND id_supplier = '109' 07/07/2022 10:16:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19630' , '109' , '1' ) 07/07/2022 10:16: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 ( '59088' , '16353' , 'QUALCUNO A CUI GUARDARE - L. EPICOCO' , '1' , '1' , '4' , '8.64' , '8.64' , '0' , '0' , '8.6400' ) 07/07/2022 10:16:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '16353' AND id_supplier = '109' 07/07/2022 10:16:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16353' , '109' , '1' ) 07/07/2022 10:16: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 ( '59088' , '19631' , 'DONO DAMORE - M.L. KING' , '1' , '1' , '4' , '12.96' , '12.96' , '0' , '0' , '12.9600' ) 07/07/2022 10:16:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19631' AND id_supplier = '109' 07/07/2022 10:16:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19631' , '109' , '1' ) 07/07/2022 10:16: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 ( '59088' , '' , 'ARROTONDAMENTO' , '1' , '1' , '4' , '-0.15' , '-0.15' , '0' , '0' , '-0.1500' ) 07/07/2022 10:16:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '109' 07/07/2022 10:16:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '109' , '1' ) 07/07/2022 10:19:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '6022270617' , '2022-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '17.57' , '17.57' , NOW() , NOW() ) 07/07/2022 10:19:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59089' 07/07/2022 10:19:41 am >> DELETE FROM ps_document_detail WHERE id_document = '59089' 07/07/2022 10:19:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59089' , '19632' , 'CATECHETICA - L. MEDDI' , '1' , '1' , '4' , '17.57' , '17.57' , '0' , '0' , '17.5700' ) 07/07/2022 10:19:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19632' AND id_supplier = '109' 07/07/2022 10:19:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19632' , '109' , '1' ) 07/07/2022 10:21:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '6022270615' , '2022-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '23.93' , '23.93' , NOW() , NOW() ) 07/07/2022 10:21:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59090' 07/07/2022 10:21:07 am >> DELETE FROM ps_document_detail WHERE id_document = '59090' 07/07/2022 10:21:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59090' , '19633' , 'CANTICO DEI CANTICI - G. RAVASI' , '1' , '1' , '4' , '23.93' , '23.93' , '0' , '0' , '23.9300' ) 07/07/2022 10:21:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19633' AND id_supplier = '109' 07/07/2022 10:21:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19633' , '109' , '1' ) 07/07/2022 10:23:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 10:23:45 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' , '2201' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.83' , NOW() , NOW() ) 07/07/2022 10:23:45 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 = '59091' 07/07/2022 10:23:45 am >> DELETE FROM ps_document_detail WHERE id_document = '59091' 07/07/2022 10:23: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 ( '59091' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 07/07/2022 10:23:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 07/07/2022 10:23:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 07/07/2022 10:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 10:30:59 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' , '2202' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '3.44' , NOW() , NOW() ) 07/07/2022 10:30:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59092' 07/07/2022 10:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '59092' 07/07/2022 10:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59092' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 07/07/2022 10:30:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 07/07/2022 10:30:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 07/07/2022 10:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59092' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 07/07/2022 10:30:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 07/07/2022 10:31:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 07/07/2022 10:37:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 10:37:15 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' , '2203' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.20' , '27.91' , NOW() , NOW() ) 07/07/2022 10:37:15 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 = '59093' 07/07/2022 10:37:15 am >> DELETE FROM ps_document_detail WHERE id_document = '59093' 07/07/2022 10:37:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59093' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 07/07/2022 10:37:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 07/07/2022 10:37:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 07/07/2022 10:37:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59093' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 07/07/2022 10:37:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 07/07/2022 10:37:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 07/07/2022 10:37:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59093' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 07/07/2022 10:37:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 07/07/2022 10:37:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 07/07/2022 11:19:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2204' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 11:19:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2204' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 07/07/2022 11:19:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59094' 07/07/2022 11:19:38 am >> DELETE FROM ps_document_detail WHERE id_document = '59094' 07/07/2022 11:19:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59094' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 07/07/2022 11:19:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 07/07/2022 11:19:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 07/07/2022 11:34:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 11:34:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2205' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '260.00' , '221.87' , NOW() , NOW() ) 07/07/2022 11:34:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59095' 07/07/2022 11:34:37 am >> DELETE FROM ps_document_detail WHERE id_document = '59095' 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '5230' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5230' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '52.00' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '10' , '22.50' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '13505' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13505' , '' , '1' ) 07/07/2022 11:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59095' , '801' , 'ASTUCCIO STOPPINO - MT 2 - 117' , '1' , '-1' , '1' , '6.39' , '5.2377049180328' , '22' , '0' , '6.39' ) 07/07/2022 11:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '801' AND id_supplier = '' 07/07/2022 11:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '801' , '' , '1' ) 07/07/2022 11:44:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 11:44:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2206' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 07/07/2022 11:44:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59096' 07/07/2022 11:44:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59096' 07/07/2022 11:44:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59096' , '2328' , 'CLERGY GRIGIO MM - COTONE 43 ' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 07/07/2022 11:44:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '2328' AND id_supplier = '' 07/07/2022 11:44:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2328' , '' , '1' ) 07/07/2022 12:02:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 12:02: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' , '2207' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '314.70' , '259.30' , NOW() , NOW() ) 07/07/2022 12:02: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 = '59097' 07/07/2022 12:02:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '59097' 07/07/2022 12:02: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 ( '59097' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '200' , '-200' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '240.00' ) 07/07/2022 12:02:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 07/07/2022 12:02:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 07/07/2022 12:02: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 ( '59097' , '13506' , 'SANTO ROSARIO' , '200' , '-200' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '60.00' ) 07/07/2022 12:02:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 07/07/2022 12:02:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 07/07/2022 12:02: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 ( '59097' , '13462' , 'SE MI AMI NON PIANGERE' , '5' , '-5' , '4' , '1.50' , '1.5' , '0' , '0' , '7.50' ) 07/07/2022 12:02:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13462' AND id_supplier = '' 07/07/2022 12:02:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13462' , '' , '1' ) 07/07/2022 12:02: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 ( '59097' , '15914' , 'QUADRETTO EFFETTO PIETRA MAD. DEL CARMINE' , '1' , '-1' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '3.70' ) 07/07/2022 12:02:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15914' AND id_supplier = '' 07/07/2022 12:02:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15914' , '' , '1' ) 07/07/2022 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59097' , '4887' , 'ICONA LEGNO 10X15 - POMPEI - 1222 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 07/07/2022 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4887' AND id_supplier = '' 07/07/2022 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4887' , '' , '1' ) 07/07/2022 07:08:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 07:08:12 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' , '2208' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 07/07/2022 07:08:12 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 = '59098' 07/07/2022 07:08:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '59098' 07/07/2022 07:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59098' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 07/07/2022 07:08:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 07/07/2022 07:08:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 07/07/2022 07:16:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 07:16:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2209' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 07/07/2022 07:16:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59099' 07/07/2022 07:16:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '59099' 07/07/2022 07:16:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59099' , '968' , 'BATTESIMO DONA VITA' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 07/07/2022 07:16:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '968' AND id_supplier = '' 07/07/2022 07:16:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '968' , '' , '1' ) 07/07/2022 07:37:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 07:37:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2210' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.30' , '12.07' , NOW() , NOW() ) 07/07/2022 07:37:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59100' 07/07/2022 07:37:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '59100' 07/07/2022 07:37:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59100' , '8966' , 'RIDERE CON IL CUORE - VALERIO ALBISETTI' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 07/07/2022 07:37:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8966' AND id_supplier = '' 07/07/2022 07:37:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8966' , '' , '1' ) 07/07/2022 07:37:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59100' , '14773' , 'BRACCIALE RIGATO - 0825N' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 07/07/2022 07:37:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14773' AND id_supplier = '' 07/07/2022 07:37:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14773' , '' , '1' ) 07/07/2022 07:43:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 07/07/2022 07:43:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2211' , '2022-07-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 07/07/2022 07:43:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59101' 07/07/2022 07:43:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '59101' 07/07/2022 07:43:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59101' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 07/07/2022 07:43:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '' 07/07/2022 07:43:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' )