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

March 7, 2024

Run, Walk, or Roll: Inaugural U. S. Steel Pittsburgh Champions Mile Invites All Abilities to Join the Celebration at the DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events

PITTSBURGH (March 7, 2024) /ENDURANCE SPORTSWIRE/ – P3R is excited to announce the newest addition to the 2024 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events - the U. S. Steel Pittsburgh Champions Mile. This untimed, inclusive event welcomes everyone to join in a celebration of inclusion, joy, and bravery,...

Events

Giving

Press Releases

Running

March 7, 2024

GFNY opens 2024 with GFNY República Dominicana this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY República Dominicana offers riders a 149.7 km race course with an elevation gain of 962 m, starting and finishing at world famous Punta Cana, known for its white sand beaches and blue turquoise water. “If you’re slowly emerging from US winter, a March trip...

Cycling

Events

Press Releases

March 7, 2024

‘Miami Course Is Just Where I Belong’ – Jason West Eyes T100 Lift Out

Miami, USA/ENDURANCE SPORTSWIRE/ – Jason West cannot wait for the gun to go on the new T100 Triathlon World Tour this Saturday, 9 March. In the form of his life heading into the opening Miami T100 at CLASH Endurance Miami, the American is on familiar ground having won at the...

Events

Press Releases

Triathlon

March 7, 2024

Brownlee, Taylor-Brown and Beaugrand All Confirmed For supertri E World Triathlon Championship powered by Zwift

LONDON, UK/ENDURANCE SPORTSWIRE/ – British stars Jonny Brownlee and Georgia Taylor-Brown will make their only major UK appearance before the Paris Olympics as they headline the supertri E World Triathlon Championship in London on April 13. Brownlee is at the start of a year that is likely to see him...

Events

Press Releases

Triathlon

March 7, 2024

Ruthless 719 Ride Returns for the 2024 SUAREZ Gran Fondo National Series

Gettysburg, PA – March 7, 2024 /ENDURANCE SPORTSWIRE/ – Gran Fondo National Series is proud to announce the continuation of its partnership with the 719 Ride cycling event in Colorado Springs. For the second year, 719 Ride participants can earn points toward the season-long Gran Fondo National Series Points Competition and qualify for the...

Business

Cycling

Events

Press Releases

Sponsorship

March 7, 2024

CLASH Endurance to Host Star-Studded Field of Olympic Medalists, Paralympians and World Champions to Homestead-Miami Speedway This Weekend

March 5, 2024 /ENDURANCE SPORTSWIRE/ - CLASH Endurance is excited to host more than 14 Olympians, numerous Paralympians and triathlon’s World Champions to the historic Homestead-Miami Speedway this weekend for the Americas Triathlon Championship and T100 Events taking place on Friday and Saturday. The Americas Triathlon Championship on Friday includes...

Awards

Cycling

Events

Press Releases

Running

Triathlon

March 6, 2024

Showcased

MarathonFoto and Bank Of America Chicago Marathon Extend Partnership For An Additional 8 Years

/ENDURANCE SPORTSWIRE/ – MarathonFoto, the leading global provider of race photography services, is excited to announce an 8-year extension of its long-standing partnership with the Bank of America Chicago Marathon. This renewal further solidifies the remarkable collaboration that began in 1983, marking more than four decades of celebrating the athletes...

Business

Events

Press Releases

Running