Difference between revisions of "SalesRow/GetLast"
From Sega Retro
| Line 2: | Line 2: | ||
table=salescharts | table=salescharts | ||
|fields=position,date | |fields=position,date | ||
| − | |where=chartname="{{{chartname|{{PAGENAME}}}}}" and gamename="{{{1|}}}" | + | |where=chartname="{{{chartname|{{PAGENAME}}}}}" and gamename="{{{1|}}}" and format="{{{2|unknown}}}" and date < "{{#var:date}}" |
|limit=1 | |limit=1 | ||
|order by=date DESC | |order by=date DESC | ||
| Line 10: | Line 10: | ||
{{#vardefine:date|1992-02-03}} | {{#vardefine:date|1992-02-03}} | ||
| − | {{SalesRow/GetLast|chartname=SalesChart|Hellfire}} | + | {{SalesRow/GetLast|chartname=SalesChart|Hellfire|XBOX}} |
{{#var:last}} | {{#var:last}} | ||
[[Category:Cargo templates]]</noinclude> | [[Category:Cargo templates]]</noinclude> | ||
Revision as of 08:22, 21 August 2020