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

March 1, 2023

deboer wetsuits Unveils FJORD 3.0

GRAN CANARIA, SPAIN /ENDURANCE SPORTSWIRE/ – On March 1st, deboer wetsuits proudly introduces the FJORD 3.0, the pinnacle of wetsuit innovation and performance for triathletes. The FJORD 3.0 integrates two years of research, development, and testing to create a wetsuit that is faster than ever before. The proprietary X-Skin neoprene technology used...

Press Releases

Products

Triathlon

March 1, 2023

Blue Streak Time Trial Celebrates 25 Years

WRIGHT- PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ – Today marks the start of registration for the 2023 Blue Streak Time Trial while also commemorating the 25th anniversary of the annual event. Time trials will occur on the second Tuesday of each month from April to October. The first time trial...

Cycling

Events

Press Releases

March 1, 2023

Injinji Launches New Run Series

San Diego, Calif. (March 1, 2023) /ENDURANCE SPORTSWIRE/ – Injinji, the innovator of the patented five-toe Performance Toesock™, is revamping its Run series, announcing the launch of its new Run Lightweight No-Show, Run Lightweight Mini-Crew, Run Original Weight No-Show, and Run Original Weight Mini-Crew for Spring 2023. This collection is designed...

Press Releases

Products

Running

Triathlon

February 28, 2023

CamelBak® Launches New and Redesigned Run Hydration Vest Collection and All-Terrain Running Challenge

PETALUMA, Calif. (Feb. 28, 2023) /ENDURANCE SPORTSWIRE/ - CamelBak®, the global leader in award-winning personal hydration products, today unveils a new line of running hydration vests that include the all-new Zephyr™ Pro Vest and Trail Run™ Vest, as well as the fully redesigned Circuit™ Vest, all optimized to keep runners...

Press Releases

Products

Running

Triathlon

February 28, 2023

World Champion Triathlete Holly Lawrence Partners with Fuelin

San Francisco, CA /ENDURANCE SPORTSWIRE/ – Nutrition coaching app, Fuelin, announced today that it has partnered with professional triathlete and 2016 IRONMAN 70.3 World Champion, Holly Lawrence. Fuelin will be providing Lawrence with expert performance nutrition coaching for training and racing via a first of its kind nutrition coaching app. Fuelin’s app...

Press Releases

Sponsorship

Triathlon

February 28, 2023

2023 Kaiser Permanente Napa Valley Marathon & Half Marathon at Full Capacity as Runners Gear Up for Race Weekend

Napa, California /ENDURANCE SPORTSWIRE/ – The 2023 Kaiser Permanente Napa Valley Marathon & Half Marathon has officially sold out, with runners from around the world gearing up for the highly anticipated race. The event, scheduled for March 5th, has drawn runners of all abilities who are ready to tackle the scenic...

Events

Press Releases

Running

February 28, 2023

PTO Asian Open 100km Race For Experienced Amateurs Sells Out

Singapore /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced that general registrations for its PTO Asian Open 100km race have sold out this weekend, having only gone on sale at 12pm Singapore Time on Thursday 23 February. The places were snapped up by experienced amateur triathletes from Singapore as well...

Events

Press Releases

Triathlon

February 28, 2023

Electrolit Hydration Beverage Announces Launch of New Blue Raspberry Flavor

CERRITOS, Calif. (February 28, 2023) /ENDURANCE SPORTSWIRE/ – Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – announced today the launch of their newest favor, Blue Raspberry. This exciting new flavor is the 14th addition to the global brand’s expansive line of hydration beverages. “Blue Raspberry...

Press Releases

Products

February 28, 2023

Tucson Bicycle Classic brings pros, amateurs together for 3 days of racing

February 28, 2023, Tucson, AZ /ENDURANCE SPORTSWIRE/ – The 35th annual Tucson Bicycle Classic p/b The Meteor returns March 3-5, bringing together pros and amateurs from all over the country and many foreign nations for 3 days of racing across the greater Tucson area. This year's race will begin in Vail on...

Cycling

Events

Press Releases