[Adrian Schneider]

The post and deletelog tables both have a 'dateline' column, so you need to specify which one. [sql]SELECT post.*
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 8
AND post.dateline > 1155014895
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 10
ORDER BY post.dateline DESC
LIMIT 1;[/sql]

I'm not sure about the other problem.