How to make a selection from three tables (new)?

Question

PHP

People help with the request, even it doesn’t work out, what am I doing wrong? It is necessary to display data from two tables according to different parameters, connected by one game table, data from the first table (npc) is displayed normally, and nothing from the second

SELECT game.id,game.type,npc.title,users.login FROM game LEFT JOIN npc ON game.id = npc.npc_id AND game.type = 'npc' 
        LEFT JOIN users ON game.id = users.user_id AND game.type = 'user' WHERE game.loc = '".$this -> user['loc']."' AND game.login != '".$this -> user['login']."' ORDER BY game.sort