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

June 10, 2022

USA Triathlon Partners With Hydrow as Official Connected Rowing Equipment And Rowing Training Partner

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon today announced a partnership with Hydrow, the leading at-home connected rower, as the organization’s Official Connected Rowing Equipment and Rowing Training Partner through 2025. Hydrow leverages innovative technology to bring the on-water, outdoor experience of rowing to the home, recreating the feeling...

Business

Press Releases

Sponsorship

Triathlon

June 8, 2022

Enduro Bearings to Host ‘Bearings & Brews Speakeasy’ June 29 at Rapha’s San Francisco Clubhouse

Oakland, California (June 8, 2022) /ENDURANCE SPORTSWIRE/ - On the heels of Enduro Bearings’ info-rich website launch last week, they’ll be hosting a free-to-the-public ‘Bearings & Brews Speakeasy’ at the Rapha Clubhouse in San Francisco (2198 Filbert St.). The event will take place at 5:30pm on Wednesday, June 29. Enduro...

Business

Cycling

Events

Press Releases

Products

Triathlon