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

November 10, 2023

Inaugural Las Vegas Marathon is Coming in November 2024

Las Vegas, Nevada, November 10, 2023/ENDURANCE SPORTSWIRE/ – Top endurance event organization, Brooksee, is proud to announce the launch of its newest event, the Las Vegas Marathon. The inaugural Las Vegas Marathon will commence on Sunday, November 3, 2024. “Brooksee is thrilled to be able to officially launch the Las Vegas Marathon,”...

Events

Press Releases

Running

November 10, 2023

A Successful First International Adventure Racing Conference (IARC)

/ENDURANCE SPORTSWIRE/ – The first International Adventure Racing Conference was held on the final day of the 2023 Adventure Racing World Championship, hosted by Expedition Africa in South Africa. The conference achieved its objective of bringing together a mix of speakers from within the Adventure Racing community to share their...

Press Releases

Trade Shows

November 10, 2023

Kinomap Marks Veteran’s Day by Partnering with Run for the Troops 5K

BOSTON (Nov. 10, 2023) /ENDURANCE SPORTSWIRE/ - This Veteran’s Day, Kinomap salutes the service of American troops at home and abroad, past and present, and is proud to announce that Run for the Troops 5K, will be among the races featured on Kinomap for Races. Taking place Sunday, Nov. 12...

Events

Press Releases

Running

November 10, 2023

Registration opens for 22nd Little Rock Marathon Expo

LITTLE ROCK, Ark. (November 10, 2023) /ENDURANCE SPORTSWIRE/ - Registration is now open for the 2024 Little Rock Marathon Health and Fitness Expo, presented by the Hatcher Agency. The two day event features vendors and exhibitors showcasing products and services geared toward runners, walkers and health-minded consumers. The Expo will...

Business

Events

Press Releases

Running

Sponsorship

Trade Shows

November 9, 2023

Life Time Sea Otter Classic Expo off to Record-Breaking Start

MONTEREY, Calif. (November 9, 2023) /ENDURANCE SPORTSWIRE/ - Life Time (NYSE: LTH), the nation's premier healthy lifestyle brand, announced that more than 1,000 brands will be represented at the 34th Annual Life Time Sea Otter Classic presented by Continental. With reservations coming in at record pace, exhibitor space for the...

Business

Cycling

Events

Press Releases

Products

Sponsorship

Trade Shows

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