-- По гильдии: 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;