Difference between revisions of "List of games available on Steam"
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.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 13: | Line 13: | ||
|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 '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%') |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 20: | Line 20: | ||
|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 '2012%' OR Infobox_game.Released HOLDS LIKE '2013%' OR Infobox_game.Released HOLDS LIKE '2014%') |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 27: | Line 27: | ||
|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 '2015%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 34: | Line 34: | ||
|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 '2016%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 41: | Line 41: | ||
|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 '2017%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 48: | Line 48: | ||
|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 | ||
}}''' games | }}''' games | ||
| Line 55: | Line 55: | ||
|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 '2019%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 62: | 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 | + | |where=Availability.Available_from HOLDS 'Steam' AND (Infobox_game.Released HOLDS LIKE '2020%' OR Infobox_game.Released HOLDS LIKE '2021%') |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 69: | Line 69: | ||
|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 '2022%' OR Infobox_game.Released HOLDS LIKE '2023%') |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 76: | Line 76: | ||
|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 '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%') |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 83: | 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 | + | |where=Availability.Available_from HOLDS 'Steam' AND Infobox_game.Released HOLDS NOT LIKE '%' AND Infobox_game.Available_on HOLDS LIKE '%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 90: | Line 90: | ||
|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 '197%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
| Line 97: | Line 97: | ||
|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 NOT LIKE '%' AND Infobox_game.Available_on HOLDS NOT LIKE '%' |
|format=text | |format=text | ||
}}''' games | }}''' games | ||
[[Category:Lists]] | [[Category:Lists]] | ||
Revision as of 07:55, 23 April 2023
This is a list of games believed to be available on Steam.
Due to the amount of games on Steam being north of
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__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:
- List of games available on Steam (Originally released in 2011 or earlier) - 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`= '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`= '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`= '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`= '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`= '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`= '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`= '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`= '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`= '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
- List of games available on Steam (Originally released in 2024 or later) - 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`= '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
- List of games available on Steam (Early Access or unknown release year) - 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`= '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
- List of games available on Steam (Games with release year database problems) - 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`= '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
- List of games available on Steam (Upcoming or marked as TBA, while not being marked as unavailable) - 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`= '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