Here is my query
SELECT mod_article.*, community.name as cname, subcategories.name as cname
FROM mod_article, community, subcategories
WHERE
(mod_article.community=community.nId ¦¦ mod_article.community='')
AND mod_article.subcategory like ';110;'
AND mod_article.cId like '%;81;%'
AND mod_article.enabled ='1'
AND mod_article.expire >='2007-01-16'

Right now it grabs 350 results... all duplicates, There are three results that it should pull.
If i remove the subcategory information, it pulls three results like it should.

One small change I need to make is on
AND mod_article.subcategory like ';110;'
I would like mod_article.subcategory like ';subcategories.sId;' However this is taking subcategories.sId as a literal string and not trying to match.