5e:Spell: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 11: Line 11:
tables=5e_Spell,Pages_Info
tables=5e_Spell,Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)
|where=(Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL)
|fields=COUNT(5e_Spell._pageName)
|fields=COUNT(5e_Spell._pageName)
}} spells
}} spells
Line 29: Line 29:
tables=5e_Spell,Pages_Info
tables=5e_Spell,Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)
|where=(Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL)
|fields=5e_Spell._pageName,5e_Spell.Spell_Name,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters,Pages_Info.Canon,Pages_Info.UA,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.User,Pages_Info.Sources,Pages_Info.Deprecated
|fields=5e_Spell._pageName,5e_Spell.Spell_Name,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters,Pages_Info.Canon,Pages_Info.UA,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.User,Pages_Info.Sources,Pages_Info.Deprecated
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
Line 42: Line 42:
{{columns|3}}
{{columns|3}}
{{#cargo_query:
{{#cargo_query:
tables=5e_Spell,Pages_Info
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)
|where=(Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL)
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]')
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User, 5e_Spell.School, 5e_Spell.Ritual, 5e_Spell.Valuable_Component
|format=template
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
|limit=1000
|limit=1000
|format=list
|delimiter=<br />
|more results text=More Spells
}}
}}
</div><!-- columns --></div><!--
</div><!-- columns --></div><!--
Line 92: Line 91:
==Sources and Notes==
==Sources and Notes==
<references />
<references />
===Notes===
===Spell Notation===
:<sup>[r]</sup> These spells may be cast as {{srd5lc|Ritual}}s.
:<sup>{{anchor|a}}</sup>&nbsp;&nbsp;{{SRD5|Abjuration}}
:<sup>{{anchor|c}}</sup>&nbsp;&nbsp;{{SRD5|Conjuration}}
:<sup>{{anchor|d}}</sup>&nbsp;&nbsp;{{SRD5|Divination}}
:<sup>{{anchor|en}}</sup>&nbsp;{{SRD5|Enchantment}}
:<sup>{{anchor|ev}}</sup>&nbsp;{{SRD5|Evocation}}
:<sup>{{anchor|i}}</sup>&nbsp;&nbsp;{{SRD5|Illusion}}
:<sup>{{anchor|n}}</sup>&nbsp;&nbsp;{{SRD5|Necromancy}}
:<sup>{{anchor|t}}</sup>&nbsp;&nbsp;{{SRD5|Transmutation}}
:<sup>{{anchor|r}}</sup>&nbsp;&nbsp;These spells may be cast as {{srd5lc|Ritual}}s.
:<sup>{{anchor|vcc|$}}</sup>&nbsp;&nbsp;These spells have a {{srd5lc|Material Component}} that has a {{SRD5|gp}} value.
{{5e Footer|Spell}}
{{5e Footer|Spell}}
{{navboxes}}
{{navboxes}}

Latest revision as of 20:26, 29 September 2021

Also see: SRD5:Spell

D&D 5e (2014) Varied ʰ 
See sections for licenses


| Spells A-Z | Spells by Name | Arcane Trickster Spells | Artificer Spells | Bard Spells, Cleric Spells | Druid Spells | Eldritch Knight Spells | Paladin Spells | Ranger Spells | Sorcerer Spells | Warlock Spells | Wizard Spells |

Spells A-Z

545 spells

Error: No field named "Hidden" found for the database table "Pages_Info".
Name Level School Casting
Time
Range Components Casters Source
Notes
Sources

Spells by Name

