Template:Franchise-page
From SABR Encyclopedia
(Difference between revisions)
(8 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= | + | |data=club=nameClub,teamID=teamID,year=year,league=nameLeague |
}} | }} | ||
{| class="wikitable" | {| class="wikitable" | ||
- | ! | + | ! Club |
- | ! | + | ! League |
- | + | {{#for_external_table:<nowiki/> | |
{{!}}- | {{!}}- | ||
- | {{!}} {{{ | + | {{!}} [[{{{year}}} {{{club}}}]] |
- | + | {{!}} [[{{{year}}} {{{league}}}]] }} | |
- | {{!}} | + | |
|} | |} | ||
[[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.