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

April 4, 2022

2022 Carmel Marathon Weekend Expects Largest, Fastest Field in 12-Year History

CARMEL, Ind. (April 4, 2022) /ENDURANCE SPORTSWIRE/ – Organizers for the 2022 Carmel Marathon Weekend are planning for more than 3,500 participants on Saturday, April 9, 2022, the largest field in its 12-year history. For the second year in a row, the race has sold out its full marathon event...

Events

Press Releases

Running

April 4, 2022

Sage Titanium Bikes Introduces a Hardtail for Going Big

Beaverton, Ore. (April 4th, 2022) /ENDURANCE SPORTSWIRE/ – Sage Titanium Bikes, the boutique manufacturer of titanium bikes that counts Beaverton, Ore. as both its physical and spiritual home, is proud to release a wholescale overhaul of its hardtail mountain bike, Flow Motion. The most rugged of Sage’s mountain bikes, this...

Cycling

Press Releases

Products

April 4, 2022

USA Cycling Signs Look Cycle and Corima for Multi-Year Track Sprint Equipment Partnership

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – LOOK and CORIMA are pleased to announce a multi-year technical partnership with USA Cycling and its USA Track Sprint Program, as the American Federation puts renewed focus into the historically successful program. Through this new partnership, USA Cycling will leverage the storied French brand’s decades...

Cycling

Press Releases

Sponsorship

April 4, 2022

SFuels Launches Race+ Gel Powder At 2022 IRONMAN World Championships from May 3 – 7, 2022

Raleigh, North Carolina /ENDURANCE SPORTSWIRE/ - SFuels – one of the leaders in consumer products featuring innovative, right-time right-fuel nutrition for sport, work and life – announces the launch of Race+ Gel and Race+ Bullets as they gear up for the 2022 IRONMAN World Championships in St. George, Utah from...

Events

Press Releases

Products

Triathlon

April 3, 2022

Jackson Laundry (CAN) And Taylor Knibb (USA) Claim Victories at Athletic Brewing IRONMAN 70.3 Oceanside Triathlon to Kick Off The 2022 North American IRONMAN 70.3 Race Season

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE - Oceanside, California and Marine Corps Base Camp Pendleton once again played host to the Athletic Brewing IRONMAN® 70.3® Oceanside triathlon on Saturday, April 2 kicking off the 2022 North American IRONMAN 70.3 schedule. With many of triathlon’s best on hand, the event saw Jackson Laundry...

Events

Press Releases

Triathlon