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 (8742)
) 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 1560, 10

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

BibRave and Feetures Join Forces to Launch Ambassador Program

Charlotte, NC /ENDURANCE SPORTSWIRE/ – BibRave, the premier endurance and fitness marketing agency, recently kicked-off a partnership with Feetures, a leading performance sock brand, to launch the Feetures Ambassador program, a dynamic community of dedicated brand advocates. BibRave will lead strategic management in collaboration with Feetures, including full program creation,...

Press Releases

Running

Sponsorship

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 28, 2024

The Paris 2024 Connected Marathon pour Tous is Available on the Kinomap App

PARIS (Feb. 28, 2024)/ENDURANCE SPORTSWIRE/ – As the distribution of the race bibs for the Marathon pour Tous draws to a close, Paris 2024 is launching the connected Marathon pour Tous on Kinomap! On August 10 & 11, 2024, runners, cyclists and rowers from all over the world will be able...

Press Releases

Products

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