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
DUE TO THE HIGH WINDS, AND FALLING BRANCHES,
BETHPAGE PARK IS NOT ALLOWING THE MEET TO OCCUR TODAY.
IN ADDITION SINCE PSEG IS STATIONED AT THE PARK, THIS WOULD CAUSE A PROBLEM WITH THE BUSES.
WE ARE GOING MONDAY.
THANKS FOR YOUR UNDERSTANDING
NEAL AND ADAM
Any questions: firstname.lastname@example.org
The entry for the first annual North Shore vs South Shore Cross-Country Invitational on Wednesday October 16th is posted. Please enter your athletes for this new and exciting event.
See you soon
Neal Levy and Adam McKenzie
The North Shore vs South Shore meet has been moved to Thursday. An email was sent out explaining the situation. (Weather being the primary reason).
If you are not receiving emails, please let me know.
The 4th annual USATF Long Island Fall Conditioning and Technical Event Clinics will start this Sunday October 4 at Island Trees High School. The clinics will go for 7 Sundays and are progressive so try to start the first week.
Registration starts at 3 :15 and the clinics start at 4 and end at 6 pm
here is the link
USA Track & Field Long Island Association - 2019 USATF Long Island Pre-Season Conditioning Clinics