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 (11)
) 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 1570, 10

November 22, 2022

IRONMAN Extends Partnership with Nirvana to provide Enhanced Travel and Race Experiences for Athletes starting in 2023

TAMPA, Fla. / LONDON, UK (November 22, 2022) /ENDURANCE SPORTSWIRE/ – IRONMAN and Nirvana Europe Limited, the British-based sport specialist travel agency, have extended and expanded their partnership across North America, Europe, and Oceania to provide enhanced travel and race experiences for athletes starting in 2023. Nirvana has been the official...

Business

Press Releases

Triathlon

November 22, 2022

Leading tour operator industry body T.O.U.R.S announce election of Jeff Adams as new president

Tuesday 22nd November 2022 - UK /ENDURANCE SPORTSWIRE/ – T.O.U.R.S - also known as Tour Operators United for Runners, are a leading industry body that represents 41 running tour organisations across 26 different countries. As a working group it helps to send over 200,000 runners to events around the globe, by working...

Business

Press Releases

Running

November 22, 2022

Virginia’s Blue Ridge TWENTY24 Cycling Returns to UCI Status

ROANOKE, Va. (November 2022) /ENDURANCE SPORTSWIRE/ – Virginia’s Blue Ridge TWENTY24 is announcing its transition back to a Union Cycliste Internationale (UCI) team. The team has a roster representing dynamic and diverse professionals in road, track, mountain biking, gravel, ultra, eSports, and para-cycling. Since its inception 18 years ago, VBR TWENTY24...

Business

Cycling

Press Releases

November 17, 2022

Motiv Group names John Smith SVP of Strategy and Partnerships

SAN DIEGO – November 17, 2022 /ENDURANCE SPORTSWIRE/ – One of the premier race production companies in the United States, Motiv Group today announced that running industry veteran, John Smith, has joined the organization as Senior Vice President of Strategy and Partnerships. Motiv owns and operates 12 iconic events including the Long...

Business

Press Releases

Running

November 17, 2022

Chasing Watts Releases version 3.0 of the growing app that connects cyclists to local group rides

Houston- November 2022/ENDURANCE SPORTSWIRE/ - Version 3.0 Available now in the Apple App store and Android market, Chasing Watts is the premier cycling app connecting cyclists with group rides. Riders of all types can quickly find, create, or join local rides to grow their personal cycling ecosystems. Within Chasing Watts,...

Business

Cycling

Press Releases

Triathlon

Wire Syndication

November 16, 2022

Fourth Annual Endurance Exchange Returns in Person to Austin, Texas, Jan. 23-26

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon’s fourth annual Endurance Exchange presented by BOA Nutrition, an industry-wide conference for endurance sports athletes and professionals, will be held in person Jan. 23-26 in Austin, Texas. “Pack clothes you can move in! This year will feature hands-on, practical experiences and workshops...

Business

Events

Press Releases

Triathlon