Difference between revisions of "Black Squirrel/Cargo"
From Sega Retro
(I can never remember the syntax) |
|||
Line 7: | Line 7: | ||
|template=RomDumpListRow | |template=RomDumpListRow | ||
}}</pre> | }}</pre> | ||
+ | |||
+ | ==testing== | ||
+ | {{#cargo_query: | ||
+ | table=releases,missedreleases | ||
+ | |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" | ||
+ | |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