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 (21083)
) 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 110, 10

September 8, 2023

The Boston Run Show is shortlisted for the 2023 TSNN Innovation Awards

/ENDURANCE SPORTSWIRE/ – Raccoon Media Group has been shortlisted for this year’s Trade Show News Network (TSNN) Innovation Awards. The Boston Run Show has been recognized and is shortlisted as a finalist for the Consumer Shows category. The awards program will celebrate and honor the “Best of Innovation” – shows...

Awards

Press Releases

Running

Trade Shows

September 1, 2023

Boulder, Colo. Named An RRCA Runner Friendly Community

BOULDER, Colo. /ENDURANCE SPORTSWIRE/ – Last week, the Road Runners Club of America (RRCA) announced that Boulder, Colo. was one of two new cities that have been added to their list of Runner Friendly Communities®. Boulder’s nomination for the selective designation was spearheaded by Boulderthon, the fastest growing running event in...

Awards

Press Releases

Running

August 30, 2023

GSI Outdoors and Buck Knives Partner to Celebrate Outdoor Cooking with Exclusive Prize Pack Giveaway

Spokane, Wash. — August 30, 2023 /ENDURANCE SPORTSWIRE/ - GSI Outdoors and Buck Knives are thrilled to announce an exciting partnership that celebrates the joy of cooking in the great outdoors. In collaboration with renowned outdoor cooking chefs, Adam and Jessica Cheek of @adam.northwest, the brands are set to launch...

Awards

Business

Events

OSW Syndicated

Press Releases

Products

Sponsorship

August 7, 2023

Thömus Bikes Head to Glasgow for UCI MTB World Championships with Three Favorites

Santa Monica, California (August 7th, 2023) /ENDURANCE SPORTSWIRE/ -  Thōmas Maxon Team, current UCI team points leaders are ready to head to Glasgow with 4th placed UCI ranked Lars Forster, winner in Leogang, 19th placed Mathias Flückiger who took 2nd in Val De Sole, Vital Albin, U23 rider Luke Weidmann,...

Awards

Business

Cycling

Events

Press Releases

Products

Sponsorship

Triathlon

August 3, 2023

$40,000 up for grabs in The 2023 CNO Financial Indianapolis Monumental Marathon & Half Marathon Elite Fields

INDIANAPOLIS /ENDURANCE SPORTSWIRE/ – Elite athletes from near and far will be chasing an Olympic Trials qualifying time to secure their trip to the 2024 U.S. Olympic Team Trials - Marathon, scheduled to take place in Orlando, FL on February 3, 2024. Beyond Monumental, the 501(c)3 non-profit responsible for the CNO...

Awards

Events

Press Releases

Running

August 1, 2023

Deadline Extended for Photographers and Filmmakers to Apply for Inaugural Outside Awards

Boulder, Colo. (August 1, 2023) /ENDURANCE SPORTSWIRE/ - Outside Interactive, Inc., the world’s leading creator of active lifestyle content, services, events, and experiences, announced today that due to increasing demand and entries, the inaugural Outside Awards deadline has been extended by one week and is now August 6, 2023. The...

Awards

Business

Press Releases

July 27, 2023

The Running Event Announces the Best Running Stores of 2023

PORTLAND, Maine (July 27, 2023)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, today announced the winners of its 2023 Best Running Stores awards program. The winning retailers will be celebrated November 30 at the 2023 Industry Awards Dinner during The Running Event in Austin,...

Awards

Press Releases

Running

Trade Shows

June 21, 2023

Deadline Approaching for Photographers and Filmmakers to Apply for Inaugural Outside Awards

Boulder, Colo. ( June 21, 2023) /ENDURANCE SPORTSWIRE/ - The inaugural Outside Awards deadline is fast approaching on July 31, 2023 and Outside Interactive, Inc., the world’s leading creator of active lifestyle content, services, events, and experiences, encourages the next generation of filmmakers and photographers to enter the new winter-focused...

Awards

Press Releases

June 20, 2023

Denver Colfax Marathon Awards Over $100,000 to Colorado Charities and Schools

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon concluded its 2023 marathon season by giving more than $100,000 to organizations within the Colorado community. The marathon awarded 75 checks this past week to local charities and schools at its annual awards celebration in Denver. “We are extremely proud to...

Awards

Business

Events

Giving

Press Releases

Running

Sponsorship

June 15, 2023

Annual Crown City Classic 4th of July Run Celebrates 50 Years Running

/ENDURANCE SPORTSWIRE/ - Celebrating its 50th year running, Coronado's annual 4th of July run returns with a remarkable display of consistency. The beloved event, renowned as one of the finest 4th of July running events in the country, invites runners of all ages and abilities to participate in a variety...

Awards

Events

Press Releases

Running