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

November 15, 2022

Austin Marathon’s Philanthropic Program Awarded Grant From The Moody Foundation

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ - Austin Marathon Gives (formerly Austin Gives Miles), the philanthropic program of the Ascension Seton Austin Marathon, proudly announces The Moody Foundation as its presenting sponsor for the 8th consecutive year. The Moody Foundation has given nearly $2 million to Austin Marathon Gives since 2016. The...

Events

Giving

Press Releases

Running

Sponsorship

November 14, 2022

Triathlon Fall Fest calls on triathletes to train and race with Roth champion, Magnus Ditlev and a Challenge Family all-star cast

Almere, Netherlands / November 14th, 2022 /ENDURANCE SPORTSWIRE/ – The Triathlon Fall Fest on ROUVY is a series of unique online events that gives both experienced athletes and newbies the opportunity to train, compete and learn with and from some of the best professional triathletes in the world. There'll be rides...

Events

Press Releases

Triathlon

November 14, 2022

Speed Hound Enters Into Multiyear Agreement with SBT GRVL

Menlo Park, CA (November 14, 2022) /ENDURANCE SPORTSWIRE/ - While Speed Hound is on a mission to provide every day athletes with the tools they need to achieve the impossible, they’re also deeply committed to supporting other organizations within the racing community. Speed Hound has found a like-minded partner in...

Cycling

Events

Giving

Press Releases

Sponsorship

November 13, 2022

Roberts Wins Fourth World Title and Dowell Silver at the 2022 BMX Freestyle World Championships

November 13, 2022 /ABU DHABI, United Arab Emirates /ENDURANCE SPORTSWIRE/ - The 2022 UCI Urban Cycling World Championships concluded with the BMX Freestyle Park Finals. Twelve men and twelve women competed in the finals, with three men and three women from Team USA making the big show. Elite Women’s Finals...

Cycling

Events

Press Releases

November 12, 2022

Christopher, Dowell, and Sandoval Transfer to Elite Men’s BMX Freestyle Finals at the 2022 Urban Cycling World Championships

November 12, 2022, ABU DHABI, United Arab Emirates – Justin Dowell (Virginia Beach, V.A.; Hyper BMX), Brian Fox (Commerce, Ga.; Woodward Camp), Daniel Sandoval (Corona, Calif.; Free Agent Bikes), Marcus Christopher (Canton, Ohio; DK Bicycles), and Jacob Thiem (Kennard, Neb.; Free Agent Bikes) all competed in the Elite Men’s BMX Freestyle semi-finals today at the 2022...

Cycling

Events

Press Releases

November 11, 2022

2023 IRONMAN 70.3 Mont-Tremblant Complet Et Accueillera Le Plus Grand Nombre D’athlètes De L’histoire De L’événement; 2023 IRONMAN 70.3 Mont-Tremblant Sold Out and Will Host the Largest Number of Athletes in The Event’s History

MONT-TREMBLANT, QUEBEC, CANADA (Nov. 11, 2022) /ENDURANCE SPORTSWIRE/ - The 2023 IRONMAN® 70.3® Mont-Tremblant triathlon taking place on June 25, 2023, has officially sold out. The 2023 event will play host to the largest number of athletes in the events history with over 3,600 athletes registered to race. In addition...

Events

Press Releases

Triathlon

November 11, 2022

Five Elite Men Advance to BMX Freestyle Semi-Finals at the 2022 Urban Cycling World Championships

November 11, 2022 /ENDURANCE SPORTSWIRE/ – Dowell, Fox, Sandoval, Christopher, and Thiem qualified in the top 24, transferring to the next round of the World Championships. ABU DHABI, United Arab Emirates – Competition began on Friday for the Elite Men’s BMX Freestyle Park at the 2022 UCI Urban Cycling World Championships. 63...

Cycling

Events

Press Releases