A-Z Index: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
tables=Veterans | tables=Veterans | ||
|fields=UPPER(SUBSTRING(_pageName,1,1))=Letter, COUNT(_pageName)=Count | |fields=UPPER(SUBSTRING(_pageName,1,1))=Letter, COUNT(_pageName)=Count | ||
|where=UPPER(SUBSTRING(_pageName,1,1)) BETWEEN "A" AND "Z" | |||
|group by=Letter | |group by=Letter | ||
|order by=Letter | |order by=Letter | ||