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 (11)
) 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 530, 10

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

RunSignup Unveils New Pricing for RaceDay Suite and RaceDay Scoring

Moorestown, NJ — February 23, 2023 /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for endurance events in the United States, introduces a simplified pricing model for its RaceDay timer technology suite. Commencing February, 2024, timers can secure an annual RaceDay Suite subscription encompassing RaceDay Scoring, Race Director,...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

February 22, 2024

Showcased

INFINIT Nutrition Launches New Custom Protein Boosts: Berry Antioxidant and Greens Powders

Cincinnati, Ohio, February 22, 2024 /ENDURANCE SPORTSWIRE/ - INFINIT Nutrition, a pioneering force in personalized nutrition solutions for athletes, announced the addition of two brand new options to their custom protein powder platform: Berry Antioxidant Blend and Greens Blend superfood powders. INFINIT's Custom Protein platform simplifies athlete nutrition by offering...

Business

Press Releases

Products