Ještě poslední dotaz (SQL dotaz ) :

SELECT products_id, additional_name, min( additional_value ) , case when additional_value regexp '^[0-9]' then max( additional_value ) else additional_value end as val, additional_text FROM products_additional WHERE TYPE = 'ADI' AND products_id IN (61501, 61512, 61507, 61500, 61511, 61509, 61510) AND (additional_value regexp( '^[0-9]+$') = 1) GROUP BY additional_name ORDER BY additional_name, additional_value UNION SELECT products_id, additional_name, min( additional_value ) , case when additional_value regexp '^[0-9]' then max( additional_value ) else additional_value end as val, additional_text FROM products_additional WHERE TYPE = 'ADI' AND products_id IN (61501, 61512, 61507, 61500, 61511, 61509, 61510) AND (additional_value regexp( '^[0-9]+$') = 0) GROUP BY additional_name ORDER BY additional_name, additional_value

Je korektní, ale hlásí chybu: Incorrect usage of UNION and ORDER BY

Jak z tohoto ven?