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

January 6, 2023

Gnarly Nutrition Partners with Method Outdoor Collective National Sales Agency

Salt Lake City, UT (January 6, 2023) /ENDURANCE SPORTSWIRE/ - Gnarly Nutrition, makers of clean, effective, and great-tasting sports nutrition supplements, is excited to announce a new sales partnership with specialty sales agency Method Outdoor Collective. Method Outdoor Collective was founded by Sasha Dietschi-Cooper, former Vice President of Sales at...

Business

Press Releases

Products

January 5, 2023

Enduro Proudly Sponsors Grasshopper Adventure Series

Oakland, California (January 5, 2023)/ENDURANCE SPORTSWIRE/ – Enduro Bearings, innovators of a wide range of bicycle bearings, seals, components and tools, recently signed on to sponsor the 2023 Grasshopper Adventure Series (GAS), a long-running mixed-terrain event series that has become a favorite of many of the top names in the sport. This...

Cycling

Press Releases

Sponsorship

January 5, 2023

IRONMAN Announces History-Filled Sporting Destination Nice, France as Men’s Race Location and Co-Host for 2023 VinFast IRONMAN World Championship

TAMPA, Fla./NICE, Fra. (Jan. 5, 2023) /ENDURANCE SPORTSWIRE/ – Following the previous announcement of the IRONMAN® World Championship continuing its commitment to dedicated race days for men and women, it was announced today that Nice, France will become the location for the 2023 men’s edition as co-host of the VinFast IRONMAN...

Events

Press Releases

Triathlon

January 5, 2023

P3R Announces Name, Image and Likeness Partnership with Nine Local College Athletes

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has announced a name, image and likeness (NIL) partnership with nine college student-athletes. As part of this opportunity, these P3R Athletes will create content for P3R’s social networks including instructional videos, blogs and other resources to inspire all ages to MOVE. The 2023 P3R Athletes include...

Press Releases

Running

Sponsorship

January 5, 2023

Sebastian Kienle Starts His Bucket List 2023 Season at Challenge Wanaka

/ENDURANCE SPORTSWIRE/ – Three-time world champion, Sebastian Kienle (GER), has confirmed his place on the start line at the first Challenge Family race of 2023 – New Zealand’s Integrity Homes Challenge Wanaka on 18 February. Challenge Wanaka marks the start of his year-long ‘retirement tour’ visiting his bucket list races before...

Events

Press Releases

Triathlon

January 4, 2023

Showcased

51st Chevron Houston Marathon Hosts One of the Fastest Fields in Race History

HOUSTON – January 4, 2023 /ENDURANCE SPORTSWIRE/ - The 51st Chevron Houston Marathon women’s race will feature a national record chase, the return of a defending champion and athletes from around the world hoping to run national or Olympic qualifying standards. The men’s field is one of the fastest in...

Events

Press Releases

Running

January 4, 2023

Lizard Skins Celebrates 30 Years in Business

American Fork, Utah (January 4th, 2023)/ENDURANCE SPORTSWIRE/ – From humble beginnings in a Utah garage in 1993, Lizard Skins has become one of the cycling industry leaders in bicycle grips and handlebar tape, and now offers products for six major sports. This January, the Utah brand looks forward to celebrating its 30th...

Business

Cycling

Press Releases

Triathlon

January 4, 2023

USA Triathlon Foundation Adds Four Board Trustees in 2022

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The USA Triathlon Foundation added four new Board Trustees in 2022: Frantz Alphonse, Audra Mallow, Bill Shenkin and Reggie Waller. “Since the Foundation launched in 2014, our goal has been to build a diverse Board with myriad talents and a passion for multisport to guide...

Business

Press Releases

Triathlon