Which sql query will be faster

[Scooty]

Hi, i have 2 sql queries, which will be faster?


1.

SELECT `name`, `rank_id` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = " .. getGuildId(getPlayerGuildName(cid)) .. ");

2.

SELECT COUNT(  `gr`.`id` ) AS  `total` 
FROM  `players` AS  `p` 
LEFT JOIN  `guild_ranks` AS  `gr` ON  `gr`.`id` =  `p`.`rank_id` 
WHERE  `gr`.`guild_id` = " .. getGuildId(getPlayerGuildName(cid))

thanks for help

 

[Scooty]

bump