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

December 21, 2023

CABDA Unveils Education Schedule for West Expo

/ENDURANCE SPORTSWIRE/ Chicago, IL – December 21, 2023 – Organizers of the CABDA Expo announced the release of their comprehensive education schedule for CABDA West, set to take place outside of Los Angeles on January 10 & 11. The CABDA Education Series is organized and presented by the National Bicycle...

Cycling

OSW Syndicated

Press Releases

Trade Shows

December 21, 2023

GFNY announces second race in Peru

/ENDURANCE SPORTSWIRE/ GFNY Global Endurance Sports Series adds GFNY Paracas to the 2024 race schedule on June 8. The competitive long distance is 116km with 662m of climbing. Start and finish will be hosted at Kite Club Paracas which is located 3.5 hours south of Lima. “After three editions of...

Cycling

Events

Press Releases

December 21, 2023

Marathon Tours & Travel announces further growth of expert team

/ENDURANCE SPORTSWIRE/ Marathon Tours & Travel (MTT) provides comprehensive travel packages for runners that include guaranteed entry, transfers, accommodation, and expert team support for some of the most popular events around the world. Proud partners of the Abbott World Marathon Majors, the team is extremely well connected, working closely with global...

Business

Press Releases

Running

December 21, 2023

UCI Gravel World Championship Qualifier Returning to Fayetteville

FAYETTEVILLE, Ark. (Dec 21, 2023) – ENDURANCE SPORTSWIRE -  Registration is open for the 2024 Highlands Gravel Classic to be held on April 27, 2024 in Fayetteville, Arkansas. The 2024 Highlands Gravel Classic which will once again be part of the UCI Gravel World Series, and an official qualifying event...

Cycling

Events

Press Releases

December 21, 2023

The ARWS Oceania Series 2024 Expands with New Races and Locations

/ENDURANCE SPORTSWIRE/ 2024 is a breakthrough year for the Adventure Racing World Series in Oceania. The series will grow to 8 races, presented by 5 experienced Race Directors, uniting Adventure Racing in Australia and New Zealand into a competitive race calendar. Teams taking part will feature in the ARWS-Oceania rankings...

Events

Press Releases

December 21, 2023

The Atlanta Rise, Denver Disruptors, and Miami Nights Announce their 2024 National Cycling League (NCL) Cup Team Rosters

 (Miami, Fla, December 21, 2023) /ENDURANCE SPORTSWIRE/ - After a successful inaugural season, three teams from the National Cycling League announced their 2024 rosters. Two second-year teams, Denver Disruptors and Miami Nights, will include riders from 2023, plus talented rookies and familiar names. First-year team Atlanta Rise has a roster...

Business

Cycling

Events

Press Releases

December 20, 2023

New Year, New You: IRONMAN Announces 2024 Commitment Day Aimed at Encouraging Athletes to Find Their IRONMAN or IRONMAN 70.3 Finish Line

IRONMAN Commitment Day looks to welcome thousands of athletes to the community of IRONMAN and IRONMAN 70.3 finishers in 2024 New Year’s resolutions in full force, IRONMAN Commitment Day encourages athletes to setting a goal and working towards completing an IRONMAN or IRONMAN 70.3 triathlon Athletes can learn more about...

Events

Press Releases

Triathlon

December 20, 2023

Spartan Race Leaps into 2024 Brand Activations with EventHub

ENDURANCE SPORTSWIRE - EventHub, the leading event sponsorship marketplace for the endurance racing industry, is proud to announce that ALL of the Spartan Portfolio of North American events including Spartan, Tough Mudder, DEKA FIT and Spartan Kids related 2024 brand activation and partnership opportunities are now available on EventHub. Interested...

Business

Press Releases

Running

Sponsorship