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

June 20, 2022

Europe Gears Up for a Big Weekend of IRONMAN® and IRONMAN® 70.3® Racing Across Four Different Countries

LONDON, UK, June 20, 2022/ENDURANCE SPORTSWIRE/ The stage is set for a bumper weekend of swim-bike-run racing across Europe this weekend with two IRONMAN European Championship races in Frankfurt and Elsinore, as well as IRONMAN and IRONMAN 70.3 events taking place in Nice and Westfriesland. In Germany, a new male IRONMAN European...

Events

Press Releases

Triathlon

June 17, 2022

Expedition Ozark to draw international teams to Northwest Arkansas

BENTONVILLE, ARK. (June 16, 2022)/ENDURANCE SPORTSWIRE/ – Some of the world's best adventure racing teams will be in Northwest Arkansas April 3-8,2023 for a new race on the Adventure Racing World Series (ARWS) calendar of World Championship qualifiers, organizers announced Thursday. The Expedition Ozark race will be a new race on...

Events

Press Releases

June 17, 2022

Rootstock Racing to host The Endless Mountains Five-day Adventure Race in June 2022

Clarion, Pennsylvania/ENDURANCE SPORTSWIRE/ – Rootstock Racing is excited to announce the Endless Mountains Adventure Race, a five-day expedition race running June 20-25, 2022 through north central Pennsylvania. This new event builds upon Rootstock’s reputation as one of the premier adventure race organizations in the northeastern US. As the name suggests, Pennsylvania...

Events

Press Releases

June 17, 2022

USATF Marathon Championships return to the California International Marathon

SACRAMENTO, Calif. /ENDURANCE SPORTSWIRE/ - The California International Marathon (CIM) has been selected to host the 2022 U.S. Marathon Championships for men and women by USA Track & Field (USATF), the sport’s national governing body. The championship races will be held in conjunction with CIM’s point-to-point race from Folsom to...

Events

Press Releases

Running

June 17, 2022

The Ride for Mental Celebrates Hope and Healing, June 25-26

NEW YORK and BOSTON /ENDURANCE SPORTSWIRE/ - Joel Klein recalls driving frantically to the hospital in White Plains, NY, while his teenage daughter, Ava, drifted in and out of consciousness. She was suffering from the debilitating effects of anxiety, PTSD and Borderline Personality Disorder (BPD), according to specialists at McLean...

Cycling

Events

Giving

Press Releases

June 17, 2022

Bud Light Pensacola Fishing Rodeo Sets Sail June 24-27

Pensacola, FL/ENDURANCE SPORTSWIRE/ – Pensacola Sports is preparing to welcome all anglers to Pensacola Beach for the 2022 Bud Light Pensacola Fishing Rodeo. Teams and individuals will compete to catch the biggest fish in twenty-one different categories. The Bud Light Pensacola Fishing Rodeo consists of different events: General Rodeo: Anglers will compete...

Events

Press Releases