Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- По персонажу:
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement