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

April 3, 2023

Runners to Race for Climate Research

/ENDURANCE SPORTSWIRE/ – For the second year in a row, Biosphere 2 is partnering with Run Tucson to host the annual TMC Earth Day 5K Race on Saturday, April 22. The race starts in the morning, but for folks and families looking for fun outside of the race, Biosphere 2 will...

Events

Press Releases

Running

April 3, 2023

Author Matt Fitzgerald Launches Dream Run Camp

Flagstaff, AZ /ENDURANCE SPORTSWIRE/ – Celebrated endurance sports author Matt Fitzgerald today announced the upcoming launch of Dream Run Camp. The new venture was inspired by Fitzgerald’s experience as a self-described “fake pro runner” in 2017, when he spent a full summer training with the Flagstaff-based HOKA Northern Arizona Elite team before...

Events

Press Releases

Running

April 1, 2023

Northwest Arkansas is ready to host the First Expedition Ozark

/ENDURANCE SPORTSWIRE/ - Adventure racers from all over the USA and the world are now arriving in the towns of Fayetteville and Bentonville, Northwest Arkansas, for the inaugural Expedition Ozark. The new race is part of the Adventure Racing World Series and has attracted teams from elite status to local...

Events

Press Releases

April 1, 2023

Léo Bergère (Fra) And Tamara Jewett (Can) Claim Victories at Athletic Brewing IRONMAN 70.3 Oceanside Triathlon To Kick Off The 2023 North American IRONMAN 70.3 Race Season

OCEANSIDE, Calif. (April 1, 2023) /ENDURANCE SPORTSWIRE/ - Oceanside, California and Marine Corps Base Camp Pendleton once again played host to the Athletic Brewing IRONMAN® 70.3® Oceanside triathlon on Saturday, April 1 kicking off the 2023 North American IRONMAN 70.3 schedule. With many of triathlon’s best on hand, the event...

Events

Press Releases

Triathlon

March 31, 2023

Live tracking comes to the Buck Fifty

Front Royal, Va. /ENDURANCE SPORTSWIRE/ – The Buck Fifty, a popular 150-mile overnight relay race based out of Chillicothe, Ohio, is gearing up for their 2023 event on April 21-22. To help enhance the experience for participants and event directors alike, the Buck Fifty has partnered with Enabled Tracking, a real-time...

Events

Press Releases

Products

March 30, 2023

World Champions and Top Contenders To Highlight High Caliber Pro Field At Athletic Brewing IRONMAN 70.3 Oceanside Triathlon To Kick Off The 2023 IRONMAN 70.3 North American Series

OCEANSIDE, Calif. (March 30, 2023) /ENDURANCE SPORTSWIRE/ - Top talent from around the globe along with approximately 2,800 age group athletes will descend on the South Coast of California on Saturday, April 1 at the 2023 Athletic Brewing IRONMAN® 70.3® Oceanside triathlon. A world-class field of professional athletes featuring IRONMAN...

Events

Press Releases

Triathlon

March 30, 2023

Wesley Kiptoo and Caroline Rotich Aim to Defend Titles at the 2023 UPMC Health Pittsburgh Half Marathon

PITTSBURGH (March 30, 2023) /ENDURANCE SPORTSWIRE/ – Wesley Kiptoo and Caroline Rotich will return to the streets of Pittsburgh to defend their titles at the 2023 UPMC Health Plan Pittsburgh Half Marathon, scheduled for Sunday, May 7. Last year in their Pittsburgh debuts, Kiptoo and Rotich both set new event records....

Events

Press Releases

Running

March 30, 2023

Course Records Expected to Drop at 13th Annual Carmel Marathon Weekend

CARMEL, Ind. (March 30, 2023) /ENDURANCE SPORTSWIRE/ – With one of the fastest and flattest Midwestern marathon and half marathon courses in the spring, the 2023 Carmel Marathon Weekend has attracted an elite field of runners aiming to break course records on Saturday, April 8 in Carmel, Ind. CRRG Events, event...

Events

Press Releases

Running

March 30, 2023

XTERRA Returns to Australia + World Cup Preview

/ENDURANCE SPORTSWIRE/ – XTERRA is headed down under for the first time since 2019 when the third stop on the 2023 Asia-Pacific Tour rolls into the southwest coastal town of Dunsborough, Western Australia this weekend. The race will award $7,500 USD equally to the top 5 men and women elite competitors...

Events

Press Releases

Triathlon