Exhibition not found SELECT DISTINCT exhibitions.*, UNIX_TIMESTAMP(exhibitions.start_date) as start_timestamp, UNIX_TIMESTAMP(exhibitions.end_date) as end_timestamp, members.id AS memberID, members.surname, members.firstname FROM exhibitions LEFT JOIN exhibition_members ON exhibition_members.exhibition_id=exhibitions.id INNER JOIN members ON members.id=exhibition_members.member_id WHERE exhibitions.id='85' AND exhibitions.display='1' ORDER BY members.surname, members.firstname, members.id