A-Z Index: Difference between revisions
No edit summary |
Group index by surname initial instead of first name |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Veterans | tables=Veterans | ||
|fields=UPPER(SUBSTRING(_pageName,1,1))=Letter, COUNT(_pageName)=Count | |fields=UPPER(SUBSTRING(SUBSTRING_INDEX(_pageName,' ',-1),1,1))=Letter, COUNT(_pageName)=Count | ||
|where=UPPER(SUBSTRING(SUBSTRING_INDEX(_pageName,' ',-1),1,1)) BETWEEN "A" AND "Z" | |||
|group by=Letter | |group by=Letter | ||
|order by=Letter | |order by=Letter | ||