09/12/2024 09:04:16 am >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 09/12/2024 09:04:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2024-11-14', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'acconto 05/12 € 260,00', 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 = '806.72', price_tax_excluded = '779.67', date_upd = NOW() WHERE id_document = '94256' 09/12/2024 09:04: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 = '94256' 09/12/2024 09:04:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94256' 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 09/12/2024 09:04:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '54.00' ) 09/12/2024 09:37:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 09:37:29 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' , '3860' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.22' , NOW() , NOW() ) 09/12/2024 09:37:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94758' 09/12/2024 09:37:29 am >> DELETE FROM ps_document_detail WHERE id_document = '94758' 09/12/2024 09:37:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94758' , '16713' , 'SACRA FAMIGLIA - 179' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 09/12/2024 09:37:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94758' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 09/12/2024 09:37:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94758' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 09/12/2024 09:39:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 09:39:48 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' , '3861' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 09/12/2024 09:39: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 = '94759' 09/12/2024 09:39:48 am >> DELETE FROM ps_document_detail WHERE id_document = '94759' 09/12/2024 09:39: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 ( '94759' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 09/12/2024 09:39: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 ( '94759' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 09/12/2024 09:39: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 ( '94759' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 09/12/2024 09:41:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 09:41:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3862' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 09/12/2024 09:41:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94760' 09/12/2024 09:41:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94760' 09/12/2024 09:41:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94760' , '23102' , 'BRACCIALE DECINA GIUBILEO - 4618D' , '50' , '-50' , '1' , '2' , '1.6393442622951' , '22' , '0' , '100.00' ) 09/12/2024 09:41:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94760' , '21796' , 'SET NATIVITA CON CAPANNA CM 15 - PB19889' , '5' , '-5' , '1' , '5' , '4.0983606557377' , '22' , '0' , '25.00' ) 09/12/2024 09:47:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 09:47:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3863' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 09/12/2024 09:47: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 = '94761' 09/12/2024 09:47:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94761' 09/12/2024 09:47: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 ( '94761' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '60' , '-60' , '1' , '2' , '1.6393442622951' , '22' , '0' , '120.00' ) 09/12/2024 09:54:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 09:54: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' , '3864' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '268.60' , '268.60' , NOW() , NOW() ) 09/12/2024 09:54: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 = '94762' 09/12/2024 09:54:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94762' 09/12/2024 09:54: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 ( '94762' , '5444' , 'IO SONO CON VOI - CAT.' , '11' , '-11' , '4' , '5.50' , '5.5' , '0' , '5' , '57.53' ) 09/12/2024 09:54: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 ( '94762' , '11193' , 'VENITE CON ME CAT.' , '6' , '-6' , '4' , '5.50' , '5.5' , '0' , '5' , '31.38' ) 09/12/2024 09:54: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 ( '94762' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.15' ) 09/12/2024 09:54: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 ( '94762' , '7259' , 'ORA DI CATECHISMO 2 GUIDA - L. FERRARESSO' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 09/12/2024 09:54: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 ( '94762' , '5529' , 'ORA DI CATECHISMO 2 - QUADERNO' , '6' , '-6' , '4' , '4.50' , '4.5' , '0' , '5' , '25.68' ) 09/12/2024 09:54: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 ( '94762' , '7257' , 'ORA DI CATECHISMO 1 GUIDA - L. FERRARESSO' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 09/12/2024 09:54: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 ( '94762' , '7258' , 'ORA DI CATECHISMO 1 QUADERNO - L. FERRARESSO' , '15' , '-15' , '4' , '4.50' , '4.5' , '0' , '5' , '64.20' ) 09/12/2024 09:54: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 ( '94762' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 09/12/2024 09:54: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 ( '94762' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 09/12/2024 09:54: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 ( '94762' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 09/12/2024 09:54: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 ( '94762' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 09/12/2024 10:02:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 10:02:52 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' , '3865' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/12/2024 10:02:52 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 = '94763' 09/12/2024 10:02:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94763' 09/12/2024 10:02:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94763' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/12/2024 10:16:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 10:16:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3866' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '420.00' , '350.86' , NOW() , NOW() ) 09/12/2024 10:16: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 = '94764' 09/12/2024 10:16:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94764' 09/12/2024 10:16: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 ( '94764' , '4195' , 'FINTA CANDELA 8X30 - 180' , '2' , '-2' , '1' , '23.5' , '19.262295081967' , '22' , '0' , '47.00' ) 09/12/2024 10:16: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 ( '94764' , '20899' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 8X20 - 1188' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 09/12/2024 10:16: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 ( '94764' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '8' , '-8' , '1' , '13' , '10.655737704918' , '22' , '0' , '104.00' ) 09/12/2024 10:16: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 ( '94764' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 09/12/2024 10:16: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 ( '94764' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/12/2024 10:16: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 ( '94764' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/12/2024 10:16: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 ( '94764' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/12/2024 10:16: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 ( '94764' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/12/2024 10:16: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 ( '94764' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 09/12/2024 10:16: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 ( '94764' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 09/12/2024 10:16: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 ( '94764' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' ) 09/12/2024 10:19:30 am >> SELECT document_num FROM ps_document WHERE document_num = '132/A' AND id_document != '94731' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-06') 09/12/2024 10:19:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '132/A', document_date = '2024-12-06', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '273.00', price_tax_excluded = '240.90', date_upd = NOW() WHERE id_document = '94731' 09/12/2024 10:19:31 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 = '94731' 09/12/2024 10:19:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94731' 09/12/2024 10:19:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94731' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '0' , '50.00' ) 09/12/2024 10:19:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94731' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '105.00' ) 09/12/2024 10:19:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94731' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 09/12/2024 10:19:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94731' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 09/12/2024 10:19:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94731' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 09/12/2024 10:19:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94731' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '0' , '45.00' ) 09/12/2024 10:28:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616133' AND id_product != '6414' AND ean13 != '' 09/12/2024 10:28:47 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616133', date_upd = NOW() WHERE id_product = '6414' 09/12/2024 10:28:47 am >> UPDATE ps_product_lang SET name = 'MERAVIGLIOSO SEGRETO DELLE ANIME DEL PURGATORIO - 8110', description = '' WHERE id_product = '6414' 09/12/2024 10:28:47 am >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '9' WHERE id_product = '6414' 09/12/2024 10:28:47 am >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6414' 09/12/2024 10:28:47 am >> DELETE FROM ps_specific_price WHERE id_product = '6414' 09/12/2024 10:30:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/12/2024 10:30:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23293' , '1' , '' , 'nuovo-prodotto' ) 09/12/2024 10:30:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23293' , '1' , '1' , '2' , NOW() , NOW() ) 09/12/2024 10:30:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23293' , '0' , '1' , '0' , '0' ) 09/12/2024 10:30:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391523' AND id_product != '23293' AND ean13 != '' 09/12/2024 10:30:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256391523', date_upd = NOW() WHERE id_product = '23293' 09/12/2024 10:30:45 am >> UPDATE ps_product_lang SET name = 'DOLINDO RUOTOLO - SANTI DEL MESSALINO - 8974', description = '' WHERE id_product = '23293' 09/12/2024 10:30:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23293' 09/12/2024 10:30:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23293' 09/12/2024 10:30:45 am >> DELETE FROM ps_specific_price WHERE id_product = '23293' 09/12/2024 10:30:45 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 = '23293' 09/12/2024 10:30:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23294' , '1' , '' , 'nuovo-prodotto' ) 09/12/2024 10:30:46 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 '23294' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23293' 09/12/2024 10:30:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23294' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23293' 09/12/2024 10:31:19 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' , '18601/00/2024' , '2024-12-05' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '126.61' , '124.01' , NOW() , NOW() ) 09/12/2024 10:31: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 = '94765' 09/12/2024 10:31:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94765' 09/12/2024 10:31: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 ( '94765' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '23104' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23104' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '1' , '4' , '19.00' , '19' , '0' , '40' , '11.4000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '18009' , 'SCALA PIU CORTA PER SALIRE IN CIELO - 8011' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18009' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18009' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '19587' , 'GESU BAMBINO DI PRAGA - 8079' , '1' , '1' , '4' , '3.00' , '3' , '0' , '40' , '1.8000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19587' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19587' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '6414' , 'MERAVIGLIOSO SEGRETO DELLE ANIME DEL PURGATORIO - 8110' , '2' , '2' , '4' , '9.00' , '9' , '0' , '40' , '10.8000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '6414' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6414' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '1' , '1' , '4' , '4.00' , '4' , '0' , '40' , '2.4000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '9105' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9105' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '3' , '3' , '4' , '2.00' , '2' , '0' , '40' , '3.6000' ) 09/12/2024 10:31:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '38' 09/12/2024 10:31:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '3388' , 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 09/12/2024 10:31:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '3388' AND id_supplier = '38' 09/12/2024 10:31:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3388' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 09/12/2024 10:31:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '38' 09/12/2024 10:31:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 09/12/2024 10:31:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '38' 09/12/2024 10:31:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '6323' , 'MEDAGLIA MIRACOLOSA E CATERINA LABOURÈ - 8814' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 09/12/2024 10:31:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '6323' AND id_supplier = '38' 09/12/2024 10:31:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6323' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '23293' , 'DOLINDO RUOTOLO - SANTI DEL MESSALINO - 8974' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 09/12/2024 10:31:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '23293' AND id_supplier = '38' 09/12/2024 10:31:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23293' , '38' , '1' ) 09/12/2024 10:31: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 ( '94765' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '2' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '14.4058' ) 09/12/2024 10:31:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '22911' AND id_supplier = '38' 09/12/2024 10:31:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22911' , '38' , '1' ) 09/12/2024 10:39:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3752' AND id_document != '94621' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 09/12/2024 10:39:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3752', 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 = '160.00', price_tax_excluded = '131.15', date_upd = NOW() WHERE id_document = '94621' 09/12/2024 10:39: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 = '94621' 09/12/2024 10:39:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94621' 09/12/2024 10:39: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 ( '94621' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 09/12/2024 10:39:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3866' AND id_document != '94764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 10:39:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3866', document_date = '2024-12-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '420.00', price_tax_excluded = '350.86', date_upd = NOW() WHERE id_document = '94764' 09/12/2024 10:39: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 = '94764' 09/12/2024 10:39:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94764' 09/12/2024 10:39: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 ( '94764' , '4195' , 'FINTA CANDELA 8X30 - 180' , '2' , '-2' , '1' , '23.5000' , '19.262295081967' , '22' , '0' , '47.00' ) 09/12/2024 10:39: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 ( '94764' , '20899' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 8X20 - 1188' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 09/12/2024 10:39: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 ( '94764' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '8' , '-8' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '104.00' ) 09/12/2024 10:39: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 ( '94764' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '2' , '-2' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 09/12/2024 10:39: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 ( '94764' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/12/2024 10:39: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 ( '94764' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/12/2024 10:39: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 ( '94764' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/12/2024 10:39: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 ( '94764' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/12/2024 10:39: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 ( '94764' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '5' , '19.00' ) 09/12/2024 10:39: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 ( '94764' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 09/12/2024 10:39: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 ( '94764' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 09/12/2024 10:45:47 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' , '1120/2024' , '2024-12-05' , '2024' , '0' , '23' , '2618' , 'V.LE ISONZO, 52 20135 MILANO' , '' , '' , '18.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '448.62' , '367.72' , NOW() , NOW() ) 09/12/2024 10:45: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 = '94766' 09/12/2024 10:45:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94766' 09/12/2024 10:45: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 ( '94766' , '17617' , 'IMMAGINI ISONZO X 100' , '174' , '174' , '1' , '2.3' , '1.8852459016393' , '22' , '30+10' , '307.5937' ) 09/12/2024 10:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '23' 09/12/2024 10:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '23' , '1' ) 09/12/2024 10:45: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 ( '94766' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '10' , '10' , '1' , '5.5' , '4.5081967213115' , '22' , '30+10' , '42.2730' ) 09/12/2024 10:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5095' AND id_supplier = '23' 09/12/2024 10:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5095' , '23' , '1' ) 09/12/2024 10:45: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 ( '94766' , '20758' , 'SEGNALIBRO 5X15' , '300' , '300' , '1' , '0.09' , '0.073770491803279' , '22' , '30+10' , '20.7522' ) 09/12/2024 10:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20758' AND id_supplier = '23' 09/12/2024 10:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20758' , '23' , '1' ) 09/12/2024 10:45: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 ( '94766' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '60' , '60' , '1' , '0.34' , '0.27868852459016' , '22' , '30+10' , '15.6794' ) 09/12/2024 10:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5105' AND id_supplier = '23' 09/12/2024 10:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5105' , '23' , '1' ) 09/12/2024 10:45: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 ( '94766' , '20956' , 'BEATO CARLO ACUTIS - 64' , '300' , '300' , '1' , '0.11' , '0.09016393442623' , '22' , '30+10' , '25.3638' ) 09/12/2024 10:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20956' AND id_supplier = '23' 09/12/2024 10:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20956' , '23' , '1' ) 09/12/2024 10:45: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 ( '94766' , '4374' , 'GESÙ BAMBINO - 273' , '300' , '300' , '1' , '0.065' , '0.05327868852459' , '22' , '30+10' , '14.9877' ) 09/12/2024 10:45:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '4374' AND id_supplier = '23' 09/12/2024 10:45:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4374' , '23' , '1' ) 09/12/2024 10:46:41 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1120/2024', document_date = '2024-12-05', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '2618', address1 = 'V.LE ISONZO, 52 20135 MILANO', address2 = '', note = 'RESTA DA PAGARE € 13,07', price_shipping = '18.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '448.61', price_tax_excluded = '367.71', date_upd = NOW() WHERE id_document = '94766' 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94766' 09/12/2024 10:46:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94766' 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94766' , '17617' , 'IMMAGINI ISONZO X 100' , '174' , '174' , '1' , '2.3000' , '1.8852459016393' , '22' , '30+10' , '307.59' ) 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94766' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '10' , '10' , '1' , '5.5000' , '4.5081967213115' , '22' , '30+10' , '42.27' ) 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94766' , '20758' , 'SEGNALIBRO 5X15' , '300' , '300' , '1' , '0.0900' , '0.073770491803279' , '22' , '30+10' , '20.75' ) 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94766' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '60' , '60' , '1' , '0.3400' , '0.27868852459016' , '22' , '30+10' , '15.68' ) 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94766' , '20956' , 'BEATO CARLO ACUTIS - 64' , '300' , '300' , '1' , '0.1100' , '0.09016393442623' , '22' , '30+10' , '25.36' ) 09/12/2024 10:46:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94766' , '4374' , 'GESÙ BAMBINO - 273' , '300' , '300' , '1' , '0.0650' , '0.05327868852459' , '22' , '30+10' , '14.99' ) 09/12/2024 11:07:35 am >> SELECT document_num FROM ps_document WHERE document_num = '125/A' AND id_document != '94315' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-18') 09/12/2024 11:07:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '125/A', document_date = '2024-11-18', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '409.80', price_tax_excluded = '341.42', date_upd = NOW() WHERE id_document = '94315' 09/12/2024 11:07:35 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 = '94315' 09/12/2024 11:07:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94315' 09/12/2024 11:07: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 ( '94315' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/12/2024 11:07: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 ( '94315' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 09/12/2024 11:07: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 ( '94315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 09/12/2024 11:07: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 ( '94315' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 09/12/2024 11:07: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 ( '94315' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' ) 09/12/2024 11:07: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 ( '94315' , '0' , '23/11 DON MICHELE RITIRA' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 09/12/2024 11:07: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 ( '94315' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 09/12/2024 11:07: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 ( '94315' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '30' , '-30' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '96.00' ) 09/12/2024 11:07: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 ( '94315' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 09/12/2024 11:07: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 ( '94315' , '21137' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '60.00' ) 09/12/2024 11:07: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 ( '94315' , '0' , '29/11' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 09/12/2024 11:07: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 ( '94315' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '30' , '-30' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '96.00' ) 09/12/2024 11:07: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 ( '94315' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 09/12/2024 11:07: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 ( '94315' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 09/12/2024 11:07: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 ( '94315' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 09/12/2024 11:07: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 ( '94315' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 09/12/2024 11:07: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 ( '94315' , '' , '09/12' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 09/12/2024 11:07: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 ( '94315' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/12/2024 11:07: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 ( '94315' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 09/12/2024 11:08:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 11:08:26 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' , '3867' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 09/12/2024 11:08:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94767' 09/12/2024 11:08:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94767' 09/12/2024 11:08:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94767' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 09/12/2024 11:09:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3868' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 11:09:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3868' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.90' , '172.72' , NOW() , NOW() ) 09/12/2024 11:09:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94768' 09/12/2024 11:09:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94768' 09/12/2024 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94768' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 09/12/2024 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94768' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/12/2024 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94768' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/12/2024 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94768' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 09/12/2024 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94768' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/12/2024 11:17:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3869' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 11:17: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' , '3869' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.40' , '3.61' , NOW() , NOW() ) 09/12/2024 11:17: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 = '94769' 09/12/2024 11:17:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94769' 09/12/2024 11:17: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 ( '94769' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 09/12/2024 11:17: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 ( '94769' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 09/12/2024 11:25:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788834619742' AND id_product != '23294' AND ean13 != '' 09/12/2024 11:25:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788834619742', date_upd = NOW() WHERE id_product = '23294' 09/12/2024 11:25:33 am >> UPDATE ps_product_lang SET name = 'FOLLEMENTE CORRETTO ', description = '' WHERE id_product = '23294' 09/12/2024 11:25:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '23294' 09/12/2024 11:25:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '536', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23294' 09/12/2024 11:25:33 am >> DELETE FROM ps_specific_price WHERE id_product = '23294' 09/12/2024 11:26:20 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 = '23294' 09/12/2024 11:26:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23295' , '1' , '' , 'nuovo-prodotto' ) 09/12/2024 11:26:20 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 '23295' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23294' 09/12/2024 11:26:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23295' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23294' 09/12/2024 11:27:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839409973' AND id_product != '23295' AND ean13 != '' 09/12/2024 11:27:46 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788839409973', date_upd = NOW() WHERE id_product = '23295' 09/12/2024 11:27:47 am >> UPDATE ps_product_lang SET name = 'DISCORSO DELLA MONTAGNA - P. LAPIDE', description = '' WHERE id_product = '23295' 09/12/2024 11:27:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '23295' 09/12/2024 11:27:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23295' 09/12/2024 11:27:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23295' 09/12/2024 11:28:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '349834' , '2024-12-05' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.80' , '173.80' , NOW() , NOW() ) 09/12/2024 11:28: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 = '94770' 09/12/2024 11:28:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94770' 09/12/2024 11:28: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 ( '94770' , '23294' , 'FOLLEMENTE CORRETTO ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 09/12/2024 11:28:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '23294' AND id_supplier = '109' 09/12/2024 11:28:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23294' , '109' , '1' ) 09/12/2024 11:28: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 ( '94770' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '2' , '2' , '4' , '24.90' , '24.9' , '0' , '0' , '49.8000' ) 09/12/2024 11:28:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '22334' AND id_supplier = '109' 09/12/2024 11:28:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22334' , '109' , '1' ) 09/12/2024 11:28: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 ( '94770' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '4' , '4' , '4' , '20.00' , '20' , '0' , '0' , '80.0000' ) 09/12/2024 11:28:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109' 09/12/2024 11:28:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' ) 09/12/2024 11:28: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 ( '94770' , '23237' , 'MARIA ALLALBA DELLOTTAVO GIORNO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 09/12/2024 11:28:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '23237' AND id_supplier = '109' 09/12/2024 11:28:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23237' , '109' , '1' ) 09/12/2024 11:28: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 ( '94770' , '23295' , 'DISCORSO DELLA MONTAGNA - P. LAPIDE' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 09/12/2024 11:28:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '23295' AND id_supplier = '109' 09/12/2024 11:28:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23295' , '109' , '1' ) 09/12/2024 11:42:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3870' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 11:42:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3870' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.40' , '4.40' , NOW() , NOW() ) 09/12/2024 11:42:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94771' 09/12/2024 11:42:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94771' 09/12/2024 11:42: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 ( '94771' , '22698' , 'CALENDARIO LITURGICO 2025' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 09/12/2024 11:42: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 ( '94771' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 09/12/2024 11:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3866' AND id_document != '94764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 11:46:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3866', document_date = '2024-12-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '420.00', price_tax_excluded = '350.86', date_upd = NOW() WHERE id_document = '94764' 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94764' 09/12/2024 11:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94764' 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '4195' , 'FINTA CANDELA 8X30 - 180' , '2' , '-2' , '1' , '23.5000' , '19.262295081967' , '22' , '0' , '47.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '20899' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 8X20 - 1188' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '8' , '-8' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '104.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '5' , '19.00' ) 09/12/2024 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94764' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 09/12/2024 11:46: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 ( '94764' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '-1' , '1' , '68' , '55.737704918033' , '22' , '0' , '68.00' ) 09/12/2024 12:23:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3871' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 12:23: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' , '3871' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '79.22' , NOW() , NOW() ) 09/12/2024 12:23: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 = '94772' 09/12/2024 12:23:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '94772' 09/12/2024 12:23: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 ( '94772' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 09/12/2024 12:23: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 ( '94772' , '1765' , 'CASULA - POLIESTERE - OGGETTI' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 09/12/2024 12:23: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 ( '94772' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '0' , '7.50' ) 09/12/2024 12:24:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3872' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 12:24: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' , '3872' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 09/12/2024 12:24: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 = '94773' 09/12/2024 12:24:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94773' 09/12/2024 12:24: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 ( '94773' , '16308' , 'PORTACHIAVI SAN BENEDETTO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 09/12/2024 12:30:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3873' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 12:30:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3873' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 09/12/2024 12:30:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94774' 09/12/2024 12:30:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94774' 09/12/2024 12:30:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94774' , '22850' , 'UPPO 2025 - CALENDARIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 09/12/2024 03:44:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 03:44: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' , '3874' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.20' , '37.78' , NOW() , NOW() ) 09/12/2024 03:44: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 = '94775' 09/12/2024 03:44:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94775' 09/12/2024 03:44: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 ( '94775' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 09/12/2024 03:44: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 ( '94775' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 09/12/2024 03:44: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 ( '94775' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 09/12/2024 03:47:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3875' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 03:47:22 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' , '3875' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.50' , '53.71' , NOW() , NOW() ) 09/12/2024 03:47:22 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 = '94776' 09/12/2024 03:47:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94776' 09/12/2024 03:47:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94776' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 09/12/2024 03:47:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94776' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 09/12/2024 04:02:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3876' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 04:02:02 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' , '3876' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 09/12/2024 04:02:02 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 = '94777' 09/12/2024 04:02:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94777' 09/12/2024 04:02:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94777' , '3179' , 'CROCIFISSO - CM 40 - 1003' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 09/12/2024 04:17:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3877' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 04:17: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 ( '11' , '3877' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 09/12/2024 04:17: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 = '94778' 09/12/2024 04:17:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94778' 09/12/2024 04:17: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 ( '94778' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '5' , '-5' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '2.00' ) 09/12/2024 04:17: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 ( '94778' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '5' , '-5' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.50' ) 09/12/2024 05:37:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3878' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 05:37: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' , '3878' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '12.21' , NOW() , NOW() ) 09/12/2024 05:37: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 = '94779' 09/12/2024 05:37:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '94779' 09/12/2024 05:37: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 ( '94779' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14.9' , '12.213114754098' , '22' , '0' , '14.90' ) 09/12/2024 06:18:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3879' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 06:18: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' , '3879' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.90' , NOW() , NOW() ) 09/12/2024 06:18: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 = '94780' 09/12/2024 06:18:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94780' 09/12/2024 06:18: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 ( '94780' , '22915' , 'CINQUE PANI DORZO 2025' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 09/12/2024 07:07:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 07:07:13 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' , '3880' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '32.00' , NOW() , NOW() ) 09/12/2024 07:07: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 = '94781' 09/12/2024 07:07:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94781' 09/12/2024 07:07: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 ( '94781' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '0' , '32.00' ) 09/12/2024 07:26:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 09/12/2024 07:26:24 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' , '3881' , '2024-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 09/12/2024 07:26:24 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 = '94782' 09/12/2024 07:26:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '94782' 09/12/2024 07:26:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94782' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '75' , '-75' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '30.00' )