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 (11)
) 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 310, 10

July 1, 2024

Denver Colfax Marathon Celebrates Race Director Creigh Kelley

DENVER, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon celebrates the career of its longtime race director, Creigh Kelley, as he transitions into a race director emeritus role. Kelley, who has been with the marathon since its inception 18 years ago, is stepping away from his official race director duties...

Awards

Business

Events

Giving

Press Releases

Running

Triathlon

June 28, 2024

Favorite Bikes Launches Brand New Hybrid CSC ST To COSTCO Canada Online

Favorite Bikes, Los Angeles, California /ENDURANCE SPORTSWIRE/ - Favorite Bikes, a pioneer in electric bike technology, proudly announces the launch of its newest model, the Hybrid CSC ST, available online at Favorite Bikes and through the newly formed relationship with Costco’s Canada and their online store for $1999 CAD. This cutting-edge...

Business

Cycling

Press Releases

Products

June 28, 2024

Ultra X Announces Big Summer Sale

/ENDURANCE SPORTSWIRE/ - Ultra X, renowned for organizing world-class ultra-marathons, is thrilled to announce the launch of its highly anticipated Big Summer Sale. This exclusive sale offers participants a chance to enjoy a 20% discount on all 2024 events, making it the perfect opportunity to secure a spot in some...

Business

Events

Press Releases

Running

June 28, 2024

Hap Seliga Appointed President of Scott USA

/ENDURANCE SPORTSWIRE/ - SCOTT Sports, manufacturer and distributor of high-quality Bike and Outdoor equipment and apparel, welcomes industry veteran Hap Seliga as President of SCOTT USA, the United States subsidiary of SCOTT Corporation. Alongside teams based in Salt Lake City and Ogden, Utah, Seliga will work to drive growth in...

Business

Cycling

Press Releases

June 26, 2024

Chargel Continues On-Site Samplings and Sponsorships at California’s Truckee Tahoe Gravel

IRVINE, Calif. (June 26, 2024)/ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy with zero caffeine, today announced it will be sampling its half drink, half snack, energy source at the 2024 Truckee Tahoe Gravel. Running from June 28-29 in Truckee,...

Business

Cycling

Events

Giving

Press Releases

Products

Sponsorship

Wire Syndication