SELECT
		c.message_id, c.post_date, c.post_ip, c.message, c.post_name, c.post_email, c.approved,
		m.user_name,
		t.obj_title, t.obj_url
	FROM
		asm_s_members m, 
		asm_comment_messages c,
		asm_comment_topic t
	WHERE
		c.member_id = m.member_id
		AND t.topic_id = c.topic_id
		AND c.approved = 1 AND c.private = 0
		AND t.is_hidden = 0
		
		
	ORDER BY
		post_date DESC LIMIT 0,10