A-Z Index: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Veterans | tables=Veterans | ||
|fields=SUBSTRING(name,1,1)= | |fields=SUBSTRING(name,1,1)=Letter, COUNT(_pageName)=Count | ||
|group by= | |group by=Letter | ||
|order by= | |order by=Letter | ||
|format= | |format=ul | ||
| | |link=none | ||
}} | }} | ||
Revision as of 15:14, 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` GROUP BY `Letter` ORDER BY `Letter` LIMIT 100