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
2019 T&F Alumni get together (and race!) at the CHSAA XC Championship meet. CK T&F Alumni are getting together again at the CHSAA XC Championship meet on Saturday, November 9th at Van Cortlandt Park. There is an alumni race that starts at 12:15. for anyone who is still able to run (/walk) the 2.5 mile course. . After the races - around 2:30 - we will get together for lunch / drinks across the street at the Hare & Tortoise. It' been great fun to get together - spread the word to men and women alums.
We have a good turnout . Going to be at least 9 or 10 of us. Trying to get more. If you can think of anyone else invite them. Alumni race is at 12:15. We have at least 4 runners right now so you would be #5.
NIce post, Charlie. Inspiring. XC is, for me, simply the best and most exciting sport. As a schoolboy runner I was average. I was also lazy. Distracted by everything that comes before teenagers I gave up on running halfway through high school. I never lost the love and appreciation for the sport. Pure, straightforward. Equal parts talent and grit. It led me back to distance running as an adult. Your efforts in reuniting CK running teammates is most appreciated. Stepping back onto the Van Cortlandt Park XC course last year with the alums was a real thrill. Hopefully, we’ll meet up again this year.