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 (16)
) 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 3780, 10

August 23, 2022

Dead Sea Marathon Israel

/ENDURANCE SPORTSWIRE/ - Tamar Regional Council invites you to a unique running experience in the lowest place in the world: DEAD SEA MARATHON; Friday - 3.2.2023 - Ein Bokek Israel The Dead Sea Marathon is being held for the fourth year and will offer participants a unique running experience in areas they...

Events

Press Releases

Running

August 23, 2022

Maryland Cycling Classic Announces Preliminary Riders Featuring Tour de France Stage Winners and Rising American Stars

BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ – Team BikeExchange-Jayco’s dynamic duo of sprinters Michael Matthews of Australia and Dylan Groenewegen of the Netherlands, both stage winners at this year’s Tour de France, and young American stars Neilson Powless of team EF Education-EasyPost and Quinn Simmons of team Trek-Segafredo, as well as current U.S. National...

Cycling

Events

Press Releases

August 22, 2022

XTERRA Elites Showcase Speed, Skill in Short Track Showcase

August 22, 2022/ENDURANCE SPORTSWIRE/ – Professional XTERRA athletes from around the world put on an incredible show over two days of Short Track and full-distance off-road triathlon racing in Zittau, Germany on August 19-20. “It was really spectacular racing and so fun to watch,” said XTERRA Europe director, Nico Lebrun. “This is...

Events

Press Releases

Triathlon

August 22, 2022

Qatar Airways Becomes the Official Airline Partner of the Global IRONMAN and IRONMAN 70.3 Series

DOHA, Qatar / TAMPA, Fla / LONDON, UK (August 22, 2022)/ENDURANCE SPORTSWIRE/ – Qatar Airways and IRONMAN have entered a long-term global partnership, making Qatar Airways the Official Airline Partner of the Global IRONMAN® Series and IRONMAN® 70.3® Series through the 2025 season. In addition, Qatar Airways will be the title...

Events

Press Releases

Sponsorship

Triathlon

August 22, 2022

Aaronn Gu and Emily Tato Claim Titles at the 2022 Columbia Threadneedle Investments Boston Triathlon

BOSTON, MA /ENDURANC SPORTSWIRE/ - On a warm summer day, the Columbia Threadneedle Investments Boston Triathlon returned to the Massachusetts Department of Conservation and Recreation’s (DCR) Carson Beach in South Boston. In the 14th annual event, Aaronn Gu of Brookline, MA, captured the title of top male athlete in the Olympic Distance...

Events

Press Releases

Triathlon

August 22, 2022

Collin Chartier (USA) And Haley Chura (USA) Claim Victories At 2022 Subaru IRONMAN Mont-Tremblant

MONT-TREMBLANT, QUEBEC, CANADA (Aug. 21, 2022) /ENDURANCE SPORTSWIRE/ - The picturesque international Resort of Tremblant and Quebec’s stunning Laurentian Mountains provided a spectacular backdrop for the return of the Subaru IRONMAN® Mont-Tremblant triathlon. With some of triathlon’s best on hand, Collin Chartier (USA) won the men’s professional race with a...

Events

Press Releases

Triathlon

August 20, 2022

Record Number of Participants Celebrate 10th Anniversary of the Yinzer 4.12K

PITTSBURGH (August 20, 2022) /ENDURANCE SPORTSWIRE/ – A record number of nearly 800 yinzers wore their finest Pittsburgh attire while celebrating the 10th anniversary of the Yinzer 4.12K on the North Shore or participating virtually this morning. This year’s event raised more than $93,000 for the Light of Life Rescue Mission...

Events

Giving

Press Releases

Running

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