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 "List of games delisted from Bethesda.net"

From PCGamingWiki, the wiki about fixing PC games
(Created page with "This is a list of games on PCGamingWiki marked as being available for purchase on Bethesda.net. ==Auto-populated list== '''Total number of games: '''{{...")
 
(migrated to Cargo query)
Line 2: Line 2:
  
 
==Auto-populated list==
 
==Auto-populated list==
−
'''Total number of games: '''{{#ask: [[Category:Games]] [[Available from::Bethesda.net]] |format=count }}
+
'''Total number of games: '''{{#cargo_query:
 +
tables=Availability
 +
|fields=COUNT(*)
 +
|where=Available_from HOLDS LIKE 'Bethesda.net'
 +
|format=text
 +
}}
  
−
{{#ask: [[Category:Games]] [[Available from::Bethesda.net]]
+
{{#cargo_query:
−
|?Part of series=Series
+
tables=Infobox_game,Availability
−
|?Developed by
+
|join on=Infobox_game._pageName=Availability._pageName
−
|?Published by
+
|where=Availability.Available_from HOLDS LIKE 'Bethesda.net'
−
|?Release date|+limit=1
+
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on
−
|format=table
+
|format=template
−
|limit=300
+
|named args=yes
−
|template=Feature/row
+
|limit=200
−
|introtemplate=Feature/intro
+
|intro={{Game list/intro}}
−
|outrotemplate=Feature/outro
+
|template=Game list/row
−
|sep=, 
+
|outro=</table>
−
|mainlabel=Game
 
−
|headers=plain
 
 
}}
 
}}
  
 
[[Category:Lists]]
 
[[Category:Lists]]

Revision as of 05:56, 26 September 2021

This is a list of games on PCGamingWiki marked as being available for purchase on Bethesda.net.

Auto-populated list

Total number of games:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Availability._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__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 'Bethesda.net') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100

No results