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

August 3, 2022

Registration Open for the 2023 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events

PITTSBURGH, PA /ENDURANCE SPORTSWIRE/ – Registration for the 2023 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events is officially open. More than 40,000 MOVERS are expected to register for the 15th anniversary event, scheduled for May 6-7, 2023. P3R will celebrate the 15th anniversary with special one-day pricing at the lowest...

Events

Press Releases

Running

August 3, 2022

GFNY takes over Kuala Lumpur on February 12, 2023

/ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series adds GFNY Kuala Lumpur, scheduled for February 12, 2023. Riders will get to experience a race that starts and finishes in the heart of Malaysia’s metropolis. The 138 km long course will take athletes from the heart of the city, into the...

Cycling

Events

Press Releases

August 3, 2022

Showcased

Elevate Women 4-Tri Malibu Triathlon Women’s Only Training Program

/ENDURANCE SPORTSWIRE/ – 2XU Malibu Triathlon is excited to announce the Elevate Women 4Tri 7-week triathlon training program will kick off the week off August 8th and lead right into race weekend September 17-18, 2022. The women’s only training program is designed to encourage participation for women learning the sport of...

Cycling

Events

Press Releases

Running

Triathlon

August 3, 2022

World’s Most Exclusive Half Marathon is back and running

August 3, 2022 /ENDURANCE SPORTSWIRE/ –  RunningFlat and Pelee Island Winery team up again to offer the most exclusive running experience in the world—an island run through one of Canada’s oldest grape growing regions making this Half Marathon Canada’s most Southern. Pelee Island, Ontario June 3rd 2023 —Canada’s southernmost half marathon, the...

Events

Press Releases

Running

Wire Syndication

August 2, 2022

IRONMAN Announces New IRONMAN 70.3 Morro Bay Triathlon in The Central Coast of California

MORRO BAY, Calif. / TAMPA, Fla. (Aug. 2, 2022) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group, announced today that the seaside city of Morro Bay, California and the central California coastline will play host to the newest IRONMAN® 70.3® triathlon. The new IRONMAN 70.3 Morro Bay triathlon is schedule to take...

Events

Press Releases

Triathlon

August 2, 2022

GFNY back in Bali this Sunday

New York City, August 2, 2022/ENDURANCE SPORTSWIRE/ – This Sunday, the GFNY Championship Asia is held at GFNY Bali Element Camp on the ‘Island of the Gods’. The 136.9 km racecourse boasts 2126m of climbing in one of the most sought after travel destinations in the world. “The mere mention of...

Cycling

Events

Press Releases

August 1, 2022

‘La Vuelta Virtual 22’ Warm-Up Racing Weekend #4 – August

Madrid, Spain / August 1st, 2022/ENDURANCE SPORTSWIRE/ – La Vuelta calls on cyclists and fans, of all fitness levels, to ride with the pros from Equipo Kern Pharma and Elisa Scarlatta to explore Spain. Elisa Scarlatta is a passionate Italian amateur cyclist, an influencer and a multi-brand ambassador on social media,...

Cycling

Events

Press Releases

August 1, 2022

Get Ready to Run with Marathon Legends

MEDIA ALERT Monday 1 August /ENDURANCE SPORTSWIRE/ – The AbbottWMM Global Run Club today launched Legends Week – a new free virtual Challenge taking place from 15-19 August. Runners must complete one challenge a day, for five days, to earn their Legends Week virtual badge and enter a prize draw for a...

Events

Press Releases

Running

August 1, 2022

Run Local Race Series registration now open

LITTLE ROCK, ARK (August 1, 2022) /ENDURANCE SPORTSWIRE/ - Registration is now open for the Run Local Race Series, which includes three different major races each calendar year. The Run Local Race Series is a Little Rock Marathon-led grassroots health initiative that focuses on promoting the benefits of a healthy...

Events

Press Releases

Running