$defaultSelectClause, (select group_concat(distinct venues.venue_code order by (position.start_date) asc) from linked_positions join venues on linked_positions.VENUE_ID = venues.id join position on position.id = linked_positions.position_id where set_id = positionView.linked_positions order by position.start_date) as linkedVenues $defaultTableClause ($defaultWhereClause) AND positionView.status is not null $defaultSelectClause $defaultTableClause ($defaultWhereClause)