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

March 3, 2022

NWSL Rookie of the Year Trinity Rodman Partners with Youth Athletes United

New York, March 3, 2022 /ENDURANCE SPORTSWIRE/ - Youth Athletes United, one of America's fastest-growing multi-sport programs, with 291 territories nationwide and more than 200,000 children instructed each year, continues to catch on in communities throughout the U.S. The multi-brand franchisor includes Soccer Stars, Amazing Athletes, TGA Premier Sports, Little Rookies Baseball...

Business

Press Releases

Sponsorship

March 3, 2022

Leon Cycle Hires SIMBOL Communications as PR Agency of Record

Seattle, Washington (March 3, 2022)/ENDURANCE SPORTSWIRE/ - Since its inception in Germany in 2014, Leon Cycle has grown into one of the biggest e-bike brands in Europe by focusing on its mission to offer high-quality bikes at affordable prices in every category. Now they’re bringing on SIMBOL Communications as its PR...

Business

Cycling

Press Releases

Triathlon

March 3, 2022

Cirrus Cycles’ Kinekt Partners with Dutch Cargo

BELLINGHAM, Wash. March 3rd, 2022 /ENDURANCE SPORTSWIRE/ - Cirrus Cycles, the maker of the KINEKT suspension post and KINEKT suspension stem, proudly announces the addition of Dutch Cargo, the well-known Australian and New Zealand distributor, thereby increasing product available to customers worldwide. “Though we’re a small company based in Bellingham, Washington,...

Business

Cycling

Press Releases

Products

March 2, 2022

Endurance Exchange Virtual Conference Begins Thursday

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - The third annual Endurance Exchange presented by BOA Nutrition, an industry-wide conference for endurance professionals and athletes, takes place as a virtual event this Thursday, March 3, through Saturday, March 5. All sessions will be recorded and available on-demand through May 31 for attendees who are unable to...

Business

Press Releases

Triathlon

March 2, 2022

New Speakers Announced, Final Lineup Confirmed for Sea Otter Classic Summit produced by Life Time, April 5-7

MONTEREY, Calif. (Mar. 2, 2022) /ENDURANCE SPORTSWIRE/ - Life Time, the nation's premier Healthy Way of Life brand (NYSE: LTH), and the Life Time Sea Otter Classic presented by Continental announce eight new experts who will share their knowledge at the inaugural Sea Otter Classic Summit taking place April 5-7,...

Business

Events

Press Releases

Trade Shows