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

June 5, 2024

Movemint Launches Zapier API Integration to Streamline Events for Organizers

/ENDURANCE SPORTSWIRE/ Streamlined event management Event organizers of all types share a common goal: Create a wonderful experience for their participants, driving increased registrations, donations, and overall enthusiasm for their events. To accomplish this, many organizers use multiple systems for participant management, email marketing, accounting, and more. Zapier is a...

Events

Press Releases

Products

June 5, 2024

Launch of new Boston Marathon logo on Global Running Day symbolizes moving forward together

BOSTON/ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) in partnership with Bank of America, today announced that an anticipated $500 million will benefit mission aligned non-profit organizations over the next decade. The vast majority of these funds will come from the incredible fundraising efforts of those participants in the Bank...

Events

Press Releases

Running

June 5, 2024

Sell-Out Field for Challenge Wales

/ENDURANCE SPORTSWIRE/ – Heading the men’s pro race is Joshua Lewis (GBR) who was third in last year’s Challenge London, but while he may be the highest ranked, he will face stiff competition from fellow countrymen, Kieran Lindars and Iestyn Harrett. Lindars, former European Long Distance Champion, and second at...

Events

Press Releases

Triathlon

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