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

April 22, 2022

British Olympic Gold Medalists To Star In Front Of Sell-Out Home Crowd In London

/ENDURANCE SPORTSWIRE/ – Three of Britain’s gold medal winning Olympic stars headline this Saturday as Arena Games Triathlon powered by Zwift comes to a sold-out London Aquatics Centre. Some 1,700 fans are set to cheer home heroes Alex Yee, Georgia Taylor-Brown and Jessica Learmonth as they aim to take a...

Events

Press Releases

Triathlon

April 22, 2022

Boochcraft Partners with the Santa Barbara Wine Country Half Marathon as Official Hard Kombucha Sponsor

SANTA BARBARA /ENDURANCE SPORTSWIRE/ - Boochcraft, the pioneer in the hard kombucha space, today announced an innovative new partnership with the Santa Barbara Wine Country Half Marathon, presented by Chumash Casino Resort, as the Official Hard Kombucha sponsor. The agreement includes on-site signage, sampling and activation during the post-race festival...

Events

Press Releases

Running

Sponsorship

April 22, 2022

SPEC PR Joins 2022 California Coast Classic Bicycle Tour + Arthritis Challenge Experience, Presented by Amgen

LOS ANGELES – April 22, 2022 /ENDURANCE SPORTSWIRE/ – The Arthritis Foundation has signed SPEC PR, a public relations agency specializing in outdoor recreation and cycling, to spearhead public relations for its leading annual fundraiser, the California Coast Classic Bicycle Tour + Arthritis Challenge Experience, presented by Amgen. The award-winning...

Cycling

Events

Giving

Press Releases

April 21, 2022

Showcased

Celebrate OC Festival Headlines Return of The SDCCU Orange County Marathon Running Festival

COSTA MESA, Calif., April 21, 2022/ENDURANCE SPORTSWIRE/ - For the first time in a long time, 26.2-mile SDCCU Orange County Marathon Running Festival returns to Newport Beach and the OC Fair and Event Center April 29 - May 1, 2022. Headlining the community’s comeback marathon will be the Celebrate OC...

Events

Press Releases

Running

April 21, 2022

Lizard Skins Re-Launches Old Favorite: The Lever Grip

American Fork, Utah (March 21, 2022)/ENDURANCE SPORTSWIRE/ – Lizard Skins, long renowned for focusing on rider contact points and protecting your bike, has just reintroduced one of their earliest products: a new take on an old favorite, now called the DSP Lever Grip. Plus it’s considerably improved from the original, which...

Cycling

Press Releases

Products

Triathlon

April 21, 2022

U.S. Olympians to Test Their Speed in Pittsburgh at 2022 UPMC Health Plan Pittsburgh Half Marathon

PITTSBURGH, PA (April 21, 2022) /ENDURANCE SPORTSWIRE/ –U.S. Olympic marathoners Aliphine Tuliamuk, Jared Ward and Abdi Abdirahman are ready to race the streets of Pittsburgh in the UPMC Health Plan Pittsburgh Half Marathon, scheduled for Sunday, May 1. Each of the members of this talented trio have a special connection...

Events

Press Releases

Running