5e:Bard/Spell List: Difference between revisions
m (→Bard Spells) |
|||
(10 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>'' | </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=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"|<!--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=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"|<!--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=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"|<!--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=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"|<!--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=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 | |||
}} | |||
|- | |- | ||
Line 113: | Line 83: | ||
|- | |- | ||
|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=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"|<!--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=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"|<!--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=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"|<!--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=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--> | ||
{{#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=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 /> | ||
< | <!-- | ||
===Notes=== | ===Notes=== | ||
===Spell Notes=== | |||
{{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 12:44, 1 January 2021
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`,`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 ofFunction: 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
Name | Level | School | Casting Time |
Range | Components | Casters | Source Notes |
Sources |
---|