5e:Bard/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
(Created page with "<noinclude> <div class="grid-container-std"> <div class="bctop">{{backto|{{SRD5|Bard}}}}</div> <div class="notice"></div> <div class="badge">{{5evaried}}</div> <div class="gi-...")
 
 
(17 intermediate revisions by the same user not shown)
Line 2: Line 2:
<div class="grid-container-std">
<div class="grid-container-std">
<div class="bctop">{{backto|{{SRD5|Bard}}}}</div>
<div class="bctop">{{backto|{{SRD5|Bard}}}}</div>
<div class="notice"></div>
<div class="notice">{{alsosee|SRD5:Spell#Bard Spells}}</div>
<div class="badge">{{5evaried}}</div>
<div class="badge">{{5evaried}}</div>
<div class="gi-main">
<div class="gi-main">
==Bard Spells==
==Bard Spells==
</noinclude>''Spells for the [[SRD5:Bard|Bard]] class.''
</noinclude>''{{#cargo_query:
{|class="zebra"
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"
!Cantrips<br />(0 Level)
!Cantrips<br />(0 Level)
!1st Level
!1st Level
Line 15: Line 20:
|-
|-
|valign="top"|<!--Cantrips-->
|valign="top"|<!--Cantrips-->
[[SRD5:Dancing Lights|Dancing Lights]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Light Spell|Light]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Mage Hand|Mage Hand]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Mending|Mending]] <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))
[[SRD5:Message|Message]] <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
[[SRD5:Minor Illusion|Minor Illusion]] <ref name="srd5" /><br />
|format=template
[[SRD5:Prestidigitation|Prestidigitation]] <ref name="srd5" /><br />
|template=5e Spell List Row
[[SRD5:True Strike|True Strike]] <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
[[SRD5:Vicious Mockery|Vicious Mockery]] <ref name="srd5" /><br />
}}


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


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


|valign="top"|<!--3rd Level-->
|valign="top"|<!--3rd Level-->
[[SRD5:Bestow Curse|Bestow Curse]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Clairvoyance|Clairvoyance]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Dispel Magic|Dispel Magic]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Fear|Fear]] <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))
[[SRD5:Glyph of Warding|Glyph of Warding]] <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
[[SRD5:Hypnotic Pattern|Hypnotic Pattern]] <ref name="srd5" /><br />
|format=template
[[SRD5:Major Image|Major Image]] <ref name="srd5" /><br />
|template=5e Spell List Row
[[SRD5:Nondetection|Nondetection]] <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
[[SRD5:Plant Growth|Plant Growth]] <ref name="srd5" /><br />
}}
[[SRD5:Sending|Sending]] <ref name="srd5" /><br />
[[SRD5:Speak with Dead|Speak with Dead]] <ref name="srd5" /><br />
[[SRD5:Speak with Plants|Speak with Plants]] <ref name="srd5" /><br />
[[SRD5:Stinking Cloud|Stinking Cloud]] <ref name="srd5" /><br />
[[SRD5:Tiny Hut|Tiny Hut]] <ref name="srd5" /><br />
[[SRD5:Tongues|Tongues]] <ref name="srd5" /><br />


|valign="top"|<!--4th Level-->
|valign="top"|<!--4th Level-->
[[SRD5:compulsion|Compulsion]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Confusion|Confusion]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Dimension Door|Dimension Door]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Freedom of Movement|Freedom of Movement]] <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))
[[SRD5:Greater Invisibility|Greater Invisibility]] <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
[[SRD5:Hallucinatory Terrain|Hallucinatory Terrain]] <ref name="srd5" /><br />
|format=template
[[SRD5:Locate Creature|Locate Creature]] <ref name="srd5" /><br />
|template=5e Spell List Row
[[SRD5:Polymorph|Polymorph]] <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
}}


|-
|-
Line 104: Line 83:
|-
|-
|valign="top"|<!--5th Level-->
|valign="top"|<!--5th Level-->
[[SRD5:Animate Objects|Animate Objects]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Awaken|Awaken]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Dominate Person|Dominate Person]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Dream|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))
[[SRD5:Geas|Geas]] <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
[[SRD5:Greater Restoration|Greater Restoration]] <ref name="srd5" /><br />
|format=template
[[SRD5:Hold Monster|Hold Monster]] <ref name="srd5" /><br />
|template=5e Spell List Row
[[SRD5:Legend Lore|Legend Lore]] <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
[[SRD5:Mass Cure Wounds|Mass Cure Wounds]] <ref name="srd5" /><br />
}}
[[SRD5:Mislead|Mislead]] <ref name="srd5" /><br />
[[SRD5:Modify Memory|Modify Memory]] <ref name="srd5" /><br />
[[SRD5:Planar Binding|Planar Binding]] <ref name="srd5" /><br />
[[SRD5:Raise Dead|Raise Dead]] <ref name="srd5" /><br />
[[SRD5:Scrying|Scrying]] <ref name="srd5" /><br />
[[SRD5:Seeming|Seeming]] <ref name="srd5" /><br />
[[SRD5:Teleportation Circle|Teleportation Circle]] <ref name="srd5" /><br />


|valign="top"|<!--6th Level-->
|valign="top"|<!--6th Level-->
[[SRD5:Eyebite|Eyebite]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Find the Path|Find the Path]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Guards and Wards|Guards and Wards]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Irresistible Dance|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))
[[SRD5:Mass Suggestion|Mass Suggestion]] <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
[[SRD5:Programmed Illusion|Programmed Illusion]] <ref name="srd5" /><br />
|format=template
[[SRD5: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-->
{{SRD5|Arcane Sword}}<ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Etherealness|Etherealness]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Forcecage|Forcecage]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Magnificent Mansion|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))
[[SRD5:Mirage Arcane|Mirage Arcane]] <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
[[SRD5:Project Image|Project Image]] <ref name="srd5" /><br />
|format=template
[[SRD5:Regenerate|Regenerate]] <ref name="srd5" /><br />
|template=5e Spell List Row
[[SRD5:Resurrection|Resurrection]] <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
[[SRD5:Symbol|Symbol]] <ref name="srd5" /><br />
}}
[[SRD5:Teleport Spell|Teleport]] <ref name="srd5" /><br />


|valign="top"|<!--8th Level-->
|valign="top"|<!--8th Level-->
[[SRD5:Dominate Monster|Dominate Monster]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Feeblemind|Feeblemind]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:Glibness|Glibness]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
[[SRD5:Mind Blank|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))
[[SRD5:Power Word Stun|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-->
[[SRD5:Foresight|Foresight]] <ref name="srd5" /><br />
{{#cargo_query:
[[SRD5:Power Word Kill|Power Word Kill]] <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
[[SRD5:True Polymorph|True Polymorph]] <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|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
}}
|}
|}
<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>
<!--
</references>
===Notes===
===User Creations===
===Spell Notes===
<references group="uc" />
{{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"