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

October 30, 2024

DATEV Challenge Roth Elevated To Platinum Tier For Professional Triathletes Organisation World Rankings

ROTH, GER / LONDON, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) and TEAMCHALLENGE are delighted to announce that the iconic DATEV Challenge Roth, known as the ‘Home of Triathlon’, has been elevated to Platinum status for the PTO’s 2025 World Ranking System. This prestigious recognition comes following a...

Business

Press Releases

Triathlon

October 30, 2024

Norwegian Outdoor Brand Norrøna Announces Varg: A Luxury, Adventure Sail Yacht

OSLO, Norway (Oct. 30, 2024) /ENDURANCE SPORTSWIRE/ — Heritage Norwegian adventure and outdoor brand Norrøna is pleased to announce the expansion of its adventure travel offerings with the upcoming launch of the Varg sailing yacht in 2025. The luxury sailing yacht will bring outdoor enthusiasts to stunning, remote locations across...

Business

Press Releases

October 30, 2024

DPS and PHANTOM Glide Enlist Billy Demong for Product Development

SALT LAKE CITY (Oct. 30, 2024) /ENDURANCE SPORTSWIRE/ — PHANTOM Glide announces the hire of former World Cup Nordic Combined champion, Billy Demong, as head of strategic product development. Demong, who has been an active PHANTOM Glide tester since its invention more than seven years ago, will formally join fellow recent hire, Ted...

Business

Press Releases

Products

October 30, 2024

‘Hit Play Not Pause,’ the Ground-Breaking Podcast for Active Performance-Minded Menopausal Women Celebrates 200 Episodes

October 30th, /ENDURANCE SPORTSWIRE/ - Started in 2020, the Hit Play Not Pause podcast, hosted by Selene Yeager and produced by Feisty Media, released its 200th episode today. In that time, the pioneering show has reached over 2.9 million listeners and helped redefine the conversation around menopause. “I knew how...

Business

Press Releases

SWW Syndication