ERROR: SELECT games.id, games.name, games.html_title, IF(games.text!='',1,0) AS caseStudy, games.url, games.new FROM games JOIN games_videos ON games_videos.id_game = games.id WHERE games.active = 1 AND games.hilite = 1 GROUP BY games.id ORDER BY games.priority ASC