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 (22)
) 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 580, 10

August 3, 2023

Amazon to Provide FREE Kids Day Events at the Columbia Threadneedle Investments Boston Triathlon

BOSTON – August 3, 2023 /ENDURANCE SPORTSWIRE/ – ethos, the mass participation event organization that presents the Columbia Threadneedle Investments Boston Triathlon, today announced that Amazon will continue as the official community partner of Kids Day at the Boston Triathlon. Thanks to Amazon’s partnership, registration for Kids Day is free to all....

Events

Press Releases

Sponsorship

Triathlon

August 3, 2023

Nix Biosensors teams up with the National Cycling League to provide innovative hydration technology to NCL athletes

/ENDURANCE SPORTSWIRE/ – Today, the National Cycling League (NCL) announced an official partnership with Nix Biosensors. This partnership celebrates the shared commitment of both companies in their continued efforts towards innovation in the field. The NCL, which launched last year, is reimagining the future of sports with the first women-...

Business

Cycling

Press Releases

Running

Sponsorship

Triathlon

August 2, 2023

Helijet Superweek announced in celebration of RBC GranFondo Whistler 2023 partnership

[Vancouver, BC] /ENDURANCE SPORTSWIRE/ - RBC GranFondo Whistler today announced the week of August 7-13, 2023 will be designated as Helijet Superweek. Helijet is the official air transport partner of the event which holds the title of North America’s largest Gran Fondo, a mass-participation cycling challenge. Helijet Superweek is a new...

Business

Cycling

Events

Press Releases

Sponsorship

August 1, 2023

Miles Above the Rest: Long Beach Airport Soars as Official Sponsor of the Long Beach Marathon

LONG BEACH – Aug. 1, 2023/ENDURANCE SPORTSWIRE/ – Long Beach Airport (LGB) and the Long Beach Marathon and Half Marathon are thrilled to announce the renewal of their partnership, marking a momentous occasion as LGB will soon celebrate its 100-year anniversary. The premier fall marathon in Southern California will welcome runners...

Press Releases

Running

Sponsorship

July 31, 2023

Gran Fondo National Series Reveals 2023 Gran Fondo National Championships Commemorative Jersey

(Gettysburg, PA – July 31, 2023) /ENDURANCE SPORTSWIRE/ - The SUAREZ Gran Fondo National Series today revealed the design for the 2023 USA Cycling Gran Fondo National Championships commemorative jersey. Age group competitors who win their category will receive an official Stars and Stripes National Championships jerseys from USA Cycling,...

Cycling

Events

Press Releases

Sponsorship

July 27, 2023

Kerrville Tri and Super Coffee Energize Partnership Deal

Kerrville, Texas, July 27, 2023 /ENDURANCE SPORTSWIRE/ - Kerrville Triathlon Festival and Super Coffee have partnered for the third year in a row. The Austin based company, Super Coffee, is the Official Coffee of Kerrville Tri, “The Most Scenic Triathlon in Texas.” The event is owned and produced by High...

Press Releases

Sponsorship

Triathlon

July 25, 2023

OOFOS Teams Up with The Historic Appalachian League as their Official Recovery Footwear Partner

Braintree, MA – July 25, 2023/ENDURANCE SPORTSWIRE/ – Ahead of the Appalachian League All-Star game tonight, OOFOS announced today it will be the Official Recovery Footwear of the Appalachian Baseball League. The Boston-based company has joined forces with one of the nation’s premier amateur baseball leagues for the 2023 summer season to...

Press Releases

Sponsorship

July 24, 2023

Electrolit Set to Hydrate Fans at Iconic Music Festivals All Year Long

Cerritos, Calif. (Jul 24, 2023) /ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage made from high-quality ingredients – is set to keep festival-goers hydrated throughout 2023. Building on successful activations at The Governors Ball Music Festival, Sueños and Day Trip, Electrolit will expand its reach to major U.S....

Press Releases

Sponsorship

July 24, 2023

Squirt Cycling Products Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ -The primary disciplines of the sport of Adventure Racing include trekking, mountain biking and paddling with map-and-compass navigation to bring them all together. It is in this environment that Squirt Cycling Products are well suited, making them a perfect partner for the Adventure Racing World Series (ARWS). Squirt’s...

Business

Cycling

Events

Press Releases

Products

Sponsorship