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

July 11, 2024

Announcing TRAVERSE Tanzania

Arusha, Tanzania (July 11, 2024) /ENDURANCE SPORTSWIRE/ – Red Knot Racing Company announces the launch of TRAVERSE Tanzania, an extraordinary 5-day adventure race set to take participants through the stunning and rugged backcountry of northern Tanzania, from the slopes of Mount Kilimanjaro to the shores of Lake Natron. This announcement...

Cycling

Events

Press Releases

Running

July 10, 2024

2024 XTERRA World Cup Stop #5 Preview: Conquering Québec

MANOIR DU LAC DELAGE, QUÉBEC, CANADA /ENDURANCE SPORTSWIRE/ – On its 10th anniversary, XTERRA Québec joins the XTERRA World Cup on July 12-14, 2024. Commemorating a decade of off-road triathlon in Canada, the venue at Manoir du Lac Delage catapults itself onto the world stage as Stop #5 in the...

Cycling

Events

Press Releases

Running

Triathlon

July 10, 2024

IRONMAN Pro Series Start Lists Announced For 25th Anniversary Edition Of The Athletic Brewing IRONMAN Lake Placid, Part Of The VinFast IRONMAN North America Series

- Athletic Brewing IRONMAN Lake Placid triathlon offers a maximum of 5,000 points towards IRONMAN Pro Series standings and a $125,000 event total pro prize purse - 2023 Athletic Brewing IRONMAN Lake Placid champions, Alice Alberts (USA) and Joe Skipper (GBR), return in a bid to retain their title; Fierce...

Events

Press Releases

Triathlon

July 10, 2024

Pro & Amateur Courses Revealed for Ibiza T100 Triathlon

Ibiza, Spain/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has revealed new professional and amateur courses for its Ibiza T100 Triathlon on 28-29 September. Continuing to test its T100 stars in environments that offer different terrains and conditions, the professional course will start with a 2km sea swim in Mediterranean...

Events

Press Releases

Triathlon

July 10, 2024

Perceev to Provide Event App for The Shore Athletic Club Premiere Events

Belford, NJ/Carlsbad, CA (July 10, 2024) /ENDURANCE SPORTSWIRE/ - Perceev, an innovative new software as a service platform for endurance races, is excited to announce its partnership with The Shore Athletic Club of New Jersey. The Shore A.C., New Jersey's oldest and most established running club, will use the Perceev...

Business

Events

Press Releases

Running

July 10, 2024

61st Manhattan Beach Grand Prix

Manhattan Beach, CA /ENDURANCE SPORTSWIRE/ – The 61st Annual Chevron Manhattan Beach Grand Prix will be held on Sunday, July 14, 2024, adjacent to Live Oak Park in Manhattan Beach, California. Featuring exciting races across multiple categories, including elite men’s and women’s races, kids’ fun races, and the Manhattan Mile running...

Cycling

Events

Press Releases

July 9, 2024

Australia Set to Host 2025 XTERRA Asia-Pacific Championship

Key Points Dunsborough welcomes the 2025 XTERRA Asia-Pacific Championship, XTERRA World Cup opener, and Asia-Pacific Trail Run Championship in March 2025. The 2-day event includes Full Distance and Sprint Triathlons, a livestreamed XTERRA Short Track race, and youth-focused competitions. Supported by Tourism Western Australia Regional Events Scheme, Royalties for Regions,...

Cycling

Events

Press Releases

Running

Triathlon

July 9, 2024

Penticton To Host Its Final IRONMAN Canada Event In 2024; Ottawa To Carry On The Legacy Of IRONMAN Canada Beginning In 2025

- Final edition of IRONMAN Canada and IRONMAN 70.3 Canada in Penticton, B.C., Canada to take place on August 25, 2024; registration for final event in Okanagan Valley is available by visiting www.ironman.com/im-canada and www.ironman.com/im703-canada - First edition of IRONMAN Canada triathlon in Ottawa, part of the VinFast IRONMAN North...

Events

Press Releases

Triathlon

July 9, 2024

La Sala Named Emerging Industry Leader By NCS4

/ENDURANCE SPORTSWIRE/ - Blistering Pace Race Management President Michelle La Sala will be recognized with the 2024 Emerging Industry Leader Award by the National Center for Spectator Sports Safety and Security. The award is given to a professional who has demonstrated outstanding leadership in addressing safety and security issues. The...

Awards

Business

Events

Press Releases

Running