Permalink
Fetching contributors…
Cannot retrieve contributors at this time
7 lines (5 sloc) 165 Bytes
insert into Participant (user_id, game_id, joinedOn)
select owner_id, game_id, min(creationDate)
from TagEntry
group by owner_id, game_id
order by creationDate asc