Notice: Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'mobile.f.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
Error No: 3065
SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (1,2,3) AND f.filter_group_id = '1' AND fd.language_id = '1' ORDER BY f.sort_order, LCASE(fd.name) in /home/www/nico/mobile/system/database/mmysqli.php on line 22