SQL=SELECT DISTINCT c.id, artid, file, title, description, cat.art_title
FROM campaigns as c, catbyid as cat, artbyid as art
WHERE (cat.category = 'Shameless Self-Promotion') and (art.category = 'Shameless Self-Promotion')
and (c.id = cat.emailid) and (c.id = art.emailid)
GROUP BY c.id, artid