SELECT mfp.id,mcc.fullname AS 'coursename',mfm.name AS 'activity',mfd.name AS 'discussion',CONCAT(mfp.subject,' | ',mfp.message) AS 'reply',mfp.parent ,CONCAT(mus.firstname,' ',mus.lastname) AS 'studentname',mfp.userid FROM mdl_forum_discussions mfd JOIN mdl_forum_posts mfp ON mfd.id=mfp.discussion JOIN mdl_course mcc ON mfd.course=mcc.id JOIN mdl_user mus ON mus.id=mfp.userid JOIN mdl_forum mfm ON mfm.id=mfd.forum