Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "User:Garrett/Sandbox"

From PCGamingWiki, the wiki about fixing PC games
Line 17: Line 17:
 
}}
 
}}
  
 +
 +
'''Total number of DRM-free games:''' {{#cargo_query:
 +
tables=Infobox_game
 +
|fields=COUNT(*)
 +
|where=License='Freeware' OR License='Former commercial'
 +
|format=text
 +
}}
  
 
Game Developer Publisher First release Systems Local LAN Online Formerly
 
Game Developer Publisher First release Systems Local LAN Online Formerly
Line 24: Line 31:
 
tables=Infobox_game,Multiplayer
 
tables=Infobox_game,Multiplayer
 
|join on=Infobox_game._pageName=Multiplayer._pageName
 
|join on=Infobox_game._pageName=Multiplayer._pageName
−
|where=Infobox_game.License='Freeware'
+
|where=Infobox_game.License='Freeware' OR License='Former commercial'
 
|fields=Infobox_game._pageName,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Infobox_game.Available_on,Multiplayer.Local,Multiplayer.LAN,Multiplayer.Online,Infobox_game.License
 
|fields=Infobox_game._pageName,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Infobox_game.Available_on,Multiplayer.Local,Multiplayer.LAN,Multiplayer.Online,Infobox_game.License
 
|format=table
 
|format=table

Revision as of 02:49, 16 October 2021

{{#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 }}


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

_pageName Developers Publishers Released Available on Local LAN Online License
.kkrieger Company:.theprodukkt 2004-04-10 Windows Freeware
"LIFE" not found Company:BerCh1n Company:BerCh1n 2022-06-23 Windows freeware
0 A.D. Company:Wildfire Games Windows • OS X • Linux true true Freeware
1001 Hugs Company:Aigul Aubanova 2019-09-26 Windows freeware
101010 Company:Jenny Chen • Company:Changcheng Fu • Company:Hunter Huynh • Company:Miranda Liu • Company:Eric Shen Company:Hunter Huynh 2019-10-03 Windows freeware

More...



|format=template |named args=yes |limit=5

|intro=

|template=Freeware list/row |outro=
Game Developer Publisher First release Systems Local LAN Online Formerly
commercial