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

Difference between revisions of "User:Aemony/Sandbox"

From AppleGamingWiki, the wiki about gaming on M1 Apple silicon Macs
m (added {{References}})
m (d)
Line 1: Line 1:
−
<ref>{{Refcheck|user=Aemony|date=2021-03-14|comment=Comment (optional)}}</ref>
+
{{#vardefine:all|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)}}}}<!--
−
<ref>{{Refurl|url=|title=|date=2021-03-14}}</ref>
 
−
<ref>{{Refurl|url=|title=|date=2021-03-14|snippet=}}</ref>
 
−
{{cn|date=2021-03-14|reason=}}
 
−
{{dubious|date=2021-03-14|reason=}}
 
−
{{note|The content of the note here.}}
 
  
 +
-->{{#vardefine:native|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.native<>'unplayable' AND Compatibility_macOS.native<>'na'}}}}<!--
  
−
{{References}}
+
-->{{#vardefine:rosetta 2|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.rosetta_2<>'unplayable' AND Compatibility_macOS.rosetta_2<>'na'}}}}<!--
 +
 
 +
-->{{#vardefine:iosipados app|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.iosipados_app<>'unplayable' AND Compatibility_macOS.iosipados_app<>'na'}}}}<!--
 +
 
 +
-->{{#vardefine:crossover|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.crossover<>'unplayable' AND Compatibility_macOS.crossover<>'na'}}}}<!--
 +
 
 +
-->{{#vardefine:wine|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.wine<>'unplayable' AND Compatibility_macOS.wine<>'na'}}}}<!--
 +
 
 +
-->{{#vardefine:parallels|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=Compatibility_macOS.parallels<>'unplayable' AND Compatibility_macOS.parallels<>'na'}}}}<!--
 +
 
 +
-->{{#vardefine:playable|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)|where=
 +
(Compatibility_macOS.native<>'unplayable' AND Compatibility_macOS.native<>'na') OR
 +
(Compatibility_macOS.rosetta_2<>'unplayable' AND Compatibility_macOS.rosetta_2<>'na') OR
 +
(Compatibility_macOS.iosipados_app<>'unplayable' AND Compatibility_macOS.iosipados_app<>'na') OR
 +
(Compatibility_macOS.crossover<>'unplayable' AND Compatibility_macOS.crossover<>'na') OR
 +
(Compatibility_macOS.wine<>'unplayable' AND Compatibility_macOS.wine<>'na') OR
 +
(Compatibility_macOS.parallels<>'unplayable' AND Compatibility_macOS.parallels<>'na')
 +
}}}}
 +
==Statistics==
 +
 
 +
* '''All Games:''' {{#var:all}}
 +
* '''Playable:''' {{#var:playable}}
 +
 
 +
 
 +
'''Playable per method:'''
 +
* Native: {{#var:native}}
 +
* Rosetta 2: {{#var:rosetta 2}}
 +
* iOS/iPadOS App: {{#var:iosipados app}}
 +
* CrossOver: {{#var:crossover}}
 +
* Wine: {{#var:wine}}
 +
* Parallels: {{#var:parallels}}

Revision as of 09:17, 13 April 2021

Statistics

  • All 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` ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

  • 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') OR (`cargo__Compatibility_macOS`.`rosetta_2`<>'unplayable' AND `cargo__Compatibility_macOS`.`rosetta_2`<>'na') OR (`cargo__Compatibility_macOS`.`iosipados_app`<>'unplayable' AND `cargo__Compatibility_macOS`.`iosipados_app`<>'na') OR (`cargo__Compatibility_macOS`.`crossover`<>'unplayable' AND `cargo__Compatibility_macOS`.`crossover`<>'na') OR (`cargo__Compatibility_macOS`.`wine`<>'unplayable' AND `cargo__Compatibility_macOS`.`wine`<>'na') OR (`cargo__Compatibility_macOS`.`parallels`<>'unplayable' AND `cargo__Compatibility_macOS`.`parallels`<>'na') ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100


Playable per method:

  • Native:
    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' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

  • Rosetta 2:
    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' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

  • iOS/iPadOS App:
    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' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

  • CrossOver:
    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' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

  • Wine:
    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`.`wine`<>'unplayable' AND `cargo__Compatibility_macOS`.`wine`<>'na' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

  • Parallels:
    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' ORDER BY `cargo__Compatibility_macOS`.`_pageID`,COUNT(*) LIMIT 100

Retrieved from "https://www.applegamingwiki.com/w/index.php?title=User:Aemony/Sandbox&oldid=1877"