Difference between revisions of "List of DRM-free games"
(migrated to Cargo query) |
|||
Line 6: | Line 6: | ||
|- | |- | ||
| [[List of games available on Amazon.com|Amazon.com]] | | [[List of games available on Amazon.com|Amazon.com]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Amazon_US_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Amazon US' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of games available on Amazon.co.uk|Amazon.co.uk]] | | [[List of games available on Amazon.co.uk|Amazon.co.uk]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Amazon_UK_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Amazon UK' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on Epic Games Store|Epic Games Store]] | | [[List of DRM-free games on Epic Games Store|Epic Games Store]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Epic_Games_Store_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Epic Games Store' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on GamersGate|GamersGate]] | | [[List of DRM-free games on GamersGate|GamersGate]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.GamersGate_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'GamersGate' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of games available on Gamesplanet|Gamesplanet]] | | [[List of games available on Gamesplanet|Gamesplanet]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Gamesplanet_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Gamesplanet' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on GOG.com|GOG.com]] | | [[List of DRM-free games on GOG.com|GOG.com]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.GOGcom_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'GOG.com' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on Humble Store|Humble Store]] | | [[List of DRM-free games on Humble Store|Humble Store]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Humble_Store_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Humble Store' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of games available on itch.io|itch.io]] | | [[List of games available on itch.io|itch.io]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.itchio_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'itch.io' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on Microsoft Store|Microsoft Store]] | | [[List of DRM-free games on Microsoft Store|Microsoft Store]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Microsoft_Store_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Microsoft Store' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on Origin|Origin]] | | [[List of DRM-free games on Origin|Origin]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.EA_Desktop_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'EA Desktop' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on Steam|Steam]] | | [[List of DRM-free games on Steam|Steam]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Steam_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Steam' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of DRM-free games on Ubisoft Store|Ubisoft Store]] | | [[List of DRM-free games on Ubisoft Store|Ubisoft Store]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Ubisoft_Store_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Ubisoft Store' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
| [[List of games available on ZOOM Platform|ZOOM Platform]] | | [[List of games available on ZOOM Platform|ZOOM Platform]] | ||
− | || {{# | + | || {{#cargo_query: |
− | || {{# | + | tables=Availability |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Zoom_Platform_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} | ||
+ | || {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'Zoom Platform' | ||
+ | |format=text | ||
+ | }} | ||
|- | |- | ||
|} | |} | ||
[[Category:Lists]] | [[Category:Lists]] |
Revision as of 06:33, 3 October 2021
This is a list of games on PCGamingWiki marked as being released (as of June 5, 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/Uplay, 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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE '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`LIKE 'Zoom Platform') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100 |