Запрос по персонажу

-- По персонажу: 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;