Because user 110 already has a row in the campaigns table, I wasn't expecting to get any rows back when executing this query....but I ended up getting a total count of how many guides user 110 has. Did I screw up my double join query?
SELECT COUNT(*) as total
FROM (users INNER JOIN users as guides ON guides.uid = users.guide)
LEFT OUTER JOIN campaigns
ON campaigns.uID = users.uID
AND campaigns.campaign = 'Upgrade to gold'
AND campaigns.answer IS NULL
WHERE users.guide = 110;