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(36,tagged_teams) or find_in_set(36,shared_with_teams) or find_in_set(37,tagged_teams) or find_in_set(37,shared_with_teams) or find_in_set(41,tagged_teams) or find_in_set(41,shared_with_teams) or find_in_set(42,tagged_teams) or find_in_set(42,shared_with_teams) or find_in_set(49,tagged_teams) or find_in_set(49,shared_with_teams) or find_in_set(50,tagged_teams) or find_in_set(50,shared_with_teams) or find_in_set(51,tagged_teams) or find_in_set(51,shared_with_teams) or find_in_set(52,tagged_teams) or find_in_set(52,shared_with_teams) or find_in_set(53,tagged_teams) or find_in_set(53,shared_with_teams) or find_in_set(54,tagged_teams) or find_in_set(54,shared_with_teams) or find_in_set(55,tagged_teams) or find_in_set(55,shared_with_teams) or find_in_set(56,tagged_teams) or find_in_set(56,shared_with_teams) or find_in_set(57,tagged_teams) or find_in_set(57,shared_with_teams) or find_in_set(58,tagged_teams) or find_in_set(58,shared_with_teams) or find_in_set(59,tagged_teams) or find_in_set(59,shared_with_teams) or find_in_set(60,tagged_teams) or find_in_set(60,shared_with_teams) or find_in_set(61,tagged_teams) or find_in_set(61,shared_with_teams) or find_in_set(62,tagged_teams) or find_in_set(62,shared_with_teams) or find_in_set(63,tagged_teams) or find_in_set(63,shared_with_teams) or find_in_set(64,tagged_teams) or find_in_set(64,shared_with_teams) or find_in_set(65,tagged_teams) or find_in_set(65,shared_with_teams) or find_in_set(66,tagged_teams) or find_in_set(66,shared_with_teams) or find_in_set(67,tagged_teams) or find_in_set(67,shared_with_teams) or find_in_set(68,tagged_teams) or find_in_set(68,shared_with_teams) or find_in_set(69,tagged_teams) or find_in_set(69,shared_with_teams) or find_in_set(70,tagged_teams) or find_in_set(70,shared_with_teams) or find_in_set(71,tagged_teams) or find_in_set(71,shared_with_teams) or find_in_set(72,tagged_teams) or find_in_set(72,shared_with_teams) or find_in_set(73,tagged_teams) or find_in_set(73,shared_with_teams) or find_in_set(74,tagged_teams) or find_in_set(74,shared_with_teams) or find_in_set(75,tagged_teams) or find_in_set(75,shared_with_teams) or find_in_set(76,tagged_teams) or find_in_set(76,shared_with_teams) or find_in_set(77,tagged_teams) or find_in_set(77,shared_with_teams) or find_in_set(78,tagged_teams) or find_in_set(78,shared_with_teams) or find_in_set(79,tagged_teams) or find_in_set(79,shared_with_teams) or find_in_set(80,tagged_teams) or find_in_set(80,shared_with_teams) or find_in_set(81,tagged_teams) or find_in_set(81,shared_with_teams) or find_in_set(82,tagged_teams) or find_in_set(82,shared_with_teams) or find_in_set(83,tagged_teams) or find_in_set(83,shared_with_teams) or find_in_set(84,tagged_teams) or find_in_set(84,shared_with_teams) or find_in_set(85,tagged_teams) or find_in_set(85,shared_with_teams) or find_in_set(86,tagged_teams) or find_in_set(86,shared_with_teams) or find_in_set(87,tagged_teams) or find_in_set(87,shared_with_teams) or find_in_set(88,tagged_teams) or find_in_set(88,shared_with_teams) or find_in_set(89,tagged_teams) or find_in_set(89,shared_with_teams) or find_in_set(90,tagged_teams) or find_in_set(90,shared_with_teams) or find_in_set(91,tagged_teams) or find_in_set(91,shared_with_teams) or find_in_set(92,tagged_teams) or find_in_set(92,shared_with_teams) or find_in_set(93,tagged_teams) or find_in_set(93,shared_with_teams) or find_in_set(94,tagged_teams) or find_in_set(94,shared_with_teams) or find_in_set(95,tagged_teams) or find_in_set(95,shared_with_teams) or find_in_set(96,tagged_teams) or find_in_set(96,shared_with_teams) or find_in_set(97,tagged_teams) or find_in_set(97,shared_with_teams) or find_in_set(98,tagged_teams) or find_in_set(98,shared_with_teams) or find_in_set(99,tagged_teams) or find_in_set(99,shared_with_teams) or find_in_set(100,tagged_teams) or find_in_set(100,shared_with_teams) or find_in_set(102,tagged_teams) or find_in_set(102,shared_with_teams) or find_in_set(103,tagged_teams) or find_in_set(103,shared_with_teams) or find_in_set(105,tagged_teams) or find_in_set(105,shared_with_teams) or find_in_set(106,tagged_teams) or find_in_set(106,shared_with_teams) or find_in_set(107,tagged_teams) or find_in_set(107,shared_with_teams) or find_in_set(108,tagged_teams) or find_in_set(108,shared_with_teams) or find_in_set(109,tagged_teams) or find_in_set(109,shared_with_teams) or find_in_set(110,tagged_teams) or find_in_set(110,shared_with_teams) or find_in_set(111,tagged_teams) or find_in_set(111,shared_with_teams) or find_in_set(112,tagged_teams) or find_in_set(112,shared_with_teams) or find_in_set(113,tagged_teams) or find_in_set(113,shared_with_teams) or find_in_set(114,tagged_teams) or find_in_set(114,shared_with_teams) or find_in_set(115,tagged_teams) or find_in_set(115,shared_with_teams) or find_in_set(116,tagged_teams) or find_in_set(116,shared_with_teams) or find_in_set(117,tagged_teams) or find_in_set(117,shared_with_teams) or find_in_set(118,tagged_teams) or find_in_set(118,shared_with_teams) or find_in_set(119,tagged_teams) or find_in_set(119,shared_with_teams) or find_in_set(120,tagged_teams) or find_in_set(120,shared_with_teams) or find_in_set(121,tagged_teams) or find_in_set(121,shared_with_teams) or find_in_set(122,tagged_teams) or find_in_set(122,shared_with_teams) or find_in_set(123,tagged_teams) or find_in_set(123,shared_with_teams) or find_in_set(124,tagged_teams) or find_in_set(124,shared_with_teams) or find_in_set(125,tagged_teams) or find_in_set(125,shared_with_teams) or find_in_set(126,tagged_teams) or find_in_set(126,shared_with_teams) or find_in_set(127,tagged_teams) or find_in_set(127,shared_with_teams) or find_in_set(128,tagged_teams) or find_in_set(128,shared_with_teams) or find_in_set(129,tagged_teams) or find_in_set(129,shared_with_teams) or find_in_set(130,tagged_teams) or find_in_set(130,shared_with_teams) or find_in_set(131,tagged_teams) or find_in_set(131,shared_with_teams) or find_in_set(132,tagged_teams) or find_in_set(132,shared_with_teams) or find_in_set(133,tagged_teams) or find_in_set(133,shared_with_teams) or find_in_set(134,tagged_teams) or find_in_set(134,shared_with_teams) or find_in_set(135,tagged_teams) or find_in_set(135,shared_with_teams) or find_in_set(136,tagged_teams) or find_in_set(136,shared_with_teams) or find_in_set(137,tagged_teams) or find_in_set(137,shared_with_teams) or find_in_set(138,tagged_teams) or find_in_set(138,shared_with_teams) or find_in_set(139,tagged_teams) or find_in_set(139,shared_with_teams) or find_in_set(140,tagged_teams) or find_in_set(140,shared_with_teams) or find_in_set(141,tagged_teams) or find_in_set(141,shared_with_teams) or find_in_set(142,tagged_teams) or find_in_set(142,shared_with_teams) or find_in_set(143,tagged_teams) or find_in_set(143,shared_with_teams) or find_in_set(144,tagged_teams) or find_in_set(144,shared_with_teams) or find_in_set(145,tagged_teams) or find_in_set(145,shared_with_teams) or find_in_set(146,tagged_teams) or find_in_set(146,shared_with_teams) or find_in_set(147,tagged_teams) or find_in_set(147,shared_with_teams) or find_in_set(148,tagged_teams) or find_in_set(148,shared_with_teams) or find_in_set(149,tagged_teams) or find_in_set(149,shared_with_teams) or find_in_set(150,tagged_teams) or find_in_set(150,shared_with_teams) or find_in_set(151,tagged_teams) or find_in_set(151,shared_with_teams) or find_in_set(152,tagged_teams) or find_in_set(152,shared_with_teams) or find_in_set(153,tagged_teams) or find_in_set(153,shared_with_teams) or find_in_set(154,tagged_teams) or find_in_set(154,shared_with_teams) or find_in_set(155,tagged_teams) or find_in_set(155,shared_with_teams) or find_in_set(156,tagged_teams) or find_in_set(156,shared_with_teams) or find_in_set(157,tagged_teams) or find_in_set(157,shared_with_teams) or find_in_set(158,tagged_teams) or find_in_set(158,shared_with_teams) or find_in_set(159,tagged_teams) or find_in_set(159,shared_with_teams) or find_in_set(35836,tagged_teams) or find_in_set(35836,shared_with_teams) or ((n.league_id = 1 and n.sport_id = 4) or find_in_set(1,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)