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
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 LIKE 'Steam' AND Infobox_game.Available_on HOLDS LIKE '%'
 
|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 82: Line 83:
 
|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 '%')
+
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS NOT LIKE '%' AND Infobox_game.Available_on HOLDS LIKE '%'
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
Line 90: Line 91:
 
|fields=COUNT(*)
 
|fields=COUNT(*)
 
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '197%'
 
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS LIKE '197%'
 +
|format=text
 +
}}''' games
 +
* [[List of games available on Steam (Upcoming or marked as TBA, while not being marked as unavailable)]] - '''{{#cargo_query:
 +
tables=Availability,Infobox_game
 +
|join on=Infobox_game._pageName=Availability._pageName
 +
|fields=COUNT(*)
 +
|where=Availability.Available_from HOLDS LIKE 'Steam' AND Infobox_game.Released HOLDS NOT LIKE '%' AND Infobox_game.Available_on HOLDS NOT LIKE '%'
 
|format=text
 
|format=text
 
}}''' games
 
}}''' games
  
 
[[Category:Lists]]
 
[[Category:Lists]]

Revision as of 07:17, 29 March 2022

This is a list of games believed to be available on Steam.

Due to the amount of games on Steam being north of

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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Available_on` WHERE `_value`LIKE '%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

, the list is divided into subfiles depending on the games' original release years:

Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND (`cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '198%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '199%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '200%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2010%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2011%') ) ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2012-14) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND (`cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2012%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2013%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2014%') ) ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2015) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2015%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2016) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2016%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2017) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2017%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2018) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2018%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2019) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2019%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2020-21) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND (`cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2020%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2021%') ) ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

  • List of games available on Steam (Originally released in 2022-23) -
    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`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND (`cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2022%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2023%') ) ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND (`cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2024%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2025%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2026%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2027%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2028%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2029%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2030%') OR `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '2040%') ) ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '%') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Available_on` WHERE `_value`LIKE '%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '197%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games

Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Steam') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '%') AND `cargo__Infobox_game`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Infobox_game__Available_on` WHERE `_value`LIKE '%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100

games