5e:Cleric/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
(wip)
 
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>
<noinclude><div class="grid-container-std">
<div class="grid-container-std">
<div class="bctop">{{backto|{{SRD5|Cleric}}}}</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">
==Cleric Spells==
==Cleric Spells==
</noinclude>
</noinclude>
''Spells for the {{SRD5|Cleric}} class.''
''{{#cargo_query:
tables=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
}} spells for the {{SRD5|Cleric}} subclass.''
{|class="zebra small"
{|class="zebra small"
!Cantrips<br />(0 Level)
!Cantrips<br />(0 Level)
Line 17: Line 21:


|valign="top"|<!--cantrips-->
|valign="top"|<!--cantrips-->
{{srd5lc|Guidance}} <ref name="srd5" /><br />
{{#cargo_query:
{{5edlc|Hand of Radiance}} <ref group="ua" name="starter" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Light Spell|light}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Mending}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Resistance Spell|resistance}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Sacred Flame}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Spare the Dying}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Thaumaturgy}} <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
{{5edlc|Toll the Dead}} <ref name="xan" /><br />
}}
{{srd5lc|Virtue}} <ref group="ua" name="starter" /><br />
{{srd5lc|Word of Radiance}} <ref name="xan" /><br />


|valign="top"|<!--1st Level-->
|valign="top"|<!--1st Level-->
{{srd5lc|Bane}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Bless}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Command}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{5edlc|Ceremony}} <ref name="xan" /><br />
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Create or Destroy Water}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Cure Wounds}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Detect Evil and Good}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Detect Magic}} <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
{{srd5lc|Detect Poison and Disease}} <ref name="srd5" /><br />
}}
{{srd5lc|Guiding Bolt}} <ref name="srd5" /><br />
{{5edlc|Guiding Hand}} <ref group="ua" name="starter" /><br />
{{srd5lc|Healing Word}} <ref name="srd5" /><br />
{{srd5lc|Inflict Wounds}} <ref name="srd5" /><br />
{{srd5lc|Protection from Evil and Good}} <ref name="srd5" /><br />
{{srd5lc|Purify Food and Drink}} <ref name="srd5" /><br />
{{srd5lc|Sanctuary}} <ref name="srd5" /><br />
{{srd5lc|Shield of Faith}} <ref name="srd5" /><br />


|valign="top"|<!--2nd Level-->
|valign="top"|<!--2nd Level-->
{{srd5lc|Aid}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Augury}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Blindness/Deafness}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Calm Emotions}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Continual Flame}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Enhance Ability}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Find Traps}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{5edlc|Focus Breaker}} <ref group="uc" name="rly" /><br />
|order by=5e_Spell.Sort_Text
{{srd5lc|Gentle Repose}} <ref name="srd5" /><br />
}}
{{srd5lc|Hold Person}} <ref name="srd5" /><br />
{{srd5lc|Lesser Restoration}} <ref name="srd5" /><br />
{{srd5lc|Locate Object}} <ref name="srd5" /><br />
{{srd5lc|Prayer of Healing}} <ref name="srd5" /><br />
{{srd5lc|Protection from Poison}} <ref name="srd5" /><br />
{{srd5lc|Silence}} <ref name="srd5" /><br />
{{srd5lc|Spiritual Weapon}} <ref name="srd5" /><br />
{{srd5lc|Warding Bond}} <ref name="srd5" /><br />
{{srd5lc|Zone of Truth}}


|valign="top"|<!--3rd Level-->
|valign="top"|<!--3rd Level-->
{{srd5lc|Animate Dead|Animate Dead}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Beacon of Hope|Beacon of Hope}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Bestow Curse|Bestow Curse}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Clairvoyance|Clairvoyance}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Create Food and Water|Create Food and Water}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Daylight Spell|Daylight}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Dispel Magic|Dispel Magic}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Glyph of Warding|Glyph of Warding}} <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
{{srd5lc|Magic Circle|Magic Circle}} <ref name="srd5" /><br />
}}
{{srd5lc|Mass Healing Word|Mass Healing Word}} <ref name="srd5" /><br />
{{srd5lc|Meld into Stone|Meld into Stone}} <ref name="srd5" /><br />
{{srd5lc|Protection from Energy|Protection from Energy}} <ref name="srd5" /><br />
{{srd5lc|Remove Curse|Remove Curse}} <ref name="srd5" /><br />
{{srd5lc|Revivify|Revivify}} <ref name="srd5" /><br />
{{srd5lc|Sending|Sending}} <ref name="srd5" /><br />
{{srd5lc|Speak with Dead|Speak with Dead}} <ref name="srd5" /><br />
{{srd5lc|Spirit Guardians|Spirit Guardians}} <ref name="srd5" /><br />
{{srd5lc|Tongues|Tongues}} <ref name="srd5" /><br />
{{srd5lc|Water Walk|Water Walk}}


