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

October 25, 2021

Michael Woods Will Race Virtually in the RBC GRANFONDO WHISTLER cycling series on ROUVY

Oct 25, 2022 /ENDURANCE SPORTSWIRE/ - With the indoor season in full swing, RBC GranFondo Whistler has created a special online cycling experience: four 'virtual races' and a ‘Challenge’ between Oct 30 - Nov 20, 2021, with the aim to give cycling enthusiasts around the globe the chance to enjoy...

Cycling

Events

Press Releases

October 24, 2021

America’s Finest City Welcomes Back Runners to The Ultimate Running Block Party at Heineken 0.0 Rock ‘n Roll Running Series San Diego, The Birthplace of The Series

SAN DIEGO, Calif. (Oct. 24, 2021) /ENDURANCE SPORTSWIRE/ - Following an over two-year hiatus, the 23rd edition of the Heineken 0.0 Rock ‘n’ Roll® Running Series San Diego returned this weekend welcoming over 14,000 participants from the ages 12 to 86. In the birthplace of the Rock ‘n’ Roll Running...

Events

Press Releases

Running

October 23, 2021

Moriah Wilson, Adam Roberge, Rach McBride Win the Inaugural Life Time Big Sugar Gravel Event

Bentonville, Ark., (Saturday, October 23, 2021) /ENDURANCE SPORTSWIRE/ - The inaugural Life Time Big Sugar Gravel race took place amidst peak fall foliage in Northwest Arkansas this Saturday with a field of more than 1,100 riders representing 46 states and 5 countries. The event joins Life Time’s portfolio of off-road cycling...

Cycling

Events

Press Releases

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

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