I vote for normalizing too... then this query becomes trivial. Been down the unnormalized path once before and it was not a place I want to go again. The time you take to normalize with make the rest of this super easy and fast.