Abi-Dalzim's Horrid Wilting [1]n
Absorb Elements [1]a
Acid Arrow [2]ev
Acid Splash [2]c
Acid Stream [3]ev
Aganazzar's Schorcher [1]ev
Aid [2]a
Air bubble [4]c
Alarm [2]a, r
Alter Self [2]t
Amauritic Witness [5]ev
Ambient Drift [5]a
Animal Friendship [2]en
Animal Messenger [2]en, r
Animal Shapes [2]t
Animate Dead [2]n
Animate Objects [2]t
Antagonize [6]en
Antilife Shell [2]a
Antimagic Field [2]a
Antipathy/Sympathy [2]en
Arcane Eye [2]d
Arcane Gate [7]c
Arcane Hand [2]ev
Arcane Lock [2]a, $
Arcane Sword [2]ev, $
Arcanist's Magic Aura [2]i
Armor of Agathys [7]a
Arms of Hadar [7]c
Arresting Caress [5]en
Artifice Assistant [8]c
Ashardalon's Stride [9]t
Assassin's Draft [5]t, $
Assess Creature [5]d, $
Astral Projection [2]n, $
Augury [2]d, r, $
Aura of Life [7]a
Aura of Purity [7]a
Aura of Vitality [7]ev
Awaken [2]t, $
Bane [2]en
Banishing Smite [7]a
Banishment [2]a
Barkskin [2]t
Beacon of Hope [2]a
Beast Bond [1]d
Beast Sense [7]d, r
Bestow Curse [2]n
Black Tentacles [2]c
Blade Barrier [2]ev
Blade of Disaster [10]c
Blade Ward [7]a
Bless [2]en
Blight [2]n
Blinding Smite [7]ev
Blindness/Deafness [2]n
Blink [2]t
Blur [2]i
Bones of the Earth [1]t
Booming Blade [11]ev, $
Borrowed Knowledge [12]d, $
Branding Smite [2]ev
Burning Hands [2]ev
Call Lightning [2]c
Calm Emotions [2]en
Catapult [1]t
Catnap [1]en
Cause Fear [1]n
Ceremony [1]a, r, $
Chain Lightning [2]ev
Chaos Bolt [1]ev
Charm Monster [1]en
Charm Person [2]en
Chill Touch [2]n
Chromatic Orb [7]ev
Circle of Death [2]n
Circle of Power [7]a
Clairvoyance [2]d, $
Clone [2]n, $
Cloud of Daggars [7]c
Cloudkill [2]c
Color Spray [2]i
Command [2]en
Commune [2]d, r
Commune with Nature [2]d, r
Compelled Duel [7]en
Comprehend Languages [2]d, r
Compulsion [2]en
Cone of Cold [2]ev
Confusion [2]en
Conjure Animals [2]c
Conjure Barrage [7]c
Conjure Celestial [2]c
Conjure Creature [8]c
Conjure Elemental [2]c
Conjure Minor Elementals [2]c
Conjure Fey [2]c
Conjure Minor Creature [8]c
Conjure Volley [7]c
Conjure Vrock [13]c, $
Conjure Woodland Beings [2]c
Contact Other Plane [2]d, r
Contagion [2]n
Contingency [2]ev, $
Continual Flame [2]ev, $
Control Flames [1]t
Control Water [2]t
Control Weather [2]t
Control Winds [1]t
Cordon of Arrows [7]t
Counterspell [2]a
Create Bonfire [1]c
Create Food and Water [2]c
Create Homunculus [1]t, $
Create Living Spellbook [5]t, $
Create Magen [10]t, $
Create or Destroy Water [2]t
Create Undead [2]n, $
Creation [2]i
Crown of Madness [7]en
Crown of Stars [1]ev
Crusader's Mantle [7]ev
Cure Wounds [2]ev
Mass Cure Wounds [2]ev
Dancing Lights [2]ev
Danse Macabre [1]n
Darkness [2]ev
Darkvision [2]t
Dawn [1]ev, $
Daylight [2]ev
Death Ward [2]a
Demiplane [2]c
Destructive Wave [7]ev
Detect Evil and Good [2]d
Detect Magic [2]d, r
Detect Poison and Disease [2]d, r
Detect Thoughts [2]d
Dimention Door [2]c
Disguse Self [2]i
Disintegrate [2]t
Dispel Evil and Good [2]a
Dispel Magic [2]a
Dissolve [5]ev
Dissonant Whispers [7]en
Divination [2]d, r, $
Divine Word [2]ev
Dominate Beast [2]en
Dominate Monster [2]en
Dominate Person [2]en
Draconic Transformation [9]t, $
Dragon's Breath [1]t
Dream [2]i
Dream of the Blue Veil [11]c
Druid Grove [1]a
Druidcraft [2]t
Dust Devil [1]c
Earth Tremor [1]ev
Earthbind [1]t
Earthquake [2]ev
Eldritch Blast [2]ev
Electrify [5]ev
Elemental Bane [1]t
Elemental Weapon [7]t
Enemies Abound [1]en
Enervation [1]n
Enhance Ability [2]t
Enlarge/Reduce [2]t
Ensnaring Strike [7]c
Entangle [2]c
Enthrall [2]en
Erosive Jet [5]ev, $
Erupting Earth [1]t
Etherealness [2]t
Expeditious Retreat [2]t
Eyebite [2]n
Fabricate [2]t
Faerie Fire [2]ev
Faithful Hound [2]c
False Life [2]n
Far Step [1]c
Father's Embrace [5]ev
Fear [2]i
Feather Fall [2]t
Feeblemind [2]en
Feign Death [7]n, r
Find Familiar [2]c, r, $
Find Greater Steed [1]c
Find Greater Steed [1]c
Find Greater Steed [1]c
Find Steed [2]c
Find the Path [2]d, $
Find Traps [2]d
Finger of Death [2]n
Fire Bolt [2]ev
Fire Shield [2]ev
Fire Storm [2]ev
Fireball [2]ev
Delayed Blast Fireball [2]ev
Fizban's Platinum Shield [9]a, $
Flame Arrows [1]t
Flame Blade [2]ev
Flame Strike [2]ev
Flaming Sphere [2]c
Flesh to Stone [2]t
Floating Disc [2]c, r
Fly [2]t
Fog Cloud [2]c
Forbiddance [2]a, r, $
Forcecage [2]ev, $
Foresight [2]d
Freedom of Movement [2]a
Freezing Sphere [2]ev
Friends [7]en
Frost Fingers [10]ev
Frostbite [1]ev
Gaseous Form [2]t
Gate [2]c, $
Geas [2]en
Gentle Repose [2]n, r, $
Giant Insect [2]t
Glibness [2]t
Globe of Invulnerability [2]a
Glyph of Warding [2]a, $
Goodberry [2]t
Grasping Vine [7]c
Grease [2]c
Green-Flame Blade [11]ev, $
Guardian of Faith [2]c
Guardian of Nature [1]t
Guards and Wards [2]a, $
Guidance [2]d
Guiding Bolt [2]ev
Guiding Hand [14]d, r
Gust [1]t
Gust of Wind [2]ev
Hail of Thorns [7]c
Hallow [2]ev, $
Hallucinatory Terrain [2]i
Hand of Radiance [14]ev
Harm [2]n
Haste [2]t
Heal [2]ev
Mass Heal [2]ev
Healing Elixir [14]c
Healing Spirit [1]c
Healing Word [2]ev
Mass Healing Word [2]ev
Heat Metal [2]t
Hellish Rebuke [2]ev
Heroes' Feast [2]c, $
Heroism [2]en
Hex [7]en
Hideous Laughter [2]en
Hither/Thither [5]t
Hold Monster [2]en
Hold Person [2]en
Holy Aura [2]a, $
Holy Weapon [1]ev
House of Cards [6]c
Hunger of Hadar [7]c
Hunter's Mark [2]d
Hypnotic Pattern [2]i
Ice Knife [1]c
Ice Storm [2]ev
Identify [2]d, r, $
Minor Illusion [2]i
Programmed Illusion [2]i, $
Illusory Dragon [1]i
Illusory Passage [5]i
Illusory Script [2]i, r, $
Major Image [2]i
Immolation [1]ev
Imprisonment [2]a, $
Incendiary Cloud [2]c
Infernal Calling [1]c, $
Infestation [1]c
Inflict Wounds [2]n
Insect Plague [2]c
Instant Summons [2]c, r, $
Intellect Fortress [11]a
Investiture of Fire [1]t
Investiture of Ice [1]t
Investiture of Stone [1]t
Investiture of Wind [1]t
Invisibility [2]i
Greater Invisibility [2]i
Invulnerability [1]a, $
Irresistible Dance [2]en
Jump [2]t
Kinetic Jaunt [12]t
Kiss of Vanti [8]n
Knock [2]t
Legend Lore [2]d, $
Levitate [2]t
Life Transference [1]n
Light [2]ev
Lightning Arrow [7]t
Lightning Bolt [2]ev
Lightning Lure [11]ev, $
Locate Animals or Plants [2]d, r
Locate Creature [2]d
Locate Object [2]d
Longstrider [2]t
Maddening Darkness [1]ev
Maelstrom [1]ev
Mage Armor [2]a
Mass Mage Armor [8]a
Mage Hand [2]c
Magic Circle [2]a, $
Magic Jar [2]n, $
Magic Missile [2]ev
Magic Mouth [2]i, r, $
Magic Stone [1]t
Magic Weapon [2]t
Magnificent Mansion [2]c, $
Maximilian's Earthen Grasp [1]t
Maze [2]c
Meld into Stone [2]t, r
Melf's Minute Meteors [1]ev
Mending [2]t
Menatal Prison [1]i
Message [2]t
Meteor Swarm [2]ev
Mighty Fortress [1]c, $
Mind Blank [2]a
Mind Sliver [11]en
Mind Spike [1]d
Mind Thrust [15]en
Mingling Guile [5]i, $
Mirage Arcane [2]i
Mire Fly [5]c
Mirror Image [2]i
Mislead [2]i
Misty Step [2]c
Modify Memory [2]en
Mold Earth [1]t
Moonbeam [2]ev
Move Earth [2]t
Nathair's Mischief [9]i
Negative Energy Flood [1]n
Nondetection [2]a, $
Oleander's Kiss [5]ev
Otherworldly Form [3]t, $
Pass without Trace [2]a
Passwall [2]t
Phantasmal Force [7]i
Phantasmal Killer [2]i
Phantom Steed [2]i, r
Planar Ally [2]c
Planar Binding [2]a, $
Plane Shift [2]c, $
Plant Growth [2]t
Poison Spray [2]c
Polymorph [2]t
Mass Polymorph [1]t
True Polymorph [2]t
Power Word Heal [7]ev
Power Word Kill [2]en
Power Word Pain [1]en
Power Word Stun [2]en
Prayer of Healing [2]ev
Prestidigitation [2]t
Presumed Affliction [5]i, $
Primal Savagery [1]t
Primordial Ward [1]a
Primordial Ward [1]a
Prismatic Spary [2]ev
Prismatic Wall [2]a
Private Sanctum [2]a
Produce Flame [2]c
Project Image [2]i, $
Protection from Energy [2]a
Protection from Evil and Good [2]a
Protection from Poison [2]a
Psychic Scream [1]en
Puppet [14]en
Purify Food and Drink [2]t, r
Pyrotechnics [1]t
Raise Dead [2]n, $
Raulothim's Psychic Lance [9]en
Ray of Enfeeblement [2]n
Ray of Frost [2]ev
Ray of Sickness [7]n
Recast Form [5]t, $
Regenerate [2]t
Reincarnate [2]t, $
Remove Curse [2]a
Resilient Sphere [2]ev
Resistance [2]a
Greater Restoration [2]a, $
Lesser restoration [2]a
Resurrection [2]n, $
True Resurrection [2]n, $
Reverse Gravity [2]t
Revivify [2]n, $
Rime's Binding Ice [9]ev
Rope Trick [2]t
Sacred Flame [2]ev
Sanctuary [2]a
Sanguine Forge [5]t
Scald [5]ev
Scatter [1]c
Scorching Ray [2]ev
Scrying [2]d, $
Searing Smite [7]ev
Secret Chest [2]c, $
See Invisibility [2]d
Seeming [2]i
Sending [2]ev
Sense Emotion [14]d
Sequester [2]t, $
Shadow Blade [1]i
Shadow of Moil [1]n, $
Shadow [8]t
Shape Water [16]t
Shapechange [2]t, $
Shatter [2]ev
Shield of Faith [2]a
Shield [2]a
Shillelagh [2]t
Shocking Grasp [2]ev
Sickening Radiance [1]ev
Silence [2]i, r
Silent Image [2]i
Silvery Barbs [12]en
Simulacrum [2]i, $
Skill Empowerment [1]t
Skywrite [1]t, r
Sleep [2]en
Sleet Storm [2]c
Slow [2]t
Snare [1]a
Snilloc's Snowball Swarm [1]ev
Snilloc's Snowball Swarm [16]ev
Soul Cage [1]n
Sovereign's Leash [5]en, $
Spare the Dying [2]n
Speak with Animals [2]d, r
Speak with Dead [2]n
Speak with Plants [2]t
Spider Climb [2]t
Spike Growth [2]t
Spirit Guardians [2]c
Spirit of Death [6]n, $
Spirit Shroud [11]n
Spiritual Weapon [2]ev
Spray of Cards [6]c
Staggering Smite [7]ev
Steel Wind Strike [1]c, $
Stinking Cloud [2]c
Stone Shape [2]t
Stoneskin [2]a, $
Storm of Vengeance [2]c
Storm Sphere [1]ev
Stubborn Roots [5]c
Sudden Awakening [14]en
Suggestion [2]en
Mass Suggestion [2]en
Summon Aberration [11]c, $
Summon Beast [11]c, $
Summon Celestial [11]c, $
Summon Construct [11]c, $
Summon Draconic Spirit [9]c, $
Summon Elemental [11]c, $
Summon Fey [11]c, $
Summon Fiend [11]c, $
Summon Greater Demon [1]c
Summon Lesser Demons [1]c
Summon Undead [11]n, $
Summon Warrior Spirit [6]c, $
Sunbeam [2]ev
Sunburst [2]ev
Swift Quiver [7]t
Sword Burst [17]c
Sword Burst [11]c
Symbol [2]a, $
Synaptic Static [1]en
Tasha's Caustic Brew [11]ev
Tasha's Mind Whip [11]en
Tasha's Otherworldly Guise [11]t
Telekinesis [2]t
Telepathic Bond [2]d, r
Telepathy [7]ev
Teleport [2]c
Teleportation Circle [2]c, $
Temple of the Gods [1]c, $
Tenser's Transformation [1]t
Thaumaturgy [2]t
Thorn Whip [7]t
Thunder Step [16]c
Thunderburst [5]ev
Thunderclap [18]ev
Thunderous Smite [7]ev
Thunderwave [2]ev
Tidal Wave [1]c
Time Stop [2]t
Tiny Hut [2]ev, r
Tiny Servant [1]t
Toll the Dead [1]n
Tongues [2]d
Transmute Rock [1]t
Transport via Plants [2]c
Tree Stride [2]c
True Seeing [2]d, $
True Strike [2]d
Tsunami [7]c
Unearthly Chorus [14]i
Unseen Servant [2]c, r
Vampiric Touch [2]n
Vicious Mockery [2]en
Viperous Volley [5]c
Virtue [14]a
Vitriolic Sphere [1]ev
Vortex Warp [12]c
Wall of Fire [2]ev
Wall of Force [2]ev
Wall of Ice [2]ev
Wall of Light [1]ev
Wall of Sand [17]ev
Wall of Sand [1]ev
Wall of Stone [2]ev
Wall of Thorns [2]c
Wall of Water [1]ev
Warding Bond [2]a, $
Warding Wind [1]ev
Water Breathing [2]t, r
Water Walk [2]t, r
Watery Sphere [1]c
Web [2]c
Weird [2]i
Whirlwind [1]ev
Wild Cunning [14]t, r
Wind Walk [2]t
Wind Wall [2]ev
Wish [2]c
Witch Bolt [7]ev
Wither and Bloom [12]n
Wither and Bloom [12]n
Wither and Bloom [12]n
Word of Radiance [1]ev
Word of Recall [2]c
Wrath of Nature [1]ev
Wrathful Smite [7]ev
Zephyr Strike [1]t
Zone of Truth [2]en

