Query to get all thread ID's for a user

[tpearl5]

This query will get all thread ID's for a specific user. I use it to see how much traffic a specific user's threads are getting by plugging the ID's into Analytics (a simple replace of /r/n with | in Notepad++ does the job for the required format)

SELECT  `threadid` FROM  `thread` WHERE  `postusername` LIKE  'USERNAME' ORDER BY `threadid` DESC;