Difference between revisions of "User:Aemony/Sandbox"
m (d) |
m (d) |
||
| (2 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:all|{{#cargo_query:tables=Compatibility_macOS|fields=COUNT(*)}}}}<!-- | ||
| Line 21: | Line 35: | ||
(Compatibility_macOS.parallels<>'unplayable' AND Compatibility_macOS.parallels<>'na') | (Compatibility_macOS.parallels<>'unplayable' AND Compatibility_macOS.parallels<>'na') | ||
}}}} | }}}} | ||
| − | |||
* '''All Games:''' {{#var:all}} | * '''All Games:''' {{#var:all}} | ||
| Line 34: | Line 47: | ||
* Wine: {{#var:wine}} | * Wine: {{#var:wine}} | ||
* Parallels: {{#var:parallels}} | * 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