-- По персонажу: https://wowroad.info/?item=45977
SELECT
characters.guid,
characters.account,
characters.name,
characters.level,
SUM( item_instance.count ) as total_count
FROM
characters
INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
WHERE
item_instance.itemEntry = 45977
GROUP BY
characters.guid
HAVING
total_count > 19;



-- https://wowroad.info/?item=40211
SELECT
characters.guid,
characters.account,
characters.name,
characters.level,
SUM( item_instance.count ) as total_count
FROM
characters
INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
WHERE
item_instance.itemEntry = 40211
GROUP BY
characters.guid
HAVING
total_count > 800;



-- https://wowroad.info/?item=33447
SELECT
characters.guid,
characters.account,
characters.name,
characters.level,
SUM( item_instance.count ) as total_count
FROM
characters
INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
WHERE
item_instance.itemEntry = 33447
GROUP BY
characters.guid
HAVING
total_count > 800;



-- https://wowroad.info/?item=33448
SELECT
characters.guid,
characters.account,
characters.name,
characters.level,
SUM( item_instance.count ) as total_count
FROM
characters
INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
WHERE
item_instance.itemEntry = 33448
GROUP BY
characters.guid
HAVING
total_count > 800;