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

August 1, 2024

Electrolit Named Official Hydration Partner of Spartan Race Canada for 2024 Season

[Toronto, Ontario] /ENDURANCE SPORTSWIRE/ – Electrolit®, Canada’s newest premium hydration beverage, is thrilled to announce its partnership with Spartan Race Canada as the Official Hydration Partner for the 2024 season. This strategic collaboration brings together two forces committed to promoting an active lifestyle, pushing boundaries, and ensuring optimal performance for...

Events

Press Releases

Sponsorship

July 31, 2024

Chargel Gears Up for On-Site Sampling at Southern California’s Tour de Big Bear

IRVINE, Calif. (July 31, 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 on-course at the 2024 Tour de Big Bear. Kicking off on...

Cycling

Press Releases

Products

Sponsorship

Wire Syndication

July 29, 2024

PeopleForBikes Announced as Gran Fondo National Series’ Advocacy and Philanthropy Partner

(Gettysburg, PA ) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series today announced that PeopleForBikes will be the organization's Advocacy and Philanthropy Partner for 2024 and beyond. Series participants will have opportunities to donate to PeopleForBikes initiatives, and the two organizations intend to work together to raise awareness of the importance...

Business

Cycling

Events

Press Releases

Sponsorship

July 28, 2024

Mcfly’s Harry Judd Headlines London T100 Triathlon Amateur Races

London, UK /ENDURANCE SPORTSWIRE/ - Mcfly drummer Harry Judd, singer Tom Grennan, international marathon runner Anya Culling, autistic Guinness World Record Triathlete Sam Holness, influencer Tom Trotter and Dr Hussain Al-Zubaidi, a doctor and lifestyle coach, were amongst 4,500 amateur triathletes in the capital this morning taking on the London T100...

Business

Cycling

Events

Press Releases

Running

Sponsorship

Trade Shows

Triathlon

July 27, 2024

Gentle Back on Top as She Wins London T100 Triathlon

London, UK /ENDURANCE SPORTSWIRE/ - Australian Ashleigh Gentle returned to winning ways at the London T100 Triathlon, to claim her second T100 race of the season and take her back to the top of the series standings. She finished ahead of Swiss star Imogen Simmonds and Britain’s Kat Matthews. Winner...

Awards

Cycling

Events

Press Releases

Running

Sponsorship

Trade Shows

Triathlon

July 25, 2024

Zoot Sports Welcomes 5x World Champion Craig “Crowie” Alexander as Brand Ambassador

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Zoot Sports, the industry leader in triathlon apparel, is excited to announce that Craig "Crowie" Alexander, a 5x World Champion and triathlon legend, has joined the company as a brand ambassador. With Alexander’s experience and expertise in the sport, he will play a pivotal role...

Press Releases

Sponsorship

Triathlon

July 19, 2024

supertri Partners With Europe Triathlon’s Rising Stars Initiative To Develop ‘NXT Gen’ Of Elite Athletes

LONDON, UK/ENDURANCE SPORTSWIRE/ – supertri can today announce a partnership with Europe Triathlon to support the development of the next wave of Olympic champions. supertri is officially backing the Rising Stars programme, which enables junior athletes from across the continent to have the chance to make a leap from amateur...

Press Releases

Sponsorship

Triathlon

July 19, 2024

Verge Sponsors Chicago Grit with a Stunning New Leader Jersey Design

NEW YORK, JULY 19, 2024 /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is proud to announce its sponsorship of Chicago Grit, formerly known as Intelligentsia Cup, the most exciting 10-day criterium race series in Chicagoland and the largest road racing series in America. Verge has closely...

Cycling

Events

Press Releases

Sponsorship