5e:Bard/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 6: Line 6:
<div class="gi-main">
<div class="gi-main">
==Bard Spells==
==Bard Spells==
</noinclude>''Spells for the [[SRD5:Bard|Bard]] class.''
</noinclude>''{{#cargo_query:
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
}} spells for the [[SRD5:Bard|Bard]] class.''
{|class="zebra sortable small"
{|class="zebra sortable small"
!Cantrips<br />(0 Level)
!Cantrips<br />(0 Level)
Line 15: Line 20:
|-
|-
|valign="top"|<!--Cantrips-->
|valign="top"|<!--Cantrips-->
''{{5edlc|Blade Ward}}'' <ref name="phb" /><br />
{{#cargo_query:
''{{srd5lc|Dancing Lights}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{5edlc|Friends}}'' <ref name="phb" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Light Spell|Light}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|Mage Hand}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Mending}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|Message}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Minor Illusion}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Prestidigitation}}'' <ref name="srd5" /><br />
}}
{{5espell|Shadow}} <ref group="uc" name="rly" /><br />
''{{5edlc|Thunderclap}}'' <ref name="xan" /><br />
''{{srd5lc|True Strike}}'' <ref name="srd5" /><br />
''{{srd5lc|Vicious Mockery}}'' <ref name="srd5" /><br />


|valign="top"|<!--1st Level-->
|valign="top"|<!--1st Level-->
''{{srd5lc|Animal Friendship}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{srd5lc|Bane}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Charm Person}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Comprehend Languages}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|Cure Wounds}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Detect Magic}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
|format=template
''{{srd5lc|Disguise Self}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{5edlc|Dissonant Whispers}}'' <ref name="phb" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Faerie Fire}}'' <ref name="srd5" /><br />
}}
''{{srd5lc|Fear}}'' <ref name="srd5" /><br />
''{{srd5lc|Feather Fall|Feather Fall}}'' <ref name="srd5" /><br />
''{{5edlc|Guiding Hand}}'' <ref group="ua" name="starter" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Healing Word}}'' <ref name="srd5" /><br />
''{{srd5lc|Heroism}}'' <ref name="srd5" /><br />
''{{srd5lc|Hideous Laughter}}'' <ref name="srd5" /><br />
''{{srd5lc|Identify}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Illusory Script}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Longstrider}}'' <ref name="srd5" /><br />
''{{5edlc|Puppet}}'' <ref group="ua" name="starter" /><br />
''{{5edlc|Sense Emotion}}'' <ref group="ua" name="starter" /><br />
''{{srd5lc|Silent Image}}'' <ref name="srd5" /><br />
''{{srd5lc|Sleep}}'' <ref name="srd5" /><br />
''{{srd5lc|Speak with Animals}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{5edlc|Sudden Awakening}}'' <ref group="ua" name="starter" /><br />
''{{srd5lc|Thunderwave}}'' <ref name="srd5" /><br />
''{{5edlc|Unearthly Chorus}}'' <ref group="ua" name="starter" /><br />
''{{srd5lc|Unseen Servant}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />


|valign="top"|<!--2nd Level-->
|valign="top"|<!--2nd Level-->
''{{srd5lc|Animal Messenger}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
{{#cargo_query:
''{{srd5lc|Blindness/Deafness}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Calm Emotions}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{5edlc|Cloud of Daggers}}'' <ref name="phb" /><br />
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{5edlc|Crown of Madness}}'' <ref name="phb" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Detect Thoughts}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|Enhance Ability}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Enthrall}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Heat Metal}}'' <ref name="srd5" /><br />
}}
''{{srd5lc|Hold Person}}'' <ref name="srd5" /><br />
''{{srd5lc|Invisibility}}'' <ref name="srd5" /><br />
''{{srd5lc|Knock}}'' <ref name="srd5" /><br />
''{{srd5lc|Lesser Restoration}}'' <ref name="srd5" /><br />
''{{srd5lc|Locate Animals or Plants}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Locate Object|Locate Object}}'' <ref name="srd5" /><br />
''{{srd5lc|Magic Mouth|Magic Mouth}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}<br />
''{{5edlc|Phantasmal Force}}'' <ref name="phb" /><br />
''{{5edlc|Pyrotechnics}}'' <ref name="xan" /><br />
''{{srd5lc|See Invisibility}}'' <ref name="srd5" /><br />
''{{srd5lc|Shatter}}'' <ref name="srd5" /><br />
''{{srd5lc|Silence}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{5edlc|Skywrite}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Suggestion}}'' <ref name="srd5" /><br />
''{{5edlc|Warding Wind}}'' <ref name="xan" /><br />
''{{srd5lc|Zone of Truth}}'' <ref name="srd5" /><br />


