5e:Height and Weight: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 26: Line 26:
tables=5e_Height_Weight, Pages_Info
tables=5e_Height_Weight, Pages_Info
|join on=5e_Height_Weight._pageName=Pages_Info._pageName
|join on=5e_Height_Weight._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=COUNT(5e_Height_Weight._pageName)
}} official and unofficial species.
{{#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=CONCAT( '[[', 5e_Height_Weight._pageName, '|', 5e_Height_Weight.Species, ']]' )=Species,5e_Height_Weight.Base_Height,5e_Height_Weight.Base_Weight,5e_Height_Weight.Height_Mod,5e_Height_Weight.Weight_Mod,Avg_HW=Average
|fields=CONCAT( '[[', 5e_Height_Weight._pageName, '|', 5e_Height_Weight.Species, ']]' )=Species,5e_Height_Weight.Base_Height,5e_Height_Weight.Base_Weight,5e_Height_Weight.Height_Mod,5e_Height_Weight.Weight_Mod,Avg_HW=Average
|order by=5e_Height_Weight.Species
|order by=5e_Height_Weight.Species

Revision as of 20:13, 28 June 2020


D&D 5e (2014) Varied ʰ 
See sections for licenses


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_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

official and unofficial species.
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_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

Sources and Notes

See individual entry


Back to Main PageDnD5x5e (2014)Race
  Varied Licenses
Caution
Varied
Licenses

This is article is covered by varying licenses, rather than the Creative Commons Attribution Sharealike License. Please see the Sources section for individual sources and licenses.