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

March 31, 2022

Natural Grocers® Returns as Sponsor for Rattler Racing In 2022

LAKEWOOD, Colo. (March 31, 2022) /ENDURANCE SPORTSWIRE/ - Natural Grocers® is proud to be a returning sponsor for Colorado-based Rattler Racing in 2022. In addition to being the largest family-operated organic and natural grocery retailer in the U.S., Natural Grocers has a bike racing team that will once again be...

Cycling

Events

Press Releases

Sponsorship

March 31, 2022

Ashworth Awards Acquires Elevation Culture’s Medallions & Awards Segment

/ENDURANCE SPORTSWIRE/ - Ashworth Awards is pleased to announce the acquisition of the medallion and awards business from Elevation Culture based out of Denver, Colorado. The addition of the Elevation Culture’s style of medals will allow Ashworth Awards to further expand their wooden medallion and award line. Dan Ashworth, CEO/President of...

Business

Press Releases

March 31, 2022

Registration is Open for the 2022 Columbia Threadneedle Investments Boston Triathlon

BOSTON – March 31, 2022 /ENDURANCE SPORTSWIRE/ - ethos, the mass participation event organization that produces the Columbia Threadneedle Investments Boston Triathlon, announced today the 14th annual event will be held on July 23-24, 2022. Registration is now open at www.BostonTri.com “The Columbia Threadneedle Investments Boston Triathlon is the only event...

Cycling

Events

Press Releases

Running

Triathlon

March 31, 2022

Tough Ruck is Back! March Honors Fallen Heroes and Raises Funds to Support Fallen Military and First Responders

CONCORD, MA – March 31, 2022 /ENDURANCE SPORTSWIRE/ - Military Friends Foundation, a nonprofit that provides critical assistance to Massachusetts military families and the families of the fallen in times of need, announced today that the 2022 event will take place on Saturday, April 16 at The Fenn School in Concord. Servicemembers, first responders, as well...

Events

Giving

Press Releases

March 30, 2022

Bivo Partners with Burlington, Vt. based Local Motion for inaugural Bivo Fund Allocation

RICHMOND, Vt. /ENDURANCE SPORTSWIRE/ - Bivo, the Vermont based stainless steel cycling bottle manufacturer is thrilled to announce that the inaugural donation from the Bivo Fund has been made, going to Local Motion, a nonprofit advocate for walking, biking, and rolling in Vermont. Bivo donates 1% of all sales both direct...

Giving

Press Releases

March 30, 2022

woom Launches First-of-its-Kind Urban Lifestyle Bike for Kids

March 30, 2022 - AUSTIN, TEXAS /ENDURANCE SPORTSWIRE/ - woom bikes, the fastest-growing kids’ bike brand in North America, today launches the woom NOW, a lightweight urban commuter and cargo-bike hybrid, built specifically for kids. The woom NOW is a fully loaded, highly versatile bike with a new take on frame...

Press Releases

Products

March 30, 2022

IRONMAN Foundation and Challenged Athletes Foundation to Host the Fourth Junior Seau Adaptive Surf Clinic in Oceanside

OCEANSIDE, Calif. / TAMPA, Fla. (March 30, 2022)/ENDURANCE SPORTSWIRE/ - With the kickoff of the 2022 North America IRONMAN season at Athletic Brewing IRONMAN® 70.3® Oceanside triathlon on Saturday, April 2, the IRONMAN® Foundation will distribute more than $30,000 in charitable giveback to nonprofit initiatives and groups in the greater Oceanside...

Events

Giving

Press Releases

Triathlon

March 30, 2022

The Tour of The Alps Goes Virtual – #LIVEUPHILL CHALLENGE on ROUVY

Trento, Italy / March 30, 2022/ENDURANCE SPORTSWIRE/ - The Italian Alps are among the world’s most admired mountains and perhaps the most coveted for those who love to ride for business or pleasure. The Alps need no introduction for cyclists from all over the world, and the images and awe inspired...

Cycling

Events

Press Releases

March 30, 2022

Enduro Bearings to Host Daily Service Clinics at Sea Otter, Introduce Maxhit™ BB

Oakland, California (March 30, 2022)/ENDURANCE SPORTSWIRE/ - Enduro Bearings is gearing up for a big weekend at the Sea Otter Classic bike festival in early April at Laguna Seca Raceway in Monterey, California. Following the recent launch of its groundbreaking Mechanics Ambassador Program, Enduro will host live bearing removal/replacement demonstrations with...

Cycling

Press Releases

Trade Shows

Triathlon