Jump to content

Index-L: Difference between revisions

From Iwo Jima Legacy Project
Newer edit →
undoDonaldson (talk | contribs)
Bureaucrats, Interface administrators, Administrators
142 edits
Created page with "== Veterans — L == {{#cargo_query: tables=Veterans |fields=_pageName=Name |where=_pageName LIKE "L%" |order by=_pageName |format=ul }}"
 
List veterans by surname (Last, First), filtered/sorted by last name
Line 3: Line 3:
{{#cargo_query:
{{#cargo_query:
tables=Veterans
tables=Veterans
|fields=_pageName=Name
|fields=_pageName=Page, SUBSTRING_INDEX(_pageName,' ',-1)=Last, TRIM(SUBSTRING(_pageName,1,CHAR_LENGTH(_pageName)-CHAR_LENGTH(SUBSTRING_INDEX(_pageName,' ',-1))))=First
|where=_pageName LIKE "L%"
|where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "L%"
|order by=_pageName
|order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName
|format=ul
|format=template
|template=VetRow
|named args=yes
}}
}}

Revision as of 10:38, 20 July 2026

Veterans — L

Retrieved from "https://iwojimaassociation.org/legacy/index.php?title=Index-L&oldid=6795"