02/04/2025 08:08:48 am >> SELECT document_num FROM ps_document WHERE document_num = '942' AND id_document != '96323' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-21') 02/04/2025 08:08:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '942', document_date = '2025-03-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 = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '96323' 02/04/2025 08:08:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96323' 02/04/2025 08:08:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96323' 02/04/2025 08:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96323' , '13462' , 'SE MI AMI NON PIANGERE' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 02/04/2025 08:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96323' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 02/04/2025 08:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96323' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 02/04/2025 08:10:06 am >> SELECT document_num FROM ps_document WHERE document_num = '532' AND id_document != '95804' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 02/04/2025 08:10:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '532', document_date = '2025-02-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '125.00', price_tax_excluded = '118.69', date_upd = NOW() WHERE id_document = '95804' 02/04/2025 08:10:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95804' 02/04/2025 08:10:06 am >> DELETE FROM ps_document_detail WHERE id_document = '95804' 02/04/2025 08:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '0' , '35.00' ) 02/04/2025 08:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '16.00' ) 02/04/2025 08:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '22438' , 'BRACCIALE ARG. CRISTALLO - 1345/CAV' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 02/04/2025 08:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '0' , '50.00' ) 02/04/2025 08:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 02/04/2025 08:10:45 am >> SELECT document_num FROM ps_document WHERE document_num = '657' AND id_document != '95956' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 02/04/2025 08:10:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '657', document_date = '2025-02-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 = '77.00', price_tax_excluded = '77.00', date_upd = NOW() WHERE id_document = '95956' 02/04/2025 08:10: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 = '95956' 02/04/2025 08:10:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95956' 02/04/2025 08:10: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 ( '95956' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 02/04/2025 08:10: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 ( '95956' , '21542' , '100 OMELIE N.E. - A. COMASTRI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 02/04/2025 08:10: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 ( '95956' , '10364' , 'SULLA STRADA DEL MAESTRO' , '4' , '-4' , '4' , '14.00' , '14' , '0' , '0' , '56.00' ) 02/04/2025 08:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '659' AND id_document != '95958' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 02/04/2025 08:11:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '659', document_date = '2025-02-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 = '315.00', price_tax_excluded = '264.51', date_upd = NOW() WHERE id_document = '95958' 02/04/2025 08:11:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95958' 02/04/2025 08:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '95958' 02/04/2025 08:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95958' , '19798' , 'CAMICE ARIANNA MISTO LINO' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 02/04/2025 08:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95958' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '0' , '35.00' ) 02/04/2025 08:12:36 am >> SELECT document_num FROM ps_document WHERE document_num = '680' AND id_document != '95985' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-01') 02/04/2025 08:12:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '680', document_date = '2025-03-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '90.00', date_upd = NOW() WHERE id_document = '95985' 02/04/2025 08:12: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 = '95985' 02/04/2025 08:12:36 am >> DELETE FROM ps_document_detail WHERE id_document = '95985' 02/04/2025 08:12: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 ( '95985' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '9' , '-9' , '4' , '10.00' , '10' , '0' , '0' , '90.00' ) 02/04/2025 08:12:56 am >> SELECT document_num FROM ps_document WHERE document_num = '677' AND id_document != '95981' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-01') 02/04/2025 08:12:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '677', document_date = '2025-03-01', 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 = '22.50', price_tax_excluded = '22.23', date_upd = NOW() WHERE id_document = '95981' 02/04/2025 08:12:56 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 = '95981' 02/04/2025 08:12:56 am >> DELETE FROM ps_document_detail WHERE id_document = '95981' 02/04/2025 08:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '0.75' , '0.75' , '0' , '0' , '1.50' ) 02/04/2025 08:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '5' , '-5' , '4' , '2.0000' , '2' , '0' , '0' , '10.00' ) 02/04/2025 08:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '14499' , 'COMUNIONE AI MALATI' , '5' , '-5' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '1.50' ) 02/04/2025 08:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '23407' , 'PROCESSO AL PROCESSETTO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/04/2025 08:13:28 am >> SELECT document_num FROM ps_document WHERE document_num = '690' AND id_document != '95995' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-01') 02/04/2025 08:13:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '690', document_date = '2025-03-01', 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 = '58.00', price_tax_excluded = '58.00', date_upd = NOW() WHERE id_document = '95995' 02/04/2025 08:13:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95995' 02/04/2025 08:13:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95995' 02/04/2025 08:13:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95995' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '8' , '-8' , '4' , '1.00' , '1' , '0' , '0' , '8.00' ) 02/04/2025 08:13:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95995' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '0' , '50.00' ) 02/04/2025 08:14:02 am >> SELECT document_num FROM ps_document WHERE document_num = '761' AND id_document != '96093' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-07') 02/04/2025 08:14:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '761', document_date = '2025-03-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 = '3.50', price_tax_excluded = '3.50', date_upd = NOW() WHERE id_document = '96093' 02/04/2025 08:14:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96093' 02/04/2025 08:14:02 am >> DELETE FROM ps_document_detail WHERE id_document = '96093' 02/04/2025 08:14:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96093' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 02/04/2025 08:14:40 am >> SELECT document_num FROM ps_document WHERE document_num = '769' AND id_document != '96107' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-07') 02/04/2025 08:14:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '769', document_date = '2025-03-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 = '16.90', price_tax_excluded = '15.10', date_upd = NOW() WHERE id_document = '96107' 02/04/2025 08:14:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96107' 02/04/2025 08:14:40 am >> DELETE FROM ps_document_detail WHERE id_document = '96107' 02/04/2025 08:14:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96107' , '18558' , 'SAN PIETRO BABY - 023 SP/ 9 BB' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/04/2025 08:14:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96107' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.45' , '3.45' , '0' , '0' , '6.90' ) 02/04/2025 08:15:25 am >> SELECT document_num FROM ps_document WHERE document_num = '772' AND id_document != '96112' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-07') 02/04/2025 08:15:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '772', document_date = '2025-03-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 = '126.00', price_tax_excluded = '126.00', date_upd = NOW() WHERE id_document = '96112' 02/04/2025 08:15:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96112' 02/04/2025 08:15:25 am >> DELETE FROM ps_document_detail WHERE id_document = '96112' 02/04/2025 08:15:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96112' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.59' , '0.59' , '0' , '0' , '0.59' ) 02/04/2025 08:15:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96112' , '23527' , 'CODICE DI DIRITTO CANONICO - 9 EDIZ.' , '1' , '-1' , '4' , '109.9000' , '109.9' , '0' , '5' , '104.41' ) 02/04/2025 08:15:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96112' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '7' , '-7' , '4' , '3' , '3' , '0' , '0' , '21.00' ) 02/04/2025 08:16:20 am >> SELECT document_num FROM ps_document WHERE document_num = '797' AND id_document != '96140' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 02/04/2025 08:16:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '797', document_date = '2025-03-10', 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 = '20.90', price_tax_excluded = '20.90', date_upd = NOW() WHERE id_document = '96140' 02/04/2025 08:16: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 = '96140' 02/04/2025 08:16:21 am >> DELETE FROM ps_document_detail WHERE id_document = '96140' 02/04/2025 08: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 ( '96140' , '23360' , 'QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/04/2025 08: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 ( '96140' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 02/04/2025 08: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 ( '96140' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 02/04/2025 08: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 ( '96140' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/04/2025 08:16:48 am >> SELECT document_num FROM ps_document WHERE document_num = '802' AND id_document != '96148' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 02/04/2025 08:16:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '802', document_date = '2025-03-10', 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 = '28.85', price_tax_excluded = '28.85', date_upd = NOW() WHERE id_document = '96148' 02/04/2025 08:16:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96148' 02/04/2025 08:16:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96148' 02/04/2025 08:16:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96148' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/04/2025 08:16:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96148' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/04/2025 08:16:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96148' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 02/04/2025 08:16:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96148' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 02/04/2025 08:17:47 am >> SELECT document_num FROM ps_document WHERE document_num = '809' AND id_document != '96157' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-10') 02/04/2025 08:17:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '809', document_date = '2025-03-10', 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 = '105.00', price_tax_excluded = '98.32', date_upd = NOW() WHERE id_document = '96157' 02/04/2025 08:17:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96157' 02/04/2025 08:17:47 am >> DELETE FROM ps_document_detail WHERE id_document = '96157' 02/04/2025 08:17:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '22052' , 'CUSTODIA BIBBIA GERUSALEMME STUDIO - 744' , '1' , '-1' , '1' , '37.0700' , '30.385245901639' , '22' , '0' , '37.07' ) 02/04/2025 08:17:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.55' , '0.55' , '0' , '0' , '0.55' ) 02/04/2025 08:17:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 02/04/2025 08:17:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '6656' , 'MIE CONFESSIONI - S. AGOSTINO - 8300' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 02/04/2025 08:17:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '18117' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 02/04/2025 08:17:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '0' , '40.00' ) 02/04/2025 08:17:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96157' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 02/04/2025 08:37:16 am >> SELECT document_num FROM ps_document WHERE document_num = '849' AND id_document != '96206' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-12') 02/04/2025 08:37:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '849', document_date = '2025-03-12', 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.79', price_tax_excluded = '47.79', date_upd = NOW() WHERE id_document = '96206' 02/04/2025 08:37:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96206' 02/04/2025 08:37:16 am >> DELETE FROM ps_document_detail WHERE id_document = '96206' 02/04/2025 08:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96206' , '23464' , 'SALVE CROCE UNICA SPERANZA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/04/2025 08:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96206' , '23360' , 'QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 02/04/2025 08:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96206' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 02/04/2025 08:37:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96206' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '18' , '-18' , '4' , '2' , '2' , '0' , '0' , '36.00' ) 02/04/2025 08:37:36 am >> SELECT document_num FROM ps_document WHERE document_num = '861' AND id_document != '96221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-13') 02/04/2025 08:37:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '861', document_date = '2025-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', 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 = '680.00', price_tax_excluded = '573.47', date_upd = NOW() WHERE id_document = '96221' 02/04/2025 08:37: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 = '96221' 02/04/2025 08:37:36 am >> DELETE FROM ps_document_detail WHERE id_document = '96221' 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '12' , '-12' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '288.00' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '5' , '-5' , '4' , '2' , '2' , '0' , '0' , '10.00' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '4' , '-4' , '4' , '2.0000' , '2' , '0' , '0' , '8.00' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '19158' , 'SETTIMANA SANTA - N.E.' , '15' , '-15' , '4' , '5.0000' , '5' , '0' , '5' , '71.25' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 02/04/2025 08:37:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96221' , '23526' , 'CANDELIERE - 638/G' , '1' , '-1' , '1' , '149.9500' , '122.90983606557' , '22' , '0' , '149.95' ) 02/04/2025 08:37:54 am >> SELECT document_num FROM ps_document WHERE document_num = '876' AND id_document != '96245' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-15') 02/04/2025 08:37:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '876', document_date = '2025-03-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 = '94.20', price_tax_excluded = '87.35', date_upd = NOW() WHERE id_document = '96245' 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96245' 02/04/2025 08:37:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96245' 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '28.00' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '20' , '-20' , '4' , '2' , '2' , '0' , '0' , '40.00' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '23500' , 'CONDIVIDIAMO LA CROCE DI GESU - VIA CRUCIS - U. DE VANNA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 02/04/2025 08:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96245' , '23452' , 'TUTTO RICOMINCIA ' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 02/04/2025 08:38:24 am >> SELECT document_num FROM ps_document WHERE document_num = '879' AND id_document != '96249' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-15') 02/04/2025 08:38:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '879', document_date = '2025-03-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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '96249' 02/04/2025 08:38:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96249' 02/04/2025 08:38:25 am >> DELETE FROM ps_document_detail WHERE id_document = '96249' 02/04/2025 08:38:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96249' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/04/2025 08:38:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96249' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '22' , '-22' , '4' , '2' , '2' , '0' , '0' , '44.00' ) 02/04/2025 08:38:48 am >> SELECT document_num FROM ps_document WHERE document_num = '827' AND id_document != '96175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-11') 02/04/2025 08:38:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '827', document_date = '2025-03-11', 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 = '229.50', price_tax_excluded = '194.79', date_upd = NOW() WHERE id_document = '96175' 02/04/2025 08:38:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96175' 02/04/2025 08:38:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96175' 02/04/2025 08:38:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96175' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '84.00' ) 02/04/2025 08:38:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96175' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 02/04/2025 08:38:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96175' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 02/04/2025 08:38:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96175' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2025 08:38:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96175' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 02/04/2025 08:39:07 am >> SELECT document_num FROM ps_document WHERE document_num = '903' AND id_document != '96278' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-18') 02/04/2025 08:39:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '903', document_date = '2025-03-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '96278' 02/04/2025 08:39: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 = '96278' 02/04/2025 08:39:07 am >> DELETE FROM ps_document_detail WHERE id_document = '96278' 02/04/2025 08:39: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 ( '96278' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '9' , '-9' , '4' , '2' , '2' , '0' , '0' , '18.00' ) 02/04/2025 08:39:42 am >> SELECT document_num FROM ps_document WHERE document_num = '908' AND id_document != '96285' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-18') 02/04/2025 08:39:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '908', document_date = '2025-03-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.80', price_tax_excluded = '11.80', date_upd = NOW() WHERE id_document = '96285' 02/04/2025 08:39:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96285' 02/04/2025 08:39:42 am >> DELETE FROM ps_document_detail WHERE id_document = '96285' 02/04/2025 08:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96285' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 02/04/2025 08:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96285' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 02/04/2025 08:40:10 am >> SELECT document_num FROM ps_document WHERE document_num = '916' AND id_document != '96295' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-19') 02/04/2025 08:40:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '916', document_date = '2025-03-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '91.50', price_tax_excluded = '83.84', date_upd = NOW() WHERE id_document = '96295' 02/04/2025 08:40:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96295' 02/04/2025 08:40:11 am >> DELETE FROM ps_document_detail WHERE id_document = '96295' 02/04/2025 08:40:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96295' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '0' , '9.00' ) 02/04/2025 08:40:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96295' , '22052' , 'CUSTODIA BIBBIA GERUSALEMME STUDIO - 744' , '1' , '-1' , '1' , '37.5000' , '30.737704918033' , '22' , '0' , '37.50' ) 02/04/2025 08:40:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96295' , '9791' , 'SEGNABIBBIA - 3110' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 02/04/2025 08:40:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96295' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '0' , '40.00' ) 02/04/2025 08:40:38 am >> SELECT document_num FROM ps_document WHERE document_num = '935' AND id_document != '96315' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-20') 02/04/2025 08:40:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '935', document_date = '2025-03-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 = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '96315' 02/04/2025 08:40: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 = '96315' 02/04/2025 08:40:38 am >> DELETE FROM ps_document_detail WHERE id_document = '96315' 02/04/2025 08:40: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 ( '96315' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.75' , '0.75' , '0' , '0' , '0.75' ) 02/04/2025 08:40: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 ( '96315' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 02/04/2025 08:40: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 ( '96315' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '0' , '21.00' ) 02/04/2025 08:41:20 am >> SELECT document_num FROM ps_document WHERE document_num = '927' AND id_document != '96306' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-20') 02/04/2025 08:41:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '927', document_date = '2025-03-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 = '64.64', price_tax_excluded = '64.35', date_upd = NOW() WHERE id_document = '96306' 02/04/2025 08:41: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 = '96306' 02/04/2025 08:41:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96306' 02/04/2025 08:41: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 ( '96306' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.75' , '0.75' , '0' , '0' , '0.75' ) 02/04/2025 08:41: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 ( '96306' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/04/2025 08:41: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 ( '96306' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/04/2025 08:41: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 ( '96306' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 02/04/2025 08:41: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 ( '96306' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 02/04/2025 08:41: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 ( '96306' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 02/04/2025 08:41: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 ( '96306' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '10' , '-10' , '4' , '2' , '2' , '0' , '0' , '20.00' ) 02/04/2025 08:41:43 am >> SELECT document_num FROM ps_document WHERE document_num = '943' AND id_document != '96326' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-21') 02/04/2025 08:41:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '943', document_date = '2025-03-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 = '9.60', price_tax_excluded = '9.60', date_upd = NOW() WHERE id_document = '96326' 02/04/2025 08:41:43 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 = '96326' 02/04/2025 08:41:43 am >> DELETE FROM ps_document_detail WHERE id_document = '96326' 02/04/2025 08:41:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96326' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '9.6' , '9.6' , '0' , '0' , '9.60' ) 02/04/2025 08:42:04 am >> SELECT document_num FROM ps_document WHERE document_num = '961' AND id_document != '96348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 02/04/2025 08:42:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '961', document_date = '2025-03-24', 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 = '60.87', price_tax_excluded = '60.87', date_upd = NOW() WHERE id_document = '96348' 02/04/2025 08:42:05 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 = '96348' 02/04/2025 08:42:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96348' 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23464' , 'SALVE CROCE UNICA SPERANZA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23482' , 'VIA CRUCIS DELLA SPERANZA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23417' , 'VIA CRUCIS FONTE DI SPERANZA' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23498' , 'SPERANZA NELLA VIA DELLA CROCE' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 02/04/2025 08:42:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '22372' , 'VOLTO DI GESU IL SERVO CROCIFISSO - E. BIANCHI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 02/04/2025 08:42:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '22080' , 'LI AMO SINO ALLA FINE - QA. RAMINA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/04/2025 08:42:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/04/2025 08:42:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '15019' , 'PREGHIAMO CON MARIA' , '10' , '-10' , '4' , '0.8000' , '0.8' , '0' , '5' , '7.60' ) 02/04/2025 08:42:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96348' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 02/04/2025 08:43:04 am >> SELECT document_num FROM ps_document WHERE document_num = '962' AND id_document != '96349' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-24') 02/04/2025 08:43:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '962', document_date = '2025-03-24', 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 = '65.00', price_tax_excluded = '65.00', date_upd = NOW() WHERE id_document = '96349' 02/04/2025 08:43:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96349' 02/04/2025 08:43:04 am >> DELETE FROM ps_document_detail WHERE id_document = '96349' 02/04/2025 08:43: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 ( '96349' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 02/04/2025 08:43: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 ( '96349' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '22' , '-22' , '4' , '3.00' , '3' , '0' , '5' , '62.70' ) 02/04/2025 08:43:22 am >> SELECT document_num FROM ps_document WHERE document_num = '970' AND id_document != '96362' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-25') 02/04/2025 08:43:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '970', document_date = '2025-03-25', 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 = '18.50', price_tax_excluded = '16.53', date_upd = NOW() WHERE id_document = '96362' 02/04/2025 08:43:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96362' 02/04/2025 08:43:22 am >> DELETE FROM ps_document_detail WHERE id_document = '96362' 02/04/2025 08:43: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 ( '96362' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.9000' , '8.9344262295082' , '22' , '0' , '10.90' ) 02/04/2025 08:43: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 ( '96362' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '2' , '-2' , '4' , '2.4' , '2.4' , '0' , '0' , '4.80' ) 02/04/2025 08:43: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 ( '96362' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 02/04/2025 08:44:11 am >> SELECT document_num FROM ps_document WHERE document_num = '973' AND id_document != '96365' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-25') 02/04/2025 08:44:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '973', document_date = '2025-03-25', 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 = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '96365' 02/04/2025 08:44:11 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 = '96365' 02/04/2025 08:44:11 am >> DELETE FROM ps_document_detail WHERE id_document = '96365' 02/04/2025 08:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96365' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 02/04/2025 08:44:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96365' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '5' , '28.50' ) 02/04/2025 08:44:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1000' AND id_document != '96395' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 02/04/2025 08:44:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1000', document_date = '2025-03-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '68.00', price_tax_excluded = '62.77', date_upd = NOW() WHERE id_document = '96395' 02/04/2025 08:44: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 = '96395' 02/04/2025 08:44:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96395' 02/04/2025 08:44: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 ( '96395' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 02/04/2025 08:44: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 ( '96395' , '19724' , 'ROSARIO COPPIGLIATO S. FAMIGLIA MM8 - RE1717-SM' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 02/04/2025 08:44: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 ( '96395' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 02/04/2025 08:44: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 ( '96395' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 02/04/2025 08:44: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 ( '96395' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '5' , '37.05' ) 02/04/2025 08:44: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 ( '96395' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '1.95' , '1.95' , '0' , '0' , '1.95' ) 02/04/2025 08:46:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1033' AND id_document != '96442' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 02/04/2025 08:46:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1033', document_date = '2025-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '96442' 02/04/2025 08:46:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96442' 02/04/2025 08:46:32 am >> DELETE FROM ps_document_detail WHERE id_document = '96442' 02/04/2025 08:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96442' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.75' , '0.75' , '0' , '0' , '0.75' ) 02/04/2025 08:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96442' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 02/04/2025 08:46:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96442' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 02/04/2025 08:47:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1020' AND id_document != '96424' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 02/04/2025 08:47:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1020', document_date = '2025-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '8.10', date_upd = NOW() WHERE id_document = '96424' 02/04/2025 08:47: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 = '96424' 02/04/2025 08:47:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96424' 02/04/2025 08:47: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 ( '96424' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.7000' , '0.7' , '0' , '0' , '2.10' ) 02/04/2025 08:47: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 ( '96424' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 02/04/2025 08:47: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 ( '96424' , '20758' , 'SEGNALIBRO 5X15' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 02/04/2025 08:47: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 ( '96424' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '2' , '-2' , '4' , '2.1' , '2.1' , '0' , '0' , '4.20' ) 02/04/2025 08:47:53 am >> SELECT document_num FROM ps_document WHERE document_num = '715' AND id_document != '96029' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-05') 02/04/2025 08:47:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '715', document_date = '2025-03-05', 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 = '289.05', price_tax_excluded = '289.05', date_upd = NOW() WHERE id_document = '96029' 02/04/2025 08:47:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96029' 02/04/2025 08:47:54 am >> DELETE FROM ps_document_detail WHERE id_document = '96029' 02/04/2025 08:47:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96029' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/04/2025 08:47:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96029' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 02/04/2025 08:47:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96029' , '23500' , 'CONDIVIDIAMO LA CROCE DI GESU - VIA CRUCIS - U. DE VANNA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 02/04/2025 08:47:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96029' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 02/04/2025 08:47:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96029' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '100' , '-100' , '4' , '2.7' , '2.7' , '0' , '0' , '270.00' ) 02/04/2025 09:09:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/04/2025 09:09:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23633' , '1' , '' , 'nuovo-prodotto' ) 02/04/2025 09:09:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23633' , '1' , '1' , '2' , NOW() , NOW() ) 02/04/2025 09:09:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23633' , '0' , '1' , '0' , '0' ) 02/04/2025 09:10:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002370' AND id_product != '23633' AND ean13 != '' 02/04/2025 09:10:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002370', date_upd = NOW() WHERE id_product = '23633' 02/04/2025 09:10:18 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - 8309', description = '' WHERE id_product = '23633' 02/04/2025 09:10:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '299.1803278688525' WHERE id_product = '23633' 02/04/2025 09:10:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '299.1803278688525', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23633' 02/04/2025 09:10:19 am >> DELETE FROM ps_specific_price WHERE id_product = '23633' 02/04/2025 09:11:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002370' AND id_product != '23633' AND ean13 != '' 02/04/2025 09:11:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002370', date_upd = NOW() WHERE id_product = '23633' 02/04/2025 09:11:13 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - 8309', description = '' WHERE id_product = '23633' 02/04/2025 09:11:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '299.1803278688525' WHERE id_product = '23633' 02/04/2025 09:11:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '299.1803278688525', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23633' 02/04/2025 09:11:13 am >> DELETE FROM ps_specific_price WHERE id_product = '23633' 02/04/2025 09:11:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002370' AND id_product != '23633' AND ean13 != '' 02/04/2025 09:11:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002370', date_upd = NOW() WHERE id_product = '23633' 02/04/2025 09:11:49 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - 8309', description = '' WHERE id_product = '23633' 02/04/2025 09:11:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '299.1803278688525' WHERE id_product = '23633' 02/04/2025 09:11:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '299.1803278688525', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23633' 02/04/2025 09:11:49 am >> DELETE FROM ps_specific_price WHERE id_product = '23633' 02/04/2025 09:11:50 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23633' 02/04/2025 09:11:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23634' , '1' , '' , 'nuovo-prodotto' ) 02/04/2025 09:11:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23634' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23633' 02/04/2025 09:11:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23634' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23633' 02/04/2025 09:12:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002371' AND id_product != '23634' AND ean13 != '' 02/04/2025 09:12:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002371', date_upd = NOW() WHERE id_product = '23634' 02/04/2025 09:12:28 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA LANA - 7930L', description = '' WHERE id_product = '23634' 02/04/2025 09:12:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '516.3934426229508' WHERE id_product = '23634' 02/04/2025 09:12:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '516.3934426229508', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23634' 02/04/2025 09:12:28 am >> DELETE FROM ps_specific_price WHERE id_product = '23634' 02/04/2025 09:13:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '30/2025' , '2025-03-31' , '2025' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '661.24' , '542.00' , NOW() , NOW() ) 02/04/2025 09:13:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96469' 02/04/2025 09:13:06 am >> DELETE FROM ps_document_detail WHERE id_document = '96469' 02/04/2025 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96469' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '1' , '1' , '75' , '61.475409836066' , '22' , '0' , '91.5000' ) 02/04/2025 09:13:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '18184' AND id_supplier = '126' 02/04/2025 09:13:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18184' , '126' , '1' ) 02/04/2025 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96469' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 02/04/2025 09:13:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 02/04/2025 09:13:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 02/04/2025 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96469' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '1' , '1' , '25' , '20.491803278689' , '22' , '0' , '30.5000' ) 02/04/2025 09:13:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126' 02/04/2025 09:13:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' ) 02/04/2025 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96469' , '23633' , 'CASULA MARIANA - 8309' , '1' , '1' , '1' , '150' , '122.95081967213' , '22' , '0' , '183.0000' ) 02/04/2025 09:13:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '23633' AND id_supplier = '126' 02/04/2025 09:13:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23633' , '126' , '1' ) 02/04/2025 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96469' , '23634' , 'CASULA MARIANA LANA - 7930L' , '1' , '1' , '1' , '260' , '213.11475409836' , '22' , '0' , '317.2000' ) 02/04/2025 09:13:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '23634' AND id_supplier = '126' 02/04/2025 09:13:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23634' , '126' , '1' ) 02/04/2025 10:21:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1053' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 10:21: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' , '1053' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 02/04/2025 10:21: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 = '96470' 02/04/2025 10:21:21 am >> DELETE FROM ps_document_detail WHERE id_document = '96470' 02/04/2025 10:21: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 ( '96470' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 02/04/2025 11:08:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1054' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:08:34 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' , '1054' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 02/04/2025 11:08:34 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 = '96471' 02/04/2025 11:08:34 am >> DELETE FROM ps_document_detail WHERE id_document = '96471' 02/04/2025 11:08:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96471' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' ) 02/04/2025 11:08:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96471' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 02/04/2025 11:08:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96471' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '6.50' ) 02/04/2025 11:11:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1055' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:11:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1055' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.15' , '6.15' , NOW() , NOW() ) 02/04/2025 11:11:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96472' 02/04/2025 11:11:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96472' 02/04/2025 11:11:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96472' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/04/2025 11:11:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96472' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 02/04/2025 11:22:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1056' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:22:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1056' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '137.00' , '112.30' , NOW() , NOW() ) 02/04/2025 11:22:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96473' 02/04/2025 11:22:24 am >> DELETE FROM ps_document_detail WHERE id_document = '96473' 02/04/2025 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96473' , '1515' , 'CALICE CM 15 INT.ORO IHS' , '1' , '-1' , '1' , '137.00' , '112.29508196721' , '22' , '0' , '137.00' ) 02/04/2025 11:25:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1057' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:25:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1057' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 02/04/2025 11:25:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96474' 02/04/2025 11:25:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96474' 02/04/2025 11:25:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96474' , '6154' , 'MAGNETI IMBUSTATI CM 4X6 - OGGETTI' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/04/2025 11:26:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1058' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:26:14 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' , '1058' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 02/04/2025 11:26:14 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 = '96475' 02/04/2025 11:26:14 am >> DELETE FROM ps_document_detail WHERE id_document = '96475' 02/04/2025 11:26:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96475' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/04/2025 11:34:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1059' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:34:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1059' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 02/04/2025 11:34:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96476' 02/04/2025 11:34:12 am >> DELETE FROM ps_document_detail WHERE id_document = '96476' 02/04/2025 11:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96476' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 02/04/2025 11:39:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1060' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:39:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1060' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.25' , '10.04' , NOW() , NOW() ) 02/04/2025 11:39:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96477' 02/04/2025 11:39:10 am >> DELETE FROM ps_document_detail WHERE id_document = '96477' 02/04/2025 11:39:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96477' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/04/2025 11:39:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96477' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/04/2025 11:39:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96477' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/04/2025 11:57:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 11:57:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1061' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 02/04/2025 11:57: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 = '96478' 02/04/2025 11:57:03 am >> DELETE FROM ps_document_detail WHERE id_document = '96478' 02/04/2025 11:57: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 ( '96478' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 02/04/2025 12:32:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 12:32: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 ( '24' , '62/A' , '2025-04-02' , 'A' , '1213' , '0' , '4679403' , 'VIA MARCONI 115 83025 MONTORO INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '530.00' , '530.00' , NOW() , NOW() ) 02/04/2025 12:32: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 = '96479' 02/04/2025 12:32:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '96479' 02/04/2025 12:32: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 ( '96479' , '' , 'OSTENSORIO' , '1' , '-1' , '0' , '530' , '530' , '' , '0' , '530.00' ) 02/04/2025 12:38:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 12:38: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' , '1062' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.00' , '76.23' , NOW() , NOW() ) 02/04/2025 12:38: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 = '96480' 02/04/2025 12:38:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96480' 02/04/2025 12:38: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 ( '96480' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '-2' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '70.00' ) 02/04/2025 12:38: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 ( '96480' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '-2' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '23.00' ) 02/04/2025 12:38:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 12:38:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1063' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.50' , '45.49' , NOW() , NOW() ) 02/04/2025 12:38:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96481' 02/04/2025 12:38:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '96481' 02/04/2025 12:38:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96481' , '17533' , 'CINGOLO ORO/COL - CING06' , '3' , '-3' , '1' , '18.5' , '15.16393442623' , '22' , '0' , '55.50' ) 02/04/2025 12:41:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '96479' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 12:41:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '62/A', document_date = '2025-04-02', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA MARCONI 115 83025 MONTORO INFERIORE', 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 = '550.00', price_tax_excluded = '546.39', date_upd = NOW() WHERE id_document = '96479' 02/04/2025 12:41:13 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 = '96479' 02/04/2025 12:41:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '96479' 02/04/2025 12:41:13 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 ( '96479' , '0' , 'OSTENSORIO' , '1' , '-1' , '0' , '530.0000' , '530' , '0' , '0' , '530.00' ) 02/04/2025 12:41:13 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 ( '96479' , '5976' , 'LUCERNA VETRO - 1493' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 02/04/2025 12:53:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '975' AND id_document != '96367' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 02/04/2025 12:53:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '975', document_date = '2025-03-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '209.60', price_tax_excluded = '175.14', date_upd = NOW() WHERE id_document = '96367' 02/04/2025 12:53: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 = '96367' 02/04/2025 12:53:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96367' 02/04/2025 12:53: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 ( '96367' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/04/2025 12:53: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 ( '96367' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 02/04/2025 12:53: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 ( '96367' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '23.70' ) 02/04/2025 12:53: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 ( '96367' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 02/04/2025 12:53: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 ( '96367' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 02/04/2025 12:53: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 ( '96367' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '84.00' ) 02/04/2025 12:53: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 ( '96367' , '5976' , 'LUCERNA VETRO - 1493' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 02/04/2025 12:57:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '96479' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 12:57:24 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '62/A', document_date = '2025-04-02', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA MARCONI 115 83025 MONTORO INFERIORE', 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 = '530.00', price_tax_excluded = '530.00', date_upd = NOW() WHERE id_document = '96479' 02/04/2025 12:57: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 = '96479' 02/04/2025 12:57:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96479' 02/04/2025 12:57: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 ( '96479' , '0' , 'OSTENSORIO' , '1' , '-1' , '0' , '530.0000' , '530' , '0' , '0' , '530.00' ) 02/04/2025 12:58:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '875' AND id_document != '96244' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-15') 02/04/2025 12:58:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '875', document_date = '2025-03-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96244' 02/04/2025 12:58: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 = '96244' 02/04/2025 12:58:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '96244' 02/04/2025 12:58: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 ( '96244' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 02/04/2025 12:58: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 ( '96244' , '5976' , 'LUCERNA VETRO - 1493' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 02/04/2025 03:08:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 03:08:31 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' , '1064' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '25.26' , NOW() , NOW() ) 02/04/2025 03:08:31 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 = '96482' 02/04/2025 03:08:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '96482' 02/04/2025 03:08:31 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 ( '96482' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2025 03:08:31 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 ( '96482' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 02/04/2025 03:08:31 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 ( '96482' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 02/04/2025 03:31:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 03:31:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '63/A' , '2025-04-02' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.80' , '18.48' , NOW() , NOW() ) 02/04/2025 03:31: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 = '96483' 02/04/2025 03:31:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96483' 02/04/2025 03:31: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 ( '96483' , '23503' , 'TRISTE CASO DELLOMELIA - F. ROSINI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 02/04/2025 03:31: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 ( '96483' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 02/04/2025 04:00:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 04:00:29 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 ( '23' , '10/L' , '2025-04-02' , 'L' , '202' , '0' , '4670823' , 'VIA BRIGNANO INFERIORE, 31 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 02/04/2025 04:00:29 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 = '96484' 02/04/2025 04:00:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96484' 02/04/2025 04:00:29 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 ( '96484' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '58' , '-58' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '17.40' ) 02/04/2025 04:00:29 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 ( '96484' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '42' , '-42' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '12.60' ) 02/04/2025 04:00:29 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 ( '96484' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '20' , '-20' , '1' , '1' , '0.81967213114754' , '22' , '0' , '20.00' ) 02/04/2025 04:10:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 04:10:39 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' , '1065' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 02/04/2025 04:10:39 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 = '96485' 02/04/2025 04:10:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96485' 02/04/2025 04:10:39 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 ( '96485' , '18222' , 'ROSARIO COLORATO - R316' , '40' , '-40' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '28.00' ) 02/04/2025 04:12:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '932' AND id_document != '96312' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-20') 02/04/2025 04:12:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '932', document_date = '2025-03-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 = '96.50', price_tax_excluded = '83.38', date_upd = NOW() WHERE id_document = '96312' 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96312' 02/04/2025 04:12:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96312' 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '-1' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '17.50' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' , '0.55' , '0.45081967213115' , '22' , '0' , '0.55' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '2' , '-2' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '4.40' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 02/04/2025 04:12:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96312' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '1.30' ) 02/04/2025 04:25:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 04:25: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' , '1066' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 02/04/2025 04:25: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 = '96486' 02/04/2025 04:25:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '96486' 02/04/2025 04:25: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 ( '96486' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' ) 02/04/2025 04:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 04:26:18 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' , '1067' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '4.20' , NOW() , NOW() ) 02/04/2025 04:26:18 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 = '96487' 02/04/2025 04:26:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '96487' 02/04/2025 04:26:18 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 ( '96487' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '3' , '-3' , '4' , '1.40' , '1.4' , '0' , '0' , '4.20' ) 02/04/2025 04:45:18 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '84-2025', document_date = '2025-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', address2 = '', note = 'INS NUMERO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '1582.25', price_tax_excluded = '1296.93', date_upd = NOW() WHERE id_document = '96425' 02/04/2025 04:45:18 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 = '96425' 02/04/2025 04:45:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '96425' 02/04/2025 04:45:18 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 ( '96425' , '23619' , 'COTTA MISTO SETA - COTTA18' , '1' , '1' , '1' , '205.0000' , '168.03278688525' , '22' , '3' , '242.60' ) 02/04/2025 04:45:18 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 ( '96425' , '23620' , 'CAMICE AVORIO GIGLIUCCIO - 19/3 PL' , '2' , '2' , '1' , '95.0000' , '77.868852459016' , '22' , '3' , '224.85' ) 02/04/2025 04:45:18 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 ( '96425' , '16456' , 'CINGOLO - CING03' , '10' , '10' , '1' , '5.9000' , '4.8360655737705' , '22' , '3' , '69.82' ) 02/04/2025 04:45:18 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 ( '96425' , '23617' , 'BORDO MACRAME\' PUNTINA - P400' , '14' , '14' , '1' , '2.7400' , '2.2459016393443' , '22' , '3' , '45.07' ) 02/04/2025 04:45:18 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 ( '96425' , '23614' , 'FERMAGLIO - B314/FE' , '6' , '6' , '1' , '6.3500' , '5.2049180327869' , '22' , '3' , '45.09' ) 02/04/2025 04:45:18 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 ( '96425' , '18586' , 'FERMAGLIO - B256/FE' , '6' , '6' , '1' , '7.0900' , '5.8114754098361' , '22' , '3' , '50.34' ) 02/04/2025 04:45:18 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 ( '96425' , '23618' , 'GALLONE ORO - GA-P06' , '25' , '25' , '1' , '4.5000' , '3.6885245901639' , '22' , '3' , '133.13' ) 02/04/2025 04:45:18 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 ( '96425' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '14' , '14' , '1' , '21.6300' , '17.729508196721' , '22' , '3' , '345.56' ) 02/04/2025 04:45:18 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 ( '96425' , '23616' , 'PIZZO MACRAME SACRO CUORE - P537' , '14' , '14' , '1' , '25.7000' , '21.065573770492' , '22' , '3' , '425.79' ) 02/04/2025 04:45:29 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '84-2025', document_date = '2025-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '1582.25', price_tax_excluded = '1296.93', date_upd = NOW() WHERE id_document = '96425' 02/04/2025 04:45:29 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 = '96425' 02/04/2025 04:45:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96425' 02/04/2025 04:45:29 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 ( '96425' , '23619' , 'COTTA MISTO SETA - COTTA18' , '1' , '1' , '1' , '205.0000' , '168.03278688525' , '22' , '3' , '242.60' ) 02/04/2025 04:45:29 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 ( '96425' , '23620' , 'CAMICE AVORIO GIGLIUCCIO - 19/3 PL' , '2' , '2' , '1' , '95.0000' , '77.868852459016' , '22' , '3' , '224.85' ) 02/04/2025 04:45:29 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 ( '96425' , '16456' , 'CINGOLO - CING03' , '10' , '10' , '1' , '5.9000' , '4.8360655737705' , '22' , '3' , '69.82' ) 02/04/2025 04:45:29 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 ( '96425' , '23617' , 'BORDO MACRAME\' PUNTINA - P400' , '14' , '14' , '1' , '2.7400' , '2.2459016393443' , '22' , '3' , '45.07' ) 02/04/2025 04:45:29 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 ( '96425' , '23614' , 'FERMAGLIO - B314/FE' , '6' , '6' , '1' , '6.3500' , '5.2049180327869' , '22' , '3' , '45.09' ) 02/04/2025 04:45:29 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 ( '96425' , '18586' , 'FERMAGLIO - B256/FE' , '6' , '6' , '1' , '7.0900' , '5.8114754098361' , '22' , '3' , '50.34' ) 02/04/2025 04:45:29 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 ( '96425' , '23618' , 'GALLONE ORO - GA-P06' , '25' , '25' , '1' , '4.5000' , '3.6885245901639' , '22' , '3' , '133.13' ) 02/04/2025 04:45:29 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 ( '96425' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '14' , '14' , '1' , '21.6300' , '17.729508196721' , '22' , '3' , '345.56' ) 02/04/2025 04:45:29 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 ( '96425' , '23616' , 'PIZZO MACRAME SACRO CUORE - P537' , '14' , '14' , '1' , '25.7000' , '21.065573770492' , '22' , '3' , '425.79' ) 02/04/2025 05:00: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 ( '32' , '6025211149' , '2025-03-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '326.69' , '326.69' , NOW() , NOW() ) 02/04/2025 05:00: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 = '96488' 02/04/2025 05:00:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '96488' 02/04/2025 05:00: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 ( '96488' , '23497' , 'ALFA E OMEGA - SANCHEZ' , '4' , '0' , '4' , '20.89' , '20.89' , '0' , '0' , '83.5600' ) 02/04/2025 05:00:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23497' AND id_supplier = '109' 02/04/2025 05:00:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23497' , '109' , '1' ) 02/04/2025 05:00: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 ( '96488' , '22187' , 'SETTE SACRAMENTI CREATIVI - A. QUEIROLO' , '1' , '0' , '4' , '8.64' , '8.64' , '0' , '0' , '8.6400' ) 02/04/2025 05:00:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22187' AND id_supplier = '109' 02/04/2025 05:00:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22187' , '109' , '1' ) 02/04/2025 05:00: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 ( '96488' , '23272' , 'BOTTA E RISPOSTA CON I GIOVANI... - M. BOTTA' , '1' , '0' , '4' , '10.8' , '10.8' , '0' , '0' , '10.8000' ) 02/04/2025 05:00:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23272' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23272' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '0' , '4' , '17.93' , '17.93' , '0' , '0' , '17.9300' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22334' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22334' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23522' , 'FILOSOFIA 1' , '2' , '0' , '4' , '26.91' , '26.91' , '0' , '0' , '53.8200' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23522' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23522' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23523' , 'EPISTEMOLOGIA E COSMOLOGIA' , '2' , '0' , '4' , '20.155' , '20.155' , '0' , '0' , '40.3100' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23523' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23523' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23537' , 'FILOSOFIA DELLEDUCAZIONE' , '1' , '0' , '4' , '15.59' , '15.59' , '0' , '0' , '15.5900' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23537' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23537' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23416' , 'CREDO COMPENDIO DELLA FEDE CATTOLICA - A. SCHNEIDER' , '1' , '0' , '4' , '18.65' , '18.65' , '0' , '0' , '18.6500' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23416' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23416' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23569' , 'TRADUZIONE - P. RICOEUR' , '3' , '0' , '4' , '8.046' , '8.046' , '0' , '0' , '24.1380' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23569' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23569' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23568' , 'MICHEL DE CERTEAU - L. EPICOCO' , '2' , '0' , '4' , '12.435' , '12.435' , '0' , '0' , '24.8700' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23568' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23568' , '109' , '1' ) 02/04/2025 05:00:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96488' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '2' , '0' , '4' , '14.19' , '14.19' , '0' , '0' , '28.3800' ) 02/04/2025 05:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 02/04/2025 05:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 02/04/2025 05:05: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 ( '32' , '6025211150' , '2025-03-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '263.65' , '263.65' , NOW() , NOW() ) 02/04/2025 05:05: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 = '96489' 02/04/2025 05:05:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '96489' 02/04/2025 05:05: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 ( '96489' , '23538' , 'CHIAMATI ALLA SANTITA\' - G. CALABRESE' , '1' , '0' , '4' , '12.7' , '12.7' , '0' , '0' , '12.7000' ) 02/04/2025 05:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23538' AND id_supplier = '109' 02/04/2025 05:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23538' , '109' , '1' ) 02/04/2025 05:05: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 ( '96489' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '0' , '4' , '27.23' , '27.23' , '0' , '0' , '27.2300' ) 02/04/2025 05:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 02/04/2025 05:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 02/04/2025 05:05: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 ( '96489' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '4' , '0' , '4' , '27.8975' , '27.8975' , '0' , '0' , '111.5900' ) 02/04/2025 05:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23256' AND id_supplier = '109' 02/04/2025 05:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23256' , '109' , '1' ) 02/04/2025 05:05: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 ( '96489' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '0' , '4' , '34.59' , '34.59' , '0' , '0' , '34.5900' ) 02/04/2025 05:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 02/04/2025 05:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 02/04/2025 05:05: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 ( '96489' , '22284' , 'BIBBIA DI GERUSALEMME - TASC. AZZURRA' , '2' , '0' , '4' , '15.94' , '15.94' , '0' , '0' , '31.8800' ) 02/04/2025 05:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22284' AND id_supplier = '109' 02/04/2025 05:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22284' , '109' , '1' ) 02/04/2025 05:05: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 ( '96489' , '23570' , 'HANNO PARLATO CON DIO - STAGLIANO / DRAGONE' , '1' , '0' , '4' , '10.72' , '10.72' , '0' , '0' , '10.7200' ) 02/04/2025 05:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23570' AND id_supplier = '109' 02/04/2025 05:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23570' , '109' , '1' ) 02/04/2025 05:05: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 ( '96489' , '23571' , 'PERCORSI SPONSALI - P. GUSMITTA' , '2' , '0' , '4' , '17.47' , '17.47' , '0' , '0' , '34.9400' ) 02/04/2025 05:05:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23571' AND id_supplier = '109' 02/04/2025 05:05:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23571' , '109' , '1' ) 02/04/2025 05:15:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1068' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 05:15: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' , '1068' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '210.00' , '172.13' , NOW() , NOW() ) 02/04/2025 05:15: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 = '96490' 02/04/2025 05:15:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '96490' 02/04/2025 05:15: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 ( '96490' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '125.00' , '102.45901639344' , '22' , '0' , '125.00' ) 02/04/2025 05:15: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 ( '96490' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 02/04/2025 05:15: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 ( '96490' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 02/04/2025 05:18: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 ( '32' , '726' , '2025-03-31' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.52' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.47' , '109.47' , NOW() , NOW() ) 02/04/2025 05:18: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 = '96491' 02/04/2025 05:18:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '96491' 02/04/2025 05:18: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 ( '96491' , '23501' , 'DAVANTI A GESU EUCARISTIA ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 02/04/2025 05:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23501' AND id_supplier = '47' 02/04/2025 05:18:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23501' , '47' , '1' ) 02/04/2025 05:18: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 ( '96491' , '23503' , 'TRISTE CASO DELLOMELIA - F. ROSINI' , '3' , '0' , '4' , '17.0000' , '17' , '0' , '30' , '35.70' ) 02/04/2025 05:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23503' AND id_supplier = '47' 02/04/2025 05:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23503' , '47' , '1' ) 02/04/2025 05:18:51 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 ( '96491' , '23558' , 'TEMPI DI MARIA - P. PEDALINO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 02/04/2025 05:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23558' AND id_supplier = '47' 02/04/2025 05:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23558' , '47' , '1' ) 02/04/2025 05:18:51 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 ( '96491' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 02/04/2025 05:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22956' AND id_supplier = '47' 02/04/2025 05:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22956' , '47' , '1' ) 02/04/2025 05:18:51 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 ( '96491' , '23559' , 'CONSACRAZIONE A SAN GIUSEPPE - GAVA' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 02/04/2025 05:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23559' AND id_supplier = '47' 02/04/2025 05:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23559' , '47' , '1' ) 02/04/2025 05:18:51 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 ( '96491' , '23560' , 'PADRE PIO UN SANTO SCOMODO - A. PRONZATO' , '1' , '0' , '4' , '17.5000' , '17.5' , '0' , '30' , '12.25' ) 02/04/2025 05:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23560' AND id_supplier = '47' 02/04/2025 05:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23560' , '47' , '1' ) 02/04/2025 05:18:51 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 ( '96491' , '23561' , 'NOSTRA BOCCA SI APRE AL SORRISO - A. PRONZATO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 02/04/2025 05:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23561' AND id_supplier = '47' 02/04/2025 05:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23561' , '47' , '1' ) 02/04/2025 05:19:32 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '1/187', document_date = '2025-03-31', document_letter = '187', id_customer = '0', id_supplier = '', id_address = '4670575', address1 = 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.25', price_tax_excluded = '37.09', date_upd = NOW() WHERE id_document = '96426' 02/04/2025 05:19:32 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 = '96426' 02/04/2025 05:19:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '96426' 02/04/2025 05:19:32 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 ( '96426' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '2' , '2' , '1' , '5.3279' , '4.367131147541' , '22' , '0' , '13.00' ) 02/04/2025 05:19:32 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 ( '96426' , '23621' , 'MEDAGLIA S. RITA ARG' , '2' , '2' , '1' , '13.2170' , '10.833606557377' , '22' , '0' , '32.25' ) 02/04/2025 05:49:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 05:49:30 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' , '1069' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 02/04/2025 05:49:30 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 = '96492' 02/04/2025 05:49:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '96492' 02/04/2025 05:49:30 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 ( '96492' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 02/04/2025 05:51:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '95849' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-02-21') 02/04/2025 05:51:08 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '6', document_date = '2025-02-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = 'RESA - n. c. ricevuta', 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 = '1003.20', price_tax_excluded = '1003.20', date_upd = NOW() WHERE id_document = '95849' 02/04/2025 05:51: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 = '95849' 02/04/2025 05:51:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95849' 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '17' , '-17' , '4' , '14.0000' , '14' , '0' , '0' , '238.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '20832' , 'BONTA DELLA FEDE - S. TARDANI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '21341' , 'IMPARANDO DALLE DONNE - F. CERAGIOLI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '20939' , 'REGOLA DI FRANCESCO SPIEGATA - G. BUFFON' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '10732' , 'TRINITÀ - AGOSTINO' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '5727' , 'LETTERE DI IGNAZIO DANTIOCHIA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '22282' , 'FIGLI DI CHI? QUALE FUTURO CI ASPETTA - S. TARDANI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '21451' , 'UNA SPIRITUALITA ECCLESIALE - G. ROSSE' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '16520' , 'CHIARA LUBICH' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '23295' , 'DISCORSO DELLA MONTAGNA - P. LAPIDE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '19913' , 'PARLARE DELLE SCRITTURE - P. BEAUCHAMP' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '19382' , 'REGNO DEI CIELI E PIENO COMPIMENTO - E. MANICARDI' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '17410' , 'NUOVO DIZIONARIO TEOLOGICO INTERDISCIPLINARE' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '9067' , 'ROSARIO - R.BARILE' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '17775' , 'PREGARE IN LATINO E ITALIANO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '17597' , 'SALMI NEL CANTO DELLAMORE - SPARTITO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '20489' , 'SALMI NEL CANTO LAMORE - M. VERSACI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 02/04/2025 05:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95849' , '20834' , 'SALMI - M. VERSACI ' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 02/04/2025 05:51: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 ( '95849' , '18503' , 'SALMI NEL CANTO DELLAMORE - M. VERSACI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 02/04/2025 05:51: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 ( '95849' , '22571' , 'BENEDETTO IL GIORNO CHE ABBIAMO SBAGLIATO - C. MIRIANO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 02/04/2025 05:51: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 ( '95849' , '23042' , 'PADRE NOSTRO - J. ZUMSTEIN' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 02/04/2025 05:51: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 ( '95849' , '19918' , 'LO RICONOBBERO NELLO SPEZZARE ... - E. MALNATI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 02/04/2025 05:51: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 ( '95849' , '21450' , 'PERDONATE E SARETE PERDONATI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 02/04/2025 05:51: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 ( '95849' , '23078' , 'DELITTO MATTEOTTI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 02/04/2025 05:51: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 ( '95849' , '23233' , 'AD THEOLOGIAM PROMOVENDAM' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 02/04/2025 05:51: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 ( '95849' , '23322' , 'MI AMI TU? - M. PAVAN' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 02/04/2025 05:51: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 ( '95849' , '19839' , 'SAN GIOVANNI DELLA CROCE - M. TONDO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 02/04/2025 05:51: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 ( '95849' , '12559' , 'TOCCARE LA SANTITA - AAVV' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 02/04/2025 05:51: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 ( '95849' , '23234' , 'AGENDA MISSIONARIA 2025' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 02/04/2025 05:51: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 ( '95849' , '17355' , 'IN OGNI COSA RENDETE GRAZIE ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 02/04/2025 05:51: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 ( '95849' , '16198' , 'SACRA BIBBIA CEI CON LECTIO DIVINA' , '1' , '-1' , '4' , '39.5000' , '39.5' , '0' , '0' , '39.50' ) 02/04/2025 05:51: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 ( '95849' , '20637' , 'INTRODUZIONE ALLA TEOLOGIA - G. PASQUALE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 02/04/2025 05:51: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 ( '95849' , '20976' , 'CHIESA SACRAMENTO DI UNITA ' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 02/04/2025 05:51: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 ( '95849' , '21872' , 'TU SEI LA MIA ROVINA - A. MUSOLESI' , '1' , '-1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 02/04/2025 05:51: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 ( '95849' , '22863' , 'E LA TUA PARTE - PICCOLISSIMI' , '2' , '-2' , '4' , '16.5000' , '16.5' , '0' , '0' , '33.00' ) 02/04/2025 05:51: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 ( '95849' , '22862' , 'E LA TUA PARTE 1 - 6/8 ANNI' , '2' , '-2' , '4' , '16.5000' , '16.5' , '0' , '0' , '33.00' ) 02/04/2025 05:51: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 ( '95849' , '22864' , 'E LA TUA PARTE 2 - 9/11 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 02/04/2025 05:51: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 ( '95849' , '22985' , 'CHE PESCI PIGLIARE ' , '2' , '-2' , '4' , '11.5000' , '11.5' , '0' , '0' , '23.00' ) 02/04/2025 05:51: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 ( '95849' , '22867' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 02/04/2025 05:51: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 ( '95849' , '22868' , 'DENTRO E ATTRAVERSO LESISTENZA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 02/04/2025 05:51: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 ( '95849' , '22665' , 'DOMANDE CHE NON TI HO FATTO - FRATINI/SEGHEDONI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 02/04/2025 05:51: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 ( '95849' , '21019' , 'DON PINO PUGLISI DON PEPPE DIANA' , '1' , '-1' , '4' , '20.9000' , '20.9' , '0' , '0' , '20.90' ) 02/04/2025 05:51: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 ( '95849' , '20490' , 'DIACONO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 02/04/2025 06:58:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-02') 02/04/2025 06:58: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' , '1070' , '2025-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.50' , '94.75' , NOW() , NOW() ) 02/04/2025 06:58: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 = '96493' 02/04/2025 06:58:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96493' 02/04/2025 06:58: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 ( '96493' , '23612' , 'CAMICE TALARE ROSSA - 431TPR' , '1' , '-1' , '1' , '109.50' , '89.754098360656' , '22' , '0' , '109.50' ) 02/04/2025 06:58: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 ( '96493' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' )