Finding all sticky posts

[kgroneman]

I've got a lot of forums and a lot of moderators. Sometimes they forget about a sticky post and it gets out of date and needs to be unstuck.

This sql query will show all sticky posts: SELECT * FROM `vb_thread` WHERE sticky = 1

However, it doesn't give me the information in easily readable format I'm looking for. What I want is a query that will show me:

• The specific forum
• The title of the sticky post
• The author of the post

Would someone that knows a lot more about querying be able to help me refine my query to show that information? I would be very appreciative.

Thanks in advance. - Kim