Difference between revisions of "Black Squirrel/Cargo"

From Sega Retro
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<pre>{{#cargo_query:
 +
table=roms
 +
|fields=name,sha1,md5,crc32,size,date,source,comments
 +
|where=format="SMS" AND (prototype IS NULL OR prototype != "yes")
 +
|limit=10000
 +
|format=template
 +
|template=RomDumpListRow
 +
}}</pre>
 +
 +
==testing==
 
{{#cargo_query:
 
{{#cargo_query:
−
table=ratings_table
+
table=releases,missedreleases
−
|fields=page,average,totalReviews
+
|fields=releases.name="name1",releases.console="format1",releases.region="region1",missedreleases.name="name2",missedreleases.format="format2",missedreleases.region="region2",releases.date="release date",missedreleases.date="missed date"
−
|format=table
+
|where=releases.console="MD" and missedreleases.format="MD"
 +
|join on=releases.name=missedreleases.name
 +
|limit=10000
 
}}
 
}}
 +
 +
TODO: determine whether a game was not released in a certain region
 +
 +
which is too much of a faff at 10:45 in the evening

Latest revision as of 17:42, 20 April 2022

{{#cargo_query:
table=roms
|fields=name,sha1,md5,crc32,size,date,source,comments
|where=format="SMS" AND (prototype IS NULL OR prototype != "yes")
|limit=10000
|format=template
|template=RomDumpListRow
}}

testing

"name1" "format1" "region1" "name2" "format2" "region2" "release date" "missed date"
Shinobi III: Return of the Ninja Master MD AS Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD AU Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD AU_[[Sega Gold Collection|Gold]][[Category:Sega Gold Collection games]] Shinobi III: Return of the Ninja Master MD JP 1994 1992-12
Shinobi III: Return of the Ninja Master MD BR Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD DE Shinobi III: Return of the Ninja Master MD JP 1993 1992-12
Shinobi III: Return of the Ninja Master MD EU Shinobi III: Return of the Ninja Master MD JP 1993 1992-12
Shinobi III: Return of the Ninja Master MD EU_[[Classic Mega Drive|Classic]][[Category:Classic Mega Drive games]] Shinobi III: Return of the Ninja Master MD JP 1994-08-19 1992-12
Shinobi III: Return of the Ninja Master MD JP Shinobi III: Return of the Ninja Master MD JP 1993-07-23 1992-12
Shinobi III: Return of the Ninja Master MD KR Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD SE_Rental Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD UK Shinobi III: Return of the Ninja Master MD JP 1993-11 1992-12
Shinobi III: Return of the Ninja Master MD US Shinobi III: Return of the Ninja Master MD JP 1993-09 1992-12

TODO: determine whether a game was not released in a certain region

which is too much of a faff at 10:45 in the evening

Retrieved from "https://segaretro.org/index.php?title=User:Black_Squirrel/Cargo&oldid=770924"