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

January 8, 2024

Gold’s Gym Thousand Oaks Redefines Fitness with Unveiling of State-of-the-Art Remodel and Exclusive Features

Thousand Oaks, CA (January 8, 2024) /ENDURANCE SPORTSWIRE/ – Gold’s Gym Thousand Oaks is excited to announce the successful completion of its extensive remodel and expansion, marking a significant milestone in its commitment to providing an unparalleled fitness experience in Southern California. The transformative project introduces exclusive facilities and state-of-the-art equipment,...

Business

Press Releases

January 8, 2024

Supply Chain Sources Will Represent Three Popular Wellness Brands At CES 2024

PLANO, TX, Jan. 8, 2024 /ENDURANCE SPORTSWIRE/ – Supply Chain Sources (SCS) will represent at CES 2024 three popular wellness brands: KingSmith Fitness and a full line of WalkingPad products (Venetian Expo, Halls A-D, Booth #54208), LifeSmart PowerTouch Fitness (Venetian Expo, Halls A-D, Booth #54508) and AiWorks Global (LVCC, North Hall,...

Business

Press Releases

Trade Shows

Wire Syndication

January 8, 2024

Phil Gyori Named Chief Executive Officer of United Sports Brands

Fountain Valley, CA (Jan 8, 2024) /ENDURANCE SPORTSWIRE/ - United Sports Brands is pleased to announce the appointment of Phil Gyori as Chief Executive Officer. Phil most recently served as the CEO of Pelican Products, and has also held past senior leadership roles at top outdoor and lifestyle brands such...

Business

Press Releases

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