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

January 21, 2022

Kaiser Permanente Napa Valley Marathon Reaches Early Sell Out for 2022 Race

NAPA, CA /ENDURANCE SPORTSWIRE/ - For the first time since 2020, the Kaiser Permanente Napa Valley Marathon and Half Marathon will return to wine country to the tune of a sold out field. With just under two months until the March 6, 2022 race, registration for the full marathon and...

Events

Press Releases

Running

January 20, 2022

Professional Triathletes Organisation Announce Age Group Racing at Collins Cup in Partnership With Challenge Family And X-Bionic® Sphere

20th January 2022. LONDON/ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) today announced that it has appointed Challenge Family as local organising committee (LOC) to deliver the second annual Collins Cup on 20th and 21st August 2022 at theextraordinary x-bionic®sphere in  Šamorín, Slovakia. The Collins Cup is the 2nd race of the...

Events

Press Releases

Sponsorship

Triathlon

January 20, 2022

Big Bear Lake to Host Global Long-Distance Hiking Event Series as HIGHLANDER Expands to U.S.

BIG BEAR LAKE, Calif. (January 20, 2022) /ENDURANCE SPORTSWIRE/ - A once sought-after destination during the California Gold Rush will now become a true gold mine for hikers who are ready to test their physical limits and live in perfect harmony with nature over several days. Big Bear Lake, the...

Events

Press Releases

January 20, 2022

Fourth Annual DeLuna’s Open Water Swim Registration is Now Open

Pensacola, FL. (January 20, 2022) /ENDURANCE SPORTSWIRE/ - Pensacola Sports and Salty Sports Society invites both locals and visitors alike to participate in the 4th annual DeLuna’s Open Water Swim on Saturday, April 23, along Pensacola Beach. Early registration is now open to the public. Participants can choose to swim...

Events

Press Releases

Triathlon

January 20, 2022

IRONMAN Announces Rubavu in Rwanda As New Host City for IRONMAN 70.3 Rwanda

TAMPA / LONDON / RUBAVU (January 20, 2022) /ENDURANCE SPORTSWIRE/ IRONMAN announced today that it will add a brand-new event to its 2022 race calendar with the IRONMAN® 70.3® Rwanda in Africa. The inaugural IRONMAN 70.3 Rwanda triathlon will take place on Sunday, August 14, 2022. General Registration will open on...

Events

Press Releases

Triathlon

January 20, 2022

28th Annual 3M Half Marathon Ready to Run Austin’s Roads

AUSTIN, Texas, January 20, 2022 /ENDURANCE SPORTSWIRE/ - High Five Events, one of the largest privately owned event production companies in the United States, is putting the final touches on the 3M Half Marathon presented by Under Armour. More than 6500 participants have registered, with 48 states and 10 countries...

Events

Press Releases

Running

January 19, 2022

Munich, London and Singapore will Host the First-Ever Esport Triathlon World Championship Series

/ENDURANCE SPORTSWIRE/ - World Triathlon & Super League Triathlon Announce Locations For Arena Games Triathlon World Championship Series powered By Zwift 2022 Following on from the recent news of a ground-breaking partnership between Super League Triathlon (SLT) and World Triathlon (WT) to grow a global esports World Championship series - Arena...

Events

Press Releases

Triathlon