[aim.dll]

Hey guys.

What's wrong with this line?

SELECT a.name, (SELECT points FROM `rcsgo_player` WHERE name = a.name) as points, (SELECT rank FROM `csgo_ranks` WHERE name = a.name) as rank FROM `csgo_clans_applications` a WHERE clan = '%i' ORDER BY rank DESC, points DESC

[gabuch2]

Subqueries need to be limited.

[Bugsy]

Is the name field unique?

[aim.dll]

What do you mean limited? So how to make this line right?

[+ARUKARI-]

Unless you present the table layout, there is no answer.

[gabuch2]

Originally Posted by aim.dll What do you mean limited? So how to make this line right?

Easiest way to "fix" it is to add LIMIT 1 at the end of your subqueries, but you need to verify why the subqueries are returning more than 1 row. If you let it slide it may result on unintended behaviour.

[Bugsy]

You would not be able to trust the results if more than 1 record is returned since the data should be specific to 1 player so I do not recommend using the LIMIT 1 statement.

Instead of using name, use steam id as this field is unique to a player and you will only get 1 result.

SELECT csgo_clans_applications.name, rcsgo_player.points, csgo_ranks.rank

FROM (csgo_clans_applications

LEFT JOIN rcsgo_player 
ON csgo_clans_applications.steamid = rcsgo_player.steamid)

LEFT JOIN csgo_ranks
ON csgo_clans_applications.steamid = csgo_ranks.steamid

WHERE clan = '%i' 

ORDER BY rank DESC, points DESC