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=1 AND n.sport_id=4)) WHERE n.status = 1 and tl.league_id = 1 and tl.team_id in (36,37,41,42,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,102,103,105,106,107,108,109,110,111,112,113,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,153,154,155,156,157,158,159,34070,34080,34200,34404,34567,34729,34862,34896,34995,35018,35364,35598,35700,35761,35769,35803,35836,97848,98847,99075,99164,99166) and n.new_user = 0 ORDER BY n.Updated_date desc LIMIT 0, 5
It is not too early to think about your end of season “ rewards” for your team of hard working, dedicated student athletes.
A trip to the NIKE Regionals at Bowdoin Park, Nov 29 and 30th will do wonders for your program.
Wait until the kids see the NIKE gift hat that all receive....the pasta dinner Friday night is a highlight...contact me or Adam McKenzie for more info. You will not regret it.
Paul Limmer NIKE NY and NE Regional Director
All rosters must be on this site by Wednesday September 4th. If your rosters are not entered on your team account, you will not be able to get competitor numbers and therefore your athletes will not be able to compete.
If you need assistance, instructions are posted on the right under coaches corner.
Neal Levy and Adam McKenzie
An email was sent to all Winter Track coaches tonight. If you are coaching Winter Track and did not receive the email please send me your information email@example.com
Also any coaches hosting Invitationals in the winter please email me the info. I would like to include it in the handbook again.
Thank you all!