MySql not using index with IN and subquery

Random Question:

Joe has 5 lines of code and Fred has 10 lines of code, then who has the most lines of code?

Recipient Name:

Recipient Email Address:

Email Subject:

Message:

Send Page to a Friend