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

October 5, 2022

She Tris Finishes the Season With Record Carnes Crossroads Turnout

  Charleston, SC /ENDURANCE SPORTSWIRE/ - She Tris Sprint Triathlon culminated the 2022 triathlon season with the 6th annual Crews Subaru She Tris Sprint Triathlon Carnes Crossroads and Crews Subaru She Tris Girl events at the end of Septemberin Summerville, South Carolina. The morning was a cool fall morning that...

Events

Press Releases

Triathlon

October 5, 2022

BibRave Drives Sell-Out Numbers for the Inaugural Pacific Beach Half Marathon & 5K

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently partnered with the San Diego Running Co. (SDRC) to provide comprehensive marketing services for the Pacific Beach Half Marathon & 5K. BibRave provided branding ideation and complete digital media management strategy and services leading to sell-out registrations...

Events

Press Releases

Running

October 5, 2022

Run4Recovery five-day, 502-mile ride concludes with community celebration in Covina

Oct. 5, 2022. COVINA, Calif. /ENDURANCE SPORTSWIRE/ – The 15th annual Run4Recovery concluded this weekend as Robin McGeough and Norman "FUJI" Fujimoto completed their five-day, 502-mile bike ride across southern California. The duo began their journey on Sept. 26, and finished on Saturday to cheers from spectators awaiting their return at Aurora...

Cycling

Events

Giving

Press Releases

October 4, 2022

National Cycling League Announces $1 Million Prize Purse and 2023 Host Cities

(New York, N.Y., October 5, 2022) /ENDURANCE SPORTSWIRE/ - The National Cycling League (NCL) is proud to announce the largest prize purse in U.S. crit racing history with a $1 Million up for grabs. To win their share of the purse, 10 teams (2 NCL teams and 8 invited teams)...

Business

Cycling

Events

Press Releases

Sponsorship

October 4, 2022

Showcased

100% Takes On The Mountain With Their First Collection Of Snow Goggles

SAN DIEGO, Calif. – October 4, 2022 /ENDURANCE SPORTSWIRE/ – 100%® unveils the 2022/23 Snow Collection created by world-class designers & engineers in California. The debut series was developed to exceed the performance expectations of top global snow athletes while catering to the weekend warriors and welcoming new adventurers to the...

OSW Syndicated

Press Releases

Products

SWW Syndication

Wire Syndication

October 4, 2022

Pau Hana: 2022 VinFast IRONMAN World Championship Daily Recap for Tuesday, October 4, 2022

KAILUA-KONA, Hawai`i (October 4, 2022) /ENDURANCE SPORTSWIRE/ – Athlete voices echoed loud today, Tuesday of race week for the 2022 VinFast IRONMAN World Championship. Here is the daily Pau Hana, a Hawaiian phrase meaning “end of the workday,” recapping highlights from the last 24 hours. PRE-RACE PRO PRESS CONFERENCE The male...

Events

Press Releases

Triathlon

October 4, 2022

Pau Hana: 2022 VinFast IRONMAN World Championship Daily Recap for Sunday, October 2, 2022

KAILUA-KONA, Hawai`i / TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - Race week for the 2022 VinFast IRONMAN World Championship kicked off today in Kailua-Kona, Hawai`i and with it, the plethora of activities and events. In the return of world’s most iconic endurance sports event, which is taking place for the first time...

Events

Press Releases

Triathlon

October 4, 2022

Showcased

2 von Bergs Make History at IRONMAN Hawaii

Pro Rudy von Berg, 29, and brother Maximilien, 35, will make their first appearance at Ironman Hawaii, Kona. It is also the first time in Ironman History that a Pro will be on the starting line with a brother racing as an age grouper. The Tinleys, in the 1980’s, were...

Press Releases

Triathlon

October 4, 2022

PeaceHealth AppleTree Marathon Festival offers a Run through History

Vancouver, WA /ENDURnce sportswire/ - The 5th annual Peacehealth Appletree Marathon festival on Sept 17th & 18th attracted 1125 athletes from two countries and 22 states. The race was on its way to becoming a northwest favorite with incredible waterfront scenery, a ‘run through history’ theme and a Boston-qualifying flat...

Events

Giving

Press Releases

Running