Error SQL:


QUERY:
SELECT DISTINCT(gr.id), gr.id AS id, gr.text_cname AS text_cname, gr.text_name AS text_name FROM omk_ru_grcolors AS gr LEFT JOIN omk_ru_colors AS colors ON colors.select_grcolors_3 = gr.id LEFT JOIN omk_ru_catalog AS catalog ON catalog.pselect_colors_2 = colors.id WHERE (catalog.parent = '5513110' OR catalog.id= '5513110') AND catalog.check_active=1 ORDER BY catalog.text_price, gr.ord
MYSQL Error:Expression #1 of ORDER BY clause is not in SELECT list, references column 'alfam1_ofisnayam.catalog.text_price' which is not in SELECT list; this is incompatible with DISTINCT