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 (21085)
) 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 1610, 10

June 23, 2022

Olympian Emma Coburn and The Elk Run 5k Choose BibBoards

Customized BibBoards made an appearance at Olympian Emma Coburn’s Elk 5K. The middle-distance runner loves the reusability and functionality of BibBoards. Race Coordinators like Coburn love that custom BibBoards keep their race’s logo on a piece of quality equipment for years to come. Emma Coburn and the ELK 5k Emma...

Cycling

Press Releases

Products

Running

Sponsorship

Trade Shows

June 23, 2022

Climategames launches to empower brands and millions of people to fight climate change through sport

/ENDURANCE SPORTSWIRE/ – Forward-thinking Climategames has launched its long-awaited full App and Web platform this June, which directly links physical activity with climate change. The London-based tech start-up has already allowed thousands of people to make a climate impact and build a thriving eco-system of business, brands, clubs, and event organisers. This...

Cycling

Press Releases

Products

Running

June 21, 2022

Tourism Grant Helps CampgroundViews.com Bring Virtual Site Tours to Arizona

LARAMIE, Wyo. (June 21, 2022) /ENDURANCE SPORTSWIRE/ - CampgroundViews.com, the company committed to taking the guesswork out of campsite selection, is developing virtual tours of up to 250 campgrounds in Arizona to make trip planning easy for RV and tent campers. With CampgroundViews.com’s proprietary 360-degree virtual tours and searchable database,...

Press Releases

Products

June 17, 2022

NFL Star, Micah Parsons, Huddles Up to be an Ambassador for NOCCO BCAA

LOS ANGELES/ENDURANCE SPORTSWIRE/ -- NOCCO – the leading no carb, branched chain amino acids (BCAA) beverage company – continues to expand their already impressive ambassador program with legendary Dallas Cowboys linebacker Micah Parsons. “Micah is hungry and electric; a perfect fit for our ambassador program,” said Ben Jones, CEO, NOCCO USA. “We...

Press Releases

Products

Sponsorship