select buywords.word, count(buywordoccurrence.wordid) as occurrence, buywordoccurrence.compid from buywords, buywordoccurrence where buywords.wordid = buywordoccurrence.wordid and buywordoccurrence.compid in (214264,705772) group by buywords.wordid order by occurrence desc limit 0, 20