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

September 21, 2022

Do You Want To Join The Coveted Seven Continent Marathon Club? Exclusive Spots Available For Sell-Out Antarctica Marathon

/ENDURANCE SPORTSWIRE/ – A sell-out event, the Antarctica Marathon is one for any runners’ bucket list. But the team at Marathon Tours & Travel have announced that up until 1st October 2022 they will be offering a limited number of places for the 2023 event, built within a special twelve day...

Events

Press Releases

Running

September 21, 2022

SMITH Promotes Rob Retzlaff to Global VP of Sales

PORTLAND, Oregon (September 20, 2022)/ENDURANCE SPORTSWIRE/ – SMITH – global market leader in snow goggles and helmets and industry innovator across bike helmets, sport, lifestyle, and prescription eyewear – is excited to announce the promotion of Rob Retzlaff to the role of Global Vice President of Sales. Retzlaff joined SMITH in...

Business

Press Releases

September 21, 2022

T-10 Days to XTERRA Worlds in Trentino, Italy

September 21, 2022 /ENDURANCE SPORTSWIRE/ – Following an action-packed racing season that traveled around the world to qualifying events in 22 countries, XTERRA will host its 26th annual XTERRA World Championship off-road triathlon at the base of the breathtaking Brenta Dolomites in Trentino, Italy on October 1, 2022. It’s the first...

Events

Press Releases

Triathlon

September 21, 2022

Stryd Announces Next Generation Foot Pod

Boulder, CO September 21, 2022 /ENDURANCE SPORTSWIRE/ – Stryd, the leader in run power technology, announces their next generation Stryd foot pod today. The next gen Stryd offers up to 5x improved running power responsiveness, tracks lower body stress, introduces new power-based run profiles, and brings a new level of accuracy...

Press Releases

Products

Running

Triathlon

September 20, 2022

Enduro Bearings to Host ‘Bearings & Brews Speakeasy’ Oct 5th at Rapha’s Boulder Clubhouse

Oakland, California (Sept 20th, 2022) /ENDURANCE SPORTSWIRE/ – On the heels of Enduro Bearings’ successful ‘Bearings & Brews Speakeasy’ events at the Rapha Clubhouse in San Francisco and the Mountain Bike Hall of Fame in Marin, Enduro is bringing the fun and informative event to Colorado. They will be hosting a...

Cycling

Events

Press Releases

Triathlon

September 20, 2022

The 2022 BMW Dallas Marathon Festival Announces New Partnership With Troy Aikman’s EIGHT Elite Light Lager

DALLAS (Sept. 20, 2022) /ENDURANCE SPORTSWIRE/ – The 2022 BMW Dallas Marathon Festival is raising a glass to its 51st year by partnering with EIGHT Elite Light Lager, a Texas beer brand founded by Dallas Cowboys legend Troy Aikman. EIGHT, which launched in February 2022 across Texas, is a light lager brewed...

Press Releases

Running

Sponsorship

September 20, 2022

Any Distance raises $1.5 million to continue building its’ new activity tracking platform

Atlanta, Georgia. September 20, 2022 /ENDURANCE SPORTSWIRE/ – Building digital and physical experiences to motivate people to be active, Any Distance today announced that it has secured $1.5M in a pre-seed round. Its new activity tracking platform for iPhone and Apple Watch gamifies and inspires movement of all kinds. The round was...

Cycling

Press Releases

Products

Running

Triathlon

September 20, 2022

Challenge Family and Turkish Triathlon Federation Announce Partnership

20 September 2022 /ENDURANCE SPORTSWIRE/ – Challenge Family and the Turkish Triathlon Federation today confirmed the signing of a multi-year agreement that heralds the global triathlon series’ expansion into the region and marks a significant step forward in the continued development of Turkish Triathlon. The agreement was signed at Challenge Family...

Business

Press Releases

Triathlon

September 20, 2022

Schmidt Earns Top-10 in Time Trial World Championship

WOLLONGONG, Australia /ENDURANCE SPORTSWIRE/ – The final day of individual time trial events was the centerpiece of the third day of the 2022 UCI Road World Championships in Wollongong. The morning had the Junior Women’s competing, with Chloe Patrick (Carson, Calif.; Serious Cycling) and Katherine Sarkisov (North Potomac, Md.; LUX Cycling...

Cycling

Events

Press Releases