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 2620, 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

BibRave Drives Growth with Key Promotion and New Hires

/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently announced a key promotion and the addition of two new strategic hires within the organization. These personnel moves bolster the company’s standing within and ability to serve the endurance and fitness markets, while also branching out to support other verticals....

Business

Press Releases

Running

September 20, 2023

INFINIT Nutrition Unveils Exciting New Flavor: Orange Dreamsicle, with Expansion of Custom Protein Platform

Cincinnati, Ohio, September 20, 2023/ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, known for its innovative custom-blended solutions, is thrilled to announce a delicious addition to its lineup: Orange Dreamsicle. This new flavor offering gives customers another unique option to enjoy while further solidifying INFINIT's commitment to personalized nutrition. Reminiscent of the classic summertime ice...

Press Releases

Products

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

Media Alert – Documentary – “Freddy Ovett’s Road To Berlin” Now Available

Atlanta, GA /ENDURANCE SPORTSWIRE/ – Supersapiens is excited to release its latest documentary venture with the riveting tale of a young sportsman, Freddy Ovett, who embraced a shift from the podium-chasing world of professional cycling to celebrating the pure essence of athleticism. Our previous documentary, "The Long Swim, Cycle, and Run to...

Cycling

Press Releases

Products

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

Polartec Power Shield Debuts in Santini Adapt Multi Jacket

September 19, 2023/ENDURANCE SPORTSWIRE/ – Polartec®, a Milliken™ & Company brand, launches all-new bio-based Polartec® Power Shield® fabric technology to market, debuting in the Adapt Multi Jacket by renowned cycling brand, Santini. The launch of the Adapt Multi Jacket ushers in an exciting new era of high-performance, eco-friendly cycling apparel and...

Cycling

Press Releases

Products

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

CEP Launches New Cold Weather Apparel Featuring Recycled Polyester

Whitsett, NC. (September 19, 2023) — Today, CEP Compression, a world leader in compression products for athletes, announces their new cold weather apparel line featuring recycled polyester. These products are guaranteed to keep users warm, dry, and comfortable during any winter run, hike, or adventure. The Cold Weather Vest offers...

Press Releases

Products

Running

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