A-Z Index: Difference between revisions

Revision as of 15:25, 19 February 2026

Error: The SQL function "SUBSTRING_INDEX()" is not allowed.

@@ 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