5e:Height and Weight: Difference between revisions
No edit summary |
m (Rlyehable moved page 5eh:Height and Weight to 5e:Height and Weight) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 23: | Line 23: | ||
<div class="badge">{{5evaried}}</div> | <div class="badge">{{5evaried}}</div> | ||
<div class="gi-main"> | <div class="gi-main"> | ||
{{#cargo_query: | |||
tables=5e_Height_Weight, Pages_Info | |||
|join on=5e_Height_Weight._pageName=Pages_Info._pageName | |||
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |||
|fields=COUNT(5e_Height_Weight._pageName) | |||
}} official and unofficial species. | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=5e_Height_Weight, Pages_Info | tables=5e_Height_Weight, Pages_Info | ||
Latest revision as of 12:36, 29 June 2020
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Height_Weight`.`_pageID` AS `cargo_backlink_page_id_5e_Height_Weight`,COUNT(`rly2_cargo__5e_Height_Weight`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Height_Weight` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Height_Weight`.`_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_Height_Weight`.`_pageID`,COUNT(`rly2_cargo__5e_Height_Weight`.`_pageName`) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Height_Weight`.`_pageID` AS `cargo_backlink_page_id_5e_Height_Weight`,CONCAT( '', `rly2_cargo__5e_Height_Weight`.`Species`, '' ) AS `Species`,`rly2_cargo__5e_Height_Weight`.`Base_Height` AS `Base Height`,`rly2_cargo__5e_Height_Weight`.`Base_Weight` AS `Base Weight`,`rly2_cargo__5e_Height_Weight`.`Height_Mod` AS `Height Mod`,`rly2_cargo__5e_Height_Weight`.`Weight_Mod` AS `Weight Mod`,`Avg_HW` AS `Average` FROM `rly2_cargo__5e_Height_Weight` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Height_Weight`.`_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_Height_Weight`.`Species` LIMIT 100
