Template:Franchise-page

From SABR Encyclopedia

Revision as of 20:58, 12 February 2010 (edit) GarverP01 (Talk | contribs) ← Older edit		Latest revision as of 19:10, 17 February 2010 (edit) (undo) GarverP01 (Talk | contribs)
(5 intermediate revisions not shown)
Line 14:		Line 14:
	|-		|-
	|}		|}
		+	{{{Pagetext|}}}
		+	== Past {{PAGENAME}} teams ==
	{{#get_db_data:		{{#get_db_data:
	|server=minorsdev		|server=minorsdev
-	|from=teams	+	|from=teams,leagues
-	|where=key_retro_franch='{{{Retro}}}'	+	|where=teams.key_retro_franch='{{{Retro}}}' AND teams.leagueID = leagues.leagueID ORDER BY year DESC
-	|data=nick=nameNick,leagueID=leagueID,teamID=teamID	+	|data=club=nameClub,teamID=teamID,year=year,league=nameLeague
	}}		}}
	{| class="wikitable"		{| class="wikitable"
-	! Nickname	+	! Club
-	! LeagueID	+	! League
-	! TeamID {{#for_external_table:<nowiki/>	+	{{#for_external_table:<nowiki/>
	{{!}}-		{{!}}-
-	{{!}} {{{nick}}}	+	{{!}} [[{{{year}}} {{{club}}}]]
-	{{!}} {{{leagueID}}}	+	{{!}} [[{{{year}}} {{{league}}}]] }}
-	{{!}} {{{teamID}}} {{#ask: [[Team-key-sabr::{{{teamID}}}]]}} }}	+
	|}		|}
	[[Category:Franchises]]		[[Category:Franchises]]
	</includeonly>		</includeonly>

---

Latest revision as of 19:10, 17 February 2010

This is the 'Franchise-page' template. It should be called in the following format:

{{Franchise-page
|Retro=Retrosheet three letter franchise ID
}}

Edit the page to see the template text.