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

March 9, 2022

Challenge Family Partner with RemoteRacing

/ENDURANCE SPORTSWIRE/ - The partnership will allow athletes anywhere in the world to compete against those racing at Challenge Taiwan, The Championship, DATEV Challenge Roth powered by hep, and Challenge Almere-Amsterdam as though they were there with them. RemoteRacing creates a fair and level playing field for remote athletes with...

Press Releases

Sponsorship

Triathlon

March 9, 2022

Showcased

Kinetic Multisports Hires Amos Digital Marketing to Broaden Awareness for Its Poconos Triathlon Festival

/ENDURANCE SPORTSWIRE/ - The leading triathlon event production company in the Mid-Atlantic has opened registrations for the second annual Poconos Triathlon Festival. This June 10th - 12th, 2022 triathlon festival is a great racing vacation opportunity for athletes in New York City and the North East region. About Kinetic Multisports...

Press Releases

Triathlon

March 9, 2022

Velo Saddles Releases Two New Saddles Commemorating the Chinese Zodiac – The Year of the Tiger

Velo introduced the first Chinese Zodiac saddle in 2015 with the Year of the Sheep. Since then, Velo has continued to release limited edition Zodiac Saddles every year representing the current animal based on the lunar calendar. The series has included the sheep/goat, monkey, rooster, dog, boar/pig, mouse, and the...

Cycling

Press Releases

Products

March 9, 2022

Bikerumor promotes Zach Overholt to Editor in Chief

MARCH 9, 2022 | LOS ANGELES, CALIF. /ENDURANCE SPORTSWIRE/ - Bikerumor, a Lola Digital Media publication, is proud to announce new editorial leadership with the promotion of Zach Overholt to Editor in Chief (EIC). Overholt replaces Tyler Benedict, who founded Bikerumor in 2008. The publication covers the cutting-edge of bike...

Business

Cycling

Press Releases

March 9, 2022

A New All-Natural Recovery Cream from GO Sleeves

San Jose, CA (March 9, 2022)/ENDURANCE SPORTSWIRE/ - GO Sleeves, the company that introduced the world’s first and only kinesiology sleeve — a compression sleeve with built-in kinesiology strips, announced today a new product release: K-Recover Cream by GO Sleeves® – the K is for kinesiology. This fast-acting, all-natural therapeutic topical...

Press Releases

Products

Running

Triathlon

March 8, 2022

Showcased

100% Names New Global Eyewear and Snow Team to Support The Companies Accelerated Growth and New Category Expansion

SAN DIEGO, Calif. – March 8, 2022/ENDURANCE SPORTSWIRE/ - 100%®, the San Diego-based sports performance brand has announced the appointment of a new leadership team to support the company’s accelerated growth in eyewear, in addition to launching the company's first collection of snow products. Gwen van Lingen has joined 100%...

Business

Cycling

Press Releases

Running

Triathlon