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 (16)
) 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 1760, 10

August 11, 2023

Obiri, Sisson to Face Off in ASICS Falmouth Road Race

FALMOUTH, Mass./ENDURANCE SPORTSWIRE/ – Two high-profile and highly-competitive women in distance running will headline the international elite field at next week’s ASICS Falmouth Road Race. Hellen Obiri and Emily Sisson, both making their Falmouth debut, will face off on the roads for the third time this year when they line up for...

Events

Press Releases

Running

August 10, 2023

BibRave and Brooks Running Host Speedrun LA – an Influencer Event Celebrating Competition, Content Creation, and Charity for 30,000 Twitch Viewers

Los Angeles, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, collaborated with Brooks Running, a global leader in running footwear and apparel, to host the first-ever Brooks Speedrun LA in Los Angeles on August 5, 2023. This electric and one-of-a-kind track event garnered over 30,000 viewers and...

Events

Press Releases

Running

August 10, 2023

Maryland Cycling Classic Presented by UnitedHealthcare Releases Full Schedule of Weekend Events

BALTIMORE, Md. – The Maryland Cycling Classic presented by UnitedHealthcare today announced its full schedule of events for Labor Day weekend beginning Thursday, August 31 and culminating with America’s top-ranked professional road cycling race on Sunday, September 3, 2023, in Baltimore, Md. Featuring a wide range of free activities for...

Cycling

Events

Press Releases

August 9, 2023

Valente Successfully Defends Omnium World Title, Earns Second Rainbow Jersey of the Week

August 9, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - On the final night of track cycling at the 2023 UCI Cycling World Championships, Jennifer Valente (San Diego; TWENTY24 Pro Cycling) successfully defended her World Championship Title in the Women’s Omnium. “To back up last year is really special in a different kind of...

Cycling

Events

Press Releases

August 9, 2023

IRONMAN 70.3 Oregon Triathlon extended in Salem for an additional five years

SALEM, Ore. / TAMPA, Fla. (August 9, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN and Travel Salem have agreed to a five-year agreement to keep the IRONMAN® 70.3® Oregon triathlon in Salem, Oregon through 2028. The event, which has sold out every year since it was first announced in 2021, remains one of the...

Events

Press Releases

Triathlon

August 9, 2023

Sprint finish at Inaugural GFNY Rockford-Illinois

New York City, August 9, 2023 /ENDURANCE SPORTSWIRE/ - Rockford hosted the inaugural edition of GFNY Rockford this past Sunday. The race course was 93.6 miles long with an elevation gain of 3583 feet. The race started off fast and already by mile 1.5, forty riders formed the lead group....

Cycling

Events

Press Releases