Difference between revisions of "List of games exclusive to Microsoft Store"
m (Protected "List of games exclusive to Microsoft Store": (via JWB) ([Edit=Allow only autoconfirmed users] (indefinite) [Move=Allow only autoconfirmed users] (indefinite))) |
(Fixed 2 incorrectly listed games.) |
||
Line 1: | Line 1: | ||
This is an automated list of all games believed to be exclusive to [[Store:Microsoft Store|Microsoft 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:Microsoft Store|Microsoft Store]], which means that buyers will have no choice but to open an account for the storefront. | ||
− | |||
− | |||
'''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 'Microsoft 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 'Ubisoft Store' AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop' 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 ' | + | |where=Availability.Available_from HOLDS LIKE 'Microsoft 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 'Ubisoft Store' | ||
+ | AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop' | ||
+ | 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 'Mac App Store' | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Oculus Store' AND Availability.Oculus_Store_DRM HOLDS NOT LIKE 'Microsoft 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 'Microsoft Store') | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'Microsoft Store') | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'Microsoft Store') | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'Microsoft Store') | ||
|format=text | |format=text | ||
}} | }} | ||
Line 13: | 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 'Microsoft 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 'Ubisoft Store' AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop' 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 ' | + | |where=Availability.Available_from HOLDS LIKE 'Microsoft 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 'Ubisoft Store' | ||
+ | AND NOT Availability.Available_from HOLDS LIKE 'EA Desktop' | ||
+ | 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 'Mac App Store' | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Oculus Store' AND Availability.Oculus_Store_DRM HOLDS NOT LIKE 'Microsoft 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 'Microsoft Store') | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT LIKE 'Microsoft Store') | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT LIKE 'Microsoft Store') | ||
+ | AND NOT (Availability.Available_from HOLDS LIKE 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT LIKE 'Microsoft Store') | ||
|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:50, 16 May 2022
This is an automated list of all games believed to be exclusive to Microsoft Store, which means that buyers will have no choice but to open an account for the storefront.
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`LIKE 'Microsoft 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 '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 'Mac App Store') AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Oculus Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Oculus_Store_DRM` WHERE `_value`LIKE 'Microsoft 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 'Microsoft Store') ) 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 'Microsoft Store') ) 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 'Microsoft Store') ) 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 'Microsoft Store') ) ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100