Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Difference between revisions of "M1 compatible games master list"

From AppleGamingWiki, the wiki about gaming on M1 Apple silicon Macs
m (moved over to using templates)
m (proper Cargo query)
Line 28: Line 28:
 
{{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]]
 
{{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.''
 
{{mm}} ''This list was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it.''
 
<div class="container-pcgwikitable">
 
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=Compatibility_macOS
 
tables=Compatibility_macOS
Line 39: Line 37:
 
|named args=yes
 
|named args=yes
 
|intro={{ListOfGames/intro/MasterList|max-width: 100%}}
 
|intro={{ListOfGames/intro/MasterList|max-width: 100%}}
|outro=</table>
+
|outro=</table></div>
 
}}
 
}}
</div>
 
  
 
[[Category:Lists]]
 
[[Category:Lists]]

Revision as of 19:46, 29 September 2022

All lists


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

M1-native games

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

Rosetta 2 games

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

iOS/iPadOS games

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

CrossOver games

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

Parallels games

This list was last refreshed on March 29, 2024. Purge the page to refresh it.

[[:#cargo_query: tables=Compatibility_macOS]]