-- По гильдии: https://wowroad.info/?item=45977
SELECT
 guild.guildid,
 guild.name,
 SUM( item_instance.count ) AS total_count 
FROM
 guild
 INNER JOIN guild_bank_item ON guild.guildid = guild_bank_item.guildid
 INNER JOIN item_instance ON guild_bank_item.item_guid = item_instance.guid 
WHERE
 item_instance.itemEntry = 45977 
GROUP BY
 guild.guildid 
HAVING
 total_count > 19;



-- https://wowroad.info/?item=40211
SELECT
 guild.guildid,
 guild.name,
 SUM( item_instance.count ) AS total_count 
FROM
 guild
 INNER JOIN guild_bank_item ON guild.guildid = guild_bank_item.guildid
 INNER JOIN item_instance ON guild_bank_item.item_guid = item_instance.guid 
WHERE
 item_instance.itemEntry = 40211 
GROUP BY
 guild.guildid 
HAVING
 total_count > 800;



-- https://wowroad.info/?item=33447
SELECT
 guild.guildid,
 guild.name,
 SUM( item_instance.count ) AS total_count 
FROM
 guild
 INNER JOIN guild_bank_item ON guild.guildid = guild_bank_item.guildid
 INNER JOIN item_instance ON guild_bank_item.item_guid = item_instance.guid 
WHERE
 item_instance.itemEntry = 33447 
GROUP BY
 guild.guildid 
HAVING
 total_count > 800;



-- https://wowroad.info/?item=33448
SELECT
 guild.guildid,
 guild.name,
 SUM( item_instance.count ) AS total_count 
FROM
 guild
 INNER JOIN guild_bank_item ON guild.guildid = guild_bank_item.guildid
 INNER JOIN item_instance ON guild_bank_item.item_guid = item_instance.guid 
WHERE
 item_instance.itemEntry = 33448 
GROUP BY
 guild.guildid 
HAVING
 total_count > 800;