MySQL Query ( SELECT DISTINCT `id`,`show`,`title`,`desc`,`folder` FROM `zp_albums` WHERE `show` = 1 AND ((`id`=74) OR (`id`=82)) ORDER BY sort_order ) Failed. Error:Expression #1 of ORDER BY clause is not in SELECT list, references column 'zen_internet.zp_albums.sort_order' which is not in SELECT list; this is incompatible with DISTINCT