Jump to content

A-Z Index: Difference between revisions

From Iwo Jima Legacy Project
No edit summary
No edit summary
Line 3: Line 3:
{{#cargo_query:
{{#cargo_query:
tables=Veterans
tables=Veterans
|fields=SUBSTRING(name,1,1)=L, COUNT(_pageName)=Count
|fields=SUBSTRING(name,1,1)=Letter, COUNT(_pageName)=Count
|group by=L
|group by=Letter
|order by=L
|order by=Letter
|format=template
|format=ul
|template=AZRow
|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