Fejl i sql-qurry

Denne sql giver fejl, hvorfor ?

SELECT Count(t_screenshots.id) AS cid, t_screenshots.gameid, First(t_screenshots.date) AS fdate, First(t_spil.title) AS ftitle
FROM t_screenshots INNER JOIN t_spil ON t_screenshots.gameid = t_spil.id
GROUP BY t_screenshots.gameid
ORDER BY First(t_screenshots.date) DESC;