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

March 25, 2022

OFX and Super League Triathlon Extend Partnership

LONDON/ENDURANCE SPORTSWIRE/ - Super League Triathlon (SLT) can today announce it has extended its partnership with OFX who will become the official Currency and Foreign Exchange partner of SLT. The agreement builds on the success of the partnership between OFX and Super League in 2021, and covers Arena Games Triathlon...

Press Releases

Sponsorship

Triathlon

March 25, 2022

OPEX Fitness Expands InsideTracker Partnership to Deliver Unparalleled Personalized Training Resources for Professional Coaches

SCOTTSDALE, Ariz. – March 25, 2022/ENDURANCE SPORTSWIRE/ - OPEX Fitness today announced a partnership with InsideTracker, the leading truly personalized performance and nutrition system, following a successful pilot program in 2021 that gave coaches and clients access to InsideTracker Pro, delivering science-backed nutrition and lifestyle recommendations based on blood, DNA...

Business

Press Releases

Products

March 24, 2022

British Cycling Brand Parcours Update Their Customisable Offering For 2022

/ENDURANCE SPORTSWIRE/ - It’s never been easier for cyclists to upgrade both the look and performance of their wheelset to match their favourite bike. Parcours have an even greater level of bespoke customisations on offer for 2022 which have been tried and tested by some of the world’s best athletes....

Cycling

Press Releases

Products

March 24, 2022

Bike.com Launches with New Premium Line of Denago eBikes

Dallas, TX (March 24, 2022) /ENDURANCE SPORTSWIRE/ - Bike.com is officially live! The online marketplace looks to become the one-stop-shop for both experienced bicyclists and those graduating from training wheels. They have created a community where anyone interested in riding can come to learn, explore and purchase a bike, while...

Cycling

Press Releases

Products

March 24, 2022

MANA Athletes Kick Start 2022 In Winning Style

/ENDURANCE SPORTSWIRE/ - MANA Sports and Entertainment Group athlete Kat Matthews has kicked off her 2022 racing season with a win at Ironman 70.3 Lanzarote. After riding into the lead on the toughest bike course on the circuit, the British athlete then broke the tape with a three-minute lead over...

Press Releases

Running

Sponsorship

Triathlon

March 24, 2022

The Giant Race Series Presented by Alaska Airlines is Partnering With BANDAI NAMCO Entertainment America Inc. to Launch the 2022 PAC-MAN Virtual Challenge

San Francisco, California /ENDURANCE SPORTSWIRE/ -  Giants Enterprises, the development and entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, announced a brand new, worldwide PAC-MAN Virtual Challenge today as part of the partnership between the Giant Race Series presented by Alaska Airlines and leading interactive entertainment company, BANDAI NAMCO...

Events

Press Releases

Running

Sponsorship

March 24, 2022

Inaugural GFNY Cannes this Sunday

/ENDURANCE SPORTSWIRE/ - GFNY Cannes will be the first of six GFNY in France in 2022 and will cover a racecourse of  111 km with 2013m of climbing. Cannes is among the most glamorous places on earth, with the jet-set letting loose on the sandy beaches, fine restaurants and bars,...

Cycling

Events

Press Releases