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

May 8, 2024

IRONMAN Pro Series Start Lists Announced For The 2024 Qatar Airways IRONMAN 70.3 Chattanooga

- The Qatar Airways IRONMAN 70.3 Chattanooga triathlon offers a maximum of 2,500 points towards IRONMAN Pro Series standings and a $50,000 event total pro prize purse - IRONMAN Pro Series is endurance racing at its best providing every professional triathlete an opportunity to compete and create career defining moments...

Events

Press Releases

Triathlon

May 8, 2024

UK Off-Road Resurgence: Elite Athletes Ready for 2024 XTERRA Weston Park

Key Points XTERRA Weston Park returns for its second year on May 11th, 2024, providing a challenging UK setting for both new and experienced off-road triathletes. Unique permanent bike course within the private 1,000-acre estate of Weston Park, designed specifically for XTERRA racing. Global competitor draw with a €7,500 elite...

Cycling

Events

Press Releases

Running

Triathlon

May 8, 2024

Virginia Runner Claims Surprise Victory at Hoag OC Marathon

Celebratory Atmosphere Marks the 20th Edition on Cinco de Mayo Sunday Top marathon runner disqualified for unauthorized assistance rule violation COSTA MESA, Calif. — May 8, 2024 /ENDURANCE SPORTSWIRE/ – The 20th edition of the Hoag OC Marathon Running Festival, held on Cinco de Mayo, combined a festive atmosphere with...

Events

Press Releases

Running

May 8, 2024

Marathon Tours & Travel Named Co-Title Sponsor of ABBOTTWMM Age Group World Rankings and Championships

World’s premier age group competition for marathon runners joins forces with global marathon tour operator 1,800 of the fastest age groupers in the world heading for Sydney More than 375 races worldwide now serve as qualifiers for annual championship /ENDURANCE SPORTSWIRE/ – The new sponsorship will see the program renamed...

Events

Press Releases

Running

Sponsorship

May 8, 2024

Belgian team Lotto dstny is racing GP New York City

NEW YORK CITY, May 8, 2024 /ENDURANCE SPORTSWIRE/ - The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The...

Cycling

Events

Press Releases

May 7, 2024

Motiv Sports Announces New Partnership with JAMBAR

Santa Barbara, CA – May 7, 2024 /ENDURANCE SPORTSWIRE/ – Motiv Sports, a North American leader in mass participation events, today announced a multi-event partnership with JAMBAR, a leading provider of organic artisan energy bars. This strategic alignment is poised to enhance the participant experience by providing substantial, healthful energy...

Events

Press Releases

Running

Sponsorship