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 (22)
) 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 1530, 10

October 29, 2021

Competitive Cyclist Named Official E-Commerce Partner of L39ION of Los Angeles

PARK CITY, Utah (Oct. 29, 2021) /ENDURANCE SPORTSWIRE/ - Competitive Cyclist, the premier online retailer for premium cycling gear and apparel, and L39ION of Los Angeles, a trailblazing professional cycling team devoted to progressing the sport through representation and inclusion, have teamed up for a multi-year partnership. The partnership announcement...

Cycling

Press Releases

Sponsorship

October 29, 2021

Community Halloween Event and Trick or Treating to Kick-Off Saturday’s Into The Lion’s Den Powered By SRAM

SACRAMENTO (October 29, 2021) /ENDURANCE SPORTSWIRE/ – In addition to world class cyclists, families will also line up on the Into the Lion’s Den powered by SRAM starting line on Saturday, October 30th at 1:00pm. The first event on course will be the Community Halloween Event, where families can casually...

Cycling

Events

Press Releases

Sponsorship

October 22, 2021

The Epigenetic Rhode Runner

Narragansett, Rhode Island. /ENDURANCE SPORTSWIRE/ - Performance Medicine® introduces epigenetic performance testing and related cutting-edge protocols for endurance athletes at the Narragansett Marathon this Sunday. The iconic event is one in a series of Ocean State Rhode Races [OSRR] managed and promoted by Susan Rancourt and Karen Cox, visionary owners of...

Press Releases

Running

Sponsorship

October 22, 2021

Austin Marathon Creates Opportunity for Local Businesses to Sponsor Aid Stations

AUSTIN, Texas, October 22, 2021 - /ENDURANCE SPORTSWIRE/ - The Ascension Seton Austin Marathon presented by Under Armour invites local businesses to sponsor aid stations and join the 30th-anniversary festivities. This newly created opportunity costs nothing and includes local establishments and national businesses with an Austin presence. Operating one of...

Business

Events

Press Releases

Running

Sponsorship

October 21, 2021

Olympic Medallist Signs with MANA

/ENDURANCE SPORTSWIRE/ - Olympic and Commonwealth Games medalist Henri Schoeman has joined the growing roster of MANA Sports & Entertainment Group athletes. Schoeman has won for South Africa a bronze medal at the 2016 Rio Olympic Games and gold at the 2018 Commonwealth Games. He is also the top-ranked triathlete...

Press Releases

Sponsorship

Triathlon

October 20, 2021

BMW Dallas Marathon Festival Will Be First U.S. Marathon Course To Feature SuperStarch-based Energy Pouch ‘UCAN Edge’

(DALLAS) /ENDURANCE SPORTSWIRE/ - The UCAN Company will return this year as an official sponsor of the BMW Dallas Marathon Festival weekend, where it will debut its innovative new product UCAN Edge, the first and only SuperStarch-based energy product in a portable pouch. “Races are a wonderful opportunity to bring people...

Events

Press Releases

Products

Running

Sponsorship