30/12/2024 09:03:34 am >> SELECT document_num FROM ps_document WHERE document_num = '4128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 09:03: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' , '4128' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 30/12/2024 09:03: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 = '95082' 30/12/2024 09:03:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95082' 30/12/2024 09:03: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 ( '95082' , '20128' , 'CORONA PER STATUA FATIMA 27 CM - C/1025' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/12/2024 09:08: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 ( '31' , '20063/00/2024' , '2024-12-23' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '204.01' , '199.46' , NOW() , NOW() ) 30/12/2024 09:08: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 = '95083' 30/12/2024 09:08:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95083' 30/12/2024 09:08: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 ( '95083' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '55' , '55' , '4' , '5.00' , '5' , '0' , '40' , '165.0000' ) 30/12/2024 09:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '23104' AND id_supplier = '38' 30/12/2024 09:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23104' , '38' , '1' ) 30/12/2024 09:08: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 ( '95083' , '8334' , 'PREGHIERE A SAN GIUSEPPE - 8115' , '1' , '1' , '4' , '8.00' , '8' , '0' , '40' , '4.8000' ) 30/12/2024 09:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '8334' AND id_supplier = '38' 30/12/2024 09:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8334' , '38' , '1' ) 30/12/2024 09:08: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 ( '95083' , '6720' , 'MIRACOLI EUCARISTICI - 8735' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 30/12/2024 09:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '6720' AND id_supplier = '38' 30/12/2024 09:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6720' , '38' , '1' ) 30/12/2024 09:08: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 ( '95083' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '1' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '7.2029' ) 30/12/2024 09:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '22911' AND id_supplier = '38' 30/12/2024 09:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22911' , '38' , '1' ) 30/12/2024 09:08: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 ( '95083' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '3' , '3' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '18.0072' ) 30/12/2024 09:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '22910' AND id_supplier = '38' 30/12/2024 09:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22910' , '38' , '1' ) 30/12/2024 09:13:58 am >> SELECT document_num FROM ps_document WHERE document_num = '4129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 09:13:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4129' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 30/12/2024 09:13:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95084' 30/12/2024 09:13:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95084' 30/12/2024 09:13:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95084' , '20181' , 'TESTA ANGELI IN RESINA CM 6 - AR04' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 30/12/2024 09:16:44 am >> SELECT document_num FROM ps_document WHERE document_num = '141/A' AND id_document != '95077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-28') 30/12/2024 09:16:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '141/A', document_date = '2024-12-28', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '74.59', date_upd = NOW() WHERE id_document = '95077' 30/12/2024 09:16: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 = '95077' 30/12/2024 09:16:44 am >> DELETE FROM ps_document_detail WHERE id_document = '95077' 30/12/2024 09:16: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 ( '95077' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 30/12/2024 09:16: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 ( '95077' , '0' , 'SACRA FAMIGLIA' , '3' , '-3' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '15.00' ) 30/12/2024 09:16: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 ( '95077' , '' , 'buono' , '1' , '-1' , '0' , '50' , '50' , '' , '0' , '50.00' ) 30/12/2024 09:30:11 am >> SELECT document_num FROM ps_document WHERE document_num = '4130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 09:30:11 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' , '4130' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 30/12/2024 09:30:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95085' 30/12/2024 09:30:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95085' 30/12/2024 09:30:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95085' , '10885' , 'UN PENSIERO AL GIORNO CON MONTFORT - 8714' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/12/2024 09:33:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 09:33:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4131' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/12/2024 09:33:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95086' 30/12/2024 09:33:10 am >> DELETE FROM ps_document_detail WHERE id_document = '95086' 30/12/2024 09:33:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95086' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/12/2024 09:54:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4121' AND id_document != '95074' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-28') 30/12/2024 09:54:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4121', document_date = '2024-12-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.80', price_tax_excluded = '20.54', date_upd = NOW() WHERE id_document = '95074' 30/12/2024 09:54:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95074' 30/12/2024 09:54:38 am >> DELETE FROM ps_document_detail WHERE id_document = '95074' 30/12/2024 09:54:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95074' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 30/12/2024 09:54:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95074' , '23301' , 'sacramenti - benedetto xvi' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 30/12/2024 09:54:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95074' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 30/12/2024 09:54:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228658' AND id_product != '23301' AND ean13 != '' 30/12/2024 09:54:54 am >> UPDATE ps_product SET id_supplier = '7', reference = 'gondola 1', ean13 = '9788892228658', date_upd = NOW() WHERE id_product = '23301' 30/12/2024 09:54:54 am >> UPDATE ps_product_lang SET name = 'SACRAMENTI - BENEDETTO XVI', description = '' WHERE id_product = '23301' 30/12/2024 09:54:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.0000' WHERE id_product = '23301' 30/12/2024 09:54:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23301' 30/12/2024 09:54:54 am >> DELETE FROM ps_specific_price WHERE id_product = '23301' 30/12/2024 09:56:56 am >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '95065' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 30/12/2024 09:56:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4112', document_date = '2024-12-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '95065' 30/12/2024 09:56:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95065' 30/12/2024 09:56:56 am >> DELETE FROM ps_document_detail WHERE id_document = '95065' 30/12/2024 10:10:01 am >> SELECT document_num FROM ps_document WHERE document_num = '4132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:10:01 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' , '4132' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.51' , '28.51' , NOW() , NOW() ) 30/12/2024 10:10:01 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 = '95087' 30/12/2024 10:10:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95087' 30/12/2024 10:10:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95087' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 30/12/2024 10:10:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95087' , '23129' , 'PELLEGRINO DI SPERANZA' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 30/12/2024 10:10:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95087' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 30/12/2024 10:20:31 am >> SELECT document_num FROM ps_document WHERE document_num = '4133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:20:31 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' , '4133' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 30/12/2024 10:20: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 = '95088' 30/12/2024 10:20:31 am >> DELETE FROM ps_document_detail WHERE id_document = '95088' 30/12/2024 10:20: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 ( '95088' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '5' , '49.40' ) 30/12/2024 10:20: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 ( '95088' , '23331' , 'MESSA MEDITAZIONE - FEB/MAR 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/12/2024 10:23:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:23:55 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' , '4134' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 30/12/2024 10:23:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95089' 30/12/2024 10:23:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95089' 30/12/2024 10:23:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95089' , '22850' , 'UPPO 2025 - CALENDARIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/12/2024 10:23:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95089' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/12/2024 10:43:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:43:13 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' , '4135' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/12/2024 10:43:13 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 = '95090' 30/12/2024 10:43:13 am >> DELETE FROM ps_document_detail WHERE id_document = '95090' 30/12/2024 10:43:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95090' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/12/2024 10:46:27 am >> SELECT document_num FROM ps_document WHERE document_num = '28/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:46:27 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 ( '22' , '28/S' , '2024-12-30' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO DICEMBRE 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '264.00' , '264.00' , NOW() , NOW() ) 30/12/2024 10:46:27 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 = '14780' 30/12/2024 10:46:27 am >> DELETE FROM ps_document_detail WHERE id_document = '14780' 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '20' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '15.00' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '18.75' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '1' , '0' , '4' , '2.60' , '2.6' , '0' , '50' , '1.30' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '50' , 'PERDONAMI SIGNORE' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '61' , 'GIOVANNI PAOLO II° SANTO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '70' , 'La storia della salvezza raccontata ai bambini. 2 Caino e Abele' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '88' , 'GESÙ È RISORTO' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 30/12/2024 10:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14780' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 30/12/2024 10:46: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 ( '14780' , '91' , 'I 10 COMANDAMENTI' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 30/12/2024 10:46: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 ( '14780' , '92' , 'LA PREGHIERA DEL ROSARIO' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 30/12/2024 10:46: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 ( '14780' , '94' , 'IL BATTESIMO' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 30/12/2024 10:46: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 ( '14780' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 30/12/2024 10:46: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 ( '14780' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 30/12/2024 10:46: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 ( '14780' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '26' , '0' , '4' , '4.00' , '4' , '0' , '50' , '52.00' ) 30/12/2024 10:46: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 ( '14780' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '8' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 30/12/2024 10:46: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 ( '14780' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '52' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '65.00' ) 30/12/2024 10:46: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 ( '14780' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 30/12/2024 10:46: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 ( '14780' , '138' , 'LA NASCITA DI GESU' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 30/12/2024 10:46: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 ( '14780' , '139' , 'E NATO - n.e.' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 30/12/2024 10:46: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 ( '14780' , '126' , 'SACRAMENTO DEL PERDONO' , '9' , '0' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 30/12/2024 10:49:19 am >> SELECT document_num FROM ps_document WHERE document_num = '29/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:49: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 ( '25' , '29/S' , '2024-12-30' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA DICEMBRE 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.05' , '58.05' , NOW() , NOW() ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14781' 30/12/2024 10:49:19 am >> DELETE FROM ps_document_detail WHERE id_document = '14781' 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '18' , '18' , '4' , '2.50' , '2.5' , '0' , '50' , '22.50' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '50' , '3.75' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '2' , '2' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '91' , 'I 10 COMANDAMENTI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '102' , 'LE BEATITUDINI N.EDIZ.' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 30/12/2024 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14781' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 30/12/2024 10:49: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 ( '14781' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '8' , '8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 30/12/2024 10:58:02 am >> SELECT document_num FROM ps_document WHERE document_num = '61/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 10:58:02 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 ( '22' , '61/E' , '2024-12-30' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2047.55' , '2041.60' , NOW() , NOW() ) 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95091' 30/12/2024 10:58:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95091' 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '116' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '139.20' ) 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '27' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '33.75' ) 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '9675' , 'SARETE MIEI TESTIMONI' , '40' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '70.00' ) 30/12/2024 10:58:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '5457' , 'IO SONO CON VOI 1 PARTE' , '314' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '439.60' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '5458' , 'IO SONO CON VOI 2 PARTE' , '75' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '105.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11191' , 'VENITE CON ME 1 PARTE' , '96' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '134.40' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11192' , 'VENITE CON ME 2 PARTE' , '86' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '120.40' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '1.70' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '32' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '54.40' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '3' , '0' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '6629' , 'MIA PREGHIERA' , '77' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '34.65' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8408' , 'PRENDETE E MANGIATE' , '115' , '0' , '4' , '3.00' , '3' , '0' , '50' , '172.50' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4154' , 'FESTA DEL PERDONO' , '129' , '0' , '4' , '3.00' , '3' , '0' , '50' , '193.50' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '0.45' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '2679' , 'CONOSCERE GESU' , '96' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '168.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '15.20' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '17.10' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '28' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '53.20' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12819' , 'REGISTRO DEL CATECHISTA ' , '66' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '33.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '15' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '26.25' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '119' , '0' , '4' , '1.00' , '1' , '0' , '50' , '59.50' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '15020' , 'PREGARE OGNI GIORNO' , '66' , '0' , '4' , '1.00' , '1' , '0' , '50' , '33.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17257' , 'IO TI BATTEZZO ' , '16' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '14.40' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17630' , 'RACCONTI SOTTO LALBERO - G. CELENTANO' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 30/12/2024 10:58:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '39' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '37.05' ) 30/12/2024 11:02:58 am >> SELECT document_num FROM ps_document WHERE document_num = '61/E' AND id_document != '95091' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:02:58 am >> UPDATE ps_document SET id_document_type = '22', document_num = '61/E', document_date = '2024-12-30', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2402.05', price_tax_excluded = '2396.10', date_upd = NOW() WHERE id_document = '95091' 30/12/2024 11:02:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95091' 30/12/2024 11:02:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95091' 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '116' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '139.20' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '27' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '33.75' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '9675' , 'SARETE MIEI TESTIMONI' , '40' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '70.00' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '5457' , 'IO SONO CON VOI 1 PARTE' , '314' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '439.60' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '5458' , 'IO SONO CON VOI 2 PARTE' , '75' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '105.00' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11191' , 'VENITE CON ME 1 PARTE' , '96' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '134.40' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11192' , 'VENITE CON ME 2 PARTE' , '86' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '120.40' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '12.00' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '1.70' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '32' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '54.40' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '6629' , 'MIA PREGHIERA' , '77' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '34.65' ) 30/12/2024 11:02:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8408' , 'PRENDETE E MANGIATE' , '115' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '172.50' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '10.00' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4154' , 'FESTA DEL PERDONO' , '129' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '193.50' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.45' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '2679' , 'CONOSCERE GESU' , '96' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '168.00' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '0.80' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '15.20' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '17.10' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 30/12/2024 11:03:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '28' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '53.20' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12819' , 'REGISTRO DEL CATECHISTA ' , '66' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '33.00' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '15' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '26.25' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '119' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '59.50' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '15020' , 'PREGARE OGNI GIORNO' , '66' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '33.00' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 30/12/2024 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17257' , 'IO TI BATTEZZO ' , '16' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '14.40' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17630' , 'RACCONTI SOTTO LALBERO - G. CELENTANO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '39' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '37.05' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.00' , '7' , '0' , '50' , '14.00' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 30/12/2024 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '0' , '4' , '35.00' , '35' , '0' , '50' , '35.00' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '20722' , 'SEMINATORI DI GIOIA' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '8' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '124' , '0' , '4' , '3.00' , '3' , '0' , '50' , '186.00' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 11:03:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 30/12/2024 11:03: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 ( '95091' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '7.00' ) 30/12/2024 11:03: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 ( '95091' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '45' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '63.00' ) 30/12/2024 11:03: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 ( '95091' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 30/12/2024 11:03:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:03: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' , '4136' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.80' , '41.18' , NOW() , NOW() ) 30/12/2024 11:03: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 = '95092' 30/12/2024 11:03:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95092' 30/12/2024 11:03: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 ( '95092' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 30/12/2024 11:03: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 ( '95092' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 30/12/2024 11:03: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 ( '95092' , '21700' , 'E NATO - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/12/2024 11:05:36 am >> SELECT document_num FROM ps_document WHERE document_num = '61/E' AND id_document != '95091' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:05:36 am >> UPDATE ps_document SET id_document_type = '22', document_num = '61/E', document_date = '2024-12-30', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO DICEMBRE 2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2951.55', price_tax_excluded = '2945.60', date_upd = NOW() WHERE id_document = '95091' 30/12/2024 11:05:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95091' 30/12/2024 11:05:36 am >> DELETE FROM ps_document_detail WHERE id_document = '95091' 30/12/2024 11:05:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '116' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '139.20' ) 30/12/2024 11:05: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 ( '95091' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '27' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '33.75' ) 30/12/2024 11:05: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 ( '95091' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 30/12/2024 11:05: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 ( '95091' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 30/12/2024 11:05: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 ( '95091' , '9675' , 'SARETE MIEI TESTIMONI' , '40' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '70.00' ) 30/12/2024 11:05: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 ( '95091' , '5457' , 'IO SONO CON VOI 1 PARTE' , '314' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '439.60' ) 30/12/2024 11:05: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 ( '95091' , '5458' , 'IO SONO CON VOI 2 PARTE' , '75' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '105.00' ) 30/12/2024 11:05: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 ( '95091' , '11191' , 'VENITE CON ME 1 PARTE' , '96' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '134.40' ) 30/12/2024 11:05: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 ( '95091' , '11192' , 'VENITE CON ME 2 PARTE' , '86' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '120.40' ) 30/12/2024 11:05: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 ( '95091' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '12.00' ) 30/12/2024 11:05: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 ( '95091' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '1.70' ) 30/12/2024 11:05: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 ( '95091' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '32' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '54.40' ) 30/12/2024 11:05: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 ( '95091' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 30/12/2024 11:05: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 ( '95091' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 30/12/2024 11:05: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 ( '95091' , '6629' , 'MIA PREGHIERA' , '77' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '34.65' ) 30/12/2024 11:05: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 ( '95091' , '8408' , 'PRENDETE E MANGIATE' , '115' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '172.50' ) 30/12/2024 11:05: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 ( '95091' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '10.00' ) 30/12/2024 11:05: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 ( '95091' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 30/12/2024 11:05: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 ( '95091' , '4154' , 'FESTA DEL PERDONO' , '129' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '193.50' ) 30/12/2024 11:05: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 ( '95091' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.45' ) 30/12/2024 11:05: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 ( '95091' , '2679' , 'CONOSCERE GESU' , '96' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '168.00' ) 30/12/2024 11:05: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 ( '95091' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '0.80' ) 30/12/2024 11:05: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 ( '95091' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '15.20' ) 30/12/2024 11:05: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 ( '95091' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '17.10' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '28' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '53.20' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12819' , 'REGISTRO DEL CATECHISTA ' , '66' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '33.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '15' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '26.25' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '119' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '59.50' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '15020' , 'PREGARE OGNI GIORNO' , '66' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '33.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17257' , 'IO TI BATTEZZO ' , '16' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '14.40' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17630' , 'RACCONTI SOTTO LALBERO - G. CELENTANO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '39' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '37.05' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '14.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '35.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '20722' , 'SEMINATORI DI GIOIA' , '9' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '11.25' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '124' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '186.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 30/12/2024 11:05:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '7.00' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '45' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '63.00' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '23092' , 'SPERANZA CHE E IN NOI' , '37' , '0' , '4' , '3.00' , '3' , '0' , '50' , '55.50' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '110' , '0' , '4' , '8.00' , '8' , '0' , '50' , '440.00' ) 30/12/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95091' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '36' , '0' , '4' , '3.00' , '3' , '0' , '50' , '54.00' ) 30/12/2024 11:12:56 am >> SELECT document_num FROM ps_document WHERE document_num = '62/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:12:56 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 ( '25' , '62/E' , '2024-12-30' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA DICEMBRE 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '339.55' , '338.83' , NOW() , NOW() ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95093' 30/12/2024 11:12:56 am >> DELETE FROM ps_document_detail WHERE id_document = '95093' 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '5458' , 'IO SONO CON VOI 2 PARTE' , '8' , '8' , '4' , '2.80' , '2.8' , '0' , '50' , '11.20' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '11191' , 'VENITE CON ME 1 PARTE' , '48' , '48' , '4' , '2.80' , '2.8' , '0' , '50' , '67.20' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '2' , '2' , '4' , '3.40' , '3.4' , '0' , '50' , '3.40' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '8408' , 'PRENDETE E MANGIATE' , '10' , '10' , '4' , '3.00' , '3' , '0' , '50' , '15.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '4154' , 'FESTA DEL PERDONO' , '12' , '12' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '22' , '22' , '4' , '0.90' , '0.9' , '0' , '50' , '9.90' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '2679' , 'CONOSCERE GESU' , '5' , '5' , '4' , '3.50' , '3.5' , '0' , '50' , '8.75' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '1' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '7543' , 'PARABOLE DI GESÙ' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '8' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '4.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '4' , '4' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '2' , '2' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 30/12/2024 11:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20719' , 'CORONA DELL’ADDOLORATA' , '6' , '6' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '50' , '2.25' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '50' , '2.25' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20722' , 'SEMINATORI DI GIOIA' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '8' , '8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '7' , '7' , '4' , '10.00' , '10' , '0' , '50' , '35.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '22151' , 'MA DIO LO HA RISUSCITATO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 30/12/2024 11:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95093' , '22152' , 'A TE RICORRIAMO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 30/12/2024 11:13:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:13:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4137' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 30/12/2024 11:13:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95094' 30/12/2024 11:13:36 am >> DELETE FROM ps_document_detail WHERE id_document = '95094' 30/12/2024 11:13:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95094' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 30/12/2024 11:34:26 am >> SELECT document_num FROM ps_document WHERE document_num = '4138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:34: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' , '4138' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.25' , '118.83' , NOW() , NOW() ) 30/12/2024 11:34: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 = '95095' 30/12/2024 11:34:26 am >> DELETE FROM ps_document_detail WHERE id_document = '95095' 30/12/2024 11:34: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 ( '95095' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 30/12/2024 11:34: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 ( '95095' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/12/2024 11:34: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 ( '95095' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 30/12/2024 11:34: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 ( '95095' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 30/12/2024 11:34: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 ( '95095' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/12/2024 11:51:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:51:09 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' , '4139' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/12/2024 11:51:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95096' 30/12/2024 11:51:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95096' 30/12/2024 11:51:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95096' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/12/2024 11:54:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 11:54:09 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' , '4140' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 30/12/2024 11:54:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95097' 30/12/2024 11:54:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95097' 30/12/2024 11:54:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95097' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 30/12/2024 12:22:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '4141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:22:16 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' , '4141' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.00' , '129.51' , NOW() , NOW() ) 30/12/2024 12:22:16 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 = '95098' 30/12/2024 12:22:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '95098' 30/12/2024 12:22:16 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 ( '95098' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '2' , '-2' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '158.00' ) 30/12/2024 12:25:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:25: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' , '4142' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.00' , '63.11' , NOW() , NOW() ) 30/12/2024 12:25: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 = '95099' 30/12/2024 12:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '95099' 30/12/2024 12:25: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 ( '95099' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 30/12/2024 12:25: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 ( '95099' , '22104' , 'TURIBOLO - TURI' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 30/12/2024 12:32:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '4143' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:32:23 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' , '4143' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 30/12/2024 12:32:23 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 = '95100' 30/12/2024 12:32:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '95100' 30/12/2024 12:32:23 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 ( '95100' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 30/12/2024 12:38:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '4143' AND id_document != '95100' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:38:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4143', document_date = '2024-12-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '95100' 30/12/2024 12:38:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95100' 30/12/2024 12:38:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95100' 30/12/2024 12:38:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95100' , '6728' , 'STATUA MIRACOLOSA - CM 20 - 326' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 30/12/2024 12:41:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4144' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:41:32 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' , '4144' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.47' , '69.35' , NOW() , NOW() ) 30/12/2024 12:41:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95101' 30/12/2024 12:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95101' 30/12/2024 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95101' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/12/2024 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95101' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/12/2024 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95101' , '23120' , 'AMEN - GEN 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/12/2024 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95101' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 30/12/2024 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95101' , '16796' , 'LUMINO 5B BIANCO' , '336' , '-336' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '67.20' ) 30/12/2024 12:43:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '4145' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:43:00 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' , '4145' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 30/12/2024 12:43:00 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 = '95102' 30/12/2024 12:43:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '95102' 30/12/2024 12:43:00 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 ( '95102' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 30/12/2024 12:45:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4146' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:45:32 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' , '4146' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.90' , '101.12' , NOW() , NOW() ) 30/12/2024 12:45:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95103' 30/12/2024 12:45:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95103' 30/12/2024 12:45:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95103' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 30/12/2024 12:45:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95103' , '16796' , 'LUMINO 5B BIANCO' , '604' , '-604' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '120.80' ) 30/12/2024 12:47:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4147' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 12:47:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4147' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.70' , '19.43' , NOW() , NOW() ) 30/12/2024 12:47:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95104' 30/12/2024 12:47:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95104' 30/12/2024 12:47:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95104' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '23.70' ) 30/12/2024 12:52:44 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16796' 30/12/2024 12:52:44 pm >> UPDATE ps_stock_available SET quantity = quantity + '-7' WHERE id_product = '16796' 30/12/2024 02:46:40 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 ( '33' , '2024-DL003821' , '2024-12-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 30/12/2024 02:46:40 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 = '95105' 30/12/2024 02:46:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '95105' 30/12/2024 02:46:40 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 ( '95105' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '20' , '20' , '4' , '2.0000' , '2' , '0' , '45' , '22.00' ) 30/12/2024 02:46:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23298' AND id_supplier = '79' 30/12/2024 02:46:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23298' , '79' , '1' ) 30/12/2024 02:47:09 pm >> DELETE FROM ps_document WHERE id_document = '94804' 30/12/2024 02:47:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94804' 30/12/2024 02:48:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024-FV001928' , '2024-12-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.75' , '125.75' , NOW() , NOW() ) 30/12/2024 02:48:44 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 = '95106' 30/12/2024 02:48:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '95106' 30/12/2024 02:48:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95106' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '20' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '22.00' ) 30/12/2024 02:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23298' AND id_supplier = '79' 30/12/2024 02:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23298' , '79' , '1' ) 30/12/2024 02:48:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95106' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '10' , '0' , '4' , '9.5000' , '9.5' , '0' , '45' , '52.25' ) 30/12/2024 02:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23313' AND id_supplier = '79' 30/12/2024 02:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23313' , '79' , '1' ) 30/12/2024 02:48:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95106' , '23332' , 'PER UNA CHIESA SINODALE' , '10' , '0' , '4' , '7.0000' , '7' , '0' , '45' , '38.50' ) 30/12/2024 02:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23332' AND id_supplier = '79' 30/12/2024 02:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23332' , '79' , '1' ) 30/12/2024 02:49:08 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '2024-DL003821', document_date = '2024-12-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.00', price_tax_excluded = '22.00', date_upd = NOW() WHERE id_document = '95105' 30/12/2024 02:49:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95105' 30/12/2024 02:49:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95105' 30/12/2024 02:49:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95105' , '23298' , 'RIMETTI A NOI I NOSTRI DEBITI' , '20' , '20' , '4' , '2.0000' , '2' , '0' , '45' , '22.00' ) 30/12/2024 02:52:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '4020' AND id_document != '94955' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 30/12/2024 02:52:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4020', document_date = '2024-12-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '66.00', price_tax_excluded = '54.10', date_upd = NOW() WHERE id_document = '94955' 30/12/2024 02:52:36 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 = '94955' 30/12/2024 02:52:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94955' 30/12/2024 02:52:36 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 ( '94955' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 30/12/2024 02:52:36 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 ( '94955' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405/TPAD' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 30/12/2024 02:52:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '4024' AND id_document != '94960' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-20') 30/12/2024 02:52:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4024', document_date = '2024-12-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '208.50', price_tax_excluded = '179.27', date_upd = NOW() WHERE id_document = '94960' 30/12/2024 02:52:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94960' 30/12/2024 02:52:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94960' 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '50' , '-50' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '20.00' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '17257' , 'IO TI BATTEZZO ' , '10' , '-10' , '4' , '1.8000' , '1.8' , '0' , '0' , '18.00' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '18400' , 'CAMICE DUE PIEGONI POL. CERNIERA SPALLA - 405/TPAS' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 30/12/2024 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94960' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '8.60' ) 30/12/2024 02:57:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4056' AND id_document != '95003' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-23') 30/12/2024 02:57:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4056', document_date = '2024-12-23', 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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '95003' 30/12/2024 02:57:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95003' 30/12/2024 02:57:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95003' 30/12/2024 02:57:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95003' , '13316' , 'SEGNALIBRI E NATALE - 120' , '200' , '-200' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '30.00' ) 30/12/2024 02:57:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95003' , '23050' , 'CAMICE MICROFIBRA CERN. DAVANTI - 435PMA' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 30/12/2024 03:41:32 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '2024010002434', document_date = '2024-12-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '6', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '12', id_causal = '0', price_tax_included = '155.25', price_tax_excluded = '155.25', date_upd = NOW() WHERE id_document = '95043' 30/12/2024 03:41:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95043' 30/12/2024 03:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95043' 30/12/2024 03:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '26' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '50.70' ) 30/12/2024 03:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23328' , 'CONOSCERE MARIA E AFFIDARSI A LEI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23324' , 'PELLEGRINI DI SPERANZA' , '12' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '23.40' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23152' , 'MARIA NEL CANTO DEI POPOLI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23326' , 'ASCOLTARE, CONDIVIDERE, ORIENTARSI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23325' , 'AMARE E INSEGNARE AD AMARE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 30/12/2024 03:41:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95043' , '23327' , 'ABBIAMO CONOSCIUTO LAMORE' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '35' , '10.40' ) 30/12/2024 04:05:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '94951' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-19') 30/12/2024 04:05:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2024-12-19', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 50,00 - € 110 - € 100,00 30/12', 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 = '314.90', price_tax_excluded = '280.01', date_upd = NOW() WHERE id_document = '94951' 30/12/2024 04:05: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 = '94951' 30/12/2024 04:05:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94951' 30/12/2024 04:05: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 ( '94951' , '16795' , 'LUMINO 5F ROSSO' , '30' , '-30' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '9.00' ) 30/12/2024 04:05: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 ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 30/12/2024 04:05: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 ( '94951' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '40.00' ) 30/12/2024 04:05: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 ( '94951' , '23189' , 'GRUPPO NATIVITA STILIZZATA - PB18073' , '48' , '-48' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '86.40' ) 30/12/2024 04:05: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 ( '94951' , '0' , '24/12' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 30/12/2024 04:05: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 ( '94951' , '0' , 'campana vetro natività' , '1' , '-1' , '0' , '110.0000' , '110' , '0' , '0' , '110.00' ) 30/12/2024 04:05: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 ( '94951' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 30/12/2024 04:05: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 ( '94951' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 30/12/2024 04:05: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 ( '94951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 30/12/2024 04:05: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 ( '94951' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/12/2024 04:07:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 04:07: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' , '4148' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 30/12/2024 04:07: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 = '95107' 30/12/2024 04:07:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '95107' 30/12/2024 04:07: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 ( '95107' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 30/12/2024 04:17:56 pm >> DELETE FROM ps_document WHERE id_document = '94951' 30/12/2024 04:17:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '94951' 30/12/2024 04:20:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '4148' AND id_document != '95107' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 04:20:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4148', document_date = '2024-12-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '95107' 30/12/2024 04:20:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95107' 30/12/2024 04:20:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95107' 30/12/2024 04:20:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95107' , '16795' , 'LUMINO 5F ROSSO' , '30' , '-30' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 30/12/2024 04:20:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95107' , '23189' , 'GRUPPO NATIVITA STILIZZATA - PB18073' , '48' , '-48' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '72.00' ) 30/12/2024 04:20:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95107' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/12/2024 04:20:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95107' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 30/12/2024 04:34:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '141/A' AND id_document != '95077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-28') 30/12/2024 04:34:41 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '141/A', document_date = '2024-12-28', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '196.25', price_tax_excluded = '172.45', date_upd = NOW() WHERE id_document = '95077' 30/12/2024 04:34:41 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 = '95077' 30/12/2024 04:34:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '95077' 30/12/2024 04:34:41 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 ( '95077' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 30/12/2024 04:34:41 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 ( '95077' , '0' , 'SACRA FAMIGLIA' , '3' , '-3' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '15.00' ) 30/12/2024 04:34:41 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 ( '95077' , '0' , 'buono' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 30/12/2024 04:34:41 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 ( '95077' , '23326' , 'ASCOLTARE, CONDIVIDERE, ORIENTARSI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/12/2024 04:34:41 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 ( '95077' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 30/12/2024 04:43:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '4149' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 04:43:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4149' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 30/12/2024 04:43:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95108' 30/12/2024 04:43:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '95108' 30/12/2024 04:43:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95108' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 30/12/2024 05:55:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4150' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 05:55:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4150' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 30/12/2024 05:55:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95109' 30/12/2024 05:55:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '95109' 30/12/2024 05:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95109' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/12/2024 06:54:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 06:54:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4151' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.25' , '71.25' , NOW() , NOW() ) 30/12/2024 06:54:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95110' 30/12/2024 06:54:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95110' 30/12/2024 06:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95110' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '5' , '71.25' ) 30/12/2024 07:41:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 07:41:15 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' , '4152' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.70' , '16.15' , NOW() , NOW() ) 30/12/2024 07:41:15 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 = '95111' 30/12/2024 07:41:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '95111' 30/12/2024 07:41:15 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 ( '95111' , '19778' , 'ANELLO CROCE/S. RITA - 6578SR' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 30/12/2024 07:41:15 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 ( '95111' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 30/12/2024 07:41:15 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 ( '95111' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/12/2024 07:50:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 07:50:20 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' , '4153' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.90' , '24.90' , NOW() , NOW() ) 30/12/2024 07:50:20 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 = '95112' 30/12/2024 07:50:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '95112' 30/12/2024 07:50:20 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 ( '95112' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '-1' , '4' , '24.90' , '24.9' , '0' , '' , '24.90' ) 30/12/2024 07:53:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '4154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 30/12/2024 07:53:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4154' , '2024-12-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '25.00' , NOW() , NOW() ) 30/12/2024 07:53:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95113' 30/12/2024 07:53:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '95113' 30/12/2024 07:53:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95113' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 30/12/2024 07:53:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95113' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' )