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

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

March 16, 2022

The WaterMonster pours it on for 2022

Kerrville, Texas (March 2022) /ENDURANCE SPORTSWIRE/ - With Spring closing in, Event Hydration Solutions, Inc has been working hard behind the scenes to offer new exciting accessories for the WaterMonster Tank water refill stations.  Announcing the FillSpout, a new large 1” water dispenser that will help to quickly refill smaller...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

March 16, 2022

Registrations Open For 2XU Malibu Triathlon 2022

March 16, 2021 /ENDURANCE SPORTSWIRE/ - 2XU Malibu Triathlon has officially opened registration for 2022. The iconic event will take place across the weekend of September 17-18, with the Olympic distance event on Saturday and Classic distance on Sunday. The Olympic distance is a 1.5k Ocean swim, a 40k out and...

Events

Press Releases

Triathlon

March 15, 2022

Three GFNY races in Quito in 2022

NEW YORK CITY, March 15, 2022 /ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series is offering three races in Ecuador’s capital Quito in 2022: the city marathon, a mass participation road cycling race and a MTB Marathon. City officials chose GFNY due to its experience in producing international endurance sports...

Cycling

Events

Press Releases

March 15, 2022

Internationally renowned Gravity Media appointed as broadcast partner for Sub7 Sub8

Sydney, Australia – 15th March, 2022 /ENDURANCE SPORTSWIRE/ - Mana Sports and Entertainment Group today announced Gravity Media as the broadcast partner for the Pho3nix Sub7 and Sub8 Project, powered by Zwift, set to take place on the 5th or 6th of June 2022 at the Dekra Lausitzring in Germany....

Business

Events

Press Releases

Triathlon