Arcane Trickster Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE (((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Arcane Trickster') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Arcane Trickster subclass.

Cantrip
0 Level
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE (((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Wizard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Artificer Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Artificer subclass.

Cantrips
(0 Level)
1st Level 2nd Level 3rd Level 4th Level 5th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Bard Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Bard class.

Cantrips
(0 Level)
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

5th Level 6th Level 7th Level 8th Level 9th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Cleric Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Cleric subclass.

Cantrips
(0 Level)
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

5th Level 6th Level 7th Level 8th Level 9th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Druid Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Druid subclass.

Cantrips
(0 Level)
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

5th Level 6th Level 7th Level 8th Level 9th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Druid') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Eldritch Knight Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Eldritch Knight') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Eldritch Knight subclass.

Cantrip
0 Level
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Eldritch Knight') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Eldritch Knight') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Eldritch Knight') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Eldritch Knight') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Eldritch Knight') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Paladin Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Paladin') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Paladin subclass.

1st Level 2nd Level 3rd Level 4th Level 5th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Paladin') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Paladin') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Paladin') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Paladin') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Paladin') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Ranger Spells

74 spells for the Ranger subclass.

1st Level 2nd Level 3rd Level 4th Level 5th Level

Absorb Elements [1]
Alarm [2]
Animal Friendship [2]
Beast Bond [1]
Cure Wounds [2]
Detect Magic [2]
Detect Poison and Disease [2]
Ensnaring Strike [7]
Entangle [2]
Fog Cloud [2]
Goodberry [2]
Hail of Thorns [7]
Hunter's Mark [2]
Jump [2]
Longstrider [2]
Searing Smite [7]
Snare [1]
Speak with Animals [2]
Sudden Awakening [14]
Wild Cunning [14]
Zephyr Strike [1]

Aid [2]
Air bubble [4]
Animal Messenger [2]
Barkskin [2]
Beast Sense [7]
Cordon of Arrows [7]
Darkvision [2]
Enhance Ability [2]
Find Traps [2]
Gust of Wind [2]
Healing Spirit [1]
Locate Animals or Plants [2]
Locate Object [2]
Magic Weapon [2]
Pass without Trace [2]
Protection from Poison [2]
Silence [2]
Spike Growth [2]
Summon Beast [11]


Ashardalon's Stride [9]
Conjure Animals [2]
Conjure Barrage [7]
Daylight [2]
Elemental Weapon [7]
Flame Arrows [1]
Lightning Arrow [7]
Meld into Stone [2]
Nondetection [2]
Plant Growth [2]
Protection from Energy [2]
Revivify [2]
Speak with Plants [2]
Summon Fey [11]
Water Breathing [2]
Water Walk [2]
Wind Wall [2]


