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

July 6, 2023

Plan Your Race Calendar: IRONMAN Launches Spring 2024 IRONMAN 70.3 Triathlon Race Schedule In North America And Europe

TAMPA, Fla. (July 6, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN is pleased to unveil its spring 2024 IRONMAN® 70.3® triathlon race calendar for Europe, the United States and Canada. Several popular IRONMAN 70.3 events across North America and Europe will open for general registration on Wednesday, July 12. Athletes looking to...

Events

Press Releases

Triathlon

July 6, 2023

National Cycling League Announces New CEO

/ENDURANCE SPORTSWIRE/ - The National Cycling League (NCL) has brought on experienced sports veteran Andrea Pagnanelli as Chief Executive Officer. “Andrea has been tremendous in building our vision for 2023 and has learned the business inside and out. Andrea's extensive experience working at the intersection of business and sports makes...

Cycling

Events

Press Releases

Sponsorship

Triathlon

July 6, 2023

Super Sunday: two GFNY races on same day

/ENDURANCE SPORTSWIRE/ - With the ever growing GFNY calendar now consisting of over 30 races, having two races on the same day is becoming more common. In 2023, there will be three Sundays where this happens. “Obviously we’re trying to avoid date collisions on the GFNY calendar where possible, in...

Cycling

Events

Press Releases

July 6, 2023

PRRO Circuit 2023-24 Resumes Action at Sold-Out Boilermaker 15K

UTICA, NY /ENDURANCE SPORTSWIRE/ - On Sunday, July 9, the Boilermaker 15K Road Race presented by Excellus BlueCross BlueShield hosts the second stop on the PRRO Circuit 2023-24. The winners of the sold-out summer tradition will qualify to compete for the $15,000 PRRO Super Bonus at the 27th PRRO Championship...

Events

Press Releases

Running

July 6, 2023

Maine Summer Adventure Race to offer taste of the Atlantic Ocean

Portland, MAINE /ENDURANCE SPORTSWIRE/ – Adventure racing is about to hit the Atlantic Ocean, as the 2023 Maine Summer Adventure Race hits the beaches and waves for its seventh annual edition on July 22, 2023. The 3-hour, 8-hour, and 24-hour editions of Maine’s only U.S. Adventure Racing Association-sanctioned adventure race will...

Events

Press Releases

July 6, 2023

The 11th Annual Northwestern Medicine Lake Bluff Criterium Returns to The Village on Saturday, July 29th

/ENDURANCRE SPORTSWIRE/ - Feel the need for speed? Be there to enjoy a day of fabulous racing, food, music, and more!  The 11th annual Northwestern Medicine Lake Bluff Criterium will take place in downtown Lake Bluff on Saturday, July 29th from 11 am until 8 pm, rain or shine. The...

Cycling

Events

Press Releases

July 5, 2023

U.S. Olympian Ben Blankenship Returns to Pittsburgh to Attempt Third Fleet Feet Liberty Mile Win

PITTSBURGH (July 5, 2023) /ENDURANCE SPORTSWIRE/ - U.S. Olympian Ben Blankenship and other top milers will join 1,500 other runners who will test their speed at the Fleet Feet Liberty Mile on July 7. Downtown Pittsburgh’s only night time road race has attracted both first-time runners, as well as some...

Events

Press Releases

Running

July 5, 2023

Showcased

Battle Of Waterloo Triathlon Announces Partnership with Survival of The Shawangunks Triathlon to Award Entries for Sold-Out Race

Grass Lake, MI (July 5, 2023) /ENDURANCE SPORTSWIRE/ - Ann Arbor-based race company, Epic Races, today announced that the winners of this year’s Battle of Waterloo (BOW) 10-stage triathlon will be awarded coveted entries into the Survival of the Shawangunks (SOS) 8-stage triathlon which sells out in minutes each year....

Events

Press Releases

Triathlon

July 5, 2023

11th Annual Saints Kickoff Run Presented by Hancock Whitney Open for Registration

New Orleans, LA – July 5, 2023 /ENDURANCE SPORTSWIRE/ - The New Orleans Saints and Easy Day Sports are thrilled to announce that online registration for the 11th Annual Saints Kickoff Run, presented by Hancock Whitney, is now open at saints5k.com. The race will take place on Saturday, September 9th,...

Events

Press Releases

Running