Difference between revisions of "List of games exclusive to Microsoft Store"
m (removed LIKE operator) |
m (removed LIKE operator) |
||
Line 16: | Line 16: | ||
AND NOT Availability.Available_from HOLDS 'itch.io' | AND NOT Availability.Available_from HOLDS 'itch.io' | ||
AND NOT Availability.Available_from HOLDS 'Mac App Store' | AND NOT Availability.Available_from HOLDS 'Mac App Store' | ||
− | AND NOT (Availability.Available_from HOLDS 'Oculus Store' AND Availability.Oculus_Store_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Oculus Store' AND Availability.Oculus_Store_DRM HOLDS NOT 'Microsoft Store') |
AND NOT Availability.Available_from HOLDS 'Viveport' | AND NOT Availability.Available_from HOLDS 'Viveport' | ||
AND NOT Availability.Available_from HOLDS 'Zoom Platform' | AND NOT Availability.Available_from HOLDS 'Zoom Platform' | ||
− | AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Green Man Gaming' AND Availability.Green_Man_Gaming_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Green Man Gaming' AND Availability.Green_Man_Gaming_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Gamesplanet' AND Availability.Gamesplanet_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Gamesplanet' AND Availability.Gamesplanet_DRM HOLDS NOT 'Microsoft Store') |
|format=text | |format=text | ||
}} | }} | ||
Line 42: | Line 42: | ||
AND NOT Availability.Available_from HOLDS 'itch.io' | AND NOT Availability.Available_from HOLDS 'itch.io' | ||
AND NOT Availability.Available_from HOLDS 'Mac App Store' | AND NOT Availability.Available_from HOLDS 'Mac App Store' | ||
− | AND NOT (Availability.Available_from HOLDS 'Oculus Store' AND Availability.Oculus_Store_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Oculus Store' AND Availability.Oculus_Store_DRM HOLDS NOT 'Microsoft Store') |
AND NOT Availability.Available_from HOLDS 'Viveport' | AND NOT Availability.Available_from HOLDS 'Viveport' | ||
AND NOT Availability.Available_from HOLDS 'Zoom Platform' | AND NOT Availability.Available_from HOLDS 'Zoom Platform' | ||
− | AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Amazon US' AND Availability.Amazon_US_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Amazon UK' AND Availability.Amazon_UK_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Humble Store' AND Availability.Humble_Store_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Green Man Gaming' AND Availability.Green_Man_Gaming_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Green Man Gaming' AND Availability.Green_Man_Gaming_DRM HOLDS NOT 'Microsoft Store') |
− | AND NOT (Availability.Available_from HOLDS 'Gamesplanet' AND Availability.Gamesplanet_DRM HOLDS NOT | + | AND NOT (Availability.Available_from HOLDS 'Gamesplanet' AND Availability.Gamesplanet_DRM HOLDS NOT '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 08:25, 23 April 2023
This is an automated list of all games believed to be exclusive to Microsoft Store, which means that buyers and code redeemers 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`= 'Microsoft Store') 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`= 'GOG.com') 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`= 'Mac App Store') AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Oculus Store') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Oculus_Store_DRM` WHERE `_value`= 'Microsoft 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`= 'Microsoft Store') ) 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`= 'Microsoft Store') ) 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`= 'Microsoft Store') ) 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`= 'Microsoft Store') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Green Man Gaming') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Green_Man_Gaming_DRM` WHERE `_value`= 'Microsoft Store') ) AND NOT (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Gamesplanet') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Gamesplanet_DRM` WHERE `_value`= 'Microsoft Store') ) ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100