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

April 24, 2024

Top Contenders Line Up for The Championship 2024

/ENDURANCE SPORTSWIRE/ – The Challenge Family flagship event over the middle distance, The Championship, is less than a month away. More than 80 professional athletes will line up alongside over 1,600 age group athletes from 57 nations to decide Challenge Family’s ultimate accolade, Champion of The Championship, on 19 May...

Events

Press Releases

Triathlon

April 24, 2024

Delaware Running Festival Celebrates 20th Anniversary with Record-Breaking Success

Wilmington, Delaware - April 24, 2024 /ENDURANCE SPORTSWIRE/ – The Delaware Running Festival marked its 20th anniversary on Sunday, April 21st, at Tubman Garrett Park. Hosted by Corrigan Sports Enterprises (CSE), the event welcomed runners from across the nation, with participants representing 48 states in various races including the full...

Events

Press Releases

Running

April 24, 2024

ASICS Falmouth Road Race Announces Registration Launch Dates

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – Organizers of the ASICS Falmouth Road Race have officially announced the registration dates for the 52nd annual event taking place Aug. 18. Falmouth resident applications will be accepted starting May 1 and closing May 7, while general registration for non-Falmouth residents will be open from...

Events

Press Releases

Running

April 23, 2024

Boston Triathlon to Add New Global Professional Race

BOSTON, MA – April 23rd, 2024/ENDURANCE SPORTSWIRE/ – ethos, a mass participation event organization that produces the Columbia Threadneedle Investments Boston Triathlon and Kids Day at the Boston Tri today announced the addition of supertri Boston to their weekend of exciting racing this coming August. The Boston Triathlon is excited to...

Business

Events

Press Releases

Triathlon

April 23, 2024

Over 8,000 Athletes Head to Asia’s Largest Triathlon at Challenge Taiwan

/ENDURANCE SPORTSWIRE/ - Selling out in hours with over 8,000 athletes, Asia’s must-do triathlon, Challenge Taiwan, returns this weekend on 27/28 April with an international pro race over the middle distance and a true celebration of age group sport at every age and level. Last year’s men’s champion, Caleb Noble...

Events

Press Releases

Triathlon

April 22, 2024

Kia America Returns as Official Automotive Partner of the 2024 Hoag OC Marathon Running Festival

ORANGE COUNTY - (April 22, 2024) /ENDURANCE SPORTSWIRE/ – The Hoag OC Marathon Running Festival today announced Kia America has returned as Official Automotive Partner of the event and sponsor of the Kia Recovery Zone. Set for the weekend of May 3-5, 2024, the Hoag OC Marathon Running Festival has...

Events

Press Releases

Running

Sponsorship

April 22, 2024

supertri Announces Synergy Wetsuits as Official Wetsuit Partner for 2024 Mass Participation Races

/ENDURANCE SPORTSWIRE/ – supertri, the leading provider of world class triathlon events, can today announce Synergy Wetsuits as the official wetsuit partner for the highly anticipated 2024 Long Beach Legacy Triathlon and the 2024 Chicago Triathlon. As well as supplying high-performance wetsuits, Synergy Wetsuits will also provide convenient rental options...

Events

Press Releases

Sponsorship

Triathlon

April 22, 2024

Bank of America Chicago 13.1 Receives Evergreen Certification from the Council for Responsible Sport

CHICAGO /ENDURANCE SPORTSWIRE/ – The Bank of America Chicago 13.1 and Council for Responsible Sport announced today the event earned Evergreen Certification, a recognition reserved for sporting events that demonstrate the highest possible commitment to environmental and social responsibility. The Chicago 13.1 debuted in 2022 with the vision to reimagine...

Events

Press Releases

Running