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 (8742)
) 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 3010, 10

October 17, 2023

XTERRA Australia 2024: Dynamic Races Await in Dunsborough

DUNSBOROUGH, Western Australia /ENDURANCE SPORTSWIRE/ – The picturesque coastal town of Dunsborough is once again set to host XTERRA Australia in 2024. This event has rapidly gained a reputation as one of the premier off-road triathlons on the global circuit. Scheduled for April 20-21, it promises to be a blend of...

Events

Press Releases

Running

Triathlon

October 17, 2023

A New Novel Shows Young Girls Just How Strong They Can Be

/ENDURANCE SPORTSWIRE/ – The Strong Girl by Molly Hurford, author of the Shred Girls series, is hitting the shelves on October 17, 2023. This is Hurford’s first historical fiction novel and while it has a circus themed setting, the real focus is around the real strength that all girls possess....

Cycling

Press Releases

Products

Running

SWW Syndication

October 17, 2023

The 2023 IMT Des Moines Marathon Shatters Registration Targets For All Events

Des Moines, IA /ENDURANCE SPORTSWIRE/ – The 2023 IMT Des Moines Marathon race weekend smashed expectations for race organizers and participants of the IMT Des Moines Marathon & Half Marathon, the Bankers Trust Marathon Relay, the Principal 5K Road Race, and the MercyOne Children’s Hospital Kids Run. Held on Sunday, October...

Events

Press Releases

Running

October 17, 2023

Empowering The Athlete Within: Exercise Intelligence Partners with Supersapiens

Atlanta – 17 October 2023 /ENDURANCE SPORTSWIRE/ – Supersapiens, the world’s first glucose management system for athletes, is excited to announce its strategic partnership with Exercise Intelligence (EXI), an acclaimed health and exercise innovator. United in a shared vision, both entities aim to "awaken the athlete within everyone", harnessing the power...

Business

Press Releases

October 17, 2023

RunSignup Requests Nominations for Alan Jones Timer of the Year Award

Moorestown, NJ – October 17, 2023 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for endurance events in the United States, is now accepting nominations for the Alan Jones Timer of the Year Award. In recognition of the remarkable efforts of race timers, this award honors those who have...

Awards

Press Releases

Running

October 17, 2023

Key West Half Marathon & Runfest Reveals Shirts and Medals for 2024 Race

KEY WEST, Fla. /ENDURANCE SPORTSWIRE/ – The Key West Half Marathon & Runfest, rated a top 10 half marathon by USA Today, is back on Jan. 14, 2024. The event has unveiled new race day shirts that feature artwork by local artist Taylor Hale. Participants will also receive a newly designed...

Events

Press Releases

Running

October 17, 2023

Fundraising Record Broken at the 51st Annual ASICS Falmouth Road Race

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – The 51st annual ASICS Falmouth Road Race saw records broken not only in times clocked on the course but also in charity fundraising. The 2023 event brought in $7,226,357.05, bringing the total overall funds raised since 2000 to $63.7M. This number is thanks to the 3,800...

Business

Press Releases

October 16, 2023

Murf Electric Bikes Unleashes Freedom with Latest Launch – The Higgs Cargo

San Clemente, CA (October 16, 2023) /ENDURANCE SPORTSWIRE/ - Murf Electric Bikes, an e-bike pioneer delivering powerful, yet comfortable solutions for cyclists of all levels, is proud to unveil the latest addition to its e-bike lineup – the Higgs Cargo. This innovative passenger e-bike is designed to provide families with...

Cycling

Press Releases

Products

October 16, 2023

Over 1,300 Registered Runners Took on Kodiak Ultra Marathons by UTMB Over Three Days

BIG BEAR LAKE, Calif. /ENDURANCE SPORTSWIRE/ - The 2023 UTMB® World Series continued with the 2023 Kodiak Ultra Marathons by UTMB® on Oct. 13 - 15. The 10th anniversary of the race featured over 1,300 registered runners from 40 States and 27 countries, regions, and territories as they descended on...

Events

Press Releases

Triathlon

October 16, 2023

Showcased

Concept2 to Offer Kinomap Demonstrations at World’s Largest Regatta

BOSTON (Oct. 16, 2023) /ENDURANCE SPORTSWIRE/ - Kinomap is thrilled to announce that its groundbreaking interactive indoor training app for rowers will be available for demonstration at the Head of the Charles Regatta, taking place Oct. 20-22. The Concept2 demonstration area will be located in Attager Row: Rowing & Fitness...

Events

Press Releases