Conjure Woodland Beings [2]
Dominate Beast [2]
Freedom of Movement [2]
Grasping Vine [7]
Guardian of Nature [1]
Locate Creature [2]
Stoneskin [2]
Summon Elemental [11]


Commune with Nature [2]
Conjure Volley [7]
Dispel Evil and Good [2]
Greater Restoration [2]
Steel Wind Strike [1]
Swift Quiver [7]
Tree Stride [2]
Wrath of Nature [1]


Sorcerer Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Sorcerer subclass.

Cantrips
(0 Level)
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

5th Level 6th Level 7th Level 8th Level 9th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Sorcerer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Warlock Spells

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Warlock subclass.

Cantrip
0 Level
1st Level 2nd Level 3rd Level 4th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

5th Level 6th Level 7th Level 8th Level 9th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100


Wizard Spells

365 spells for the Wizard subclass.

Cantrip
0 Level
1st Level 2nd Level 3rd Level 4th Level

Acid Splash [2]
Blade Ward [7]
Booming Blade [11]
Chill Touch [2]
Control Flames [1]
Create Bonfire [1]
Dancing Lights [2]
Fire Bolt [2]
Friends [7]
Frostbite [1]
Green-Flame Blade [11]
Gust [1]
Minor Illusion [2]
Infestation [1]
Kiss of Vanti [8]
Light [2]
Lightning Lure [11]
Mage Hand [2]
Mending [2]
Message [2]
Mind Sliver [11]
Mold Earth [1]
Poison Spray [2]
Prestidigitation [2]
Ray of Frost [2]
Sanguine Forge [5]
Shadow [8]
Shape Water [16]
Shocking Grasp [2]
Sword Burst [11]
Sword Burst [17]
Thunderclap [18]
Toll the Dead [1]
True Strike [2]


Absorb Elements [1]
Acid Stream [3]
Alarm [2]
Assess Creature [5]
Burning Hands [2]
Catapult [1]
Cause Fear [1]
Charm Person [2]
Chromatic Orb [7]
Color Spray [2]
Comprehend Languages [2]
Detect Magic [2]
Disguse Self [2]
Expeditious Retreat [2]
False Life [2]
Feather Fall [2]
Find Familiar [2]
Floating Disc [2]
Fog Cloud [2]
Frost Fingers [10]
Grease [2]
Guiding Hand [14]
Healing Elixir [14]
Hideous Laughter [2]
Ice Knife [1]
Id Insinuation [15]
Identify [2]
Illusory Script [2]
Jump [2]
Longstrider [2]
Mage Armor [2]
Magic Missile [2]
Presumed Affliction [5]
Protection from Evil and Good [2]
Puppet [14]
Ray of Sickness [7]
Scald [5]
Sense Emotion [14]
Shield [2]
Silent Image [2]
Silvery Barbs [12]
Sleep [2]
Snare [1]
Sudden Awakening [14]
Tasha's Caustic Brew [11]
Thunderwave [2]
Unseen Servant [2]
Witch Bolt [7]

Acid Arrow [2]
Aganazzar's Schorcher [1]
Air bubble [4]
Alter Self [2]
Arcane Lock [2]
Arcanist's Magic Aura [2]
Augury [2]
Blur [2]
Borrowed Knowledge [12]
Cloud of Daggars [7]
Continual Flame [2]
Crown of Madness [7]
Darkness [2]
Darkvision [2]
Detect Thoughts [2]
Dragon's Breath [1]
Dust Devil [1]
Earthbind [1]
Enhance Ability [2]
Enlarge/Reduce [2]
Flaming Sphere [2]
Gentle Repose [2]
Gust of Wind [2]
Hold Person [2]
Illusory Passage [5]
Invisibility [2]
Kinetic Jaunt [12]
Knock [2]
Levitate [2]
Locate Object [2]
Magic Mouth [2]
Magic Weapon [2]
Maximilian's Earthen Grasp [1]
Mental Barrier [15]
Mind Spike [1]
Mind Thrust [15]
Mirror Image [2]
Misty Step [2]
Nathair's Mischief [9]
Phantasmal Force [7]
Pyrotechnics [1]
Ray of Enfeeblement [2]
Rime's Binding Ice [9]
Rope Trick [2]
Scorching Ray [2]
See Invisibility [2]
Shadow Blade [1]
Shatter [2]
Skywrite [1]
Snilloc's Snowball Swarm [1]
Snilloc's Snowball Swarm [16]
Spider Climb [2]
Spray of Cards [6]
Suggestion [2]
Tasha's Mind Whip [11]
Thought Shield [15]
Vortex Warp [12]
Warding Wind [1]
Web [2]
Wither and Bloom [12]
Wither and Bloom [12]
Wither and Bloom [12]

Animate Dead [2]
Antagonize [6]
Ashardalon's Stride [9]
Bestow Curse [2]
Blink [2]
Catnap [1]
Clairvoyance [2]
Counterspell [2]
Dispel Magic [2]
Enemies Abound [1]
Erupting Earth [1]
Fear [2]
Feign Death [7]
Fireball [2]
Flame Arrows [1]
Fly [2]
Gaseous Form [2]
Glyph of Warding [2]
Haste [2]
House of Cards [6]
Hypnotic Pattern [2]
Major Image [2]
Intellect Fortress [11]
Life Transference [1]
Lightning Bolt [2]
Mass Mage Armor [8]
Magic Circle [2]
Melf's Minute Meteors [1]
Nondetection [2]
Phantom Steed [2]
Protection from Energy [2]
Psionic Blast [15]
Sending [2]
Sleet Storm [2]
Slow [2]
Speak with Dead [2]
Spirit Shroud [11]
Stinking Cloud [2]
Summon Fey [11]
Summon Lesser Demons [1]
Summon Undead [11]
Summon Warrior Spirit [6]
Thunder Step [16]
Tidal Wave [1]
Tiny Hut [2]
Tiny Servant [1]
Tongues [2]
Vampiric Touch [2]
Wall of Sand [1]
Wall of Water [1]
Water Breathing [2]

Arcane Eye [2]
Banishment [2]
Black Tentacles [2]
Blight [2]
Charm Monster [1]
Confusion [2]
Conjure Minor Elementals [2]
Conjure Shadow Demon [13]
Control Water [2]
Dimention Door [2]
Dissolve [5]
Divination [2]
Ego Whip [15]
Elemental Bane [1]
Fabricate [2]
Faithful Hound [2]
Fire Shield [2]
Hallucinatory Terrain [2]
Ice Storm [2]
Greater Invisibility [2]
Locate Creature [2]
Phantasmal Killer [2]
Polymorph [2]
Private Sanctum [2]
Raulothim's Psychic Lance [9]
Recast Form [5]
Resilient Sphere [2]
Secret Chest [2]
Sickening Radiance [1]
Spirit of Death [6]
Stone Shape [2]
Stoneskin [2]
Storm Sphere [1]
Summon Aberration [11]
Summon Construct [11]
Summon Elemental [11]
Vitriolic Sphere [1]
Wall of Fire [2]
Watery Sphere [1]

5th Level 6th Level 7th Level 8th Level 9th Level

Animate Objects [2]
Arcane Hand [2]
Cloudkill [2]
Cone of Cold [2]
Conjure Elemental [2]
Conjure Vrock [13]
Contact Other Plane [2]
Control Winds [1]
Create Living Spellbook [5]
Creation [2]
Danse Macabre [1]
Dawn [1]
Dominate Person [2]
Dream [2]
Earth Tremor [1]
Enervation [1]
Far Step [1]
Geas [2]
Hold Monster [2]
Immolation [1]
Infernal Calling [1]
Legend Lore [2]
Mislead [2]
Modify Memory [2]
Negative Energy Flood [1]
Passwall [2]
Planar Binding [2]
Scrying [2]
Seeming [2]
Skill Empowerment [1]
Steel Wind Strike [1]
Summon Draconic Spirit [9]
Synaptic Static [1]
Telekinesis [2]
Telepathic Bond [2]
Teleportation Circle [2]
Transmute Rock [1]
Wall of Force [2]
Wall of Light [1]
Wall of Stone [2]

