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

November 4, 2021

T S Restaurants Partners with XTERRA Worlds

Kapalua, Maui (November 4, 2021) – T S Restaurants’ Hula Grill, Duke’s Beach House, Kimo’s and Leilani’s will serve as title sponsors of the XTERRA Kapalua Trail Runs on the island of Maui on Saturday, December 4, 2021. Adding to the lineup and new this year is the XTERRA Trail...

Press Releases

Running

Sponsorship

November 2, 2021

Olympic Bronze Medalist Molly Seidel Joins COROS Pro Athlete Team

Irvine, CA, November 2, 2021 /ENDURANCE SPORTSWIRE/ - COROS Wearables Inc., makers of innovative performance GPS watches is introducing Olympic Bronze Medalist, Molly Seidel, to its Pro Athlete Team. This partnership further strengthens the brand’s commitment to the sport of running and improving the training of athletes of all levels....

Press Releases

Running

Sponsorship

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