SELECT  hobbies.id,membershobbies.hobbyid
FROM hobbies LEFT JOIN membershobbies on membershobbies.hobbyID=hobbies.id RIGHT JOIN members ON members.id = membershobbies.memberid
WHERE members.id=1