SELECT t1.CachedValue, t2.CachedValue, t3.CachedValue, t4.CachedValue, t5.CachedValue, t6.CachedValue FROM CachedFilterValue t1 INNER JOIN CachedFilterValue t2 ON (t1.CachedFilterRowId = t2.ParentFilterRowId AND t2.CachedFilterId = 197796 AND t2.FilterIndex = 2 ) INNER JOIN CachedFilterValue t3 ON (t2.CachedFilterRowId = t3.ParentFilterRowId AND t3.CachedFilterId = 197796 AND t3.FilterIndex = 3 ) INNER JOIN CachedFilterValue t4 ON (t3.CachedFilterRowId = t4.ParentFilterRowId AND t4.CachedFilterId = 197796 AND t4.FilterIndex = 4 ) INNER JOIN CachedFilterValue t5 ON (t4.CachedFilterRowId = t5.ParentFilterRowId AND t5.CachedFilterId = 197796 AND t5.FilterIndex = 5 ) INNER JOIN CachedFilterValue t6 ON (t5.CachedFilterRowId = t6.ParentFilterRowId AND t6.CachedFilterId = 197796 AND t6.FilterIndex = 6 ) WHERE t1.FilterIndex = 1 AND t1.CachedFilterId = 197796 AND t1.CachedValue IN ( 'LIST OF 165 VALUES')