Difference between revisions of "List of games available on Steam (Originally released in 2018)"
m (→top: General maintenance with AutoWikiBrowser in Bot mode) |
m (removed LIKE operator where applicable) |
||
Line 5: | Line 5: | ||
|join on=Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=Availability._pageName | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
− | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2018%' |
|format=text | |format=text | ||
}} | }} | ||
Line 11: | Line 11: | ||
tables=Infobox_game,Availability | tables=Infobox_game,Availability | ||
|join on=Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=Availability._pageName | ||
− | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS LIKE '2018%' |
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | ||
|format=template | |format=template |
Revision as of 08:07, 23 April 2023
This is a list of games believed to be available on Steam, and whose original releases (May not necessarily have been on Steam) were in 2018. For other eras, see List of games available on Steam.
Total number of 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`= '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