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

November 12, 2024

Short and Long Course Athletes to Go Head to Head at Challenge Canberra

/ENDURANCE SPORTSWIRE/ - Challenge Canberra is delivering a full festival of sport to Australia’s capital city this weekend, 16/17 November, with no less than six event over two days, including the Pro Open combining the Standard and Sprint distances, and age group worlds qualifying events. The Pro Open will be...

Events

Press Releases

Triathlon

November 11, 2024

Pike on a Bike: Pi Kapa Alpha Fraternity Brothers Complete 8,423 Minutes Stationary Bike Ride, Raising $48,318 in Honor of The 8,423 Cyclists and Pedestrians Killed Last Year By Riders

November 11th. /OUTDOOR SPORTSWIRE/ - BOULDER, CO — In a powerful demonstration of endurance and purpose, Pi Kappa Alpha fraternity brothers completed an extraordinary 8,423-minute stationary bike ride – one minute for every cyclist and pedestrian killed on U.S. roads in 2023. Their wheels never stopped turning during the six-day...

Cycling

Events

Giving

Press Releases

November 11, 2024

The Monterey Bay Half Marathon Welcomes 8,000+ Runners for Its 19th Presentation

November 11th. /ENDURANCE SPORTSWIRE/ - MONTEREY, CA – The 19th Annual Monterey Bay Half Marathon, which took place on Sunday, November 10th, welcomed its largest field of participants in seven years to enjoy the dramatic beauty of the central coast. Race weekend included a two-day expo in downtown Monterey, the...

Events

Press Releases

Running

November 11, 2024

Challenge Family World Bonus Top Placings Decided at Challenge Xiamen

November 11th. /ENDURANCE SPORTSWIRE/ - After a thrilling day’s racing at yesterday’s Challenge Xiamen, it’s all change in the Challenge Family World Bonus, with Jack Moody (NZL) and Alanis Siffert (SUI) now confirmed as unbeatable for 2024. While the winning titles of the inaugural Challenge Xiamen were being contended, there...

Events

Press Releases

Triathlon

November 10, 2024

More than 6,700 athletes take part in the 2024 Boston Half presented by Dana-Farber Cancer Institute and the Jimmy Fund

BOSTON /ENDURANCE SPORTSWIRE/ - The 2024 Boston Half presented by Dana-Farber Cancer Institute and the Jimmy Fund took place today under beautiful blue skies, starting and finishing within Boston’s Franklin Park. A total of 6,767 athletes started today’s race, with preliminary results for all finishers available here. It was an...

Events

Press Releases

Running

November 10, 2024

Memorable Wins for Stojanović and Siffert at Inaugural Challenge Xiamen

/ENDURANCE SPORTSWIRE/ - In his seventh Challenge Family race of the season, Ognjen Stojanović (SRB) took that elusive first Challenge win today at Challenge Xiamen in 3:41:02 and confirmed his second position in the Challenge Family World Bonus. And it was a faultless performance from Alanis Siffert (SUI) who dominated...

Events

Press Releases

Triathlon

November 8, 2024

Frias, TenKate Win Santa Barbara Half Marathon presented by HOKA

SANTA BARBARA, Calif. November 8th /ENDURANCE SPORTSWIRE/ – On a spectacular sunny Sunday morning, November 3, Chris Frias, 33, of Ventura and Melissa TenKate, 35, of Arroyo Grande won the fourth Santa Barbara Half Marathon presented by HOKA, clocking 1 hour, 8 minutes, 33 seconds and 1:22:05, respectively. For Frias,...

Events

Press Releases

Running

November 7, 2024

Shop Women-Led Wednesday To Support Women In Business This Spending Season

Sun Valley, ID (Nov. 7, 2024) /ENDURANCE SPORTSWIRE/ - Women-Led Wednesday, the annual purpose-driven holiday that urges the public to shop women-led businesses, returns for the seventh year, calling on consumers to be mindful of their purchasing power leading up to popular eCommerce holidays like Black Friday and Cyber Monday....

Business

Events

Press Releases

Products