Difference between revisions of "List of games exclusive to retail copies"
(initial implementation. Only Steam is omitted from being checked historically due to Cargo failing if the query becomes too large) |
m (→top: General maintenance with AutoWikiBrowser in Bot mode) |
||
(7 intermediate revisions by 3 users not shown) | |||
Line 4: | Line 4: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
− | |where=Availability.Available_from HOLDS 'Retail' AND Availability.Available_from HOLDS NOT 'GOG.com' AND Availability.Available_from HOLDS NOT ' | + | |where= |
+ | Availability.Available_from HOLDS 'Retail' | ||
+ | AND Availability.Available_from HOLDS NOT 'GOG.com' | ||
+ | AND Availability.Available_from HOLDS NOT 'itch.io' | ||
+ | AND Availability.Available_from HOLDS NOT 'Mac App Store' | ||
+ | AND Availability.Available_from HOLDS NOT 'Oculus Store' | ||
+ | AND Availability.Available_from HOLDS NOT 'Viveport' | ||
+ | AND Availability.Available_from HOLDS NOT 'Humble Store' | ||
+ | AND Availability.Available_from HOLDS NOT 'Battle.net' | ||
+ | AND Availability.Available_from HOLDS NOT 'Zoom Platform' | ||
+ | AND Availability.Available_from HOLDS NOT 'Amazon US' | ||
+ | AND Availability.Available_from HOLDS NOT 'Amazon UK' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'GOG.com' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Microsoft Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Epic Games Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Ubisoft Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'EA Desktop' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Publisher website' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Official website' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Developer website' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Steam' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Humble Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'GamersGate' | ||
}} | }} | ||
Line 10: | Line 32: | ||
tables=Infobox_game,Availability | tables=Infobox_game,Availability | ||
|join on=Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=Availability._pageName | ||
− | |where=Availability.Available_from HOLDS 'Retail' AND Availability.Available_from HOLDS NOT 'GOG.com' AND Availability.Available_from HOLDS NOT ' | + | |where= |
+ | Availability.Available_from HOLDS 'Retail' | ||
+ | AND Availability.Available_from HOLDS NOT 'GOG.com' | ||
+ | AND Availability.Available_from HOLDS NOT 'itch.io' | ||
+ | AND Availability.Available_from HOLDS NOT 'Mac App Store' | ||
+ | AND Availability.Available_from HOLDS NOT 'Oculus Store' | ||
+ | AND Availability.Available_from HOLDS NOT 'Viveport' | ||
+ | AND Availability.Available_from HOLDS NOT 'Humble Store' | ||
+ | AND Availability.Available_from HOLDS NOT 'Battle.net' | ||
+ | AND Availability.Available_from HOLDS NOT 'Zoom Platform' | ||
+ | AND Availability.Available_from HOLDS NOT 'Amazon US' | ||
+ | AND Availability.Available_from HOLDS NOT 'Amazon UK' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'GOG.com' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Microsoft Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Epic Games Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Ubisoft Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'EA Desktop' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Publisher website' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Official website' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Developer website' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Steam' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'Humble Store' | ||
+ | AND Availability.Available_from_historically HOLDS NOT 'GamersGate' | ||
|format=template | |format=template | ||
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | ||
|named args=yes | |named args=yes | ||
− | |limit= | + | |limit=500 |
|intro={{Game list/intro}} | |intro={{Game list/intro}} | ||
|template=Game list/row | |template=Game list/row | ||
− | |outro=</table> | + | |outro=</table></div> |
}} | }} | ||
[[Category:Lists]] | [[Category:Lists]] |
Latest revision as of 05:52, 6 September 2022
This is an automated list of all games believed to be exclusive to retail copies without any digital copies available.
Total number of games:
Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,COUNT(*) FROM `cargo__Availability` WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Retail') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'GOG.com') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'itch.io') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Mac App Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Oculus Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Viveport') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Humble Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Battle.net') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Zoom Platform') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Amazon US') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Amazon UK') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'GOG.com') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Microsoft Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Epic Games Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Ubisoft Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'EA Desktop') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Publisher website') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Official website') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Developer website') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Steam') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'Humble Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`= 'GamersGate') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100