SELECT c.*, m.user_name FROM asm_s_members m, asm_comment_messages c WHERE c.member_id = m.member_id AND topic_id = '2' AND c.approved = 1 AND c.private = 0 ORDER BY post_date ASC LIMIT 100