20/01/2025 12:19:56 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/01/2025 12:19:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23352' , '1' , '' , 'nuovo-prodotto' ) 20/01/2025 12:19:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23352' , '1' , '1' , '2' , NOW() , NOW() ) 20/01/2025 12:19:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23352' , '0' , '1' , '0' , '0' ) 20/01/2025 08:37:30 am >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '95302' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-16') 20/01/2025 08:37:30 am >> UPDATE ps_document SET id_document_type = '21', document_num = '7', document_date = '2025-01-16', document_letter = '', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '398.25', price_tax_excluded = '398.25', date_upd = NOW() WHERE id_document = '95302' 20/01/2025 08:37:30 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 = '95302' 20/01/2025 08:37:30 am >> DELETE FROM ps_document_detail WHERE id_document = '95302' 20/01/2025 08:37: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 ( '95302' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 20/01/2025 08:37: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 ( '95302' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 20/01/2025 08:37: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 ( '95302' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 20/01/2025 08:37: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 ( '95302' , '11192' , 'VENITE CON ME 2 PARTE' , '22' , '-22' , '4' , '2.8000' , '2.8' , '0' , '15' , '52.36' ) 20/01/2025 08:37: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 ( '95302' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '15' , '33.32' ) 20/01/2025 08:37: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 ( '95302' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 20/01/2025 08:37: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 ( '95302' , '5457' , 'IO SONO CON VOI 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 20/01/2025 08:37: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 ( '95302' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '13397' , 'MIO GESU' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '15' , '2.04' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 20/01/2025 08:37:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95302' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 20/01/2025 08:43:36 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '1YsO5itXWwSrHvhI' , NOW() , NOW() ) 20/01/2025 08:43:36 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4155' , '1' ) 20/01/2025 08:43:36 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4155' , '2' ) 20/01/2025 08:43:36 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4155' , '3' ) 20/01/2025 09:04:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '256' , '2025-01-16' , '' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 20/01/2025 09:04:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95347' 20/01/2025 09:04:03 am >> DELETE FROM ps_document_detail WHERE id_document = '95347' 20/01/2025 09:04:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95347' , '23347' , 'PREGHIERA DEL ROSARIO' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/01/2025 09:04:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '23347' AND id_supplier = '125' 20/01/2025 09:04:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23347' , '125' , '1' ) 20/01/2025 09:04: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 ( '95347' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/01/2025 09:04:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '23348' AND id_supplier = '125' 20/01/2025 09:04:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23348' , '125' , '1' ) 20/01/2025 09:04: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 ( '95347' , '8408' , 'PRENDETE E MANGIATE' , '6000' , '6000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/01/2025 09:04:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '125' 20/01/2025 09:04:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '125' , '1' ) 20/01/2025 10:40:58 am >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 10:40: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' , '192' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '34.00' , NOW() , NOW() ) 20/01/2025 10:40: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 = '95348' 20/01/2025 10:40:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95348' 20/01/2025 10:40: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 ( '95348' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '5' , '-5' , '4' , '6.8' , '6.8' , '0' , '0' , '34.00' ) 20/01/2025 10:43:59 am >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 10:43: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' , '193' , '2025-01-20' , '' , '0' , '0' , '0' , 'SAN LEONARDO 84090 GIFFONI SEI CASALI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '255.00' , '223.37' , NOW() , NOW() ) 20/01/2025 10:43: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 = '95349' 20/01/2025 10:43:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95349' 20/01/2025 10:43: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 ( '95349' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.36' , '8.36' , '0' , '0' , '8.36' ) 20/01/2025 10:43: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 ( '95349' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 20/01/2025 10:43: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 ( '95349' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.2049' , '22' , '0' , '25.00' ) 20/01/2025 10:43: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 ( '95349' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '24' , '-24' , '1' , '1.0000' , '0.8197' , '22' , '0' , '24.00' ) 20/01/2025 10:43: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 ( '95349' , '19231' , 'CARD CARLO ACUTIS - RN93' , '10' , '-10' , '1' , '1.0000' , '0.8197' , '22' , '0' , '10.00' ) 20/01/2025 10:43: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 ( '95349' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '12' , '-12' , '1' , '1.2000' , '0.9836' , '22' , '0' , '14.40' ) 20/01/2025 10:43: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 ( '95349' , '18131' , 'TAU MEDIO CM3 - T6/t5' , '12' , '-12' , '1' , '1.0000' , '0.8197' , '22' , '0' , '12.00' ) 20/01/2025 10:43: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 ( '95349' , '22923' , 'ROLL UP GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.2787' , '22' , '0' , '65.00' ) 20/01/2025 10:43: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 ( '95349' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 20/01/2025 10:43: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 ( '95349' , '23120' , 'AMEN - GEN 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 20/01/2025 10:43: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 ( '95349' , '23119' , 'AMEN - FEB 25' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 20/01/2025 10:43: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 ( '95349' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.2049' , '22' , '0' , '25.00' ) 20/01/2025 10:55:57 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 10:55:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '22/A' , '2025-01-20' , 'A' , '385' , '0' , '4679346' , 'VIA E. BOTTIGLIERI, 21 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '292.30' , '292.30' , NOW() , NOW() ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95350' 20/01/2025 10:55:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95350' 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '3' , '-3' , '4' , '38.00' , '38' , '0' , '0' , '114.00' ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '0' , '42.00' ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '46.00' , '46' , '0' , '0' , '46.00' ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '3' , '-3' , '4' , '18.50' , '18.5' , '0' , '0' , '55.50' ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 20/01/2025 10:55:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95350' , '18783' , 'MIA BIBBIA PREFERITA ' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 20/01/2025 11:14:23 am >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '95197' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-08') 20/01/2025 11:14:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '73', document_date = '2025-01-08', 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 = '182.35', price_tax_excluded = '158.55', date_upd = NOW() WHERE id_document = '95197' 20/01/2025 11:14:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95197' 20/01/2025 11:14:23 am >> DELETE FROM ps_document_detail WHERE id_document = '95197' 20/01/2025 11:14: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 ( '95197' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 20/01/2025 11:14: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 ( '95197' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 20/01/2025 11:14: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 ( '95197' , '23326' , 'ASCOLTARE, CONDIVIDERE, ORIENTARSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 20/01/2025 11:14: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 ( '95197' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '102.00' ) 20/01/2025 11:14: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 ( '95197' , '23324' , 'PELLEGRINI DI SPERANZA' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '5' , '8.55' ) 20/01/2025 11:14: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 ( '95197' , '23210' , 'ETA DELLA VITA - C. M. MARTINI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 20/01/2025 11:14: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 ( '95197' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 20/01/2025 11:14: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 ( '95197' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 20/01/2025 11:15:09 am >> SELECT document_num FROM ps_document WHERE document_num = '149' AND id_document != '95293' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-15') 20/01/2025 11:15:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '149', document_date = '2025-01-15', 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 = '134.00', price_tax_excluded = '125.16', date_upd = NOW() WHERE id_document = '95293' 20/01/2025 11:15:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95293' 20/01/2025 11:15:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95293' 20/01/2025 11:15:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95293' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 20/01/2025 11:15:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95293' , '17503' , 'PAROLA DI CRISTO - R. CANTALAMESSA' , '1' , '-1' , '4' , '45.0000' , '45' , '0' , '5' , '42.75' ) 20/01/2025 11:15:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95293' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 20/01/2025 11:15:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95293' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 20/01/2025 11:15:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95293' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 20/01/2025 11:25:18 am >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 11:25:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '23/A' , '2025-01-20' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 20/01/2025 11:25: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 = '95351' 20/01/2025 11:25:18 am >> DELETE FROM ps_document_detail WHERE id_document = '95351' 20/01/2025 11:25: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 ( '95351' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 20/01/2025 11:25: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 ( '95351' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '6.66' ) 20/01/2025 11:25: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 ( '95351' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.34' , '2.7377049180328' , '22' , '0' , '3.34' ) 20/01/2025 11:29:08 am >> SELECT document_num FROM ps_document WHERE document_num = '194' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 11:29: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 ( '11' , '194' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.00' , '125.95' , NOW() , NOW() ) 20/01/2025 11:29: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 = '95352' 20/01/2025 11:29:08 am >> DELETE FROM ps_document_detail WHERE id_document = '95352' 20/01/2025 11:29: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 ( '95352' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 20/01/2025 11:29: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 ( '95352' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '6.66' ) 20/01/2025 11:29: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 ( '95352' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.34' , '2.7377049180328' , '22' , '0' , '3.34' ) 20/01/2025 11:29: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 ( '95352' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 20/01/2025 11:31:01 am >> DELETE FROM ps_document WHERE id_document = '95351' 20/01/2025 11:31:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95351' 20/01/2025 11:32:45 am >> DELETE FROM ps_document WHERE id_document = '93247' 20/01/2025 11:32:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93247' 20/01/2025 11:33:09 am >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '95348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 11:33:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '192', document_date = '2025-01-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '34.00', price_tax_excluded = '34.00', date_upd = NOW() WHERE id_document = '95348' 20/01/2025 11:33:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95348' 20/01/2025 11:33:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95348' 20/01/2025 11:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95348' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '34' , '34' , '0' , '0' , '34.00' ) 20/01/2025 12:38:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '195' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 12:38:26 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' , '195' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.55' , '5.87' , NOW() , NOW() ) 20/01/2025 12:38:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95353' 20/01/2025 12:38:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95353' 20/01/2025 12:38:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95353' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '3.75' ) 20/01/2025 12:38:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95353' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 20/01/2025 12:39:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '196' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 12:39: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 ( '11' , '196' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 20/01/2025 12:39: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 = '95354' 20/01/2025 12:39:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '95354' 20/01/2025 12:39: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 ( '95354' , '9706' , 'SCATOLA ALTA PER OSTIA CON LUNETTA - 1356 -' , '1' , '-1' , '1' , '160.00' , '131.14754098361' , '22' , '0' , '160.00' ) 20/01/2025 12:52:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '197' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 12:52:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '197' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.40' , '9.30' , NOW() , NOW() ) 20/01/2025 12:52:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95355' 20/01/2025 12:52:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95355' 20/01/2025 12:52:44 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 ( '95355' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 20/01/2025 12:52:44 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 ( '95355' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/01/2025 12:52:44 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 ( '95355' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/01/2025 03:35:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 03:35:04 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' , '198' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.29' , '21.29' , NOW() , NOW() ) 20/01/2025 03:35:04 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 = '95356' 20/01/2025 03:35:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '95356' 20/01/2025 03:35:04 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 ( '95356' , '21891' , 'HO AVUTO PAURA ' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 20/01/2025 03:35:04 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 ( '95356' , '23112' , 'CONOSCI TE STESSO - C. AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 20/01/2025 04:10:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 04:10: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 ( '11' , '199' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 20/01/2025 04:10: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 = '95357' 20/01/2025 04:10:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '95357' 20/01/2025 04:10: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 ( '95357' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/01/2025 04:10: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 ( '95357' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 20/01/2025 04:10: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 ( '95357' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '9.3' , '7.6229508196721' , '22' , '0' , '18.60' ) 20/01/2025 04:10: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 ( '95357' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/01/2025 04:10: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 ( '95357' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/01/2025 04:11:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 04:11:27 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' , '200' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '420.00' , '362.00' , NOW() , NOW() ) 20/01/2025 04:11:27 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 = '95358' 20/01/2025 04:11:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '95358' 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '30' , '-30' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '105.00' ) 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/01/2025 04:11:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '9.2' , '7.5409836065574' , '22' , '0' , '27.60' ) 20/01/2025 04:12:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 04:12:10 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' , '201' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.13' , '11.13' , NOW() , NOW() ) 20/01/2025 04:12:10 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 = '95359' 20/01/2025 04:12:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95359' 20/01/2025 04:12:10 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 ( '95359' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 20/01/2025 04:12:10 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 ( '95359' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 20/01/2025 04:12:10 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 ( '95359' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 20/01/2025 04:25:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 20/01/2025 04:25:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '10/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA CONVENTO 83025 MONTORO', address2 = '', note = 'DDT 119/A DEL 07/11/2024', 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 = '420.00', price_tax_excluded = '344.26', date_upd = NOW() WHERE id_document = '94115' 20/01/2025 04:25:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94115' 20/01/2025 04:25:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '94115' 20/01/2025 04:25:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94115' , '20263' , 'PIZZO IHS UVA - PIZ0M420' , '4' , '-4' , '1' , '105' , '86.065573770492' , '22' , '0' , '420.00' ) 20/01/2025 04:26:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 20/01/2025 04:26:08 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '10/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA CONVENTO 83025 MONTORO', address2 = '', note = 'DDT 119/A DEL 07/11/2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '400.00', price_tax_excluded = '327.87', date_upd = NOW() WHERE id_document = '94115' 20/01/2025 04:26:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94115' 20/01/2025 04:26:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94115' 20/01/2025 04:26:09 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 ( '94115' , '20263' , 'PIZZO IHS UVA - PIZ0M420' , '4' , '-4' , '1' , '100' , '81.967213114754' , '22' , '0' , '400.00' ) 20/01/2025 05:09:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4049' AND id_document != '94994' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 20/01/2025 05:09:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4049', document_date = '2024-12-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.00', price_tax_excluded = '108.00', date_upd = NOW() WHERE id_document = '94994' 20/01/2025 05:09: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 = '94994' 20/01/2025 05:09:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94994' 20/01/2025 05:09: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 ( '94994' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 20/01/2025 05:09: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 ( '94994' , '23327' , 'ABBIAMO CONOSCIUTO LAMORE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 20/01/2025 05:09: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 ( '94994' , '23223' , 'COPRILEGGIO - CL10' , '1' , '-1' , '1' , '52' , '42.622950819672' , '22' , '0' , '52.00' ) 20/01/2025 05:10:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '95125' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02') 20/01/2025 05:10:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '12', document_date = '2025-01-02', 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 = '940.00', price_tax_excluded = '775.46', date_upd = NOW() WHERE id_document = '95125' 20/01/2025 05:10:57 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 = '95125' 20/01/2025 05:10:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '95125' 20/01/2025 05:10:57 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 ( '95125' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '606' , '496.72131147541' , '22' , '0' , '606.00' ) 20/01/2025 05:10:57 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 ( '95125' , '1914' , 'CERA DELLA LITURGIA' , '11' , '-11' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '51.70' ) 20/01/2025 05:10:57 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 ( '95125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '3.30' ) 20/01/2025 05:10:57 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 ( '95125' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 20/01/2025 05:10:57 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 ( '95125' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '-1' , '1' , '244.00' , '200' , '22' , '0' , '244.00' ) 20/01/2025 05:11:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4119' AND id_document != '95072' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-28') 20/01/2025 05:11:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4119', document_date = '2024-12-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.00', price_tax_excluded = '40.23', date_upd = NOW() WHERE id_document = '95072' 20/01/2025 05:11: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 = '95072' 20/01/2025 05:11:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '95072' 20/01/2025 05:11: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 ( '95072' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 20/01/2025 05:11: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 ( '95072' , '1914' , 'CERA DELLA LITURGIA' , '10' , '-10' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '35.00' ) 20/01/2025 05:11:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '59' AND id_document != '95182' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-07') 20/01/2025 05:11:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '59', document_date = '2025-01-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.70', price_tax_excluded = '3.98', date_upd = NOW() WHERE id_document = '95182' 20/01/2025 05:11:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95182' 20/01/2025 05:11:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '95182' 20/01/2025 05:11:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95182' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 20/01/2025 05:11:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95182' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 20/01/2025 05:11:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '89' AND id_document != '95215' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-09') 20/01/2025 05:11:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '89', document_date = '2025-01-09', 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 = '3.50', price_tax_excluded = '2.87', date_upd = NOW() WHERE id_document = '95215' 20/01/2025 05:11:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95215' 20/01/2025 05:11:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '95215' 20/01/2025 05:11:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95215' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/01/2025 05:30:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 05:30: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 ( '24' , '23/A' , '2025-01-20' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALE CURTERI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 20/01/2025 05:30: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 = '95360' 20/01/2025 05:30:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95360' 20/01/2025 05:30: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 ( '95360' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/01/2025 06:48:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 06:48: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' , '202' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 20/01/2025 06:48: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 = '95361' 20/01/2025 06:48:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95361' 20/01/2025 06:48: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 ( '95361' , '23088' , 'CAMPANA DEL GIUBILEO' , '2' , '-2' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '40.00' ) 20/01/2025 06:51:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 06:51:50 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' , '203' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 20/01/2025 06:51:50 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 = '95362' 20/01/2025 06:51:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '95362' 20/01/2025 06:51:50 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 ( '95362' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 20/01/2025 07:29:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 20/01/2025 07:29: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' , '204' , '2025-01-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/01/2025 07:29: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 = '95363' 20/01/2025 07:29:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '95363' 20/01/2025 07:29: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 ( '95363' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )