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

February 16, 2022

Nominations Open for the Best Running Stores of 2022

PORTLAND, Maine (February 16, 2022) /ENDURANCE SPORTSWIRE/ - Best Running Stores, the awards program that recognizes and celebrates the best run specialty stores in America, today announced nominations are open for the 2022 awards. The reception will take place December 1 in Austin, TX at The Running Event. “We’re thrilled...

Awards

Press Releases

Running

Trade Shows

February 16, 2022

Enduro Bearings launches Mechanics Ambassador Program

Oakland, California (February 16, 2022) /ENDURANCE SPORTSWIRE/ - Bike mechanics – or ‘wrenches’ as they’re endearingly referred to in the industry – are the unsung heroes of the cycling world; the right one can get you on the podium or fix your bike so it’s at peak performance for your weekend group ride...

Cycling

Press Releases

Sponsorship

Triathlon

February 16, 2022

Leading Compression Wear Brand CEP Launch a New Range of Run Socks For 2022

/ENDURANCE SPORTSWIRE/ - CEP’s new Run Sock Collection includes five products to suit all needs - knee-high socks, calf sleeves, mid-cut, low cut, and no show socks. Each product is packed with intelligent features to improve performance, reduce fatigue, and provide unbeatable comfort. CEP’s compression technology stimulates blood flow, reduces muscle...

Press Releases

Products

Running

February 16, 2022

Historic Pho3nix Foundation Sub7 and Sub8 Record Attempt Opts For Speed in Venue Choice

Sydney, Australia – 16th February, 2022 /ENDURANCE SPORTSWIRE/ - The Pho3nix Foundation is excited to confirm a date and venue for the Pho3nix Sub7 and Sub8 Project, powered by Zwift which will see Alistair Brownlee, Lucy Charles-Barclay, Kristian Blummenfelt and Nicola Spirig attempt to break seven hours for men and eight hours...

Events

Press Releases

Triathlon

February 16, 2022

Groundbreaking Sports Documentary Series Released by Super League Triathlon

/ENDURANCE SPORTSWIRE/ - Super League Triathlon’s groundbreaking documentary series Every Second Counts has been released today. Episode 1: The Golden Quartet is available exclusively through Super League Triathlon’s YouTube channel. It tells the story of the four British Olympic gold medal winning heroes and their homecoming race in London to...

Press Releases

Products

Triathlon

February 15, 2022

Thousands expected to #FlyDowntheField for Inaugural War Eagle Run Fest

AUBURN, Al. /ENDURANCE SPORTSWIRE/ - Over 2,400 running enthusiasts and Auburn faithful will #FlyDowntheField this Sunday for the Inaugural War Eagle Run Fest just like Auburn University legends Cam Newton and Bo Jackson once did before them. The Inaugural event on Feb. 20 offers Tiger fans, students, and faculty alike...

Business

Events

Press Releases

Running

Sponsorship