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

November 10, 2022

Roberts, Benegas, and Marino Transfer to BMX Freestyle Finals at the 2022 Urban Cycling World Championships

ABU DHABI, United Arab Emirates /ENDURANCE SPORTSWIRE/ – The Elite Women’s BMX Freestyle Park Qualifying kicked off the 2022 UCI Urban Cycling World Championships. Twenty-five women were on the start list, six representing the United States. Team USA women’s roster included: Hannah Roberts (Buchanan, Mich.; Hyper BMX), Perris Benegas (Reno, Nev.; Haro BMX),...

Cycling

Events

Press Releases

November 10, 2022

Publix Battleship 12K honors our military this Sunday

SPANISH FORT, AL. /ENDURANCE SPORTSWIRE/ – Runners from across the country will honor those who serve this Sunday at the 7th Annual Publix Battleship 12K in Spanish Fort, AL. A Veterans Day tradition for many, so far over 2300 participants from 23 states & Canada have registered. The patriotic run takes...

Events

Press Releases

Running

November 10, 2022

Orlando Selected to Host The 2024 U.S. Olympic Team Trials – Marathon

Orlando, FL /ENDURANCE SPORTSWIRE/ – Together with the Greater Orlando Sports Commission, the City of Orlando, and Orange County, Track Shack is thrilled to announce that Orlando will be the host city for the 2024 U.S. Olympic Team Trials - Marathon. The Trials will be Saturday, February 3, 2024, in downtown...

Events

Press Releases

Running

November 10, 2022

Super Sunday: GFNY closes 2022 with three races on same day

/ENDURANCE SPORTSWIRE/ GFNY Cozumel The 9th GFNY Cozumel is the largest bike race in the Americas south of NYC. The long course offers riders a flat and furiously fast 157km around the tropical paradise island of Cozumel. Like no other, the race combines panoramic views of the beautiful turquoise ocean...

Cycling

Events

Press Releases

November 10, 2022

Australia’s Capital City to Host Challenge Canberra 2023

/ENDURANCE SPORTSWIRE/ - Australia’s capital city is home to the country’s newest international middle distance triathlon with Challenge Family’s announcement today of Challenge Canberra, taking place on 26 November 2023. Long synonymous with triathlon, Canberra has become a preferred training destination for many with its extensive network of bike paths...

Events

Press Releases

Triathlon

November 9, 2022

2023 XTERRA World Championship Set for Sept. 23 in Trentino, Italy

/ENDURANCE SPORTSWIRE/ – The 2023 XTERRA World Championship off-road triathlon will return to Trentino, Italy for the second straight year on Saturday, September 23, at Lake Molveno. The new date, one week earlier than in 2022, comes almost exactly a month after the XTERRA USA Championship, where 58 slots will be...

Events

Press Releases

Triathlon

November 9, 2022

Sprint finish at GFNY Colonia- Uruguay

New York City, November 9, 2022 /ENDURANCE SPORTSWIRE/ – Colonia - Uruguay hosted the second edition of GFNY Colonia this past Sunday. The racecourse was 148.2km with an elevation gain of 1122m. Under clear skies with perfect temperatures yet strong 30km/h cross winds, the race started off fast. It was at...

Cycling

Events

Press Releases

November 9, 2022

Roark Run Amok Launches A Capsule Collection with Artist Travis Weller

LAGUNA BEACH, CA./ENDURANCE SPORTSWIRE/ - Roark announces the launch of a capsule collection created in collaboration with longtime co-conspirator and friend, the artist and ultra distance runner, Travis Weller. As part of Roark’s Run Amok collection, which provides a unique vision of trail running and functional activewear born from adventure...

Events

Press Releases