Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.


Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "List of games exclusive to GOG.com"

From PCGamingWiki, the wiki about fixing PC games
(Fixed 4 incorrectly listed games.)
(Fixed 2 more incorrectly listed games.)
Line 1: Line 1:
This is an automated list of all games believed to be exclusive to [[Store:GOG.com|GOG.com]], which means that buyers will have no choice but to open an account for the storefront.
+
This is an automated list of all games believed to be exclusive to [[Store:GOG.com|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.
 
 
For practical reasons, stores that sell the games as keys to redeem on other stores on key-seller stores, does not currently affect exclusivity status.
 
  
 
'''Total number of games: '''{{#cargo_query:
 
'''Total number of games: '''{{#cargo_query:
Line 22: Line 20:
 
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
 
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
 
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
 
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND (Availability.GamersGate_DRM HOLDS LIKE 'DRM-free' OR Availability.GamersGate_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%')
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND (Availability.Amazon_US_DRM HOLDS LIKE 'DRM-free' OR Availability.Amazon_US_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'GOG%')
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND (Availability.Amazon_UK_DRM HOLDS LIKE 'DRM-free' OR Availability.Amazon_UK_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'GOG%')
AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND (Availability.Humble_Store_DRM HOLDS LIKE 'DRM-free' OR Availability.Humble_Store_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'GOG%')
 
|format=text
 
|format=text
 
}}
 
}}
Line 48: Line 46:
 
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
 
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
 
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
 
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND (Availability.GamersGate_DRM HOLDS LIKE 'DRM-free' OR Availability.GamersGate_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%')
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND (Availability.Amazon_US_DRM HOLDS LIKE 'DRM-free' OR Availability.Amazon_US_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'GOG%')
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND (Availability.Amazon_UK_DRM HOLDS LIKE 'DRM-free' OR Availability.Amazon_UK_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'GOG%')
AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND (Availability.Humble_Store_DRM HOLDS LIKE 'DRM-free' OR Availability.Humble_Store_DRM HOLDS LIKE 'Unknown'))
+
AND NOT (Availability.Available_from HOLDS LIKE '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:53, 16 May 2022

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:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Availability._pageID'; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

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`LIKE 'GOG.com') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Microsoft Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Epic Games Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Ubisoft Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'EA Desktop') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Publisher website') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Official website') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Developer website') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Retail') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'itch.io') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Bethesda.net') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Mac App Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Oculus Store') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Viveport') AND NOT `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Zoom Platform') AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE '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`LIKE '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`LIKE '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`LIKE '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