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

October 3, 2023

Challenge Barcelona Triathlon Kicks Off with a Sell-Out Event and World-Class Pro Field

/ENDURANCE SPORTSWIRE/ - This weekend’s inaugural Challenge Barcelona Triathlon on Sunday 8 October is a sell out with 3,200 participants from 57 countries, including a strong field of over 70 professional athletes competing over the new Elite Short distance in the heart of one of Europe’s most iconic cities. Formerly...

Events

Press Releases

Triathlon

October 2, 2023

Disney Veteran Dennis Snow Set to Wow Audience at Running USA’s 2024 Industry Conference

ORLANDO (Oct. 2, 2023) /ENDURANCE SPORTSWIRE/ - Running USA is excited to announce that Dennis Snow, a renowned customer service leader and recognized innovator at Walt Disney World, will address attendees on February 1, 2024 as the keynote speaker of the 20th Industry Conference presented by haku. “I am thrilled...

Press Releases

Trade Shows

October 2, 2023

Amy Cymerman and Matthew Sharpe take first place in New York City Triathlon

NEW YORK (Oct. 2, 2023)/ENDURANCE SPORTSWIRE/ – The New York City Triathlon, produced by Life Time (NYSE: LTH) and recently acquired by Super League Triathlon, welcomed nearly 1,800 athletes from 43 states and 19 countries ranging in age from 14-80. “We’re so proud of all the athletes who competed today. Despite required...

Events

Press Releases

Triathlon

October 2, 2023

SPORTIME Clubs and Hornig Capital Partners Partner to Develop Pickleball Facilities

New York, October 2, 2023/ENDURANCE SPORTSWIRE/ – SPORTIME Clubs and Hornig Capital Partners announced today that they have signed a partnership agreement to establish a new company, SPORTIME Pickleball, LLC, that will develop and operate state-of-the-art, standalone, pickleball facilities in the tri-state area under the SPORTIME brand. The joint venture is...

Business

Press Releases

October 2, 2023

Experiencing ‘Goa Beyond Beaches’ at India’s 2nd National Adventure Racing Championship.

/ENDURANCE SPORTSWIRE/ - India successfully hosted a 2nd National AR Championship in Goa. The race was themed as “Goa Beyond Beaches” and explored a destination which is famous for its beaches and as an exclusive water sports adventure destination. Adventure Racing in India is growing rapidly with many new teams...

Events

Press Releases

October 2, 2023

Approximately 11,000 Runners Took to The Streets of Speed City, USA for The 2023 United Airlines Rock ‘N’ Roll Running Series San Jose

SAN JOSE, Calif. /ENDURANCE SPORTSWIRE/ - Approximately 11,000 registered participants took the to the streets of Speed City, USA as the United Airlines Rock ‘n’ Roll® Running Series San Jose returned over the weekend. The Rock ‘n’ Roll Running Series is a best-in-class running series Bringing Fun to the Run®...

Press Releases

Running