5e:Deity: Difference between revisions
(Created page with "<!--{{#cargo_declare: _table = 5e_Deity |Name = Text |Sort_Text = Text |Title = List (, ) of Text |Gender = Text |Portfolio = List (, ) of Text |Alignment = Text |Domains = Li...") |
mNo edit summary |
||
| Line 28: | Line 28: | ||
|join on=5e_Deity._pageName=Pages_Info._pageName | |join on=5e_Deity._pageName=Pages_Info._pageName | ||
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | ||
|fields=5e_Deity._pageName,5e_Deity.Name,5e_Deity.Title,5e_Deity.Gender,5e_Deity.Portfolio,5e_Deity.Alignment,5e_Deity.Domains,5e_Deity.Plane,5e_Deity.Symbol,5e_Deity.Pantheon,5e_Deity.Worshipers | |fields=5e_Deity._pageName,5e_Deity.Name,5e_Deity.Title,5e_Deity.Gender,5e_Deity.Portfolio,5e_Deity.Alignment,5e_Deity.Domains,5e_Deity.Plane,5e_Deity.Symbol,5e_Deity.Pantheon,5e_Deity.Worshipers,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources | ||
|order by=5e_Deity.Sort_Text | |order by=5e_Deity.Sort_Text | ||
}} | }} | ||
Revision as of 17:20, 14 June 2020
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Deity`.`_pageID` AS `cargo_backlink_page_id_5e_Deity`,COUNT(`rly2_cargo__5e_Deity`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Deity` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Deity`.`_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_Deity`.`_pageID`,COUNT(`rly2_cargo__5e_Deity`.`_pageName`) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Deity`.`_pageID` AS `cargo_backlink_page_id_5e_Deity`,`rly2_cargo__5e_Deity`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Deity`.`Name` AS `Name`,`Title__full` AS `Title`,`rly2_cargo__5e_Deity`.`Gender` AS `Gender`,`Portfolio__full` AS `Portfolio`,`rly2_cargo__5e_Deity`.`Alignment` AS `Alignment`,`Domains__full` AS `Domains`,`rly2_cargo__5e_Deity`.`Plane` AS `Plane`,`rly2_cargo__5e_Deity`.`Symbol` AS `Symbol`,`Pantheon__full` AS `Pantheon`,`Worshipers__full` AS `Worshipers`,`rly2_cargo__Pages_Info`.`Canon` AS `Canon`,`rly2_cargo__Pages_Info`.`Pointer` AS `Pointer`,`rly2_cargo__Pages_Info`.`UA` AS `UA`,`rly2_cargo__Pages_Info`.`User` AS `User`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Deity` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Deity`.`_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_Deity`.`Sort_Text` LIMIT 100
