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

April 27, 2022

ROUVY to host a 3rd Virtual Edition of The German UCI Classic ESCHBORN-FRANKFURT

Frankfurt, Germany / Apr 27, 2022 /ENDURANCE SPORTSWIRE/ – In the transition from the spring monuments to the national tours, there will once again be a battle between the pro classics specialists and the sprinters' elite. In a total of 20 selected teams, with BORA – hansgrohe being the only German...

Cycling

Events

Press Releases

April 27, 2022

Age Groups for USA Cycling Gran Fondo National Championships Announced

(Gettysburg, PA – March 27, 2022)/ENDURANCE SPORTSWIRE/ – Gran Fondo National Series, the organizer for the official USA Cycling Gran Fondo National Championships event, announced new age group categories for the 2022 championships event. Additionally, riders who win their individual age group at nationals will automatically qualify for the 2022...

Cycling

Events

Press Releases

April 27, 2022

Mascot Sports’ First-Ever Oak Run Co. House Launches on April 27 at the Moxy Hotel in Downtown Oakland

OAKLAND, Calif. (April 27, 2022) /ENDURANCE SPORTSWIRE/ - The first-ever Oak Run Co. House powered by Let’s Do This kicks off today at the Moxy Hotel in Downtown Oakland. Created by Mascot Sports, a leader in one-of-a-kind endurance sports experiences in partnership with its Oakland Run Co. platform, the Oak...

Events

Press Releases

Running

April 26, 2022

MANA Athletes Step into The Triathlon Spotlight

/ENDURANCE SPORTSWIRE/ - MANA athlete Magnus Ditlev took second place in his Ironman debut last weekend at Ironman Texas. The Dane exited the 3.8-kilometre swim in 15th place, used his renowned bike strength over 180 kilometres to power into the pointy end despite a tire puncture, and battled eventual winner...

Events

Press Releases

Sponsorship

Triathlon

April 26, 2022

Do Good, Run Better. BibBoards partners with Run Ottawa

/ENDURANCE SPORTSWIRE/ – Run Ottawa is the nation’s leader when it comes to race planning and execution. Run Ottawa is the organization behind the country’s biggest marathon weekend, Tamarack Ottawa Race Weekend taking place May 28-29th. In addition to high-quality races, Run Ottawa has used its events to raise money...

Events

Giving

Press Releases

Products

Running

April 26, 2022

RUSH awarded the ‘Great Canadian’ honour from a Race

Amherstburg, ON; 04/25/22-/ENDURANCE SPORTSWIRE/ – The Canada D’Eh Run is the largest and most bombastic patriotic Canada Day Run in Canada.  Now it can be shared around the world, not just in Amherstburg ON. July 1st, 2022 2,500 participants are expected to Run or Walk 5K in an all red and white celebration.  Known...

Awards

Events

Press Releases

Running

April 26, 2022

Swedish Armed Forces Adventure Team Top the New Adventure Racing World Series Rankings

/ENDURANCE SPORTSWIRE/ – The recent revision of the Adventure Racing World Series rankings saw a new World #1 team announced, improved positions for South American teams, and a significant effect from the Regional rankings around the world.  The top 20 also shows a healthy mix of nationalities, with 10 different...

Events

Press Releases

April 25, 2022

Aging Up, Not Out

Charleston, South Carolina (April 25, 2022)/ENDURANCE SPORTSWIRE/ – Most of the time people hear the word triathlon and think, “WHY?”. Most of the time they also equate any triathlon with an Ironman distance - the longest distance of triathlons (until you get into ultra distances and we’re not going there...

Events

Press Releases

Triathlon

April 25, 2022

Life Time Sea Otter Classic Boosts Monterey County Economy

MONTEREY, CA/ENDURANCE SPORTSWIRE/ – A recent study of 2022 Sea Otter Classic attendees reveals the event’s significant economic impact on Monterey County. Spending associated with the Sea Otter Classic accounted for $71,896,388 in direct and indirect expenditures. “The Life Time Sea Otter Classic is an important event for the cycling industry...

Business

Cycling

Events

Press Releases