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

July 11, 2022

The Running Event Delivers Mentorship Opportunities for Specialty Retailers

PORTLAND, Maine (July 11, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier run and outdoor specialty conference and trade show, today announced new opportunities for connection and advancement among specialty retail professionals leading up to #TRE22 this November 29 to December 1 in Austin, TX. Currently with 50 members representing...

Press Releases

Running

Trade Shows

July 10, 2022

Silver Rush 50 Weekend Welcomes 1,300 Runners and Riders to Leadville

Leadville, Colo., (July 10, 2022) /ENDURANCE SPORTSWIRE/ - The Life Time Silver Rush 50 Run presented by La Sportiva and Stages Cycling Silver Rush 50 Mountain Bike race events, owned and produced by Life Time (NYSE: LTH), took place in a back-to-back format this weekend, bringing more than 1,300 runners...

Cycling

Events

Press Releases

Running

July 10, 2022

Life Time Crusher in the Tushar presented by The Creamery Celebrates Ten Years with New Course Record

Beaver, Utah /ENDURANCE SPORTSWIRE/ - The Crusher in the Tushar presented by The Creamery, a gravel event owned and produced by Life Time, welcomed a field of approximately 800 riders representing 37 states and eight countries to Utah’s Tushar Mountains outside of Beaver, Utah this past Saturday, July 9. Crusher in...

Cycling

Events

Press Releases

July 10, 2022

Justin Metzler (USA) And Danielle Lewis (USA) Claim Victories at the 2022 IRONMAN 70.3 Oregon Triathlon

SALEM. Ore. (July 10, 2022) /ENDURANCE SPORTSWIRE/ - Salem, Oregon's capital city and the Willamette Valley hosted the IRONMAN 70.3 Oregon triathlon on Sunday, July 10 where thousands of athletes, including professional and age-group athletes took to the region for the second edition of the event. The event saw Justin...

Events

Press Releases

Triathlon

July 8, 2022

Bahrain Victorious Takes Over Scorpions Franchise As SLT Teams 2022 Officially Launches

/ENDURANCE SPORTSWIRE/ – Bahrain Victorious have become the first franchise owners in SLT Teams with triathlon legend Chris McCormack managing the squad in Super League Triathlon’s 2022 Championship Series. McCormack will be up against a familiar roster of Team Managers this year following the successful debut of SLT teams in 2021,...

Business

Press Releases

Triathlon

July 8, 2022

Race Roster introduces enhancements to Digital Engagement Kits

London, ON (Fri, July 8, 2022) /ENDURANCE SPORTSWIRE/ - Race Roster recently introduced Digital Engagement Kits to the endurance event space, and so far, Race Roster users testing out this tool are seeing positive results. “We loved using Race Roster’s new Digital Engagement Kit at the 41st Annual Fair Oaks...

Business

Press Releases

July 8, 2022

XTERRA USA Championship Celebration July 16 in Avon, CO

July 8, 2022 /ENDURANCE SPORTSWIRE/ - A new course, new format, and free community concert are generating a lot of excitement for the XTERRA USA Championship off-road triathlons at Beaver Creek Resort with its accompanying outdoor festival at Nottingham Park in Avon, Colorado on July 15-16, 2022. Thousands of participants...

Events

Press Releases

Triathlon

July 8, 2022

Boilermaker 15K Hosts 25th PRRO Championship

UTICA, NY /ENDURANCE SPORTSWIRE/ - The PRRO Circuit will celebrate its 25th PRRO Championship presented by Boilermaker 15K on Sunday, July 10. The 45th Boilermaker will offer $65,100 in prize money, including $14,500 U.S. prize money. In addition, at the 2022 PRRO Championship, seven PRRO Circuit winners, listed below with...

Events

Press Releases

Running

July 7, 2022

Enduro Bearings Heads To Eurobike with Distributors NOW Company and COSMIC Sports to introduce two new component lines

Oakland, California (July 7, 2022) /ENDURANCE SPORTSWIRE/ - Enduro Bearings is looking forward to meeting with clients old and new at Eurobike next week, where they’ll work closely with their European distribution partners NOW Company and COSMIC Sports. The event will mark the European launch of Maxhit components, already available...

Cycling

Press Releases

Products

Trade Shows

Triathlon