5e:Bard/Spell List: Difference between revisions
No edit summary |
No edit summary |
||
Line 6: | Line 6: | ||
<div class="gi-main"> | <div class="gi-main"> | ||
==Bard Spells== | ==Bard Spells== | ||
</noinclude>'' | </noinclude>''{{#cargo_query: | ||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=COUNT(5e_Spell._pageName) | |||
}} spells for the [[SRD5:Bard|Bard]] class.'' | |||
{|class="zebra sortable small" | {|class="zebra sortable small" | ||
!Cantrips<br />(0 Level) | !Cantrips<br />(0 Level) | ||
Line 15: | Line 20: | ||
|- | |- | ||
|valign="top"|<!--Cantrips--> | |valign="top"|<!--Cantrips--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
'' | |fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | ||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
---- | |||
''{{5edlc|Thunderclap}}'' <ref name="xan" /><br /> | ''{{5edlc|Thunderclap}}'' <ref name="xan" /><br /> | ||
|valign="top"|<!--1st Level--> | |valign="top"|<!--1st Level--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
'' | |fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | ||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
---- | |||
''{{5edlc|Guiding Hand}}'' <ref group="ua" name="starter" /> <sup>{{iplink|Notes|[r]}}</sup><br /> | ''{{5edlc|Guiding Hand}}'' <ref group="ua" name="starter" /> <sup>{{iplink|Notes|[r]}}</sup><br /> | ||
''{{5edlc|Puppet}}'' <ref group="ua" name="starter" /><br /> | ''{{5edlc|Puppet}}'' <ref group="ua" name="starter" /><br /> | ||
''{{5edlc|Sense Emotion}}'' <ref group="ua" name="starter" /><br /> | ''{{5edlc|Sense Emotion}}'' <ref group="ua" name="starter" /><br /> | ||
''{{5edlc|Sudden Awakening}}'' <ref group="ua" name="starter" /><br /> | ''{{5edlc|Sudden Awakening}}'' <ref group="ua" name="starter" /><br /> | ||
''{{5edlc|Unearthly Chorus}}'' <ref group="ua" name="starter" /><br /> | ''{{5edlc|Unearthly Chorus}}'' <ref group="ua" name="starter" /><br /> | ||
|valign="top"|<!--2nd Level--> | |valign="top"|<!--2nd Level--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
'' | }} | ||
---- | |||
''{{5edlc|Pyrotechnics}}'' <ref name="xan" /><br /> | ''{{5edlc|Pyrotechnics}}'' <ref name="xan" /><br /> | ||
''{{5edlc|Skywrite}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br /> | ''{{5edlc|Skywrite}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br /> | ||
''{{5edlc|Warding Wind}}'' <ref name="xan" /><br /> | ''{{5edlc|Warding Wind}}'' <ref name="xan" /><br /> | ||
|valign="top"|<!--3rd Level--> | |valign="top"|<!--3rd Level--> | ||
'' | {{#cargo_query: | ||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
---- | |||
''{{5edlc|Catnap}}'' <ref name="xan" /><br /> | ''{{5edlc|Catnap}}'' <ref name="xan" /><br /> | ||
''{{5edlc|Enemies Abound}}'' <ref name="xan" /><br /> | ''{{5edlc|Enemies Abound}}'' <ref name="xan" /><br /> | ||
|valign="top"|<!--4th Level--> | |valign="top"|<!--4th Level--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
---- | |||
''{{5edlc|Charm Monster}}'' <ref name="xan" /><br /> | ''{{5edlc|Charm Monster}}'' <ref name="xan" /><br /> | ||
|- | |- | ||
Line 124: | Line 100: | ||
|- | |- | ||
|valign="top"|<!--5th Level--> | |valign="top"|<!--5th Level--> | ||
{{#cargo_query: | |||
'' | table=5e_Spell, Pages_Info | ||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
---- | |||
''{{5edlc|Earth Tremor}}'' <ref name="xan" /><br /> | ''{{5edlc|Earth Tremor}}'' <ref name="xan" /><br /> | ||
''{{5edlc|Skill Empowerment}}'' <ref name="xan" /><br /> | ''{{5edlc|Skill Empowerment}}'' <ref name="xan" /><br /> | ||
''{{5edlc|Synaptic Static}}'' <ref name="xan" /><br /> | ''{{5edlc|Synaptic Static}}'' <ref name="xan" /><br /> | ||
|valign="top"|<!--6th Level--> | |valign="top"|<!--6th Level--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
'' | |join on=5e_Spell._pageName=Pages_Info._pageName | ||
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
|valign="top"|<!--7th Level--> | |valign="top"|<!--7th Level--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
|join on=5e_Spell._pageName=Pages_Info._pageName | |||
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
|valign="top"|<!--8th Level--> | |valign="top"|<!--8th Level--> | ||
{{#cargo_query: | |||
table=5e_Spell, Pages_Info | |||
'' | |join on=5e_Spell._pageName=Pages_Info._pageName | ||
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
|valign="top"|<!--9th Level--> | |valign="top"|<!--9th Level--> | ||
'' | {{#cargo_query: | ||
table=5e_Spell, Pages_Info | |||
|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=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |||
|format=list | |||
|delimiter=<br /> | |||
|order by=5e_Spell.Sort_Text | |||
}} | |||
---- | |||
''{{5edlc|Mass Polymorph}}'' <ref name="xan" /><br /> | ''{{5edlc|Mass Polymorph}}'' <ref name="xan" /><br /> | ||
''{{5edlc|Psychic Scream}}'' <ref name="xan" /><br /> | ''{{5edlc|Psychic Scream}}'' <ref name="xan" /><br /> | ||
|} | |} | ||
Line 187: | Line 167: | ||
==Sources== | ==Sources== | ||
<references> | <references> | ||
<ref name="xan">{{Cite Pub|Xanathar's Guide to Everything}}</ref> | |||
<ref name="xan">{{ | |||
</references> | </references> | ||
===Unearthed Arcana=== | ===Unearthed Arcana=== | ||
''Unearthed Arcana spells are at the GM's discression'' | ''Unearthed Arcana spells are at the GM's discression'' | ||
<references group="ua"> | <references group="ua"> | ||
<ref group="ua" name="starter">{{ | <ref group="ua" name="starter">{{Cite Pub|UA Starter Spells}}</ref> | ||
</references> | </references> | ||
===User Creations=== | ===User Creations=== |
Revision as of 16:30, 27 April 2020
Bard Spells
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`= 'Bard') ) 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
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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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 guiding hand [ua 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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 |
Sources
Unearthed Arcana
Unearthed Arcana spells are at the GM's discression
- Wizards RPG Team. UA Starter Spells (5e 2014) (2017.04.03). Wizards of the Coast. ↑ 1.0 1.1 1.2 1.3 1.4
User Creations
Cite error: <ref>
tag with name "rly" defined in <references>
has group attribute "uc" which does not appear in prior text.
Notes
- [r] These spells may be cast as rituals.