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

April 22, 2024

Lizzie Orchard and Benjamin Forbes Clinch XTERRA Australia Crowns

DUNSBOROUGH, AUSTRALIA /ENDURANCE SPORTSWIRE/ – The fourth stop on the XTERRA APAC Tour concluded with a closely contested elite women’s race, where Elizabeth “Lizzie” Orchard (NZL) narrowly secured victory, finishing just 27 seconds ahead of Hannah-Lee Young (AUS) alongside Ben Forbes (AUS) in the men’s race, emerging victorious at XTERRA...

Cycling

Events

Press Releases

Running

Triathlon

April 22, 2024

Iestyn Harrett and Marta Lagownik Secure First Professional Victories at Anfi Challenge Mogán Gran Canaria

/ENDURANCE SPORTSWIRE/ – Today’s Anfi Challenge Mogán Gran Canaria race was nothing short of spectacular. The race, featuring over 40 elite triathletes, witnessed intense competition from start to finish in both the men’s and women’s races with Iestyn Harrett (GBR) and Marta Lagownik (POL) both taking maiden professional wins in...

Events

Press Releases

Triathlon

April 19, 2024

Tour of Somerville: A Celebration of Community, Cycling, and Unbridled Thrills Enters its 79th Year

Somerville, NJ /ENDURANCE SPORTSWIRE/ - The adrenaline-fueled excitement of competitive cycling is poised to take center stage in Somerville as the iconic "Tour of Somerville" gears up for its 79th-year edition. Organized by Arts on Division and Long Tail Productions, this event has evolved into a community-wide celebration that invites...

Cycling

Events

Press Releases

April 19, 2024

Molokaʻi-2-Oʻahu Paddleboard World Championships Sells Out

HONOLULU, HI (April 19th, 2024) /ENDURANCE SPORTSWIRE/ – Molokaʻi-2-Oʻahu Paddleboard World Championships presented by the Hawai‘i Tourism Authority(M2O) is officially SOLD OUT for the 32-mile race across the Kaiwi channel, connecting the Hawaiian Islands of Moloka‘i and O‘ahu. The prestigious race attracts over 250 of the world’s best paddlers from 25+...

Events

Press Releases

April 18, 2024

OUTRIGGER Resorts & Hotels Digs In as Title Sponsor of The Big West Men’s and Women’s Volleyball Championship

HONOLULU /ENDURANCE SPORTSWIRE/ - OUTRIGGER Resorts & Hotels, the Official Hospitality Partner of The Big West, is the title sponsor for The Hawaiian Islands presents the 2024 OUTRIGGER Big West Men‘s Volleyball Championship, April 18-20, 2024 at SimpliFi Arena at Stan Sheriff Center. As part of a multi-year partnership renewal...

Events

Press Releases

Sponsorship

April 18, 2024

April 21st Marks the 20th Anniversary of the Delaware Running Festival

Wilmington, DE/ENDURANCE SPORTSWIRE/ – Corrigan Sports Enterprises (CSE) is thrilled to announce the commemoration of its 20th anniversary, celebrating two decades of hosting an event that promotes health and community spirit. The Delaware Running Festival will celebrate its 20th Anniversary on Sunday, April 21 with over 2,500 runners. Participants of...

Events

Press Releases

Running

April 18, 2024

Tyler McCandless: The Champion Returns to Conquer DICK’S Sporting Goods Pittsburgh Marathon Once More

PITTSBURGH, PA (April 18, 2024) /ENDURANCE SPORTSWIRE/ – The streets of Pittsburgh are set to witness a battle of endurance and speed as defending champion Tyler McCandless gears up to claim victory at the 2024 DICK’S Sporting Goods Pittsburgh Marathon. McCandless, who broke the finisher’s tape in 2:16:08 last year,...

Events

Press Releases

Running