 |
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)
Kristin Frazer made a post
February 11 at 9:04 am
If you are attending the State Qualifier meet as a spectator please consider bringing an item to donate to the Food & Supply Drive. All details in the link under "News & Announcements" Thank you!
Coach Higgins made a post
January 15 at 7:30 pm
Prospective student athletes New York Tech is activity recruiting ,We hope you will become a member of our revived program, and add to it’s great history. Please contact Coach Pete Zinno at 5163982221 or email pzinno@nyit.edu
Coach Lenroy Raffington
5169844928
Email lraffing@nyit.edu ( can you put this on track conference )
John McCree shared a post
August 30 2019
XC runners!
 Details
Steven Gerardi
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.
September 25 2019
Rich Degnan made a post
December 20 2019
The Annual USATF New Years Eve Clinic will take place at St Anthony's
Tuesday December ,31st. Registration starts at 12 noon and the Clinic starts at 1 pm to 3 pm. This clinic will cover all the technical aspects of our sport'
Events covered are Hurdles, sprint mechanics and starts, High Jump, Pole Vault, long and triple jump and Shot and Weight throws.
Cost is $35 pre registered or $50 day of.
To pre register email mbundr8029@aol.com
Happy New Year
Mike Frazer, darin harrison liked this post
December 11 2019
I will be filming @ Group B League Meets and at meets Baldwin HS is competing. I will post videos to this YouTube Playlist: https://www.youtube.com/playlist?list=PLSTweGwLed0_Gh9q8SXBK2tDUrMmAPiCw
Details
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    Printable Team Performance Grid   
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 © 2020
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
