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

February 15, 2023

The 2022 American Criterium Cup administrator returns for 2023.

ENDURANCE SPORTSWIRE/ - "I'm excited to return to the ACC. Last year was a great start, and I look forward to working with and advocating for our teams and athletes participating in the series again. Working with a great group of Race Directors who are committed to the sport, and...

Business

Cycling

Events

Press Releases

February 15, 2023

The Great Run Company partners with Endurance Zone to launch ‘Great Run Rewards powered by Endurance Zone’

London, UK /ENDURANCE SPORTSWIRE/ - The Great Run Company (GRC), organisers of the nationwide AJ Bell Great Run Series, including the UKs biggest running event, the AJ Bell Great North Run, is proud to announce its partnership with Endurance Zone, the largest sports reward & engagement platform in the world....

Business

Events

Press Releases

Running

February 14, 2023

Kaite Morgan joins DMSE Sports as Communications Coordinator

BOSTON /ENDURANCE SPORTSWIRE/ - DMSE Sports has announced the hiring of Kaite Morgan who will take on the role of Communications Coordinator for the brand. Morgan will manage and support the overall communications strategy for DMSE, engaging its external audiences through social media, email marketing, and more. “Kaite joins our...

Business

Press Releases

February 14, 2023

KOO Taps OutsidePR as Public Relations Agency of Record to Inspire People to See the Unseen

Sausalito, CA (February 14, 2023) /ENDURANCE SPORTSWIRE/ – KOO Eyewear, the Italian brand of cutting edge eyewear, has partnered with industry leader OutsidePR to serve as the brand’s public relations agency of record for the North American and Australian regions. Established in 2017, KOO Eyewear is an innovative sportswear brand specializing...

Business

Cycling

Press Releases

Running

Triathlon