PHP Code:
SELECT DISTINCT(videos.GTitle), videos.systemgames.yeargames.gamegames.boximage FROM games
INNER
JOIN
 videos
 ON videos
.GTitle games.game AND videos.system games.system
WHERE games
.year>=2005 ORDER BY videos.ID DESC LIMIT 4 
I want to show 4 games which have the newest videos. This right now is not working as it shows just the 4 newest added games.