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

July 6, 2023

J&A Racing and Hoffman Beverage Company Announce New Partnership

July 6, 2023 – VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ - J&A Racing is excited to announce a new partnership with Hoffman Beverage Company, which will now become the preferred alcoholic beverage partner for 7 race weekends throughout the year. Both J&A Racing and Hoffman Beverage Company are locally owned and operated...

Business

Events

Press Releases

Running

July 6, 2023

Borah returns as official jersey sponsor for Intelligentsia Cup 2023!

July 6, 2023 Chicago, IL /ENDURANCE SPORTSWIRE/ - The Intelligentsia Cup is pleased to announce Borah Teamwear as a returning sponsor - and official jersey supplier - for the 2023 Intelligentsia Cup race series. “We love working with the Borah team! They do a fantastic job of taking our vision...

Cycling

Events

Press Releases

Sponsorship

July 6, 2023

Olympic And World Champions Kristian Blummenfelt And Léo Bergere Join All-Star Super League Triathlon Line-Up

/ENDURANCE SPORTSWIRE/ - Kristian Blummenfelt will race the Super League Triathlon (SLT) 2023 Championship Series alongside Léo Bergere, ensuring the men's line-up includes the reigning Olympic individual, Mixed Relay, World Triathlon, Commonwealth Games and SLT champions. Blummenfelt, the 29-year-old Norwegian who has an IRONMAN and IRONMAN 70.3 World Championship title...

Press Releases

Triathlon

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