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 (22)
) 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 220, 10

July 25, 2024

Zoot Sports Welcomes 5x World Champion Craig “Crowie” Alexander as Brand Ambassador

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Zoot Sports, the industry leader in triathlon apparel, is excited to announce that Craig "Crowie" Alexander, a 5x World Champion and triathlon legend, has joined the company as a brand ambassador. With Alexander’s experience and expertise in the sport, he will play a pivotal role...

Press Releases

Sponsorship

Triathlon

July 19, 2024

supertri Partners With Europe Triathlon’s Rising Stars Initiative To Develop ‘NXT Gen’ Of Elite Athletes

LONDON, UK/ENDURANCE SPORTSWIRE/ – supertri can today announce a partnership with Europe Triathlon to support the development of the next wave of Olympic champions. supertri is officially backing the Rising Stars programme, which enables junior athletes from across the continent to have the chance to make a leap from amateur...

Press Releases

Sponsorship

Triathlon

July 19, 2024

Verge Sponsors Chicago Grit with a Stunning New Leader Jersey Design

NEW YORK, JULY 19, 2024 /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is proud to announce its sponsorship of Chicago Grit, formerly known as Intelligentsia Cup, the most exciting 10-day criterium race series in Chicagoland and the largest road racing series in America. Verge has closely...

Cycling

Events

Press Releases

Sponsorship

July 18, 2024

BMW Joins as Official Partner for Challenge New Jersey State Triathlon

MERCER COUNTY, NJ – July 18, 2024 /ENDURANCE SPORTSWIRE/ - The Challenge Family and Motiv Sports today announced BMW as the official automotive partner for the Challenge New Jersey State Triathlon, taking place this weekend, July 20-21, 2024. This partnership brings a new level of prestige to one of the...

Events

Press Releases

Sponsorship

Triathlon

July 17, 2024

Foil Race Kicks Off 25th Anniversary Molokaʻi 2 Oʻahu Paddleboard World Championships

Now over two weekends, the open ocean challenge begins on Sunday, July 21 with the foil race, followed by the prone and standup paddleboard race on July 28, 2024. Foil athletes will break in a new longer and faster course that will finish off the shore of Kaimana Beach in...

Events

Press Releases

Sponsorship

July 17, 2024

Chargel Announces Two On-Site Samplings at Signature California-Based Races: The San Francisco Marathon and Barracuda Championship

IRVINE, Calif. (July 17, 2024)/ENDURANCE SPORTSWIRE/ – Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy before any workout with zero caffeine, today announced its July competitive race station lineup. Chargel will be showcasing its half drink, half snack, all delicious energy source at...

Press Releases

Running

Sponsorship

July 17, 2024

DEKA Announces Partnership with PRIME Energy and Alani Nu as the U.S. Exclusive Energy Drink

BOSTON, MASS./ENDURANCE SPORTSWIRE/ – DEKA, the leading fitness event series revolutionizing the way athletes train and compete, is thrilled to announce a new partnership with PRIME Energy and Alani Nu, a premier provider of great tasting energy drinks. PRIME Energy and Alani Nu will have a presence at upcoming DEKA FIT...

Press Releases

Products

Running

Sponsorship