Difference between revisions of "List of games exclusive to retail copies"
m (fixed gamersgate and removed a few parts of less likely stores to have games on it that caused the Cargo query to fail) |
(Compressed the "Where" fields.) |
||
Line 7: | Line 7: | ||
Availability.Available_from HOLDS 'Retail' | Availability.Available_from HOLDS 'Retail' | ||
AND Availability.Available_from HOLDS NOT 'GOG.com' | AND Availability.Available_from HOLDS NOT 'GOG.com' | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
AND Availability.Available_from HOLDS NOT 'itch.io' | AND Availability.Available_from HOLDS NOT 'itch.io' | ||
− | |||
AND Availability.Available_from HOLDS NOT 'Mac App Store' | AND Availability.Available_from HOLDS NOT 'Mac App Store' | ||
AND Availability.Available_from HOLDS NOT 'Oculus Store' | AND Availability.Available_from HOLDS NOT 'Oculus Store' | ||
AND Availability.Available_from HOLDS NOT 'Viveport' | AND Availability.Available_from HOLDS NOT 'Viveport' | ||
− | |||
AND Availability.Available_from HOLDS NOT 'Humble Store' | AND Availability.Available_from HOLDS NOT 'Humble Store' | ||
AND Availability.Available_from HOLDS NOT 'Battle.net' | AND Availability.Available_from HOLDS NOT 'Battle.net' | ||
AND Availability.Available_from HOLDS NOT 'Zoom Platform' | AND Availability.Available_from HOLDS NOT 'Zoom Platform' | ||
− | |||
AND Availability.Available_from_historically HOLDS NOT 'GOG.com' | 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 'Microsoft Store' | ||
Line 43: | Line 33: | ||
Availability.Available_from HOLDS 'Retail' | Availability.Available_from HOLDS 'Retail' | ||
AND Availability.Available_from HOLDS NOT 'GOG.com' | AND Availability.Available_from HOLDS NOT 'GOG.com' | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
AND Availability.Available_from HOLDS NOT 'itch.io' | AND Availability.Available_from HOLDS NOT 'itch.io' | ||
− | |||
AND Availability.Available_from HOLDS NOT 'Mac App Store' | AND Availability.Available_from HOLDS NOT 'Mac App Store' | ||
AND Availability.Available_from HOLDS NOT 'Oculus Store' | AND Availability.Available_from HOLDS NOT 'Oculus Store' | ||
AND Availability.Available_from HOLDS NOT 'Viveport' | AND Availability.Available_from HOLDS NOT 'Viveport' | ||
− | |||
AND Availability.Available_from HOLDS NOT 'Humble Store' | AND Availability.Available_from HOLDS NOT 'Humble Store' | ||
AND Availability.Available_from HOLDS NOT 'Battle.net' | AND Availability.Available_from HOLDS NOT 'Battle.net' | ||
AND Availability.Available_from HOLDS NOT 'Zoom Platform' | AND Availability.Available_from HOLDS NOT 'Zoom Platform' | ||
− | |||
AND Availability.Available_from_historically HOLDS NOT 'GOG.com' | 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 'Microsoft Store' |
Revision as of 22:07, 13 May 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_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