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 (8742)
) 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 2730, 10

August 14, 2024

Boulderthon Announces PUMA as Presenting Sponsor

BOULDER, Colo. /ENDURANCE SPORTSWIRE/ – Boulderthon has announced global sports company PUMA as the new multi-year presenting sponsor ahead of its 2024 event, taking place Sunday, Sept. 29. The announcement comes on the heels of PUMA’s launch of the Deviate NITRO™ 3 running shoe, which will be carried in the...

Press Releases

Sponsorship

August 14, 2024

SCOTT Appoints Marketing Veteran Matt Heitmann To Lead Brand’s Growth In America

Salt Lake City, Utah August 13th, 2024 /ENDURANCE SPORTSWIRE/ – SCOTT USA, the American subsidiary of SCOTT, today announced the appointment of Matt Heitmann as its new Chief Marketing Officer. The move comes as SCOTT's management continues to invest heavily in the brand's future growth and expansion in the American...

Business

Cycling

Press Releases

August 14, 2024

Indiana University Indianapolis signs on as presenting sponsor of the Apex Benefits Monumental Kids Movement

INDIANAPOLIS, IN /ENDURANCE SPORTSWIRE/ – Through a shared commitment to Indianapolis and public education, Beyond Monumental is excited to announce that IU Indianapolis joins on as presenting sponsor of the Apex Benefits Monumental Kids Movement and the program’s culminating event, the Apex Benefits Monumental Kids 5K. “Everything we do as...

Events

Press Releases

Sponsorship

August 13, 2024

BRANWYN Ranks 109th Among Inc. 5000’s Fastest-Growing Brands

Bend, OR – August 13, 2024 /ENDURANCE SPORTSWIRE/ - BRANWYN, the women’s seamless Merino Performance Innerwear brand, is thrilled to announce its inclusion in the 2024 Inc. 5000 list. This annual list celebrates the fastest-growing private companies in America, highlighting the success of independent, entrepreneurial enterprises in the nation's most...

Awards

Press Releases

August 13, 2024

Record-Breaking Year For World’s Largest Fun Run City2Surf

SYDNEY, Australia / TAMPA, Fla./ENDURANCE SPORTSWIRE/ – Australia’s City2Surf celebrated a record turnout for its 54th year with almost 80,000 participants crossing the finish line of the world’s largest fun run on Sunday 11 August. The streets of Sydney, Australia, came alive with energy as a sea of runners, walkers,...

Events

Press Releases

Running

August 13, 2024

Chefs, celebs & cyclists convene for the inaugural Gran Fondo Hincapie Bentonville

Bentonville, Ark., (August 13, 2024) /ENDURANCE SPORTSWIRE/ – Gran Fondo Hincapie has been creating cycling experiences for over 12 years and this year, launched its latest event taking place in Bentonville, Ark., Sept. 6 - 8. The multi-day cycling celebration will offer scenic rides, live music, and a family festival...

Cycling

Events

Press Releases

August 13, 2024

Vermont Outdoor Business Alliance to showcase premier local brands at The Boston Outdoor Expo 2025

Boston, MA – August 13, 2024 /ENDURANCE SPORTSWIRE/ – The Boston Outdoor Expo confirms that Vermont Outdoor Business Alliance (VOBA) will join the line-up of exhibitors at the upcoming event, returning March 1-2, 2025 in the Boston Convention & Exhibition Center. VOBA will proudly represent an exceptional lineup of Vermont-based...

OSW Syndicated

Press Releases

Trade Shows