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

November 17, 2023

The Carlsbad Marathon, Half Marathon and 5K Offers Unique LEGOLAND® Race Location for Kids Marathon Mile

Carlsbad, Calif. — The Carlsbad Marathon, Half Marathon and 5K, produced by In Motion Events, returns on Jan. 14 for another year of scenic oceanfront running. One day before the event, on Jan. 13, the Kids Marathon Mile will be taking place at LEGOLAND® California Resort, before the doors open...

Events

Press Releases

Running

November 17, 2023

Exploring the Mountains of Mexico with La Ruta Madre Adventure Race

/ENDURANCE SPORTSWIRE/ – La Ruta Madre Expedition Race starts on Saturday and the new ARWS Demonstration race will give teams the chance to explore the mountains and canyons of Nuevo Leon province in Mexico. Teams from the US, Canada and Mexico can expect a great adventure on a tough 500km...

Events

Press Releases

November 17, 2023

BibRave Helps Strava Shine at the New York City Marathon

New York, NY /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently crafted an engaging weekend of events at the New York City Marathon for the connected fitness platform, Strava. The multi-day event brought together athletes, creators, and spectators to celebrate running and women’s sports. The weekend of...

Events

Press Releases

November 17, 2023

Over 3000 racers at 10th edition of GFNY Cozumel

New York City, November 17, 2023 /ENDURANCE SPORTSWIRE/ - The completely closed to traffic 157.5km cycling long race course of the 10th GFNY Cozumel is flat yet windy and as such one of the toughest bike races in Latin America. 3000 riders were ready to race hard and play hard,...

Cycling

Events

Press Releases

November 16, 2023

USA Triathlon Announces 2024 State Championships Calendar

COLORADO SPRINGS, Colo. /ENDURANCE SORTSWIRE/ - USA Triathlon today unveiled the dates and locations for the 2024 USA Triathlon State Championships, a robust calendar of local, USA Triathlon sanctioned events across the United State that give athletes around the country the opportunity to race for state titles and qualify for...

Events

Press Releases

Triathlon

November 16, 2023

Catalina Island Half Marathon Winner Completes Course Over 7 Minutes Ahead of Next Finisher

AVALON, Calif. /ENDURANCE SPORTSWIRE/ - The Catalina Island Half Marathon, one of the most popular trail half marathons in California, returned on Nov. 11 for another year of trail racing, bringing together runners from around the country to participate in the historic event. This trail half marathon challenged participants through...

Events

Press Releases

Running

November 14, 2023

Challenge Family announces its return to the USA with Challenge New Jersey State Triathlon

/ENDURANCE SPORTSWIRE/ – Challenge Family has revealed its second race in North America in as many months with today’s announcement of Challenge New Jersey State Triathlon on 20-21 July 2024, following on from last month’s announcement of SAIL Challenge Cap Québec powered by Argon 18. Previously the New Jersey State...

Events

Press Releases

Triathlon