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

November 1, 2023

The Boston Run Show wins Best Consumer Show at TSNN Awards

/ENDURANCE SPORTSWIRE/ – Raccoon Media Group has seen success at this year’s Trade Show News Network (TSNN) Innovation Awards with The Boston Run Show taking home the award for The Best Consumer Show. The awards evening took place Saturday Oct 28th and honored the “Best of Innovation”. Global show organizers...

Awards

Press Releases

Running

Trade Shows

October 26, 2023

The Running Event and Switchback at TRE Partners with Outside, Inc.

PORTLAND, Maine (October 26, 2023)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, today announced Outside, Inc. (Outside)— the premier news publication for outdoor, sport, and gear enthusiasts—as an Official Media Partner of TRE 2023. “Outside is a go-to resource for so many within the...

Press Releases

Running

Sponsorship

Trade Shows

October 23, 2023

Iñigo San Millán, Coach Of Tour De France Winner, to Present Keynote At Endurance Exchange

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon today announced renowned physiologist, sports scientist and coach Iñigo San Millán will serve as keynote speaker for the fifth annual Endurance Exchange, USA Triathlon’s endurance sports industry conference scheduled for Jan. 4-7, 2024 in Charlotte, North Carolina. With live sessions presented by the endurance sports...

Press Releases

Trade Shows

Triathlon

October 12, 2023

USA Triathlon and USA Cycling Collaborate to Increase Educational Opportunities at Endurance Exchange 2024

Colorado Springs, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon announced its collaboration with USA Cycling to provide exceptional educational and networking opportunities at USA Triathlon’s upcoming Industry Conference, Endurance Exchange. This collaboration aims to unite the endurance sports community and encourage coaches and other endurance industry professionals to continue expanding their knowledge...

Cycling

Press Releases

Trade Shows

October 10, 2023

The Running Event Announces 2023 Keynote Speaker

PORTLAND, Maine (October 10, 2023) – The Running Event (TRE), North America’s premier specialty retail conference and trade show, today announced Melissa Gonzalez, Principal, MG2 and Founder, Lionesque Group, as the 2023 Keynote Speaker. Gonzalez will give her address, “Running Through Today’s Retail Landscape,” Tuesday, November 28 at 12:00 PM...

Press Releases

Running

Trade Shows

October 6, 2023

Finalists Announced for Darn Tough Vermont® Trail Sustainability Contest at US Trail Running Conference

October, 2023/ENDURANCE SPORTSWIRE/ – The US Trail Running Conference presented by Marathon Printing, has announced the three finalists for the Darn Tough Vermont ® Trail Sustainability Contest. The Contest is sponsored by the Vermont-based premium sock manufacturer who are seeking to reward innovative race directors who have made sustainability a...

Press Releases

Running

Trade Shows

October 5, 2023

Nomination Period Now Open for 2024 Running USA Industry Conference Awards

Oct. 5, 2023/ENDURANCE SPORTSWIRE/ – Nominations are now being accepted for Running USA’s 2024 Industry Awards, which will be presented at the 20th Industry Conference presented by haku in Orlando. The event will be held Jan. 31 – Feb. 2, 2024 at Disney’s Coronado Springs Resort. “We encourage anyone connected with...

Awards

Press Releases

Trade Shows

October 4, 2023

40th Anniversary Keynoter Announced

/ENDURANCE SPORTSWIRE/ - Road Race Management, Inc., organizer of the industry’s first national race directors’ meeting, will celebrate the meeting’s 40th anniversary this year by having Founder, Editor and Publisher Phil Stewart deliver the Keynote address at the MarathonGuide Keynote Dinner. In a running industry career spanning over 45 years,...

Business

Events

Press Releases

Running

Trade Shows