SELECT FirstName, LastName, PhoneNumber, members.MemberID AS MemberID FROM members LEFT JOIN phone_numbers ON ( members.MemberID=phone_numbers.MemberID AND phone_numbers.PhoneNumberID IN (SELECT MIN(PhoneNumberID) FROM phone_numbers GROUP BY MemberID) ) WHERE Verified=1 ORDER BY LastName, FirstName, members.MemberID;