A-Z Index: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
tables=Veterans | tables=Veterans | ||
|fields=SUBSTRING(name,1,1)=Letter, COUNT(_pageName)=Count | |fields=SUBSTRING(name,1,1)=Letter, COUNT(_pageName)=Count | ||
|where=SUBSTRING(name,1,1) REGEXP "^[A-Z]" | |||
|group by=Letter | |group by=Letter | ||
|order by=Letter | |order by=Letter | ||
Revision as of 15:17, 19 February 2026
Iwo Jima Veterans Index
Error 1054: Unknown column 'name' in 'field list'
Function: CargoSQLQuery::run Query: SELECT SUBSTRING(name,1,1) AS `Letter`,COUNT(_pageName) AS `Count` FROM `mwhl_cargo__Veterans` `Veterans` WHERE SUBSTRING(name,1,1) REGEXP "^[A-Z]" GROUP BY `Letter` ORDER BY `Letter` LIMIT 100