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

July 7, 2023

12 National Titles Awarded on Day 2 of Cross-Country Mountain Bike Nationals at Bear Creek

MACUNGIE, Penn. /ENDURANCE SPORTSWIRE/ – It was a hot, humid, and beautiful day for racing at the 2023 USA Cycling Cross-Country Mountain Bike National Championships. Riders competed in the Master’s Cross-Country, Junior Short Track, e-Bike, and Non-Championship races. This is the event's first time back on the east coast since 2018...

Cycling

Events

Press Releases

July 7, 2023

RunSignup Expands into Track Meet, Cross Country, and Tournament Events with Spectator Tickets

July 7, 2023 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology solution provider for endurance events in the United States, announces its expansion into track meet and cross country spectator tickets with its TicketSignup technology. Timers and event organizers are able to use TicketSignup to sell...

Business

Cycling

Events

Giving

Press Releases

Products

Running

Triathlon

July 6, 2023

Andrew Messick To Retire After 12 Years as President and Chief Executive Officer of The IRONMAN Group, Leading Company Through Some of Its Most Transformative Years

TAMPA, Fla. (July 6, 2023) /ENDURANCE SPORTSWIRE/ - After 12 years of transformative leadership, Andrew Messick has announced he will be retiring in 2023 from his position of President & Chief Executive Officer for The IRONMAN Group. Messick will remain a stakeholder and member of the Board of Directors following...

Events

Press Releases

Triathlon

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

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