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

May 16, 2023

Tifosi Optics Expands Clarion Blue Fototec Lens Collection

Watkinsville, GA (May 16, 2023) /ENDURANCE SPORTSWIRE/ - Tifosi Optics, the #1 selling brand of cycling eyewear in the United States, is excited to announce the expansion of its Clarion Blue Fototec Lens Collection. Clarion Blue Fototec instantly adapts to changes in ambient light conditions allowing cyclists freedom from having...

Cycling

Press Releases

Products

Running

Triathlon

May 16, 2023

US Trail Running Conference Announces RouteArrows.com As Run Sponsor & Exhibitor

Nailsworth, England /ENDURANCE SPORTSWIRE/ – US Trail Running Conference, presented by Marathon Printing, announces that conference exhibitor RouteArrows.com will be the Official Supplier of Route Marking Products for the 2023 USTRC Fun Runs. The 2023 edition takes place in Mukilteo, Washington, October 18-20, remaining in the Pacific Northwest for the second...

Press Releases

Running

Sponsorship

Trade Shows

May 16, 2023

Whitefish Marathon Preparing for New Course Records, Championship-Level Competition and Festive Atmosphere

WHITEFISH, Mont. (May 16, 2023)/ENDURANCE SPORTSWIRE/ - Participants from nearly 40 states will be vying for personal bests and course records at the 16th annual Whitefish Marathon, Half Marathon and 5K Powered by Hammer Nutrition this Saturday, May 20, 2023 in Whitefish, Montana. Held in the shadows of Glacier National...

Events

Press Releases

Running

May 16, 2023

Powering Performance: INFINIT Nutrition Announced as Official Nutrition Partner of TRI AMSTERDAM

(Prague, Czech Republic)/ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, a leading player in the US sports nutrition market since 2003, is focusing more on Europe with immediate effect and will therefore become Official Nutrition Sponsor of TRI AMSTERDAM. Athletes will be offered sports drinks from INFINIT during and after the race. "As an...

Press Releases

Sponsorship

Triathlon

May 15, 2023

Michelin Soles Takes Bigger Steps into North American Market with JV International

WOLCOTT, Vt (May 15, 2023) /ENDURANCE SPORTSWIRE/ – JV International, a manufacturer of technical soles and the worldwide licensee of soles by Michelin, is expanding its North American presence with a new office opening in Wolcott, Vermont. The newly established JV North America Corp aims to strengthen and improve its position...

Business

Press Releases

May 15, 2023

Cycling Time Trials (CTT) welcomes Nick Adnitt and Helen May to the team

May 2023 - UK/ENDURANCE SPORTSWIRE/ – Cycling Time Trials (CTT) are delighted to welcome two new members to their team - Nick Adnitt and Helen May, in two brand new roles, and in a move that sees the team growing and diversifying. Nick takes on the role of Support Administrator, principally responsible...

Business

Cycling

Press Releases

May 15, 2023

Sportive Breaks announces launch of travel & spectator packages for the 2023 UCI Cycling World Championships

15th May 2023 - Manchester UK /ENDURANCE SPORTSWIRE/ – Sports travel experts Sportive Breaks offer bespoke premium travel packages for cyclists looking to take part in Europe’s most prestigious cycling events, cycling breaks and weekenders. Be it that you are looking for your next big endurance challenge or simply some time away...

Cycling

Events

Press Releases

Sponsorship

May 15, 2023

17th Annual Denver Colfax Marathon Returns to the Mile High City

Denver, CO/ENDURANCE SPORTSWIRE/ – For the first time in its 17-year race history, the Denver Colfax Marathon, presented by Cigna, has sold out the marathon (26.2 mile) race distance. The city’s only marathon weekend will take place May 19-21, 2023. While the marathon distance has reached its limit for registrants, people...

Events

Press Releases

Running

May 15, 2023

Pho3nix Announce Athlete Program Paris 2024

/ENDURANCE SPORTSWIRE/ - The Pho3nix Foundation has today announced the initial ten athletes who will receive support in their campaigns to qualify for the 2024 Paris Olympic Games via the Pho3nix Athlete Program. Now in its third Olympic cycle, the Pho3nix Athlete Program aims to assist Olympic athletes from any...

Press Releases

Sponsorship