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

September 23, 2022

The Milkman Triathlon is coming back to Madison, WI on June 18th, 2023

Madison, WI /ENDURANCE SPORTSWIRE/ – Madison may be known for the University of WI-Madison and its incredible dairylands in the area, but it is also known as one of the most active and fit cities in the United States. The Milkman Triathlon will serve as Madison's premier endurance event in June...

Events

Press Releases

Running

Triathlon

September 22, 2022

L’Étape Brasil goes virtual with Santander and Mitsubishi Motors as main sponsors

São Paulo, Brazil / September 22, 2022 /ENDURANCE SPORTSWIRE/ - For the first time, the Campos do Jordão circuit of L'Étape Brasil will be ridden 1:1 simultaneously in the real and in the virtual world on ROUVY. One of the great attractions of the L'Étape Brasil by Tour de France...

Cycling

Events

Press Releases

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