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

July 18, 2022

Wine Country welcomes 4,000 runners for 18th running of Napa to Sonoma Half Marathon Weekend

Sonoma, California /ENDURANCE SPORTSWIRE/ - Sonoma County is blessed with more than 425 wineries, and on a sun-kissed Sunday morning, thousands of runners scampered past many of them for the 18th Napa to Sonoma Wine Country Half Marathon. No one was faster than the Reno, Nev., husband-wife tandem of Dominic...

Events

Press Releases

Running

July 18, 2022

Middaugh, Paterson win XTERRA USA Championship

/ENDURANCE SPORTSWIRE/ – Teenage phenom Sullivan Middaugh and five-time World Champion Lesley Paterson captured the 21st annual XTERRA USA Championship off-road triathlon elite titles on a picture-perfect blue sky day at Beaver Creek Resort near Avon, Colorado on Saturday, July 16, 2022. It’s the first elite win for the 18-year-old Middaugh,...

Events

Press Releases

Triathlon

July 15, 2022

Ultra Marathon Legend Charlie Engle’s ‘Movement For Recovery’ July Event Draws Star-Studded Participation

Havre de Grace, Md. (July 15, 2022) /ENDURANCE SPORTSWIRE/ - The Penguin: Movement for Recovery – a live and virtual event held July 23-24 - launches a worldwide campaign to celebrate addiction recovery using movement as a tool to not just survive but to thrive. In the middle of an...

Events

Giving

Press Releases

Running

July 15, 2022

Mar del Plata Set to Host IRONMAN 70.3 Triathlon on December 4, 2022

BUENOS AIRES, Argentina / TAMPA, Fla. (July 15, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that the city of Mar del Plata, Argentina will host the inaugural edition of the IRONMAN® 70.3® Mar del Plata triathlon with competition set to take place on Sunday, December 4, 2022. The event will coincide with the...

Events

Press Releases

Triathlon

July 15, 2022

Wanjiru Defends PRRO Title, Wins $10,000 PRRO Super Bonus at 45th Boilermaker 15K

UTICA, NY /ENDURANCE SPORTSWIRE/ - On Sunday morning July 10th under sunny, temperate conditions, the 45th Boilermaker 15K hosted the 25th PRRO Championship, and Jemal Yimer Mekonnen of Ethiopia and Rosemary Wanjiru of Kenya won the PRRO titles, the second for both, in 42 minutes, 38 seconds and 48:54, respectively....

Events

Press Releases

Running

July 14, 2022

U.S. Olympians, USA Road Mile Champions Ready to Race in Pittsburgh at the 2022 Fleet Feet Liberty Mile

PITTSBURGH /ENDURANCE SPORTSWIRE/ – The country’s fastest milers are ready to test their speed in the City of Champions at the 2022 Fleet Feet Liberty Mile, scheduled for Friday, July 22. Downtown Pittsburgh’s only night time road race will feature U.S. Olympians Clayton Murphy, Heather MacLean and Ben Blankenship, as well as...

Events

Press Releases

Running