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
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 LIKE 'GOG.com'
+
|where= Availability.Available_from HOLDS 'GOG.com'
−
AND NOT Availability.Available_from HOLDS LIKE 'Steam'
+
AND NOT Availability.Available_from HOLDS 'Steam'
−
AND NOT Availability.Available_from HOLDS LIKE 'Microsoft Store'
+
AND NOT Availability.Available_from HOLDS 'Microsoft Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Epic Games Store'
+
AND NOT Availability.Available_from HOLDS 'Epic Games Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Ubisoft Store'
+
AND NOT Availability.Available_from HOLDS 'Ubisoft Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop'
+
AND NOT Availability.Available_from HOLDS 'EA Desktop'
−
AND NOT Availability.Available_from HOLDS LIKE 'Publisher website'
+
AND NOT Availability.Available_from HOLDS 'Publisher website'
−
AND NOT Availability.Available_from HOLDS LIKE 'Official website'
+
AND NOT Availability.Available_from HOLDS 'Official website'
−
AND NOT Availability.Available_from HOLDS LIKE 'Developer website'
+
AND NOT Availability.Available_from HOLDS 'Developer website'
−
AND NOT Availability.Available_from HOLDS LIKE 'Retail'
+
AND NOT Availability.Available_from HOLDS 'Retail'
−
AND NOT Availability.Available_from HOLDS LIKE 'itch.io'
+
AND NOT Availability.Available_from HOLDS 'itch.io'
−
AND NOT Availability.Available_from HOLDS LIKE 'Bethesda.net'
+
AND NOT Availability.Available_from HOLDS 'Bethesda.net'
−
AND NOT Availability.Available_from HOLDS LIKE 'Mac App Store'
+
AND NOT Availability.Available_from HOLDS 'Mac App Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Oculus Store'
+
AND NOT Availability.Available_from HOLDS 'Oculus Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
+
AND NOT Availability.Available_from HOLDS 'Viveport'
−
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
+
AND NOT Availability.Available_from HOLDS 'Zoom Platform'
−
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%')
+
AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%')
−
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'GOG%')
+
AND NOT (Availability.Available_from HOLDS '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 NOT LIKE 'GOG%')
+
AND NOT (Availability.Available_from HOLDS '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 NOT LIKE 'GOG%')
+
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 LIKE 'GOG.com'
+
|where= Availability.Available_from HOLDS 'GOG.com'
−
AND NOT Availability.Available_from HOLDS LIKE 'Steam'
+
AND NOT Availability.Available_from HOLDS 'Steam'
−
AND NOT Availability.Available_from HOLDS LIKE 'Microsoft Store'
+
AND NOT Availability.Available_from HOLDS 'Microsoft Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Epic Games Store'
+
AND NOT Availability.Available_from HOLDS 'Epic Games Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Ubisoft Store'
+
AND NOT Availability.Available_from HOLDS 'Ubisoft Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop'
+
AND NOT Availability.Available_from HOLDS 'EA Desktop'
−
AND NOT Availability.Available_from HOLDS LIKE 'Publisher website'
+
AND NOT Availability.Available_from HOLDS 'Publisher website'
−
AND NOT Availability.Available_from HOLDS LIKE 'Official website'
+
AND NOT Availability.Available_from HOLDS 'Official website'
−
AND NOT Availability.Available_from HOLDS LIKE 'Developer website'
+
AND NOT Availability.Available_from HOLDS 'Developer website'
−
AND NOT Availability.Available_from HOLDS LIKE 'Retail'
+
AND NOT Availability.Available_from HOLDS 'Retail'
−
AND NOT Availability.Available_from HOLDS LIKE 'itch.io'
+
AND NOT Availability.Available_from HOLDS 'itch.io'
−
AND NOT Availability.Available_from HOLDS LIKE 'Bethesda.net'
+
AND NOT Availability.Available_from HOLDS 'Bethesda.net'
−
AND NOT Availability.Available_from HOLDS LIKE 'Mac App Store'
+
AND NOT Availability.Available_from HOLDS 'Mac App Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Oculus Store'
+
AND NOT Availability.Available_from HOLDS 'Oculus Store'
−
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
+
AND NOT Availability.Available_from HOLDS 'Viveport'
−
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
+
AND NOT Availability.Available_from HOLDS 'Zoom Platform'
−
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%')
+
AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'GOG%')
−
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'GOG%')
+
AND NOT (Availability.Available_from HOLDS '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 NOT LIKE 'GOG%')
+
AND NOT (Availability.Available_from HOLDS '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 NOT LIKE 'GOG%')
+
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:

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`= '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

Game Series Developer Publisher First release Available on
A Kiss for the Petals - Maidens of Michael A Kiss for the Petals St. Michael's Girls School MangaGamer November 30, 2012
Windows
macOS (OS X)
Linux
American Hero Inter-Active Productions, Empty Clip Studios Ziggurat Interactive November 11, 2021
Windows
Betrayer Blackpowder Games March 24, 2014
Windows
Bus Driver Simulator KishMish Games
Windows
CLARC GoldenTricycle Hahn Film AG May 15, 2014
Windows
macOS (OS X)
Linux
Crimzon Clover: World Ignition Crimzon Clover Yotsubane, Adventure Planning Service Degica June 6, 2014
Windows
Dragon's Lair Trilogy Dragon's Lair Digital Leisure July 24, 2018
Windows
Man O' War: Corsair Warhammer Evil Twin Artworks April 19, 2017
Windows
macOS (OS X)
Linux
Metal Gear (MSX2) Metal Gear Konami September 25, 2020
Windows
Puzzlink Alexis Clemente AleC Games January 8, 2024
Windows
Saboteur II: Avenging Angel Saboteur SimFabric, Clive Townsend SimFabric August 2, 2019
Windows
Saboteur SiO Saboteur SimFabric, Clive Townsend SimFabric September 1, 2020
Windows
Saboteur! Saboteur SimFabric, Clive Townsend SimFabric November 30, 2018
Windows
macOS (OS X)
The King of Fighters 2003 The King of Fighters SNK Corporation SNK Corporation April 8, 2024
Windows