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

November 1, 2021

US Mountain Running Team Racing XTERRA Trail Run Worlds in Maui, Dec 4

November 1, 2021 /ENDURANCE SPORTSWIRE/ - The top trail runners in the U.S. are headed to Hawaii to compete in the XTERRA Trail Run World Championship half-marathon at The Ritz-Carlton, Kapalua on December 4, 2021. Highlighting the all-star cast from the U.S. Mountain Running Team are 2019 XTERRA Trail Run...

Events

Press Releases

Running

November 1, 2021

O’Side Turkey Trot’s Triumphant Return Set For Thanksgiving Day

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ - The O’Side Turkey Trot, San Diego County’s largest Thanksgiving day running event, will be welcoming friends and family back to downtown Oceanside this year and inviting them to ‘move their feet before they eat®’ on Nov. 25. After moving to a virtual event during the...

Events

Press Releases

Running

October 29, 2021

Competitive Cyclist Named Official E-Commerce Partner of L39ION of Los Angeles

PARK CITY, Utah (Oct. 29, 2021) /ENDURANCE SPORTSWIRE/ - Competitive Cyclist, the premier online retailer for premium cycling gear and apparel, and L39ION of Los Angeles, a trailblazing professional cycling team devoted to progressing the sport through representation and inclusion, have teamed up for a multi-year partnership. The partnership announcement...

Cycling

Press Releases

Sponsorship

October 29, 2021

Sun Belt Conference Basketball Tournament Ticket Books on Sale November 1

NEW ORLEANS /ENDURANCE SPORTSWIRE/ - Ticket books for the 2022 Sun Belt Conference Men’s and Women’s Basketball Tournaments will go on sale Monday, November 1 at 10 a.m. CT. In partnership with Pensacola Sports and Visit Pensacola, the tournaments will be played March 2-7, 2022 at the Pensacola Bay Center...

Events

Press Releases

October 29, 2021

Duel In The Desert: Ultra Time Trial Racers Scorch The Roads

Boulder, CO /ENDURANCE SPORTSWIRE/ - Two weekends ago while many eyes in the cycling world were focused on Sea Otter Classic there was serious racing happening in the peripheral vision of the sport. The 10th edition of the 6-12-24 World Time Trial Championships (WTTC) was happening in Borrego Springs, CA. ...

Cycling

Events

Press Releases

October 29, 2021

Golden Gate Half Marathon Celebrates 20 Years on Sunday

SAN FRANCISCO - October 29, 2021 /ENDURANCE SPORTSWIRE/ - The Golden Gate Half Marathon & 5k will welcome more than 6,000 participants to San Francisco for the 20th edition of the iconic event on Sunday, November 7, 2021. The classic California half-marathon is the original race in the Bay Area...

Events

Press Releases

Running