5e:Cleric/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 19: Line 19:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
----
''{{srd5lc|Guidance}}'' <ref name="srd5" /><br />
''{{5edlc|Hand of Radiance}}'' <ref name="starter">{{pub|UA Starter Spells}}</ref><br />
''{{5edlc|Hand of Radiance}}'' <ref group="ua" name="starter" /><br />
''{{5edlc|Toll the Dead}}'' <ref name="xan">{{Cite Pub|Xanathar's Guide to Everything}}</ref><br />
''{{srd5lc|Light Spell|light}}'' <ref name="srd5" /><br />
''{{srd5lc|Virtue}}'' <ref name="starter" /><br />
''{{srd5lc|Mending}}'' <ref name="srd5" /><br />
''{{srd5lc|Resistance Spell|resistance}}'' <ref name="srd5" /><br />
''{{srd5lc|Sacred Flame}}'' <ref name="srd5" /><br />
''{{srd5lc|Spare the Dying}}'' <ref name="srd5" /><br />
''{{srd5lc|Thaumaturgy}}'' <ref name="srd5" /><br />
''{{5edlc|Toll the Dead}}'' <ref name="xan" /><br />
''{{srd5lc|Virtue}}'' <ref group="ua" name="starter" /><br />
''{{srd5lc|Word of Radiance}}'' <ref name="xan" /><br />
''{{srd5lc|Word of Radiance}}'' <ref name="xan" /><br />


Line 42: Line 35:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
----
''{{srd5lc|Bane}}'' <ref name="srd5" /><br />
''{{srd5lc|Bless}}'' <ref name="srd5" /><br />
''{{srd5lc|Command}}'' <ref name="srd5" /><br />
''{{5edlc|Ceremony}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{5edlc|Ceremony}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Create or Destroy Water}}'' <ref name="srd5" /><br />
''{{5edlc|Guiding Hand}}'' <ref name="starter" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Cure Wounds}}'' <ref name="srd5" /><br />
''{{srd5lc|Detect Evil and Good}}'' <ref name="srd5" /><br />
''{{srd5lc|Detect Magic}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Detect Poison and Disease}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Guiding Bolt}}'' <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|Inflict Wounds}}'' <ref name="srd5" /><br />
''{{srd5lc|Protection from Evil and Good}}'' <ref name="srd5" /><br />
''{{srd5lc|Purify Food and Drink}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Sanctuary}}'' <ref name="srd5" /><br />
''{{srd5lc|Shield of Faith}}'' <ref name="srd5" /><br />


