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=3 AND n.sport_id=4)) WHERE n.status = 1 and tl.league_id = 3 and tl.team_id in (161,36151,36152,36154,36156,36160,97438,97476,97660,97780,97781,97789,97796,97801,97813,97814,97815,97816,97831,97849,97853,98115,98584,98611,98614,98621,98623,98629,98636,98691,98742,98840,99415) and n.new_user = 0 ORDER BY n.Updated_date desc LIMIT 0, 5

SHOWING RECENT ACTIVITY (Show latest posts on top)