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

September 22, 2021

Strong Mountain Bike Pro Field Expected For 2nd Annual Pikes Peak Apex Presented by Rockshox

Colorado Springs, CO /ENDURANCE SPORTSWIRE/ -- Sports Strategies announces a strong professional field of racers for the 4-day mountain bike challenge on the slopes of Pikes Peak. $25,000 is up for grabs, split evenly between the men and women’s top finishers. The men’s field includes reigning APEX Champion and Marathon...

Cycling

Events

Press Releases

September 22, 2021

Rosalyn Durant to Open 2022 Running USA Industry Conference with Keynote Remarks

ORLANDO (Wednesday, Sept. 22, 2021) /ENDURANCE SPORTSWIRE/ -- Running USA, the non-profit trade organization for the sport of running, today announced its keynote speaker for the 2022 Industry Conference presented by Race Roster. Rosalyn (Roz) Durant, Senior Vice President of Operations for Walt Disney World Resort, will open the event...

Press Releases

Running

Trade Shows

September 22, 2021

NYC Bike Expo 2022 held May 13-15

/ENDURANCE SPORTSWIRE/ -- On May 13-15, 2022  NYC Bike Expo returns for its 10th annual edition. The road cycling show will attract more than 10,000 visitors who are avid road cyclists, endurance athletes and cycling fans. Exhibitors will showcase products such as bike components, bike brands, and cycling events. New...

Cycling

Press Releases

Trade Shows

September 21, 2021

100%® Launches 2021 Peter Sagan Limited-Edition Collection in Time For World Championships and Paris-Roubaix

SAN DIEGO, Calif. – September 21, 2021 /ENDURANCE SPORTSWIRE/ -- 100%®, the San Diego-based sports performance company, has announced the launch of the 2021 Peter Sagan Limited Edition Collection.  Just in time for one of the most highly-anticipated Paris-Roubaix races and on the heels of Sagan’s victory in the Tour...

Cycling

Press Releases

Products

September 21, 2021

Arthritis Foundation’s California Coast Classic Bicycle Tour Presented by Amgen is Back for 2021

SAN FRANCISCO – September 21, 2021 /ENDURANCE SPORTSWIRE/ -- The Arthritis Foundation’s California Coast Classic (CCC) Bike Tour presented by Amgen left San Francisco on Saturday morning for its annual 525-mile eight-day bicycle tour to raise $1 million for the Arthritis Foundation. As of Monday morning, the CCC’s 165 in-person...

Cycling

Events

Giving

Press Releases

September 21, 2021

Tough Mudder Launches 2022 Global Calendar and New Distances

BOSTON, Mass. (Sept. 21, 2022) /ENDURANCE SPORTSWIRE/ -- Tough Mudder, the global leader in obstacle course adventures, announced the launch of its 2022 season calendar, including new distances and more obstacles than ever before. The company is also expanding its calendar to offer more events to meet post-COVID demand across...

Events

Press Releases

Running

September 21, 2021

Marathon-Photos LIVE reaches USA

September 21, 2021 /ENDURANCE SPORTSWIRE/ -- Hot on the heels of its Live photography launch in the UK, world-leading endurance photo company MarathonPhotos.Live has launched its ground-breaking new service in the United States. Runners in San Francisco Marathon had their photos online within seconds of passing photographers – both on...

Press Releases

Products

Running

Triathlon

September 21, 2021

Results of the UTMB® Mont-Blanc 2021 health policy

Quartz Event Program In order to protect the health of the participants and to contribute to a clean sport, the organization of the UTMB® Mont-Blanc has set up since 2008 the QUARTZ Event Program which implies specific medical rules; in particular, runners agree not to take part in any of...

Events

Press Releases

Running

September 21, 2021

2021 Americas Triathlon Championships now part of Super Sprint Weekend in Hurricane, Utah on Oct 30-31

St. GEORGE, Utah — USA Triathlon, PATCO and Intermountain Tri today announced that the 2021 Americas Triathlon Championships St George have been scheduled for Saturday, October 30 and Sunday, October 31, in conjunction with Super Sprint Weekend in Hurricane, Utah. The Elite, U23, & Junior international races welcome top athletes...

Events

Press Releases

Triathlon

September 21, 2021

Lucyd SMART Eyewear Launches Lyte Sport

Miami, FL: Lucyd, the brand of Bluetooth-enabled sunglasses announces today the launch of its lineup of SMART eyewear designed for the sports market. In addition to its current assortment of lifestyle-focused designs, Lucyd is rolling out the “Lyte Sport” capsule collection of its popular Lyte frames, which offer a sleek...

Press Releases

Products