5e:Spell List: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
<div class="gi-main"> | <div class="gi-main"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=5e_Spell, Pages_Info | |||
|fields=COUNT(_pageName) | |join on=5e_Spell._pageName=Pages_Info._pageName | ||
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |||
|fields=COUNT(5e_Spell._pageName) | |||
}} {{srd5lc|Spell}}s | }} {{srd5lc|Spell}}s | ||
<div style="overflow:auto; width:98%; font-size:0.8em;"> | <div style="overflow:auto; width:98%; font-size:0.8em;"> | ||
| Line 12: | Line 14: | ||
tables=5e_Spell,Pages_Info | tables=5e_Spell,Pages_Info | ||
|join on=5e_Spell._pageName=Pages_Info._pageName | |join on=5e_Spell._pageName=Pages_Info._pageName | ||
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )=Spell,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, 5e_Spell.Canon_Spell=Canon,Pages_Info.Sources | |fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )=Spell,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, 5e_Spell.Canon_Spell=Canon,Pages_Info.Sources | ||
|order by=5e_Spell.Sort_Text | |order by=5e_Spell.Sort_Text | ||
Revision as of 05:29, 23 April 2020
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__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
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__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100