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 (proper Cargo query)
m (added |group by=_pageNamespace to fix Cargo queries)
Line 1: Line 1:
{{#vardefine:all|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)}}}}<!--
+
{{#vardefine:all|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace}}}}<!--
  
-->{{#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:native|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|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:rosetta 2|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|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:iosipados app|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|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:crossover|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|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:wine|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|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:parallels|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|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=
+
-->{{#vardefine:playable|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|group by=_pageNamespace|where=
 
(Compatibility_macOS.native<>'unplayable' AND Compatibility_macOS.native<>'na' AND Compatibility_macOS.native<>'unknown') OR
 
(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.rosetta_2<>'unplayable' AND Compatibility_macOS.rosetta_2<>'na' AND Compatibility_macOS.rosetta_2<>'unknown') OR

Revision as of 17:44, 10 June 2023