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

October 8, 2023

Race of Champions at Challenge Peguera-Mallorca Next Weekend

/ENDURANCE SPORTSWIRE/ - There is more than enough for triathlon fans to enjoy in the coming weeks, because with Challenge Barcelona, Challenge Vieux Boucau and Challenge Peguera-Mallorca, three races are scheduled, each featuring insanely strong professional fields. Even though Challenge Peguera-Mallorca features a strong field every year, this year the...

Events

Press Releases

Triathlon

October 6, 2023

Rusnak BMW Returns as Presenting Sponsor for sold-out Malibu Half Marathon

MALIBU, CA – October 6, 2023 /ENDURANCE SPORTSWIRE - Run Malibu organizers today announced that longtime race partner Rusnak BMW is returning as the presenting sponsor for the highly anticipated running of the Malibu Half Marathon, 5K & Kids Run presented by Rusnak BMW, set to take place in November...

Events

Press Releases

Running

Sponsorship

October 6, 2023

European Athletics selects haku as the driving force behind the race registration and CRM technology for the 2025 and 2027 European Running Championships

Miami & Lausanne – October 6, 2023 /ENDURANCE SPORTSWIRE/ – haku is pleased to announce it has been selected by European Athletics as the race registration and CRM technology partner to power the 2025 and 2027 editions of the European Running Championship. Taking place in Leuven and Brussels on 12-13 April...

Events

Press Releases

Running

October 6, 2023

Snail’s Pace Running Shop and the Surf City Marathon Announce Multi-Year Partnership

HUNTINGTON BEACH, Calif. /ENDURANCE SPORTSWIRE/ - A Snail's Pace Running Shop, Southern California's beloved hub for running and walking enthusiasts since 1979, and the Surf City Marathon and Half Marathon presented by 361° today announced a new partnership, making A Snail's Pace the official retail and expo partner of the...

Events

Press Releases

Running

Sponsorship

October 6, 2023

Super Sunday in USA and Mexico for GFNY

New York City, October 6, 2023 /ENDURANCE SPORTSWIRE/ – Cambridge hosted the inaugural edition of GFNY Maryland this past Sunday. The race course was a 92.4 mile long course with only 481 ft of climbing. As early as at mile 9 two riders managed to escape the main group: ex-pro and...

Cycling

Events

Press Releases

October 5, 2023

IRONMAN 70.3 North Carolina Triathlon Set To Return To Wilmington, N.C. On Saturday, October 21

- 2023 IRONMAN 70.3 North Carolina triathlon sells out general registration - Approximately 3,200 registered athletes are expected to toe the start line on Oct. 21, 2023 - Media credentials registration now available by visiting, www.ironman.com/credential-requests WILMINGTON, N.C. (Oct. 5, 2023) /ENDURANCE SPORTSWIRE/ – Wilmington, North Carolina will welcome athletes and...

Events

Press Releases

Triathlon

October 5, 2023

IRONMAN Announces New IRONMAN 70.3 Triathlon In Valdivia, Región De Los Ríos, Chile

- Valdivia, Chile set to host the IRONMAN 70.3 Valdivia triathlon with the inaugural edition taking place on Nov. 17, 2024 - IRONMAN 70.3 Valdivia triathlon general registration will be open on Nov. 15 at www.ironman.com/im703-valdivia VALDIVIA, Chile / TAMPA, Fla. (Oct. 5, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today the...

Events

Press Releases

Triathlon