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

September 23, 2022

RunSignup Announces New Free Mobile Timing App

September 23, 2022 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration provider for U.S. endurance events, announces its RaceDay Mobile Timing App for timing of smaller events and backup for chip-timed events. Through the convenient use of Android and Apple phones and tablets, event timers are able to use...

Cycling

Press Releases

Products

Running

Triathlon

September 23, 2022

Shmidt Finishes Fifth in Junior Men’s Road World Championships

WOLLONGONG, Australia /ENDURANCE SPORTSWIRE/ – It was a rainy day in New South Wales for the Junior and U23 Men’s Road Races on the fifth day of the 2022 UCI Road World Championships in Wollongong, Australia. Artem Shmidt (Cumming, Ga.; Hot Tubes Development Cycling) was the standout rider of the day for Team USA,...

Cycling

Events

Press Releases

September 23, 2022

The Milkman Triathlon is coming back to Madison, WI on June 18th, 2023

Madison, WI /ENDURANCE SPORTSWIRE/ – Madison may be known for the University of WI-Madison and its incredible dairylands in the area, but it is also known as one of the most active and fit cities in the United States. The Milkman Triathlon will serve as Madison's premier endurance event in June...

Events

Press Releases

Running

Triathlon

September 22, 2022

L’Étape Brasil goes virtual with Santander and Mitsubishi Motors as main sponsors

São Paulo, Brazil / September 22, 2022 /ENDURANCE SPORTSWIRE/ - For the first time, the Campos do Jordão circuit of L'Étape Brasil will be ridden 1:1 simultaneously in the real and in the virtual world on ROUVY. One of the great attractions of the L'Étape Brasil by Tour de France...

Cycling

Events

Press Releases

September 22, 2022

Tulsa, Oklahoma adds IRONMAN 70.3 Triathlon in 2023; Joins Certified Piedmontese Beef IRONMAN Tulsa Triathlon, Part of The Vinfast IRONMAN U.S. Series, for a Full Day of Racing

TULSA, Okla. / TAMPA, Fla. (Sept. 22, 2022) – IRONMAN announced today a new IRONMAN® 70.3® triathlon will be added in Tulsa, Okla. Providing for additional racing opportunities in the spring of 2023. The inaugural IRONMAN 70.3 Tulsa half-distance race will take place on Sunday, May 21 in conjunction with...

Events

Press Releases

Triathlon

September 22, 2022

Collin Chartier Leads Team USA’s Charge For Victory At PTO US Open

Dallas, Texas /ENDURANCE SPORTSWIRE/ – American Collin Chartier led the home charge in the Dallas heat by winning the first-ever PTO US Open. With US Olympic legend and Dallas native Michael Johnson watching on – and temperatures touching 95°F and 51% humidity – Chartier powered past compatriot Sam Long on the penultimate run...

Events

Press Releases

Triathlon

September 22, 2022

Full Speaker Lineup Revealed for the 2022 Running USA Accelerator Series

(September 22, 2022) /ENDURANCE SPORTSWIRE/ - Running USA and Race Roster are excited to announce the full speaker slates for three previously unveiled Fall 2022 Accelerator Series events. Registration is open and attendees are urged to sign up today to save a spot. The Accelerator Series events feature compelling speakers...

Press Releases

Running

Trade Shows

September 22, 2022

Team Toyota Tundra captures second straight U.S. Adventure Racing Association National Championship

/ENDURANCE SPORTSWIRE/ - Mari Chandler, Brian Mayer and Justin Bakken of Team Toyota Tundra won their second consecutive U.S. Adventure Racing Association (USARA) National Championship in convincing fashion. This year’s 30-hour championship race covered 115 miles between Mammoth Lakes and Bishop, California, with 38 teams completing multiple stages of biking,...

Events

Press Releases

September 22, 2022

Lucra Sports to be Official Partner of Spartan

BOSTON, MASS. (9/22/22)/ENDURANCE SPORTSWIRE/ – Spartan, the world's leading endurance sports and extreme wellness brand, has announced that Lucra Sports will be the official partner of Spartan for the remainder of the 2022 U.S. Season. “As both a professional sport operating in 30+ countries, and one of the world’s largest mass...

Press Releases

Running

Sponsorship