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

September 22, 2022

Tulsa, Oklahoma adds IRONMAN 70.3 Triathlon in 2023; Joins Certified Piedmontese Beef IRONMAN Tulsa Triathlon, Part of The Vinfast IRONMAN U.S. Series, for a Full Day of Racing

TULSA, Okla. / TAMPA, Fla. (Sept. 22, 2022) – IRONMAN announced today a new IRONMAN® 70.3® triathlon will be added in Tulsa, Okla. Providing for additional racing opportunities in the spring of 2023. The inaugural IRONMAN 70.3 Tulsa half-distance race will take place on Sunday, May 21 in conjunction with...

Events

Press Releases

Triathlon

September 22, 2022

Collin Chartier Leads Team USA’s Charge For Victory At PTO US Open

Dallas, Texas /ENDURANCE SPORTSWIRE/ – American Collin Chartier led the home charge in the Dallas heat by winning the first-ever PTO US Open. With US Olympic legend and Dallas native Michael Johnson watching on – and temperatures touching 95°F and 51% humidity – Chartier powered past compatriot Sam Long on the penultimate run...

Events

Press Releases

Triathlon

September 22, 2022

Full Speaker Lineup Revealed for the 2022 Running USA Accelerator Series

(September 22, 2022) /ENDURANCE SPORTSWIRE/ - Running USA and Race Roster are excited to announce the full speaker slates for three previously unveiled Fall 2022 Accelerator Series events. Registration is open and attendees are urged to sign up today to save a spot. The Accelerator Series events feature compelling speakers...

Press Releases

Running

Trade Shows

September 22, 2022

Team Toyota Tundra captures second straight U.S. Adventure Racing Association National Championship

/ENDURANCE SPORTSWIRE/ - Mari Chandler, Brian Mayer and Justin Bakken of Team Toyota Tundra won their second consecutive U.S. Adventure Racing Association (USARA) National Championship in convincing fashion. This year’s 30-hour championship race covered 115 miles between Mammoth Lakes and Bishop, California, with 38 teams completing multiple stages of biking,...

Events

Press Releases

September 22, 2022

Lucra Sports to be Official Partner of Spartan

BOSTON, MASS. (9/22/22)/ENDURANCE SPORTSWIRE/ – Spartan, the world's leading endurance sports and extreme wellness brand, has announced that Lucra Sports will be the official partner of Spartan for the remainder of the 2022 U.S. Season. “As both a professional sport operating in 30+ countries, and one of the world’s largest mass...

Press Releases

Running

Sponsorship

September 22, 2022

4th GFNY Ecuador Manta

GFNY Manta offers riders a challenging course of 142.2km with 2030m of climbing.  This year's race will start and finish at Hotel Wyndham Manta located in the lively center of this coastal city with breathtaking Pacific Ocean views. "Ecuador is living a road cycling boom right now that wasn’t even...

Cycling

Events

Press Releases

September 22, 2022

Anheuser-Busch InBev Partners with Two Great Races in Two Great Places

Southern California – September 22, 2022 /ENDURANCE SPORTSWIRE/ – With summer at an end, September is traditionally when fall marathon season kicks into high gear. Thousands of Southern California runners are training for two of the best events of the year. Race organizers today announced an exclusive partnership with Anheuser-Busch InBev,...

Events

Press Releases

Running

Sponsorship

September 21, 2022

Fred Henninger Prepares to Take on His 100th Rock ‘N’ Roll Running Series Event at The Inaugural Publix Rock ‘N’ Roll Running Series Clearwater on October 1-2, 2022

CLEARWATER, Fla. (September 21, 2022) /ENDURANCE SPORTSWIRE/ - Thousands of runners are scheduled to participate in the inaugural Publix Rock ‘n’ Roll® Running Series Clearwater on Saturday and Sunday, October 1-2, 2022 but the race will be serving as a true milestone for one of the participants. Fred Henninger, 56,...

Events

Press Releases

Running

September 21, 2022

P3R Announces Renewed Support from FedEx Ground for All P3R Events through 2025

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R is pleased to announce FedEx Ground, a subsidiary of FedEx Corp. (NYSE: FDX), has renewed its commitment to continue supporting the FedEx Pittsburgh Marathon Relay as a title sponsor for three years, as well as its sponsorship of the FedEx Pittsburgh Corporate Challenge and FedEx Ground Gear...

Press Releases

Running

Sponsorship