Difference between revisions of "User:Garrett/Sandbox"
From PCGamingWiki, the wiki about fixing PC games
| Line 1: | Line 1: | ||
| − | + | ==S== | |
{{#ask:[[Category:Games]] [[License::Freeware||Former commercial]] | {{#ask:[[Category:Games]] [[License::Freeware||Former commercial]] | ||
|?Developed by | |?Developed by | ||
| Line 17: | Line 17: | ||
}} | }} | ||
| − | + | ==C== | |
'''Total number of DRM-free games:''' {{#cargo_query: | '''Total number of DRM-free games:''' {{#cargo_query: | ||
tables=Infobox_game | tables=Infobox_game | ||
Revision as of 02:59, 16 October 2021
S
{{#ask: |Former commercial |?Developed by |?Published by |?Release date#SORTKEY |+limit=1 |?Release date |+limit=1 |?Available on |?Local play |?LAN play |?Online play |?License |format=template |template=Freeware list/row |introtemplate=Freeware list/intro |outrotemplate=Freeware list/outro |limit=5 }}
C
Total number of DRM-free games:
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._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__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` WHERE License='Freeware' OR License='Former commercial' ORDER BY `cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100
Game Developer Publisher First release Systems Local LAN Online Formerly commercial
| Game | Developer | Publisher | First release | Systems | Local | LAN | Online | Formerly commercial |
|---|---|---|---|---|---|---|---|---|
| .kkrieger | .theprodukkt | April 10, 2004 |  |
|||||
| "LIFE" not found | BerCh1n | BerCh1n | June 23, 2022 | |
||||
| 0 A.D. | Wildfire Games | |
||||||
| 1001 Hugs | Aigul Aubanova | September 26, 2019 | |
|||||
| 101010 | Jenny Chen, Changcheng Fu, Hunter Huynh, Miranda Liu, Eric Shen | Hunter Huynh | October 3, 2019 | |