5e:Bard/Spell List: Difference between revisions
No edit summary |
No edit summary |
||
Line 24: | Line 24: | ||
|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 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | |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, ']]' ) | |fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) , 5e_Spell.School, 5e_Spell.Ritual, 5e_Spell.Ritual, Pages_Info.Sources, Pages_Info.User, Pages_Info.Canon, Pages_Info.Pointer, Pages_Info.UA | ||
|format=list | |format=template | ||
|delimiter=<br /> | |template=5e Spell List Row | ||
<!--|format=list | |||
|delimiter=<br />--> | |||
|order by=5e_Spell.Sort_Text | |order by=5e_Spell.Sort_Text | ||
}} | }} | ||
Line 168: | Line 170: | ||
<references> | <references> | ||
<ref name="xan">{{Cite Pub|Xanathar's Guide to Everything}}</ref> | <ref name="xan">{{Cite Pub|Xanathar's Guide to Everything}}</ref> | ||
</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> |
Revision as of 13:38, 29 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, ']]' )`,`rly2_cargo__5e_Spell`.`School` AS `School`,`rly2_cargo__5e_Spell`.`Ritual` AS `Ritual`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User`,`rly2_cargo__Pages_Info`.`Canon` AS `Canon`,`rly2_cargo__Pages_Info`.`Pointer` AS `Pointer`,`rly2_cargo__Pages_Info`.`UA` AS `UA` 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
Notes
Spell Notes
a = Abjuration
c = Conjuration
d = Divination
en = Enchantment
ev = Evocation
i = Illusion
n = Necromancy
t = Transmutation
o = Other school
cn = Concentration
r = Ritual
can = Canon
p = Pointer
ua = Unearthed Arcana
uc = User Creation
Cite error: <ref>
tags exist for a group named "ua", but no corresponding <references group="ua"/>
tag was found