[chrispadfield]

well you should put it in usercp.php but it is a bit more complicated than that, you need to create some custom templates and to gettemplate() based around the query.

You need probably 1 template for the basis of the section on emails and another for each email, call it email_bit

then loop through, generating email_bit.

If it was you, i would look at the code for the subscribed threads, or private messages and compare it to that. You have the SQL query (the hardest bit) already.