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

November 3, 2022

Pumpkin Spice Half celebrates seven years of fall fun in Fort Worth

FORT WORTH, Texas /ENDURANCE SPORTSWIRE/ – Running season and pumpkin spice season pair perfectly at the Pumpkin Spice Half Marathon, 10K and 5K, which will return to the streets of Fort Worth on Nov. 19. The event is a part of Run Project, Texas’ premier race series, and over 2500 runners...

Events

Giving

Press Releases

Running

November 3, 2022

FulGaz expands User Experience with New Enhancements

TAMPA, Fla. / MELBOURNE, Australia (November 3, 2022) /ENDURANCE SPORTSWIRE/ – FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, has released new enhancements to expand the user experience, including the launch of avatars and numerous new courses from IRONMAN® and IRONMAN® 70.3® Triathlon Series, Haute Route, and Epic Series events from around...

Cycling

Press Releases

Products

Triathlon

November 3, 2022

LIVALL launch the PikaBoost – for seamless and effective e-bike conversion

3rd November 2022, 2pm GMT, UK /ENDURANCE SPORTSWIRE/ – LIVALL, the team behind the world’s first smart cycling helmet, have expanded their smart cycle technology into the fast-growing e-bike market. The PikaBoost easily attaches to most bike categories and brands, transforming any bike into an e-bike in under 30 seconds. The tool-free...

Cycling

Press Releases

Products

November 3, 2022

ROUVY disrupts Cycling eSports with OmniMode technology using real 360° videos

Prague, Czech Republic / November 3rd, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY’s unique digital platform is based on augmented geo-synced video routes which bring the real-life cycling and triathlon competition experience to your home. Over the last few years, ROUVY has given anyone the possibility to try La Vuelta, Tour de Suisse,...

Cycling

Press Releases

Products

Triathlon

November 3, 2022

Spring racing at 2nd GFNY Colonia-Uruguay this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Colonia Uruguay offers racers a fast long course of 148.2km with 1122m of climbing where the wind will be the main challenge aside from the high pace. Colonia del Sacramento is an irresistibly picturesque town enshrined as a Unesco World Heritage site. Its Barrio Histórico,...

Cycling

Events

Press Releases