Difference between revisions of "SalesChart"
From Sega Retro
| Line 1: | Line 1: | ||
| − | <includeonly>{{#vardefine:currentdate|{{{date|}}}}}{|class="prettytable sortable"| | + | <includeonly>{{#vardefine:currentdate|{{#replace:{{#replace:{{{date|}}}|x|0}}|-|}}{|class="prettytable sortable"| |
|+{{{date}}} | |+{{{date}}} | ||
|- | |- | ||
Revision as of 09:46, 21 August 2020
 |
This task is unfinished This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed. |
Programmatically render sales charts. I have no idea how best to do this. -Black Squirrel (talk) 12:52, 18 August 2020 (EDT)
{{#vardefine:currentdate|19920101{|class="prettytable sortable"| |+1992-01-01 |- !Position !Previous
!Name
!class="unsortable"|Change
|-
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Desert Strike: Return to the Gulf" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|1
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Desert Strike: Return to the Gulf
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="EA Hockey" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|2
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="PGA Tour Golf" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|3
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Rolling Thunder 2" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|4
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Wonder Boy in Monster World" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|5
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Krusty's Super Fun House" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|6
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Pit-Fighter" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|7
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Arch Rivals" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|8
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Kid Chameleon" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|9
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Hellfire" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|10
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|} [1]
{{#vardefine:currentdate|19920202{|class="prettytable sortable"|
|+1992-02-02
|-
!Position
!Previous
!Format
!Name
!class="unsortable"|Change
|-
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Desert Strike: Return to the Gulf" and format="MD" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|1
|style="text-align:center;"|
||style="text-align:center;"|
|Desert Strike: Return to the Gulf
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Kid Chameleon" and format="SAT" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|2
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="EA Hockey" and format="MD" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|3
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Krusty's Super Fun House" and format="SMS" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|4
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="PGA Tour Golf" and format="MD" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|5
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Pit-Fighter" and format="NG" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|6
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Rolling Thunder 2" and format="SMS" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|7
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Wonder Boy in Monster World" and format="SMS" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|8
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Arch Rivals" and format="SAT" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|9
|style="text-align:center;"|
||style="text-align:center;"|
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Hellfire" and format="XBOX" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|10
|style="text-align:center;"|
||style="text-align:center;"|
|} [1]
{{#vardefine:currentdate|19920303{|class="prettytable sortable"|
|+1992-03-03
|-
!Position
!Previous
!Name !Units !class="unsortable"|Change
|-
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Desert Strike: Return to the Gulf" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|1
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Desert Strike: Return to the Gulf||style="text-align:right;"|1000
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="EA Hockey" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|2
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|EA Hockey||style="text-align:right;"|999
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="PGA Tour Golf" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|3
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|PGA Tour Golf||style="text-align:right;"|998
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Rolling Thunder 2" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|4
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Rolling Thunder 2||style="text-align:right;"|700
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Wonder Boy in Monster World" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|5
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Wonder Boy in Monster World||style="text-align:right;"|600
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Krusty's Super Fun House" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|6
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Krusty's Super Fun House||style="text-align:right;"|555
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Pit-Fighter" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|7
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Pit-Fighter||style="text-align:right;"|444
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Arch Rivals" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|8
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Arch Rivals||style="text-align:right;"|33
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Kid Chameleon" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|9
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Kid Chameleon||style="text-align:right;"|20
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Hellfire" and format="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|10
|style="text-align:center;"|
||style="text-align:center;"|{{ }}
|Hellfire||style="text-align:right;"|1
|} [1]
{{#vardefine:currentdate|19920404{|class="prettytable sortable"|
|+1992-04-04
|-
!Position
!Previous
!Format
!Name
!Units
!class="unsortable"|Change
|-
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Krusty's Super Fun House" and format="SMS" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|1
|style="text-align:center;"|
||style="text-align:center;"|
|Krusty's Super Fun House||style="text-align:right;"|555
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Pit-Fighter" and format="NG" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|2
|style="text-align:center;"|
||style="text-align:center;"|
|Pit-Fighter||style="text-align:right;"|444
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Arch Rivals" and format="SAT" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|3
|style="text-align:center;"|
||style="text-align:center;"|
|Arch Rivals||style="text-align:right;"|33
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Rolling Thunder 2" and format="SMS" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|4
|style="text-align:center;"|
||style="text-align:center;"|
|Rolling Thunder 2||style="text-align:right;"|700
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="EA Hockey" and format="MD" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|5
|style="text-align:center;"|
||style="text-align:center;"|
|EA Hockey||style="text-align:right;"|999
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="PGA Tour Golf" and format="MD" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|6
|style="text-align:center;"|
||style="text-align:center;"|
|PGA Tour Golf||style="text-align:right;"|998
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Desert Strike: Return to the Gulf" and format="MD" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|7
|style="text-align:center;"|
||style="text-align:center;"|
|Desert Strike: Return to the Gulf||style="text-align:right;"|1000
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Wonder Boy in Monster World" and format="SMS" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|8
|style="text-align:center;"|
||style="text-align:center;"|
|Wonder Boy in Monster World||style="text-align:right;"|600
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Kid Chameleon" and format="SAT" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|9
|style="text-align:center;"|
||style="text-align:center;"|
|Kid Chameleon||style="text-align:right;"|20
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
Query: SELECT `position` AS `position`,`date` AS `date` FROM `cargo__salescharts` WHERE chartname="" and gamename="Hellfire" and format="XBOX" and date < ORDER BY `date` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `date` DESC LIMIT 100' at line 1 (localhost)
}}
|- |style="text-align:center;"|10
|style="text-align:center;"|
||style="text-align:center;"|
|Hellfire||style="text-align:right;"|1
|} [1]