SELECT COUNT(topic.teme_id) as numcom, sum(if('2012-02-06 01:32:44' < topic.data,1,0)) as newnumcom, MAX(topic.topic_id) as last_topic ,
UNIX_TIMESTAMP(teme.lasttime) as lasttime, teme.counter, teme.user_id, teme.user_anonim, teme.close,
teme.last_anonim,teme.lastuser_id,teme.ico_id, UNIX_TIMESTAMP(teme.data) as data,teme.name_teme,teme.teme_id
FROM forums_teme as teme, forums_topic as topic WHERE
teme.forum_id='35' AND topic.teme_id=teme.teme_id
GROUP BY topic.teme_id
order by teme.lasttime DESC LIMIT 0, 30
| ответы | Название темы | просмотры | дата и автор | последнее сообщение | |
|
|
|