5e:Monster List: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
tables=5eMonster, Pages_Info | tables=5eMonster, Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where=(5eMonster.Hidden=0 OR 5eMonster.Hidden IS NULL) | |||
|fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Tags,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Hit_Dice=HD,5eMonster.Challenge_Rating=CR,5eMonster.Experience_Points=XP,5eMonster.Monster_Features=Features,5eMonster.Canon,5eMonster.Pointer | |fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Tags,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Hit_Dice=HD,5eMonster.Challenge_Rating=CR,5eMonster.Experience_Points=XP,5eMonster.Monster_Features=Features,5eMonster.Canon,5eMonster.Pointer,Pages_Info.User,Pages_Info.Sources | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
|limit=500 | |limit=500 | ||