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

August 9, 2024

Super League Triathlon Brownlee Racing Back Best Of British To Fire Them to supertri Title

LONDON, UK/ENDURANCE SPORTSWIRE/ – Brownlee Racing believe their British legacy can lift them to a first title in supertri League. Brownlee Racing, the new endurance racing team launched by three-time Olympic medallist Jonny Brownlee and his double-Gold winning brother, Alistair, are entering supertri for the first time after acquiring a team...

Events

Press Releases

Triathlon

August 9, 2024

The Numbers Behind The City2Surf

SYDNEY, Australia / TAMPA, Fla. (August 9, 2024) /ENDURANCE SPORTSWIRE/ – The City2Surf returns to the streets of Sydney this Sunday 11 August, with tens of thousands of runners preparing to take part in the world-famous event. The 2024 City2Surf will be a record-breaking day, with the event selling out...

Events

Press Releases

Running

August 9, 2024

Brooksee Deploys Industry-Leading Laurel Timing Technology at 2024 Ragnar Wasatch Back and Road Northwest Passage, Kicking Off National Expansion

SALT LAKE CITY, Utah /ENDURANCE SPORTSWIRE/ – Brooksee, the endurance event production and service company behind the Las Vegas Marathon, Portland Marathon, Mesa Marathon and REVEL Race Series, recently deployed its Laurel timing technology at this year’s Ragnar Wasatch Back, the first time the race has featured live tracking and...

Business

Events

Press Releases

Running

August 9, 2024

Bucks County Classic gearing up for 20th Anniversary Edition on September 8th

/ENDURANCE SPORTSWIRE/ - The excitement is building for the 20th Anniversary Edition of the Bucks County Classic set for Sunday September 8th. Organized by MSH Productions LLC the event has grown from a race for professionals only to include opportunities for amateur racers and community members to participate in the...

Cycling

Events

Press Releases

August 9, 2024

Blistering Pace Race Management Welcomes Hannah Sconzo as Director of Marketing

NAPA, CALIFORNIA /ENDURANCE SPORTSWIRE/ - Blistering Pace Race Management is thrilled to announce that Hannah Sconzo has joined the staff as Director of Marketing, bringing valuable perspective and expertise to the organization’s list of clients and events. Sconzo brings a wealth of experience in creative marketing both in the road...

Events

Press Releases

Running

August 9, 2024

ASICS Falmouth Road Race Annual Track Festival To Debut First-Ever Drone Show

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ - The 2024 ASICS Falmouth Road Race has announced the addition of a drone show and opening ceremony event to their 2024 Falmouth Track Festival. The festival will be taking place on Friday, Aug. 16 starting at 6 p.m. at James T. Kalperis Track, kicking off...

Events

Press Releases

August 9, 2024

Austin International Half Set to Host Pro Field With Prize Purse

AUSTIN, TX — August, 9 , 2024 /ENDURANCE SPORTSWIRE/ – The Austin International Half, formerly known as the 3M Half Marathon, is now accepting applications from elite runners to compete for a $10,000 prize purse. On January 19, 2025, thousands of athletes will converge in Austin, Texas, for this popular...

Events

Press Releases

Running

August 8, 2024

The IRONMAN Group Promotes Keats McGonigal to Managing Director of North America

TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - The IRONMAN Group is pleased to announce Keats McGonigal has been promoted to Senior Vice President & Managing Director, North America. Starting as an intern with the company and steadily progressing to more complex and diverse leadership roles during his tenure, McGonigal brings a significant...

Events

Press Releases

Triathlon