Arcane Gate [7]
Chain Lightning [2]
Circle of Death [2]
Contingency [2]
Create Homunculus [1]
Create Undead [2]
Disintegrate [2]
Eyebite [2]
Fizban's Platinum Shield [9]
Flesh to Stone [2]
Freezing Sphere [2]
Globe of Invulnerability [2]
Guards and Wards [2]
Programmed Illusion [2]
Instant Summons [2]
Investiture of Fire [1]
Investiture of Ice [1]
Investiture of Stone [1]
Investiture of Wind [1]
Irresistible Dance [2]
Magic Jar [2]
Menatal Prison [1]
Move Earth [2]
Otherworldly Form [3]
Psychic Crush [15]
Scatter [1]
Soul Cage [1]
Mass Suggestion [2]
Summon Fiend [11]
Sunbeam [2]
Tasha's Otherworldly Guise [11]
Tenser's Transformation [1]
Thunderburst [5]
True Seeing [2]
Wall of Ice [2]

Arcane Sword [2]
Conjure Hezrou [13]
Create Magen [10]
Crown of Stars [1]
Draconic Transformation [9]
Dream of the Blue Veil [11]
Etherealness [2]
Father's Embrace [5]
Finger of Death [2]
Delayed Blast Fireball [2]
Forcecage [2]
Magnificent Mansion [2]
Mirage Arcane [2]
Plane Shift [2]
Power Word Pain [1]
Prismatic Spary [2]
Project Image [2]
Reverse Gravity [2]
Sequester [2]
Simulacrum [2]
Symbol [2]
Teleport [2]
Whirlwind [1]

Abi-Dalzim's Horrid Wilting [1]
Antimagic Field [2]
Antipathy/Sympathy [2]
Clone [2]
Control Weather [2]
Demiplane [2]
Dominate Monster [2]
Feeblemind [2]
Illusory Dragon [1]
Incendiary Cloud [2]
Maddening Darkness [1]
Maze [2]
Mighty Fortress [1]
Mind Blank [2]
Power Word Stun [2]
Sunburst [2]
Telepathy [7]

Astral Projection [2]
Blade of Disaster [10]
Foresight [2]
Gate [2]
Imprisonment [2]
Invulnerability [1]
Meteor Swarm [2]
Mass Polymorph [1]
True Polymorph [2]
Power Word Kill [2]
Prismatic Wall [2]
Psychic Scream [1]
Shapechange [2]
Time Stop [2]
Weird [2]
Wish [2]


