Difference between revisions of "User:Dandelion Sprout/For the hobby club's iMac"
Line 24: | Line 24: | ||
|join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=Availability._pageName | ||
|where=API.macOS_Intel_64bit_app='unknown' AND (Infobox_game.Monetization HOLDS 'Freeware' OR Infobox_game.License='freeware') AND Infobox_game.Available_on HOLDS 'OS X' AND Infobox_game.Wrappers_OS_X HOLDS NOT LIKE '%' AND Infobox_game.Themes HOLDS NOT 'Adult' AND (Availability.Available_from HOLDS 'Developer website' OR Availability.Available_from HOLDS 'Publisher website' OR Availability.Available_from HOLDS 'Official website' OR Availability.Available_from HOLDS 'itch.io') AND Infobox_game.Engines HOLDS NOT LIKE 'Engine:Ren\'Py%' AND Infobox_game.Engines HOLDS NOT LIKE 'Engine:Flash' | |where=API.macOS_Intel_64bit_app='unknown' AND (Infobox_game.Monetization HOLDS 'Freeware' OR Infobox_game.License='freeware') AND Infobox_game.Available_on HOLDS 'OS X' AND Infobox_game.Wrappers_OS_X HOLDS NOT LIKE '%' AND Infobox_game.Themes HOLDS NOT 'Adult' AND (Availability.Available_from HOLDS 'Developer website' OR Availability.Available_from HOLDS 'Publisher website' OR Availability.Available_from HOLDS 'Official website' OR Availability.Available_from HOLDS 'itch.io') AND Infobox_game.Engines HOLDS NOT LIKE 'Engine:Ren\'Py%' AND Infobox_game.Engines HOLDS NOT LIKE 'Engine:Flash' | ||
+ | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released_OS_X=Released | ||
+ | |format=template | ||
+ | |named args=yes | ||
+ | |limit=750 | ||
+ | |intro={{Game list/intro no OS}} | ||
+ | |template=Game list/row no OS | ||
+ | |outro=</table></div> | ||
+ | }} | ||
+ | |||
+ | ===PCGW GOG staff account macOS games whose 64-bit status is unknown=== | ||
+ | '''Total number of games: '''{{#cargo_query: | ||
+ | tables=Infobox_game,API,GOGcom_Enhancement_Project | ||
+ | |join on=API._pageName=Infobox_game._pageName,API._pageName=GOGcom_Enhancement_Project._pageName | ||
+ | |where=API.macOS_Intel_64bit_app='unknown' AND GOGcom_Enhancement_Project.Press_account='true' AND Infobox_game.Available_on HOLDS 'OS X' AND Infobox_game.Wrappers_OS_X HOLDS NOT LIKE '%' AND Infobox_game.Themes HOLDS NOT 'Adult' | ||
+ | |fields=COUNT(*) | ||
+ | |format=text | ||
+ | }} | ||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game,API,GOGcom_Enhancement_Project | ||
+ | |join on=API._pageName=Infobox_game._pageName,API._pageName=GOGcom_Enhancement_Project._pageName | ||
+ | |where=API.macOS_Intel_64bit_app='unknown' AND GOGcom_Enhancement_Project.Press_account='true' AND Infobox_game.Available_on HOLDS 'OS X' AND Infobox_game.Wrappers_OS_X HOLDS NOT LIKE '%' AND Infobox_game.Themes HOLDS NOT 'Adult' | ||
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released_OS_X=Released | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released_OS_X=Released | ||
|format=template | |format=template |
Revision as of 11:52, 15 February 2023
Apple Arcade macOS games whose ARM64 status is unknown
Not present (or hard to find) on MacUpdates
- ShockRods (3.6 GB)
- Decoherence (1.8 GB)
- Punch Planet (1.1 GB)
- Fallen Knight (691 MB)
- The Lullaby of Life (446 MB)
Both low priority (Cards/Solitaire/Pinball) and not present (or hard to find) on MacUpdates
Freeware macOS games whose 64-bit status is unknown
Total number of games:
Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`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`)) LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__API`.`macOS_Intel_64bit_app`='unknown' AND (`cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Monetization` WHERE `_value`= 'Freeware') OR `cargo__Infobox_game`.`License`='freeware') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Available_on` WHERE `_value`= 'OS X') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Wrappers_OS_X` WHERE `_value`LIKE '%') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Themes` WHERE `_value`= 'Adult') AND (`cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Developer website') OR `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Publisher website') OR `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'Official website') OR `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'itch.io') ) AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Engines` WHERE `_value`LIKE 'Engine:Ren\'Py%') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Engines` WHERE `_value`LIKE 'Engine:Flash') ORDER BY `cargo__Availability`.`_pageID`,`cargo__API`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100
PCGW GOG staff account macOS games whose 64-bit status is unknown
Total number of games:
Function: CargoSQLQuery::run Query: SELECT `cargo__GOGcom_Enhancement_Project`.`_pageID` AS `cargo_backlink_page_id_GOGcom_Enhancement_Project`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,`cargo__API`.`_pageID` AS `cargo_backlink_page_id_API`,COUNT(*) FROM `cargo__API` LEFT OUTER JOIN `cargo__Infobox_game` ON ((`cargo__API`.`_pageName`=`cargo__Infobox_game`.`_pageName`)) LEFT OUTER JOIN `cargo__GOGcom_Enhancement_Project` ON ((`cargo__API`.`_pageName`=`cargo__GOGcom_Enhancement_Project`.`_pageName`)) WHERE `cargo__API`.`macOS_Intel_64bit_app`='unknown' AND `cargo__GOGcom_Enhancement_Project`.`Press_account`='true' AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Available_on` WHERE `_value`= 'OS X') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Wrappers_OS_X` WHERE `_value`LIKE '%') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Themes` WHERE `_value`= 'Adult') ORDER BY `cargo__GOGcom_Enhancement_Project`.`_pageID`,`cargo__Infobox_game`.`_pageID`,`cargo__API`.`_pageID`,COUNT(*) LIMIT 100