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
CK’s Hall of Fame Dinner is Saturday, May 18th (corrected from earlier post). Pete Farrell is one of the honorees, (as well as Perna Pucci, R.I.P., one of my ‘75 classmates.) Anyone considering attending?
Okay, I’m in! Registered today. Will be coming from Yankees game that afternoon. Forgive the mustard stains and smell of stale, yet expensive, beer. Look forward to seeing you all and honoring our peeps!
Lloyd’s Carrot Cake - across from the start at Van Cortland Park. Don’t know how I missed this before, but Steve Conroy says it’s been here for more than 25 years and is the best carrot cake in the world! Interesting having a business focused on a single product.
Teams: St. John's University Track & Field / XC - Men
This was a really fun day for me! It was enjoyable reminiscing with old teammates. I didn't expect to be the only one running. Please get all your body parts fixed and throw on your old Puma spikes (they're stuffed in a box somewhere!) Please plan on joining in for future events. That means you, Logiurato! I can't be the only rep from class of '75. Rattle the cages and find some of our classmates. Seriously though, many thanks to Charlie Bindert for spearheading the effort. Maybe a relay team for a day at the armory??? - Steve