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

March 24, 2022

MANA Athletes Kick Start 2022 In Winning Style

/ENDURANCE SPORTSWIRE/ - MANA Sports and Entertainment Group athlete Kat Matthews has kicked off her 2022 racing season with a win at Ironman 70.3 Lanzarote. After riding into the lead on the toughest bike course on the circuit, the British athlete then broke the tape with a three-minute lead over...

Press Releases

Running

Sponsorship

Triathlon

March 24, 2022

The Giant Race Series Presented by Alaska Airlines is Partnering With BANDAI NAMCO Entertainment America Inc. to Launch the 2022 PAC-MAN Virtual Challenge

San Francisco, California /ENDURANCE SPORTSWIRE/ -  Giants Enterprises, the development and entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, announced a brand new, worldwide PAC-MAN Virtual Challenge today as part of the partnership between the Giant Race Series presented by Alaska Airlines and leading interactive entertainment company, BANDAI NAMCO...

Events

Press Releases

Running

Sponsorship

March 24, 2022

Inaugural GFNY Cannes this Sunday

/ENDURANCE SPORTSWIRE/ - GFNY Cannes will be the first of six GFNY in France in 2022 and will cover a racecourse of  111 km with 2013m of climbing. Cannes is among the most glamorous places on earth, with the jet-set letting loose on the sandy beaches, fine restaurants and bars,...

Cycling

Events

Press Releases

March 23, 2022

“Taste of the Spring Classics” – Experience the 5 iconic cycling Monuments from home

Zottegem, Belgium / March 23, 2022 /ENDURANCE SPORTSWIRE/ - Animotion BV presents the "Taste of the Spring Classics" on ROUVY - a series of 5 races on 1:1 real digitized routes for virtual cycling that correspond to 5 major spring European road racing events in Belgium, the Netherlands and France....

Cycling

Events

Press Releases

March 23, 2022

BOA Nutrition Inks Deal with Los Angeles FC Forward Christian Torres

RALEIGH, N.C. (March 23, 2022)/ENDURANCE SPORTSWIRE/ - BOA Nutrition announced today it has signed a deal with 17-year-old forward Christian Torres of the Los Angeles Football Club (LAFC). Torres will be featured in the company’s brand marketing campaigns beginning this year. BOA uses a high-powered oral aerosol blast to deliver...

Press Releases

Sponsorship

March 23, 2022

Tasmania’s Dragon Trail Delivers World Class Riding and a Carnival Atmosphere

/ENDURANCE SPORTSWIRE/ - The Dragon Trail MTB Stage Race returned to the trails, hills and forests of North-East Tasmania for a second edition last week, and delivered its unique mix of world class flow trails, X-country adventure riding, challenge and community. Over two hundred riders, from all over Australia, gathered at...

Cycling

Events

Press Releases

March 23, 2022

Tide of runners rolling through T-town for 10th Tuscaloosa Tourism and Sports Half Marathon and Publix 5k

TUSCALOOSA, AL. /ENDURANCE SPORTSWIRE/ -  A tide of runners will roll through T-town Saturday for the 10th year of the Tuscaloosa Tourism and Sports Half Marathon and Publix 5K. Nearly 1000 runners from 28 different states have registered for the event on March 26. The Tuscaloosa Tourism & Sports Half Marathon...

Events

Press Releases

Running

March 23, 2022

Champions Return For Fast And Furious Head-to-Head Battles in Arena Games Triathlon powered by Zwift

/ENDURANCE SPORTSWIRE/ - Four former champions and an Olympic gold medallist are among the first wave of athletes confirmed for the Arena Games Triathlon powered by Zwift. There are two monumental clashes in the offing as Jess Learmonth, the first ever Arena Games winner, and fellow Brit Beth Potter, who took...

Events

Press Releases

Triathlon