Using mysql its pretty easy to get a page (lets say 20) of threads. However i'd like to push up stickies. Whats the best way to do this? One way i thought was to use two queries, the first getting the sticky (if on first page) the next a regular query excluding stickies. But i still need to substract the amount of stickies so it seems like i need to make two queries each time.

I could also write one which may be better but it may need a subquery which is bad? i am actually not sure how to write this

I'm sure there is a pretty good way but i dont know much about mysql so what do you guys suggest?

Originally asked by: acidzombie24 on Stack Overflow