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 (11)
) 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 510, 10

August 29, 2024

Sport for good : Destination Sport Experiences launches Destination Sport Charity

Manchester, UK – Thursday 29th August 2024/ENDURANCE SPORTSWIRE/ – Leaders in global sports experiences, Destination Sport Experiences, are delighted to announce the launch of Destination Sport Charity. Destination Sport Charity promises to become the ultimate partner for charities seeking to access premium fundraising opportunities through a wide range of events and...

Business

Giving

Press Releases

August 28, 2024

Polartec Continues ‘Beyond Begins Today’ Mini Series with Launch of Chapter 2: People

Planet Earth, The Universe (August 28, 2024) /ENDURANCE SPORTSWIRE/ – Polartec, a Milliken & Company brand and the premium creator of innovative and more sustainable textile solutions, introduces PEOPLE, the second chapter in Polartec’s multifaceted Beyond Begins Today campaign. Featuring Sierra Quitiquit (Pro Skier, Influencer and Environmental Activist), Helgi Oskarsson...

Business

Press Releases

August 28, 2024

Outside Launches Integrated Social Platform to Inspire More Adventure

BOULDER, CO /ENDURANCE SPORTSWIRE/ – Outside Interactive, Inc., the world’s leading creator of outdoor content, mapping, events, and experiences, today announced the launch of a community-based social platform. What will soon be available to more than 100 million registered users, including 1 million paid subscribers across the Outside Network, the social...

Business

Press Releases

Products

August 27, 2024

Spotlighting Inspiration, The James Brand Introduces Be James

PORTLAND, OR (August 27, 2024) /ENDURANCE SPORTSWIRE/ – The James Brand – makers of modern, minimal everyday carry products – launches Be James°, a series spotlighting individuals who push boundaries, challenge norms, and inspire others to step outside their comfort zones. By showcasing the diverse talents and experiences of athletes,...

Business

Press Releases

August 26, 2024

Redwood Outdoors Named the Official Sauna and Cold Plunge of Spartan Seattle and Spartan Los Angeles

BOSTON, MASS. /ENDURANCE SPORTSWIRE/ - In an exciting development for endurance athletes, Spartan Race, the global leader in obstacle course racing, is thrilled to announce Redwood Outdoors as the Official Sauna and Cold Plunge Partner for its upcoming Seattle and Los Angeles races. This partnership marks a significant step forward in...

Business

Events

Press Releases

Products

Running

Sponsorship