Difference between revisions of "List of DRM-free games"
m (List of DRM-free games on itch.io) |
m (HOLDS LIKE -> HOLDS) |
||
| Line 9: | Line 9: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Amazon_US_DRM HOLDS | + | |where=Availability.Amazon_US_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 15: | Line 15: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Amazon US' |
|format=text | |format=text | ||
}} | }} | ||
| Line 23: | Line 23: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Amazon_UK_DRM HOLDS | + | |where=Availability.Amazon_UK_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 29: | Line 29: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Amazon UK' |
|format=text | |format=text | ||
}} | }} | ||
| Line 37: | Line 37: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Epic_Games_Store_DRM HOLDS | + | |where=Availability.Epic_Games_Store_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 43: | Line 43: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Epic Games Store' |
|format=text | |format=text | ||
}} | }} | ||
| Line 51: | Line 51: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.GamersGate_DRM HOLDS | + | |where=Availability.GamersGate_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 57: | Line 57: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'GamersGate' |
|format=text | |format=text | ||
}} | }} | ||
| Line 65: | Line 65: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Gamesplanet_DRM HOLDS | + | |where=Availability.Gamesplanet_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 71: | Line 71: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Gamesplanet' |
|format=text | |format=text | ||
}} | }} | ||
| Line 79: | Line 79: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.GOGcom_DRM HOLDS | + | |where=Availability.GOGcom_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 85: | Line 85: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'GOG.com' |
|format=text | |format=text | ||
}} | }} | ||
| Line 93: | Line 93: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Humble_Store_DRM HOLDS | + | |where=Availability.Humble_Store_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 99: | Line 99: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Humble Store' |
|format=text | |format=text | ||
}} | }} | ||
| Line 107: | Line 107: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.itchio_DRM HOLDS | + | |where=Availability.itchio_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 113: | Line 113: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'itch.io' |
|format=text | |format=text | ||
}} | }} | ||
| Line 121: | Line 121: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Microsoft_Store_DRM HOLDS | + | |where=Availability.Microsoft_Store_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 127: | Line 127: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Microsoft Store' |
|format=text | |format=text | ||
}} | }} | ||
| Line 135: | Line 135: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.EA_Desktop_DRM HOLDS | + | |where=Availability.EA_Desktop_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 141: | Line 141: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'EA Desktop' |
|format=text | |format=text | ||
}} | }} | ||
| Line 149: | Line 149: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Steam_DRM HOLDS | + | |where=Availability.Steam_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 155: | Line 155: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Steam' |
|format=text | |format=text | ||
}} | }} | ||
| Line 163: | Line 163: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Ubisoft_Store_DRM HOLDS | + | |where=Availability.Ubisoft_Store_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 169: | Line 169: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Ubisoft Store' |
|format=text | |format=text | ||
}} | }} | ||
| Line 177: | Line 177: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Zoom_Platform_DRM HOLDS | + | |where=Availability.Zoom_Platform_DRM HOLDS 'DRM-free' |
|format=text | |format=text | ||
}} | }} | ||
| Line 183: | Line 183: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| − | |where=Availability.Available_from HOLDS | + | |where=Availability.Available_from HOLDS 'Zoom Platform' |
|format=text | |format=text | ||
}} | }} | ||
Revision as of 19:57, 2 October 2022
This is a list of games on PCGamingWiki marked as being released (as of September 21, 2024) and available for purchase on various platforms and flagged as DRM-free. Note that this list tracks confirmed DRM-free titles so it is possible the number of DRM-free titles on a platform is in reality higher than shown here. The inaccuracy is due to insufficient testing as often the used DRM on a platform is assumed to be the 'default' for that platform (e.g. DRM protected on Steam/Origin/Ubisoft Store, and DRM-free on GOG.com, etc).
| Platform | DRM-free titles | Out of |
|---|---|---|
| Amazon.com | 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__Amazon_US_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Amazon US') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Amazon.co.uk | 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__Amazon_UK_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Amazon UK') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Epic Games Store | 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__Epic_Games_Store_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Epic Games Store') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| GamersGate | 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__GamersGate_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'GamersGate') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Gamesplanet | 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__Gamesplanet_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Gamesplanet') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| GOG.com | 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__GOGcom_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'GOG.com') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Humble Store | 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__Humble_Store_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Humble Store') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| itch.io | 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__itchio_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'itch.io') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Microsoft Store | 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__Microsoft_Store_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Microsoft Store') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Origin | 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__EA_Desktop_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'EA Desktop') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Steam | 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__Steam_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Steam') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| Ubisoft Store | 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__Ubisoft_Store_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Ubisoft Store') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
| ZOOM Platform | 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__Zoom_Platform_DRM` WHERE `_value`= 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |
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`= 'Zoom Platform') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |