Difference between revisions of "List of games available on Microsoft Store"
From PCGamingWiki, the wiki about fixing PC games
(Ensuring the list takes up 2 pages instead of 3.) |
(migrated to Cargo query) |
||
| Line 1: | Line 1: | ||
This is a list of games on PCGamingWiki marked as being available for purchase on [[Microsoft Store]]. | This is a list of games on PCGamingWiki marked as being available for purchase on [[Microsoft Store]]. | ||
| − | + | '''Total number of games: '''{{#cargo_query: | |
| − | '''Total number of games: '''{{# | + | tables=Availability |
| + | |fields=COUNT(*) | ||
| + | |where=Available_from HOLDS LIKE 'Microsoft Store' | ||
| + | |format=text | ||
| + | }} | ||
| − | {{# | + | {{#cargo_query: |
| − | + | tables=Infobox_game,Availability | |
| − | + | |join on=Infobox_game._pageName=Availability._pageName | |
| − | + | |where=Availability.Available_from HOLDS LIKE 'Microsoft Store' | |
| − | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |
| − | + | |format=template | |
| − | + | |named args=yes | |
| − | + | |limit=200 | |
| − | + | |intro={{Game list/intro}} | |
| − | + | |template=Game list/row | |
| − | + | |outro=</table> | |
| − | |||
| − | |||
| − | |||
}} | }} | ||
[[Category:Lists]] | [[Category:Lists]] | ||
Revision as of 08:34, 2 October 2021
This is a list of games on PCGamingWiki marked as being available for purchase on Microsoft Store.
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 'Microsoft Store') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100
