i haven't looked up the database table names and field names, so that code below won't work out of the box. But something very similar to that should work:
SELECT
*
FROM
posts
WHERE
parentid > 0
ORDER BY
dateline DESC LIMIT 100
(parentid - or whatever it is actually called in the database excludes threads).
No time to start phpmyadmin in order to check the real names, sorry. Hope that code helps anyway.
|