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 (28) group by aso.ID order by size desc

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 (29) group by aso.ID order by size desc