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)=Letter, COUNT(_pageName)=Count
|fields=SUBSTRING(name,1,1)=L, COUNT(_pageName)=Count
|group by=Letter
|group by=L
|order by=Letter
|order by=L
|format=ul
|format=template
|template=AZRow
}}
}}

Revision as of 15:12, 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 `L`,COUNT(_pageName) AS `Count` FROM `mwhl_cargo__Veterans` `Veterans` GROUP BY `L` ORDER BY `L` LIMIT 100