Sources and Notes

  1. Mike Mearls, et. al.. Xanathar's Guide to Everything (5e 2014) (November 2017). Wizards of the Coast. 1.000 1.001 1.002 1.003 1.004 1.005 1.006 1.007 1.008 1.009 1.010 1.011 1.012 1.013 1.014 1.015 1.016 1.017 1.018 1.019 1.020 1.021 1.022 1.023 1.024 1.025 1.026 1.027 1.028 1.029 1.030 1.031 1.032 1.033 1.034 1.035 1.036 1.037 1.038 1.039 1.040 1.041 1.042 1.043 1.044 1.045 1.046 1.047 1.048 1.049 1.050 1.051 1.052 1.053 1.054 1.055 1.056 1.057 1.058 1.059 1.060 1.061 1.062 1.063 1.064 1.065 1.066 1.067 1.068 1.069 1.070 1.071 1.072 1.073 1.074 1.075 1.076 1.077 1.078 1.079 1.080 1.081 1.082 1.083 1.084 1.085 1.086 1.087 1.088 1.089 1.090 1.091 1.092 1.093 1.094 1.095 1.096 1.097 1.098 1.099 1.100 1.101 1.102 1.103 1.104 1.105 1.106 1.107 1.108 1.109 1.110 1.111 1.112 1.113 1.114 1.115 1.116 1.117 1.118 1.119 1.120 1.121 1.122 1.123 1.124 1.125 1.126 1.127 1.128 1.129 1.130 1.131 1.132 1.133 1.134 1.135 1.136 1.137 1.138 1.139 1.140 1.141 1.142 1.143 1.144 1.145 1.146 1.147 1.148 1.149 1.150 1.151 1.152 1.153 1.154 1.155 1.156 1.157 1.158 1.159 1.160 1.161 1.162 1.163 1.164 1.165 1.166 1.167 1.168 1.169 1.170 1.171 1.172 1.173 1.174 1.175 1.176
  2. Wizards RPG Team. SRD-OGL v5.1 (5e 2014) (2015.05.06). Wizards of the Coast. 2.000 2.001 2.002 2.003 2.004 2.005 2.006 2.007 2.008 2.009 2.010 2.011 2.012 2.013 2.014 2.015 2.016 2.017 2.018 2.019 2.020 2.021 2.022 2.023 2.024 2.025 2.026 2.027 2.028 2.029 2.030 2.031 2.032 2.033 2.034 2.035 2.036 2.037 2.038 2.039 2.040 2.041 2.042 2.043 2.044 2.045 2.046 2.047 2.048 2.049 2.050 2.051 2.052 2.053 2.054 2.055 2.056 2.057 2.058 2.059 2.060 2.061 2.062 2.063 2.064 2.065 2.066 2.067 2.068 2.069 2.070 2.071 2.072 2.073 2.074 2.075 2.076 2.077 2.078 2.079 2.080 2.081 2.082 2.083 2.084 2.085 2.086 2.087 2.088 2.089 2.090 2.091 2.092 2.093 2.094 2.095 2.096 2.097 2.098 2.099 2.100 2.101 2.102 2.103 2.104 2.105 2.106 2.107 2.108 2.109 2.110 2.111 2.112 2.113 2.114 2.115 2.116 2.117 2.118 2.119 2.120 2.121 2.122 2.123 2.124 2.125 2.126 2.127 2.128 2.129 2.130 2.131 2.132 2.133 2.134 2.135 2.136 2.137 2.138 2.139 2.140 2.141 2.142 2.143 2.144 2.145 2.146 2.147 2.148 2.149 2.150 2.151 2.152 2.153 2.154 2.155 2.156 2.157 2.158 2.159 2.160 2.161 2.162 2.163 2.164 2.165 2.166 2.167 2.168 2.169 2.170 2.171 2.172 2.173 2.174 2.175 2.176 2.177 2.178 2.179 2.180 2.181 2.182 2.183 2.184 2.185 2.186 2.187 2.188 2.189 2.190 2.191 2.192 2.193 2.194 2.195 2.196 2.197 2.198 2.199 2.200 2.201 2.202 2.203 2.204 2.205 2.206 2.207 2.208 2.209 2.210 2.211 2.212 2.213 2.214 2.215 2.216 2.217 2.218 2.219 2.220 2.221 2.222 2.223 2.224 2.225 2.226 2.227 2.228 2.229 2.230 2.231 2.232 2.233 2.234 2.235 2.236 2.237 2.238 2.239 2.240 2.241 2.242 2.243 2.244 2.245 2.246 2.247 2.248 2.249 2.250 2.251 2.252 2.253 2.254 2.255 2.256 2.257 2.258 2.259 2.260 2.261 2.262 2.263 2.264 2.265 2.266 2.267 2.268 2.269 2.270 2.271 2.272 2.273 2.274 2.275 2.276 2.277 2.278 2.279 2.280 2.281 2.282 2.283 2.284 2.285 2.286 2.287 2.288 2.289 2.290 2.291 2.292 2.293 2.294 2.295 2.296 2.297 2.298 2.299 2.300 2.301 2.302 2.303 2.304 2.305 2.306 2.307 2.308 2.309 2.310 2.311 2.312 2.313 2.314 2.315 2.316 2.317 2.318 2.319 2.320 2.321 2.322 2.323 2.324 2.325 2.326 2.327 2.328 2.329 2.330 2.331 2.332 2.333 2.334 2.335 2.336 2.337 2.338 2.339 2.340 2.341 2.342 2.343 2.344 2.345 2.346 2.347 2.348 2.349 2.350 2.351 2.352 2.353 2.354 2.355 2.356 2.357 2.358 2.359 2.360 2.361 2.362 2.363 2.364 2.365 2.366 2.367 2.368 2.369 2.370 2.371 2.372 2.373 2.374 2.375 2.376 2.377 2.378 2.379 2.380 2.381 2.382 2.383 2.384 2.385 2.386 2.387 2.388 2.389 2.390 2.391 2.392 2.393 2.394 2.395 2.396 2.397 2.398 2.399 2.400 2.401 2.402 2.403 2.404 2.405 2.406 2.407 2.408 2.409 2.410 2.411 2.412 2.413 2.414 2.415 2.416 2.417 2.418 2.419 2.420 2.421 2.422 2.423 2.424 2.425 2.426 2.427 2.428 2.429 2.430 2.431 2.432 2.433 2.434 2.435 2.436 2.437 2.438 2.439 2.440 2.441 2.442 2.443 2.444 2.445 2.446 2.447 2.448 2.449 2.450 2.451 2.452 2.453 2.454 2.455 2.456 2.457 2.458 2.459 2.460 2.461 2.462 2.463 2.464 2.465 2.466 2.467 2.468 2.469 2.470 2.471 2.472 2.473 2.474 2.475 2.476 2.477 2.478 2.479 2.480 2.481 2.482 2.483 2.484 2.485 2.486 2.487 2.488 2.489 2.490 2.491 2.492 2.493 2.494 2.495 2.496 2.497 2.498 2.499 2.500 2.501 2.502 2.503 2.504 2.505 2.506 2.507 2.508 2.509 2.510 2.511 2.512 2.513 2.514 2.515 2.516 2.517 2.518 2.519 2.520 2.521 2.522 2.523 2.524 2.525 2.526 2.527 2.528 2.529 2.530 2.531 2.532 2.533 2.534 2.535 2.536 2.537 2.538 2.539 2.540 2.541 2.542 2.543 2.544 2.545 2.546 2.547 2.548 2.549 2.550 2.551 2.552 2.553 2.554 2.555 2.556 2.557 2.558 2.559 2.560 2.561 2.562 2.563 2.564 2.565 2.566 2.567 2.568 2.569
  3. Ben Petrisor, et. al.. UA 2020 Spells and Magic Tattoos (5e 2014) (2020-03-26). Wizards of the Coast. 3.0 3.1 3.2 3.3
  4. Christopher Perkins, et. al.. Astral Adventurer's Guide (5e 2014) (2022-08-16). Wizards of the Coast. ISBN 978-0786968220. 4.0 4.1 4.2
  5. Celeste Conowitch, et. al.. Venture Maidens Campaign Guide (5e 2014) (2022-06-07 (Community Edition)). Venture Maidens LLC, 2CGaming. 5.00 5.01 5.02 5.03 5.04 5.05 5.06 5.07 5.08 5.09 5.10 5.11 5.12 5.13 5.14 5.15 5.16 5.17 5.18 5.19 5.20 5.21 5.22 5.23 5.24 5.25 5.26 5.27 5.28 5.29 5.30 5.31 5.32
  6. Makenzie De Armas, et. al.. UA 2022 Wonders of the Multiverse (5e 2014) (2022-07-18). Wizards of the Coast. 6.0 6.1 6.2 6.3 6.4 6.5 6.6 6.7 6.8 6.9
  7. Wizards RPG Team. Player's Handbook (5e) (5e 2014) (2014-08-19). Wizards of the Coast. ISBN 9780786965601. 7.00 7.01 7.02 7.03 7.04 7.05 7.06 7.07 7.08 7.09 7.10 7.11 7.12 7.13 7.14 7.15 7.16 7.17 7.18 7.19 7.20 7.21 7.22 7.23 7.24 7.25 7.26 7.27 7.28 7.29 7.30 7.31 7.32 7.33 7.34 7.35 7.36 7.37 7.38 7.39 7.40 7.41 7.42 7.43 7.44 7.45 7.46 7.47 7.48 7.49 7.50 7.51 7.52 7.53 7.54 7.55 7.56 7.57 7.58 7.59 7.60 7.61 7.62 7.63
  8. Rlyehable 8.0 8.1 8.2 8.3 8.4 8.5 8.6 8.7 8.8
  9. James Wyatt, et. al.. Fizban's Treasury of Dragons (5e 2014) (2021-10-26). Wizards of the Coast. ISBN 978-0-7869-6730-8. 9.00 9.01 9.02 9.03 9.04 9.05 9.06 9.07 9.08 9.09 9.10 9.11 9.12 9.13 9.14
  10. Christopher Perkins, et. al.. Icewind Dale Rime of the Frostmaiden (5e 2014) (2020-09-15). Wizards of the Coast. ISBN 978-0786966981. 10.0 10.1 10.2 10.3 10.4 10.5
  11. Jeremy Crawford, et. al.. Tasha's Cauldron of Everything (5e 2014) (2020-11-17). Wizards of the Coast. ISBN 9780786967025. 11.00 11.01 11.02 11.03 11.04 11.05 11.06 11.07 11.08 11.09 11.10 11.11 11.12 11.13 11.14 11.15 11.16 11.17 11.18 11.19 11.20 11.21 11.22 11.23 11.24 11.25 11.26 11.27 11.28 11.29 11.30 11.31 11.32 11.33 11.34 11.35 11.36 11.37 11.38
  12. Amanda Hamon, et. al.. Strixhaven (5e 2014) (2021-11). Wizards of the Coast. ISBN 978-0-7869-6744-5. 12.00 12.01 12.02 12.03 12.04 12.05 12.06 12.07 12.08 12.09 12.10 12.11 12.12 12.13
  13. Mike Mearls. UA That Old Black Magic (5e 2014) (2015.12.07). Wizards of the Coast. 13.0 13.1 13.2 13.3
  14. Wizards RPG Team. UA Starter Spells (5e 2014) (2017.04.03). Wizards of the Coast. 14.00 14.01 14.02 14.03 14.04 14.05 14.06 14.07 14.08 14.09 14.10 14.11 14.12 14.13 14.14 14.15
  15. Jeremy Crawford, et. al.. UA Fighter, Rogue, and Wizard (5e 2014) (2019-11-25). Wizards of the Coast. 15.0 15.1 15.2 15.3 15.4 15.5 15.6 15.7
  16. Varied, XGtE, PotA 16.0 16.1 16.2 16.3 16.4 16.5
  17. 17.0 17.1 17.2
  18. Varied, XGtE, PotA, WGtE 18.0 18.1

Spell Notation

a  Abjuration
c  Conjuration
d  Divination
en Enchantment
ev Evocation
i  Illusion
n  Necromancy
t  Transmutation
r  These spells may be cast as rituals.
$  These spells have a material component that has a gp value.

