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

October 9, 2023

Hincapie Unveils a New Website

GREENVILLE, SC- October 9, 2023 /ENDURANCE SPORTSWIRE/ - Today, The Brand Leader, a leading branding and advertising agency in Greenville, proudly announces the launch of the freshly redesigned Hincapie Sports website. The new design exemplifies The Brand Leader's mission to provide innovative and transformative solutions that produce unmatched customer experiences....

Business

Press Releases

Products

October 9, 2023

Supersapiens Launches Apple Watch Display with Live Glucose Readings

Atlanta, GA /ENDURANCE SPORTSWIRE/ – Supersapiens announces the launch of its display on Apple Watch with app update release 3.1.1. For those seeking real-time insights into their body, the app watch integration offers convenience by displaying live glucose readings on the wrist without the need to access a mobile phone. Expanding...

Press Releases

Products

October 9, 2023

Swenson and Stephens Secure Fifth and Sixth at 2023 UCI Gravel World Championships

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling competed in the 2023 UCI Gravel World Championships held in Veneto, Italy on October 7-8. In the event’s second year, USA Cycling sent a full team with ambitious goals. The competition witnessed athletes tackling grueling courses and intense competition to secure top finishes...

Cycling

Events

Press Releases

October 8, 2023

Race of Champions at Challenge Peguera-Mallorca Next Weekend

/ENDURANCE SPORTSWIRE/ - There is more than enough for triathlon fans to enjoy in the coming weeks, because with Challenge Barcelona, Challenge Vieux Boucau and Challenge Peguera-Mallorca, three races are scheduled, each featuring insanely strong professional fields. Even though Challenge Peguera-Mallorca features a strong field every year, this year the...

Events

Press Releases

Triathlon

October 8, 2023

Triumphant Win for Youri Keulen at Challenge Barcelona Triathlon while Imogen Simmonds Takes Third Win of the Season

/ENDURANCE SPORTSWIRE/ - A spectacular day of racing through the heart of Barcelona resulted in a nail-biting race to the finish between Youri Keulen (NED) and Alistair Brownlee (GBR) with Keulen winning through to take victory at the inaugural Challenge Barcelona Triathlon in 2:29:15. Imogen Simmonds (SUI) took her third...

Press Releases

Triathlon

October 6, 2023

Rusnak BMW Returns as Presenting Sponsor for sold-out Malibu Half Marathon

MALIBU, CA – October 6, 2023 /ENDURANCE SPORTSWIRE - Run Malibu organizers today announced that longtime race partner Rusnak BMW is returning as the presenting sponsor for the highly anticipated running of the Malibu Half Marathon, 5K & Kids Run presented by Rusnak BMW, set to take place in November...

Events

Press Releases

Running

Sponsorship

October 6, 2023

European Athletics selects haku as the driving force behind the race registration and CRM technology for the 2025 and 2027 European Running Championships

Miami & Lausanne – October 6, 2023 /ENDURANCE SPORTSWIRE/ – haku is pleased to announce it has been selected by European Athletics as the race registration and CRM technology partner to power the 2025 and 2027 editions of the European Running Championship. Taking place in Leuven and Brussels on 12-13 April...

Events

Press Releases

Running

October 6, 2023

Snail’s Pace Running Shop and the Surf City Marathon Announce Multi-Year Partnership

HUNTINGTON BEACH, Calif. /ENDURANCE SPORTSWIRE/ - A Snail's Pace Running Shop, Southern California's beloved hub for running and walking enthusiasts since 1979, and the Surf City Marathon and Half Marathon presented by 361° today announced a new partnership, making A Snail's Pace the official retail and expo partner of the...

Events

Press Releases

Running

Sponsorship

October 6, 2023

Super Sunday in USA and Mexico for GFNY

New York City, October 6, 2023 /ENDURANCE SPORTSWIRE/ – Cambridge hosted the inaugural edition of GFNY Maryland this past Sunday. The race course was a 92.4 mile long course with only 481 ft of climbing. As early as at mile 9 two riders managed to escape the main group: ex-pro and...

Cycling

Events

Press Releases