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(TeamName," - ",CASE sex WHEN "M" THEN "Men" ELSE "Women" END) ORDER BY TeamName SEPARATOR ", ") from jcm_teams where 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 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 WHERE n.status = 1 and ( find_in_set(161,tagged_teams) or find_in_set(161,shared_with_teams) or find_in_set(36154,tagged_teams) or find_in_set(36154,shared_with_teams) or find_in_set(97440,tagged_teams) or find_in_set(97440,shared_with_teams) or find_in_set(97441,tagged_teams) or find_in_set(97441,shared_with_teams) or find_in_set(97476,tagged_teams) or find_in_set(97476,shared_with_teams) or find_in_set(97477,tagged_teams) or find_in_set(97477,shared_with_teams) or find_in_set(97660,tagged_teams) or find_in_set(97660,shared_with_teams) or find_in_set(97661,tagged_teams) or find_in_set(97661,shared_with_teams) or find_in_set(97789,tagged_teams) or find_in_set(97789,shared_with_teams) or find_in_set(97796,tagged_teams) or find_in_set(97796,shared_with_teams) or find_in_set(97801,tagged_teams) or find_in_set(97801,shared_with_teams) or find_in_set(97802,tagged_teams) or find_in_set(97802,shared_with_teams) or find_in_set(97811,tagged_teams) or find_in_set(97811,shared_with_teams) or find_in_set(97812,tagged_teams) or find_in_set(97812,shared_with_teams) or find_in_set(97813,tagged_teams) or find_in_set(97813,shared_with_teams) or find_in_set(97814,tagged_teams) or find_in_set(97814,shared_with_teams) or find_in_set(97815,tagged_teams) or find_in_set(97815,shared_with_teams) or find_in_set(97816,tagged_teams) or find_in_set(97816,shared_with_teams) or find_in_set(97818,tagged_teams) or find_in_set(97818,shared_with_teams) or find_in_set(97833,tagged_teams) or find_in_set(97833,shared_with_teams) or find_in_set(97842,tagged_teams) or find_in_set(97842,shared_with_teams) or ((n.league_id = 3 or find_in_set(3,shared_with_leagues)) and n.sport_id = 4) ) and n.view_preference = 0 ORDER BY n.Updated_date desc LIMIT 0, 5

SHOWING RECENT ACTIVITY (Show latest posts on top)