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

September 15, 2022

6-Time IRONMAN World Champion Mark Allen Endorses Frontier X2

London, UK /ENDURANCE SPORTSWIRE/ – Mark Allen – dubbed the greatest endurance athlete of all time through an official ESPN poll – has partnered with pioneering medical technology start-up Fourth Frontier to help endurance athletes monitor their heart health and train at optimum levels. The company has made great strides to...

Cycling

Press Releases

Running

Sponsorship

Triathlon

September 15, 2022

RunSignup Endurance Industry 2022 YTD Update

September 15, 2022,  Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration provider for U.S. endurance events, provides a September industry update. Recent data indicates the market is showing signs of improving. Previously, data on a per race basis revealed a decrease in the per event registrations and in repeat...

Business

Press Releases

Running

September 14, 2022

Rock ‘n’ Roll Running Series Las Vegas Extends Partnership with Resorts World Las Vegas Bringing The Health & Fitness Expo to The Las Vegas Strip for Three More Years

- 2023 Rock ‘n’ Roll Running Series Las Vegas Half Marathon taking place on Sunday, Feb. 26 will be streamed on Resorts World Las Vegas 100,000 square-foot West Tower LED screen - Registration for the 2023 Rock ‘n’ Roll Running Series Las Vegas with a distance for everyone including 5K,...

Press Releases

Running

Sponsorship

Trade Shows

September 14, 2022

IRONMAN 70.3 Perú returns to Lima, Peru for 2023

Lima, Perú (September 14, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that IRONMAN® 70.3® Perú triathlon will return to Lima, Perú for the first time since 2019. The fourth edition of IRONMAN 70.3 Perú triathlon is scheduled to take place on Sunday, April 23, 2023. Registration for the event opens on Thursday,...

Events

Press Releases

Triathlon

September 14, 2022

Handcyclists can now choose to ride an Adaptive Bike in Zwift

Long Beach, California, Sept. 14, 2022/ENDURANCE SPORTSWIRE/ – Zwift, the global online fitness platform for cyclists, is proud to announce the addition of a handcycle to their in-game bike options. The new handcycle is Zwift’s first adaptive bike and is designed to be used by Zwifters who ride handcycles at home, so...

Cycling

Press Releases

Products

September 14, 2022

Gran Fondo Maryland Announced as USA Cycling Gran Fondo National Championship for 2023

Gettysburg, PA – September 14, 2022)/ENDURANCE SPORTSWIRE/ – Gran Fondo National Series is proud to announce that the 2023 USA Cycling Gran Fondo National Championships will be held in conjunction with Gran Fondo Maryland. The date for the Championships in Frederick, Maryland, will be September 17, 2023. Gran Fondo National Series...

Cycling

Events

Press Releases

September 14, 2022

Athletic Brewing Company Announces Return of Oktoberfest

MILFORD, Conn. and SAN DIEGO (September 14, 2022)/ENDURANCE SPORTSWIRE/ – Athletic Brewing Company, the leading non-alcoholic craft brewer in the U.S., today announced the return of its beloved Oktoberfest Non-Alcoholic Festbier for a fourth year. As the seasons change and fall festivities return, Athletic Oktoberfest pairs perfectly with all of your...

Events

Press Releases

Products

September 14, 2022

BUFF® Releases Fall-Winter 2022-23 Collection

SANTA ROSA, California /ENDURANCE SPORTSWIRE/ - BUFF®, creator of versatile performance head and neckwear for all-season outdoor enthusiasts, announces the launch of its fall-winter 2022-23 collection. The brand celebrates 30 years of innovation, incorporating two new eco-friendly materials into its collection: PrimaLoft® Bio™ Fleece, a 100-percent recycled synthetic fiber made from...

Business

Cycling

Press Releases

Products

Running

September 14, 2022

MicroOLED Introduces the First AR Solution to Enable Real-Time Display of Apple Watch Sensor Data

GRENOBLE, France and BOSTON, Mass., Sept. 14, 2022/ENDURANCE SPORTSWIRE/ – MicroOLED, the company that specializes in the design and manufacture of OLED microdisplays, today announced the first of its kind integration of the ActiveLook “Light AR” platform with Apple Watch. The integration allows Apple Watch users to connect ActiveLook-enabled eyewear directly to...

Press Releases

Products

Running

September 14, 2022

Stryd Launches NIL Program

Boulder, CO September 14, 2022 /ENDURANCE SPORTSWIRE/ - Today, Stryd announces the launch of a groundbreaking NIL (Name, Image & Likeness) program to advance collegiate running performance & highlighting student-athlete achievement — with Stryd’s breakthrough running power metric and wearable foot pod. This program will show that Stryd can help...

Press Releases

Running

Sponsorship