5e:Warlock/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
(Created page with "<div class="grid-container-std"> <div class="bctop">{{backto|{{SRD5|Warlock}}}}</div> <div class="notice"></div> <div class="badge">{{5evaried}}</div> <div class="gi-main"> ==...")
 
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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 31: Line 31:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 41: Line 41:
table=5e_Spell, Pages_Info
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=2 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 53: Line 53:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 64: Line 64:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 83: Line 83:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 94: Line 94:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 105: Line 105:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 116: Line 116:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}
Line 127: Line 127:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Warlock') 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
}}
}}

Revision as of 12:40, 30 April 2020

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


Eldritch Knight Spells

Spells for the Warlock class.

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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 `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

Warlock spells for 5th ed. (official and unofficial).
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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `Spell`,`rly2_cargo__5e_Spell`.`Level` AS `Level`,`rly2_cargo__5e_Spell`.`School` AS `School`,`rly2_cargo__5e_Spell`.`Action_Type` AS `Casting`,`rly2_cargo__5e_Spell`.`Spell_Range` AS `Range`,`Component__full` AS `VSM`,`rly2_cargo__5e_Spell`.`Valuable_Component` AS `VC`,`rly2_cargo__5e_Spell`.`Consumable_Component` AS `CC`,`Casters__full` AS `Casters`,`rly2_cargo__5e_Spell`.`Canon_Spell` AS `Canon`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Sources and Notes

  • See individual spells for sources.
  1. Note: This level may only be cast using the Mystic Arcanum 1.0 1.1 1.2 1.3

Back to Main PageDnD5x5e (2014)ClassWarlock
  Varied Licenses
Caution
Varied
Licenses

This is article is covered by varying licenses, rather than the Creative Commons Attribution Sharealike License. Please see the Sources section for individual sources and licenses.