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

May 12, 2022

Showcased

Running legend Gary Robbins joins Run Show Chicago lineup

/ENDURANCE SPORTSWIRE/ – Gary Robbins, globally recognised endurance athlete from Chilliwack, BC, will join an all-star lineup at the inaugural Run Show Chicago, set to take place on June 4-5 at the DES Convention Center. Robbins will join Olympic athlete, Carl Lewis, ultramarathoner Dean Karnazes, Mirna Valerio aka The Mirnavator and professional...

Press Releases

Running

Sponsorship

May 12, 2022

Jacky Hunt-Broersma: Aspirational Cancer Survivor & World Record Holder for 104 marathons joins Run Show Chicago line-up

/ENDURANCE SPORTSWIRE/ – Jacky Hunt-Broersma, world renown American amputee ultramarathon runner and cancer survivor from Arizona will join an incredible line up of athletes at the launch of Run Show Chicago set to take place on June 4-5 at the DES Convention Center. Hunt-Broersma will join Olympic athlete, Carl Lewis, running...

Press Releases

Running

Sponsorship

May 12, 2022

Rib Mountain Adventure Challenge, largest US adventure race, returns Memorial Day weekend

/ENDURANCE SPORTSWIRE/ – The Rib Mountain Adventure Challenge returns on May 28, 2022, as the largest adventure race in the United States, with 3-hour, 8-hour and 18-hour editions. Taking place in and around Wausau, Wisconsin, the 2022 Rib Mountain Adventure Challenge has once again sold out, with entries capped at 500...

Cycling

Events

Press Releases

Running

May 12, 2022

New IRONMAN Training Plan Marketplace by Final Surge

/ENDURANCE SPORTSWIRE/ – Final Surge has partnered with IRONMAN to launch the IRONMAN Training Plan Marketplace, allowing athletes training for IRONMAN®, IRONMAN 70.3® and 5150® events to find and utilize training plans created by IRONMAN U Certified Coaches. IRONMAN U coaches have been working with Final Surge to develop training plans...

Events

Press Releases

Products

Triathlon

May 12, 2022

United Rentals and DelMoSports Renew Partnership to Support the US Military during May’s National Military Appreciation Month

Cape May, NJ/ENDURANCE SPORTSWIRE/ – DelMoSports and United Rentals have partnered up again in 2022 to provide active military the opportunity to race in two of DelMoSports’ major events this summer. With United Rentals’ support, DelMoSports will be offering a 50% registration discount at the Atlantic City Triathlon and Tri the...

Giving

Press Releases

Sponsorship

Triathlon

May 11, 2022

Outdoor rides from Garmin devices added to ROUVY CAREER for more training fun and better motivation

Prague, Czech Republic / May 11, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY enables anyone to travel the world from home, simulating the outdoor environment indoors via the unique mixed-augmented reality technology. From Norway to South Africa, from Brazil to Japan, across the US, Europe to New Zealand, the whole globe is available in...

Cycling

Press Releases

Products

May 11, 2022

Darn Tough Vermont (R) Becomes Official Sock Partner for US Trail Running Conference

Estes Park (May 11, 2022) - Active at Altitude, organizers of the US Trail Running Conference, have announced that Darn Tough Vermont has become the Official Sock Partner of the 2022 Conference. Darn Tough Vermont is an American manufacturer of premium all-weather running, outdoor and lifestyle socks, backed up by...

Press Releases

Running

Sponsorship

Trade Shows

May 11, 2022

Showcased

I Ran the D 5K Celebrates Detroit Sports & Raises Funds for Pediatric Brain Cancer

DETROIT /ENDURANCE SPORTSWIRE/ - A Detroit sports fan’s dream, the I Ran the D 5k, presented by Bally Sports Detroit, brought together all four of Detroit’s professional sports teams – Tigers, Red Wings, Pistons and Lions – to raise money for the ChadTough Defeat DIPG Foundation which supports pediatric brain...

Events

Press Releases