query:
select distinct tag, count(tagid) as tag_count from link_tags t INNER JOIN tags using (tagid) INNER JOIN links l using (linkid) where l.status='ALL' and l.is_spam='0' and l.urlid=4334073 group by tag order by count(tag) desc limit 500;