Hearthstone Wiki

Hearthstone Wiki's card database has been updated to Patch 23.2.2.139719!

READ MORE

Hearthstone Wiki
Register
Don't have an account?
Sign In
Hearthstone Wiki
Hearthstone Wiki
18,287
pages

Run query: BG/Hero

Special page

Clear cache Talk page

Hero

Hero name

DbfId Id
Hero cycles

Armor.pngHero's tier

HealthHero'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

>= , <=

Abilities

Does not contains
Wiki tags

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

Community content is available under CC BY-NC-SA 3.0 unless otherwise noted.