Difference between revisions of "List of games available on Battle.net"
(Created page with "This is a list of games on PCGamingWiki marked as being available for purchase or download on Battle.net. ==Auto-populated list== '''Total number of game...") |
(→Auto-populated list: migrated game count to Cargo) |
||
(One intermediate revision by the same user not shown) | |||
Line 2: | Line 2: | ||
==Auto-populated list== | ==Auto-populated list== | ||
− | '''Total number of games: '''{{# | + | '''Total number of games: '''{{#cargo_query: |
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Available_from HOLDS LIKE 'Battle.net' | ||
+ | |format=text | ||
+ | }} | ||
− | {{# | + | {{#cargo_query: |
− | + | tables=Infobox_game,Availability | |
− | + | |join on=Infobox_game._pageName=Availability._pageName | |
− | + | |where=Availability.Available_from HOLDS LIKE 'Battle.net' | |
− | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |
− | + | |format=template | |
− | + | |named args=yes | |
− | + | |limit=200 | |
− | + | |intro={{Game list/intro}} | |
− | + | |template=Game list/row | |
− | + | |outro=</table> | |
− | |||
− | |||
− | |||
}} | }} | ||
[[Category:Lists]] | [[Category:Lists]] |
Revision as of 04:27, 26 September 2021
This is a list of games on PCGamingWiki marked as being available for purchase or download on Battle.net.
Auto-populated list
Total number of games:
Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,COUNT(*) FROM `cargo__Availability` WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Battle.net') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100