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

December 2, 2024

Biggest Sale of The Season; Rock ‘N’ Roll Running Series Announces 24-Hour Winter Sale

TAMPA, Fla. (Dec. 2, 2024) /ENDURANCE SPORTSWIRE/ – To celebrate the holidays and provide participants the opportunity to achieve fitness goals for the new year, the Rock ‘n’ Roll® Running Series has announced its 24-hour Winter Sale beginning at midnight Pacific time on Wednesday, Dec. 4, 2024, offering the lowest prices...

Events

Press Releases

Running

December 2, 2024

Traverse Tanzania GRVL Joins Gran Fondo World Tour® Gravel Series 2025

December 2. /ENDURANCE SPORTSWIRE/ - Since its inception in 2016, the series has continually grown, offering the most sought-after destinations for gravel enthusiasts. Traverse Tanzania GRVL represents a significant step forward in providing tailored, all-inclusive events that cater to gravel travelers seeking adventure and challenge. "At Gran Fondo World Tour®,...

Business

Cycling

Events

Press Releases

December 1, 2024

Gregory Barnaby (ITA) And Marta Sanchez (ESP) Claim IRONMAN 70.3 Western Australia Asia-Pacific Championship Titles and Maximum Points

Gregory Barnaby’s win in Busselton moves the Italian to the top of the IRONMAN Pro Series with just one race to go Barnaby claims his first IRONMAN 70.3 triathlon title, while Marta Sanchez secures her second of the year. As race winners, Barnaby and Sanchez earn the maximum 2,500 IRONMAN...

Events

Press Releases

Triathlon

November 29, 2024

Explore Exciting Roles at the Austin Marathon Recruitment Event

AUSTIN, Texas, November 29, 2024 /ENDURANCE SPORTSWIRE/ - High Five Events, the parent company behind the Ascension Seton Austin Marathon and other premier endurance events, invites individuals passionate about event production to join a recruitment session for prospective team members on Saturday, December 7, 2024, at 10:00am. The event will...

Business

Cycling

Events

Press Releases

Running

Triathlon

November 27, 2024

3rd GFNY Puerto Rico closing out 2024 GFNY season of 28 races

New York City, November 27, 2024 /ENDURANCE SPORTSWIRE/ - The city of Ponce, hosted the third edition of GFNY Puerto Rico last Sunday. The racecourse was 130.8km with 2637m of climbing. After the seven neutralized kilometers through the town of Ponce, the race was opened and Bryan León (Puerto Rico)...

Cycling

Events

Press Releases

November 27, 2024

Winter Adventure Race Expands

MERRILL (November 27) /ENDURANCE SPORTSWIRE/ – After three years in the books, the Rib Mountain Adventure Challenge – Winter Edition returns December 7, 2024 with expanded race offerings. In addition to the existing 3-hour race option, a 6-hour and a 3-hour no bike option are available to winter enthusiasts. Racers...

Cycling

Events

Press Releases

Running