Difference between revisions of "M1 compatible games master list"
From AppleGamingWiki, the wiki about gaming on M1 Apple silicon Macs
m (added count) |
|||
| Line 1: | Line 1: | ||
| + | {{#vardefine:all|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:native|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.native<>'unplayable' AND Compatibility_macOS.native<>'na' AND Compatibility_macOS.native<>'unknown'}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:rosetta 2|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.rosetta_2<>'unplayable' AND Compatibility_macOS.rosetta_2<>'na' AND Compatibility_macOS.rosetta_2<>'unknown'}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:iosipados app|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.iosipados_app<>'unplayable' AND Compatibility_macOS.iosipados_app<>'na' AND Compatibility_macOS.iosipados_app<>'unknown'}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:crossover|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.crossover<>'unplayable' AND Compatibility_macOS.crossover<>'na' AND Compatibility_macOS.crossover<>'unknown'}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:wine|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.wine<>'unplayable' AND Compatibility_macOS.wine<>'na' AND Compatibility_macOS.wine<>'unknown'}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:parallels|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.parallels<>'unplayable' AND Compatibility_macOS.parallels<>'na' AND Compatibility_macOS.parallels<>'unknown'}}}}<!-- | ||
| + | |||
| + | -->{{#vardefine:playable|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where= | ||
| + | (Compatibility_macOS.native<>'unplayable' AND Compatibility_macOS.native<>'na' AND Compatibility_macOS.native<>'unknown') OR | ||
| + | (Compatibility_macOS.rosetta_2<>'unplayable' AND Compatibility_macOS.rosetta_2<>'na' AND Compatibility_macOS.rosetta_2<>'unknown') OR | ||
| + | (Compatibility_macOS.iosipados_app<>'unplayable' AND Compatibility_macOS.iosipados_app<>'na' AND Compatibility_macOS.iosipados_app<>'unknown') OR | ||
| + | (Compatibility_macOS.crossover<>'unplayable' AND Compatibility_macOS.crossover<>'na' AND Compatibility_macOS.crossover<>'unknown') OR | ||
| + | (Compatibility_macOS.wine<>'unplayable' AND Compatibility_macOS.wine<>'na' AND Compatibility_macOS.wine<>'unknown') OR | ||
| + | (Compatibility_macOS.parallels<>'unplayable' AND Compatibility_macOS.parallels<>'na' AND Compatibility_macOS.parallels<>'unknown') | ||
| + | }}}} | ||
| + | |||
;All lists: | ;All lists: | ||
{{Lists}} | {{Lists}} | ||
| + | |||
| + | |||
| + | {{ii}} '''Tracking {{#var:all}} games of which {{#var:playable}} are playable''' • [[M1 native compatible games list|{{#var:native}} M1-native games]] • [[M1 Rosetta 2 compatible games list|{{#var:rosetta 2}} Rosetta 2 games]] • [[M1 iPhone/iPadOS compatible games list|{{#var:iosipados app}} iOS/iPadOS games]] • [[M1 CrossOver Windows compatible games list|{{#var:crossover}} CrossOver games]] • [[M1 Parallels Windows compatible games list|{{#var:parallels}} Parallels games]] | ||
| + | {{mm}} ''This list was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it.'' | ||
| + | |||
<div class="container-pcgwikitable"><table class="pcgwikitable template-infotable sortable" id="table-listofgames" style="max-width: 100%"><!-- | <div class="container-pcgwikitable"><table class="pcgwikitable template-infotable sortable" id="table-listofgames" style="max-width: 100%"><!-- | ||
Revision as of 07:21, 17 April 2021
- All lists
- M1 compatible games master list
- M1 perfect games list
- M1 native compatible games list
- M1 Rosetta 2 compatible games list
- M1 iPhone iPadOS compatible games list
- M1 CrossOver Windows compatible games list
- M1 Parallels Windows compatible games list
- List of Apple Arcade games
- Tracking Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
games of which
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` WHERE (`cargo__Compatibility_macOS`.`native`<>'unplayable' AND `cargo__Compatibility_macOS`.`native`<>'na' AND `cargo__Compatibility_macOS`.`native`<>'unknown') OR (`cargo__Compatibility_macOS`.`rosetta_2`<>'unplayable' AND `cargo__Compatibility_macOS`.`rosetta_2`<>'na' AND `cargo__Compatibility_macOS`.`rosetta_2`<>'unknown') OR (`cargo__Compatibility_macOS`.`iosipados_app`<>'unplayable' AND `cargo__Compatibility_macOS`.`iosipados_app`<>'na' AND `cargo__Compatibility_macOS`.`iosipados_app`<>'unknown') OR (`cargo__Compatibility_macOS`.`crossover`<>'unplayable' AND `cargo__Compatibility_macOS`.`crossover`<>'na' AND `cargo__Compatibility_macOS`.`crossover`<>'unknown') OR (`cargo__Compatibility_macOS`.`wine`<>'unplayable' AND `cargo__Compatibility_macOS`.`wine`<>'na' AND `cargo__Compatibility_macOS`.`wine`<>'unknown') OR (`cargo__Compatibility_macOS`.`parallels`<>'unplayable' AND `cargo__Compatibility_macOS`.`parallels`<>'na' AND `cargo__Compatibility_macOS`.`parallels`<>'unknown') ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
are playable •
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` WHERE `cargo__Compatibility_macOS`.`native`<>'unplayable' AND `cargo__Compatibility_macOS`.`native`<>'na' AND `cargo__Compatibility_macOS`.`native`<>'unknown' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` WHERE `cargo__Compatibility_macOS`.`rosetta_2`<>'unplayable' AND `cargo__Compatibility_macOS`.`rosetta_2`<>'na' AND `cargo__Compatibility_macOS`.`rosetta_2`<>'unknown' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` WHERE `cargo__Compatibility_macOS`.`iosipados_app`<>'unplayable' AND `cargo__Compatibility_macOS`.`iosipados_app`<>'na' AND `cargo__Compatibility_macOS`.`iosipados_app`<>'unknown' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` WHERE `cargo__Compatibility_macOS`.`crossover`<>'unplayable' AND `cargo__Compatibility_macOS`.`crossover`<>'na' AND `cargo__Compatibility_macOS`.`crossover`<>'unknown' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'applegamingwiki_cargo.cargo__Compatibility_macOS._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__Compatibility_macOS`.`_pageID` AS `cargo_backlink_page_id_Compatibility_macOS`,COUNT(*) FROM `cargo__Compatibility_macOS` WHERE `cargo__Compatibility_macOS`.`parallels`<>'unplayable' AND `cargo__Compatibility_macOS`.`parallels`<>'na' AND `cargo__Compatibility_macOS`.`parallels`<>'unknown' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100
- This list was last refreshed on May 1, 2024. Purge the page to refresh it.
[[:#cargo_query:
tables=Compatibility_macOS]]
| Game | Native | Rosetta 2 | iOS/iPadOS | CrossOver | Parallels |
|---|