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

November 1, 2024

Ascension Seton Austin Marathon Teams Up with HotelPlanner for 2025

Austin, TX – /ENDURANCE SPORTSWIRE/ – The 2025 Ascension Seton Austin Marathon, Half Marathon, & 5K® is proud to announce a partnership with HotelPlanner, a leading travel technology company, which will provide online hotel bookings and accommodations for the Event Weekend of February 14-16, 2025. This partnership will provide participants, spectators,...

Business

Events

Press Releases

Running

Sponsorship

November 1, 2024

2025 World Mountain & Trail Running Championships – Team USA Selection Criteria Announced

/ENDURANCE SPORTSWIRE/ - Team USA will compete in the third World Mountain and Trail Running Championships (WMTRC) slated for September 24-28, 2025, in Canfranc-Pirineos, Spain. This biennial event is organized by the World Mountain Running Association (WMRA), the International Association of Ultrarunners (IAU) and the International Trail Running Association (ITRA),...

Events

Press Releases

Running

November 1, 2024

Triathlon First for Challenge Sir Bani Yas

/ENDURANCE SPORTSWIRE/ - The first long distance (226km) triathlon in the UAE, Challenge Sir Bani Yas is also billed as the most unique triathlon experience in the world, as revealed by a triathlon first announced today. With the five-day racing and cultural experience based on the eco-tourism island of Sir...

Events

Press Releases

Triathlon

October 31, 2024

$800 off the well-reviewed Kingbull Folding eBike, under $900 at 100 off for Halloween

October 31, /ENDURANCE SPORTSWIRE/ - E-bikes have become a preferred mode of transportation, and for good reason—they offer an ideal blend of convenience, fitness, and environmental benefits. This Halloween, Kingbull is offering a spectacular deal on their highly rated Literider folding e-bike, with a seasonal discount of $800, bringing the...

Events

Press Releases

Products

October 31, 2024

GFNY is back in Tuscany

NEW YORK CITY, October 31, 2024 /ENDURANCE SPORTSWIRE/- GFNY Global Endurance Sports Series is back in Italy with GFNY Toscana-Pistoia, scheduled for April 6, 2025. The race is held in the picturesque and cultural heart of Tuscany, just outside Florence. The area is also arguably the center of road cycling...

Cycling

Events

Press Releases

October 31, 2024

Spartan Super World Championship Debuts in Mammoth Lakes, October 2025

Mammoth Lakes, CA, /ENDURANCE SPORTSWIRE/ - Spartan is set to make history as Mammoth Lakes, California, welcomes the inaugural Spartan Super World Championship on October 4-5, 2025. Known as an adventureland for outdoor enthusiasts, Mammoth Lakes and Mammoth Mountain Ski Area offers an ideal setting for this prestigious event. For...

Events

Press Releases

Running

October 31, 2024

TREW Gear Brings “TREW To You” Film Project to Salt Lake City, UT

Salt Lake City, Utah /ENDURANCE SPORTSWIRE/ - TREW Gear is pleased to announce that the TREW To You film contest is coming to Salt Lake City, UT, on Thursday, November 7th, for a special screening at Level 9 Sports Downtown Location. This screening is part of a North American tour...

Events

Press Releases

October 31, 2024

Movemint Bridges the Gap Between Activities and Events with New Strava Integration

SAN FRANCISCO, CA [10/31/2024] /ENDURANCE SPORTSWIRE/ - Movemint, a technology platform for endurance events, is excited to unveil a new integration with Strava. This integration bridges the gap between events and activities: when you do an event on Movemint, the event is automatically shown on your Strava activity. “When you...

Business

Events

Press Releases

October 31, 2024

TREW Gear Brings “TREW To You” Film Project to Rossland, British Columbia

Rossland, BC – /ENDURANCE SPORTSWIRE/ – TREW Gear is excited to announce a special hometown screening of TREW To You in Rossland, BC, on Monday, November 4th at the historic Rossland Miner's Union Hall. TREW To You is more than just a film; it celebrates skiing and snowboarding communities across...

Events

Press Releases