View Single Post
  #1  
Old 30 Aug 2017, 18:42
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Question Finding all sticky posts

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
Reply With Quote