10 May 2006 15:05:22 xpdb::readQuery() [mode split] - query took 21.629260063171 seconds: select xp.users.userid, xp.users.login, xp.users.accesslv, xp.users.mod_fg, xp.users.mod_bg, xp.users.mod_border, xp.users.comments, xp.users.rating, xp.users.salute, viewed.v_viewed, posts.msg, posts.to_uid, posts.replies, posts.user, posts.duedate, posts.lastdate, posts.date, posts.featureid, posts.styleid, posts.thumbnail, posts.large, post_image_id, posts.postid, posts.bitfield, posts.rank, posts.title, posts.parentid, posts.post_rating, posts.post_org, posts.post_city, posts.post_state, posts.post_country, posts.xpid, posts.ip, to_days(now()) - to_days(posts.date) as daycount from xp.users,posts,viewed where posts.postid = viewed.v_postid and xp.users.userid=posts.userid and posts.typeid=0 and rank>=0 and parentid=0 and featureid in (1, 2, 3, 4, 11, 7, 8) order by lastdate desc limit 0,25 # printForumTopicsByQuery # /hot.html