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 (16)
) 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 2830, 10

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 30, 2023

Trevor Foley (USA) and Giorgia Priarone (ITA) Top The Competition At 2023 IRONMAN 70.3 Maine Triathlon

AUGUSTA, Maine/ENDURANCE SPORTSWIRE/ - Maine’s State Capital and scenic Kennebec County played host to the 2023 edition of IRONMAN® 70.3® Maine triathlon, North American TriClub Championship – Northeast. The event saw Trevor Foley (USA) put in blistering fast splits across the swim, bike and run to capture the overall victory with a...

Events

Press Releases

Triathlon

July 28, 2023

Team USA Announced for Challenge Stellina

/ENDURANCE SPORTSWIRE/ – The 35th edition of Challenge Stellina, a 14.3K uphill race with 1500 meters of climb, will take place Sunday, August 27, 2023, in Susa, Italy, and Team USA will be on the start line. Four athletes, two men and two women, along with one staffer, will travel...

Events

Press Releases

Running

July 28, 2023

Live tracking at Expedition Colorado 2023

Front Royal, Va. /ENDURANCE SPORTSWIRE/ – In 2023, Expedition Colorado will be partnering with Enabled Tracking, a real-time GPS timing and tracking service provided by Adventure Enablers, in order to help provide athletes with an enhanced expedition racing experience. The event starts on August 3rd, 2023. Expedition Colorado is a...

Events

Press Releases

Products

July 28, 2023

Alpha Win Introduces Brand New Triathlon at Historic Wildflower Location

(July 25, 2023) /ENDURANCE SPORTSWIRE/ - Alpha Win is proud to announce that it will be adding a new race to its California lineup at the location of the historic Wildflower Triathlon. The Alpha Win Lake San Antonio Triathlon will be held Saturday, April 27, 2024, in Bradley, California. Previously...

Cycling

Events

Press Releases

Running

Triathlon

July 27, 2023

Division BMX to Showcase Local Legend Marshall Gehrke at Intelligentsia Cup’s Lake Bluff Event

Chicago, IL, July 27, 2023/ENDURANCE SPORTSWIRE/ – Division BMX, the renowned adrenaline-fueled BMX stunt team, is set to wow audiences at the upcoming Intelligentsia Cup bicycle race event in Lake Bluff, this Saturday (July 29). The action-packed event will feature two exhilarating BMX shows, scheduled at 4:00pm and 5:30pm. Shows are scheduled...

Cycling

Events

Press Releases

July 27, 2023

Quad-City Times Bix 7 Hosts Third PRRO Circuit 2023-24 Stop

DAVENPORT, IA /ENDURANCE SPORTSWIRE/ – As the third stop on the PRRO Circuit 2023-24, the Quad-City Times Bix 7 will encourage participants to “Run with the Best” on Saturday morning, July 29. The 49th edition of the Midwest summer tradition is again the host of the USATF Men & Women’s 7...

Events

Press Releases

Running

July 27, 2023

The Legend Adventure Race Takes to the Great Ocean Road for 2024

/ENDURANCE SPORTSWIRE/ – The Legend expedition adventure race was launched by Wild&Co in February this year as part of the Adventure Racing World Series. In the first race teams crossed the Alpine mountains, forests and lakes of the Snowy Mountains of New South Wales. It was a spectacular 500km route...

Cycling

Events

Press Releases

Running