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

June 14, 2023

Frontwave Rides On With Bike The Coast As Title Sponsor

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ – Bike The Coast, Southern California’s premier coastal cycling event, has announced that Frontwave Credit Union has once again signed on as the ride’s title sponsor for 2023 and 2024. The longstanding partnership signals Frontwave’s continued dedication to the local community and events that bring visibility to...

Cycling

Events

Press Releases

Sponsorship

June 13, 2023

goodr Becomes a Sunglass Partner of USA Cycling

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling is proud to welcome sunglass company, goodr, as a partner through 2024. This collaboration brings together two powerhouses in their respective fields and marks an exciting chapter for both USA Cycling and goodr. This partnership represents a perfect collaboration with goodr's commitment to...

Cycling

Events

Press Releases

Sponsorship

June 13, 2023

3rd GFNY Florida Sebring double-race weekend: marathon and bike race coming up in October 2023

/ENDURANCE SPORTSWIRE/ - On October 21-22, 2023, two endurance races take place in Florida's home of endurance racing: On October 21, runners will take on a marathon and half marathon race from the Barn at Paso Fino. On October 22, one thousand cyclists from across the USA and 50+ countries...

Cycling

Events

Press Releases

June 13, 2023

Experience Vittoria Sweepstakes Offers a Once-In-A-Lifetime Cycling Experience/Getaway

BENTONVILLE, AR (June 13, 2023) /ENDURANCE SPORTSWIRE/ - Vittoria, the world’s leading brand of performance bicycle tires and accessories, announces the launch of the Experience Vittoria Sweepstakes, offering one lucky winner and their guest, the opportunity to embark on a journey to the Lombardy region in Italy. This remarkable adventure...

Cycling

Events

Press Releases

June 12, 2023

Next-generation marketing and communications platform for endurance events partners with Broken Arrow SkyRace

/ENDURANCE SPORTSWIRE/ - Capra is thrilled to announce their partnership with their first US race outside of Australia and New Zealand, Broken Arrow SkyRace in Palisades Tahoe that is taking place this week on June 16-18 (US). With Capra’s innovative mobile-first platform, Broken Arrow SKyRace race directors and event managers...

Business

Events

Press Releases

Products

Running

Sponsorship

June 11, 2023

XTERRA Belgium World Cup Weekend Wrap

ENDURANCE SPORTSWIRE/ - The inaugural XTERRA World Cup touched down in Europe for the first time at the iconic Citadel in Namur in Belgium over the June 10-11 weekend. Results and recaps from both the XTERRA European Championship full-distance race and the XTERRA Belgium Short Track are below. Felix Forissier,...

Events

Press Releases

Triathlon

June 11, 2023

Bishop and Byram Prove Dominant at 2XU Challenge Wales

/endurance sportswire/ - Wales shone in all its glory this weekend providing perfect conditions for an all-British victory with Tom Bishop and Lucy Byram taking the wins at Challenge Wales in 3:56:28 and 4:25:07 respectively. Andrew Horsfall-Turner led out of the swim, posting a time of 25:20 with Tom Bishop...

Events

Press Releases

Triathlon

June 11, 2023

Great Wins at Challenge Cagnes-sur-Mer for Mennesson and Simmonds

/ENDURANCE SPORTSWIRE/ - A stunning day of racing on the Côte d’Azur delivered victory for William Mennesson and Imogen Simmonds as they both proved dominant on the testing course in the hills above Nice with winning times of 4:09:48 and 4:43:03 respectively. An early start on the shores of the...

Events

Press Releases

Triathlon