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

February 9, 2022

Adventure Racing World Series Oceania Champs Set For The Gold Coast

/ENDURANCE SPORTSWIRE/ -The venue for the Oceania Championship final of the Adventure Racing World Series has been announced as the Gold Coast, and the race will now be part of a 5 race series, following the news that Alpine Quest has joined the premier adventure racing series in the region....

Events

Press Releases

February 8, 2022

Marmot Continues Success with Ever-Expanding WarmCube® Collection to Now Include WarmCube Active Insulation

Rohnert Park, Calif. — Feb 8, 2022/ENDURANCE SPORTSWIRE/ - Marmot continues to innovate with its award-winning WarmCube insulation technology, adding an active line for fall 2022 focused on high-output cold-weather adventures. WarmCube Active technology is a revolutionary temperature-regulating technology that allows air to circulate in the jacket as you move,...

Press Releases

Products

February 8, 2022

Turning Up the Volume: Rock ‘n’ Roll Running Series Announces New Half Marathon Elite Series

TAMPA, Fla. (Feb. 8, 2022) /ENDURANCE SPORTSWIRE/ -The Rock ‘n’ Roll® Running Series today announced a new Rock ‘n’ Roll EliteTM half marathon series that will take place across eight North America Rock ‘n’ Roll Running Series events. Contested across the half marathon distances, each of the events will offer...

Events

Press Releases

Running

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