McGaiser

$venues = $this->PrestigeLogs->PrestigeLogsItems->Venues->find('list')->contain(['Games'])->group(['Games.id'])->toArray();

Creates error:
Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'camarilla.Venues.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SQL Query:
SELECT Venues.id AS `Venues__id`, Venues.domain_id AS `Venues__domain_id`, Venues.continuity_id AS `Venues__continuity_id`, Venues.game_id AS `Venues__game_id`, Venues.created AS `Venues__created`, Venues.modified AS `Venues__modified`, Games.id AS `Games__id`, Games.parent_id AS `Games__parent_id`, Games.lft AS `Games__lft`, Games.rght AS `Games__rght`, Games.name AS `Games__name`, Games.abbreviation AS `Games__abbreviation`, Games.description AS `Games__description`, Games.created AS `Games__created`, Games.modified AS `Games__modified` FROM venues Venues LEFT JOIN gam