Difference between revisions of "User:Aemony/Sandbox"
(d) |
m (d) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | < | + | |
| − | + | Test: | |
| − | + | ||
| − | {{ | + | {{User:Aemony/Sandbox/Test|}} |
| − | {{ | + | |
| − | {{ | + | |
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | ==Statistics== | ||
| + | |||
| + | {{#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'}}}}<!-- | ||
| + | |||
| + | -->{{#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') | ||
| + | }}}} | ||
| + | |||
| + | * '''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}} | ||
| + | |||
| + | ==Apple Arcade== | ||
| + | |||
| + | {{#cargo_query:tables=Store_Features | ||
| + | |fields=_pageName=Page | ||
| + | |where=Store_Features.apple_arcade='1' | ||
| + | |format=table | ||
| + | }} | ||
Latest revision as of 20:41, 18 April 2021
Test:
Echo: na
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