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

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

February 27, 2024

deboer Make A Splash With New Partnership Of T100 Triathlon World Tour

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced a new partnership with deboer, who will become the Official Wetsuit & Performance and Training Swimwear Partner of the T100 Triathlon World Tour for the next three years. The wetsuit brand is the market leader and has a decade-long...

Press Releases

Sponsorship

Triathlon

February 27, 2024

Verge Launches The Intermarché-Wanty “They Win! You Win! Classics” Competition for Devoted Racing Supporters.

NEW YORK — February 27th, 2023 /ENDURANCE SPORTSWIRE/ – Verge, proud custom kit supplier for UCI World Tour Team Intermarché-Wanty, invites devoted fans to ride along during the Spring Classics with their loyalty competition “They Win! You Win! Classics.” Strade Bianche, Milan-San Remo, Gent-Wevelgem, Tour of Flanders, Paris-Roubaix and Liège–Bastogne–Liège,...

Cycling

Events

Press Releases

February 27, 2024

Tri Travel announce limited number of travel packages to sell out triathlon event, Escape from Alcatraz

27th February 2024 - UK/ENDURANCE SPORTSWIRE/ – Escape from Alcatraz is one of the world’s most iconic triathlon events, selling out year-on-year, with a reported 10,000 applicants vying for only 2,000 spots, making it a must do for any triathlete’s ‘bucket list’. Replicating the infamous prison escapes in modern history,...

Events

Press Releases

Triathlon

February 27, 2024

ASICS Falmouth Road Race Announces 2024 Charity Partners

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – The ASICS Falmouth Road Race has announced its list of charity participants for its 52nd annual race taking place on Aug. 18, 2024. Runners can gain early access (or guaranteed entry) into the popular event by raising funds for a charity through the Numbers for...

Events

Giving

Press Releases

Running

February 27, 2024

2nd Annual Annapolis Running Festival Returns to Historic Downtown Annapolis on March 9th.

Annapolis, Maryland – February 27, 2024/ENDURANCE SPORTSWIRE/ – The 2nd Annual Annapolis Running Festival is back and ready to take over the streets of historic downtown Annapolis on March 9, 2024. Hosted by Corrigan Sports Enterprises (CSE), this festival celebrates the spirit of running and community while offering participants a...

Events

Press Releases

February 27, 2024

TriDot Named Finalist for “App of the Year” by prestigious Sports Technology Awards

DALLAS, TX – February 27th, 2024 /ENDURANCE SPORTSWIRE/ – The prestigious Sports Technology Awards (STA), known as “The Oscars of Sports Technology,” announced that TriDot is shortlisted in three award categories including App of the Year. Shortlisted companies are invited to walk the red carpet and attend The Sports Technology...

Awards

Press Releases

Triathlon

February 27, 2024

Women’s Running Festival Adds New 10K to Labor Day Weekend Event

CARMEL, Ind. (February 27, 2024) /ENDURANCE SPORTSWIRE/ – The Women’s Running Festival, the largest women’s running event in Indiana, added a 10K race in 2024 to complement its half marathon and 5K. In addition, race organizers CRRG Events returned the event to its original date during Labor Day weekend. Set...

Events

Press Releases

Running

February 27, 2024

Altra Launches the Mont Blanc Carbon

DENVER, Colo. (February 27, 2024) /ENDURANCE SPORTSWIRE/ - Altra, a leading innovator in performance running, launches the all-new Mont Blanc Carbon – where comfort meets speed on the trail. “The Mont Blanc is one of the most well received shoes across the brand for comfort on any trail terrain,” according...

Press Releases

Products

Running