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

March 30, 2023

Showcased

Feature Documentary Film Announced with Support from DeFeet and Repreve

Hildebran, NC, March 30, 2023 /ENDURANCE SPORTSWIRE/ – Producer Shane Cooper and director Paul Willerton have teamed up to create a new feature-length documentary film, Flandrien. The film is set in the Flanders region of Belgium and explores the past, present, and future of cycling and local culture. The Tour of...

Cycling

OSW Syndicated

Press Releases

Products

SWW Syndication

March 30, 2023

Course Records Expected to Drop at 13th Annual Carmel Marathon Weekend

CARMEL, Ind. (March 30, 2023) /ENDURANCE SPORTSWIRE/ – With one of the fastest and flattest Midwestern marathon and half marathon courses in the spring, the 2023 Carmel Marathon Weekend has attracted an elite field of runners aiming to break course records on Saturday, April 8 in Carmel, Ind. CRRG Events, event...

Events

Press Releases

Running

March 30, 2023

Jo Sinclair Named as Super League Triathlon’s Chief Commercial and Marketing Officer

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) have announced the appointment of Jo Sinclair as its new Chief Commercial and Marketing Officer. Jo has more than 20 years experience in the sports industry leading commercial and marketing teams in football, Formula 1 and netball, and joins SLT at an exciting time...

Business

Press Releases

Triathlon

March 30, 2023

XTERRA Returns to Australia + World Cup Preview

/ENDURANCE SPORTSWIRE/ – XTERRA is headed down under for the first time since 2019 when the third stop on the 2023 Asia-Pacific Tour rolls into the southwest coastal town of Dunsborough, Western Australia this weekend. The race will award $7,500 USD equally to the top 5 men and women elite competitors...

Events

Press Releases

Triathlon

March 30, 2023

4iiii’s latest firmware update optimizes power meter for any terrain

COCHRANE, ALBERTA — MARCH 30 2023 /ENDURANCE SPORTSWIRE/ – 4iiii Innovations Inc., the leader in power-driven cycling performance, announced today its latest firmware update to its PRECISION 3 Powermeter. PRECISION 3 retains its extremely low profile, 800-hour battery life, and stellar accuracy, but adds Gyroscope and more responsive cadence and power output....

Cycling

Press Releases

Products

March 30, 2023

RACE RESULT Track Box Passive Patent Granted in US and EU

/ENDURANCE SPORTSWIRE/ – RACE RESULT is excited to share that it has received US and EU patents for its cutting-edge sports timing device, Track Box Passive. Since the introduction of the Track Box Passive in 2020, the solution has become very popular among timekeepers around the world. Every weekend, several hundred...

Cycling

Press Releases

Products

Running

Triathlon

March 30, 2023

US Trail Running Conference Announces 2023 Theme

Nailsworth, England /ENDURANCE SPORTSWIRE/ – Active at Altitude, organizers of the US Trail Running Conference, presented by Marathon Printing, has announced the theme for this year’s eleventh annual event, Building a Sustainable Approach to the Business of Trail Running. This year’s theme is an organic development that combines previous themes focused...

Press Releases

Running

Trade Shows

March 29, 2023

The IRONMAN Foundation Announces 2023 Ambassador Team and Service Project Schedule

TAMPA, Fla. (March 29, 2023) /ENDURANCE SPORTSWIRE/ – The IRONMAN Foundation, Inc., which aims to create positive, tangible change in race communities through grants and volunteerism efforts, announced today its 2023 IRONMAN Foundation Ambassador Team, along with 18 service project initiatives for the season. Leading the team as The IRONMAN Foundation...

Giving

Press Releases

Running

Sponsorship

Triathlon

March 29, 2023

The Race That Changed Running: The Book Behind Trail Running’s Biggest Race

/ENDURANCE SPORTSWIRE/ – Helvetiq will publish The Race That Changed Running in English and French on June 13, 2023, two months before the 20th anniversary edition of the world’s most important trail race. In 2023, more than 30,000 people from more than 100 countries have entered the lottery for starting places...

Press Releases

Products

Running