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

February 24, 2023

USA Triathlon Launches Women’s Series, Featuring Women’s-Only Triathlons Across the Country

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the 15 women’s-focused multisport events that are a part of the inaugural USA Triathlon Women’s Series. The series highlights prominent women’s races across the country that give female athletes, from beginner to experienced, a space to celebrate and engage with other women...

Events

Press Releases

Triathlon

February 24, 2023

Hawaiian Airlines Announced as Exclusive Airline Partner of the 2023 Los Angeles Marathon

LOS ANGELES, CA / HONOLULU, HI (February 24, 2023) /ENDURANCE SPORTSWIRE/ – The McCourt Foundation (TMF) today announced Hawaiian Airlines as Exclusive Airline Partner of the 2023 Los Angeles Marathon presented by ASICS on Sunday, March 19, 2023. “We are thrilled to partner with Hawaiian Airlines, the top leisure carrier flying to Hawai’i...

Events

Press Releases

Running

Sponsorship

February 24, 2023

The RunnerBox and The RiderBox Keep Athletes Motivated with Their Latest Release

/ENDURANCE SPORTSWIRE/ – On February 1st, The RunnerBox and The RiderBox debuted their February-March ‘conquer winter’ box. Shipping out every other month, this athlete-run subscription company has selected products that will motivate subscribers to push through these final winter days, defrost, and prepare for the upcoming spring race season. “Winter is...

Cycling

Press Releases

Products

Running

Triathlon

February 24, 2023

Meg Treat, APR, named Director of Operations and Communications for Dave McGillivray Finish Strong Foundation

MISSION VIEJO, Calif. /ENDURANCE SPORTSWIRE/ – Treat Public Relations has expanded its engagement with clients Dave McGillivray and the Dave McGillivray Finish Strong Foundation. The PR agency representing endurance sports events and public figures will also continue to support media relations initiatives for DMSE Sports alongside their in-house communications team. Owner...

Business

Press Releases

February 24, 2023

Deboer Wetsuits Announces Partnership with Ironman World Champion Chelsea Sodaro

New York, NY /ENDURANCE SPORTSWIRE/ – Deboer Wetsuits, the leading manufacturer of high-performance wetsuits, is proud to announce its partnership with Chelsea Sodaro, the reigning Ironman World Champion. As part of the partnership, Sodaro will wear deboer wetsuits during her training and racing in the 2023 season and beyond. Sodaro, who grew...

Press Releases

Sponsorship

Triathlon

February 23, 2023

Oakland Running Festival Welcomes Under Armour as Official Shoe & Apparel Partner

OAKLAND, Calif. – (February 23, 2023) /ENDURANCE SPORTSWIRE/ – The Oakland Running Festival welcomes Under Armour as its Official Shoe and Apparel partner for the March 17–19 event. With its long-standing involvement in the Oakland community, Under Armour’s partnership will kick off with a free, open-to-all “Last Long Run” at the...

Events

Press Releases

Running

Sponsorship

February 23, 2023

USA Triathlon Announces 2023 Gravel Triathlon Series

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the nine local gravel triathlon events that make up the 2023 USA Triathlon Gravel Triathlon Series. “Gravel triathlon is an exciting way for athletes to test their skills and try a unique race experience, and not surprisingly it has taken off...

Events

Press Releases

Triathlon

February 23, 2023

XTERRA Season Openers in U.S., Asia-Pacific Region this Saturday

February 23, 2023 /ENDURANCE SPORTSWIRE/ – XTERRA South Africa kick started the 2023 off-road triathlon racing season in the EMEA region last month, and on Saturday, the U.S. and Asia-Pacific regions get underway at XTERRA Iceman in Arizona and XTERRA Wellington in New Zealand. The third running of the XTERRA Wellington...

Events

Press Releases

Running

Triathlon

February 23, 2023

Science in Sport (SiS) announce partnership with OGC Nice

23rd February 2023 - London UK /ENDURANCE SPORTSWIRE/ – Côte d’Azur, France-based OGC Nice are widely recognised as one of the original members of first division French football. With regard to the development of the club, particularly on the performance perspective, this new partnership comes at an exciting time and will see...

Press Releases

Sponsorship

February 23, 2023

U.S. Air Force Special Warfare to Partner with Spartan

BOSTON, MASS. (02/23/2023)/ENDURANCE SPORTSWIRE/ – Spartan, the world’s leading endurance sports and extreme wellness brand, announced that the U.S. Air Force Special Warfare will be an Official Partner of select races in 2023. “At Spartan, we pride ourselves on grit, toughness, resiliency, and finding comfort in discomfort. By partnering with...

Press Releases

Running

Sponsorship