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

July 29, 2022

BikeExchange / Kitzuma Cycling Logistics Merger Proving Highly Successful

Asheville, North Carolina (July 28, 2022) /ENDURANCE SPORTSWIRE/ - After joining forces in December, two rising industry disrupters – Kitzuma Cycling Logistics, offering fully-assembled bike deliveries nationwide, and BikeExchange, an online storefront for retailers, manufacturers and consumers across the country – continue to change the way bikes are bought, sold and...

Business

Cycling

Press Releases

Products

Triathlon

July 29, 2022

XTERRA Returns to Shelby County, AL in May, 2023

July 29, 2022/ENDURANCE SPORTSWIRE/ – XTERRA will return for its 16th year at Oak Mountain State Park in Shelby County, Alabama with a family-friendly festival featuring live music, beer gardens, food trucks, trail runs, mountain bike races, and off-road triathlons for pros and amateurs on May 18-21, 2023. The jam-packed weekend...

Events

Press Releases

Triathlon

July 28, 2022

Denver Colfax Marathon’s Newest Race Sells Out In 13 hours

Denver /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon is offering runners in Colorado an opportunity of a lifetime: to run a 5K on the runway at one of the busiest airports in the world. "This will be an incredible race for our runners in so many ways," said Andrea Dowdy,...

Business

Events

Press Releases

Running

Sponsorship

July 28, 2022

2023 VinFast IRONMAN World Championship to Hold Dedicated Women’s and Men’s Race Days as Two-Day Format Continues in Kailua-Kona, Hawai`i for 2023

TAMPA, Fla. (July 28, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN, in collaboration with local and state officials in Hawai`i, announced today that the 2023 VinFast IRONMAN® World Championship triathlon will continue with a two-day format in Kailua-Kona, Hawai`i on October 12 & 14. This year, for the first time in the 40-plus year...

Events

Press Releases

Triathlon

July 28, 2022

Sydney Marathon Announced as An Abbott World Marathon Majors Candidate Race

(Sydney, 6am AEST, 28 July 2022) /ENDURANCE SPORTSWIRE/ - The Blackmores Sydney Marathon has officially been announced as a candidate race for the Abbott World Marathon Majors (AbbottWMM) - the first marathon in Oceania to be nominated. The announcement marks the commencement of a multi-year evaluation process by AbbottWMM. To...

Events

Press Releases

Running

July 28, 2022

Lizard Skins Launches New Monitor Glove, The 3 SZN

American Fork, Utah (July 28, 2022) /ENDURANCE SPORTSWIRE/ - Lizard Skins, a leader in grips and handlebar tape, knows a lot about a rider’s contact points, and their renowned Monitor line of gloves has been providing comfort and performance in the hands, perhaps the most important contact point, for years....

Cycling

Press Releases

Products

Triathlon

July 28, 2022

Challenge Family Partners with TrainingPeaks

/ENDURANCE SPORTSWIRE/ - Challenge Family and TrainingPeaks today announced a global partnership to help athletes of all abilities achieve their peak race condition for Challenge Family events around the world. The partnership further highlights Challenge Family’s commitment to the athlete journey throughout the year, from registration to race day. TrainingPeaks...

Press Releases

Sponsorship

Triathlon

July 28, 2022

Nutrition Coaching App, Fuelin, Announces Integration with TrainingPeaks

(San Francisco, CA)/ENDURANCE SPORTSWIRE/ – Fuelin announced today the integration of its nutrition coaching app with sports technology platform, TrainingPeaks. Fuelin’s mission is to make personalized nutrition coaching available to all athletes and coaches at an affordable price point. Nutrition is a key pillar to performance in endurance training and racing,...

Cycling

Press Releases

Products

Running

Triathlon

July 28, 2022

Showcased

ElliptiGO® Launches Virtual Ride & Fundraiser and Limited-Edition Bikes Benefiting Stand Up To Cancer®

SAN DIEGO, Calif. /ENDURANCE SPORTSWIRE/ – ElliptiGO, the world leader and pioneer of both elliptical and stand up cycling, is rallying riders across the globe to make miles into meaningful contributions for Stand Up To Cancer® (SU2C). The ElliptiGO Virtual Stand Up & Ride Fundraiser to benefit Stand Up To Cancer...

Cycling

Events

Giving

Press Releases