User:Aemony/Sandbox
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