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

March 2, 2022

New Walking Division Announced for 2022 UPMC Health Plan Pittsburgh Half Marathon

PITTSBURGH, PA (March 2, 2022) /ENDURANCE SPORTSWIRE/ - P3R announced a new Walking Division for the 2022 UPMC Health Plan Pittsburgh Half Marathon. Through this brand new division, walking division participants can walk the 13.1-mile course through Pittsburgh to earn their half marathon medal during the 2022 DICK’S Sporting Goods...

Events

Press Releases

Running

March 2, 2022

Endurance Exchange Virtual Conference Begins Thursday

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - The third annual Endurance Exchange presented by BOA Nutrition, an industry-wide conference for endurance professionals and athletes, takes place as a virtual event this Thursday, March 3, through Saturday, March 5. All sessions will be recorded and available on-demand through May 31 for attendees who are unable to...

Business

Press Releases

Triathlon

March 2, 2022

New Speakers Announced, Final Lineup Confirmed for Sea Otter Classic Summit produced by Life Time, April 5-7

MONTEREY, Calif. (Mar. 2, 2022) /ENDURANCE SPORTSWIRE/ - Life Time, the nation's premier Healthy Way of Life brand (NYSE: LTH), and the Life Time Sea Otter Classic presented by Continental announce eight new experts who will share their knowledge at the inaugural Sea Otter Classic Summit taking place April 5-7,...

Business

Events

Press Releases

Trade Shows

March 2, 2022

Registration Opens for the 2022 GAP Relay Presented by UPMC Health Plan

PITTSBURGH (March 2, 2022)/ENDURANCE SPORTSWIRE/ - The 2022 GAP Relay presented by UPMC Health Plan returns to the Great Allegheny Passage the weekend of Oct. 14-15, 2022.  The course will begin in Cumberland, Md. and finish in Pittsburgh, Pa. “This event is unique in the adventure elements all runners get to...

Events

Press Releases

Running

March 2, 2022

Archer Components Launches New Paddle Remote for D1x Trail System

Scotts Valley, California (March 2, 2022) /ENDURANCE SPORTSWIRE/ - Archer Components continues to build on its winning formula of developing electronic shifting for any mechanical derailleur with the release of the new Paddle Remote for its renowned D1x Trail e-shifting conversion kit. The new remote -- which can be purchased individually or...

Cycling

Press Releases

Products

Triathlon

March 2, 2022

Lizard Skins Launches Their Latest Grip: The Strata

American Fork, Utah (March 2, 2022) /ENDURANCE SPORTSWIRE/ - Lizard Skins, a longtime industry leader in grips and handlebar tape, has a new grip offering: the ‘Strata’. The Strata is a single-clamp lock-on grip that offers a soft, comfortable feel with its mushroom-style fin design. The medium diameter of 32.25mm sets the...

Business

Cycling

Press Releases

Products

Triathlon

March 2, 2022

The Kilimanjaro Trail Run is a World-Class Event and a Force for Good

/ENDURANCE SPORTSWIRE/ - This September, the Kilimanjaro Trail Run (KTR) will offer four high-altitude races over two days on Africa’s tallest mountain. Mount Kilimanjaro is a beacon directing our attention toward climate change, deforestation, and the need for clean energy and clean water. The Kilimanjaro Trail Run will champion these global...

Events

Press Releases

Running

March 2, 2022

How Bike Club’s decentralized cycling community changes everything

/ENDURANCE SPORTSWIRE/ - Originally conceived as an NFT project, Bike Club has quickly grown into something much bigger. As the world’s first decentralized cycling club and community that is free and open to everyone, the implications for the industry are massive. “Traditionally, bike clubs provided a foundational structure and grassroots...

Business

Press Releases