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

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

October 29, 2021

Jordan Tropf Runs Three Marathons in Three Days; Believe in the Run Documents The Record-Breaking Attempt

BALTIMORE, Md /ENDURANCE SPORTSWIRE/ – Believe in the Run, in partnership with Soul Focus Sports and Under Armour, recently followed Jordan Tropf as he broke the world record (pending verification) for average finish time of three marathons in three days. Over the course of 52 hours from October 9 to...

Events

Press Releases

Running

October 29, 2021

Community Halloween Event and Trick or Treating to Kick-Off Saturday’s Into The Lion’s Den Powered By SRAM

SACRAMENTO (October 29, 2021) /ENDURANCE SPORTSWIRE/ – In addition to world class cyclists, families will also line up on the Into the Lion’s Den powered by SRAM starting line on Saturday, October 30th at 1:00pm. The first event on course will be the Community Halloween Event, where families can casually...

Cycling

Events

Press Releases

Sponsorship

October 29, 2021

GFNY North America Championship this Sunday in Sebring, Florida

/ENDURANCE SPORTSWIRE/ - After their inaugural GFNY Marathon in Sebring last week, GFNY Global Endurance Sports Series is back with cycling at the second GFNY Florida Sebring this Sunday, October 31. It’s this year’s GFNY North America Championship race where the champions win a fully covered trip to the World...

Cycling

Events

Press Releases