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 (11)
) 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 500, 10

September 4, 2024

The Travel Yogi Appoints Darby Communications as Communications Agency of Record

Long Beach, CA – September, 2024 /ENDURANCE SPORTSWIRE/ – The Travel Yogi, the first company to blend yoga and wellness with first class adventure travel, proudly announces its partnership with Darby Communications, a PR and digital marketing agency specializing in the outdoor and active lifestyle markets. Effective immediately, Darby Communications will...

Business

Press Releases

September 4, 2024

CHAPTER2 partners with BikeInsure for USA Bike Insurance Solution

Bentonville, AR. – September 4, 2024 /ENDURANCE SPORTSWIRE/ – CHAPTER2, the boutique bike brand of New Zealand, has selected BikeInsure as the company's Official USA Bicycle Insurance partner. BikeInsure offers affordable, opt-in bicycle insurance to protect CHAPTER2 customer’s bicycles against the riding, transit, and theft risks that all bike owners...

Business

Cycling

Press Releases

Products

September 4, 2024

RBC GranFondo Whistler: Celebrating a 15 Year Legacy of Building Cycling Community

Vancouver/Whistler /ENDURANCE SPORTSWIRE/ – Celebrating its 15th anniversary on September 7, 2024, the RBC GranFondo Whistler draws around 10,000 cyclists and spectators over a range of distances and has inspired countless stories of motivation, camaraderie, and community spirit since 2010. As we approach the highly anticipated RBC GranFondo Whistler on...

Business

Cycling

Events

Press Releases

September 3, 2024

360 Hoops to Launch Proprietary Three-in-One Basketball Product This Fall, Transforming Youth Sports

SANFORD, Fla., September 3, 2024/ENDURANCE SPORTSWIRE/ – 360 Hoops, a sports innovation company with dual patents for its three-in-one basketball hoop and 3v3v3 gameplay format, will make its debut this fall in Texas. The unique three-in-one basket, combined with a 3v3v3 'king of the court' style gameplay, offers an unparalleled...

Business

Press Releases

Products

September 3, 2024

Showcased

Front Pack Launches the First Social Network for Endurance Athletes

AUSTIN, TX - September 3, 2024 /ENDURANCE SPORTSWIRE/ - Front Pack, the first social network designed for both avid and casual endurance athletes is now available at www.frontpacksports.com and through the Apple App Store and on Google Play. Built on the values of authenticity, fostering meaningful connections, mutual accountability, and...

Business

Cycling

Press Releases

Products

Running

Triathlon

August 30, 2024

Outside Interactive, Inc. Acquires MapMyFitness Outdoor Fitness Tracking Applications from Under Armour, Inc.

BOULDER, CO – August 30, 2024 /ENDURANCE SPORTSWIRE/ - Outside Interactive, Inc., the world’s leading creator of outdoor content, services, events, and experiences, today announced the acquisition of MapMyFitness from Under Armour, Inc. MapMyFitness is a fitness tracking application that allows users to track their activities using built-in GPS on...

Business

Press Releases