Запрос по гильдии

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