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 (22)
) 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 1110, 10

February 1, 2022

Rock ‘N’ Roll Running Series Las Vegas Partners with Resorts World Las Vegas To Bring the Health and Fitness Expo to The Strip

LAS VEGAS, Nev. (Feb. 1, 2022) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series Las Vegas is going all in on new race weekend experiences including moving the three-day Health & Fitness Expo to the Strip at Resorts World Las Vegas, which also signed on as the expo’s presenting...

Press Releases

Running

Sponsorship

February 1, 2022

Cedars-Sinai Kerlan-Jobe Institute Announces New Marathon Partnerships

SOUTHERN CALIFORNIA  – February 1, 2022 /ENDURANCE SPORTSWIRE/ - Cedars-Sinai Kerlan-Jobe Institute, a world leader in the diagnosis, treatment and prevention of sports-related injuries and illnesses, today announced a new multi-year partnership with the Surf City Marathon and Long Beach Marathon as the official Official Orthopaedic & Sports Medicine Partner...

Events

Press Releases

Running

Sponsorship

February 1, 2022

Suarez Cycling Apparel Announced as Title Sponsor of Gran Fondo National Series

(Gettysburg, PA – February 1, 2022)  /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series today announced that Suarez Cycling Apparel will be the title sponsor of the Series for the next two years. The Colombian apparel brand will supply custom winner’s cycling kits for age-group champions at all Series events, a commemorative...

Cycling

Press Releases

Sponsorship

February 1, 2022

F2C Nutrition Official Nutrition Partner of the Okanagan Granfondo and the Okanagan Graveller

/ENDURANCE SPORTSWIRE/ - F2C Nutrition Inc. is proud to be the official nutrition partner for the Okanagan Granfondo and the Okanagan Graveller cycling events. F2C Nutrition, known for its clean, athlete-focused, science driven premium sports nutrition products and internationally recognized for quality and innovation, will support both events with race fuel,...

Cycling

Press Releases

Sponsorship

January 27, 2022

deboer wetsuits introduces the deboer ProAm Team

Stamford, CT, Release: January 27, 2022 /ENDURANCE SPORTSWIRE/ - deboer wetsuits is proud to introduce the deboer ProAm Team.  The deboer ProAm Team allows professional triathletes (Pro) as well as amateurs (Am) to share more than the course – ‘it's one thing to race alongside your favourite triathletes, it's another to...

Business

Press Releases

Sponsorship

Triathlon

January 27, 2022

Mana Signs Marquee IRONMAN For Argon Bikes

/ENDURANCE SPORTSWIRE/ - MANA Sports & Entertainment Group are proud to announce MANA athlete Joe Skipper has signed on to ride Argon18 bicycles. The British Ironman champion will be riding the E-119 Tri+ Disc with two Ironman World Championship races on completely different courses in his sights for 2022. He...

Press Releases

Sponsorship