Back to Main PageDnD5x5e (2014)Spell

Varied Contrigubtions +

684 articles
2e 5e, 5e 5e, Aarakocra 5e, Aasimar 5e, Abbathor, Aberration, Abishai, Abyss 5e, Academy of Devastation, Acid Arrow One, Adamantine 5e, Adult Bronze Dragon 5e, Adventure 5e, Aerdrie Faenya, Air Elemental 5e, Air Elemental Myrmidon, Alarm One, Alchemy Jug, Alhoon 5e, Alkilith, Allip, Alter Self One, Amethyst Dragon 5e, Amnizu, Amphisbaena, Angel, Angharradh, Angry Sorrowsworn, Animal Friendship One, Animate Objects One, Annis Hag, Antilife Shell One, Ape 5e, Apprentice Wizard NPC, Arcane Trickster/Spell List 5e, Archer NPC, Archon 5e, Archon Mount 5e, Armanite, Armor 5e, Artificer/Spell List 5e, Arvoreen, Astral Dreadnought, Astral Plane 5e, Atomie, Aubreck Drallion 5e, Aura of Vitality, Aurochs, Aurumvorax Baby 5e, Autumn Eladrin, Babau, Bael, Baervan Wildwanderer, Bahamut, Bahgtru, Balhannoth, Banderhobb, Banishment, Baphomet 5e, Baravar Cloakshadow, Barbarian, Bard, Bard NPC 5e, Bard NPC VGtM, Bard/Spell List 5e, Barghest, Barret Gloffrin 5e, Bat, Bear, Bear 5e, Beast, Beast List 5e, Beatrice 5e, Beholder 5e, Bellis Belweather 5e, Berbalang, Berronar Truesilver, Bheur Hag, Birsk Chumwell 5e, Biscuit 5e, Bitzi 5e, Black Abishai, Black Dragon 5e, Black Guard Drake, Blackguard NPC, Blight Spell One, Blindness/Deafness One, Blink One, Bloodybeak 5e, Blue Abishai, Blue Dragon 5e, Blue Guard Drake, Blur One, Bobi 5e, Bodak, Bodger 5e, Boggart, Boggle, Boneclaw, Bramble, Brandobaris, Brass Dragon 5e, Brontosaurus, Brownie, Buckawn, Bugbear 5e, Bullywug 5e, Bullywug Royal, Bunnyoid, Burly 5e, Call Lightning One, Callarduran Smoothhands, Callybon 5e, Campaign Setting 5e, Canoloth, Cap of Water Breathing, Carisso 5e, Cat, Cave Bear 5e, Cave Cricket, Cave Fisher, Cave Moray, Celestial 5e, Centaur Race, Cerberus 5e, Champion, Champion NPC, Changeling, Charm Monster, Chimera 5e, Chitine, Choker, Choldrith, Chucklehead, Circle of the Moon/Beast Shape 5e, Clangeddin Silverbeard, Class 5e, Cleric/Spell List 5e, Clurichaun, College of Lore, Copper Dragon 5e, Corellon Larethian, Corpse Flower, Cradlefall 5e, Cranium Rat, Creature 5e, Creature List, Crown of Stars, Crusader's Mantle, Crystal Dragon, Cult 5e, Cult of the Dragon, Cults of Elemental Evil, Cults of the Dragon Below, Cyrrollalee, Dance Macabre, Dandy 5e, Darkling, Darkling Elder, Davus Raal 5e, Dawn, Death Kiss, Death Ward One, Deathlock, Deathlock Wight, Deep Duerra, Deep Gnome Subrace, Deep Lacedon 5e, Deep Rothé, Deep Sashelas 5e, Deep Scion, Deinonychus, Deity 5e, Demogorgon, Demon 5e, Dendar 5e, Derro 5e, Derro MToF, Detect Magic One, Devil, Devourer, Diety 5e, Dimetrodon, Dinosaur 5e, Dobie, Dog 5e, Dolphin, Dolphin Common, Door 5e, Draconic Transformation, Draegloth, Dragon Pantheon, Dragon's Breath, Dragonborn 5e, Dragonlance 5e, Dragonnel, Drake 5e, Drider, Drizlash Ghast, Drow 5e, Drow Arachnomancer, Drow Favored Consort, Drow House Captain, Drow Inquisitor, Drow Matron Mother, Drow Shadowblade, Druid, Druid Grove, Druid/Beast Shape 5e, Druid/Spell List 5e, Dryad 5e, Duergar 5e, Duergar Despot, Duergar Hammerer, Duergar Kavalrachni, Duergar Mind Master, Duergar Pantheon, Duergar Soulblade MToF, Duergar Warlord, Duergar Xarrorn, Dugmaren Brightmantle, Dumathoin, Dungus 5e, Dust Devil Spell, Dwarf 5e, Dwarf Common 5e, Dwarf Lineage 5e, Dwarven Pantheon, Dybbuk, Earth Elemental 5e, Earth Elemental Myrmidon, Earth Tremor, Earthbind, Eberron, Eberron Pantheon, Eidolon, Eidolon Common, Eladrin 5e, Elanys 5e, Elder Brain, Elder Tempest, Eldritch Invocation List 5e, Eleanor Lovage 5e, Eleanor Loveage 5e, Elemental 5e, Elf 5e, Elidon 5e, Elmo the Emaciated 5e, Elven Pantheon, Emerald Dragon, Equipment Pack 5e, Fairy, Far Realm 5e, Feldrin Kane 5e, Female Steeder, Fenmarel Mestarine 5e, Fey 5e, Fey Kelpie, Feystag, Feywild 5e, Fiend 5e, Fighter, Fighter 5e, Fighting Style 5e, Fire Elemental 5e, Fire Elemental Myrmidon, Fire Giant Dreadnought, Firenewt, Flail Snail, Flandal Steelskin, Flind, Forcecage One, Forest Gnome, Forgotten Realms 5e, Fossergrim, Fraz-Urb'luu, Frog, Froghemoth Adult, Frost Giant Everlasting One, Frost Salamander, Frostwind Virago, Fungus 5e, Gaerdal Ironhand, Garl Glittergold, Gem Dragon 5e, Genasi 5e, Genie 5e, Geryon, Giant 5e, Giant Spider, Giant Weasel, Gibberling, Giff, Giff Common, Girallon, Gith 5e, Githyanki 5e, Githyanki Gish, Githyanki Kith'rak, Githyanki Supreme Commander, Githzerai 5e, Gnoll 5e, Gnome, Gnomish Pantheon, Goat, Goblin, Goblinoid 5e, Gold Dragon 5e, Goliath, Gorgon 5e, Gorm Gulthyn, Granam 5e, Gray Ooze 5e, Great Cat, Great Cat 5e, Greater Restoration One, Green Abishai, Green Dragon 5e, Green Guard Drake, Greyhawk 5e, Greyhawk Pantheon 5e, Grig, Grotten Longflint 5e, Gruumsh, Guard Drake, Guard Drake Common, Habitat 5e, Habitat/Arctic 5e, Habitat/Astral Sea 5e, Habitat/Coastal 5e, Habitat/Desert 5e, Habitat/Feywild 5e, Habitat/Forest 5e, Habitat/Grassland 5e, Habitat/Hill 5e, Habitat/Khyber 5e, Habitat/Mountain 5e, Habitat/Shadowfell 5e, Habitat/Swamp 5e, Habitat/Underdark 5e, Habitat/Underground 5e, Habitat/Underwater 5e, Habitat/Underworld 5e, Habitat/Urban 5e, Habitat/Wildes 5e, Habitat/Wildspace 5e, Hadrosaurus, Haela Brightaxe, Hag 5e, Halfling 5e, Halfling Pantheon, Handaxe 5e, Hanseath, Harengon, Harpy 5e, Hawk, Hazard 5e, Height and Weight 5e, Helgelar Sunlost 5e, High Elf, High Elf Common 5e, Hill Dwarf Common 5e, Hill Giant, Hobgoblin 5e, Homunculus 5e, Hoplite 5e, Horse, Human 5e, Hurly 5e, Hutjin, Hydra 5e, Ice Troll, Illithilich 5e, Ilneval, Imp, Individual 5e, Janore Stormswake 5e, Jute 5e, Kak 5e, Knife-Catcher Skeen 5e, Kobold 5e, Korred, Kraken 5e, Krell Grohlg 5e, Kurtulmak, Laduguer, Language 5e, Language List 5e, Laogzed, Leshy, Lich 5e, Life Domain, Lion, Lizard, Lizardfolk 5e, Locathah, Location 5e, Lolth, Loquid 5e, Luthic, Lycanthrope 5e, Mages of High Sorcery 5e, Magic Item 5e, Magic Item List 5e, Magic Potion 5e, Maglubiyet, Main 5e, Major Ursa 5e, Male Steeder 5e, Maneuver, Marius Golpon 5e, Marthammor Duin, Mastiff, Medusa 5e, Mephit 5e, Merfolk 5e, Merrick 5e, Merrshaulk 5e, Metallic Sentinel, Mind Flayer 5e, Minotaur, Mintleaf 5e, Mirria Delvane 5e, Moloch, Monkey 5e, Monster List 5e, Moradin, Mordinsamman, Morley Tobe 5e, Mountain Dwarf Common 5e, Muamman Duathal, Mule, Mummy 5e, Mya, Myconid 5e, Myrmidon, Naga, Nebelun, Neo-Otyugh, Neogi, Nine Hells, Nixie, Nymph 5e, Octopus, Odium 5e, Ogmund 5e, Ogre, One DnD 5e, One:Arcane Spell One, One:Arms of Hadar, One:Aura of Vitality, One:Awaken One, One:Bane One, One:Banishment, One:Beacon of Hope One, One:Bestow Curse One, One:Charm Person One, One:Condition One, One:Create of Destroy Water One, One:Dissonant Whispers, One:Divine Spell One, One:Dominate Monster One, One:Eldritch Invocation List One, One:Feat, One:Fighting Style, One:Heal One, One:Hypnotic Pattern One, One:Jump Spell One, One:Primal Spell One, One:Ray of Enfeeblement One, One:Regenerate One, One:Rules Glossary, One:Scimitar One, One:Slow One, One:Spell List/Abjuration One, One:Spell List/Conjuration One, One:Spell List/Divination One, One:Spell List/Enchantment One, One:Spell List/Evocation One, One:Spell List/Illusion One, One:Spell List/Necormancy One, One:Spell List/Transmutation One, One:Spell One, One:Thunderwave One, One:Trident, One:Warlock/Spell One, One:Wind Wall One, Ooze 5e, Orc 5e, Organization 5e, Othokent, Overlord 5e, Owl, Ox, Ozymandias 5e, Paladin/Spell List 5e, Panther, Path of the Berserker, Path of the Totem Warrior, Pech, Phanaton, Phoenix Ash/Creature Trait/Mimicry 5e, Phoenix Ash/Creature Trait/Multi-Headed 5e, Pirate 5e, Pirate Captain 5e, Plane 5e, Polearm 5e, Polis 5e, Pony, Pseudodragon, Quasit, Quetzalcoatlus, Quickling, Quori 5e, Race 5e, Rakshasa 5e, Ranger/Spell List 5e, Rashlen 5e, Rat, Raven, Raven Queen 5e, Ravenloft, Ravnica, Red Abishai, Red Dragon 5e, Red Guard Drake, Reef Shark, Refrum 5e, Remorhaz 5e, Revenant, Roc 5e, Rock Gnome, Roil 5e, Roknar, Rule Tip 5e, Rule Tip/AC Calculations Don't Stack 5e, Rule Tip/Bonus Actions 5e, Rule Tip/Divine Strike vs. Potent Spellcasting 5e, Rule Tip/Jumping Costs Movement 5e, Rule Tip/Resistance 5e, Rule Tip/Ribbon 5e, Rule Tip/Round Down 5e, Rule Tip/Temporary Hit Points Don't Stack 5e, Rule Tip/You're a Creature 5e, Russet Mold 5e, Sacred Statue, Sahuagin 5e, Salamander 5e, Sanctuary One, Satyr, Sauriv 5e, Scorpion, Sea Elf 5e, Sea Hag 5e, Sea Serpent 5e, Secret Chest One, Segojan Earthcaller, Sehanine Moonbow, Sekolah, Sending One, Serpent Gods Pantheon, Sgothgah 5e, Shape Water, Shapechanger 5e, Sharindlar, Shark, Shark 5e, Sheela Peryroyl, Shifter, Skeldruff Plenk 5e, Skeleton, Skeleton 5e, Slaad 5e, Slarkrethel 5e, Sliris 5e, Sloane 5e, Snake, Snake 5e, Snilloc's Snowball Swarm, Sorcerer/Spell List 5e, Specter 5e, Spell 5e, Spell List 5e, Spell List/Abjuration 5e, Spell List/Conjuration 5e, Spell List/Divination 5e, Spell List/Enchantment 5e, Spell List/Evocation 5e, Spell List/Evocation One, Spell List/Illusion 5e, Spell List/Necromancy 5e, Spell List/Transmutation 5e, Spellcasting Focus 5e, Spelljammer 5e, Sphinx 5e, Spider, Spider 5e, Spoorx 5e, Spring Eladrin, Sprite, Sprite 5e, Sseth 5e, Ssurran Common 5e, Ssurran Shaman, Stegosaurus, Stench Kow, Stone Giant, Stone Golem 5e, Storm Giant, Strahd von Zarovich, Subclass 5e, Summer Eladrin, Surtur, Svirfneblin 5e, Swarm of Beetles 5e, Swarm of Centipedes 5e, Swarm of Cranium Rats, Swarm of Spiders 5e, Swarm of Wasps 5e, Tabaxi, Tak Merakin 5e, Telekinesis One, Teleport Spell One, Thard Harr, Tharmekhul, The Blood of Vol, The Path of Light, The Silver Flame, The Spirits of the Past, The Undying Court, Thornwell 5e, Thri-kreen 5e, Thunder Step, Thunderclap, Tiamat 5e, Tiefling 5e, Tiefling Common 5e, Tiger, Timpella 5e, Tortle 5e, Tree Blight, Trinket, Triton Race, Troglodyte 5e, Troll 5e, Ulaa, Ulder Raserhill 5e, Urdlen, Urogalan, Valissia Arrowen 5e, Vampire 5e, Vampire Spellcaster 5e, Vampire Warrior 5e, Vampiric Mist 5e, Vecna, Vegepygmy 5e, Velociraptor, Vergadain, Virgil 5e, Volo, Vortanim 5e, Wall of Fire One, Wand 5e, Warlock/Spell List 5e, Water Elemental 5e, Water Elemental Myrmidon, Water Walk One, Weapon 5e, Weasel, Wereraven 5e, White Abishai, White Dragon 5e, White Guard Drake, White Pudding 5e, Will of the Feywild 5e, Winter Eladrin, Wizard/Spell List 5e, Wolf, Wolgar Windrune 5e, Wondrous Item 5e, Wood Elf Common 5e, Yondalla, Zennor 5e, Zombie 5e