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

May 17, 2022

CampgroundViews.com Offers a Close Look at 16,000 U.S. Campgrounds to Make Trip Planning Easy

LARAMIE, Wyo. (May 17, 2022)/ENDURANCE SPORTSWIRE/ – With over 61 million U.S. households expected to camp this summer according to the KOA 2022 Camping Report, CampgroundViews.com, the company committed to taking the guesswork out of campsite selection, is offering campers unprecedented access to 16,000 U.S. campgrounds to make trip planning easy for...

Press Releases

Products

May 16, 2022

Showcased

The Running Event to Launch a New Space for Outdoor Specialty Retailers and Brands at 2022 Trade Show

PORTLAND, Maine (May 16, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier run specialty conference and trade show, today announced it is launching Switchback at TRE, a new space that will unite specialty retailers and brands this November 29 to December 1 in the Austin Convention Center. A dedicated area...

Press Releases

Running

Trade Shows

May 16, 2022

World Class Cyclists and Triathletes Chosen by Spirig And Matthews to Deliver Them Sub8 Performances

Sydney, Australia 16 May 2022/ENDURANCE SPORTSWIRE/ – The Pho3nix Foundation today announced the bike pacing teams selected by Nicola Spirig and Kat Matthews for the Pho3nix Sub8 Project, Powered by Zwift. To go faster than eight hours over the full distance of triathlon and overcome physical and mental barriers never before...

Cycling

Events

Press Releases

Triathlon

May 16, 2022

Run Tucson Announces Coveted 2022 Gabe Zimmerman Triple Crown Series Medallion

/ENDURANCE SPORTSWIRE/ – The artwork for the coveted 2022 Gabe Zimmerman Triple Crown medallion has been released and registration for the three-race series is now open. Developed by Ashworth Awards and Run Tucson, the coaster features elements of the Sonoran Desert, the City of Tucson, and the unique aspects of Tucson’s popular...

Events

Press Releases

Running

May 15, 2022

Thousands of Participants Took to the Streets and Boardwalk of Atlantic City for The Inaugural Rock ‘n’ Roll Running Series Atlantic City

ATLANTIC CITY, N.J. (May 15, 2022) /ENDURANCE SPORTSWIRE/ – Thousands of runners and walkers alike took to the streets and the famous Atlantic City boardwalk this weekend for the inaugural Rock ‘n’ Roll Running Series Atlantic City. Bringing the Fun to the Run® with music and community support through the event, participants...

Events

Press Releases

Running

May 14, 2022

BibBoards Patent: The One and Only Fastening Clips

/ENDURANCE SPORTSWIRE/ - May 14, 2022 BibBoards are One-of-A-Kind BibBoards are the only solution to replacing your safety pins on race day. And now, Biboards are the only patented and trademarked product of their kind. When you order your BibBoards or partner with the company you can be sure that...

Business

Cycling

Press Releases

Products

Running

Trade Shows

Triathlon

May 13, 2022

Ultimate Direction Announces its 2022 Athlete Team Roster

BOULDER – May 13, 2022 /ENDURANCE SPORTSWIRE/ - Ultimate Direction, creator of innovative products that help support self-propelled athletes at all stages of skill find their stride and improve performance, is pleased to announce its 2022 athlete team roster. Celebrating the unique pursuits and interests in the sport of running...

Press Releases

Running

May 13, 2022

Challenge Family Announces Challenge Montpellier

12 May 2022. /ENDURANCE SPORTSWIRE/ - There is a new long distance race on the race calendar with today’s announcement of Challenge Montpellier on 7 May 2023. The latest member of the Challenge Family will take in 226km of some of the most striking rural and urban landscapes of southern...

Events

Press Releases

Triathlon