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

January 19, 2023

Eaton Becomes Mobile Charging Unit Partner at P3R Events, Including DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events

PITTSBURGH, PA /ENDURANCE SPORTSWIRE/ – P3R announced that Eaton, an intelligent power management company, will be the mobile charging unit partner at all P3R events, including the DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. Through the three-year partnership, convenient and secure phone charging stations will be set up at locations...

Events

Press Releases

Running

Sponsorship

January 19, 2023

3M Half Marathon Welcomes Local Bands for On-Course Music

AUSTIN, Texas, January 19, 2023 /ENDURANCE SPORTSWIRE/ – The 3M Half Marathon has finalized the lineup for its on-course entertainment for the point-to-point race happening this Sunday, January 22 in Austin, Texas. The ten local bands and DJ join the race-day excitement and perform live music for participants along the 13.1...

Events

Press Releases

Running

January 18, 2023

Ramble Ride returns for season number eight with new rides in Arkansas and California.

Wednesday, January 18, 2023 /Fort Collins, Colorado /ENDURANCE SPORTSWIRE/ – Registration for the Ramble Ride, returning for an eight-season with events in Arkansas, California, Colorado, and Utah, is now open. "We're excited for this season of events," says Peter Discoe, promoter of the Ramble Rides. "Our Colorado route is our staple, but...

Cycling

Events

Press Releases

January 18, 2023

Professional Triathletes Organisation Announces Singapore Will Host New PTO Asian Open Race For Next 3 Years

London, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) today announced the continued expansion of its PTO Tour, with the inaugural staging of the PTO Asian Open in Singapore on 19-20 August, 2023. In a multi-year partnership between the PTO, The Singapore Tourism Board (STB) and Sport Singapore (SportSG), the PTO...

Events

Press Releases

Triathlon

January 17, 2023

Challenge Family Welcomes First Race in Central Asia – Challenge Samarkand

/ENDURANCE SPORTSWIRE/ – Challenge Family enters Central Asia for the first time with the launch of Challenge Samarkand. The new middle distance race in Uzbekistan will take place on 16-17 September, working with the Uzbekistan Triathlon Federation to take the sport of triathlon in the region to the next level. "We...

Events

Press Releases

Triathlon

January 17, 2023

Life Time Presents Gripping, Original Docuseries on Inaugural Life Time Grand Prix presented by Mazda

Boulder, Colo., (Jan. 17, 2023)/ENDURANCE SPORTSWIRE/ – Life Time (NYSE: LTH), the nation’s premier healthy lifestyle brand, announces “Call of a Life Time,” a docuseries made up of six binge-worthy episodes that follows the elite women and men in the inaugural Life Time Grand Prix presented by Mazda. Launching on January 27,...

Cycling

Events

Press Releases

Products

January 17, 2023

National Cycling League (NCL) announces ZIeL Concept Store as the Miami Race Fan Headquarters and Club House for the Miami Nights Cycling Club

Miami, FL, January 17, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League, the first of its kind in professional sports built around 21st century values of diverse ownership, gender equality, technology, and sustainability, today announced that it has selected ZIeL Concept store, Miami’s preeminent cycling resource and lifestyle community store as the...

Business

Cycling

Events

Press Releases