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

March 7, 2023

Carmel Marathon Presented by Franciscan Health Sold Out for Third Consecutive Year

CARMEL, Ind. (March 7, 2023) /ENDURANCE SPORTSWIRE/ – For the third consecutive year, the Carmel Marathon Presented by Franciscan Health has sold out. The 13th annual Carmel Marathon Weekend, held on Saturday, April 8, 2023, in Carmel, Indiana, also hosts the Carmel Half Marathon, Indiana Spine Group 10K, Indiana Members Credit...

Events

Press Releases

Running

March 7, 2023

Gran Fondo Florida Moves to Dade City, Florida for 2023

Gettysburg, PA – March 7, 2023 /ENDURANCE SPORTSWIRE/ – The SUAREZ Gran Fondo National Series is proud to announce the 2023 Gran Fondo Florida will be hosted by Dade City Brewhouse and start and finish in Dade City, Florida, on March 19, 2023. The annual event previously started and finished in San...

Cycling

Events

Press Releases

March 4, 2023

The Malacara Race – Adventure on a Magic Island as the ARWS Returns to Brazil

/ENDURANCE SPORTSWIRE/ – After an amazing start to the 2023 Adventure Racing World Series with The Legend race in Australia, it’s now time for the Malacara race in Brazil. The ARWS moves straight from the Snowy Mountains of Australia to one of Brazil’s most famous beach resorts! The Malacara race is...

Events

Press Releases

March 3, 2023

Ultra X launches their latest race in Europe’s most exotic island

/ENDURANCE SPORTSWIRE/ – Global ultra-marathon events series, Ultra X launch their latest race, a 2 day, 110km race around in Madeira, adding to their collection of bucketlist races. Ultra X 110 Madeira is a multi-stage ultra-marathon taking place over two days. There is also an option for competitors to run the...

Events

Press Releases

Running

March 3, 2023

Expo Vendor Registration Now Open

WRIGHT- PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ - Vendor registration for the Air Force Marathon Health and Fitness Expo is now open. Expo vendors will have the opportunity to promote and sell their products and services to thousands of athletes, spectators and health and fitness enthusiasts. The expo offers...

Events

Press Releases

Running

Trade Shows

March 3, 2023

Dick Hoyt Memorial “Yes You Can” Run Together running and walking event comes to Hopkinton this May

HOPKINTON, Mass. /ENDURANCE SPORTSWIRE/ – On May 27, the Hoyt Foundation and The Hoyt Family will host the first-ever Dick Hoyt Memorial “Yes You Can” Run Together race in Hopkinton, Mass. The event begins at 10 a.m. and features a five-mile run and a two-mile walk. Funds raised by the event...

Events

Giving

Press Releases

Running

March 2, 2023

5th GFNY Monterrey this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Monterrey opens the jam packed 2023 GFNY Mexico season. Riders get to compete on a 137km course with an elevation gain of 1386m and a hilltop finish on iconic Chipinque. Start and finish will be at Macroplaza which true to its name is the world's...

Cycling

Events

Press Releases