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 (21087)
) 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 260, 10

June 15, 2022

Showcased

First Run Show USA Los Angeles, opens box office with special ticket offer

/ENDURANCE SPORTSWIRE/ –Following the hugely successful launch of the Run Show USA in Chicago at the beginning of the month, the ticket box office for the Run Show USA Los Angeles opened this week with a special ticket offer available, offering 1,000 FREE tickets to the running expo. Visitors simply need...

Press Releases

Running

Trade Shows

June 14, 2022

The APEX Outdoor Festival & Expo Returns to Colorado Springs Sunday, September 25th

Colorado Springs, CO, June 14, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces the return of The APEX Outdoor Festival & Expo in September, marking the final stage of highest profile mountain bike event on The Front Range - The Pikes Peak APEX presented by RockShox. In addition to the 4-Day...

Cycling

Events

Giving

Press Releases

Running

Sponsorship

Trade Shows

June 10, 2022

Inaugural Run Show USA wows the North American Running Community

/ENDURANCE SPORTSWIRE/ – The first ever Run Show USA debuted in Chicago at the Donaldson E Stephens Convention Center June 4-5, 2022, attracting thousands of the running community who visited to get the latest gear, races, coaching advice, tech and nutrition ready for the coming marathon season. The weekend expo welcomed...

Press Releases

Running

Trade Shows

June 8, 2022

Climate Positive Sportswear Brand Presca Launch Webinar Series Hosted by CEO Rob Webbon

/ENDURANCE SPORTSWIRE/ – ‘The Lunchtime Webbonars’ is a new series with Rob Webbon, Presca’s CEO, who will be having casual chats with a selection of inspirational people from the Presca network and world of sustainability. Listening in will give insight into topics of endurance sports, to the industry supply chain, to...

Cycling

Press Releases

Running

Trade Shows

June 6, 2022

Outdoor Market Alliance Kicks Off First Summer Market Week

June 6, 2022 - /ENDURANCE SPORTSWIRE/ LAKEWOOD, CO - Outdoor Market Alliance (OMA), a collective of 25 independent sales and marketing agencies representing over 175 different brands in the outdoor, resort, run and bike markets in the Rockies region, is launching its first Summer Market Week, June 13th-17th. OMA will...

Press Releases

Trade Shows

June 6, 2022

Registration Open for 2022 Running USA Industry Conference presented by Race Roster

DENVER (June 6, 2022)/ENDURANCE SPORTSWIRE/ – Registration is now open for the 2023 Running USA Industry Conference presented by Race Roster. The 19th edition of the running industry’s leading education and networking event is set for February 10-12, 2023. For the first time ever, the conference will be held in Denver, Colo....

Press Releases

Running

Trade Shows

June 1, 2022

World Premiere of Born to Adapt Documentary During Run Show USA, Chicago

San Jose, CA (June 1, 2022) /ENDURANCE SPORTSWIRE/ - GO Sleeves, the company that introduced the world’s first and only kinesiology sleeve — a compression sleeve with built-in kinesiology strips, announced today that sponsored partner Zachary Friedley will speak at Run Show USA – Chicago: June 4-5, about about the...

Press Releases

Trade Shows

Triathlon

May 24, 2022

Debut of Run Show USA for North American Running Community Set to Begin

LONDON (May 24, 2022)/ENDURANCE SPORTSWIRE/ – Raccoon Events, the dynamic UK-based events business with extensive experience in organizing and executing consumer expos worldwide, is set to bring their popular National Run Show to North American audiences with the inaugural Run Show, Chicago on June 4-5 at the DES Convention Center in Rosemont,...

Press Releases

Running

Trade Shows