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

March 18, 2022

Sea Otter Australia Announces 2023 Dates

/ENDURANCE SPORTSWIRE/ - The team at Sea Otter Australia has been working full throttle behind the scenes to re-shape the event so that Sea Otter will provide a more contemporary and more impactful experience. Our commitment to design and deliver a truly unique community cycling festival is resolute. As a...

Cycling

Events

Press Releases

March 18, 2022

Gourdy’s Pumpkin Run Partners with Girls On The Run For Third Year

NEW YORK /ENDURANCE SPORTSWIRE/ - The fall-favorite race has again teamed up with Girls on the Run for a third year in a row, after raising a combined total of over $400,000 for the National Charity Partner in the previous two years. Gourdy’s Pumpkin Run will continue donating $1 per...

Events

Giving

Press Releases

Running

March 17, 2022

GFNY opens 2022 with two beach resort races this Sunday

/ENDURANCE SPORTSWIRE/ - The 4th GFNY Punta del Este is based in South America’s most famous beach resort where riders competing in the long competitive course will race 172.8 km with an elevation of 1773 m. The flat to hilly course offers plenty of opportunity for racers to make a...

Cycling

Events

Press Releases

March 17, 2022

2022 IRONMAN 70.3 Broadcast Coverage Schedule on Outside TV Announced

TAMPA, Fla. (March 17, 2022) /ENDURANCE SPORTSWIRE/ - IRONMAN is excited to announce the live broadcast coverage schedule for the 2022 IRONMAN® 70.3® Triathlon Series on Outside TV, featuring 11 IRONMAN 70.3 triathlon events from across globe. Beginning on April 2, with the 2022 Athletic Brewing IRONMAN 70.3 Oceanside triathlon, viewers will be...

Events

Press Releases

Triathlon

March 17, 2022

New Professional Criterium Series Announces Official Name

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - The newest cycling series in the U.S. officially has a name, the American Criterium Cup. The core group of cycling stakeholders, including criterium race directors, cycling teams, and USA Cycling, which announced the full ten-event calendar in January, is proud to announce the official series...

Business

Cycling

Events

Press Releases

March 17, 2022

13 US adventure races named as USARA Regional Championships

/ENDURANCE SPORTSWIRE/ - The U.S. Adventure Racing Association (USARA) is excited to announce its list of 13 races that have been named 2022 USARA Regional Championships. The USARA Regional Championships were created to catalyze a more competitive U.S. race scene and to showcase the geographic reach of the sport of adventure...

Events

Press Releases

March 17, 2022

ŠKODA eMČR 2022 – the National Championships of the Czech Republic in Virtual Cycling with the local stars at the start

Prague, March 17, 2022 /ENDURANCE SPORTSWIRE/ - Last year, the premiere of the virtual cycling championships took place; this year, the four-part international series, Visegrad 4 e-CUP was added. Everything will now culminate in the second fight for Czech titles within the ŠKODA eMČR. Last year, Daniel Turek and Martina Sáblíková won...

Cycling

Events

Press Releases

March 17, 2022

2022 Molokaʻi-2-Oʻahu Paddleboard World Championships Presents Racing Options for 2022 as Hawaii Loosens Restrictions

HONOLULU, HI (March 17,2022) /ENDURANCE SPORTSWIRE/ - Molokaʻi-2-Oʻahu Paddleboard World Championships (M2O) will celebrate the sport of paddling this summer with the introduction of its first annual Blue Water Hawaiian Classic on July 24th   and the triumphant return of the M2O Virtual Edition 3.0 the weekend of July 31st....

Events

Press Releases