I think I've worked out how to limit the results to only the latest comment for each blog... New version up in a minute

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT blog_text.blogid, blog_text.state, blog_text.blogtextid, blog_text.username, blog_text.userid, date( FROM_UNIXTIME( blog_text.dateline ) ) AS date, time( FROM_UNIXTIME( blog_text.dateline ) ) AS time, blogtitle.userid AS authorid, blogtitle.username AS author, blogtitle.views AS views, pagetext, blogtitle.title AS title, blog_text.title AS text_title
FROM vb6_blog_text
INNER JOIN (
SELECT max( blogtextid ) AS blogtextid
FROM vb6_blog_text AS blog_text
GROUP BY blogid
)blogtextids ON blog_text.blogtextid = blogtextids.blogtextid
INNER JOIN vb6_blog AS blogtitle ON blogtitle.blogid = blog_text.blogid
WHERE blog_text.dateline >=1228188924
AND blogtitle.state = 'visible'
ORDER BY blog_text.dateline DESC
LIMIT 15;

MySQL Error : Unknown column 'blog_text.blogid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 9th 2008 @ 04:35:24 AM
Error Date : Tuesday, December 9th 2008 @ 04:35:24 AM
Script : http://www.mysite.com/forum/search.php?do=getnew

Ah - I see the problem... just a sec, new version coming.\\

New version up 0.0.9a - problem will have only affected those with table prefixes

Works great. Thanks!

Just updated again - 0.0.9b - time/date disaply should be same as rest of forum now...

updated to 0.0.9b I am using 3.8.0 RC1 and vbblog 2.0 RC1 Everything working fine. I am also using the template change in post #41. Thank you for the update. :)

Please help
Please tell me How can I show this mod in Forum Home (No need to Search anything)
Thanks

Shouldn't be too hard, I'll look into it...

I use this mod in combination with Blog Stats Forum Home and they seem to do the job.

Thank You very much. That's very kind of you.