SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, IF(wppm.meta_value= 1, 'YES', NULL) as showcased
					 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wppm ON (wp_posts.ID = wppm.post_id AND wppm.meta_key = 'promoted')
					 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (8742)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID NOT IN ( SELECT ID FROM wp_posts WHERE post_type IN ('post','page','attachment','job_listing','podcasts','industry-news','product','business-directory','testimonial') AND ID IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN (0) AND pm.meta_value IN ( SELECT group_id FROM wp_groups_group ) AND post_id NOT IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN (0) ) ) )  AND wp_posts.ID IN  (    SELECT ID FROM wp_posts WHERE ID NOT IN ( SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' )    UNION ALL    SELECT post_id AS ID FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' AND wp_postmeta.meta_value IN ('')  ) 
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.menu_order,  wp_posts.menu_order, wp_posts.post_date DESC
					 LIMIT 5450, 10

August 19, 2022

Professional triathlete Meredith Kessler shares pregnancy news in Master Spas video

FORT WAYNE, Ind. — AUGUST 18, 2022/ENDURANCE SPORTSWIRE/ – Professional triathlete Meredith Kessler does not have any races on her calendar this summer. However, the 11-time IRONMAN Champion is preparing for her next big finish line — the birth of her second child. In a new video with Master Spas, Kessler shares the...

Press Releases

Triathlon

August 19, 2022

TeamTrak Cycling League and Legends Announce Strategic Partnership

NEW YORK, NY – August 19, 2022/ENDURANCE SPORTSWIRE/ – TeamTrak Cycling League, an entity of World Cycling Limited, and Legends announced a strategic partnership today to support the launch and growth of the startup indoor cycling league. The partnership spans revenue-generating sponsorship sales and omnichannel merchandise services as well as a minority...

Cycling

Press Releases

Sponsorship

August 19, 2022

Run4Recovery Celebrates 15 Years of Running, Riding, and Raising Funds for Addiction Recovery

COVINA, Calif. /ENDURANCE SPORTSWIRE/ – Run4Recovery has announced that its founder Robin McGeough is making final preparations for this year’s edition of their annual endurance challenge and community event. Beginning Sept. 26, McGeough will ride 502 miles in just five days with the goal of raising $50,000. The event benefits the...

Cycling

Events

Giving

Press Releases

Running

August 19, 2022

Mustang Medals, Tees Await Inaugural Run Medford Finishers

BOSTON /ENDURANCE SPORTSWIRE/ – DMSE Sports is providing participants with a preview of the commemorative apparel and medals that await them at Run Medford, a brand new weekend-long celebration of community, running, and the City of Medford. Produced by Ashworth Awards, both designs feature a blue mustang that pays homage to Medford...

Events

Press Releases

Running

August 18, 2022

TransRockies Gravel Royale Kicks Off in Panorama Monday

Panorama, B.C. (August 16, 2022) — TransRockies Race Series is looking forward to the inaugural TransRockies Gravel Royale gravel stage race beginning Monday, August 22, at Panorama Mountain Resort. Initially set for August 2021, COVID-19 restrictions canceled all events in British Columbia’s Interior. The TransRockies Gravel Royale course kicks off...

Business

Cycling

Events

Press Releases

August 18, 2022

3rd annual GFNY Day this Sunday

New York City, August 18, 2022 /ENDURANCE SPORTSWIRE/ GFNY Day is an annual global celebration of GFNY and sport which will take place this Sunday August 21, 2022. GFNY invites all athletes to put on their GFNY gear to ride and run with their teams, clubs, groups or alone and...

Cycling

Events

Press Releases

August 18, 2022

Onewheel’s 2022 World Championship Race Promises to be Must Watch Event

Reno, Nevada – August 18, 2022 /ENDURANCE SPORTSWIRE/ – Future Motion, maker of the popular Onewheel GT and Pint X electric boards, will host its biggest and most ambitious Championship competition to date, The Race for the Rail World Championships at Sky Tavern Resort August 20th and 21st. The world’s best Onewheel...

Events

Press Releases

August 18, 2022

‘La Vuelta Virtual’ starts along the real La Vuelta ‘22

Madrid, Spain / August 18th, 2022 /ENDURANCE SPORTSWIRE/ – The 77th edition of the real La Vuelta 22 will start on Friday the 19th (and finish on Sunday the 11th of September) from Utrecht (the Netherlands) to Madrid, World Capital of Sports 2022. The Spanish Grand Tour in 2022 will see the...

Cycling

Events

Press Releases