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

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

July 17, 2024

2024 XTERRA European Trail Run Championship: Pyrenees Preview

/ENDURANCE SPORTSWIRE/ – On July 20-21, the untamed beauty of the Pyrenees will be conquered, not just admired. Selfie sticks will give way to trail running poles, and tour groups will be replaced by scores of Europe’s toughest competitors, each battling for the title of 2024 XTERRA European Trail Run...

Events

Press Releases

Running

July 17, 2024

Foil Race Kicks Off 25th Anniversary Molokaʻi 2 Oʻahu Paddleboard World Championships

Now over two weekends, the open ocean challenge begins on Sunday, July 21 with the foil race, followed by the prone and standup paddleboard race on July 28, 2024. Foil athletes will break in a new longer and faster course that will finish off the shore of Kaimana Beach in...

Events

Press Releases

Sponsorship

July 17, 2024

The Marin Mile Partners with Movemint for 2025

SAN FRANCISCO [07/17/24] /ENDURANCE SPORTSWIRE/ - The Marin Mile is set to join the Movemint event platform for the 2025 edition of the race. This exciting partnership marks a step forward in the evolution of The Marin Mile, ensuring the event continues to meet the evolving needs of its vibrant...

Events

Press Releases

Running