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

June 5, 2024

Standard Chartered Singapore Marathon 2023 announced as Best Sports Event of the Year at the 2024 Singapore Sports Awards

SINGAPORE, 4 June 2024 /ENDURANCE SPORTSWIRE/ - Standard Chartered Singapore Marathon (SCSM) 2023 was awarded Best Sports Event of the Year in the Community and Mass Participation Category at the 2024 Singapore Sports Awards (SSA) held last night. The IRONMAN Group, organisers of the Standard Chartered Singapore Marathon, accepted the...

Awards

Events

Press Releases

Running

June 5, 2024

Running USA Announces Industry Safety Day, Set for Sept. 17 in Atlanta

ATLANTA (June 5, 2024) /ENDURANCE SPORTSWIRE/ - Running USA, North America’s leading trade organization for the running industry, will offer CPR certification and crisis management training to its members at its first ever Safety Day to be held in Atlanta on Tuesday, September 17. This regional training will be free...

Events

Press Releases

June 5, 2024

Year Ten of the Teton Ogre Adventure Race to Take Place June 8th

/ENDURANCE SPORTSWIRE/ - In its tenth iteration, the Teton Ogre Adventure Race will take place in beautiful Swan Valley, Idaho, this coming Saturday, June 8th. One hundred racers from all over the country will take on the 24-hour event this year, which includes high mountain trekking through a lingering spring...

Events

Press Releases

June 5, 2024

Wawanesa Insurance joins the 2024 Under Armour Toronto 10K

TORONTO/ENDURANCE SPORTSWIRE/ –  Canada Running Series is thrilled to announce that Wawanesa Insurance will be joining the Under Armour Toronto 10K next month. Wawanesa is a Canadian-owned and operated company with a vision to build a safer, healthier, and more sustainable future - a commitment that aligns perfectly with Canada...

Events

Press Releases

Sponsorship

June 5, 2024

Inaugural GFNY Paracas this Saturday

/ENDURANCE SPORTSWIRE/ – This Saturday, GFNY Paracas offers riders a 116 km race course with an elevation gain of 662 m. Paracas, located on the west coast of Peru where the desert meets the Pacific ocean, combines history, natural beauty and adventure. “After several successful editions in the high Andes,...

Cycling

Events

Press Releases

June 4, 2024

IRONMAN Launches Brand-New Podcast: IRONMAN Insider Presented by Maurten

TAMPA, Fla. (June 4, 2024) /ENDURANCE SPORTSWIRE/ - IRONMAN is excited to announce the launch of a brand-new podcast, IRONMAN Insider™ presented by Maurten. The podcast is scheduled to be released bi-weekly, plus bonus episodes, and will delve into the culture and sport of long-course triathlon, bringing fans new insights...

Events

Press Releases

Products

Triathlon

June 4, 2024

Big River Race Management Times Two National Records at HOKA Festival of Miles

ST. LOUIS (June 4, 2024)/ENDURANCE SPORTSWIRE/ – Big River Race Management timed back-to-back national high school records at HOKA Festival of Miles while providing in-depth timing services for the track meet nationally renowned for its fast times on Thursday, May 30, 2024. Allie Zealand a senior from Pacers Homeschool (VA) won...

Events

Press Releases

Running

June 4, 2024

Verge Cycling Apparel Announces Sponsorship of the Prospect Park Women’s Series

NEW YORK, June 4th /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel is thrilled to announce its sponsorship of the Prospect Park Women's Series, now officially named the Prospect Park Women's Series presented by Verge. This exciting series takes place in the heart of Brooklyn, NY, and...

Cycling

Events

Press Releases

Sponsorship