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

September 20, 2023

Grand Canyon Trail Half Marathon Announces Prize Money

/ENDURANCE SPORTSWIRE/ - The November 4th Grand Canyon Trail Half Marathon is pleased to announce that it is offering up to $1000 in prize money in 2023. With a loop course through the scenic Kaibab National Forest, the Trail Half Marathon will begin and end in Grand Canyon Village, located...

Events

Press Releases

Running

September 20, 2023

Gobble ‘til You Wobble at This Year’s O’side Turkey Trot

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ – San Diego County’s largest Thanksgiving day running event is back with fun, fitness and festivities on Nov. 23. The O’side Turkey Trot attracts visitors from 46 States and 460 cities and benefits the Move Your Feet Before You Eat!® Foundation. Those interested in running, walking...

Events

Press Releases

Running

September 19, 2023

Old Kentucky Home: IRONMAN Returns to The Bluegrass State with New IRONMAN 70.3 Louisville Triathlon Beginning in 2024

- Popular host venue returns to host first IRONMAN branded event since 2019 - Inaugural IRONMAN 70.3 Louisville triathlon scheduled to take place Aug. 18, 2024; General registration to open Sept. 27, 2023, and can be accessed by visiting, www.ironman.com/im703-louisville LOUISVILLE, Ky. / TAMPA, Fla. (Sept 19, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN...

Events

Press Releases

Triathlon

September 19, 2023

Tucson Bicycle Classic Announces Dates for 36th Annual Stage Race in 2024

Tucson, AZ, September 19, 2024 /ENDURANCE SPORTSWIRE/ – The Tucson Bicycle Classic (TBC) proudly announces the dates for its 36th annual stage race in 2024. A premier event in the world of competitive road cycling, TBC continues to attract top talent from across the nation. In celebration of its rich history,...

Cycling

Events

Press Releases

September 19, 2023

Challenge Sanremo celebrates international triathlon on the Italian Riviera

/ENDURANCE SPORTSWIRE/ – The celebration of sport that is Challenge Sanremo returns to the Italian Riviera this weekend, bringing together professional athletes, young people and amateurs on one of the circuit’s most spectacular but testing courses. With over 40 professional athletes on the start line, the spotlight is on Bart...

Events

Press Releases

Triathlon

September 19, 2023

Israman Joins Challenge Family Global Triathlon Series, Celebrates 25th Anniversary as Challenge Israman

/ENDURANCE SPORTSWIRE/ – Challenge Family is proud to announce Challenge Israman in its partnership with Israman in a ground-breaking move that marks a significant milestone in the event’s illustrious 25-year history. Since its inception in 1999, Israman has been synonymous with excellence, attracting athletes from all corners of the globe...

Events

Press Releases

Triathlon

September 19, 2023

Run Medford Partners with Kinomap to Expand Event Fundraising Reach

(Sept. 19, 2023) /ENDURANCE SPORTSWIRE/ - In an exciting addition to its second iteration, Run Medford is partnering with Kinomap for Races to film the Saturday, Sept. 23 five miler and bring the event to runners on treadmills or other cardio devices anywhere in the world. Not only will this...

Business

Events

Press Releases

September 19, 2023

Bike the Coast Returns for Another Year of Oceanfront Riding

San Diego, Calif. /ENDURANCE SPORTSWIRE/ – Bike the Coast, San Diego’s iconic oceanfront cycling event, will be returning for its annual ride on Nov. 4. The ride provides opportunities for participants of all levels to enjoy a memorable course that takes them along the scenic views and quaint communities along Highway...

Cycling

Events

Press Releases