| select forum_topic.notifies,forum_topic.id_topic,forum_topic.id_cat,forum_topic.id_board ,forum_puser.name,forum_puser.surname
from forum_topic
Left Join forum_categories ON forum_categories.id_cat = forum_topic.id_cat
Left Join forum_puser ON forum_puser.pid = forum_topic.id_member_started
where
forum_topic.bin='S'
and forum_topic.topic_type='To'
and forum_topic.id_forum=1
and forum_categories.type_cat = 'G'
order by forum_topic.numreplies desc limit 0,5 | |
