A-Z Index: Difference between revisions

Revision as of 15:25, 19 February 2026

Error 1054: Unknown column 'name' in 'field list'

Function: CargoSQLQuery::run Query: SELECT SUBSTRING_INDEX(name,' ',-1) AS `Letter`,COUNT(_pageName) AS `Count` FROM `mwhl_cargo__Veterans` `Veterans` GROUP BY `Letter` ORDER BY `Letter` LIMIT 100

@@ Line 1: / Line 1: @@
-== Iwo Jima Veterans Index ==
 {{#cargo_query:
 tables=Veterans
-|fields=SUBSTRING(last_name,1,1)=Letter, COUNT(_pageName)=Count
+|fields=SUBSTRING_INDEX(name,' ',-1)=Letter, COUNT(_pageName)=Count
 |group by=Letter
 |order by=Letter