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 Ubisoft Store"

From PCGamingWiki, the wiki about fixing PC games
m (Protected "List of games exclusive to Ubisoft Store": (via JWB) ([Edit=Allow only autoconfirmed users] (indefinite) [Move=Allow only autoconfirmed users] (indefinite)))
Line 1: Line 1:
This is an automated list of all games believed to be exclusive to [[Store:Ubisoft Store|Ubisoft Store]], 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:Ubisoft Store|Ubisoft Store]], which means that buyers and code redeemers will have no choice but to open an account for the storefront.
 
 
For practical reasons, availability on key-seller stores like [[Store:Humble Store|Humble Store]], [[Store:GamersGate|GamersGate]], or [[Store:Amazon|Amazon]], does not affect exclusivity status.
 
  
 
'''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 LIKE 'Ubisoft Store' AND NOT Availability.Available_from HOLDS LIKE 'Steam' AND NOT Availability.Available_from HOLDS LIKE 'GOG.com' AND NOT Availability.Available_from HOLDS LIKE 'Epic Games Store' AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop' AND NOT Availability.Available_from HOLDS LIKE 'Microsoft Store' AND NOT Availability.Available_from HOLDS LIKE 'Publisher website' AND NOT Availability.Available_from HOLDS LIKE 'Official website' AND NOT Availability.Available_from HOLDS LIKE 'Developer Website' AND NOT Availability.Available_from HOLDS LIKE 'Retail' AND NOT Availability.Available_from HOLDS LIKE 'itch.io' AND NOT Availability.Available_from HOLDS LIKE 'Bethesda.net' AND NOT Availability.Available_from HOLDS LIKE 'Mac App Store' AND NOT Availability.Available_from HOLDS LIKE 'Oculus Store' AND NOT Availability.Available_from HOLDS LIKE 'Viveport' AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
+
|where= Availability.Available_from HOLDS LIKE 'Ubisoft Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Steam'
 +
AND NOT Availability.Available_from HOLDS LIKE 'GOG.com'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Epic Games Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Microsoft Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Publisher website'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Official website'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Developer Website'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Retail'
 +
AND NOT Availability.Available_from HOLDS LIKE 'itch.io'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Bethesda.net'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Mac App Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Oculus Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
 +
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Gamesplanet' AND Availability.Gamesplanet_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Green Man Gaming' AND Availability.Green_Man_Gaming_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 
|format=text
 
|format=text
 
}}
 
}}
Line 13: 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 LIKE 'Ubisoft Store' AND NOT Availability.Available_from HOLDS LIKE 'Steam' AND NOT Availability.Available_from HOLDS LIKE 'GOG.com' AND NOT Availability.Available_from HOLDS LIKE 'Epic Games Store' AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop' AND NOT Availability.Available_from HOLDS LIKE 'Microsoft Store' AND NOT Availability.Available_from HOLDS LIKE 'Publisher website' AND NOT Availability.Available_from HOLDS LIKE 'Official website' AND NOT Availability.Available_from HOLDS LIKE 'Developer Website' AND NOT Availability.Available_from HOLDS LIKE 'Retail' AND NOT Availability.Available_from HOLDS LIKE 'itch.io' AND NOT Availability.Available_from HOLDS LIKE 'Bethesda.net' AND NOT Availability.Available_from HOLDS LIKE 'Mac App Store' AND NOT Availability.Available_from HOLDS LIKE 'Oculus Store' AND NOT Availability.Available_from HOLDS LIKE 'Viveport' AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
+
|where= Availability.Available_from HOLDS LIKE 'Ubisoft Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Steam'
 +
AND NOT Availability.Available_from HOLDS LIKE 'GOG.com'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Epic Games Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Microsoft Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Publisher website'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Official website'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Developer Website'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Retail'
 +
AND NOT Availability.Available_from HOLDS LIKE 'itch.io'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Bethesda.net'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Mac App Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Oculus Store'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Viveport'
 +
AND NOT Availability.Available_from HOLDS LIKE 'Zoom Platform'
 +
AND NOT (Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Gamesplanet' AND Availability.Gamesplanet_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 +
AND NOT (Availability.Available_from HOLDS LIKE 'Green Man Gaming' AND Availability.Green_Man_Gaming_DRM HOLDS NOT LIKE 'Ubisoft Connect')
 
|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 08:00, 16 May 2022

This is an automated list of all games believed to be exclusive to Ubisoft Store, which means that buyers and code redeemers will have no choice but to open an account for the storefront.

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 'Ubisoft Store') 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 'GOG.com') 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 'EA Desktop') 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 '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 'Ubisoft Connect') ) 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 'Ubisoft Connect') ) 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 'Ubisoft Connect') ) 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 'Ubisoft Connect') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Gamesplanet') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Gamesplanet_DRM` WHERE `_value`LIKE 'Ubisoft Connect') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Green Man Gaming') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Green_Man_Gaming_DRM` WHERE `_value`LIKE 'Ubisoft Connect') ) ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100