Search results

SELECT player_name FROM onscore_players, onscore_scores WHERE onscore_players.game_id=1 AND onscore_players.player_id=onscore_scores.player_id AND onscore_scores.list_id=1 ORDER BY player_score DESC LIMIT 4,1