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

April 5, 2023

Hotel Engine to be an Official Partner with Spartan

BOSTON, MASS. (4/5/23)  /ENDURANCE SPORTSWIRE/ – Spartan, the world's leading endurance sports and extreme wellness brand, announced Hotel Engine will be the Official Lodging Partner of Spartan Race U.S for the 2023 race season. “We are excited to name Hotel Engine as our Official Lodging Partner for Spartan Race in North...

Events

Press Releases

Running

Sponsorship

April 4, 2023

PTO Renews 36-Country Broadcast Deal with beIN Sports

London, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has renewed its deal with beIN SPORTS, as one of the main broadcasters of the 2023 PTO Tour. The deal will see them broadcast the PTO Tour on a non-exclusive basis in MENA, Asia and North America (US & Canada). The agreement...

Business

Events

Press Releases

Triathlon

April 4, 2023

Ultra X Goes Loopy: Partners Announced

/ENDURANCE SPORTSWIRE/ – Ultra X, the global ultra-marathon events series, is excited to announce the partners for their upcoming event, Ultra X Goes Loopy, in 2023. The event promises to be incredible, thanks to the involvement of Asics, Red Bull, Days Brewing, Jubel, Phizz, and Rise Porridge. “Ultra X was setup...

Events

Press Releases

Running

April 4, 2023

The RunnerBox and RiderBox Partner with University of North Carolina Asheville to Enhance the Entrepreneurial Ecosystem and Spur Company Growth

/ENDURANCE SPORTSWIRE/ - The RunnerBox & The RiderBox, which curates subscription and gift boxes for runners and cyclists, has been working with UNC Asheville business students since January as part of a Business Consulting Practicum. The class, taught by Associate Professor of Business, Dr. Susan Clark allows students to have...

Business

Events

Press Releases

Running

April 4, 2023

The National Cycling League (NCL) Announces the Team Lineup for Miami Beach Invitational

Miami, FL, April 4th, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League, the first of its kind, revolutionary professional sports league, built around 21st century values of diversity, gender equity, sustainability, and community, today announced the complete team lineup ahead of the inaugural NCL cup race, the Miami Beach Invitational on April...

Cycling

Events

Press Releases

April 4, 2023

GFNY announces Athletes´Choice Awards 2022

New York City /ENDURANCE SPORTSWIRE/- GFNY announces the 2022 top 3 best events overall, the best finish village, best pre-race activities, best race destination, best pre race communication, best start area, best aid stations, best course, best course organization and best finish line. The results are based on post-race surveys...

Cycling

Events

Press Releases

April 4, 2023

Sportive Breaks announces partnership with indoor cycling platform, BKOOL

/ENDURANCE SPORTSWIRE/ - Sports travel experts Sportive Breaks offer bespoke premium travel packages for cyclists looking to take part in the worlds most prestigious cycling events, cycling breaks and weekenders. Supported by a team of highly experienced professionals who are on hand to help organise the perfect cycling holiday they...

Business

Cycling

Events

Press Releases

April 3, 2023

Samantha Kingsford & Sam Osborne win big in XTERRA’s return to Australia

/ENDURANCE SPORTSWIRE/ – Samantha Kingsford and Sam Osborne from New Zealand captured the inaugural XTERRA Dunsborough off-road triathlon elite titles in Western Australia on Sunday, April 2, 2023. It’s the ninth career XTERRA World Tour win for Kingsford, and the 21st for Osborne. In the women’s elite race Kingsford led from...

Events

Press Releases

Triathlon

April 3, 2023

J&A Racing Announces Inaugural Labor Day Race, The Chartway Virginia Beach 10 Miler & 5K

VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ – Excitement and preparations are underway for the newest of J&A Racing’s events. The Chartway Virginia Beach 10 Miler will debut this Labor Day weekend at the Virginia Beach Oceanfront. Participants will have the opportunity to run a 5K on Saturday, 10 Miler on Sunday, or...

Events

Press Releases

Running