Difference between revisions of "List of games exclusive to retail copies"
(Improved the search query furthermore.) |
m (→top: General maintenance with AutoWikiBrowser in Bot mode) |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
This is an automated list of all games believed to be exclusive to retail copies without any digital copies available. | This is an automated list of all games believed to be exclusive to retail copies without any digital copies available. | ||
− | |||
− | |||
'''Total number of games: '''{{#cargo_query: | '''Total number of games: '''{{#cargo_query: | ||
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 12: | 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]] |
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