im looking to link the following tables : articles.*, images.*, games.*
my query is :

SELECT articles.*, games.*, images.* FROM articles JOIN articles ON articles.id = 1 JOIN games ON games.id = articles.game_id JOIN images ON images.game_id = game.id


the "1" stands for a $_GET result that will be implemented dynamically