[Grooverider]

I don't see a way to get around the use of distinct, as the keyword ID is erpeating. Incidentally, the execution time of the above query is 0.01s on a 1m row database, so the performance is acceptable.