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

September 25, 2022

Deena Kastor becomes an AbbottWMM Six Star Finisher

/ENDURANCE SPORTSWIRE/ - Deena Kastor, former American record holder for the marathon, half marathon, 10,000 meters and road 5km – today collected another accolade as she became an Abbott World Marathon Majors Six Star Finisher. The 2004 Athens Olympic bronze medalist over 26.2 miles finished the BMW BERLIN-Marathon today in...

Events

Press Releases

Running

September 25, 2022

More than 7,000 Runners and Walkers Celebrate the 45th Anniversary of the Richard S. Caliguiri City of Pittsburgh Great Race

PITTSBURGH (September 25, 2022) /ENDURANCE SPORTSWIRE/ – More than 7,000 runners and walkers braved the rainy weather to celebrate the 45th anniversary of the Richard S. Caliguiri City of Pittsburgh Great Race. A beloved Pittsburgh fall tradition and the largest 10K in Pennsylvania, the race attracted participants from 35 states and...

Events

Press Releases

Running

September 23, 2022

Shmidt Finishes Fifth in Junior Men’s Road World Championships

WOLLONGONG, Australia /ENDURANCE SPORTSWIRE/ – It was a rainy day in New South Wales for the Junior and U23 Men’s Road Races on the fifth day of the 2022 UCI Road World Championships in Wollongong, Australia. Artem Shmidt (Cumming, Ga.; Hot Tubes Development Cycling) was the standout rider of the day for Team USA,...

Cycling

Events

Press Releases

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

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

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