select students.lname, students.fname, subjects.name, entries.name
from students
left join subjects on students.id = subjects.student_id
left join entries  on subjects.id = entries.subject_id
where students.id = ?
order by students.Sex, students.lname, students.fname