Solved Sql query

[Rufo]

Hello i want to find players with storage value "13540 > 0" and i made this query, but doesnt work, could you help me out?

SELECT * FROM `players` WHERE (SELECT `player_id` FROM `player_storage` WHERE `key` = 13540 AND `value` > 0) = `id`

 

[SpiderOT]

SELECT * FROM `players` WHERE (SELECT `player_id` FROM `player_storage` WHERE `key` = 13540 AND `value` > 0)

 

[Rufo]

#1242 - Subquery returns more than 1 row

 

[SpiderOT]

SELECT * FROM `players` WHERE `id` IN ( SELECT player_id FROM `player_storage` WHERE `key` =13540 AND `value` >0 )

this should work

 

[Rufo]

yes it works, thank you!