SELECT Title, Hours, mDate, StudentID, MeetingID, MeetingTypeiD
FROM meetings m
INNER JOIN userdetails u ON u.UserID = m.StudentID
AND u.Level =40
AND StudentID =758
AND m.MeetingStatusID =2
AND YEAR( m.mDate ) =2011
AND MONTH( m.mDate ) =5
AND (
MeetingTypeID
IN ( 30, 32, 27, 26, 38 )
OR (
MeetingTypeID
IN ( 23, 36, 31, 33 )
AND StudentID NOT
IN ( 58, 747, 643, 803, 793 ) ))