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 DRM-free games"

From PCGamingWiki, the wiki about fixing PC 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]]
|| {{#ask: [[Category:Games]] [[Available from::Amazon.com]] [[Amazon DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Amazon.com]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Amazon.co.uk]] [[Amazon UK DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Amazon.co.uk]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Epic Games Store]] [[Epic Games Store DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Epic Games Store]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::GamersGate]] [[GamersGate DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::GamersGate]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Gamesplanet]] [[Gamesplanet DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Gamesplanet]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::GOG.com]] [[GOGcom DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::GOG.com]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Humble Store]] [[Humble Store DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Humble Store]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::itch.io]] [[Itchio DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::itch.io]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Microsoft Store]] [[Microsoft Store DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Microsoft Store]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Origin]] [[Origin DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Origin]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Steam]] [[Steam DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Steam]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::Ubisoft Store]] [[Ubisoft Store DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::Ubisoft Store]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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]]
|| {{#ask: [[Category:Games]] [[Available from::ZOOM Platform]] [[ZOOM Platform DRM::DRM-free]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
|| {{#cargo_query:
|| {{#ask: [[Category:Games]] [[Available from::ZOOM Platform]] [[Release date::<{{CURRENTMONTHNAME}} {{CURRENTDAY}},  {{CURRENTYEAR}}]] |format=count }}
+
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