Drilldown: 5e Spell
Jump to navigation
Jump to search
Choose a table:
- 35e Spell (6)
- 5eMonster (1466)
- 5e Adventure Creature (74)
- 5e Adventure Creature xRef (40)
- 5e Adventures (36)
- 5e Armor (5)
- 5e Background (49)
- 5e Class (18)
- 5e Condition (20)
- 5e Deity (308)
- 5e Disease (14)
- 5e Eldritch Invocation (54)
- 5e Feats (124)
- 5e Features (240)
- 5e Group Patron (8)
- 5e Height Weight (90)
- 5e Individual (508)
- 5e Language (0)
- 5e Location (6)
- 5e Magic Items (352)
- 5e Organization (17)
- 5e PA Creature (3)
- 5e PA Creature Trait (81)
- 5e Pact Boons (4)
- 5e Pantheon (18)
- 5e Race (103)
- 5e Spell (553)
- 5e Subclass (180)
- 5e Subrace (51)
- 5e Vessel (2)
- 5e Weapon (51)
- One Background (18)
- One Class (18)
- One Creature (11)
- One Eldritch Invocation (26)
- One Feat (64)
- One Species (9)
- One Spell (518)
- One Subclass (40)
- One Weapon (39)
- Pages Info (5215)
- Publication (182)
5e Spell > Sort Text 
:
Aganazzar's Schorcher 5e or
Mage Hand 5e or
Prayer of Healing 5e
& Spell Range :
30 feet or
90 feet or
Self
& Level:
Cantrip
& Canon Spell:
Yes
& Casters :
Arcane Trickster or
Eldritch Knight or
None
:
Aganazzar's Schorcher 5e or
Mage Hand 5e or
Prayer of Healing 5e
& Spell Range :
30 feet or
90 feet or
Self
& Level:
Cantrip
& Canon Spell:
Yes
& Casters :
Arcane Trickster or
Eldritch Knight or
None Use the filters below to narrow your results.
Sort Text: (Click arrow to add another value)
Spell Name:
Ritual:
Concentration:
Action Type:
Spell Range: (Click arrow to add another value)
Valuable Component:
Consumable Component:
Level: (Click arrow to add another value)
School:
Scalable:
Canon Spell: (Click arrow to add another value)
Casters: (Click arrow to add another value)
Showing below up to 2 results in range #1 to #2.
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Schorcher 5e' OR `5e_Spell_alias`.`Sort_Text` = 'Mage Hand 5e' OR `5e_Spell_al' at line 1
Function: CargoSQLQuery::run
Query: SELECT `5e_Spell_alias`.`_pageName` AS `_pageName` FROM `rly2_cargo__5e_Spell` `5e_Spell_alias` LEFT OUTER JOIN `rly2_cargo__5e_Spell__Casters` `5e_Spell_alias__Casters` ON ((`5e_Spell_alias`.`_ID`=`5e_Spell_alias__Casters`.`_rowID`)) WHERE (`5e_Spell_alias`.`Sort_Text` = 'Aganazzar's Schorcher 5e' OR `5e_Spell_alias`.`Sort_Text` = 'Mage Hand 5e' OR `5e_Spell_alias`.`Sort_Text` = 'Prayer of Healing 5e') AND (`5e_Spell_alias`.`Spell_Range` = '30 feet' OR `5e_Spell_alias`.`Spell_Range` = '90 feet' OR `5e_Spell_alias`.`Spell_Range` = 'Self') AND (`5e_Spell_alias`.`Level` = 'Cantrip') AND (`5e_Spell_alias`.`Canon_Spell` = '1') AND (`5e_Spell_alias__Casters`.`_value` = 'Arcane Trickster' OR `5e_Spell_alias__Casters`.`_value` = 'Eldritch Knight' OR ((`5e_Spell_alias__Casters`.`_value` = '' AND `5e_Spell_alias__Casters`.`_value` != 0) OR `5e_Spell_alias__Casters`.`_value` IS NULL) ) ORDER BY `5e_Spell_alias`.`_pageName` LIMIT 250