No discussion topics available







![]() |
Section 8 League Feed
powered by teammates.net 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 "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
SHOWING RECENT ACTIVITY (Show latest posts on top)
Rich Degnan made a post
November 21 at 11:09 am
USATF CLINICS THIS WEEKEND.
Saturday and Sunday the USATF Long Island will offer its final weekend of clinics for sprinters, high jumpers, hurdlers and throwers. Saturday 3pm at Island Trees and 3 pm Sunday at Island Trees. Coaches can attend for free.
Do not miss out. Our next clinic after these are over will be New Years Eve at St Anthony's
Rich Degnan made a post
November 14 at 1:29 pm
The Sunday USATF Clinics have added Saturday November 23rd and Sunday November 24th at Island Trees High School. The clinics including this Sunday November 17 now will start at 3 pm Registration starts at 2 30. Please let your athletes know as the start of Winter track is upon us. All coaches are invited to come for free and learn from our great coaching staff.
Good luck to all those racing at States this weekend
Charles Bindert liked this post
October 01 at 11:18 am
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
Paul Limmer made a post
October 24 at 7:43 am
Coaches,
Do you want to take your XC program to the next level? One of the surest way to do it is by encouraging your kids to register for the NIKE Regionals...so many good reasons why an athlete should attend...just ask Manhasset, Syosset, North Shore, Massapequa and many other Sec VIII schools.
It’s a must for those wishing to extend the XC season and go to the next level.
Go to nikecrossnationals.com.
Paul Limmer
Teams: Mepham HS Track & Field / XC - Boys
![]()
Track SweepsYou are already entered in the sweepstakes and have received an entry for today. Track SweepsYou have already been credited with an entry for today. Track SweepsCongratulations to Katherine Hui of Great Neck South ![]() ![]() ![]() ![]() ![]() ![]() ![]()
Discussions
No discussion topics available
Do you wish to block this user
This post has been set to "Teammates Only" by the person who originally posted it. Only the original poster can share it with other teams.
![]() Please wait ... Updating..
![]()
Trackconference.com can now highlight members of your favorite team when you view rankings or meet results.
Copyright © 2019
|