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

February 8, 2022

Alchemy Bikes Creates Certified Service Center Network with Beeline Connect

Denver, Colorado (February 8, 2022) /ENDURANCE SPORTSWIRE/ - In an innovative effort to improve service options on their direct-to- rider bikes, while also advancing its commitment to bike shops, Alchemy Bikes is excited to announce it is expanding its relationship with Beeline Connect to establish a nationwide network of Certified Alchemy ...

Business

Cycling

Press Releases

Triathlon

February 8, 2022

Showcased

UNDRBUDR Continues Partnership with Gran Fondo National Series as Exclusive Chamois Cream Partner Through 2022

Montclair, NJ, February 8, 2022 /ENDURANCE SPORTSWIRE/ - UNDRBUDR, developer of high performance, nature-inspired skin care and recovery products, today announced an exclusive sponsoring partnership with the Gran Fondo National Series (GFNS) to continue throughout 2022.  This year the relationship will expand to highlight the company's full line of skin...

Press Releases

Sponsorship

February 8, 2022

F2C Nutrition Named Official Nutrition Partner of the Somersault Multisport Series

/ENDURANCE SPORTSWIRE/ - F2C Nutrition Inc. has partnered with the Somersault Multisport Series. F2C Nutrition, known for its clean, athlete-focused, science driven premium sports nutrition products and internationally recognized for quality and innovation, will support Eastern Ontario’s largest multisport series with race fuel, electrolytes and recovery beverages. “The Somersault Multisport Series...

Events

Press Releases

Running

Sponsorship

Triathlon

February 8, 2022

RunSignup Introduces TicketSignup, a Free Ticket Event Platform

/ENDURANCE SPORTSWIRE/ -RunSignup is proud to announce TicketSignup, an offering that provides event directors with an intuitive and free event ticketing option that works for simple, complex, and multi-day events. TicketSignup provides event directors with all the tools they need for a successful event, including free email marketing, free websites,...

Business

Press Releases

Products

February 7, 2022

Runners celebrate return of Surf City Marathon and Half Marathon

HUNTINGTON BEACH, CALIFORNIA – February 7, 2022 /ENDURANCE SPORTSWIRE/ - Winter storm Landon dumped hundreds of inches of snow throughout the Midwest this week, along with burying the Southeastern United States in ice. As for the more than 11,000 runners from 47 states and 14 countries who participated in the...

Events

Press Releases

Running