SELECT name, description, ... WHERE id IN (SELECT id FROM table1 WHERE ... ORDER BY display_order, name)