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

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

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