Query returned no rows: SELECT e1.* , g1.fullname as groupname FROM events e1 left join groups g1 on e1.groupid = g1.groupid WHERE (e1.statusid = 2 or e1.statusid = 3) AND e1.eventid = 96