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

November 18, 2023

La Routa Adventure Race in the Philippines Hosts the ARWS Asia Championship

.ENDURANCE SPORTSWIRE/- International adventure racing returns to the Philippines next week, when La Routa Adventure Race hosts the Adventure Racing World Series Asia Championship. La Routa is the longest established adventure race in The Philippines, and ran continuously from 2000 to 2010. It was revived in 2019, and now returns...

Events

Press Releases

November 17, 2023

RunSignup Announces RaceDay Photo Platform Optimization

Moorestown, NJ— November 17, 2023 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for endurance events in the United States, announces optimization advancements in its RaceDay Photo platform. The company’s free photo platform is designed to simplify the process for photographers and race directors while delivering instant photo access...

Cycling

Press Releases

Products

Running

Triathlon

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

ORTLIEB Repair Week 2023 – Repair Rather Than Rebuy

AUBURN, Washington, USA /ENDURANCE SPORTSWIRE/ – Renowned for its unwavering commitment to durability and sustainability, ORTLIEB, the German manufacturer of premium waterproof backpacks, panniers, and travel bags, proudly announces the return of its annual Repair Weeks, running from November 13th to December 3rd, 2023. During this time, ORTLIEB will be offering...

Press Releases

Products

November 16, 2023

Destination Sport Experiences launches ultimate training camps programme, with seven world-class sports resorts

16th November 2023 - Manchester, UK/ENDURANCE SPORTSWIRE/ – Destination Sport Experiences takes athletes to participate in the best cycling, running and triathlon events all over the world. For 2024 it launches a programme of training camps at seven top sports resorts to help them prepare in the perfect environment. These work...

Business

Cycling

Press Releases

Running

Triathlon

November 16, 2023

Olympic Hopefuls, U.S. Olympian Carrie Tollefson Announced for Main Stage Panel at 2024 Running USA Industry Conference

ORLANDO (Nov. 16, 2023) – Running USA is excited to announce the first of many conference events connected to the U.S. Olympic Marathon Team Trials at the 2024 Industry Conference presented by haku in Orlando, Jan. 31-Feb. 2, 2023. Not registered for the world’s biggest and best running industry yet?...

Press Releases

Running

Trade Shows