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

September 9, 2023

Second India National AR Championship Starts at Goa

/ENDURANCE SPORTSWIRE/ – The second 2023 Adventure Racing Championship India (ARCI) takes place this weekend in Goa. The race is a National Championship event which is also the qualifier for the ARWS Asia Regional Championship and is hosted by NthAdventure, India’s only licensed ARWS organization. Adventure Racing is a fast-growing...

Events

Press Releases

September 8, 2023

6,000 Runners Ready to Race at 2023 Volvo Santa Monica Classic

SANTA MONICA, CA – September 08, 2023 /ENDURANCE SPORTSWIRE/ – The stage is set, registration is sold-out and an exhilarating day of running and breathtaking views are in store for more than 6,000 runners as the Volvo Santa Monica Classic presented by ASICS returns this Sunday, September 10. Featuring three distances...

Events

Press Releases

Running

September 7, 2023

B.A.A. Announces Expanded Para Athletics Divisions & Enhanced Prize Money Awards for 2024 Events

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) today announced plans for an enhanced prize money structure across B.A.A. events in 2024, as well as the introduction of two new Para Athletics Divisions for athletes competing with coordination impairments (T35-T38) and intellectual impairments (T20) as well as more inclusive upper...

Events

Press Releases

Running

September 7, 2023

Do you own a road bike? Come and try the 2023 Cycling Time Trials Road Bike Championships

/ENDURANCE SPORTSWIRE/ – The team at Cycling Time Trials (CTT) are excited to share that FTP Racing (Fulfill The Potential) will be hosting the 2023 edition of their Road Bike Championships; an inclusive event which welcomes all cyclists to take part - all you need is a road bike, helmet,...

Cycling

Events

Press Releases

September 7, 2023

San Francisco Marathon Exceeds Fundraising Goal by 70% for Charity with GoFundraise Partnership

/ENDURANCE SPORTSWIRE/ – The annual San Francisco Marathon, in partnership with online fundraising platform GoFundraise, proudly announced today that they've exceeded their fundraising goal by an impressive 70% for non-profit organizations. Participants could choose to fundraise for the Marathon's partner charities or from the wide range of charities available on...

Events

Giving

Press Releases

Running

September 7, 2023

BibRave Scores Big with the 2023 San Francisco Giant Race Presented by Alaska Airlines

Honolulu, HI/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, partnered for the second year with Giants Enterprises, the entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, to provide marketing services for the 14th annual San Francisco Giant Race presented by Alaska Airlines. This collaboration resulted...

Events

Press Releases

Running

September 7, 2023

Ultra X and Ecolibrium Partner to Drive Sustainable Racing

/ENDURANCE SPORTSWIRE/ – Ultra X, a prominent name in the world of ultramarathon events, is excited to announce a partnership with ecolibrium, a growing community of festivals, suppliers, artists and music companies taking action to reduce the environmental impacts of travel, the largest source of emissions from live events. The...

Business

Events

Press Releases

Running

September 6, 2023

The Dimock Center, Hoodfit and Boston Athletic Association Host the Road to Wellness 5k Run/2-Mile Walk

ROXBURY (September 6, 2023) /ENDURANCE SPORTSWIRE/ - On Saturday, September 9th, The Dimock Center, HoodFit and the Boston Athletic Association (B.A.A.) will host the 9th Annual Road to Wellness 5K Run/2-Mile Walk. The race will be staged at The Dimock Center at 55 Dimock Street in Roxbury and the 5K...

Events

Press Releases

Running

September 6, 2023

New York City Triathlon & Duathlon produced by Life Time Features New Fall Date and $19,000 Prize Purse for Pros

NEW YORK – (Sept. 06, 2023)/ENDURANCE SPORTSWIRE/ – The New York City Triathlon, produced by Life Time (NYSE: LTH) and a marquee event in the city since 2001, will welcome athletes from around the world on Sunday, October 1. Kicking off at 7:30 am, Triathletes will swim 0.93 miles (1500m), pedal 24.8...

Events

Press Releases

Triathlon