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 (16)
) 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 1580, 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

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 8, 2023

PTO Asian Open Gets ‘Thumbs Up’ From Athletes – As Singapore Return Confirmed For 12-14 April 2024

Singapore, 8 November/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has confirmed the 2024 PTO Tour will return to Singapore on 12-14 April, 2024, staging 100km triathlons races for female and male professionals and experienced amateurs* as well as two duathlons. Whilst PTO World #1’s Kristian Blummenfelt and Ashleigh Gentle claimed the...

Events

Press Releases

Triathlon

November 8, 2023

Celebrate Veterans Day at the 24th Annual Silver Strand Veterans Day Half Marathon, 10 Miler, 12K, and 5K Sunday November 12th, 2023

San Diego, CA /ENDURANCE SPORTSWIRE/ - On November 12th, you can honor Veterans Day by participating in the 24th Annual Silver Strand Veterans Day Half Marathon, 10 Miler, 12K, and 5K, presented by KOZ Events. This event, hosted by Life Sports Foundation (LSF), will not only support veterans but also...

Events

Giving

Press Releases

November 8, 2023

3000 riders at 10th edition of GFNY Cozumel this Sunday

New York City, November 8, 2023 /ENDURANCE SPORTSWIRE/ - The 10th GFNY Cozumel is the largest bike race in the Americas south of NYC. This Sunday, 3000 riders will tackle the flat yet windy 157.5km race course with 431m of climbing around the tropical island. “GFNY Cozumel is the success...

Cycling

Events

Press Releases