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

December 19, 2023

USA Cycling Announces BMX Freestyle Athletes Selected for the 2024 Olympic Qualifier Series

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Cycling announced today the athletes who have been selected for the first-ever Olympic Qualifier Series hosted by the International Olympic Committee. The series includes two prestigious events in 2024: the first in Shanghai, China, from May 16-19, and the second in Budapest, Hungary,...

Cycling

Events

Press Releases

Sponsorship

December 19, 2023

Quintana Roo selected Official Bike Partner of Challenge Family Series

/ENDURANCE SPORTSWIRE/ - Quintana Roo and Challenge Family announce a multi-year partnership naming Quintana Roo the Official Global Bike Partner of Challenge Family, beginning a collaboration that brings triathlon’s leading bike brand to a greater global base at Challenge Family events throughout Europe, Asia and beyond. Now in its 21st...

Press Releases

Sponsorship

Triathlon

December 19, 2023

Bikeflights Buck Up For Bikes Program Donates $20,000

PORTLAND, OR (December 19, 2023) /ENDURANCE SPORTSWIRE/ - Bikeflights has donated $20,000 through its Buck Up For Bikes program to five non-profit cycling organizations: Trip for Kids, National Interscholastic Cycling Association, Little Bellas, International Mountain Bike Association and World Bicycle Relief. The donation includes contributions made by Bikeflights’ customers throughout...

Business

Cycling

Giving

Press Releases

December 18, 2023

Plan Your Race Calendar: IRONMAN Launches Winter 2024 Ironman 70.3 Triathlon Race Schedule in the United States

TAMPA, Fla. (Dec. 18, 2023) – IRONMAN is pleased to unveil its winter 2024 IRONMAN® 70.3® triathlon race calendar for events taking place in the United States. Several popular IRONMAN 70.3 events across the U.S. will open for general registration on Monday, Dec, 18 at 12 p.m. ET. Athletes looking...

Events

Press Releases

Triathlon

December 18, 2023

Race Across America Introduces Race Across the East

December 18, 2023 / Boulder, CO /ENDURANCE SPORTSWIRE/ –  Race Across America, Inc. (The Company) is pleased to announce the inaugural Race Across the East (RAE). RAE will start June 19, 2024 in Blanchester, Ohio, follow the Race Across America (RAAM) route, and finish in Atlantic City, New Jersey. The race...

Cycling

Events

Press Releases

December 18, 2023

Shimano to Sponsor U23 Entries to Gran Fondo National Series Cycling Events

(Gettysburg, PA ) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series today announced that Shimano will sponsor the opportunity for riders under 23 years of age (U23) to register for SUAREZ Gran Fondo National Series events for just $23 per event. This sponsorship bolsters the long-term partnership between the Series and...

Business

Cycling

Events

Press Releases

Sponsorship

December 18, 2023

MarathonFoto to Capture the Spirit of the 2024 Running USA Industry Conference Morning Run and Share Data from Photos

ORLANDO /ENDURANCE SPORTSWIRE/ - MarathonFoto, the industry leader in race photography, is excited to announce its participation in the upcoming Running USA Industry Conference Morning Run. As the official photography partner for the event, MarathonFoto will be on-site to capture vibrant moments of runners and share valuable data from the...

Press Releases

Trade Shows