Difference between revisions of "GetEarliestRelease"

From Sega Retro

(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<div style="display:none;">{{#cargo_query:table=releases
+
<includeonly><div style="display:none">{{#vardefine:formattedName|{{FormatSQL|{{{1|}}}}}}}{{#vardefine:lowestValue|9999}}{{#cargo_query:table=releases
 
|fields=date
 
|fields=date
|where=name="{{#replace:{{{1}}}|"|""}}" AND console="{{{2}}}"
+
|where=name="{{#var:formattedName}}" AND console="{{{2|}}}"
 
|format=template
 
|format=template
|template=CargoResult
+
|template=CargoLowest
}}{{#vardefine:lowestValue|9999}}{{#vardefine:currentLine|NULL}}{{#vardefine:i|0}}{{#while:
+
}}</div>{{#var:lowestValue}}</includeonly><noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}
| {{#ifexpr:{{#len:{{#var:currentLine}}}} > 3|true|}}
 
| {{#vardefine:currentLine|{{#explode:{{#var:cargoResult}}| |{{#var:i}}}}}}{{incvar|i}}
 
{{#vardefine:valueToCheck|{{#sub:{{#var:currentLine}}|0|4}}}}
 
{{#ifexpr:{{#len:{{#var:valueToCheck}}}} = 4|
 
{{#ifexpr: {{#var:valueToCheck}} < {{#var:lowestValue}}|{{#vardefine:lowestValue|{{#var:valueToCheck}}}}|}}
 
|}}
 
|}}</div>{{#var:lowestValue}}{{#vardefine:cargoResult|9999}}<noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}
 
  
{{GetEarliestRelease|Evander Holyfield's "Real Deal" Boxing|MD}}[[Category:Sega Retro templates]]</noinclude>
+
{{GetEarliestRelease|Evander Holyfield's "Real Deal" Boxing|MD}}
 +
 
 +
{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}
 +
 
 +
{{ProductionHistory|Jun Senoue|JunJun|瀬上 純}}
 +
 
 +
[[Category:Sega Retro templates]]</noinclude>

Revision as of 13:59, 23 May 2021

2001

1992



  • Sega TV Game Genga Gallery, Graphic Sha, page 35
  • Sega TV Game Genga Gallery, Graphic Sha, page 30
  • File:SkyTarget Saturn JP SSEnding.pdf
  • File:IntheHunt_Saturn_JP_SSEnding.pdf
  • File:SARemix CD JP booklet.pdf, page 9
  • File:SADLCOST CD JP booklet1.pdf, page 2
  • File:ThrilloftheFeel CD JP booklet.pdf, page 10
  • File:CutsUnleashed CD JP front.pdf, page 3
  • File:MDSA2OST poster1.pdf, page 1
  • 10.0 10.1 10.2 File:SA2OST CD US booklet.pdf, page 10
  • 11.0 11.1 File:Crush40 CD US back.png
  • File:TripleThreat CD JP booklet.pdf, page 2
  • File:CompleteTrinity CD JP booklet.pdf, page 8
  • File:StHOriginalSoundtrax CD JP booklet.pdf, page 2
  • 15.0 15.1 File:LostandFound CD JP booklet.pdf, page 6
  • 16.0 16.1 File:StHOST CD JP booklet.pdf, page 6
  • File:SeveralWIlls CD JP booklet.pdf, page 15
  • File:TrueBlue CD JP booklet.pdf, page 5
  • File:PlanetaryPieces CD JP booklet.pdf, page 10
  • File:LGATVGDUSAAB Music JP inlay back.jpg
  • 21.0 21.1 File:TalesofKnighthood CD JP booklet.pdf, page 10
  • 22.0 22.1 File:FacetoFaith CD JP booklet.pdf, page 11
  • File:Crush40SuperSonicSongsTray.jpg
  • File:TrueColorsTray.jpg
  • File:SFROST CD JP booklet.pdf, page 3
  • File:VividSound CD JP booklet.pdf, page 18
  • File:MDLAH Music JP inlay front.png
  • File:SonicCD OST Tray.jpg
  • File:Sonic Generations Original Soundtrack Tray.jpg
  • File:RiseAgainTray.jpg
  • File:Live! CD JP booklet.pdf, page 15
  • File:SLWOSTWB CD JP booklet.pdf, page 22
  • 33.0 33.1 File:SonicAdventureMusicExperience CD JP Box Tokyo.jpg
  • File:SMPOST CD JP booklet.pdf, page 3
  • File:MaximumOverdrive CD JP inlay front.jpg