A-Z Index: Difference between revisions
No edit summary |
No edit summary |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Veterans | tables=Veterans | ||
|fields=SUBSTRING( | |fields=UPPER(SUBSTRING(_pageName,1,1))=Letter, COUNT(_pageName)=Count | ||
|group by= | |where=UPPER(SUBSTRING(_pageName,1,1)) BETWEEN "A" AND "Z" | ||
|order by= | |group by=Letter | ||
|order by=Letter | |||
|format=template | |format=template | ||
|template=AZRow | |template=AZRow | ||
|named args=yes | |||
}} | }} | ||