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}}}"
+
|where=chartname="{{{chartname|{{PAGENAME}}}}}" and gamename="{{{1|}}}" and format="{{{2|unknown}}}" and date < {{#var:currentdate}}
 
|order by=date DESC
 
|order by=date DESC
 
|format=template
 
|format=template
 
|template=SalesRow/GetLast/Cargo
 
|template=SalesRow/GetLast/Cargo
}}</div></includeonly><noinclude>[[Category:Cargo templates]]</noinclude>
+
}}</div></includeonly><noinclude>
 +
 
 +
 
 +
{{#vardefine:currentdate|20020605}}
 +
{{SalesRow/GetLast|Shenmue II|DC|chartname=Dreamcast French charts}}
 +
{{#var:last}}
 +
 
 +
[[Category:Cargo templates]]</noinclude>

Revision as of 12:50, 4 May 2022



Expression error: Missing operand for >.

0