|valign="top"|<!--4th Level-->
|valign="top"|<!--4th Level-->
{{srd5lc|Banishment|Banishment}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Control Water|Control Water}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Death Ward|Death Ward}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Divination Spell|Divination}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Freedom of Movement|Freedom of Movement}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Guardian of Faith|Guardian of Faith}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Locate Creature|Locate Creature}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Stone Shape|Stone Shape}}
|order by=5e_Spell.Sort_Text
}}


|-
|-
Line 108: Line 84:


|valign="top"|<!--5th Level-->
|valign="top"|<!--5th Level-->
{{srd5lc|Commune|Commune}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Contagion|Contagion}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Dispel Evil and Good|Dispel Evil and Good}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Flame Strike|Flame Strike}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Geas|Geas}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Greater Restoration|Greater Restoration}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Hallow|Hallow}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Insect Plague|Insect Plague}} <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
{{srd5lc|Legend Lore|Legend Lore}} <ref name="srd5" /><br />
}}
{{srd5lc|Mass Cure Wounds|Mass Cure Wounds}} <ref name="srd5" /><br />
{{srd5lc|Planar Binding|Planar Binding}} <ref name="srd5" /><br />
{{srd5lc|Raise Dead|Raise Dead}} <ref name="srd5" /><br />
{{srd5lc|Scrying|Scrying}}


|valign="top"|<!--6th Level-->
|valign="top"|<!--6th Level-->
{{srd5lc|Blade Barrier|Blade Barrier}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Create Undead|Create Undead}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Find the Path|Find the Path}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Forbiddance|Forbiddance}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Harm|Harm}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Heal|Heal}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Heroes' Feast}}<ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Planar Ally|Planar Ally}} <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
{{srd5lc|True Seeing|True Seeing}} <ref name="srd5" /><br />
}}
{{srd5lc|Word of Recall|Word of Recall}}


|valign="top"|<!--7th Level-->
|valign="top"|<!--7th Level-->
{{srd5lc|Conjure Celestial|Conjure Celestial}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Divine Word|Divine Word}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Etherealness|Etherealness}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Fire Storm|Fire Storm}} <ref name="srd5" /><br />
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
{{srd5lc|Plane Shift|Plane Shift}} <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
{{srd5lc|Regenerate|Regenerate}} <ref name="srd5" /><br />
|format=template
{{srd5lc|Resurrection|Resurrection}} <ref name="srd5" /><br />
|template=5e Spell List Row
{{srd5lc|Symbol|Symbol}}
|order by=5e_Spell.Sort_Text
}}


|valign="top"|<!--8th Level-->
|valign="top"|<!--8th Level-->
{{srd5lc|Antimagic Field|Antimagic Field}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Control Weather|Control Weather}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Earthquake|Earthquake}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|Holy Aura|Holy Aura}}
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Cleric') 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
}}


|valign="top"|<!--9th Level-->
|valign="top"|<!--9th Level-->
{{srd5lc|Astral Projection|Astral Projection}} <ref name="srd5" /><br />
{{#cargo_query:
{{srd5lc|Gate|Gate}} <ref name="srd5" /><br />
table=5e_Spell, Pages_Info
{{srd5lc|Mass Heal|Mass Heal}} <ref name="srd5" /><br />
|join on=5e_Spell._pageName=Pages_Info._pageName
{{srd5lc|True Resurrection|True Resurrection}}
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Cleric') 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
<noinclude>
|format=template
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
}}
|}<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 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
}} {{SRD5|Cleric}} {{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 'Cleric' 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===
:<sup>[r]</sup> These spells may be cast as {{srd5lc|Ritual}}s.
</div><!--source-->
</div><!--source-->
</div><!--grid-container-std-->
</div><!--grid-container-std-->
</noinclude>
</noinclude>

Latest revision as of 07:30, 21 October 2020

< Cleric

D&D 5e Varied ʰ 
See sections for licenses


Cleric 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`= 'Cleric') ) 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 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

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`= 'Cleric') ) 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

Cleric 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:Cleric/Spell_List&oldid=9180"