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

June 17, 2023

Tierra Indomita in Chile is a new Adventure Racing World Series Race for 2024

/ENDURANCE SPORTSWIRE/ - The Tierra Indomita Adventure Race, set in the stunning Cordillera de Fuego of the Chilean Andes is a new addition to the Adventure Racing World Series next year! Prepare your senses for an unparalleled experience in one of the most beautiful and wild landscapes on the planet....

Events

Press Releases

June 17, 2023

The Temiscamingue International Raid Joins the Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ - The Temiscamingue International Endurance Aventure Raid in Quebec is the first stage race to join the Adventure Racing World Series. The race will take place from September 8-10th in the magnificent territory of the Anishinaabe Nation, and the location is a paradise for outdoor enthusiasts and lovers...

Events

Press Releases

June 16, 2023

FRESHJUNKIE Racing Introduces Groundbreaking Profit-Sharing Plan for Employees and Contract Staff

Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - FRESHJUNKIE Racing, a leading event production company known for its exceptional race experiences, is proud to announce its revolutionary profit-sharing plan designed to include employees and event contract staff. This innovative approach aims to enhance employee incentives, foster team retention, and solidify FRESHJUNKIE Racing's...

Business

Events

Press Releases

Running

June 16, 2023

Focus on Mental Health for Next US Trail Running Conference Webinar, A Global Campfire

/ENDURANCE SPORTSWIRE/ – A Global Campfire: How supporting mental health can grow your race, is the subject of the fifth webinar in eight-webinar series produced by the US Trail Running Conference presented by Marathon Printing. The live webinar takes place on Thursday, June 22, at 1.00 pm MT, and is free...

Press Releases

Running

Trade Shows

June 16, 2023

RunSignup Expands RaceDay CheckIn App with Participant Kiosk Features

Moorestown, NJ - June 16, 2023 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading provider of registration and event technology, unveils the latest advancements in its RaceDay CheckIn app, transforming its use to greater functionality. The new release includes the ability for events to use the app as a dedicated Results Kiosk enabling...

Cycling

Press Releases

Products

Running

Triathlon

June 15, 2023

Lake Sonoma Race Series Proves Elite Performance, Community and Diversity can Co-Exist on the Trails

/ENDURANCE SPORTSWIRE/ – This year’s 50-Mile event boasted a record high participation rate for female runners, with a forty percent uptick from previous years. The race also raised thousands of dollars for local vineyard workers children scholarships – all while serving as the selection race for the USATF World Mountain Running...

Events

Press Releases

Running

June 15, 2023

MLS NEXT, Kitman Labs Build New System To Drive Operational Efficiencies, Optimize Player Pathways

NEW YORK (Thursday, June 15, 2023) /ENDURANCE SPORTSWIRE/ – MLS NEXT and Kitman Labs, the sports technology and analytics company setting an industry standard for how elite sports organizations use data, today announced a new deal that will provide MLS NEXT with new software to enhance the operation of MLS NEXT and...

Business

Press Releases

Products

June 15, 2023

Super League Triathlon Announce Fifth Anniversary Championship Series With Star Athlete Line-Ups

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) has unveiled the dates of its fifth anniversary Championship Series and the first superstar athletes who will deliver the fastest racing on the planet. Super League has revolutionised triathlon with its unpredictable formats and innovations, exciting courses, Teams format and action-packed broadcasts that were...

Events

Press Releases

Triathlon

June 15, 2023

Annual Crown City Classic 4th of July Run Celebrates 50 Years Running

/ENDURANCE SPORTSWIRE/ - Celebrating its 50th year running, Coronado's annual 4th of July run returns with a remarkable display of consistency. The beloved event, renowned as one of the finest 4th of July running events in the country, invites runners of all ages and abilities to participate in a variety...

Awards

Events

Press Releases

Running