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

June 15, 2022

Showcased

First Run Show USA Los Angeles, opens box office with special ticket offer

/ENDURANCE SPORTSWIRE/ –Following the hugely successful launch of the Run Show USA in Chicago at the beginning of the month, the ticket box office for the Run Show USA Los Angeles opened this week with a special ticket offer available, offering 1,000 FREE tickets to the running expo. Visitors simply need...

Press Releases

Running

Trade Shows

June 15, 2022

Gnarly Nutrition Launches ‘Fuel For Life Scholarship’ to Provide Funding for Endurance Sport Groups

Salt Lake City, UT (June 15, 2022) /ENDURANCE SPORTSWIRE/ - Gnarly Nutrition is excited to announce the launch of its Fuel for Life Scholarship to provide funding for endurance sports groups. If chosen as a winner, the funding will be used to help the organization create community, attend races or...

Cycling

Giving

Press Releases

Running

June 15, 2022

Hundreds of Children to Experience the Benefits of Exercise Through New Training Program from Life Time and City Parks Foundations

NEW YORK (June 15, 2022) /ENDURANCE SPORTSWIRE/ - To inspire New York City kids to get outdoors this summer and benefit from exercise and healthier eating, City Parks Foundation and Life Time Foundation have partnered to introduce the first-ever Life Time Foundation New York City Kids Run – a running...

Giving

Press Releases

June 15, 2022

NOCCO Welcomes Social Media Sensation and Former D1 Athlete Noah Beck to Brand Ambassador Program

LOS ANGELES (June 15, 2022)/ENDURANCE SPORTSWIRE/ – NOCCO – the no carbs, branched-chain amino acids (BCAA) beverage company – has just announced their partnership with Noah Beck, social media phenom and former D1 Athlete, as he is added to the brand ambassador program. ”We are thrilled to have an exciting talent...

Press Releases

Products

Sponsorship

June 15, 2022

Professional Triathlete, Timothy O’Donnell, Qualifies for IRONMAN World Championships 15 Months After Harrowing On-Course Heart Attack

CAMBRIDGE, Mass.—June 15, 2022 /ENDURANCE SPORTSWIRE/ - Professional triathlete, Timothy O’Donnell, yesterday qualified for the IRONMAN World Championships in Kailua-Kona, Hawaii, with a time of 8:10:07 and a third-place finish at IRONMAN Des Moines. This marks the 11th time O’Donnell has qualified for the World Championships, but is remarkable in...

Events

Press Releases

Triathlon

June 15, 2022

Expedition Canada Takes World Series Adventure Racing Back to its Roots

/ENDURANCE SPORTSWIRE/ – Expedition Canada attracted international teams from 7 different nations to the town of Kelowna in British Columbia, Canada, for the 5th event in the 2022 Adventure Racing World Series. After staging a Demonstration Race last year, the event stepped up to full AR World Series membership this year,...

Events

Press Releases

June 14, 2022

GFNY Super Sunday results

New York City, June 14, 2022/ENDURANCE SPORTSWIRE/ – For the inaugural edition of GFNY Lourdes Tourmalet (France) racers tackled 157km with 4064m of climbing in the legendary French Pyrenees. Col d’Aspin was the first real obstacle of the day - and it didn’t disappoint. The peloton split into groups with the...

Cycling

Events

Press Releases

June 14, 2022

Nix Biosensors Partners With SweatWorks to Revolutionize Hydration Monitoring

BOSTON, MASS. — JUNE 14, 2022/ENDURANCE SPORTSWIRE/ – Nix, the biosensor company delivering health and wellness data to consumers, today announces a partnership with SweatWorks, the leading digital technology agency for the fitness and wellness industry. As part of the partnership, SweatWorks will be responsible for the designing and building the hardware...

Business

Press Releases

Products