5e:Monster List: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 7: | Line 7: | ||
tables=5eMonster, Pages_Info | tables=5eMonster, Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (5eMonster.Type <>"Overview") | <!--|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (5eMonster.Type <>"Overview")--> | ||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} {{srd5lc|Monster}}s | }} {{srd5lc|Monster}}s | ||
| Line 25: | Line 25: | ||
tables=5eMonster, Pages_Info | tables=5eMonster, Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._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=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources,Pages_Info.Hidden | |fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources,Pages_Info.Hidden | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||