Miscellany

SELECT pos.ID, pos.post_name, com.comment_date_gmt, com.comment_ID, com.comment_content
FROM wp2_posts pos, wp2_comments com
WHERE com.comment_post_id = pos.ID
AND com.comment_approved = '1'
ORDER BY com.comment_date_gmt DESC
LIMIT 0,10