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

April 27, 2022

BibRave, Nuun Hydration Kick-Off Experiential & Field Marketing Partnership

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, is partnering with Nuun Hydration, the sport and lifestyle hydration company based out of Seattle,  leading field and experiential marketing initiatives for 2022. Building upon BibRave’s industry expertise and wide network of Ambassadors, the new partnership with...

Business

Press Releases

Running

April 26, 2022

MANA Athletes Step into The Triathlon Spotlight

/ENDURANCE SPORTSWIRE/ - MANA athlete Magnus Ditlev took second place in his Ironman debut last weekend at Ironman Texas. The Dane exited the 3.8-kilometre swim in 15th place, used his renowned bike strength over 180 kilometres to power into the pointy end despite a tire puncture, and battled eventual winner...

Events

Press Releases

Sponsorship

Triathlon

April 26, 2022

NordicTrack from iFIT Expands Studio Cycle Bike Line with 27-inch HD Touchscreen and Two Limited Edition Colorways

LOGAN, UT (April 26, 2022)/ENDURANCE SPORTSWIRE/ - iFIT, a global leader in connected fitness software, content and equipment, today announced that NordicTrack from iFIT has enhanced its consumer-favorite studio cycle in two important ways. For more immersive iFIT workouts and ease of use, the smart HD touchscreen has expanded to...

Press Releases

Products

April 26, 2022

New Course, Live Global Broadcast, Champions Return at Upcoming 2022 Garmin UNBOUND Gravel presented by Craft Sportswear

EMPORIA, Kan., (April 26, 2022) /ENDURANCE SPORTSWIRE/ - With 4,000 expected riders, Life Time’s (NYSE: LTH) Garmin UNBOUND Gravel presented by Craft Sportswear promises to continue its reign as the premier gravel cycling event for racers of all abilities. Now 40 days out, the 2022 edition will see updates and...

Cycling

Press Releases

April 26, 2022

Foehn Launches Innovative Outdoor Performance Sportswear Category and Breaks into Mountain Biking and Running

Quebec, Canada (April 26, 2022) /ENDURANCE SPORTSWIRE/ - Foehn is proud to announce the launch of its new SS22 Collection that takes Foehn’s signature meld of tech and eye for fine design into new pieces for Running and Mountain Biking. The innovative Canadian company delivers a fresh take on the...

Cycling

Press Releases

Products

Running

April 26, 2022

Aquasphere Brings Speed and Advanced Technology to Eyewear for Competitive Swimmers Worldwide with XCEED Goggle

SOPHIA ANTIPOLIS, France (April 26, 2022)/ENDURANCE SPORTSWIRE/ – As Aquasphere continues to expand its presence in competitive swimming, the premier swimming brand is releasing its best-in-class racing goggle XCEED with new lens colorways, available today via aquapshereswim.com. The go-to racing goggle for competitive swimmers including global Team Aquasphere athletes, seven-time...

Press Releases

Products

April 26, 2022

Do Good, Run Better. BibBoards partners with Run Ottawa

/ENDURANCE SPORTSWIRE/ – Run Ottawa is the nation’s leader when it comes to race planning and execution. Run Ottawa is the organization behind the country’s biggest marathon weekend, Tamarack Ottawa Race Weekend taking place May 28-29th. In addition to high-quality races, Run Ottawa has used its events to raise money...

Events

Giving

Press Releases

Products

Running

April 26, 2022

RUSH awarded the ‘Great Canadian’ honour from a Race

Amherstburg, ON; 04/25/22-/ENDURANCE SPORTSWIRE/ – The Canada D’Eh Run is the largest and most bombastic patriotic Canada Day Run in Canada.  Now it can be shared around the world, not just in Amherstburg ON. July 1st, 2022 2,500 participants are expected to Run or Walk 5K in an all red and white celebration.  Known...

Awards

Events

Press Releases

Running

April 26, 2022

Swedish Armed Forces Adventure Team Top the New Adventure Racing World Series Rankings

/ENDURANCE SPORTSWIRE/ – The recent revision of the Adventure Racing World Series rankings saw a new World #1 team announced, improved positions for South American teams, and a significant effect from the Regional rankings around the world.  The top 20 also shows a healthy mix of nationalities, with 10 different...

Events

Press Releases