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 (16)
) 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 640, 10

June 26, 2024

Chargel Continues On-Site Samplings and Sponsorships at California’s Truckee Tahoe Gravel

IRVINE, Calif. (June 26, 2024)/ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy with zero caffeine, today announced it will be sampling its half drink, half snack, energy source at the 2024 Truckee Tahoe Gravel. Running from June 28-29 in Truckee,...

Business

Cycling

Events

Giving

Press Releases

Products

Sponsorship

Wire Syndication

June 26, 2024

Natural Grocers Cycling Hosts Masters and Junior State Criterium Championships in Littleton, Colorado: June 29, 2024

LAKEWOOD, Colo., June 26, 2024 /ENDURANCE SPORTSWIRE/ - Natural Grocers Cycling (with the support of their title sponsor, Natural Grocers by Vitamin Cottage®) is proud to host the 2024 Colorado State Criterium Championships for Masters and Juniors on June 29, at the Douglas County EVOC Track. It is also part...

Cycling

Events

Press Releases

Sponsorship

June 25, 2024

Project Mayhem CX Announces Inaugural Cyclocross Race Series in Connecticut

Connecticut, USA /ENDURANCE SPORTSWIRE/ - PMCX (Project Mayhem CX) is thrilled to announce the launch of its inaugural cyclocross race series, set to kick off this September. This new series aims to deliver a fun and exciting regional cyclocross experience that is inclusive and welcoming to all racers, regardless of...

Cycling

Events

Press Releases

Sponsorship

June 25, 2024

Battle Of The Brits: Charles-Barclay Leads Strong British Line Up For London T100 Triathlon

London, UK/ENDURANCE SPORTSWIRE/ – T100 series leader Lucy Charles-Barclay will get the chance to win her first T100 race on home soil, as the Professional Triathletes Organisation (PTO) and World Triathlon announced the 15 contracted female athletes taking the start line for the London T100 Triathlon on 27-28 July next...

Events

Press Releases

Triathlon

June 25, 2024

Over 40 Professional Athletes Line Up for Challenge Cagnes-sur-Mer

/ENDURANCE SPORTSWIRE/ – Challenge Family racing is back to France’s Côte d’Azur this weekend for the second edition of Challenge Cagnes-sur-Mer. This year's event features a strong professional field with 48 professional athletes competing. In the men's field, Jack Moody (AUS) has a great record. The Challenge Family Bonus ranking...

Events

Press Releases

Triathlon

June 25, 2024

The Countdown is on to Crusher in the Tushar

Beaver, Utah (Wednesday, June 25) /ENDURANCE SPORTSWIRE/ – The Life Time Grand Prix presented by Mazda returns for the third race of the series on Saturday, July 13th with the Life Time Crusher in the Tushar. This noted event in Beaver, Utah, is arguably the toughest 69.9-mile race on the planet...

Cycling

Events

Press Releases

June 24, 2024

IRONMAN Comes to Illinois for First Time with New IRONMAN 70.3 Triathlon to be Hosted in Rockford

- Inaugural IRONMAN 70.3 Rockford-Illinois triathlon is scheduled to take place on June 22, 2025 - General registration to open on July 1, 2024, at www.ironman.com/im703-rockford-illinois ROCKFORD, Ill. / TAMPA, Fla. (June 24, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN, the global leader in long-distance triathlon, announced today that it will host...

Events

Press Releases

Triathlon