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|}}}" and format="{{{2|unknown}}}" and date < "{{#var: | + | |where=chartname="{{{chartname|{{PAGENAME}}}}}" and gamename="{{{1|}}}" and format="{{{2|unknown}}}" and date < "{{#var:currentdate}}" |
|limit=1 | |limit=1 | ||
|order by=date DESC | |order by=date DESC | ||
| Line 9: | Line 9: | ||
}}</div></includeonly><noinclude> | }}</div></includeonly><noinclude> | ||
| − | {{#vardefine: | + | {{#vardefine:currentdate|19920203}} |
{{SalesRow/GetLast|chartname=SalesChart|Hellfire|XBOX}} | {{SalesRow/GetLast|chartname=SalesChart|Hellfire|XBOX}} | ||
{{#var:last}} | {{#var:last}} | ||
[[Category:Cargo templates]]</noinclude> | [[Category:Cargo templates]]</noinclude> | ||
Revision as of 09:06, 21 August 2020