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

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

July 24, 2023

SFuels expands partnership with Run Catalina series through 2025

AVALON, Calif. /ENDURANCE SPORTSWIRE/ - The Hi-Tec Run Catalina series and SFuels have announced a new two-year partnership, making SFuels the Official Nutrition Sponsor of all three storied island running events. The collaboration will cover nutrition and hydration needs for runners throughout their race day experience in each event, as...

Business

Press Releases

Running

Sponsorship

July 21, 2023

Moloka’i 2 O’ahu Paddleboard World Championships Welcomes New partner dryrobe®

HONOLULU, HI (July 21, 2023)/ENDURANCE SPORTSWIRE/ – The Moloka'i 2 O'ahu Paddleboard World Championships (M2O) is excited to return to Hawai'i later this month for the 24th annual race featuring top athletes in prone paddleboarding, SUP, and FOIL. The race is excited to introduce these world class watermen and women...

Events

Press Releases

Sponsorship