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

December 6, 2023

Perceev, the Endurance Sports Platform, Partners with Double Olympic Triathlon Champion Alistair Brownlee

/ENDURANCE SPORTSWIRE/ - Perceev, the Endurance Sports Platform, Partners with Double Olympic Triathlon Champion Alistair Brownlee. Perceev, an innovative new software as a service platform for endurance races, has partnered with double Olympic Triathlon Champion, Alistair Brownlee, MBE. Alistair needs no introduction to the world of endurance sports, with a...

Business

Press Releases

Products

December 6, 2023

What is BibRave?

/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently celebrated its 10-year anniversary, having created hundreds of marketing campaigns for races and brands across the industry. In keeping with the company’s Vision to “Move people and business to constantly evolve what makes them great,” BibRave’s marketing services have...

Business

Press Releases

Running

December 6, 2023

Mike Bone Announced as Chair of Catalina Island Special Events Committee

AVALON, Calif. /ENDURANCE SPORTSWIRE/ – The Special Events Committee on Catalina Island has welcomed Mike Bone, President and CEO of Spectrum Sports Management, as their new Committee Chair. The committee is dedicated to attracting events to the island, while also ensuring the current high quality events taking place on the island...

Business

Press Releases

December 6, 2023

Nix Biosensors and INFINIT Nutrition Join Forces to Provide Custom Hydration and Fueling Formulas

BOSTON, MASS — December 6, 2023/ENDURANCE SPORTSWIRE/ – Nix Biosensors, a leading innovator in biosensing technology, and INFINIT Nutrition, a renowned provider of personalized performance nutrition formulas, are excited to announce they’ve teamed up in the launch of INFINIT’s new Performance Lab Toolbox. With Nix’s state-of-the art sweat monitoring technology, athletes will...

Business

Cycling

Press Releases

Products

Running

Triathlon

December 5, 2023

SNO-GO Partners With GovX To Offer Discounts For Active Military, Veterans, And First Responders

December 5, 2023 | Salt Lake City, UT/ENDURANCE SPORTSWIRE/ – SNO-GO, the global leader in ski bikes, today announced a partnership with government procurement platform GovX to expand access to its line of products for active military, veterans, and first responders. Through this new collaboration, SNO-GO will offer specially discounted ski bikes...

Business

Press Releases

Products

December 5, 2023

Perceev Integrates with Race Result Timing to Provide Live Athlete Tracking and Leaderboards for Endurance Races

December 5, 2023 /ENDURANCE SPORTSWIRE/ – Perceev, an innovative new software as a service platform for endurance races, is excited to announce its integration with Race Result Timing Solutions. The Perceev platform is the first available technology of its kind to allow race directors to easily and affordably build an event...

Business

Press Releases

Products