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 = '1375078' OR catalog.id= '1375078') 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