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

February 29, 2024

USA Cycling Gran Fondo National Championships Named Official Qualification Event for UCI Gran Fondo World Championships

(Gettysburg, PA – February 29, 2024) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series and USA Cycling today announced that the 2023 and 2024 USA Cycling Gran Fondo National Championships are official qualifier events for Masters (racing age 30+) aiming to compete in the 2024 and 2025 UCI Gran Fondo World...

Business

Cycling

Events

Press Releases

February 28, 2024

Always Endeavor Announces the 8th Year of Endeavor Team Challenge, Its Premier Adventure Competition

Bear Valley, California /ENDURANCE SPORTSWIRE/ – Adventure race company Always Endeavor is proud to announce the dates and location for the 8th Endeavor Team Challenge, a paramount event in the world of adventure racing. The two-person team challenge is slated to take place in Bear Valley, California, August 24th and...

Events

Press Releases

February 28, 2024

Showcased

Baltimore Triathlon joins forces with Revolution3

/ENDURANCE SPORTSWIRE/ – Charm City Run Events and Revolution3 are proud to announce the continuation of the Baltimore Triathlon. Founded as the HammerMan Triathlon in 2010, the Baltimore Triathlon has been owned and operated for many years by Charm City Run Events, a Baltimore area endurance sports company. In 2024,...

Events

Press Releases

Triathlon

February 28, 2024

Pro Tour Team Corratec-Vini Fantini confirmed for Gran Premio New York City

NEW YORK CITY, February 28, 2024 /ENDURANCE SPORTSWIRE/ - The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The...

Cycling

Events

Press Releases

February 28, 2024

RBC GranFondo Whistler and XFondo accepted into gender equity Same Game Challenge

[Vancouver/Whistler, BC Canada]/ENDURANCE SPORTSWIRE/ - The organizing team behind the cycling events RBC GranFondo Whistler and XFondo announced today that they have been successfully accepted into the Canadian Women and Sport Same Game Challenge. The Same Game Challenge “helps sport and physical activity organizations across Canada build their capacity to...

Business

Cycling

Events

Press Releases

February 28, 2024

LA Tri-Series Returns for Another Year of Historical Races at Bonelli Park

LOS ANGELES, Calif. /ENDURANCE SPORTSWIRE/ – The LA Tri-Series is returning for its 42nd consecutive event, continuing its streak as the oldest triathlon series in the world. The 2024 edition will be kicking off with the LA Tri-Series #1, which takes place on April 7. Registration for all three events...

Events

Press Releases

Triathlon

February 28, 2024

Mascot Sports’ Livermore Valley Half Marathon returns for 10th Anniversary in California’s Original Wine Country

/ENDURANCE SPORTSWIRE/ - The 10th Anniversary of the Livermore Valley Half Marathon, all-new 5K & kids races will take place on March 3, 2024. Mascot Sports, who founded the race in 2014 and awarded “Destination Partner of the Year” from Livermore Downtown Inc., is excited to kick off this iconic...

Events

Press Releases

Running

February 27, 2024

Norco Factory Racing Rider Gracey Hemstreet Makes History at Red Bull Hardline Tasmania

VANCOUVER /ENDURANCE SPORTSWIRE/ - Norco Factory Racing rider Gracey Hemstreet was the biggest story of the Red Bull Hardline race in Tasmania last weekend, after becoming the first-ever female rider to complete the entire Hardline course. At just 19-years-old, the young Canadian’s fearless performance secured her the title of fastest woman...

Cycling

Events

Press Releases

Sponsorship

February 27, 2024

Showcased

Tennis Legend Andre Agassi Named Inaugural Chair of Life Time Pickleball and Tennis Board to Guide Future Growth, Programming and Community

Chanhassen, Minn., (February 27, 2024)/ENDURANCE SPORTSWIRE/ – There is no slowdown in sight in the growth of pickleball and tennis at Life Time (NYSE: LTH), and the passion among those playing is at an all-time high. With the goal of charting the Company’s future in these areas, Life Time Founder, Chairman...

Business

Events

Press Releases