Yackem

I don't know enough about nested queries so I went ahead and made two separate queries. The end result is what I needed. Thanks.

Greetings. I own a message board and have recently added new Topic Types outside of the regular normal, stickies, global...etc. Currently the sql looks as follows: SELECT t.topic_type FROM phpbb_topics t WHERE t.forum_id = 2 AND t.topic_type IN (0,1,2,3,4,5,6,7,8,9) ORDER BY t.topic_type DESC, t.topic_last_post_time DESC The output shows topic_type 9 9 9 8 8 8 . . . I would like for the entries that have t.topic_type = 1 always be listed first and ordered by t.topic_last_post_time ASC. And then the remaining entries just ordered by t.topic_last_post_time DESC. So an output like this. topic_type 1 1 1 1 1 1 4 5 3 . . Can anyone point me in the right direction as to get this accomplished? Thanks