Difference between revisions of "List of games exclusive to GOG.com"
m (→top: General maintenance with AutoWikiBrowser in Bot mode) |
m (removed LIKE operator where applicable) |
||
Line 4: | Line 4: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
− | |where= Availability.Available_from HOLDS | + | |where= Availability.Available_from HOLDS 'GOG.com' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Steam' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Microsoft Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Epic Games Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Ubisoft Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'EA Desktop' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Publisher website' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Official website' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Developer website' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Retail' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'itch.io' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Bethesda.net' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Mac App Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Oculus Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Viveport' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Zoom Platform' |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%') |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'GOG%') |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'GOG%') |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'GOG%') |
|format=text | |format=text | ||
}} | }} | ||
Line 29: | Line 29: | ||
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 | + | |where= Availability.Available_from HOLDS 'GOG.com' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Steam' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Microsoft Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Epic Games Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Ubisoft Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'EA Desktop' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Publisher website' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Official website' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Developer website' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Retail' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'itch.io' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Bethesda.net' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Mac App Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Oculus Store' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Viveport' |
− | AND NOT Availability.Available_from HOLDS | + | AND NOT Availability.Available_from HOLDS 'Zoom Platform' |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%') |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'GOG%') |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'GOG%') |
− | AND NOT (Availability.Available_from HOLDS | + | AND NOT (Availability.Available_from HOLDS 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'GOG%') |
|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 | ||
|format=template | |format=template |
Revision as of 07:52, 23 April 2023
This is an automated list of all games believed to be exclusive to GOG.com, which means that buyers will have no choice but to open an account for the storefront, either to buy or to redeem the game.
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`= 'GOG.com') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Steam') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Microsoft Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Epic Games Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Ubisoft Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'EA Desktop') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Publisher website') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Official website') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Developer website') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Retail') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'itch.io') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Bethesda.net') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Mac App Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Oculus Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Viveport') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Zoom Platform') AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'GamersGate') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__GamersGate_DRM` WHERE `_value`LIKE 'GOG%') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Amazon US') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Amazon_US_DRM` WHERE `_value`LIKE 'GOG%') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Amazon UK') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Amazon_UK_DRM` WHERE `_value`LIKE 'GOG%') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Humble Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Humble_Store_DRM` WHERE `_value`LIKE 'GOG%') ) ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100