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 (8742)
) 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 3330, 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

Challenge Family World Bonus Six Month Standings Released

/ENDURANCE SPORTSWIRE/ - With the first six months of racing in 2023 now complete, the Challenge Family Pro Athlete World Bonus has seen a number of changes in the men’s rankings but the women’s top three remains unchanged. Tom Bishop (GBR) had overtaken Mathis Margirier (FRA) to claim the top...

Press Releases

Triathlon

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

PTO Unveils Leading Cycling Brand Ekoï As A New PTO Tour Partner

London, UK /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) has signed up Ekoï as its first Official Helmet and Sunglasses Partner of the PTO Tour on a new three year deal. The leading cycling brand will begin its partnership at the PTO US Open in Milwaukee on 4-5 August 2023,...

Business

Press Releases

Sponsorship

Triathlon

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