|valign="top"|<!--3rd Level-->
|valign="top"|<!--3rd Level-->
''{{srd5lc|Bestow Curse}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{5edlc|Catnap}}'' <ref name="xan" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Clairvoyance}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Dispel Magic}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{5edlc|Enemies Abound}}'' <ref name="xan" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{5edlc|Feign Death}}'' <ref name="phb" /> <sup>{{iplink|Notes|[r]}}</sup><br />
|format=template
''{{srd5lc|Glyph of Warding}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Hypnotic Pattern}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Major Image}}'' <ref name="srd5" /><br />
}}
''{{srd5lc|Nondetection}}'' <ref name="srd5" /><br />
''{{srd5lc|Plant Growth}}'' <ref name="srd5" /><br />
''{{srd5lc|Sending}}'' <ref name="srd5" /><br />
''{{srd5lc|Speak with Dead}}'' <ref name="srd5" /><br />
''{{srd5lc|Speak with Plants}}'' <ref name="srd5" /><br />
''{{srd5lc|Stinking Cloud}}'' <ref name="srd5" /><br />
''{{srd5lc|Tiny Hut}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}<br />
''{{srd5lc|Tongues}}'' <ref name="srd5" /><br />


|valign="top"|<!--4th Level-->
|valign="top"|<!--4th Level-->
''{{5edlc|Charm Monster}}'' <ref name="xan" /><br />
{{#cargo_query:
''{{srd5lc|compulsion}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Confusion}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Dimension Door}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|Freedom of Movement}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Greater Invisibility}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|Hallucinatory Terrain}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Locate Creature}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Polymorph}}'' <ref name="srd5" /><br />
}}


|-
|-
Line 124: Line 83:
|-
|-
|valign="top"|<!--5th Level-->
|valign="top"|<!--5th Level-->
''{{srd5lc|Animate Objects}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{srd5lc|Awaken}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Dominate Person}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Dream}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{5edlc|Earth Tremor}}'' <ref name="xan" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Geas}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|Greater Restoration}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Hold Monster}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Legend Lore}}'' <ref name="srd5" /><br />
}}
''{{srd5lc|Mass Cure Wounds}}'' <ref name="srd5" /><br />
''{{srd5lc|Mislead}}'' <ref name="srd5" /><br />
''{{srd5lc|Modify Memory}}'' <ref name="srd5" /><br />
''{{srd5lc|Planar Binding}}'' <ref name="srd5" /><br />
''{{srd5lc|Raise Dead}}'' <ref name="srd5" /><br />
''{{srd5lc|Scrying}}'' <ref name="srd5" /><br />
''{{srd5lc|Seeming}}'' <ref name="srd5" /><br />
''{{5edlc|Skill Empowerment}}'' <ref name="xan" /><br />
''{{5edlc|Synaptic Static}}'' <ref name="xan" /><br />
''{{srd5lc|Teleportation Circle}}'' <ref name="srd5" /><br />


|valign="top"|<!--6th Level-->
|valign="top"|<!--6th Level-->
''{{srd5lc|Eyebite}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{srd5lc|Find the Path}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Guards and Wards}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Irresistible Dance}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|Mass Suggestion}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Programmed Illusion}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|True Seeing|True Seeing}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
}}


|valign="top"|<!--7th Level-->
|valign="top"|<!--7th Level-->
''{{srd5lc|Arcane Sword}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{srd5lc|Etherealness}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Forcecage}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Magnificent Mansion}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|Mirage Arcane}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{5edlc|Mordenkainen's Sword}}'' <ref name="phb" /><br />
|format=template
''{{srd5lc|Project Image}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Regenerate}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Resurrection}}'' <ref name="srd5" /><br />
}}
''{{srd5lc|Symbol}}'' <ref name="srd5" /><br />
{{5espell|Teleport Spell}} <ref name="srd5" /><br />


