SELECT distinct n.id, n.user_id, n.comment, n.comment_type, n.posted_date, n.updated_date, n.status, n.media_file_id, n.team_id, n.shared_userid, n.like_count, n.view_preference, u.Name, u.PhotoUrl, u.user_type, m.media_file_type, m.media_file_name, n.like_count, n.media_files, n.article_title, n.article_description, n.article_photo, n.article_url,n.tagged_teams, (select GROUP_CONCAT(DISTINCT CONCAT(t.TeamName," - ", CASE sex when "C" then "Combined" WHEN "M" THEN (case when school_or_college = 1 then "Men" else "Boys" end) ELSE (case when school_or_college = 1 then "Women" else "Girls" end) END) ORDER BY t.TeamName SEPARATOR ", ") from jcm_teams t join jcm_school s on s.id = t.school_id where t.id in (n.tagged_teams) ) as TeamName, m.season_from, m.season_to, m.photo_year, m.dim_n, m.dim_p, m.dim_t, n.dim_article_photo, (SELECT GROUP_CONCAT(DISTINCT TagText ORDER BY TagText SEPARATOR ", ") FROM wp_image_tags Where ImageId = n.media_file_id) as TaggedNames, (SELECT GROUP_CONCAT(DISTINCT Title ORDER BY Title SEPARATOR ", ") FROM jcm_event_photo_mapping tg LEFT JOIN jcm_team_events tm ON tg.EventId=tm.Id Where ByTag=1 AND PhotoId = n.media_file_id) as TaggedEvents, (SELECT user_id from jcm_likes where news_feed_id = n.id and user_id = 0 limit 1) as youlike, n.last_action, n.new_user, n.post_type, n.event_id, n.league_id, m.media_file_title, m.doc_category_ids, (SELECT GROUP_CONCAT(DISTINCT category_name ORDER BY id SEPARATOR ", ") FROM jcm_doc_category Where find_in_set(id,m.doc_category_ids)) as doc_category_names, original_post_by, original_post_on, original_post_description, original_post_userid, social_feed_url FROM jcm_news_feed n LEFT JOIN jcm_users u ON u.ID = n.user_id LEFT JOIN jcm_media_files m ON n.media_file_id = m.Id INNER JOIN jcm_team_league tl ON (FIND_IN_SET(tl.team_id,n.shared_with_teams) or FIND_IN_SET(tl.team_id,n.tagged_teams) or (n.league_id=1 AND n.sport_id=4)) WHERE n.status = 1 and tl.league_id = 1 and tl.team_id in (36,37,41,42,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,102,103,105,106,107,108,109,110,111,112,113,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,153,154,155,156,157,158,159,34070,34080,34200,34404,34567,34729,34862,34896,34995,35018,35364,35598,35700,35761,35769,35803,35836,97848,98847,99075,99164,99166) ORDER BY n.Updated_date desc LIMIT 0, 5

SHOWING RECENT ACTIVITY (Show latest posts on top)