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

October 19, 2022

Race Across America and Inifinty Seats Announce 2023 Partnership

Boulder, CO /ENDURANCE SPORTSWIRE/ - Race Across America (RAAM) is pleased to announce a new partnership with Infinity Seats. Both brands are recognized world-wide for their excellence in their respective industries. 2023 marks the 41st year for Race Across America – The World’s Toughest Bicycle Race. Riders come from around...

Press Releases

Sponsorship

October 19, 2022

First Round of Official Nonprofits Selected for Austin Marathon

AUSTIN, Texas/ENDURANCE SPORTSWIRE/ - The Ascension Seton Austin Marathon is excited to announce the first round of selected 2023 charities for their Austin Marathon Gives program. Austin Marathon Gives, presented by the Moody Foundation, is the Official Charity Program for the Austin Marathon®. Each non-profit will raise awareness for their...

Giving

Press Releases

October 19, 2022

Correa and Melo win GFNY Bento Gonçalves

New York City, October 19, 2022 /ENDURANCE SPORTSWIRE/ - Bento Gonçalves, located in the heart of Brazil's Sierra Gaúcha, hosted the first edition of GFNY Bento Gonçalves 2022 this past Sunday. The racecourse was 138.6 km long with 2957m of climbing. Pro cyclist Alex Melo (Maxel Cycling) took the win...

Cycling

Events

Press Releases

October 19, 2022

The countdown is on for the 2022 World Triathlon Championship Series Bermuda

Hamilton, BERMUDA - 19 October, 2022 /ENDURANCE SPORTSWIRE/ - Anticipation mounts as the World Triathlon Championship Series (WTCS) Bermuda makes its long-awaited return on 5 - 6 November, 2022, just under a month away. It is all hands-on deck to pull together an event of this magnitude, and both the...

Events

Press Releases

Triathlon

October 19, 2022

BibBoards and The Donna Foundation Partner Up to Take Breast Cancer Down

/ENDURANCE SPORTSWIRE/ – BibBoards has partnered with The Donna Foundation to raise money and spread awareness during Breast Cancer Awareness month. Exclusive Breast Cancer Awareness designs will be available with proceeds going to The Donna Foundation and their work in cancer research. These exclusive bibSNAPS are the best way to support...

Cycling

Giving

Press Releases

Products

Running

October 19, 2022

XTERRA Returns to Australia in 2023

October 19, 2022 /ENDURANCE SPORTSWIRE/ – XTERRA returns to Australia in 2023 with a World Championship qualifying event in the southwest coastal town of Dunsborough, Western Australia on the weekend of April 1-2, 2023. The inaugural XTERRA Australia - Dunsborough off-road triathlon starts with a 1.5-kilometer swim in the turquoise waters...

Events

Press Releases

Running

Triathlon

October 19, 2022

Gold Coast gets ready to host the first Adventure Racing World Series Oceania Championships

/ENDURANCE SPORTSWIRE/ – The first Adventure Racing World Series Oceania Championship race takes place in Gold Coast and its hinterland hills and rivers between October 21st and 23rd. The best Adventure Racers in Australia will arrive in the city for 36 and 24 hour races, combining river paddling, trekking, coasteering, beach...

Events

Press Releases

October 19, 2022

BibRave Drives Sell-Out Numbers for the IMT Des Moines Marathon

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance, and fitness marketing agency, has partnered with the IMT Des Moines Marathon for years, providing marketing services and custom program ideation that boost registration and enhance the race experience for participants. In 2022, BibRave provided comprehensive 12-month marketing services, including strategy and ideation,...

Events

Press Releases

Running