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

March 22, 2024

Katie Zaferes To Make supertri E Debut In London

/ENDURANCE SPORTSWIRE/ – Katie Zaferes is joining an all-star line-up for supertri E World Triathlon Championships powered by Zwift in London on April 13. The American Olympic silver and bronze medallist is continuing her bid to qualify for Paris by tackling the multi-award winning hybrid real life and virtual race...

Events

Press Releases

Triathlon

March 22, 2024

Tuscaloosa welcomes record breaking crowd for the Visit Tuscaloosa Half Marathon + Publix 5K

TUSCALOOSA, AL. /ENDURANCE SPORTSWIRE/ – Tuscaloosa is set to welcome a record crowd of over 1,500 runners from 37 states and Israel for the 12th Annual Visit Tuscaloosa Half Marathon and Publix 5K.  The premier 13.1-mile race is the city’s longest-distance running race offering runners and walkers scenic views of Tuscaloosa....

Events

Press Releases

Running

March 21, 2024

Every Second Matters: Pro Start List Unveiled For IRONMAN Pro Series Debut In Oceanside, California

- 2024 Athletic Brewing IRONMAN 70.3 Oceanside triathlon kicks off the new IRONMAN Pro Series along with United States race season on Saturday, April 6, in California - IRONMAN Pro Series will be endurance racing at its best providing every professional triathlete an opportunity to compete and create career defining...

Events

Press Releases

Triathlon

March 21, 2024

P3R Announces “America’s Mile” — A Revitalized Running Tradition Set to Take the Country by Storm on July 12

PITTSBURGH, PA (March 21, 2024) /ENDURANCE SPORTSWIRE/ – P3R, the engine behind Pittsburgh's most iconic road races, is thrilled to unveil "America's Mile," the latest evolution of the city's beloved one-mile challenge, now poised to become a national sensation. Presented by VisitPITTSBURGH, the event is scheduled to dazzle participants and...

Events

Press Releases

Running

March 21, 2024

Patrick Lange and Magnus Ditlev – the fastest long-distance triathletes reunite in Roth in 2024

ROTH/ENDURANCE SPORTSWIRE/ – DATEV Challenge Roth on 7 July 2024 will once again be a world-class triathlon festival featuring the fastest athletes over the long distance, including Magnus Ditlev and Patrick Lange, who finished first and second last year. The fastest in the world 7:24:40 hours - that's all Magnus...

Events

Press Releases

Triathlon

March 21, 2024

Sold out GFNY Cannes opens Euro season

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Cannes offers riders a spectacular 110.8 km race course with an elevation gain of 2011 m. The route leads from the shores of Cannes at the Côte d’Azur onto curvy and hilly hinterland roads with two significant climbs: Col du Tanneron with 7.5 km...

Cycling

Events

Press Releases

March 21, 2024

Route Announced for Juniors Racing 2024 USA Cycling Gran Fondo National Championships

(Gettysburg, PA – March 21, 2024) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series and USA Cycling today announced that Junior 14-16 Male and Female racers will compete for 2024 USA Cycling Gran Fondo National Championships on the 61-mile Medio Route of Gran Fondo Maryland on September 15, 2024. Junior 17-18...

Cycling

Events

Press Releases