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

July 20, 2024

SylvanSport Celebrates 20 Years of Innovating Camping Experiences with Micro Adventure Series

Brevard, NC – July 20, 2024 /ENDURANCE SPORTSWIRE/ – SylvanSport, the Brevard, NC-based innovator and manufacturer of renowned adventure travel trailers, pop-up campers, rooftop tents, and outdoor gear, celebrates its 20th anniversary with the launch of its latest product line, the 2025 Micro Adventure Series (MAS). Maintaining the brand’s commitment to...

Press Releases

Products

July 19, 2024

supertri Partners With Europe Triathlon’s Rising Stars Initiative To Develop ‘NXT Gen’ Of Elite Athletes

LONDON, UK/ENDURANCE SPORTSWIRE/ – supertri can today announce a partnership with Europe Triathlon to support the development of the next wave of Olympic champions. supertri is officially backing the Rising Stars programme, which enables junior athletes from across the continent to have the chance to make a leap from amateur...

Press Releases

Sponsorship

Triathlon

July 19, 2024

Verge Sponsors Chicago Grit with a Stunning New Leader Jersey Design

NEW YORK, JULY 19, 2024 /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is proud to announce its sponsorship of Chicago Grit, formerly known as Intelligentsia Cup, the most exciting 10-day criterium race series in Chicagoland and the largest road racing series in America. Verge has closely...

Cycling

Events

Press Releases

Sponsorship

July 19, 2024

XTERRA World Championship Announces the Return to Trentino, Italy for 2025

TRENTINO, ITALY /ENDURANCE SPORTSWIRE/ – The XTERRA World Championship will return to the village of Molveno, situated beneath the UNESCO World Heritage-listed Brenta Dolomites in the northern Italian Alps, for its 2025 edition. This venue, first selected in 2022, marked the first relocation of the XTERRA World Championship outside of...

Cycling

Events

Press Releases

Running

Triathlon

July 19, 2024

Korir, Nawowuna Win Boilermaker 15K at PRRO Circuit 2024-25 Opener

UTICA, NY /ENDURANCE SPORTSWIRE/ – On Sunday morning, July 14, under warm, sunny conditions, John Korir and Grace Loibach Nawowuna won their respective races at the 47th Boilermaker 15K presented by Excellus BlueCross BlueShield, the first stop on the PRRO Circuit 2024-25. The winners of the sold-out summertime classic also...

Events

Press Releases

Running

July 18, 2024

BMW Joins as Official Partner for Challenge New Jersey State Triathlon

MERCER COUNTY, NJ – July 18, 2024 /ENDURANCE SPORTSWIRE/ - The Challenge Family and Motiv Sports today announced BMW as the official automotive partner for the Challenge New Jersey State Triathlon, taking place this weekend, July 20-21, 2024. This partnership brings a new level of prestige to one of the...

Events

Press Releases

Sponsorship

Triathlon

July 18, 2024

BOA Fit System Proven to Enhance Cycling Footwear Performance

Denver, CO (July 18, 2024)/ENDURANCE SPORTSWIRE/ – BOA® Technology, the creators of the award-winning patented BOA® Fit System, partners with leading brands to create high performance fit solutions that enable the world’s best athletes in Cycling, Snow, Athletic, and Outdoor sports to get dialed in and perform at their peak....

Business

Cycling

Press Releases

Products

July 18, 2024

Fast Racing Will be on Display at the 2024 Bank of America Chicago Marathon

CHICAGO /ENDURANCE SPORTSWIRE/ – The professional athlete field for the 46th running of the Bank of America Chicago Marathon was announced today. It features two of the top 10 fastest women of all time, two of the world’s most exciting marathon stars racing in the United States for the first...

Events

Press Releases

Running

July 18, 2024

Almaty Marathon 2023 Generates Over $1.8 Million for the Local Economy

Almaty, Kazakhstan /ENDURANCE SPORTSWIRE/ – On 29 September 2024, Almaty will host the thirteenth edition of the Almaty Marathon, the largest running event in Central Asia, which has become a catalyst for change in the region. The Marathon has instilled a love of running in the people of Kazakhstan and...

Business

Events

Press Releases

Running

July 18, 2024

Sold out GFNY Grand Ballon: over 4000m of climbing this Sunday

New York City, July 18, 2024 /ENDURANCE SPORTSWIRE/ - This Sunday, the GFNY Grand Ballon offers racers a 146.3 km long course with 4041m of climbing through the Vosges mountains in one of the most beautiful destinations in France. The third edition sold out with a record number of riders....

Cycling

Events

Press Releases