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 (8742)
) 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 1940, 10

January 18, 2024

Quintana Roo Announced as Challenge Family Global Swim Partner

/ENDURANCE SPORTSWIRE/ – Quintana Roo and Challenge Family announce a multi-year partnership naming Quintana Roo the Official Global Swim Partner of Challenge Family, beginning a collaboration that brings the original triathlon wetsuit brand to Challenge Family events throughout Europe, Asia and beyond. Now in its 21st year, Challenge Family hosts...

Press Releases

Sponsorship

Triathlon

January 18, 2024

2024 XTERRA World Cup: New Season, Locations & Live Action

Key Points: Greece and Quebec join as new locations in the 7-stop series. Revised scoring system with all races counting towards total points. Live streaming coverage bringing the action to a global audience. MINNEAPOLIS, USA /ENDURANCE SPORTSWIRE/ – The 2024 XTERRA World Cup is set to elevate professional off-road triathlon in...

Cycling

Events

Press Releases

Triathlon

January 18, 2024

Publix and Magic Sports Announce Major Strategic Partnership in Triathlon and Running Races Across Tennessee and Kentucky

Nashville, TN – January 18, 2024 /ENDURANCE SPORTSWIRE/ –Magic Sports, a leading organizer of triathlons and running races across the Southeast, is thrilled to announce a groundbreaking strategic partnership with Publix, one of the largest and fastest-growing supermarket chains in the United States. This partnership marks the largest sponsorship in the...

Events

Press Releases

Running

Sponsorship

Triathlon

January 18, 2024

30th Edition of 3M Half Marathon Set to Race Austin’s Streets This Weekend

AUSTIN, Texas, January 18, 2024 /ENDURANCE SPORTSWIRE/ – High Five Events, a premier event production company in the United States, is putting the final touches on the 30th Annual 3M Half Marathon. With over 6,000 enthusiastic participants hailing from 46 states and 8 countries, this year's edition promises to be a monumental...

Events

Press Releases

Running

January 18, 2024

Over 3500 Runners Kick Off 2024 at the Key West Half Marathon Weekend

KEY WEST, Fla. /ENDURANCE SPORTSWIRE/ – The Key West Half Marathon and 5K held its annual Half Marathon and Runfest this past weekend, featuring their traditional offerings for the second this year, the Papa’s Pilar Rum Stroll and Key West Beach N’ Beer Mile. The Papa’s Pilar Rum Stroll took participants...

Events

Press Releases

Running

January 17, 2024

Boston Champions & Global Stars Set to Square Off at 128th Boston Marathon presented by Bank of America

BOSTON/ENDURANCE SPORTSWIRE/ – A fast and accomplished professional men’s field will take center stage at the 128th Boston Marathon presented by Bank of America, featuring two-time defending open champion Evans Chebet, wheelchair course record holder Marcel Hug, and the world’s fourth-fastest man Sisay Lemma. Marathon winners from around the world and...

Events

Press Releases

Running

January 17, 2024

Denver Colfax Marathon Reveals 2024 Race Medals

Denver, CO /ENDURANCE SPORTSWIRE/ – The Denver Colfax Marathon, presented by Cigna Healthcare, is excited to reveal the official 2024 race weekend medals. The city’s only marathon weekend, which features eight different races over two days, will take place May 17-19, 2024. This year, the race day medals celebrate Denver’s finest landmarks...

Events

Press Releases

Running

January 17, 2024

VF Group Bardiani-CSF Faizanè confirmed for GP New York City

NEW YORK CITY, January 17, 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

January 17, 2024

PEARL iZUMi Announces 2024 Team and Athlete Roster

Broomfield, Colorado (January 17, 2024) /ENDURANCE SPORTSWIRE/ - PEARL iZUMi, the Colorado-based global leader in cycling apparel and footwear, proudly announces its 2024 athlete roster. PEARL iZUMi welcomes back veterans Alexey Vermeulen, Hannah Shell, Whit Allison, Zack Allison, Mark Mathews, and Jake Magee, while expanding their team with 41 new...

Cycling

Press Releases

Sponsorship

January 17, 2024

Renew Your Wedding Vows at the Coronado Valentine’s Day Run: A Celebration of Love and Fitness

San Diego, Calif. /ENDURANCE SPORTSWIRE/ – This February 4, 2024, the Coronado Valentine’s Day 10K, 5K, and 1-Mile Fun Run offers a unique and heartfelt experience for couples. In the spirit of Valentine's Day, the event invites couples to celebrate their love by participating in a non-denominational mass wedding vow...

Events

Press Releases

Running