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

February 15, 2024

The Ascension Seton Austin Marathon Weekend Kicks Off Today

AUSTIN, Texas, February 15, 2024 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon and 5k is set to take place this weekend in Austin, Texas. Highlights of this world-class event include three race distances for participants of all speeds and abilities, the Health & Fitness Expo, and a 4-block-long...

Events

Press Releases

Running

February 15, 2024

TMC Old Tucson Trail Run Returns to Old Tucson Studios

/ENDURANCE SPORTSWIRE/ - For fans of the wild west, the 14th Annual TMC Old Tucson Trail Run is a 4-Mile or 1-Mile journey through the scenic desert trails of Old Tucson, nestled among the beautiful Saguaro cactus forest in the western foothills of the Tucson Mountains. “Our goal is to...

Events

Press Releases

Running

February 14, 2024

Registration Will Open for Richard S. Caliguiri City of Pittsburgh Great on Feb. 15 with Special Two-Day Opening Pricing

PITTSBURGH, PA – (February 14, 2024) /ENDURANCE SPORTSWIRE/ - Registration for the 47th annual Richard S. Caliguiri City of Pittsburgh Great Race presented by Highmark Blue Cross Blue Shield and 29th annual Dollar Bank Junior Great Race will open on Feb. 15. To celebrate the return of this must-do Pittsburgh...

Events

Press Releases

Running

February 14, 2024

Penticton adds IRONMAN 70.3 Triathlon; Joins Iconic IRONMAN Canada Triathlon, Part of the VinFast IRONMAN North America Series

- IRONMAN 70.3 Canada triathlon scheduled for Sunday, Aug. 25, 2024; General registration to open on Wednesday, Feb. 21 can be accessed by visiting, www.ironman.com/im703-canada PENTICTON, B.C., Canada / TAMPA, Fla. (Feb. 14, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today the return of the IRONMAN® 70.3® Canada triathlon which will be...

Events

Press Releases

Triathlon

February 14, 2024

Team Skyline – Cadence Pro Cycling at Gran Premio New York City

NEW YORK CITY, February 14, 2024 /ENDURANCE SPORTSWIRE/ – The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The teams...

Cycling

Events

Press Releases

February 14, 2024

The Golden Trail World Series Powered by Salomon Lands in Marin on September 14/15th

/ENDURANCE SPORTSWIRE/ – The Golden Trail World Series, the preeminent global trail running circuit, lands in Marin at the Headlands 27k powered by Salomon on September 14 and 15. This 27k looped course features many of the Marin Headlands and Mt. Tam's most historic trails, Dipsea, Matt Davis, Bootjack, and...

Events

Press Releases

Running

February 14, 2024

BibRave Brings Innovative Marketing Approach to Giant Race Series

San Francisco, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, has once again partnered with Giants Enterprises, the entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, to provide marketing services for the annual San Francisco Giant Race and the return of the Scottsdale Giant...

Business

Events

Press Releases

Running

February 14, 2024

Garda Bike Hotel’s Nicola Verdolin to Ride Gran Fondo Florida

Gettysburg, PA – February 14, 2024) /ENDURANCE SPORTSWIRE/ – Gran Fondo National Series and Garda Bike Hotel today announced that Nicola Verdolin, President of Garda Bike Hotel and the Andiamo Cycling touring company, will attend Gran Fondo Florida in Dade City, Florida on March 17, 2024. A long-time partner of Gran...

Cycling

Events

Press Releases

February 14, 2024

American River Endurance Runs, Presented by Altra – The Trails are Calling!

Auburn, CA /ENDURANCE SPORTSWIRE/ - American River 50-Mile Endurance Run (AR50), presented by Altra, the iconic, historic and second-largest 50-mile endurance run in the United States is returning for its 45th year. The prestigious race event brings together veterans, first-timers, and runners traveling from out of the country. Taking place...

Events

Press Releases

Running

February 14, 2024

GFNY announces second race in Brazil

/ENDURANCE SPORTSWIRE/ – GFNY Global Endurance Sports Series brings GFNY Conservatória back to the 2024 race schedule on August 4 after a five year hiatus. The competitive long distance is 130.1km with 2533m of climbing. Start and finish will be hosted at Rua das Flores. This route will lead riders...

Cycling

Events

Press Releases