User:Aemony/Sandbox/Unity

There's nothing to indicate that Unity ever supported Direct3D API versions older than 9. As a result, all of these games needs to have their pre-9 values removed from the D3D versions field.

Total number of games:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__API._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__API`.`_pageID` AS `cargo_backlink_page_id_API`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__API` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__API`.`_pageName`)) WHERE `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Engines` WHERE `_value`= "Engine:Unity") AND (`cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '2%') OR `cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '3%') OR `cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '4%') OR `cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '5%') OR `cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '6%') OR `cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '7%') OR `cargo__API`.`_ID` IN (SELECT `_rowID` FROM `cargo__API__Direct3D_versions` WHERE `_value`LIKE '8%') ) ORDER BY `cargo__API`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games.

No results