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

June 20, 2024

J&A Racing Announce The New Beach Bum Challenge In Virginia Beach

JUNE, 2024 – VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ – J&A Racing, the premier racing company in Coastal Virginia, announcing a new challenge for participants. The Beach Bum Challenge is a two-race challenge that includes participation in the iconic Yuengling Shamrock Marathon Weekend and the Chartway Virginia Beach 10 Miler. The...

Events

Press Releases

Running

June 20, 2024

GFNY Lourdes Tourmalet this Sunday

New York City, June 20, 2024 /ENDURANCE SPORTSWIRE/ - This Sunday, the famous pilgrimage town of Lourdes, located in the Southwest of France at the the base of the Pyrenees mountains, will host the third edition of GFNY Lourdes Tourmalet. The challenging race course is 157 km long with an...

Cycling

Events

Press Releases

June 19, 2024

IRONMAN Pro Series Returns to Europe as IRONMAN 70.3 Les Sables D’olonne Vendée Gets Ready to Welcome Over 80 Professional Triathletes

- The IRONMAN 70.3 Les Sables D’Olonne-Vendée triathlon offers a maximum of 2,500 towards IROMAN Pro Series standings and a $50,000 event total pro prize purse - 2023 VinFast IRONMAN 70.3 World Champion, Rico Bogen (DEU) to make his IRONMAN Pro Series debut - Last year’s IRONMAN 70.3 Les Sables...

Cycling

Events

Press Releases

Running

Triathlon

June 19, 2024

Cycling Time Trials (CTT) unveils new ‘Tribes’ team competition, along with introduction of intuitive ‘Event Finder’ functionality.

19th June 2024, 5pm GMT /ENDURANCE SPORTSWIRE/ – Even among cyclists, time trialling has a reputation for being a lonely affair; a solitary rider competing in a race of truth against the clock and themselves over a set distance. Add in the time spent travelling the country to find ‘fast’ courses...

Cycling

Events

Press Releases

June 19, 2024

First-ever America’s Mile Promises Fast Times, Thrilling Competition

PITTSBURGH, PA (June 12, 2024) /ENDURANCE SPORTSWIRE/ – Get ready for the thrill of the summer as Pittsburgh becomes the stage for America’s Mile presented by VisitPITTSBURGH! On July 12, feel the pulse of the city’s North Shore as it transforms into a runner’s paradise, offering a flat, point-to-point course...

Events

Press Releases

Running

June 19, 2024

2024 XTERRA Switzerland Preview: Victory in the Valley

VALLÉE DE LA BRÉVINE, SWITZERLAND /ENDURANCE SPORTSWIRE/ – XTERRA Switzerland debuts a new course in the heart of the Neuchâtel mountains at the 11th stop of the 2024 XTERRA EMEA Tour on June 22, 2024. Set against the backdrop of Swiss landscapes, this location offers an iconic setting for off-road...

Cycling

Events

Press Releases

Running

Triathlon

June 19, 2024

Get Moving for the Cause that Moves You with the 2024 TCS Toronto Waterfront Marathon Charity Challenge

TORONTO, ON (June 19, 2024)  /ENDURANCE SPORTSWIRE/ - The annual TCS Toronto Waterfront Marathon is returning to the city’s streets this fall for the iconic run’s 35th edition and as of today, registration is officially open for the TCS Charity Challenge, giving participants the opportunity to run, walk or wheel...

Events

Giving

Press Releases

Running

June 19, 2024

CNO Financial Group Renews Title Sponsorship of the Indianapolis Monumental Marathon Through 2026

Carmel, Ind./ENDURANCE SPORTSWIRE/ – CNO Financial Group, Inc. (NYSE: CNO) announced an extension of its title sponsorship of the CNO Financial Indianapolis Monumental Marathon through 2026. The race has grown to one of the top 15 largest marathons in the country and attracts Olympians, Boston Marathon qualifiers and running enthusiasts...

Events

Press Releases

Running

Sponsorship

June 19, 2024

GFNY Super Sunday an ocean apart: Pennsylvania-York and La Vaujany-L’Alpe d’Huez

New York City, June 19, 2024 /ENDURANCE SPORTSWIRE/ – York hosted the second edition of GFNY Pennsylvania this past Sunday. The undulating race course was just 67.8 miles yet boasting an elevation gain of no less than 6053 feet. Under perfect weather conditions, the race started off with a strong...

Cycling

Events

Press Releases