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

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

December 20, 2023

80/20 Endurance Adds Triathlon Plans to Its Team 80/20 Subscription on Final Surge

Midway, UTAH – Dec 20, 2023/ENDURANCE SPORTSWIRE/ – 80/20 Endurance, the world’s largest provider of online endurance training plans, today announced the addition of triathlon plans to its portfolio of training plans available on the Final Surge fitness app. Athletes who subscribe to Team 80/20 on Final Surge will have...

Press Releases

Products

Triathlon

December 19, 2023

To Promote More Mindful Drinking, Athletic Brewing Company Launches ‘Track Record’

MILFORD, Conn. and SAN DIEGO (December 19, 2023) /ENDURANCE SPORTSWIRE/ - Athletic Brewing Company, America’s largest non-alcoholic brewery, is inviting drinkers to ‘Give Dry a Try’ this January by offering an easy way to track the days they don’t consume alcohol. Called Track Record, the new alcohol moderation tool will...

Cycling

Events

Press Releases

Products

Running

December 19, 2023

Verge Renews Commitment to EuroCross Academy

NEW YORK, Dec 19, 2023 - ENDURANCE SPORTSWIRE – Verge, the leader in innovative custom cycling apparel, proudly announces the continuation of its sponsorship of the EuroCross Academy, a junior cyclocross team comprising talented riders from the United States who will be competing in Belgium during the “holy week” of...

Cycling

Press Releases

Sponsorship