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 (8742)
) 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 2640, 10

January 4, 2024

Showcased

For Sale Memphis in May Triathlon

Memphis, TN /ENDURANCE SPORTSWIRE/ - P.R Event Management will offer to interested and qualified parties the opportunity to acquire the Legacy 40th Memphis in May Olympic and Sprint Triathlons in time for the 2024 season. Since the inception of the Memphis In May Triathlon in 1983 the event has been...

Business

Events

Press Releases

Triathlon

January 4, 2024

80/20 Endurance Launches Virtual Training and Plans on Velocity Indoor Cycling Platform

Highland Park, Illinois, January, 2024 /ENDURANCE SPORTSWIRE/ – 80/20 Endurance, a leader in the global endurance training and coaching industry, has launched its virtual cycling and enhanced training plan offerings on Velocity, with the Team 80/20 Virtual Cycling Club. 80/20 Endurance is currently leading Live, Replay and On-demand cycling workouts on...

Business

Cycling

Press Releases

Products

Triathlon

January 3, 2024

Varlo Sports Secures Seed Funding for Growth and Innovation, Attracts Investment from REI Co-op Path Ahead Ventures

CHERRY HILL, N.J. (Jan. 3, 2024)/ENDURANCE SPORTSWIRE/ – Varlo Sports, a trailblazing company at the intersection of design and performance in the sports apparel industry, proudly announces the successful completion of its most recent seed funding round. This significant milestone ensures the company's continued growth and operational excellence as it embarks on...

Business

Cycling

Press Releases

Running

Triathlon

Wire Syndication

January 3, 2024

Strava Releases Year In Sport Trend Report, Showing What Makes and Breaks Motivation Across Generations

SAN FRANCISCO – January 3, 2024 /ENDURANCE SPORTSWIRE/ –  Strava, the leading digital community for active people with more than 120 million athletes, today announced the release of Year In Sport: The Trend Report, highlighting the global trends among active people across generations. It’s no surprise that Gen Z’s behaviors and...

Cycling

Press Releases

Running

Studies

Triathlon

January 3, 2024

Verge Launches Cutting-Edge 2024 Custom Apparel

NEW YORK, January 3rd, 2024 /ENDURANCE SPORTSWIRE/ – Verge founder Mike Magur began making custom cycle apparel in New York since 1996, driven by two passions: technical innovation and a love of cycling. Over two decades later, we proudly introduce our 2024 custom apparel collection - crafted to help riders of...

Cycling

Press Releases

Products

January 3, 2024

Registrations Open for the Ultimate Cycling Bucket List as Haute Route Welcomes New Ownership

3 January 2023 /ENDURANCE SPORTSWIRE/ – The recent transition of the Haute Route events in France from the Ironman Group to France Vélo Evénements (FVE) is set to deliver two extraordinary cycling adventures in 2024 in the Pyrenees and Alps. Under the guidance of its new deputy director, Marius Louvet, the quintessential look...

Business

Cycling

Events

Press Releases

January 3, 2024

Showcased

Purple Patch Fitness Selects Velocity as Their Indoor Cycling Platform

Highland Park, Illinois, January 3, 2024 /ENDURANCE SPORTSWIRE/ The Velocity indoor cycling platform has been selected to be the software solution for Purple Patch Fitness, a global leader in triathlon coaching. Purple Patch initially launched their virtual cycling product on Velocity in March 2023 and expanded their offerings on Velocity...

Business

Cycling

Press Releases

Triathlon

January 3, 2024

A 2024 Cyclist Buyer’s Guide to America’s Best Bicycle Insurance

January 3, 2024 / ENDURANCE SPORTSWIRE/ - BikeInsure, an insurtech company specializing in bicycle insurance for cyclists in the United States, has released a 2024 Cyclist Buyer's Guide to America's Best Bike Insurance. Today's cyclists need separate bike insurance to protect their new or used bicycles and eBikes from riding,...

Cycling

Press Releases

Products

Triathlon

Wire Syndication