A-Z Index: Difference between revisions
Created page with "== Iwo Jima Veterans Index == {{#cargo_query: tables=Veterans |fields=CONCAT('', SUBSTRING(name,1,1), '')=Letter, COUNT(*)=Count |group by=SUBSTRING(name,1,1) |order by=SUBSTRING(name,1,1) |format=ul }}" |
No edit summary |
||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Veterans | tables=Veterans | ||
|fields= | |fields=SUBSTRING(name,1,1)=Letter, COUNT(_pageName)=Count | ||
|group by= | |group by=Letter | ||
|order by= | |order by=Letter | ||
|format=ul | |format=ul | ||
}} | }} | ||
Revision as of 15:11, 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