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

March 16, 2022

Canadian Carbon Fiber Bike Manufacturer, BRIDGE Bike Works, Secures Angel Round Funding From OvareVentures

Los Angeles, CA  /ENDURANCE SPORTSWIRE/ -  OvareVentures is adding to its portfolio of outdoor and active brands with an investment in Toronto carbon fiber bicycle manufacturer BRIDGE Bike Works. Bike sales boomed by as much as 120 percent during the pandemic, with consumer expectations refocusing on locally made products. BRIDGE...

Business

Cycling

Press Releases

March 16, 2022

Speedland Introduces the SL:HSV Bringing Improved Performance to Trail Runners

Portland, Oregon, March 16, 2022 /ENDURANCE SPORTSWIRE/ - Developed by industry experts Dave Dombrow and Kevin Fallon and tested by elite trail running athletes, Speedland, a revolutionary equipment company for trail runners, launches its second footwear style with the SL:HSV. In collaboration with elite ultrarunner and Speedland athlete Liz Canty,...

Business

Press Releases

Products

Running

March 16, 2022

The WaterMonster pours it on for 2022

Kerrville, Texas (March 2022) /ENDURANCE SPORTSWIRE/ - With Spring closing in, Event Hydration Solutions, Inc has been working hard behind the scenes to offer new exciting accessories for the WaterMonster Tank water refill stations.  Announcing the FillSpout, a new large 1” water dispenser that will help to quickly refill smaller...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

March 16, 2022

Zwift, USA Triathlon partner to engage multisport community, promote USA Triathlon Certified Coaches

COLORADO SPRINGS, COLO. /ENDURANCE SPORTSWIRE/ - Zwift and USA Triathlon have partnered to grow, engage and support the multisport community and promote the value of USA Triathlon Certified Coaches, USA Triathlon announced today. The partnership features in-game racing in association with Endurance Exchange, Legacy Triathlon and National Triathlon Week, a custom co-branded...

Business

Cycling

Press Releases

Triathlon

March 15, 2022

USA Triathlon Foundation now accepting 2022 Grant Applications

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/-The USA Triathlon Foundation is accepting grant applications from the triathlon community for 2022. Individuals and organizations can apply for a USA Triathlon Foundation Pillar Grant program at usatriathlonfoundation.org. All proposals are due by April 10, and the USA Triathlon Foundation’s independent grant committee will make selections...

Business

Press Releases

Triathlon

March 15, 2022

Internationally renowned Gravity Media appointed as broadcast partner for Sub7 Sub8

Sydney, Australia – 15th March, 2022 /ENDURANCE SPORTSWIRE/ - Mana Sports and Entertainment Group today announced Gravity Media as the broadcast partner for the Pho3nix Sub7 and Sub8 Project, powered by Zwift, set to take place on the 5th or 6th of June 2022 at the Dekra Lausitzring in Germany....

Business

Events

Press Releases

Triathlon