Difference between revisions of "User:Garrett/Sandbox"
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:
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 |
|format=template
|named args=yes
|limit=5
|intro=
|template=Freeware list/row |outro=Game | Developer | Publisher | First release | Systems | Local | LAN | Online | Formerly commercial |
---|