Query returned no rows: SELECT e1.*, c1.category, (select count(e2.signupid) from eventsign e2 WHERE e2.eventid = e1.eventid and e2.status = 'Signed Up' and e2.waitlist = 0) as countsold , p1.name as presentname, p1.company as presentcompany, p1.location as presentloc, p1.email as presentemail, p1.url as presenturl, p1.biodesc FROM events as e1 LEFT JOIN eventpresent p1 on e1.presenterid = p1.presenterid LEFT JOIN eventcat c1 on e1.categoryid = c1.categoryid WHERE e1.status = 'Active' AND e1.eventid = 689