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

October 26, 2023

Enduro Bearings Announces Partnership with Cervelo Orange Living Cyclocross Team for the 2023/24 Season

Oakland, California (October 26, 2023) /ENDURANCE SPORTSWIRE/ - With a global group of ambassadors that includes athletes, mechanics and teams, Enduro Bearings is excited to add the Cervélo Orange Living Team to their roster. The Cervélo Orange Living Cyclocross program focuses on the future of the sport with a talented...

Business

Cycling

Press Releases

Products

Sponsorship

October 26, 2023

RunSignup Timer Survey 2023 Now Open

Moorestown, NJ— October 26, 2023 /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for endurance events in the United States, launches its 2023 Timer Survey. This annual industry research survey, now in its 5th year, is the only research available that is specifically tailored to timers and offers...

Business

Events

Press Releases

Products

Running

Studies

Triathlon

October 25, 2023

Kitman Labs Launches ‘The Football Intelligence Platform’ For Premier League Academies

London, England and Menlo Park, CA (Oct. 25, 2023)/ENDURANCE SPORTSWIRE/ – Kitman Labs, the sports technology and analytics company setting the industry standard for how elite sports organisations use data, today announced a new partnership with the Premier League. The partnership will provide all Premier League club academies with a centralised,...

Business

Press Releases

Products

October 25, 2023

BibRave Expands Marketing Services Partnership with Race Day Events

Fitchburg, WI /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, is excited to announce an expanded partnership with Race Day Events, the Midwest's event production leader to provide comprehensive marketing services for the organization’s extensive portfolio of running, cycling, and triathlon events. BibRave will manage essential aspects of...

Business

Events

Press Releases

October 25, 2023

haku and Chicago Event Management Ink Multi-Year Partnership Extension

/ENDURANCE SPORTSWIRE/ - With events that include the Bank of America Chicago Distance Series comprised of the Chicago Marathon, Shamrock Shuffle, and Chicago 13.1 plus the BTN Big 10K and Race Management Program, Chicago Event Management has leveraged haku's best-in-class technology to deliver unparalleled experiences for participants, partners, spectators, and...

Business

Events

Press Releases

Running