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 (16)
) 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 3760, 10

April 12, 2023

Cycling Industry flocks to NYC Bike Expo on May 19-21

New York City, April 12, 2023 /ENDURANCE SPORTSWIRE/ - NYC Bike Expo returns for its 11th annual edition on May 19-21. The road cycling show will attract more than 10,000 visitors who are avid road cyclists, endurance athletes and cycling fans. Exhibitors will showcase products such as bike components, bike...

Cycling

Events

Press Releases

April 12, 2023

Challenge Family Arrives in Italy’s South with Challenge Egnazia Tri

/ENDURANCE SPORTSWIRE/ - Challenge Family today confirmed its third race in Italy with the announcement of Challenge Egnazia Tri on 21 October 2023. Challenge Family's new triathlon destination, hosted in Savelletri di Fasano in Puglia, a beautiful Apulian village on the Adriatic Coast, is known for its picturesque harbour and...

Events

Press Releases

Triathlon

April 12, 2023

IRONMAN 70.3 New York – Jones Beach Sells Out General Registration Becoming Largest Inaugural Triathlon in IRONMAN 70.3 History

WANTAGH, N.Y. (April. 11, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that general registration for the inaugural 2023 IRONMAN® 70.3® New York – Jones Beach triathlon has sold out. With the sellout, the event will play host to the largest inaugural IRONMAN 70.3 event in the history of the IRONMAN...

Events

Press Releases

Triathlon

April 12, 2023

Exhibitor Registration Now Open for 2023 CapTex Tri Expo

AUSTIN, Texas, April 11, 2023 /ENDURANCE SPORTSWIRE/ - High Five Events, one of the largest event production companies in the US, announces the opening of exhibitor registration for the 2023 CapTex Tri Expo. This two day event provides exhibitors with the opportunity to showcase and sell their products and services...

Events

Press Releases

Triathlon

April 11, 2023

Casa Bonita Joins the Denver Colfax Marathon as Volunteer Program Sponsor

  Denver, CO /ENDURANCE SPORTSWIRE/ - Casa Bonita has partnered with the Denver Colfax Marathon as the 2023 race season volunteer program sponsor. This partnership will allow the marathon to continue its support of 1,500 volunteers during the race weekend in May. “This is such a unique partnership,” said Andrea...

Business

Events

Press Releases

Running

Sponsorship

April 11, 2023

Frederick Running Festival Announces 2nd Charity Chaser

April 11, 2023- Elkridge, MD /ENDURANCE SPORTSWIRE/ – We are excited to continue the tradition of the Charity Chaser and funds raised for the “What Would Stew Dew Fund” at the Frederick Running Festival. For the second year in a row, two Frederick Police officers will participate in the Frederick Running Festival...

Events

Giving

Press Releases

Running

April 11, 2023

First top seeds announced for The Championship 2023

/ENDURANCE SPORTSWIRE/ – It’s almost showtime at The Championship: more than sixty professional athletes will compete for the win at Challenge Family's flagship event on 21 May at the x-bionic® sphere in Šamorín, Slovakia. Once again, many world class triathletes will line up with their eye on the coveted titles in...

Events

Press Releases

Triathlon

April 11, 2023

TCS Toronto Waterfront Marathon Earns Evergreen Certification for Commitment to Sustainability and Community Impact

TORONTO April 11, 2023 /ENDURANCE SPORTSWIRE/ - The TCS Toronto Waterfront Marathon (TWM), Canada's premier running event, has been newly awarded with an Evergreen certification by the Council for Responsible Sport, earning the race the highest distinction possible for outstanding social, environmental, economic and community impact. TWM's successful efforts to...

Awards

Events

Press Releases

Running

April 11, 2023

Course Records, Qualifiers, and Impressive Results Highlight Picture-Perfect Carmel Marathon Weekend

CARMEL, Ind. (April 11, 2023) /ENDURANCE SPORTSWIRE/ - Under sunshine and ideal racing conditions, the 2023 Carmel Marathon Weekend started with a full capacity participant field and finished with five course records. More than 4,000 participants crossed the start line after traveling to Carmel, Ind. from 40 states and six...

Events

Press Releases

Running

April 10, 2023

RunSignup Announces RaceJoy’s 10 Year Anniversary

April 11, 2023 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for U.S. endurance events, announces RaceJoy’s ten year milestone. RaceJoy is RunSignup’s interactive race day mobile app with more than 1.7 million users at more than 6,300 events during the last 10 years. RaceJoy...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon