Run query: BG/Hero

Jump to navigation Jump to search

Clear cache Talk page

Hero

Hero name

DbfId Id
Hero cycles

Armor.pngHero's armor

Does not contains

>= , <=

Health.pngHero's health

Does not contains

>= , <=

Hero Power

Hero Power name

DbfId Id
Text

Each word:
Gold large icon.pngHero Power's cost

Does not contains

>= , <=

Advanced settings

For inputs that use SQL, see tables Cards for parameters to use. A table, CardsHeroPower, is actually Cards, but LEFT OUTER JOINed itself by parameter heroPowerDbfId.

Display format

Where

  • Overrides every input in the previous sections.
  • Corresponds to the SQL WHERE clause.
Group by

  • Corresponds to the SQL GROUP BY clause.
Order by

  • Corresponds to the SQL ORDER BY clause.
Limit

  • Corresponds to the SQL LIMIT clause.
  • Recommended size at 500. If the number of results is larger than that, it may cause lag or the query to not return the results.
Offset

  • Corresponds to the SQL OFFSET clause.
  • Combined with Limit in case the number of results may be larger than Limit.

Clear cache Talk page

Retrieved from "https://hearthstone.wiki.gg/wiki/Special:RunQuery/BG/Hero"