Advertisement
Sansuall

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

Oct 22nd, 2023
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. По персонажу:
  2. https://wowroad.info/?item=45977
  3. SELECT
  4. characters.guid,
  5. characters.account,
  6. characters.name,
  7. characters.level,
  8. SUM( item_instance.count ) as total_count
  9. FROM
  10. characters
  11. INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
  12. WHERE
  13. item_instance.itemEntry = 45977
  14. GROUP BY
  15. characters.guid
  16. HAVING
  17. total_count > 19;
  18.  
  19.  
  20.  
  21. https://wowroad.info/?item=40211
  22. SELECT
  23. characters.guid,
  24. characters.account,
  25. characters.name,
  26. characters.level,
  27. SUM( item_instance.count ) as total_count
  28. FROM
  29. characters
  30. INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
  31. WHERE
  32. item_instance.itemEntry = 40211
  33. GROUP BY
  34. characters.guid
  35. HAVING
  36. total_count > 800;
  37.  
  38.  
  39.  
  40. https://wowroad.info/?item=33447
  41. SELECT
  42. characters.guid,
  43. characters.account,
  44. characters.name,
  45. characters.level,
  46. SUM( item_instance.count ) as total_count
  47. FROM
  48. characters
  49. INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
  50. WHERE
  51. item_instance.itemEntry = 33447
  52. GROUP BY
  53. characters.guid
  54. HAVING
  55. total_count > 800;
  56.  
  57.  
  58.  
  59. https://wowroad.info/?item=33448
  60. SELECT
  61. characters.guid,
  62. characters.account,
  63. characters.name,
  64. characters.level,
  65. SUM( item_instance.count ) as total_count
  66. FROM
  67. characters
  68. INNER JOIN item_instance ON characters.guid = item_instance.owner_guid
  69. WHERE
  70. item_instance.itemEntry = 33448
  71. GROUP BY
  72. characters.guid
  73. HAVING
  74. total_count > 800;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement