urob union dvoch selectov. jedno ti zgrupuje take, ktorych hodnoty su ciselne a druhe len surovo vypise tie, ktore su neciselne. opat som tam dal funkciu isnumeric, ktora viem, ze v mysql nie je. nahrad ju ekvivalentom (nechcelo sa mi ho hladat).

SELECT products_id, additional_name, min( additional_value ) ,  max( additional_value ) as val, additional_text
FROM products_additional
WHERE TYPE = 'ADI' AND ISNUMERIC(additional_value) = 1
GROUP BY additional_name

UNION ALL

SELECT products_id, additional_name, additional_value,  additional_value as val, additional_text
FROM products_additional
WHERE TYPE = 'ADI' AND ISNUMERIC(additional_value) = 0