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 4490, 10

May 31, 2022

Super League Triathlon Announces 2022 Championship Series Expansion and Groundbreaking Fan Team Concept

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) will visit even more major global destinations for the fourth season of its Championship Series and give fans a unique opportunity to own a stake in one of its race teams as it develops the sport’s first professional league. SLT is the world's premiere...

Events

Press Releases

Triathlon

May 31, 2022

Teton Ogre Adventure Race brings rugged racing to Wydaho region

/ENDURANCE SPORTSWIRE/ - The Teton Ogre Adventure Race, taking place June 25-26, 2022, will once again take its racers on a wild and rugged adventure through the Wydaho area of the Rocky Mountains. This year’s 24-hour race will be based out of Driggs, Idaho, the gateway to Yellowstone National Park...

Events

Press Releases

May 31, 2022

Thorne, Arrowhead Water, and Amazfit Join as New Partners for 2022 Escape from Alcatraz™ Triathlon

SAN FRANCISCO (May 31, 2022) /ENDURANCE SPORTSWIRE/ - IMG, a global leader in sports, events, media, and fashion, today announced new partnerships with Thorne, Arrowhead Water, and Amazfit for the 2022 Escape from Alcatraz Triathlon. The iconic race is set to take place on Sunday, June 5, in San Francisco.,...

Events

Press Releases

Sponsorship

Triathlon

May 31, 2022

Showcased

Andrea Peet Becomes First Person Diagnosed With ALS To Finish 50 Marathons in 50 States

PRINCE OF WALES, Alaska /ENDURANCE SPORTSWIRE/ -  Andrea Peet has become the first person diagnosed with ALS to finish 50 marathons in 50 states, following her completion of the ​​Prince of Wales Island Marathon on Saturday. Peet’s journey began in 2016 at the Shamrock Marathon in Virginia Beach, Va., though...

Events

Giving

Press Releases

Running

May 29, 2022

Quinn Simmons and Kira Payer win Iron Horse Bicycle Classic Coca Cola Road Race

Durango, Colo. (May 29, 2022) /ENDURANCE SPORTSWIRE / - Quinn Simmons and Kira Payer won the Iron Horse Bicycle Classic Coca Cola Road Race this morning in Silverton. The road race and non-competitive, gran fondo-style McDonalds Citizen’s Tour saw 2,200 riders in total across all age group categories, with the...

Cycling

Events

Press Releases

May 27, 2022

California Coast 500 presented by REI Summer Mileage Challenge Returns in Support of Eat. Learn. Play.

San Francisco, Calif. (May 27, 2022) /ENDURANCE SPORTSWIRE/ - Returning for its third year, Bay Area-based event production company Run Local® is welcoming participants from around the world for another edition of the fan favorite California summer mileage challenge – the California Coast 500 presented by REI. From Memorial Day,...

Cycling

Events

Press Releases

Running