select aso.value as word,count(aso.ID) as size from atSelectOptionsSelected asos, atSelectOptions aso, CollectionAttributeValues cav, (select cv.cvID, cv.cID from Pages p1 inner join CollectionVersions cv on cv.cID = p1.cID WHERE cvIsApproved=1 AND p1.cIsTemplate = 0) cvt where asos.avID = cav.avID AND aso.ID = asos.atSelectOptionID AND cav.cvID = cvt.cvID AND cav.cID = cvt.cID AND aso.akID in (33) group by aso.ID order by size desc