|valign="top"|<!--8th Level-->
|valign="top"|<!--8th Level-->
''{{srd5lc|Dominate Monster}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{srd5lc|Feeblemind}}'' <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
''{{srd5lc|Glibness}}'' <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Mind Blank}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|Power Word Stun}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|format=template
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
}}


|valign="top"|<!--9th Level-->
|valign="top"|<!--9th Level-->
''{{srd5lc|Foresight}}'' <ref name="srd5" /><br />
{{#cargo_query:
''{{5edlc|Mass Polymorph}}'' <ref name="xan" /><br />
table=5e_Spell, Pages_Info
''{{5edlc|Power Word Heal}}'' <ref name="phb" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
''{{srd5lc|Power Word Kill}}'' <ref name="srd5" /><br />
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
''{{srd5lc|True Polymorph}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{5edlc|Psychic Scream}}'' <ref name="xan" /><br />
|format=template
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
}}
|}
|}
<noinclude>
<noinclude>
==Sortable Table==
The following is a sortable list of {{#cargo_query:
tables=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
}} {{SRD5|Bard}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial).
<div style="overflow:auto; width:100%; max-height:80vh; font-size:0.75rem;">
{|class="zebra small sortable"
!Name
!Level
!School
!Casting<br />Time
!Range
!Components
!Casters
!Source<br />Notes
!Sources
|-
{{#cargo_query:
tables=5e_Spell,Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=5e_Spell.Casters HOLDS 'Bard' AND ((Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (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
|order by=5e_Spell.Sort_Text
|limit=1000
|format=template
|template=5e Spell Table Row
|more results text=More Spells
}}
|}</div>
</div><!--gi-main-->
</div><!--gi-main-->
<div class="source">
<div class="source">


==Sources==
==Sources==
<references>
<references />
<ref name="srd5">{{pub|SRD-OGL v5.1}}</ref>
<!--
<ref name="phb">{{pub|Player's Handbook (5e)}}</ref>
<ref name="xan">{{pub|Xanathar's Guide to Everything}}</ref>
</references>
===Unearthed Arcana===
''Unearthed Arcana spells are at the GM's discression''
<references group="ua">
<ref group="ua" name="starter">{{pub|UA Starter Spells}}</ref>
</references>
===User Creations===
<references group="uc">
<ref group="uc" name="rly">[[User:Rlyehable]]</ref>
</references>
===Notes===
===Notes===
:<sup>[r]</sup> These spells may be cast as {{srd5lc|Ritual}}s.
===Spell Notes===
{{anchor|a}} = {{SRD5|Abjuration}}<br />
{{anchor|c}} = {{SRD5|Conjuration}}<br />
{{anchor|d}} = {{SRD5|Divination}}<br />
{{anchor|en}} = {{SRD5|Enchantment}}<br />
{{anchor|ev}} = {{SRD5|Evocation}}<br />
{{anchor|i}} = {{SRD5|Illusion}}<br />
{{anchor|n}} = {{SRD5|Necromancy}}<br />
{{anchor|t}} = {{SRD5|Transmutation}}<br />
{{anchor|o}} = Other school<br />
<br />
{{anchor|cn}} = {{SRD5|Concentration}}<br />
{{anchor|r}} = {{SRD5|Ritual}}<br />
<br />
{{anchor|can}} = Canon<br />
{{anchor|p}} = Pointer<br />
{{anchor|ua}} = Unearthed Arcana<br />
{{anchor|uc}} = User Creation
-->
</div><!--source-->
</div><!--source-->
</div><!--grid-container-std-->
</div><!--grid-container-std-->
</noinclude>
</noinclude>

Latest revision as of 13:44, 1 January 2021

< Bard
Also see: SRD5:Spell#Bard Spells

D&D 5e Varied ʰ 
See sections for licenses


Bard Spells

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

Function: CargoSQLQuery::run Query: SELECT 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 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


Sortable Table

The following is a sortable list of
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT 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 COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

Bard spells for 5th ed. (official and unofficial).
Error: No field named "Hidden" found for the database table "Pages_Info".
Name Level School Casting
Time 		Range Components Casters Source
Notes 		Sources

Sources

Retrieved from "https://wiki.rlyehable.com/index.php?title=5e:Bard/Spell_List&oldid=10053"