SELECT id FROM (SELECT DISTINCT a.id AS id, b AS ORDER FROM TABLE a JOIN TABLE b ON a.id = b.id WHERE something = something ) TABLE ORDER BY TABLE.ORDER