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

June 16, 2022

lululemon and DMSE Sports Present the 2022 lululemon 10K Tour

Boston, June 16, 2022/ENDURANCE SPORTSWIRE/ – DMSE Sports is thrilled to announce its continuing partnership with lululemon for the lululemon 10K Tour. The Tour will arrive in two U.S. locations for 2022. The Atlanta 10K Tour stop will be run on Saturday, October 22, and the Houston 10K will be run on...

Events

Press Releases

Running

June 16, 2022

The 2022 DICK’S Sporting Goods Pittsburgh Marathon Was a “Zero Waste” Event, Diverting 92 Percent of the Event’s Waste from the Landfill

PITTSBURGH, PA (June 16, 2022)/ENDURANCE SPORTSWIRE/ – The 2022 DICK’S Sporting Goods Pittsburgh Weekend of Events once again was a “zero waste” event with 92% of the event’s waste diverted from landfills. P3R, along with the help of community partners, successfully recycled, reused or composted approximately 26,500 pounds of waste generated...

Events

Press Releases

Running

June 16, 2022

‘La Vuelta Virtual 22’ June’s Warm-Up Racing Series – Win A VIP Experience in Madrid from home

Madrid, Spain / June 16th, 2022/ENDURANCE SPORTSWIRE/ – The 77th edition of the real La Vuelta 22 will start on Friday the 19th of August and finish on Sunday the 11th of September, from Utrecht (the Netherlands) to Madrid, World Capital of Sports 2022. The Spanish Grand Tour in 2022 will...

Cycling

Events

Press Releases

June 16, 2022

GFNY back at L’Alpe d’Huez

New York City, June 16, 2022/ENDURANCE SPORTSWIRE/ – After conquering the legendary Col du Tourmalet in the French Pyrenees a few days ago at GFNY Lourdes, GFNY riders get to race another iconic climb this Sunday: L’Alpe d’Huez. GFNY La Vaujany is 145.1 km long with 3663m of climbing, including Col...

Cycling

Events

Press Releases

June 15, 2022

XTERRA Short Track Lures Off-Road Elite to France

June 15, 2022/ENDURANCE SPORTSWIRE/ –  The XTERRA off-road triathlon racing season heads into primetime July 2 in Xonrupt, France with the first of four events in the 2022 XTERRA Short Track Series. XTERRA Short Track is an invite-only event exclusive to the top 25 eligible men and women. While qualification procedures...

Events

Press Releases

Triathlon

June 15, 2022

Lake Sonoma Race Series Expands to Multiple Weekends with New Distances in 2022 and Looks for Even More in 2023

/ENDURANCE SPORTSWIRE/ – 2022 was a huge year for the iconic Lake Sonoma Race Series (LSRS), which has grown from its roots as a small-town charity race founded by John Medinger fifteen years ago into a four-race series with distances from the marathon up to 100K.  The relentlessly hilly, winding courses...

Events

Press Releases

Running

June 15, 2022

Professional Triathlete, Timothy O’Donnell, Qualifies for IRONMAN World Championships 15 Months After Harrowing On-Course Heart Attack

CAMBRIDGE, Mass.—June 15, 2022 /ENDURANCE SPORTSWIRE/ - Professional triathlete, Timothy O’Donnell, yesterday qualified for the IRONMAN World Championships in Kailua-Kona, Hawaii, with a time of 8:10:07 and a third-place finish at IRONMAN Des Moines. This marks the 11th time O’Donnell has qualified for the World Championships, but is remarkable in...

Events

Press Releases

Triathlon

June 15, 2022

Expedition Canada Takes World Series Adventure Racing Back to its Roots

/ENDURANCE SPORTSWIRE/ – Expedition Canada attracted international teams from 7 different nations to the town of Kelowna in British Columbia, Canada, for the 5th event in the 2022 Adventure Racing World Series. After staging a Demonstration Race last year, the event stepped up to full AR World Series membership this year,...

Events

Press Releases