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

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

January 17, 2022

New Partnership Set to Transform Expedition Adventure Racing in North America

/ENDURANCE SPORTSWIRE/ - Bend Racing in Oregon, Rootstock Racing in Pennsylvania, and Hoodoo Adventures in British Columbia announce a new partnership to grow the sport of mu­­lti-day expedition racing in the United States and Canada: The North American Expedition Race Series. The series brings together premier race organizations in the...

Business

Events

Press Releases

Sponsorship

January 14, 2022

Biofreeze Becomes Official External Pain Relief Partner of The Rock ‘N’ Roll Running Series

TAMPA, Fla. / PARSIPPANY, N.J. (Jan. 14, 2022) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series is excited to announce a multi-year partnership with Biofreeze®, a Reckitt brand. The new partnership will feature Biofreeze as the Official External Pain Relief Partner of the Series and of each Rock ‘n’...

Business

Events

Press Releases

Running

Sponsorship

January 14, 2022

The Pro Cyclist Foundation and Black Swift Group, LLC Team Up With USA Cycling in Support of National Team Athletes

/ENDURANCE SPORTSWIRE/ - In a unique model, the Pro Cyclist Foundation, with funding support from Black Swift Group, LLC (“Black Swift”), a Boulder, Colorado based SEC registered investment firm, leads a new breed of investment to support USA Cycling Foundation and other cycling focused organizations. Everyone in the cycling industry knows...

Business

Cycling

Press Releases

January 13, 2022

Data Driven Sports/ShotTracker to Provide Data and Advanced Analytics for Big 12 Basketball

KANSAS CITY, Mo. – (January 13, 2022) /ENDURANCE SPORTSWIRE/ - Data Driven Sports (DDSports), the parent company of ShotTracker, today announced they have entered into an agreement with ESPN to provide data and analytics for Big 12 Conference basketball games. The multi-year deal gives ESPN the opportunity to integrate ShotTracker data...

Business

Press Releases

Products