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

October 23, 2021

unPAved of the Susquehanna River Valley Returns for Fourth Year

/ENDURANCE SPORTSWIRE/ - After a dramatically scaled back event in 2020, unPAved of the Susquehanna River Valley returned on Sunday, October 10th with a field of 825 participants, tackling distances ranging from 20 to 125 miles, and its signature celebration-style aid stations and DONEpaved Party, this year toasting riders with...

Cycling

Events

Press Releases

October 22, 2021

Ashton Lambie wins 2021 Men’s Individual Pursuit World Championship

ROUBAIX, France /ENDURANCE SPORTSWIRE/ - Ashton Lambie (Lincoln, Neb.; HUUB Wattbike) was the highlight of the third day of the 2021 Tissot UCI Track World Championships, winning the Men’s Individual Pursuit World Championship title. Jennifer Valente (San Diego; TWENTY24 Pro Cycling) raced four events today, all part of the Omnium, and Gavin...

Cycling

Events

Press Releases

October 22, 2021

Pic2Go Delivered Race Photo Based Video Clips at the Warsaw Marathon 2021

/ENDURANCE SPORTSWIRE/ - Pic2Go has successfully delivered Race Photo based Video Clips to participants of the 43. Warsaw Marathon, while boosting social reach and engagement to the activation sponsor – Bridgestone Poland! Pic2Go’s photo-based videos let organizers offer finishers with video clips to share, while keeping affordable activation costs (saving...

Events

Press Releases

Products

Running

October 22, 2021

The Epigenetic Rhode Runner

Narragansett, Rhode Island. /ENDURANCE SPORTSWIRE/ - Performance Medicine® introduces epigenetic performance testing and related cutting-edge protocols for endurance athletes at the Narragansett Marathon this Sunday. The iconic event is one in a series of Ocean State Rhode Races [OSRR] managed and promoted by Susan Rancourt and Karen Cox, visionary owners of...

Press Releases

Running

Sponsorship

October 22, 2021

Austin Marathon Creates Opportunity for Local Businesses to Sponsor Aid Stations

AUSTIN, Texas, October 22, 2021 - /ENDURANCE SPORTSWIRE/ - The Ascension Seton Austin Marathon presented by Under Armour invites local businesses to sponsor aid stations and join the 30th-anniversary festivities. This newly created opportunity costs nothing and includes local establishments and national businesses with an Austin presence. Operating one of...

Business

Events

Press Releases

Running

Sponsorship

October 22, 2021

Run Show USA Selects Dylan Bowman, Ultra Runner and Founder of Pyllars Podcast, to Host the Trail Running and Ultra Stage

Boston, MA /ENDURANCE SPORTSWIRE/ - The Run Show USA has added a Trail Running and Ultra Stage, hosted by Dylan Bowman, to its Boston event taking place at the Hynes Convention Center, January 29-30. Dylan is a professional ultrarunner from Portland, Oregon. Racing professionally for twelve years, Dylan has earned...

Events

Press Releases

Running

Trade Shows

October 22, 2021

GFNY launches Marathon running

/ENDURANCE SPORTSWIRE/ - GFNY Endurance Sports Series is back in the United States with the inaugural running event, GFNY Marathon Florida Sebring. The course is USATF certified and the flat and fast route makes it the perfect race for runners wanting to score a personal best. GFNY Marathon Florida also...

Events

Press Releases

Running

October 22, 2021

GFNY announces GFNY Waco

/ENDURANCE SPORTSWIRE/ - GFNY Waco is the latest addition to the GFNY Endurance Sports Series, making it the fourth GFNY cycling race in the United States. Scheduled for June 26, 2022, riders will get to ride a 86-mile double-looped course on open county roads passing farmland, cattle ranches and dairies....

Cycling

Events

Press Releases