|valign="top"|<!--2nd Level-->
|valign="top"|<!--2nd Level-->
Line 71: Line 49:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
----
''{{srd5lc|Aid}}'' <ref name="srd5" /><br />
''{{5edlc|Focus Breaker}}'' <ref name="user:Rlyehable">[[user:Rlyehable]]</ref><br />
''{{srd5lc|Augury}}'' <ref name="srd5" /><br />
''{{srd5lc|Blindness/Deafness}}'' <ref name="srd5" /><br />
''{{srd5lc|Calm Emotions}}'' <ref name="srd5" /><br />
''{{srd5lc|Continual Flame}}'' <ref name="srd5" /><br />
''{{srd5lc|Enhance Ability}}'' <ref name="srd5" /><br />
''{{srd5lc|Find Traps}}'' <ref name="srd5" /><br />
''{{5edlc|Focus Breaker}}'' <ref group="uc" name="rly" /><br />
''{{srd5lc|Gentle Repose}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><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-->
Line 101: Line 62:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
----
''{{srd5lc|Animate Dead}}'' <ref name="srd5" /><br />
''{{srd5lc|Beacon of Hope}}'' <ref name="srd5" /><br />
''{{srd5lc|Bestow Curse}}'' <ref name="srd5" /><br />
''{{srd5lc|Clairvoyance}}'' <ref name="srd5" /><br />
''{{srd5lc|Create Food and Water}}'' <ref name="srd5" /><br />
''{{srd5lc|Daylight Spell|daylight}}'' <ref name="srd5" /><br />
''{{srd5lc|Dispel Magic}}'' <ref name="srd5" /><br />
''{{srd5lc|Glyph of Warding}}'' <ref name="srd5" /><br />
''{{5edlc|Life Transference}}'' <ref name="xan" /><br />
''{{5edlc|Life Transference}}'' <ref name="xan" /><br />
''{{srd5lc|Magic Circle}}'' <ref name="srd5" /><br />
''{{srd5lc|Mass Healing Word}}'' <ref name="srd5" /><br />
''{{srd5lc|Meld into Stone}}'' <ref name="srd5" /><br />
''{{srd5lc|Protection from Energy}}'' <ref name="srd5" /><br />
''{{srd5lc|Remove Curse}}'' <ref name="srd5" /><br />
''{{srd5lc|Revivify}}'' <ref name="srd5" /><br />
''{{srd5lc|Sending}}'' <ref name="srd5" /><br />
''{{srd5lc|Speak with Dead}}'' <ref name="srd5" /><br />
''{{srd5lc|Spirit Guardians}}'' <ref name="srd5" /><br />
''{{srd5lc|Tongues}}'' <ref name="srd5" /><br />
''{{srd5lc|Water Walk}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />


|valign="top"|<!--4th Level-->
|valign="top"|<!--4th Level-->
Line 133: Line 75:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
''{{srd5lc|Banishment}}'' <ref name="srd5" /><br />
''{{srd5lc|Control Water}}'' <ref name="srd5" /><br />
''{{srd5lc|Death Ward}}'' <ref name="srd5" /><br />
''{{srd5lc|Divination Spell|Divination}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Freedom of Movement|Freedom of Movement}}'' <ref name="srd5" /><br />
''{{srd5lc|Guardian of Faith|Guardian of Faith}}'' <ref name="srd5" /><br />
''{{srd5lc|Locate Creature}}'' <ref name="srd5" /><br />
''{{srd5lc|Stone Shape}}''' <ref name="srd5" /><br />


|-
|-
Line 161: Line 94:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
----
''{{srd5lc|Commune}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Contagion}}'' <ref name="srd5" /><br />
''{{srd5lc|Dawn}}'' <ref name="xan" /><br />
''{{srd5lc|Dawn}}'' <ref name="xan" /><br />
''{{srd5lc|Dispel Evil and Good}}'' <ref name="srd5" /><br />
''{{srd5lc|Flame Strike|Flame Strike}}'' <ref name="srd5" /><br />
''{{srd5lc|Geas}}'' <ref name="srd5" /><br />
''{{srd5lc|Greater Restoration}}'' <ref name="srd5" /><br />
''{{srd5lc|Hallow}}'' <ref name="srd5" /><br />
''{{srd5lc|Holy Weapon}}'' <ref name="xan" /><br />
''{{srd5lc|Insect Plague}}'' <ref name="srd5" /><br />
''{{srd5lc|Legend Lore}}'' <ref name="srd5" /><br />
''{{srd5lc|Mass Cure Wounds}}'' <ref name="srd5" /><br />
''{{srd5lc|Planar Binding}}'' <ref name="srd5" /><br />
''{{srd5lc|Raise Dead|Raise Dead}}'' <ref name="srd5" /><br />
''{{srd5lc|Scrying|Scrying}}''
''{{srd5lc|Scrying|Scrying}}''


Line 188: Line 108:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
''{{srd5lc|Blade Barrier}}'' <ref name="srd5" /><br />
''{{srd5lc|Create Undead}}'' <ref name="srd5" /><br />
''{{srd5lc|Find the Path}}'' <ref name="srd5" /><br />
''{{srd5lc|Forbiddance}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Harm}}'' <ref name="srd5" /><br />
''{{srd5lc|Heal}}'' <ref name="srd5" /><br />
''{{srd5lc|Heroes' Feast}}''<ref name="srd5" /><br />
''{{srd5lc|Planar Ally}}'' <ref name="srd5" /><br />
''{{srd5lc|True Seeing}}'' <ref name="srd5" /><br />
''{{srd5lc|Word of Recall}}''


|valign="top"|<!--7th Level-->
|valign="top"|<!--7th Level-->
Line 210: Line 119:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
----
''{{srd5lc|Conjure Celestial}}'' <ref name="srd5" /><br />
''{{srd5lc|Divine Word}}'' <ref name="srd5" /><br />
''{{srd5lc|Etherealness}}'' <ref name="srd5" /><br />
''{{srd5lc|Fire Storm}}'' <ref name="srd5" /><br />
''{{srd5lc|Plane Shift}}'' <ref name="srd5" /><br />
''{{srd5lc|Regenerate}}'' <ref name="srd5" /><br />
''{{srd5lc|Resurrection}}'' <ref name="srd5" /><br />
''{{srd5lc|Symbol}}'' <ref name="srd5" /><br />
''{{srd5lc|Temple of the Gods}}'' <ref name="xan" /><br />
''{{srd5lc|Temple of the Gods}}'' <ref name="xan" /><br />


Line 231: Line 132:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
''{{srd5lc|Antimagic Field}}'' <ref name="srd5" /><br />
''{{srd5lc|Control Weather}}'' <ref name="srd5" /><br />
''{{srd5lc|Earthquake}}'' <ref name="srd5" /><br />
''{{srd5lc|Holy Aura}}'' <ref name="srd5" /><br />


|valign="top"|<!--9th Level-->
|valign="top"|<!--9th Level-->
Line 247: Line 143:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
----
''{{srd5lc|Astral Projection}}'' <ref name="srd5" /><br />
''{{srd5lc|Gate}}'' <ref name="srd5" /><br />
''{{srd5lc|Mass Heal}}'' <ref name="srd5" /><br />
''{{srd5lc|True Resurrection}}''
|}
|}
</div><!--gi-main-->
</div><!--gi-main-->
Line 262: Line 153:


==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 discretion''
<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-->

Revision as of 13:00, 30 April 2020

< Cleric

D&D 5e Varied ʰ 
See sections for licenses


Cleric Spells

Spells for the Cleric 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`= '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

hand of radiance [1]
toll the dead [2]
virtue [1]
word of radiance [2]
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

ceremony [2] [r]
guiding hand [1] [r]
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

focus breaker [3]
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

life transference [2]
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

dawn [2]
scrying

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

temple of the gods [2]
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

Sources

  1. UA Starter Spells ↑ 1.0 1.1 1.2
  2. Mike Mearls, et. al.. Xanathar's Guide to Everything (5e) (November 2017). Wizards of the Coast. ↑ 2.0 2.1 2.2 2.3 2.4 2.5
  3. user:Rlyehable ↑
Retrieved from "https://wiki.rlyehable.com/index.php?title=5e:Cleric/Spell_List&oldid=5702"