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

November 9, 2023

USA Triathlon Announces 2024 National Championships Calendar

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today unveiled the dates and locations for its 2024 National Championships, a robust calendar of triathlon and multisport events across the United States. USA Triathlon has partnered with local USA Triathlon Race Directors across the United States to produce the 2024 National Championships, which offer...

Events

Press Releases

Triathlon

November 9, 2023

P3R and Pittsburgh Flag Football League Team Up to Take Youth Activity to the Next Level

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has partnered with the Pittsburgh Flag Football League (PFFL) to inspire youth to MOVE in new ways. Through the partnership, P3R plans to help organize, facilitate and promote a Youth Flag Football Clinic and an open Recreational Flag Football Tournament in 2024. P3R recently announced their...

Press Releases

Sponsorship

November 9, 2023

End Result Celebrates Record-Breaking 2023 for Cross Country Running Events

Rock Island, IL – November 8, 2023 /ENDURANCE SPORTSWIRE/ – End Result, powered by Stack Sports, soon to be Stack Endurance, have set a new benchmark in the world of cross country running events in the Midwest. Their collective efforts culminated in a series of events that showcased the best of...

Events

Press Releases

Running

November 9, 2023

End Result Times CNO Financial Indianapolis Monumental Marathon, Setting New Event Records

Indianapolis, IN - Nov 8, 2023 /ENDURANCE SPORTSWIRE/ – End Result, powered by Stack Sports, a leading race timing company is proud to announce its successful partnership with the CNO Financial Indianapolis Monumental Marathon, one of the 15 largest marathons in the U.S. The event, which took place last Saturday, October...

Events

Press Releases

Running

November 9, 2023

USA Cycling Partners with the EuroCrossAcademy for 2023-2024 Cyclocross Season

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling and EuroCrossAcademy (ECA) will partner for cyclocross junior development throughout the 2023-2024 season. The common goal of USA Cycling and ECA is to focus on long-term, holistic development for junior athletes through a character-driven curriculum and a process-to-performance philosophy. The partnership will kick...

Cycling

Events

Press Releases

Sponsorship

November 9, 2023

Cigna Healthcare Extends Title Sponsorship with the Denver Colfax Marathon

Denver, CO (November 9th, 2023) /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon announced today that Cigna Healthcare is renewing its title sponsorship for the 2024 Denver Colfax Marathon. This partnership comes as the health benefits provider continues to support the health and vitality of those in the greater Denver community...

Business

Events

Press Releases

Running

Sponsorship

November 9, 2023

Nominations Now Open for CABDA Awards

Chicago, IL – November 9, 2023 /ENDURANCE SPORTSWIRE/ – Organizers of the CABDA Expo announced this week that nominations of their annual awards program are now open. The CABDA Awards celebrate excellence and innovation within the bicycle industry, recognizing outstanding achievements in three key categories: Retailer of the Year, Supplier of...

Awards

Cycling

Press Releases

Trade Shows

November 9, 2023

Momentum Introduces Its First Throttle E-Bike, Cito E+

NEWBURY PARK, Calif. (Nov. 9, 2023) /ENDURANCE SPORTSWIRE/ - Momentum, the lifestyle-inspired bicycle brand focused on urban transportation solutions, today introduced its first throttle e-bike, the Cito E+. Inspired by moto design and built to offer an efficient way to travel around town, the Cito E+ is able to keep...

Cycling

Press Releases

November 8, 2023

ENVO Drive Systems Named One of Canada’s Clean Technology Winners in Deloitte’s Technology Fast 50™ Program

Vancouver, Canada (November 8, 2023)/ENDURANCE SPORTSWIRE/ – ENVO Drive Systems has received a Clean Technology award as part of Deloitte’s Technology Fast 50 program. Launched last year, the new award leadership category recognizes Canada’s top clean innovators providing processes, goods, or services that reduce environmental impacts. Designers and manufacturers of traditional e-bikes...

Awards

Cycling

Press Releases

Products