SELECT COUNT(topic.teme_id) as numcom, sum(if('2012-05-19 15:31:09' < 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='42' AND topic.teme_id=teme.teme_id
GROUP BY topic.teme_id
order by teme.lasttime DESC LIMIT 0, 30
| ответы | Название темы | просмотры | дата и автор | последнее сообщение | | 1 | + dfgdfgdsf g | 592 |
 Maxim(2008:05:16 в 00:09) |
Maxim(2008:05:16 в 00:09) | | |
|
|
|