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.
| Game | Developer | Publisher | Engine | Versions | First release | Available on |
|---|---|---|---|---|---|---|
| Stellar Settlers: Space Base Builder | Tinymice Entertainment | Rogue Duck Interactive, Gamersky Games | Unity | 8 | February 22, 2025 |  |
| Tsuki ni yorisou otome no sahou | Navel | Navel, HIKARI FIELD | QLIE, Unity | 7, 9.0, 11 | October 26, 2012 | |
| Wedding Witch | Chowbie | Unity | 8 | November 3, 2023 | |