11/12/2024 09:27:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 09:27:49 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' , '3897' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.23' , NOW() , NOW() ) 11/12/2024 09:27:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94800' 11/12/2024 09:27:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94800' 11/12/2024 09:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94800' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 11/12/2024 09:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94800' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 11/12/2024 09:45:38 am >> SELECT document_num FROM ps_document WHERE document_num = '263' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 09:45:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '263' , '2024-12-11' , '' , '65' , '0' , '4679378' , 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '24.00' , '24.00' , NOW() , NOW() ) 11/12/2024 09:45: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 = '94801' 11/12/2024 09:45:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94801' 11/12/2024 09:45: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 ( '94801' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 11/12/2024 10:56:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 10:56:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3898' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '32.96' , NOW() , NOW() ) 11/12/2024 10:56:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94802' 11/12/2024 10:56:08 am >> DELETE FROM ps_document_detail WHERE id_document = '94802' 11/12/2024 10:56:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94802' , '6720' , 'MIRACOLI EUCARISTICI - 8735' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 11/12/2024 10:56:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94802' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 11/12/2024 10:56:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94802' , '20758' , 'SEGNALIBRO 5X15' , '1' , '-1' , '1' , '.22' , '0.18032786885246' , '22' , '0' , '0.22' ) 11/12/2024 11:14:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 11:14:42 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' , '3899' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.08' , NOW() , NOW() ) 11/12/2024 11:14: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 = '94803' 11/12/2024 11:14:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94803' 11/12/2024 11:14: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 ( '94803' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 11/12/2024 11:48:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3666' AND id_document != '94517' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 11/12/2024 11:48:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3666', document_date = '2024-11-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 = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '94517' 11/12/2024 11:48: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 = '94517' 11/12/2024 11:48:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94517' 11/12/2024 11:48: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 ( '94517' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 11/12/2024 11:48:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3757' AND id_document != '94627' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 11/12/2024 11:48:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3757', document_date = '2024-12-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.90', price_tax_excluded = '9.75', date_upd = NOW() WHERE id_document = '94627' 11/12/2024 11:48:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94627' 11/12/2024 11:48:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94627' 11/12/2024 11:48: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 ( '94627' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 11/12/2024 11:48: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 ( '94627' , '21137' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 11/12/2024 11:49:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2928' AND id_document != '93473' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-05') 11/12/2024 11:49:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2928', document_date = '2024-10-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 = '104.30', price_tax_excluded = '87.32', date_upd = NOW() WHERE id_document = '93473' 11/12/2024 11:49:19 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 = '93473' 11/12/2024 11:49:19 am >> DELETE FROM ps_document_detail WHERE id_document = '93473' 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '22.80' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 11/12/2024 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '20956' , 'BEATO CARLO ACUTIS - 64' , '50' , '-50' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '10.00' ) 11/12/2024 11:49:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2992' AND id_document != '93554' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-10') 11/12/2024 11:49:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2992', document_date = '2024-10-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 = '5.70', price_tax_excluded = '4.89', date_upd = NOW() WHERE id_document = '93554' 11/12/2024 11:49: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 = '93554' 11/12/2024 11:49:34 am >> DELETE FROM ps_document_detail WHERE id_document = '93554' 11/12/2024 11:49: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 ( '93554' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 11/12/2024 11:49:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93554' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 11/12/2024 11:49:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2995' AND id_document != '93557' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-10') 11/12/2024 11:49:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2995', document_date = '2024-10-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 = '4.20', price_tax_excluded = '3.66', date_upd = NOW() WHERE id_document = '93557' 11/12/2024 11:49:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93557' 11/12/2024 11:49:49 am >> DELETE FROM ps_document_detail WHERE id_document = '93557' 11/12/2024 11:49: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 ( '93557' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 11/12/2024 11:49: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 ( '93557' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 11/12/2024 11:49: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 ( '93557' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 11/12/2024 11:50:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3650' AND id_document != '94497' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 11/12/2024 11:50:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3650', document_date = '2024-11-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 = '149.70', price_tax_excluded = '124.45', date_upd = NOW() WHERE id_document = '94497' 11/12/2024 11:50:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94497' 11/12/2024 11:50:15 am >> DELETE FROM ps_document_detail WHERE id_document = '94497' 11/12/2024 11:50:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94497' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.15' , '1.15' , '0' , '0' , '1.15' ) 11/12/2024 11:50:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94497' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 11/12/2024 11:50:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94497' , '22749' , 'PAROLA E I GIORNI 2025' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 11/12/2024 11:50:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3701' AND id_document != '94560' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 11/12/2024 11:50:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3701', document_date = '2024-11-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 = '1.20', price_tax_excluded = '1.20', date_upd = NOW() WHERE id_document = '94560' 11/12/2024 11:50:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94560' 11/12/2024 11:50:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94560' 11/12/2024 11:50:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94560' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 11/12/2024 11:50:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3767' AND id_document != '94647' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-03') 11/12/2024 11:50:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3767', document_date = '2024-12-03', 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 = '1.90', price_tax_excluded = '1.77', date_upd = NOW() WHERE id_document = '94647' 11/12/2024 11:50: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 = '94647' 11/12/2024 11:50:56 am >> DELETE FROM ps_document_detail WHERE id_document = '94647' 11/12/2024 11:50: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 ( '94647' , '2653' , 'CONFEZIONE CARTONCINO CON BAMBINO - P391' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 11/12/2024 11:50: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 ( '94647' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 11/12/2024 11:51:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3814' AND id_document != '94708' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 11/12/2024 11:51:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3814', document_date = '2024-12-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 = '10.40', price_tax_excluded = '9.58', date_upd = NOW() WHERE id_document = '94708' 11/12/2024 11:51: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 = '94708' 11/12/2024 11:51:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94708' 11/12/2024 11:51: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 ( '94708' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.4000' , '2.7868852459016' , '22' , '0' , '3.40' ) 11/12/2024 11:51: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 ( '94708' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/12/2024 11:51: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 ( '94708' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 11/12/2024 11:51: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 ( '94708' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 11/12/2024 11:51:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3734' AND id_document != '94598' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 11/12/2024 11:51:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3734', document_date = '2024-11-30', 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 = '23.52', price_tax_excluded = '22.35', date_upd = NOW() WHERE id_document = '94598' 11/12/2024 11:51: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 = '94598' 11/12/2024 11:51:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94598' 11/12/2024 11:51: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 ( '94598' , '22482' , 'AVE MARIA - E. RONCHI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 11/12/2024 11:51: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 ( '94598' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 11/12/2024 11:51: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 ( '94598' , '23139' , 'SAI COSE IL NATALE - A. COMASTRI' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 11/12/2024 11:51: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 ( '94598' , '21796' , 'SET NATIVITA CON CAPANNA CM 15 - PB19889' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 11/12/2024 11:51: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 ( '94598' , '17257' , 'IO TI BATTEZZO ' , '2' , '-2' , '4' , '1.19' , '1.19' , '0' , '0' , '2.38' ) 11/12/2024 11:52:14 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/12/2024 11:52:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23298' , '1' , '' , 'nuovo-prodotto' ) 11/12/2024 11:52:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23298' , '1' , '1' , '2' , NOW() , NOW() ) 11/12/2024 11:52:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23298' , '0' , '1' , '0' , '0' ) 11/12/2024 11:52:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826609423' AND id_product != '23298' AND ean13 != '' 11/12/2024 11:52:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826609423', date_upd = NOW() WHERE id_product = '23298' 11/12/2024 11:52:49 am >> UPDATE ps_product_lang SET name = 'RIMETTI A NOI I NOSTRI DEBITI', description = '' WHERE id_product = '23298' 11/12/2024 11:52:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '23298' 11/12/2024 11:52:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23298' 11/12/2024 11:52:49 am >> DELETE FROM ps_specific_price WHERE id_product = '23298' 11/12/2024 11:52: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 = '23298' 11/12/2024 11:52:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23299' , '1' , '' , 'nuovo-prodotto' ) 11/12/2024 11:52: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 '23299' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23298' 11/12/2024 11:52:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23299' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23298' 11/12/2024 11:53:43 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' , '2024-DL003821' , '2024-12-06' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 11/12/2024 11:53: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 = '94804' 11/12/2024 11:53:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94804' 11/12/2024 11:53: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 ( '94804' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '20' , '20' , '4' , '2.00' , '2' , '0' , '45' , '22.0000' ) 11/12/2024 11:53:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '23298' AND id_supplier = '79' 11/12/2024 11:53:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23298' , '79' , '1' ) 11/12/2024 11:58:49 am >> SELECT document_num FROM ps_document WHERE document_num = '101/A' AND id_document != '93254' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-23') 11/12/2024 11:58:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '101/A', document_date = '2024-09-23', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', 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 = '600.00', price_tax_excluded = '491.80', date_upd = NOW() WHERE id_document = '93254' 11/12/2024 11:58:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93254' 11/12/2024 11:58:49 am >> DELETE FROM ps_document_detail WHERE id_document = '93254' 11/12/2024 11:58: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 ( '93254' , '12816' , 'LIBRO DEI DEFUNTI' , '6' , '-6' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '144.00' ) 11/12/2024 11:58: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 ( '93254' , '12814' , 'LIBRO DEI BATTEZZATI' , '6' , '-6' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '144.00' ) 11/12/2024 11:58: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 ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 11/12/2024 11:58:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '0' , '06/11/2024' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 11/12/2024 11:58:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 11/12/2024 11:58:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 11/12/2024 11:58:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '' , '11/12' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 11/12/2024 11:58:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '72.00' ) 11/12/2024 12:06:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '263' AND id_document != '94801' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:06:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '263', document_date = '2024-12-11', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679378', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '93.96', price_tax_excluded = '93.96', date_upd = NOW() WHERE id_document = '94801' 11/12/2024 12:06: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 = '94801' 11/12/2024 12:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '94801' 11/12/2024 12:06: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 ( '94801' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 11/12/2024 12:06: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 ( '94801' , '23108' , 'SUB TUUM PRAESIDIUM' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 11/12/2024 12:06: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 ( '94801' , '22984' , 'GIUBILEO DELLA SPERANZA - D. COSO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 11/12/2024 12:06: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 ( '94801' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 11/12/2024 12:06: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 ( '94801' , '21440' , 'MIO LIBRO DI PREGHIERE A MARIA - L. FANZAGA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 11/12/2024 12:06: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 ( '94801' , '23207' , 'GESU, ECO LUOMO - B. SESBOUE' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 11/12/2024 12:06: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 ( '94801' , '22676' , 'MI STAI A CUORE - M. SEBASTIANI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 11/12/2024 12:29:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3900' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:29:47 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' , '3900' , '2024-12-11' , '' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.35' , '24.06' , NOW() , NOW() ) 11/12/2024 12:29:47 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 = '94805' 11/12/2024 12:29:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '94805' 11/12/2024 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94805' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 11/12/2024 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94805' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '25.00' ) 11/12/2024 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94805' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 11/12/2024 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94805' , '16061' , 'MEDAGLIA S. RITA- FM022' , '3' , '-3' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.90' ) 11/12/2024 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94805' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 11/12/2024 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94805' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 11/12/2024 12:31:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:31:08 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' , '3901' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '368.05' , '337.32' , NOW() , NOW() ) 11/12/2024 12:31: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 = '94806' 11/12/2024 12:31:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '94806' 11/12/2024 12:31: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 ( '94806' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '2' , '-2' , '4' , '42.0000' , '42' , '0' , '5' , '79.80' ) 11/12/2024 12:31: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 ( '94806' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '36' , '-36' , '1' , '1.4000' , '1.1475' , '22' , '0' , '50.40' ) 11/12/2024 12:31: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 ( '94806' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '400' , '-400' , '1' , '0.3000' , '0.2459' , '22' , '0' , '120.00' ) 11/12/2024 12:31: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 ( '94806' , '23252' , 'BREVE INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 11/12/2024 12:31: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 ( '94806' , '23282' , 'CASTITA - E. VARDEN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 11/12/2024 12:31: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 ( '94806' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 11/12/2024 12:31: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 ( '94806' , '18183' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - G. DE VIRGILIO' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 11/12/2024 12:31: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 ( '94806' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 11/12/2024 12:32:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:32:49 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' , '3902' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 11/12/2024 12:32:49 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 = '94807' 11/12/2024 12:32:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94807' 11/12/2024 12:32:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94807' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 11/12/2024 12:32:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94807' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 11/12/2024 12:34:59 pm >> DELETE FROM ps_document WHERE id_document = '94685' 11/12/2024 12:34:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94685' 11/12/2024 12:49:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '263' AND id_document != '94801' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:49:59 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '263', document_date = '2024-12-11', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679378', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '116.16', price_tax_excluded = '116.16', date_upd = NOW() WHERE id_document = '94801' 11/12/2024 12:49:59 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 = '94801' 11/12/2024 12:49:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94801' 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '23108' , 'SUB TUUM PRAESIDIUM' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '22984' , 'GIUBILEO DELLA SPERANZA - D. COSO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '21440' , 'MIO LIBRO DI PREGHIERE A MARIA - L. FANZAGA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '23207' , 'GESU, ECO LUOMO - B. SESBOUE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '22676' , 'MI STAI A CUORE - M. SEBASTIANI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '4' , '3.60' , '3.6' , '0' , '0' , '7.20' ) 11/12/2024 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94801' , '4374' , 'GESÙ BAMBINO - 273' , '100' , '-100' , '0' , '0.15' , '0.15' , '' , '0' , '15.00' ) 11/12/2024 12:52:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3903' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:52: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' , '3903' , '2024-12-11' , '' , '0' , '0' , '0' , 'VIA S. MARGHERITA 1 84129 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '676.40' , '555.04' , NOW() , NOW() ) 11/12/2024 12:52: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 = '94808' 11/12/2024 12:52:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '94808' 11/12/2024 12:52: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 ( '94808' , '17617' , 'IMMAGINI ISONZO X 100' , '17' , '-17' , '1' , '3.3000' , '2.7049' , '22' , '0' , '56.10' ) 11/12/2024 12:52: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 ( '94808' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 11/12/2024 12:52: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 ( '94808' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346' , '4' , '0' , '4.30' ) 11/12/2024 12:52: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 ( '94808' , '7202' , 'ARTICOLI RELIGIOSI medaglie' , '1' , '-1' , '1' , '6.0000' , '4.918' , '22' , '0' , '6.00' ) 11/12/2024 12:52: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 ( '94808' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.1000' , '0.9016' , '22' , '0' , '11.00' ) 11/12/2024 12:52: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 ( '94808' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.7049' , '22' , '0' , '46.00' ) 11/12/2024 12:52: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 ( '94808' , '8054' , 'PISSIDE DUE SPECIE - 873' , '1' , '-1' , '1' , '220.0000' , '180.3279' , '22' , '0' , '220.00' ) 11/12/2024 12:52: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 ( '94808' , '22215' , 'CALICE MALTA - 341' , '1' , '-1' , '1' , '280.0000' , '229.5082' , '22' , '0' , '280.00' ) 11/12/2024 12:52: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 ( '94808' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40.0000' , '32.7869' , '22' , '0' , '40.00' ) 11/12/2024 12:53:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3900' AND id_document != '94805' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 12:53:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3900', document_date = '2024-12-11', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '29.35', price_tax_excluded = '24.06', date_upd = NOW() WHERE id_document = '94805' 11/12/2024 12:53: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 = '94805' 11/12/2024 12:53:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94805' 11/12/2024 12:53: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 ( '94805' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 11/12/2024 12:53: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 ( '94805' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '25.00' ) 11/12/2024 12:53: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 ( '94805' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 11/12/2024 12:53: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 ( '94805' , '16061' , 'MEDAGLIA S. RITA- FM022' , '3' , '-3' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.90' ) 11/12/2024 12:53: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 ( '94805' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.50' ) 11/12/2024 12:53: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 ( '94805' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '1' , '-1' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.25' ) 11/12/2024 02:35:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3531' AND id_document != '94336' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 11/12/2024 02:35:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3531', document_date = '2024-11-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 = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '94336' 11/12/2024 02:35: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 = '94336' 11/12/2024 02:35:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94336' 11/12/2024 02:35: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 ( '94336' , '21085' , 'BRACCIALE ARG. BIMBA - 1537BIMB' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 11/12/2024 03:47:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '14770' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 11/12/2024 03:47:21 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '43', document_date = '2024-11-19', document_letter = '', id_customer = '7113', id_supplier = '', id_address = '177359060', address1 = 'VIA PAOLO VI 55 84018 SCAFATI', address2 = '', note = '', price_shipping = '0', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '138.45', price_tax_excluded = '138.45', date_upd = NOW() WHERE id_document = '14770' 11/12/2024 03:47:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14770' 11/12/2024 03:47:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '14770' 11/12/2024 03:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14770' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '65' , '-65' , '4' , '2.1300' , '2.13' , '0' , '0' , '138.45' ) 11/12/2024 05:28:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3904' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 05:28:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3904' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.40' , '57.11' , NOW() , NOW() ) 11/12/2024 05:28:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94809' 11/12/2024 05:28:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94809' 11/12/2024 05:28:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94809' , '22102' , 'INIZIAZIONE ALLA PREGHIERA - R. PASOLINI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 11/12/2024 05:28:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94809' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/12/2024 05:28:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94809' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.90' , '16.311475409836' , '22' , '0' , '19.90' ) 11/12/2024 05:28:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94809' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 11/12/2024 07:39:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 11/12/2024 07:39:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3905' , '2024-12-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 11/12/2024 07:39:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94810' 11/12/2024 07:39:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '94810' 11/12/2024 07:39:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94810' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' )