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

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

February 26, 2024

Iconic Home of Fitness Gold’s Gym SoCal Welcomes All IHRSA-Goers for Free Workouts

Los Angeles, CA – As the fitness world converges on Los Angeles for the highly anticipated International Health, Racquet & Sportsclub Association (IHRSA) 2024 Convention and Trade Show, Gold’s Gym SoCal – the original home of fitness workouts – announces a special offer for all attendees. In celebration of this...

Business

Events

Press Releases

Trade Shows

February 26, 2024

Rock‘n’Roll Running Series Las Vegas – World’s Largest Running Party – Welcomes Participants From 60 Countries, Regions & Territories To Exhilarating Multi-Day Immersive Running Experience Over The Weekend

LAS VEGAS /ENDURANCE SPORTSWIRE/ – Approximately 27,000 registered participants from around the world converged in Las Vegas, Nevada this weekend for the 14th edition of the Rock ‘n’ Roll® Running Series Las Vegas - the World’s Largest Running Party. The Rock ‘n’ Roll Running Series Las Vegas half marathon and 10K...

Events

Press Releases

Running

February 26, 2024

Bikeflights Becomes Tour de France Femmes Avec Zwift Official Service

PORTLAND, OR (February 26, 2024) /ENDURANCE SPORTSWIRE/ - Bikeflights, a bicycle shipping service trusted by riders worldwide, is now a Tour de France Femmes avec Zwift Official Service. “We’re pleased to extend Bikeflights’ relationship with Amaury Sport Organisation (A.S.O.) to both continue our support for the Tour de France and...

Cycling

Events

Press Releases

Sponsorship

February 26, 2024

Rock ‘N’ Roll Running Series Las Vegas Participants Kick Off World’s Largest Running Party in Downtown Las Vegas On Saturday Night at Rock ‘N’ Roll Running Series 5k

LAS VEGAS /ENDURANCE SPORTSWIRE/ - The 14th running of the iconic Rock ‘n’ Roll® Running Series Las Vegas commenced as participants of all ages, abilities, and backgrounds conquered the 2024 Rock ‘n’ Roll Las Vegas 5K in Downtown Las Vegas on Saturday night. As runners and walkers alike crossed the...

Press Releases

Running