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 available on Steam"

From PCGamingWiki, the wiki about fixing PC games
m
 
(4 intermediate revisions by 2 users not shown)
Line 2: Line 2:
  
 
Due to the amount of games on Steam being north of '''{{#cargo_query:
 
Due to the amount of games on Steam being north of '''{{#cargo_query:
tables=Availability
+
tables=Availability,Infobox_game
 +
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Available_from HOLDS LIKE 'Steam'
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Available_on HOLDS LIKE '%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''', the list is divided into subfiles depending on the games' original release years:
 
}}''', the list is divided into subfiles depending on the games' original release years:
Line 12: Line 14:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND (Infobox_game.Released HOLDS LIKE '198%' OR Infobox_game.Released HOLDS LIKE '199%' OR Infobox_game.Released HOLDS LIKE '200%' OR Infobox_game.Released HOLDS LIKE '2010%' OR Infobox_game.Released HOLDS LIKE '2011%')
+
|where=Availability.Available_from HOLDS 'Steam' AND (Infobox_game.Released HOLDS LIKE '198%' OR Infobox_game.Released HOLDS LIKE '199%' OR Infobox_game.Released HOLDS LIKE '200%' OR Infobox_game.Released HOLDS LIKE '2010%' OR Infobox_game.Released HOLDS LIKE '2011%')
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 19: Line 22:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND (Infobox_game.Released HOLDS LIKE '2012%' OR Infobox_game.Released HOLDS LIKE '2013%' OR Infobox_game.Released HOLDS LIKE '2014%')
+
|where=Availability.Available_from HOLDS 'Steam' AND (Infobox_game.Released HOLDS LIKE '2012%' OR Infobox_game.Released HOLDS LIKE '2013%' OR Infobox_game.Released HOLDS LIKE '2014%')
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 26: Line 30:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '2015%'
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2015%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 33: Line 38:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '2016%'
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2016%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 40: Line 46:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '2017%'
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2017%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 47: Line 54:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '2018%'
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2018%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 54: Line 62:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '2019%'
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2019%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 61: Line 70:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND (Infobox_game.Released HOLDS LIKE '2020%' OR Infobox_game.Released HOLDS LIKE '2021%')
+
|where=Availability.Available_from HOLDS 'Steam' AND (Infobox_game.Released HOLDS LIKE '2020%' OR Infobox_game.Released HOLDS LIKE '2021%')
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 68: Line 78:
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND (Infobox_game.Released HOLDS LIKE '2022%' OR Infobox_game.Released HOLDS LIKE '2023%')
+
|where=Availability.Available_from HOLDS 'Steam' AND (Infobox_game.Released HOLDS LIKE '2022%' OR Infobox_game.Released HOLDS LIKE '2023%')
 +
|group by=Infobox_game._pageNamespace
 +
|format=text
 +
}}''' games
 +
* [[List of games available on Steam (Originally released in 2024 or later)]] - '''{{#cargo_query:
 +
tables=Availability,Infobox_game
 +
|join on=Infobox_game._pageName=Availability._pageName
 +
|fields=COUNT(*)
 +
|where=Availability.Available_from HOLDS 'Steam' AND (Infobox_game.Released HOLDS LIKE '2024%' OR Infobox_game.Released HOLDS LIKE '2025%' OR Infobox_game.Released HOLDS LIKE '2026%' OR Infobox_game.Released HOLDS LIKE '2027%' OR Infobox_game.Released HOLDS LIKE '2028%' OR Infobox_game.Released HOLDS LIKE '2029%' OR Infobox_game.Released HOLDS LIKE '2030%' OR Infobox_game.Released HOLDS LIKE '2040%')
 +
|group by=Infobox_game._pageNamespace
 +
|format=text
 +
}}''' games
 +
* [[List of games available on Steam (Early Access or unknown release year)]] - '''{{#cargo_query:
 +
tables=Availability,Infobox_game
 +
|join on=Infobox_game._pageName=Availability._pageName
 +
|fields=COUNT(*)
 +
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS NOT LIKE '%' AND Infobox_game.Available_on HOLDS LIKE '%'
 +
|group by=Infobox_game._pageNamespace
 +
|format=text
 +
}}''' games
 +
* [[List of games available on Steam (Games with release year database problems)]] - '''{{#cargo_query:
 +
tables=Availability,Infobox_game
 +
|join on=Infobox_game._pageName=Availability._pageName
 +
|fields=COUNT(*)
 +
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '197%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
* [[List of games available on Steam (Originally released in 2024 or later)]]
+
* [[List of games available on Steam (Upcoming or marked as TBA, while not being marked as unavailable)]] - '''{{#cargo_query:
* [[List of games available on Steam (Early Access)]] - '''{{#cargo_query:
 
 
tables=Availability,Infobox_game
 
tables=Availability,Infobox_game
 
|join on=Infobox_game._pageName=Availability._pageName
 
|join on=Infobox_game._pageName=Availability._pageName
 
|fields=COUNT(*)
 
|fields=COUNT(*)
|where=Availability.Available_from HOLDS LIKE 'Steam' AND (Infobox_game.Released HOLDS NOT LIKE '%' OR Infobox_game.Released HOLDS LIKE '197%')
+
|where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS NOT LIKE '%' AND Infobox_game.Available_on HOLDS NOT LIKE '%'
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
  
 
[[Category:Lists]]
 
[[Category:Lists]]

Latest revision as of 20:54, 30 May 2023