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 "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 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(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(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(97849,tagged_teams) or find_in_set(97849,shared_with_teams) or find_in_set(97852,tagged_teams) or find_in_set(97852,shared_with_teams) or find_in_set(97853,tagged_teams) or find_in_set(97853,shared_with_teams) or find_in_set(97854,tagged_teams) or find_in_set(97854,shared_with_teams) or find_in_set(98579,tagged_teams) or find_in_set(98579,shared_with_teams) or find_in_set(98580,tagged_teams) or find_in_set(98580,shared_with_teams) or find_in_set(98581,tagged_teams) or find_in_set(98581,shared_with_teams) or find_in_set(98582,tagged_teams) or find_in_set(98582,shared_with_teams) or find_in_set(98583,tagged_teams) or find_in_set(98583,shared_with_teams) or find_in_set(98584,tagged_teams) or find_in_set(98584,shared_with_teams) or find_in_set(98585,tagged_teams) or find_in_set(98585,shared_with_teams) or find_in_set(98588,tagged_teams) or find_in_set(98588,shared_with_teams) or find_in_set(98589,tagged_teams) or find_in_set(98589,shared_with_teams) or find_in_set(98590,tagged_teams) or find_in_set(98590,shared_with_teams) or find_in_set(98591,tagged_teams) or find_in_set(98591,shared_with_teams) or find_in_set(98592,tagged_teams) or find_in_set(98592,shared_with_teams) or find_in_set(98593,tagged_teams) or find_in_set(98593,shared_with_teams) or find_in_set(98594,tagged_teams) or find_in_set(98594,shared_with_teams) or find_in_set(98595,tagged_teams) or find_in_set(98595,shared_with_teams) or find_in_set(98596,tagged_teams) or find_in_set(98596,shared_with_teams) or find_in_set(98597,tagged_teams) or find_in_set(98597,shared_with_teams) or find_in_set(98603,tagged_teams) or find_in_set(98603,shared_with_teams) or find_in_set(98606,tagged_teams) or find_in_set(98606,shared_with_teams) or find_in_set(98611,tagged_teams) or find_in_set(98611,shared_with_teams) or find_in_set(98612,tagged_teams) or find_in_set(98612,shared_with_teams) or find_in_set(98613,tagged_teams) or find_in_set(98613,shared_with_teams) or find_in_set(98614,tagged_teams) or find_in_set(98614,shared_with_teams) or find_in_set(98615,tagged_teams) or find_in_set(98615,shared_with_teams) or find_in_set(98619,tagged_teams) or find_in_set(98619,shared_with_teams) or find_in_set(98620,tagged_teams) or find_in_set(98620,shared_with_teams) or find_in_set(98621,tagged_teams) or find_in_set(98621,shared_with_teams) or find_in_set(98622,tagged_teams) or find_in_set(98622,shared_with_teams) or find_in_set(98623,tagged_teams) or find_in_set(98623,shared_with_teams) or find_in_set(98624,tagged_teams) or find_in_set(98624,shared_with_teams) or find_in_set(98625,tagged_teams) or find_in_set(98625,shared_with_teams) or find_in_set(98626,tagged_teams) or find_in_set(98626,shared_with_teams) or find_in_set(98627,tagged_teams) or find_in_set(98627,shared_with_teams) or find_in_set(98628,tagged_teams) or find_in_set(98628,shared_with_teams) or find_in_set(98629,tagged_teams) or find_in_set(98629,shared_with_teams) or find_in_set(98630,tagged_teams) or find_in_set(98630,shared_with_teams) or find_in_set(98631,tagged_teams) or find_in_set(98631,shared_with_teams) or find_in_set(98632,tagged_teams) or find_in_set(98632,shared_with_teams) or find_in_set(98633,tagged_teams) or find_in_set(98633,shared_with_teams) or find_in_set(98634,tagged_teams) or find_in_set(98634,shared_with_teams) or find_in_set(98635,tagged_teams) or find_in_set(98635,shared_with_teams) or find_in_set(98636,tagged_teams) or find_in_set(98636,shared_with_teams) or find_in_set(98637,tagged_teams) or find_in_set(98637,shared_with_teams) or find_in_set(98638,tagged_teams) or find_in_set(98638,shared_with_teams) or find_in_set(98639,tagged_teams) or find_in_set(98639,shared_with_teams) or find_in_set(98641,tagged_teams) or find_in_set(98641,shared_with_teams) or find_in_set(98691,tagged_teams) or find_in_set(98691,shared_with_teams) or ((n.league_id = 3 and n.sport_id = 4) or find_in_set(3,shared_with_leagues)) ) and n.view_preference = 0 ORDER BY n.Updated_date desc LIMIT 0, 5

SHOWING RECENT ACTIVITY (Show latest posts on top)