Template:TeamMembers: Difference between revisions

Revision as of 08:59, 9 December 2023

@@ Line 10: / Line 10: @@
 {{#get_db_data:
 |server=drck-db
-|from=wikiyearsofteams
+|from=wikiteammembers
 |where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}') and (Year='{{#var:FindTeamYear}}')
-|order by=Year DESC
+|data=Initials=Initials,LastName=LastName
-|data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,Photo=Photo
 }}
 {| class="wikitable"
 {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} {{{Photo}}}
+{{!}} {{{Intials}}}{{{LastName}}}
 }}
 |}