|
SELECT COUNT(topic.teme_id) as numcom, sum(if('2012-05-19 15:36:43' < 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='41' AND topic.teme_id=teme.teme_id
GROUP BY topic.teme_id
order by teme.lasttime DESC LIMIT 0, 30 |
|
|
|