31/10/2024 09:22:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 09:22: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 ( '11' , '3283' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 31/10/2024 09:22:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93979' 31/10/2024 09:22:03 am >> DELETE FROM ps_document_detail WHERE id_document = '93979' 31/10/2024 09:22: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 ( '93979' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2024 09:22: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 ( '93979' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2024 10:07:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3172' AND id_document != '93813' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 31/10/2024 10:07:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3172', document_date = '2024-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '564.50', price_tax_excluded = '488.45', date_upd = NOW() WHERE id_document = '93813' 31/10/2024 10:07: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 = '93813' 31/10/2024 10:07:26 am >> DELETE FROM ps_document_detail WHERE id_document = '93813' 31/10/2024 10:07: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 ( '93813' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 31/10/2024 10:07: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 ( '93813' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 31/10/2024 10:07: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 ( '93813' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 31/10/2024 10:07: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 ( '93813' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 31/10/2024 10:07: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 ( '93813' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '21.50' ) 31/10/2024 10:07: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 ( '93813' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '140.00' ) 31/10/2024 10:07: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 ( '93813' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/10/2024 10:07: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 ( '93813' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 31/10/2024 10:07: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 ( '93813' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 31/10/2024 10:37:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 10:37: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' , '3284' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.46' , '29.46' , NOW() , NOW() ) 31/10/2024 10:37: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 = '93980' 31/10/2024 10:37:48 am >> DELETE FROM ps_document_detail WHERE id_document = '93980' 31/10/2024 10:37: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 ( '93980' , '5846' , 'LIBRO DELLA PAROLA - M. PRIOTTO' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '5' , '22.80' ) 31/10/2024 10:37: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 ( '93980' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 31/10/2024 10:42:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 10:42:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3285' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.53' , '77.55' , NOW() , NOW() ) 31/10/2024 10:42:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93981' 31/10/2024 10:42:53 am >> DELETE FROM ps_document_detail WHERE id_document = '93981' 31/10/2024 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93981' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '40' , '-40' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '72.00' ) 31/10/2024 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93981' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/10/2024 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93981' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/10/2024 10:53:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3286' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 10:53:20 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' , '3286' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '204.25' , '169.99' , NOW() , NOW() ) 31/10/2024 10:53:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93982' 31/10/2024 10:53:20 am >> DELETE FROM ps_document_detail WHERE id_document = '93982' 31/10/2024 10:53: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 ( '93982' , '22252' , 'MADONNA CON BAMBINO CM 53 - PA504' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 31/10/2024 10:53: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 ( '93982' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 31/10/2024 10:58:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3287' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 10:58:00 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' , '3287' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.06' , '56.06' , NOW() , NOW() ) 31/10/2024 10:58:00 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 = '93983' 31/10/2024 10:58:00 am >> DELETE FROM ps_document_detail WHERE id_document = '93983' 31/10/2024 10:58: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 ( '93983' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 31/10/2024 10:58: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 ( '93983' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 31/10/2024 10:58: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 ( '93983' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 31/10/2024 10:58:22 am >> DELETE FROM ps_document WHERE id_document = '92245' 31/10/2024 10:58:22 am >> DELETE FROM ps_document_detail WHERE id_document = '92245' 31/10/2024 11:15:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001283' AND id_product != '16189' AND ean13 != '' 31/10/2024 11:15:23 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001283', date_upd = NOW() WHERE id_product = '16189' 31/10/2024 11:15:23 am >> UPDATE ps_product_lang SET name = 'STOLA CROCE - PST007', description = '' WHERE id_product = '16189' 31/10/2024 11:15:23 am >> UPDATE ps_product SET wholesale_price = '17.00', on_sale = '0', price = '43.442622950819676' WHERE id_product = '16189' 31/10/2024 11:15:24 am >> UPDATE ps_product_shop SET wholesale_price = '17.00', price = '43.442622950819676', id_tax_rules_group = '1', id_category_default = '440', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16189' 31/10/2024 11:15:24 am >> DELETE FROM ps_specific_price WHERE id_product = '16189' 31/10/2024 11:24:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2971' AND id_document != '93529' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-09') 31/10/2024 11:24:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2971', document_date = '2024-10-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '247.90', price_tax_excluded = '206.53', date_upd = NOW() WHERE id_document = '93529' 31/10/2024 11:24: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 = '93529' 31/10/2024 11:24:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93529' 31/10/2024 11:24: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 ( '93529' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 31/10/2024 11:24: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 ( '93529' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 31/10/2024 11:24: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 ( '93529' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 31/10/2024 11:24: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 ( '93529' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 31/10/2024 11:24: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 ( '93529' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 31/10/2024 11:24: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 ( '93529' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '14' , '11.475409836066' , '22' , '0' , '28.00' ) 31/10/2024 11:24:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2998' AND id_document != '93560' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 31/10/2024 11:24:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2998', document_date = '2024-10-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '93560' 31/10/2024 11:24:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93560' 31/10/2024 11:24:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93560' 31/10/2024 11:24: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 ( '93560' , '20272' , 'CASULA CROCE - 652' , '2' , '-2' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '120.00' ) 31/10/2024 11:24: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 ( '93560' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 31/10/2024 11:52:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3288' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 11:52:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3288' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.20' , '133.20' , NOW() , NOW() ) 31/10/2024 11:52:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93984' 31/10/2024 11:52:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93984' 31/10/2024 11:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93984' , '23106' , 'DILEXIT NOS' , '40' , '-40' , '4' , '3.50' , '3.5' , '0' , '5' , '133.20' ) 31/10/2024 12:00:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 12:00:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '117/A' , '2024-10-31' , 'A' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '434.00' , '432.02' , NOW() , NOW() ) 31/10/2024 12:00:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93985' 31/10/2024 12:00:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93985' 31/10/2024 12:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93985' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '14' , '-14' , '4' , '4.5' , '4.5' , '0' , '0' , '63.00' ) 31/10/2024 12:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93985' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '18' , '-18' , '4' , '4.5' , '4.5' , '0' , '0' , '81.00' ) 31/10/2024 12:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93985' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '25' , '-25' , '4' , '4.5' , '4.5' , '0' , '0' , '112.50' ) 31/10/2024 12:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93985' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '37' , '-37' , '4' , '4.5' , '4.5' , '0' , '0' , '166.50' ) 31/10/2024 12:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93985' , '12819' , 'REGISTRO DEL CATECHISTA ' , '11' , '-11' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '11.00' ) 31/10/2024 12:00:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3289' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 12:00:55 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' , '3289' , '2024-10-31' , '' , '0' , '0' , '0' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '434.00' , '432.02' , NOW() , NOW() ) 31/10/2024 12:00:55 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 = '93986' 31/10/2024 12:00:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93986' 31/10/2024 12:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93986' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '14' , '-14' , '4' , '4.5000' , '4.5' , '0' , '0' , '63.00' ) 31/10/2024 12:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93986' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '18' , '-18' , '4' , '4.5000' , '4.5' , '0' , '0' , '81.00' ) 31/10/2024 12:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93986' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '25' , '-25' , '4' , '4.5000' , '4.5' , '0' , '0' , '112.50' ) 31/10/2024 12:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93986' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '37' , '-37' , '4' , '4.5000' , '4.5' , '0' , '0' , '166.50' ) 31/10/2024 12:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93986' , '12819' , 'REGISTRO DEL CATECHISTA ' , '11' , '-11' , '1' , '1.0000' , '0.8197' , '22' , '0' , '11.00' ) 31/10/2024 12:08:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3194' AND id_document != '93855' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 31/10/2024 12:08:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3194', document_date = '2024-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.50', price_tax_excluded = '6.50', date_upd = NOW() WHERE id_document = '93855' 31/10/2024 12:08:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93855' 31/10/2024 12:08:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93855' 31/10/2024 12:08: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 ( '93855' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 31/10/2024 12:08: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 ( '93855' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 31/10/2024 12:09:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3026' AND id_document != '93600' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 31/10/2024 12:09:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3026', document_date = '2024-10-14', 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 = '3', id_causal = '0', price_tax_included = '828.33', price_tax_excluded = '768.57', date_upd = NOW() WHERE id_document = '93600' 31/10/2024 12:09:51 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 = '93600' 31/10/2024 12:09:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93600' 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22912' , 'CALENDARIO DA TAVOLO 2025 - 40825' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22985' , 'CHE PESCI PIGLIARE ' , '1' , '-1' , '4' , '11.5000' , '11.5' , '0' , '5' , '10.93' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '50' , '-50' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '35.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '21.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '6019' , 'LUMINO ROSSO - 10B' , '384' , '-384' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '192.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '14' , '-14' , '4' , '5.0000' , '5' , '0' , '5' , '66.50' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '23023' , 'ABBI CURA DI TE STESSO - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22876' , 'AMEN - NOV 24' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22875' , 'AMEN - DIC 24' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22902' , 'PREGARE CON IL CORPO - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22898' , 'VIGILANZA QUOTIDIANA - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22901' , 'ORAZIONE MENTALE - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22900' , 'LECTIO DIVINA - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22899' , 'SILENZIO - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '3' , '-3' , '4' , '20.0000' , '20' , '0' , '5' , '57.00' ) 31/10/2024 12:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 31/10/2024 12:09:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 31/10/2024 12:09:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '199.86' , '199.86' , '0' , '0' , '199.86' ) 31/10/2024 12:11:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2919' AND id_document != '93460' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-04') 31/10/2024 12:11:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2919', document_date = '2024-10-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '93460' 31/10/2024 12:11:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93460' 31/10/2024 12:11:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93460' 31/10/2024 12:11:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93460' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '82.0000' , '67.213114754098' , '22' , '0' , '82.00' ) 31/10/2024 12:11:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93460' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 31/10/2024 12:12:56 pm >> DELETE FROM ps_document WHERE id_document = '93985' 31/10/2024 12:12:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93985' 31/10/2024 12:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3290' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 12:13: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' , '3290' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 31/10/2024 12:13: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 = '93987' 31/10/2024 12:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93987' 31/10/2024 12:13: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 ( '93987' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 31/10/2024 12:20:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3291' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 12:20: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' , '3291' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.70' , '93.84' , NOW() , NOW() ) 31/10/2024 12:20: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 = '93988' 31/10/2024 12:20:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93988' 31/10/2024 12:20: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 ( '93988' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 31/10/2024 12:20: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 ( '93988' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 31/10/2024 12:20: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 ( '93988' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 31/10/2024 12:20: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 ( '93988' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/10/2024 12:20: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 ( '93988' , '13083' , 'PREGHIERA PER I DEFUNTI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 31/10/2024 12:20: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 ( '93988' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 31/10/2024 12:44:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3003' AND id_document != '93569' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 31/10/2024 12:44:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3003', document_date = '2024-10-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '257.90', price_tax_excluded = '211.39', date_upd = NOW() WHERE id_document = '93569' 31/10/2024 12:44:51 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 = '93569' 31/10/2024 12:44:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93569' 31/10/2024 12:44:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93569' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' ) 31/10/2024 12:44:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93569' , '19793' , 'STOLA IHS - 220' , '1' , '-1' , '1' , '73.0000' , '59.83606557377' , '22' , '0' , '73.00' ) 31/10/2024 12:44:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93569' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.45' , '0.36885245901639' , '22' , '0' , '0.90' ) 31/10/2024 12:44:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93569' , '19150' , 'MOCCOLO 70X200' , '16' , '-16' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '136.00' ) 31/10/2024 12:46:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3292' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 12:46:03 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' , '3292' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 31/10/2024 12:46:03 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 = '93989' 31/10/2024 12:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93989' 31/10/2024 12:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93989' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 31/10/2024 12:50:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3026' AND id_document != '93600' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 31/10/2024 12:50:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3026', document_date = '2024-10-14', 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 = '3', id_causal = '0', price_tax_included = '828.33', price_tax_excluded = '768.57', date_upd = NOW() WHERE id_document = '93600' 31/10/2024 12:50:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93600' 31/10/2024 12:50:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93600' 31/10/2024 12:50:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22912' , 'CALENDARIO DA TAVOLO 2025 - 40825' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22985' , 'CHE PESCI PIGLIARE ' , '1' , '-1' , '4' , '11.5000' , '11.5' , '0' , '5' , '10.93' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '50' , '-50' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '35.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '21.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '6019' , 'LUMINO ROSSO - 10B' , '384' , '-384' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '192.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '14' , '-14' , '4' , '5.0000' , '5' , '0' , '5' , '66.50' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '23023' , 'ABBI CURA DI TE STESSO - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22876' , 'AMEN - NOV 24' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22875' , 'AMEN - DIC 24' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22902' , 'PREGARE CON IL CORPO - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22898' , 'VIGILANZA QUOTIDIANA - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22901' , 'ORAZIONE MENTALE - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22900' , 'LECTIO DIVINA - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22899' , 'SILENZIO - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '3' , '-3' , '4' , '20.0000' , '20' , '0' , '5' , '57.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '100.86' , '100.86' , '0' , '0' , '100.86' ) 31/10/2024 12:50:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '22' , '-22' , '4' , '4.5' , '4.5' , '0' , '0' , '99.00' ) 31/10/2024 12:53:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3293' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 12:53:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3293' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 31/10/2024 12:53:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93990' 31/10/2024 12:53:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93990' 31/10/2024 12:53:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93990' , '21691' , 'PENDENTE FF 10X11' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2024 12:54:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3117' AND id_document != '93733' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-21') 31/10/2024 12:54:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3117', document_date = '2024-10-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '260.00', price_tax_excluded = '213.48', date_upd = NOW() WHERE id_document = '93733' 31/10/2024 12:54:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93733' 31/10/2024 12:54:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93733' 31/10/2024 12:54:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93733' , '19818' , 'INCENSO NATURALE 3A KG 1' , '3' , '-3' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '69.00' ) 31/10/2024 12:54:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93733' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 31/10/2024 12:54:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93733' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 31/10/2024 12:54:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93733' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '10' , '-10' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '40.00' ) 31/10/2024 12:54:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93733' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 31/10/2024 12:54:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93733' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 31/10/2024 02:23:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2723' AND id_document != '93188' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-18') 31/10/2024 02:23:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2723', document_date = '2024-09-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '76.78', price_tax_excluded = '75.79', date_upd = NOW() WHERE id_document = '93188' 31/10/2024 02:23:53 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 = '93188' 31/10/2024 02:23:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93188' 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '17201' , 'DOMANDE GRANDI DEI BAMBINI - COFANETTO' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '5' , '23.66' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '5' , '5.70' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 31/10/2024 02:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93188' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 31/10/2024 02:24:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3064' AND id_document != '93655' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 31/10/2024 02:24:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3064', document_date = '2024-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.50', price_tax_excluded = '28.50', date_upd = NOW() WHERE id_document = '93655' 31/10/2024 02:24:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93655' 31/10/2024 02:24:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '93655' 31/10/2024 02:24:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93655' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '5' , '28.50' ) 31/10/2024 02:24:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3071' AND id_document != '93662' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 31/10/2024 02:24:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3071', document_date = '2024-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.90', price_tax_excluded = '20.90', date_upd = NOW() WHERE id_document = '93662' 31/10/2024 02:24:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93662' 31/10/2024 02:24:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93662' 31/10/2024 02:24:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93662' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 31/10/2024 02:24:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93662' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 02:24:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93662' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2024 02:24:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93662' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2024 02:24:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93662' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 02:25:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3092' AND id_document != '93697' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-18') 31/10/2024 02:25:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3092', document_date = '2024-10-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.08', price_tax_excluded = '8.08', date_upd = NOW() WHERE id_document = '93697' 31/10/2024 02:25:09 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 = '93697' 31/10/2024 02:25:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93697' 31/10/2024 02:25:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93697' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 31/10/2024 02:25:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93697' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/10/2024 02:25:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3257' AND id_document != '93938' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-29') 31/10/2024 02:25:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3257', document_date = '2024-10-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '34.75', price_tax_excluded = '31.05', date_upd = NOW() WHERE id_document = '93938' 31/10/2024 02:25:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93938' 31/10/2024 02:25:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93938' 31/10/2024 02:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93938' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/10/2024 02:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93938' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 31/10/2024 02:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93938' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 31/10/2024 02:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93938' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 31/10/2024 02:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93938' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/10/2024 02:56:51 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/10/2024 02:56:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23142' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 02:56:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23142' , '1' , '1' , '2' , NOW() , NOW() ) 31/10/2024 02:56:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23142' , '0' , '1' , '0' , '0' ) 31/10/2024 02:57:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793156' AND id_product != '23142' AND ean13 != '' 31/10/2024 02:57:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793156', date_upd = NOW() WHERE id_product = '23142' 31/10/2024 02:57:30 pm >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - GEN FEB 2025', description = '' WHERE id_product = '23142' 31/10/2024 02:57:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23142' 31/10/2024 02:57:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23142' 31/10/2024 02:57:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '23142' 31/10/2024 02:57:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23142' 31/10/2024 02:57:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23143' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 02:57:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23143' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23142' 31/10/2024 02:57:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23143' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23142' 31/10/2024 02:57: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 ( '31' , '396/24' , '2024-10-22' , '24' , '0' , '40' , '2635' , 'VIA CARLO POMA, 2 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '43.20' , '43.20' , NOW() , NOW() ) 31/10/2024 02:57: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 = '93991' 31/10/2024 02:57:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93991' 31/10/2024 02:57: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 ( '93991' , '23142' , 'MESSA MEDITAZIONE - GEN FEB 2025' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 31/10/2024 02:57:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23142' AND id_supplier = '40' 31/10/2024 02:57:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23142' , '40' , '1' ) 31/10/2024 03:17:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069341' AND id_product != '23143' AND ean13 != '' 31/10/2024 03:17:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788801069341', date_upd = NOW() WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> UPDATE ps_product_lang SET name = 'CATECHISTI DI SPERANZA - F. VANNOTTI', description = '' WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.9' WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '35', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23144' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 03:17:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23144' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23143' 31/10/2024 03:17:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23144' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23143' 31/10/2024 03:19:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882276218' AND id_product != '23144' AND ean13 != '' 31/10/2024 03:19:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788882276218', date_upd = NOW() WHERE id_product = '23144' 31/10/2024 03:19:07 pm >> UPDATE ps_product_lang SET name = 'UNA STORIA DEL MESSIA', description = '' WHERE id_product = '23144' 31/10/2024 03:19:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '23144' 31/10/2024 03:19:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '248', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23144' 31/10/2024 03:19:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23144' 31/10/2024 03:19:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23144' 31/10/2024 03:19:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23145' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 03:19:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23145' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23144' 31/10/2024 03:19:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23145' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23144' 31/10/2024 03:19:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069419' AND id_product != '23145' AND ean13 != '' 31/10/2024 03:19:59 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788801069419', date_upd = NOW() WHERE id_product = '23145' 31/10/2024 03:19:59 pm >> UPDATE ps_product_lang SET name = 'SEI GRANDE! - PAPA FRANCESCO', description = '' WHERE id_product = '23145' 31/10/2024 03:19:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23145' 31/10/2024 03:19:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23145' 31/10/2024 03:19:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '23145' 31/10/2024 03:20:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23145' 31/10/2024 03:20:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23146' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 03:20:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23146' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23145' 31/10/2024 03:20:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23146' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23145' 31/10/2024 03:20:34 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' , '679606' , '2024-10-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.71' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.13' , '124.79' , NOW() , NOW() ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93992' 31/10/2024 03:20:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93992' 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '35' , '5.1350' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23143' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23143' , '7' , '1' ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '22527' , 'ROSARIO CON PAPA FRANCESCO - N.E.' , '1' , '1' , '1' , '32.37' , '26.532786885246' , '22' , '25' , '29.6185' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22527' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22527' , '7' , '1' ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '22746' , 'COME SE VEDESSE LINVISIBILE - G.M. DOS SANTOS' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22746' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22746' , '7' , '1' ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '1826' , 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO' , '3' , '3' , '4' , '6.50' , '6.5' , '0' , '33' , '13.0650' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1826' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1826' , '7' , '1' ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '12104' , 'MINISTERO ORDINATO - E. CASTELLUCCI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '30' , '18.2000' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12104' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12104' , '7' , '1' ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '23144' , 'UNA STORIA DEL MESSIA' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23144' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23144' , '7' , '1' ) 31/10/2024 03:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93992' , '23145' , 'SEI GRANDE! - PAPA FRANCESCO' , '4' , '4' , '4' , '14.00' , '14' , '0' , '35' , '36.4000' ) 31/10/2024 03:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23145' AND id_supplier = '7' 31/10/2024 03:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23145' , '7' , '1' ) 31/10/2024 03:21:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 03:21:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '117/A' , '2024-10-31' , 'A' , '3353' , '0' , '4670000' , 'VIA 84100 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '18.20' , NOW() , NOW() ) 31/10/2024 03:21:37 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 = '93993' 31/10/2024 03:21:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93993' 31/10/2024 03:21:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93993' , '' , 'LAMPADA' , '1' , '-1' , '0' , '10' , '10' , '' , '0' , '10.00' ) 31/10/2024 03:21:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93993' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2024 03:36:06 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 ( '31' , '278' , '2024-10-29' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '424.85' , '348.24' , NOW() , NOW() ) 31/10/2024 03:36:06 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 = '93994' 31/10/2024 03:36:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93994' 31/10/2024 03:36:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '7' , '7' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '137.4940' ) 31/10/2024 03:36:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 31/10/2024 03:36:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 31/10/2024 03:36:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '1' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '21.6745' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16494' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16494' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '1' , '1' , '20.8' , '17.049180327869' , '22' , '10' , '22.8384' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16588' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16588' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '1' , '1' , '1' , '18.10' , '14.83606557377' , '22' , '6' , '20.7571' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19606' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19606' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '18682' , 'CLERGY ROMANO ML - C17' , '2' , '2' , '1' , '25.1' , '20.573770491803' , '22' , '10' , '55.1196' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18682' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18682' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '16535' , 'CLERGY MARANGEL ML - C20' , '3' , '3' , '1' , '21' , '17.213114754098' , '22' , '10' , '69.1740' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16535' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16535' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '16461' , 'CLERGY NIDO DAPE ML - C22' , '1' , '1' , '1' , '25.9' , '21.229508196721' , '22' , '10' , '28.4382' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16461' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16461' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '1' , '1' , '22.5' , '18.44262295082' , '22' , '10' , '24.7050' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22196' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22196' , '137' , '1' ) 31/10/2024 03:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93994' , '18984' , 'POLO FELPATO ML ' , '1' , '1' , '1' , '28' , '22.950819672131' , '22' , '5' , '32.4520' ) 31/10/2024 03:36:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '137' 31/10/2024 03:36:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '137' , '1' ) 31/10/2024 03:39: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 ( '32' , '2024-FV001568' , '2024-10-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '32.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '919.70' , '919.70' , NOW() , NOW() ) 31/10/2024 03:39: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 = '93995' 31/10/2024 03:39:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '93995' 31/10/2024 03:39: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 ( '93995' , '14418' , 'MISSALE ROMANUM EDITIO TERTIA' , '1' , '0' , '4' , '200.0000' , '200' , '0' , '35' , '130.00' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14418' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14418' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '10119' , 'SPE SALVI' , '53' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '58.30' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10119' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10119' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '22507' , 'SPES NON CONFUNDIT' , '20' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '22.00' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '3' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '48.75' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '23051' , 'PREGHIERE A MARIA - PAPA FRANCESCO' , '3' , '0' , '4' , '11.0000' , '11' , '0' , '45' , '18.15' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23051' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23051' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21656' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21656' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '22507' , 'SPES NON CONFUNDIT' , '20' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '22.00' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '5' , '0' , '4' , '13.0000' , '13' , '0' , '45' , '35.75' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15024' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15024' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/10/2024 03:39:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 31/10/2024 03:39:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 31/10/2024 03:39: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 ( '93995' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '22507' , 'SPES NON CONFUNDIT' , '40' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '44.00' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '23086' , 'GLORIA DEI BUONI A NULLA - S. DETOC' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '45' , '7.70' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23086' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23086' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '23106' , 'DILEXIT NOS' , '50' , '0' , '4' , '3.5000' , '3.5' , '0' , '45' , '96.25' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23106' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23106' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '23140' , 'PREGHIERA DEL MATTINO E DELLA SERA - N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23140' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23140' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21656' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21656' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '3' , '0' , '4' , '15.5000' , '15.5' , '0' , '30' , '32.55' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '79' , '1' ) 31/10/2024 03:39:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93995' , '23106' , 'DILEXIT NOS' , '80' , '0' , '4' , '3.5000' , '3.5' , '0' , '45' , '154.00' ) 31/10/2024 03:39:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23106' AND id_supplier = '79' 31/10/2024 03:39:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23106' , '79' , '1' ) 31/10/2024 04:03:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '75060 cvj' AND id_product != '23146' AND ean13 != '' 31/10/2024 04:03:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75060 cvj', date_upd = NOW() WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> UPDATE ps_product_lang SET name = 'SPILLA PORTA CIUCCIO CEL.', description = '' WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '453', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23147' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 04:03:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23147' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23146' 31/10/2024 04:03:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23147' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23146' 31/10/2024 04:04:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057960203011' AND id_product != '23147' AND ean13 != '' 31/10/2024 04:04:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8057960203011', date_upd = NOW() WHERE id_product = '23147' 31/10/2024 04:04:07 pm >> UPDATE ps_product_lang SET name = 'SPILLA PORTA CIUCCIO ROSA', description = '' WHERE id_product = '23147' 31/10/2024 04:04:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '23147' 31/10/2024 04:04:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '453', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23147' 31/10/2024 04:04:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23147' 31/10/2024 04:04:07 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23147' 31/10/2024 04:04:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23148' , '1' , '' , 'nuovo-prodotto' ) 31/10/2024 04:04:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23148' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23147' 31/10/2024 04:04:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23148' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23147' 31/10/2024 04:09:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057960203004' AND id_product != '23146' AND ean13 != '' 31/10/2024 04:09:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8057960203004', date_upd = NOW() WHERE id_product = '23146' 31/10/2024 04:09:03 pm >> UPDATE ps_product_lang SET name = 'SPILLA PORTA CIUCCIO CEL.', description = '' WHERE id_product = '23146' 31/10/2024 04:09:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.1148' WHERE id_product = '23146' 31/10/2024 04:09:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.1148', id_tax_rules_group = '1', id_category_default = '453', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23146' 31/10/2024 04:09:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '23146' 31/10/2024 04:09:33 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 ( '31' , '1/2871' , '2024-10-24' , '2871' , '0' , '131' , '4670575' , 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI' , '' , '' , '0.01' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '26.01' , '21.32' , NOW() , NOW() ) 31/10/2024 04:09:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93996' 31/10/2024 04:09:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93996' 31/10/2024 04:09: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 ( '93996' , '23147' , 'SPILLA PORTA CIUCCIO ROSA' , '2' , '2' , '1' , '5.3279' , '4.367131147541' , '22' , '' , '13.0001' ) 31/10/2024 04:09:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23147' AND id_supplier = '131' 31/10/2024 04:09:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23147' , '131' , '1' ) 31/10/2024 04:09: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 ( '93996' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '2' , '2' , '1' , '5.3279' , '4.367131147541' , '22' , '0' , '13.0001' ) 31/10/2024 04:09:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23146' AND id_supplier = '131' 31/10/2024 04:09:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23146' , '131' , '1' ) 31/10/2024 04:45:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '93369' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-01') 31/10/2024 04:45:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '133', document_date = '2024-10-01', document_letter = '', id_customer = '1246', id_supplier = '', id_address = '4675590', address1 = 'L.GO MARGHERITA DI SAVOIA 85021 AVIGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '198.80', price_tax_excluded = '198.80', date_upd = NOW() WHERE id_document = '93369' 31/10/2024 04:45:46 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 = '93369' 31/10/2024 04:45:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '93369' 31/10/2024 04:45:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '15020' , 'PREGARE OGNI GIORNO' , '100' , '-100' , '4' , '1.0000' , '1' , '0' , '15' , '85.00' ) 31/10/2024 04:45:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '15' , '3.83' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '15' , '5.95' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '15' , '3.83' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '0' , '0.5000' , '0.5' , '0' , '15' , '21.25' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '15' , '12.75' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '15' , '15.72' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '15' , '21.25' ) 31/10/2024 04:45:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93369' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '9.125' , '9.125' , '0' , '0' , '18.25' ) 31/10/2024 04:47:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '138' AND id_document != '93415' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-02') 31/10/2024 04:47:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '138', document_date = '2024-10-02', document_letter = '', id_customer = '4119', id_supplier = '', id_address = '4679375', address1 = 'PIAZZA MICHELE D\\\'ASTE 2 84042 ACERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '531.77', price_tax_excluded = '531.77', date_upd = NOW() WHERE id_document = '93415' 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93415' 31/10/2024 04:47:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93415' 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '2679' , 'CONOSCERE GESU\'' , '24' , '-24' , '4' , '3.5000' , '3.5' , '0' , '15' , '71.40' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '11192' , 'VENITE CON ME 2 PARTE' , '37' , '-37' , '4' , '2.8000' , '2.8' , '0' , '15' , '88.06' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '11191' , 'VENITE CON ME 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '11193' , 'VENITE CON ME CAT.' , '37' , '-37' , '4' , '5.5000' , '5.5' , '0' , '5' , '193.32' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '5444' , 'IO SONO CON VOI - CAT.' , '10' , '-10' , '4' , '5.5000' , '5.5' , '0' , '5' , '52.25' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '0' , '4.00' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '15' , '23.80' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '15' , '23.80' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 31/10/2024 04:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93415' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 31/10/2024 04:48:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '140' AND id_document != '93508' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 31/10/2024 04:48:21 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '140', document_date = '2024-10-08', document_letter = '', id_customer = '4123', id_supplier = '', id_address = '4679380', address1 = 'VIA GRENOBLE 9 43123 PARMA', address2 = '', note = '', price_shipping = '4.99', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '26.38', price_tax_excluded = '26.38', date_upd = NOW() WHERE id_document = '93508' 31/10/2024 04:48:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93508' 31/10/2024 04:48:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93508' 31/10/2024 04:48:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93508' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '4.39' , '4.39' , '0' , '0' , '4.39' ) 31/10/2024 04:48:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93508' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 31/10/2024 04:52:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '93637' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-15') 31/10/2024 04:52:50 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '158', document_date = '2024-10-15', document_letter = '', id_customer = '4081', id_supplier = '', id_address = '4679276', address1 = 'VIA PAZZIGNO 6 80146 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '105.00', price_tax_excluded = '105.00', date_upd = NOW() WHERE id_document = '93637' 31/10/2024 04:52: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 = '93637' 31/10/2024 04:52:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '93637' 31/10/2024 04:52: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 ( '93637' , '22987' , 'GIUSEPPE MOSCATI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 04:52: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 ( '93637' , '7105' , 'NOVENA A SAN PIO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 04:52: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 ( '93637' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2024 04:52: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 ( '93637' , '22988' , 'PREGHIERA DANZA DELLO SPIRITO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 04:52: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 ( '93637' , '22953' , 'NOVENA DELLE ROSE' , '1' , '-1' , '4' , '1.1000' , '1.1' , '0' , '0' , '1.10' ) 31/10/2024 04:52: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 ( '93637' , '22952' , 'ROSARIO CON SANTA TERESA DI G. BAMBINO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 04:52: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 ( '93637' , '22767' , 'CUORE DI MAMMA - A. COMASTRI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2024 04:52: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 ( '93637' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 31/10/2024 04:52: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 ( '93637' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/10/2024 04:52: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 ( '93637' , '22884' , 'MARIA CAREZZA DI DIO - D. LIGAS' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 31/10/2024 04:52: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 ( '93637' , '6988' , 'NELLE TUE MANI LA MIA VITA - FR. M. DAVIDE' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 31/10/2024 04:52: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 ( '93637' , '22989' , 'MARIA MODELLO DI ISPIRAZIONE - S. VITA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 31/10/2024 04:52: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 ( '93637' , '22986' , 'GIOVANNI DI DIO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2024 04:52: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 ( '93637' , '23043' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 31/10/2024 04:52: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 ( '93637' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '10.8' , '10.8' , '0' , '0' , '10.80' ) 31/10/2024 04:52: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 ( '93637' , '0' , 'contrassegno ' , '1' , '-1' , '4' , '2.3700' , '2.37' , '0' , '0' , '2.37' ) 31/10/2024 04:53:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3122' AND id_document != '93741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-21') 31/10/2024 04:53:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3122', document_date = '2024-10-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '93741' 31/10/2024 04:53:28 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 = '93741' 31/10/2024 04:53:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '93741' 31/10/2024 04:53:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93741' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2024 04:53:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93741' , '23090' , 'ALBERO CON PRESEPE ' , '4' , '-4' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '100.00' ) 31/10/2024 04:53:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93741' , '16969' , 'CORONA DELLE ROSE - 10974' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 31/10/2024 04:55:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '165' AND id_document != '93716' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-19') 31/10/2024 04:55:03 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '165', document_date = '2024-10-19', document_letter = '', id_customer = '2843', id_supplier = '', id_address = '4673405', address1 = 'V. PICENZA, 63 BIS 84131 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '91.43', price_tax_excluded = '91.43', date_upd = NOW() WHERE id_document = '93716' 31/10/2024 04:55:03 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 = '93716' 31/10/2024 04:55:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93716' 31/10/2024 04:55:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93716' , '15020' , 'PREGARE OGNI GIORNO' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 31/10/2024 04:55:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93716' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.4000' , '2.4' , '0' , '15' , '4.08' ) 31/10/2024 04:55:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93716' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '15' , '23.80' ) 31/10/2024 04:55:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93716' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '15' , '23.80' ) 31/10/2024 04:55:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93716' , '2679' , 'CONOSCERE GESU' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2024 05:08:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '199' AND id_document != '93956' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-29') 31/10/2024 05:08:25 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '199', document_date = '2024-10-29', document_letter = '', id_customer = '4134', id_supplier = '', id_address = '4679407', address1 = 'VIA DEI CONFINI 58/20 59100 PRATO', address2 = '', note = '', price_shipping = '4.50', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '33.50', price_tax_excluded = '33.50', date_upd = NOW() WHERE id_document = '93956' 31/10/2024 05:08:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93956' 31/10/2024 05:08:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93956' 31/10/2024 05:08:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93956' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 31/10/2024 05:08:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93956' , '15020' , 'PREGARE OGNI GIORNO' , '9' , '-9' , '4' , '1.00' , '1' , '0' , '0' , '9.00' ) 31/10/2024 05:13:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3294' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 05:13: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' , '3294' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.16' , '103.37' , NOW() , NOW() ) 31/10/2024 05:13: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 = '93997' 31/10/2024 05:13:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93997' 31/10/2024 05:13: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 ( '93997' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 31/10/2024 05:13: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 ( '93997' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 31/10/2024 05:13: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 ( '93997' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 31/10/2024 05:13: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 ( '93997' , '11192' , 'VENITE CON ME 2 PARTE' , '3' , '-3' , '4' , '2.5' , '2.5' , '0' , '0' , '7.50' ) 31/10/2024 05:13:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3295' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 05:13:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3295' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.80' , '19.51' , NOW() , NOW() ) 31/10/2024 05:13:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93998' 31/10/2024 05:13:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93998' 31/10/2024 05:13:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93998' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '2' , '-2' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '23.80' ) 31/10/2024 05:17:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3296' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 05:17:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3296' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 31/10/2024 05:17: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 = '93999' 31/10/2024 05:17:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '93999' 31/10/2024 05:17: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 ( '93999' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 31/10/2024 06:37:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3297' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 06:37:05 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' , '3297' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 31/10/2024 06:37:05 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 = '94000' 31/10/2024 06:37:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94000' 31/10/2024 06:37:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94000' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 31/10/2024 07:11:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3298' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 31/10/2024 07:11:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3298' , '2024-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '8.40' , NOW() , NOW() ) 31/10/2024 07:11:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94001' 31/10/2024 07:11:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94001' 31/10/2024 07:11:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94001' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '12' , '-12' , '4' , '0.70' , '0.7' , '0' , '0' , '8.40' ) 31/10/2024 07:18:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3187' AND id_document != '93841' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 31/10/2024 07:18:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3187', document_date = '2024-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.66', price_tax_excluded = '80.65', date_upd = NOW() WHERE id_document = '93841' 31/10/2024 07:18:53 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 = '93841' 31/10/2024 07:18:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93841' 31/10/2024 07:18:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93841' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 31/10/2024 07:18:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93841' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 31/10/2024 07:18:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93841' , '1114' , 'BIBBIA DEGLI SPOSI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 31/10/2024 07:18:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93841' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 31/10/2024 07:18:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93841' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2024 07:18:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93841' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '35.5' , '29.098360655738' , '22' , '0' , '35.50' ) 31/10/2024 07:23:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10999' AND id_product != '18270' AND ean13 != '' 31/10/2024 07:23:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10999', date_upd = NOW() WHERE id_product = '18270' 31/10/2024 07:23:07 pm >> UPDATE ps_product_lang SET name = 'CORONA 7 PATER AVE E GLORIA', description = '' WHERE id_product = '18270' 31/10/2024 07:23:07 pm >> UPDATE ps_product SET wholesale_price = '1.72', on_sale = '0', price = '5' WHERE id_product = '18270' 31/10/2024 07:23:07 pm >> UPDATE ps_product_shop SET wholesale_price = '1.72', price = '5', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18270' 31/10/2024 07:23:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '18270'