MySQLi Error (1054) Unknown column 'productions.director' in 'order clause'. Query: select productions.*, directors.name as director, stylists.name as stylist from productions left join (directors, stylists) on (directors.id = productions.director_id and stylists.id = productions.stylist_id) where is_active = 1 and production_category_id = 5 order by productions.director asc, productions.id desc limit 0, 15