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

May 11, 2022

Golden Gate Half Marathon and Sports Basement Announce 2022 Partnership

SAN FRANCISCO – May 11, 2022 /ENDURANCE SPORTSWIRE/ - The Golden Gate Half Marathon today announced a new partnership with Bay Area-based specialty retailer Sports Basement to welcome thousands of participants to San Francisco on Sunday, November 6, 2022. The classic California half-marathon is the original race in the Bay...

Events

Press Releases

Running

Sponsorship

May 11, 2022

Run Tucson Announces Prize Money for June 4th TMC Meet Me Downtown 5k and Festival of Miles

/ENDURANCE SPORTSWIRE/ – With over $2,400 in prize money at stake in multiple races on June 4th, the TMC Meet Me Downtown Night Run has become a popular race among athletes from around the Southwest.  The largest race in Tucson, with over 2000 registrants, features handfuls of regional elite athletes taking aim...

Events

Press Releases

Running

May 11, 2022

39th Annual Run for Education Returns to San Ramon Valley This October

SAN RAMON, Calif. (May 11, 2022)/ENDURANCE SPORTSWIRE/ – Following two years of virtual runs, the biggest family event of the year is returning to San Ramon Valley with a weekend of in-person events. The 39th edition of the San Ramon Valley Education Foundation’s annual Run for Education will be held on Sunday,...

Events

Giving

Press Releases

Running

May 11, 2022

Live this Sunday: 10th GFNY World Championship NYC

NEW YORK CITY, May 11, 2022/ENDURANCE SPORTSWIRE/ – The 10th GFNY World Championship NYC will be broadcast live on Sunday May 15 from 6am ET until noon on GFNY.COM, Youtube and Facebook. 5000 pros and amateurs alike fight for the GFNY World Championship crown on the 103 mile course with 8500...

Cycling

Events

Press Releases

May 10, 2022

NBA Star Deandre Ayton Joins NOCCO BCAA Beverage Brand As New Ambassador

LOS ANGELES /ENDURANCE SPORTSWIRE/ NOCCO – the leading no-carb, branched chain amino acids (BCAA) beverage company – adds to their impressive roster of ambassadors with the addition of Phoenix Suns Center, Deandre Ayton. “Ayton is an awesome high energy athlete and personality that embodies the core beliefs at NOCCO – hard...

Press Releases

Products

Sponsorship

May 10, 2022

CTS Announces Strong Slate of Partnerships for 2022

Colorado Springs, CO – May 10, 2022/ENDURANCE SPORTSWIRE/ – In its 22nd year at the forefront of the endurance coaching industry, CTS is proud to announce a bevy of partnerships that enhance athlete experience, improve performance, and provide CTS Coaches with the best tools to work with their athletes. New Partners...

Cycling

Press Releases

Running

Sponsorship

Triathlon

May 10, 2022

After five-year break, Little Rock’s Dirtiest 5k is Back!

LITTLE ROCK, Ark. (May 10, 2022)/ENDURANCE SPORTSWIRE/ – After a five-year hiatus, registration for the Mud Run – affectionately known as Little Rock’s Dirtiest 5K – opens today. The 2022 return of the Mud Run is slated for Wednesday, July 27, at 6 p.m. in War Memorial Park, and is a...

Events

Press Releases

Running

May 10, 2022

Challenged Athletes Foundation to Host A Celebration of Heart at The Chase Center Presented by the Golden State Warriors

SAN FRANCISCO, CA – May 10, 2022 /ENDURANCE SPORTSWIRE/ - In strong collaboration with the Golden State Warriors, Challenged Athletes Foundation (CAF) will host the fifth annual Celebration of Heart event on Thursday, May 19 at the spectacular Chase Center in downtown San Francisco. CAF will welcome back an in-person...

Events

Giving

Press Releases