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 (21085)
) 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 240, 10

August 28, 2024

RunSignup Introduces Chip Timing Tracking Alerts in its RaceJoy Event App

Moorestown, NJ – August 28, 2024 /ENDURANCE SPORTSWIRE/ - RunSignup, the premier provider of registration and technology for endurance events in the United States, announces its RaceJoy event app now offers participant chip-timed progress alerts. This is the latest advancement in RunSignup’s RaceDay Real-Time technology suite. Timers can now activate...

Cycling

Events

Press Releases

Products

Running

Triathlon

August 27, 2024

Garmin adds AMOLED displays to fēnix 8 Series, its most capable lineup of premium multisport GPS smartwatches with something for everyone

OLATHE, Kan./August 27, 2024/ENDURANCE SPORTSWIRE/ – Garmin (NYSE: GRMN) today announced the fēnix® 8 Series, its next-gen premium multisport GPS smartwatches that offer either a bright AMOLED display or solar charging display for even greater battery life. Introducing advanced strength training features, dive capabilities, an internal speaker and mic and...

Press Releases

Products

August 27, 2024

Push your limits with the Enduro 3 from Garmin, a lightweight ultraperformance GPS smartwatch with best-in-class solar battery life

OLATHE, Kan./August 27, 2024/ENDURANCE SPORTSWIRE/ – Garmin (NYSE: GRMN) today announced Enduro™ 3, its next-gen ultraperformance GPS smartwatch that is lighter than ever and can last for longer than the previous model thanks to a solar charging display. Built for the longest races, Enduro 3 weighs just 63 grams and...

Press Releases

Products

Running

August 26, 2024

KUIU Introduces New Kodiak 2000 Cooler Backpack

Aug. 26, 2024 -- Dixon, CA /ENDURANCE SPORTSWIRE/ –KUIU, the leading manufacturer of high-performance hunting apparel and gear, proudly introduces the Kodiak 2000 Cooler Backpack. Purpose-built to eliminate the need for multiple bags, this backpack combines wet and dry submersible storage into one versatile pack. The Kodiak 2000 Cooler Backpack...

Press Releases

Products

August 26, 2024

Redwood Outdoors Named the Official Sauna and Cold Plunge of Spartan Seattle and Spartan Los Angeles

BOSTON, MASS. /ENDURANCE SPORTSWIRE/ - In an exciting development for endurance athletes, Spartan Race, the global leader in obstacle course racing, is thrilled to announce Redwood Outdoors as the Official Sauna and Cold Plunge Partner for its upcoming Seattle and Los Angeles races. This partnership marks a significant step forward in...

Business

Events

Press Releases

Products

Running

Sponsorship

August 26, 2024

Experience the Paris 2024 Paralympic Games with New Connected Challenges on Kinomap

PARIS - August 26, 2024/ENDURANCE SPORTSWIRE/ – Get ready to immerse yourself in the excitement and inspiration of the Paris 2024 Paralympic Games with Kinomap’s exclusive virtual challenges. From August 28 to September 8, you can join the action from the comfort of your own home or gym, with new connected...

Press Releases

Products

August 22, 2024

PAYNTR Golf and Carbitex Debut The TRAINER CARBON X

Portland, OR /ENDURANCE SPORTSWIRE/ – PAYNTR Golf, North America’s fastest growing golf footwear brand, today announces the launch of the TRAINER CARBON X, a revolutionary training shoe developed in collaboration with Carbitex®, a leading expert in high-performance materials. Engineered to elevate both on and off-course performance, the TRAINER CARBON X is...

Press Releases

Products