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

October 8, 2024

Electrolit Unveils Zesty Lemon Lime Hydration Powders, Dropping Exclusively on Amazon

Houston, TX (October 8, 2024) /ENDURANCE SPORTSWIRE/ Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – unveils the launch of its all-new Lemon Lime flavor in conveniently compact and ready-to-mix electrolyte hydration powders, launching exclusively on Amazon with savings for October Prime Day (Oct 8-9)....

Business

Press Releases

Products

October 8, 2024

RunSignup Announces Strong Q3 2024 Performance

Moorestown, NJ – October 8, 2024 /ENDURANCE SPORTSWIRE/ RunSignup, the leading technology provider for endurance events, peer-to-peer fundraising, and ticketing, released its Q3 business update. RunSignup continues to demonstrate strong market indicators with impressive results for the third quarter of 2024. The employee-owned company experiences continued growth and leadership in...

Business

Press Releases

Products

October 7, 2024

Announcing Zwift’s Biggest Racing Update to Date: Zwift Racing Score

/ENDURANCE SPORTSWIRE/ Zwift, the global online fitness platform for cyclists, has officially launched Zwift Racing Score. Following recent public testing in the Zwift Labs Club, Zwift Racing Score will revolutionize racing by delivering more competitive, accessible and fairer racing. Zwift Racing Score is a new ranking system that reflects current...

Cycling

Events

Press Releases

Triathlon

October 7, 2024

The Northshore Half Marathon celebrates its 15th Anniversary

Mandeville, LA /ENDURANCE SPORTSWIRE/ This weekend the Northshore Half Marathon and 10 Miler celebrates its 15th Anniversary in gorgeous Fontainebleau State Park. The event known for its scenic course and amazing post-race party is set to be held on Sunday, October 13, 2024. This year's event has drawn a record number...

Events

Press Releases

Running

October 7, 2024

Colnago introduces Retrofitting, an innovative system for certifying the authenticity of vintage frames, opening up a world of new opportunities for Colnago bike owners.

Cambiago /ENDURANCE SPORTSWIRE/ In the world of cycling, the Colnago brand guarantees excellence, quality, and tradition. The legendary Italian company, founded in 1954, has written essential pages in the history of this sport, winning the hearts of professional cyclists and enthusiasts worldwide. Today, Colnago is ready to launch an ambitious...

Business

Cycling

Press Releases

Products

October 7, 2024

Portland Marathon Sells Out its 52nd Annual Event

PORTLAND, Ore. /ENDURANCE SPORTSWIRE/ The Portland Marathon presented by OHSU Health, one of the longest-running consecutive marathons in the state of Oregon, sold out its 52nd annual event with 9,000 registrations. The Portland Marathon presented by OHSU Health took place on Oct. 6, and offered four distances, a marathon, half...

Events

Press Releases

Running

October 6, 2024

Thousands Of Runners Hit the Streets of Speed City, USA For The 2024 Rock ‘N’ Roll Running Series San Jose

SAN JOSE, Calif. (Oct. 6, 2024) /ENDURANCE SPORTSWIRE/ - Thousands of participants took to the streets of Speed City, USA, nicknamed after the legendary San Jose State track teams of the 60s, to participate in the 19th edition of the Rock ‘n’ Roll® Running Series San Jose. The best-in-class running...

Events

Press Releases

Running

October 5, 2024

Action-Packed Showdown at Challenge Vieux Boucau – Hutchens and Davies Claim Victory

/ENDURANCE SPORTSWIRE/ - It was a fast day of racing at Challenge Vieux Boucau with a 1.9km swim in the marine lake, a 90km ride through the Landes pine forests, and a decisive run to finish, which gave Jack Hutchens (GBR) and Daisy Davies (GBR) a chance to claim victories...

Events

Press Releases

Triathlon

October 4, 2024

Enabled Tracking to Provide Live GPS Tracking for October 2024 Endurance Events

Front Royal, VA – October 2024 /ENDURANCE SPORTSWIRE/ - Enabled Tracking, the timing and tracking division of Adventure Enablers, is thrilled to introduce its innovative live GPS tracking services. These advanced solutions are designed to enhance both past and upcoming endurance events throughout the month. Whether participants are navigating rugged...

Business

Events

Press Releases

October 4, 2024

The BMC Rock Cobbler Partners with Movemint for 2025

BAKERSFIELD, CALIFORNIA [10/04/24] /ENDURANCE SPORTSWIRE/ - The Rock Cobbler joins the Movemint event platform for the 2025 edition of the race. This new partnership ensures that the event can continue to meet the evolving needs of its community with a host of new features. To bring new energy to the...

Business

Cycling

Events

Press Releases