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

May 23, 2022

ROUVY Ghosts’ Comeback – 10 Virtual Pace Bots to make the indoor cycling session more fun

Prague, Czech Republic / May 23, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY, is an application and platform that turns what was formerly known as mundane stationary training into a fun and motivating virtual adventure around the world. The overlaid 3D avatars and objects, atop the real-life geo-synced video footage, create a realistic...

Cycling

Press Releases

Products

Triathlon

May 23, 2022

2023 UTMB® World Series to broaden offering to runners with the confirmation of a brand-new event in Thailand

Chamonix, France. 23 May 2022 /ENDURANCE SPORTSWIRE/ – With the inaugural UTMB World Series now in full swing with 25 events scheduled in 2022 and thousands of runners across the world signed up and ready to compete, the organizers are already looking ahead to 2023 and the continued expansion of the...

Events

Press Releases

Running

May 23, 2022

Expedition Oregon 2022 Takes Adventure Racing to a new Level of Endurance

/ENDURANCE SPORTSWIRE/ - Expedition Oregon 2022 was a race which will live long in the memory of the teams who raced and survived it, and of the many thousands of fans who were gripped by the online race coverage. It was a true expedition, a great competition, and lived up...

Events

Press Releases

May 23, 2022

Microsoft Teams integration for CorporateFitness.app released

May 23, 2022 /ENDURANCE SPORTSWIRE/ – CorporateFitness.app is proud to announce the immediate availability of its Microsoft Teams integration. The brand new Microsoft Teams integration brings your corporate step or fitness challenge right inside the Microsoft Teams app everyone is already using all day long! Using this new integration your team can...

Press Releases

Products

May 23, 2022

Registration is now open for the 5th Annual Tiger 10K

Baton Rouge, LA (May 23, 2022)/ENDURANCE SPORTSWIRE/ – Registration for the Fifth Annual Our Lady of the Lake Tiger 10K is now open. The event, which features a 10K, 5K and a Kids Mile, will take place Sunday, Dec. 4, at the South Gates of Tiger Stadium. Thousands of runners, joggers...

Events

Press Releases

Running

May 23, 2022

Run Tucson Announces Prize Money for Grand Canyon Trail Half Marathon

/ENDURANCE SPORTSWIRE/ - The November 4th Grand Canyon Trail Half Marathon is pleased to announce that it is offering prize money in 2022. With a loop course through the scenic Kaibab National Forest, the Trail Half Marathon will begin and end in Grand Canyon Village, located just a few miles...

Press Releases

Running

May 22, 2022

Tulsa, Oklahoma’s Sam Carr and Boulder, Colorado’s Maggie Rusch Victorious at Second Edition Of Certified Piedmontese Beef IRONMAN Tulsa Triathlon

TULSA, Okla. (May 22, 2022) /ENDURANCE SPORTSWIRE/ - Northeastern Oklahoma provided a stunning backdrop for the second edition of the Certified Piedmontese Beef IRONMAN triathlon on Sunday, May 22. Athletes from around the world started the Certified Piedmontese Beef IRONMAN triathlon, it was local Tulsa, Okla. athlete Sam Carr from...

Events

Press Releases

Triathlon

May 22, 2022

Jason West (USA) And Jackie Hering (USA) Claim Victories At 2022 Sunbelt Bakery IRONMAN 70.3 North American Championship Chattanooga Presented by Mckee A Family Bakery

CHATTANOOGA, Tenn. (May 22, 2022) /ENDURANCE SPORTSWIRE/ - The Scenic City and southeastern Tennessee and northern Georgia provided a stunning backdrop for the 2022 Sunbelt Bakery IRONMAN® 70.3® North American Championship Chattanooga presented by McKee A Family Bakery triathlon. With some of triathlon’s best on hand,  Jason West (USA) won the...

Events

Press Releases

Triathlon

May 22, 2022

Runners Rejoice at 13th Annual Life Time Chicago Spring Half Marathon and 10K

CHICAGO – (May 22, 2022) /ENDURANCE SPORTSWIRE/ - The 13th annual Life Time Chicago Spring Half Marathon & 10K returned triumphantly after a two-year hiatus on Sunday, May 22 as more than 5,000 runners hailing from 47 states and 27 countries toed the start line at Maggie Daley Park downtown...

Press Releases

Running