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 (11)
) 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 2070, 10

January 20, 2022

Heath Pearce Named President of For Soccer Ventures

NEW YORK AND LOS ANGELES January 20, 2022 /ENDURANCE SPORTSWIRE/ - For Soccer Ventures (FSV), the largest independent soccer media and experiences company in the United States, announced that former United States Men’s National Team Player and three-time Major League Soccer All-Star Heath Pearce has been named as President of...

Business

Press Releases

January 20, 2022

Challenge Family Enters the World of Virtual Sports with ROUVY

20 January 2022 /ENDURANCE SPORTSWIRE/ - ROUVY will combine animated 3D avatars, both cycling and running, with real-life video footage of Challenge Family destinations to create a new level of interactive home training. The new partnership aims to continue development of a strong online community through virtual group rides, race-specific...

Business

Press Releases

Triathlon

January 19, 2022

Showcased

Black Rifle Coffee to be Named the Official Coffee of Spartan US Across 10 Races Starting in 2022

Boston, Mass. (January 19, 2022) /ENDURANCE SPORTSWIRE/ - Black Rifle Coffee (BRCC), a rapidly growing and mission-driven premium coffee company founded to support Veterans, active-duty military, and first responders, is prepared to caffeinate the Spartan community starting in 2022. The BRCC mission harmonizes perfectly with the prominent military ties blended...

Business

Events

Press Releases

Products

Sponsorship

January 18, 2022

Professional Triathletes Organisation Announces Appointment of Lisa Bentley to The PTO Board

18th January 2022. LONDON, ENGLAND /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation today announced that it has appointed 11-time IRONMAN® Champion and Collins Cup Team International Captain, Lisa Bentley to the PTO Board. Bentley raced for 20 years as a professional triathlete winning 11 IRONMAN® races and 11 IRONMAN® 70.3 races. She...

Business

Press Releases

Triathlon