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

February 10, 2022

The Specialized Cactus Cup Kicks Off Mountain Bike Racing In 2022

/ENDURANCE SPORTSWIRE/ - Since 1991, Arizona’s legendary Cactus Cup has been a must-do early season event for professional and amateur athletes. This female-owned mountain bike festival features world-class competition in a fun, inclusive environment with activities for mountain bikers of all ages and ability levels—including children. “The Cactus Cup is...

Cycling

Events

Press Releases

February 10, 2022

Blistering Pace Taps Recover Brands as Premier Sustainability Partner

NAPA, CA. /ENDURANCE SPORTSWIRE/ - Blistering Pace Race Management (BPRM) is thrilled to expand their partnership with Recover Brands to encompass all five of the event management company’s West Coast events. Recover Brands creates eco-friendly custom apparel that aims to minimize environmental impact from manufacturing to fulfillment. BPRM takes pride...

Events

Press Releases

Running

Sponsorship

February 9, 2022

Quincy Cass Associates Marathon Challenge to Highlight Elite Runners of 2022 Los Angeles Marathon

Los Angeles, CA (February 10, 2022) /ENDURANCE SPORTSWIRE/ - The 2022 Los Angeles Marathon presented by ASICS is proud to announce the return of the Quincy Cass Associates Marathon Challenge, an exciting 26.2-mile race-within-a-race competition that will highlight the talented runners of the women’s and men’s elite fields in an...

Events

Press Releases

Running

Sponsorship

February 9, 2022

“Krewe” of runners to roll through Baton Rouge for Mardi Gras Mambo

BATON ROUGE, La. /ENDURANCE SPORTSWIRE/ - Celebrate Carnival Season with a “krewe” of over 1500 other runners from across the South taking on the Mardi Gras Mambo in Baton Rouge this weekend. The Saturday race boasts a distance for everyone from beginners to runners dipping their toe into longer distances...

Events

Press Releases

Running

February 9, 2022

Courses Announced for the 2022 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events

PITTSBURGH, PA /ENDURANCE SPORTSWIRE/ - Today P3R revealed the courses for the highly anticipated return of the 2022 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events, scheduled for April 29-May 1. Sunday’s events will feature a similar course as 2019, and Saturday’s 5K and Kids Marathon will now cross the...

Events

Press Releases

Running

February 9, 2022

BikeFlights.com Announces 2022 Brand Ambassadors

PORTLAND, OR (February 9, 2022) /ENDURANCE SPORTSWIRE/ - BikeFlights, an easy-to-use bicycle shipping service and supplier of easy-to-pack bike boxes, is pleased to introduce its Brand Ambassadors for the 2022 season, including 39 individuals and one team. “We have an amazing and talented roster of cyclists who will represent BikeFlights...

Cycling

Press Releases

Sponsorship

Triathlon