Difference between revisions of "SalesChart"
From Sega Retro
| Line 18: | Line 18: | ||
Programmatically render sales charts. I have no idea how best to do this. -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 12:52, 18 August 2020 (EDT) | Programmatically render sales charts. I have no idea how best to do this. -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 12:52, 18 August 2020 (EDT) | ||
| − | {{SalesChart| | + | {{SalesChart|date=1992-xx-xx| |
{{SalesRow|Desert Strike: Return to the Gulf}} | {{SalesRow|Desert Strike: Return to the Gulf}} | ||
{{SalesRow|EA Hockey}} | {{SalesRow|EA Hockey}} | ||
| Line 32: | Line 32: | ||
}} | }} | ||
| + | {{SalesChart|date=1992-xx-xx|format=yes| | ||
| + | {{SalesRow|Desert Strike: Return to the Gulf|format=MD}} | ||
| + | {{SalesRow|EA Hockey|format=MD}} | ||
| + | {{SalesRow|PGA Tour Golf|format=MD}} | ||
| + | {{SalesRow|Rolling Thunder 2|format=SMS}} | ||
| + | {{SalesRow|Wonder Boy in Monster World|format=SMS}} | ||
| + | {{SalesRow|Krusty's Super Fun House|format=SMS}} | ||
| + | {{SalesRow|Pit-Fighter|format=NG}} | ||
| + | {{SalesRow|Arch Rivals|format=SAT}} | ||
| + | {{SalesRow|Kid Chameleon|format=SAT}} | ||
| + | {{SalesRow|Hellfire|format=XBOX}} | ||
| + | |ref={{magref|segapro|9|10}} | ||
| + | }} | ||
| + | |||
| + | {{SalesChart|date=1992-xx-xx|units=yes| | ||
| + | {{SalesRow|Desert Strike: Return to the Gulf|units=1000}} | ||
| + | {{SalesRow|EA Hockey|units=999}} | ||
| + | {{SalesRow|PGA Tour Golf|units=998}} | ||
| + | {{SalesRow|Rolling Thunder 2|units=700}} | ||
| + | {{SalesRow|Wonder Boy in Monster World|units=600}} | ||
| + | {{SalesRow|Krusty's Super Fun House|units=555}} | ||
| + | {{SalesRow|Pit-Fighter|units=444}} | ||
| + | {{SalesRow|Arch Rivals|units=33}} | ||
| + | {{SalesRow|Kid Chameleon|units=20}} | ||
| + | {{SalesRow|Hellfire|units=1}} | ||
| + | |ref={{magref|segapro|9|10}} | ||
| + | }} | ||
| + | |||
| + | {{SalesChart|date=1992-xx-xx|format=yes|units=yes| | ||
| + | {{SalesRow|Desert Strike: Return to the Gulf|format=MD|units=1000}} | ||
| + | {{SalesRow|EA Hockey|format=MD|units=999}} | ||
| + | {{SalesRow|PGA Tour Golf|format=MD|units=998}} | ||
| + | {{SalesRow|Rolling Thunder 2|format=SMS|units=700}} | ||
| + | {{SalesRow|Wonder Boy in Monster World|format=SMS|units=600}} | ||
| + | {{SalesRow|Krusty's Super Fun House|format=SMS|units=555}} | ||
| + | {{SalesRow|Pit-Fighter|format=NG|units=444}} | ||
| + | {{SalesRow|Arch Rivals|format=SAT|units=33}} | ||
| + | {{SalesRow|Kid Chameleon|format=SAT|units=20}} | ||
| + | {{SalesRow|Hellfire|format=XBOX|units=1}} | ||
| + | |ref={{magref|segapro|9|10}} | ||
| + | }} | ||
[[Category:Sega Retro templates]] | [[Category:Sega Retro templates]] | ||
</noinclude> | </noinclude> | ||
Revision as of 12:29, 20 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)
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)
}}
| Position | Previous | Name | |
|---|---|---|---|
| 1 |  |
{{ }} | Desert Strike: Return to the Gulf
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 2 | |
{{ }} | EA Hockey
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 3 | |
{{ }} | PGA Tour Golf
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 4 | |
{{ }} | Rolling Thunder 2
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 5 | |
{{ }} | Wonder Boy in Monster World
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 6 | |
{{ }} | Krusty's Super Fun House
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 7 | |
{{ }} | Pit-Fighter
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 8 | |
{{ }} | Arch Rivals
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 9 | |
{{ }} | Kid Chameleon
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 10 | |
{{ }} | Hellfire |
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)
}}
| Position | Previous | Format | Name | |
|---|---|---|---|---|
| 1 | |
 |
Desert Strike: Return to the Gulf
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 2 | |
|
EA Hockey
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 3 | |
|
PGA Tour Golf
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 4 | |
 |
Rolling Thunder 2
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 5 | |
|
Wonder Boy in Monster World
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 6 | |
|
Krusty's Super Fun House
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 7 | |
 |
Pit-Fighter
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 8 | |
 |
Arch Rivals
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 9 | |
|
Kid Chameleon
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 10 | |
 |
Hellfire |
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)
}}
| Position | Previous | Name | Units | |
|---|---|---|---|---|
| 1 | |
{{ }} | Desert Strike: Return to the Gulf | 1000
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 2 | |
{{ }} | EA Hockey | 999
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 3 | |
{{ }} | PGA Tour Golf | 998
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 4 | |
{{ }} | Rolling Thunder 2 | 700
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 5 | |
{{ }} | Wonder Boy in Monster World | 600
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 6 | |
{{ }} | Krusty's Super Fun House | 555
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 7 | |
{{ }} | Pit-Fighter | 444
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 8 | |
{{ }} | Arch Rivals | 33
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 9 | |
{{ }} | Kid Chameleon | 20
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} |
| 10 | |
{{ }} | Hellfire | 1 |
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)
}}
| Position | Previous | Format | Name | Units | |
|---|---|---|---|---|---|
| 1 | |
|
Desert Strike: Return to the Gulf | 1000
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 2 | |
|
EA Hockey | 999
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 3 | |
|
PGA Tour Golf | 998
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 4 | |
|
Rolling Thunder 2 | 700
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 5 | |
|
Wonder Boy in Monster World | 600
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 6 | |
|
Krusty's Super Fun House | 555
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 7 | |
|
Pit-Fighter | 444
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 8 | |
|
Arch Rivals | 33
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 9 | |
|
Kid Chameleon | 20
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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)
}} | |
| 10 | |
|
Hellfire | 1 |