MySQL function - how to execute without variable

[Ulti]

Hi, i have this SQL Query(guild rank)

SELECT  `g`.`id` AS  `id` ,  `g`.`name` AS  `name` , `g`.`logo_gfx_name` AS `logo`,
SUM(`p`.`kill_points`) AS `kills`,
SUM(`p`.`death_points`) AS `deaths`,
(SUM(  `p`.`level` ) + 20*(SUM((`p`.`achievementpoints` + `p`.`questpoints` + `p`.`addonpoints`))) + SUM(`p`.`kill_points` - `p`.`death_points`)) AS `all`
FROM  (SELECT *
      FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild->getId().')
      ORDER BY `level` DESC
      LIMIT 100) p
LEFT JOIN  `guild_ranks` gr ON  `p`.`rank_id` =  `gr`.`id` 
LEFT JOIN  `guilds` g ON  `gr`.`guild_id` =  `g`.`id`
WHERE  `g`.`id` =  `g`.`id`
GROUP BY  `name` 
ORDER BY  `all` DESC 
LIMIT 15;

and it works when my gęsior have variable $guild->getId() (for ex. in guild page), but when he havent it(in guild rank page) sql dont works
can somebody remake this SQL Query without $guild->getId(), please?