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

March 23, 2022

Limited additional capacity released for Europe’s most popular IRONMAN® and IRONMAN® 70.3® triathlons

LONDON, UK /ENDURANCE SPORTSWIRE/ - The IRONMAN Group has today announced a limited release of additional race entries for 11 of the public’s favourite European races. Including the likes of Mainova IRONMAN European Championship Frankfurt, which has been the arena for some of the most memorable elite triathlon racing of the past...

Events

Press Releases

Triathlon

March 23, 2022

NCM Introduces Euro-Inspired Commuter E-Bike Line

Seattle, Washington (March 23, 2022) /ENDURANCE SPORTSWIRE/ - Since its inception in Germany in 2014, NCM, a Leon Cycle brand, has grown into one of Europe's most popular e-bike brands, and they’ve recently launched a new line of Class I e-bikes in the States that pay homage to that urban European heritage....

Cycling

Press Releases

Products

Triathlon

March 23, 2022

Showcased

Nutrition Coaching App, FuelIn, Announces Integration with Today’s Plan

(San Francisco, CA) /ENDURANCE SPORTSWIRE/ FuelIn announced today the integration of its nutrition coaching app with sports technology platform, Today’s Plan. This brings FuelIn one step closer to the mission of making personalized performance nutrition coaching available to all athletes around the world. The FuelIn program takes the complex world...

Press Releases

Products

March 23, 2022

BibRave Provides Comprehensive Marketing Services Across All San Diego Running Co. Events

Portland, OR /ENDURANCE SPORTSWIRE/ - BibRave, the leading-edge endurance and fitness marketing agency, is partnering with San Diego Running Co. (SDRC) to provide full-service marketing. Supported SDRC events include Pacific Beach Half Marathon & 5K, America’s Finest Corporate Dash 5K, San Diego Santa Run, San Diego Resolution Run, San Diego...

Business

Press Releases

Running

March 22, 2022

iFIT Adventures Launches, Allowing Members to Travel to Destinations First Discovered Through iFIT Workouts

Logan, Utah /ENDURANCE SPORTSWIRE/ - iFIT, one of the global leaders in connected fitness software, content, and equipment, today announced the launch of iFIT Adventures – a new series of in-person travel fitness experiences that explore destinations around the globe, bringing iFIT’s favorite, most-streamed Global Workouts to life. Led by...

Press Releases

Products

March 22, 2022

GFNY Super Sunday at the beaches

/ENDURANCE SPORTSWIRE/ - GFNY Punta del Este At the GFNY South American Championship Punta del Este in Uruguay, the 172km race with 1700m of climbing came down to sprint finishes both in the women’s and men's race. Brazilian National TT Champion Tamire Radatz edged out US elite racer Jill Patterson...

Cycling

Events

Press Releases

March 22, 2022

FloSports to Exclusively Stream Inaugural Life Time Grand Prix Series Kicking Off April 9

AUSTIN, Texas (March 22, 2021) /ENDURANCE SPORTSWIRE/ - FloSports, a leading sports streaming service, today announced an official broadcasting partnership with Life Time, the nation’s premier healthy lifestyle brand (NYSE: LTH), for the Company’s inaugural Life Time Grand Prix Series. The new event series—comprised of 60 elite cyclists from around the world...

Cycling

Events

Press Releases

Sponsorship

March 22, 2022

Ready to Run?

YAKIMA, WA. /ENDURANCE SPORTSWIRE/ - Make the Downtown Yakima Mile part of your Fourth of July weekend festivities! This year’s race will be held on Saturday, July 2, and will feature heats for kids, families, veterans, elite runners, and more. Walkers and dogs are welcome too! The Downtown Yakima Mile...

Events

Giving

Press Releases

Running

March 22, 2022

Ride Santa Barbara 100 Kicks Off Registration with 72-Hour Special Pricing and Announces 2022 Charity Partner

SANTA BARBARA, Calif. /ENDURANCE SPORTSWIRE/ - Ride Santa Barbara 100 (RideSB100), the premier cycling event on California’s Central Coast, today opened registration and announced plans to partner with the newly merged SB BIKE + COAST to support the local cycling community and help create healthy Santa Barbara communities. Taking place...

Cycling

Events

Giving

Press Releases