WP sql

select pos.ID, pos.post_name, MAX(com.comment_date_gmt) AS max_date, com.comment_date_gmt, com.comment_ID, com.comment_contentfrom lj_posts pos, lj_comments comwhere com.comment_post_id = pos.IDand com.comment_approved = '1'GROUP BY post_nameORDER BY com.comment_date_gmt DESCLIMIT 0,10