Export threads from a single user / Query modification

[tischtelefon2]

Hi all,

I need a bit support. A good friend of mine died and he actively posted in my forum and started several threads. So I would like to export all threads my friend started including the first post he wrote. I'd like to use this as a kind of memorial for all of his friends.

The following query does a good job to get all of his postings, but I only want to export the threads including the first post. Could anyone help me how to modify the query?

SELECT post.postid, post.threadid, thread.title, post.username, FROM_UNIXTIME(post.dateline) as date, post.pagetext from post, thread WHERE post.threadid = thread.threadid AND post.username = 'XXXXXXXXXX' ORDER BY date;

Thanks so much.

Michael