Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software
Select top 10 p.id, p.body, p.ownerdisplayname, p.tags from posts p, posttags pt, tags t where p.id = pt.postid and pt.tagid = t.id and t.tagname in ('html','css'); /*Select count(*) from posts where tags like '%html%' or tags like '%css%';*/