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

October 31, 2024

Showcased

AF Events announces Summer Vibes Bike Rally & Run Fest for June in Colorado

/ENDURANCE SPORTSWIRE/ - Today AF Events, producer of many top active events in Colorado, announces the SUMMER VIBES Bike Rally and & Run Fest - a new Mountain Festival for Adventure Seekers. Designed to be the best weekend of the year for the outdoorsy, the festival will include an exciting...

Cycling

Events

Press Releases

Running

October 31, 2024

Inaugural GFNY Bahamas this Sunday

New York City, October 31, 2024 /ENDURANCE SPORTSWIRE/ - This Sunday, Nassau, the vibrant capital of The Bahamas, will host the highly anticipated inaugural edition of GFNY Bahamas. Riders will take on a flat 60.8-mile course, offering a unique blend of challenge and stunning scenery. GFNY Bahamas will offer participants...

Cycling

Events

Press Releases

October 31, 2024

TREW Gear Brings “TREW To You” Film Project to Truckee, CA

Tahoe, CA /OUTDOOR SPORTSWIRE/ - TREW Gear is thrilled to announce the Tahoe, CA screening of TREW To You on Tuesday, November 5th, at the Tahoe Art Haus and Cinema. This unique film contest celebrates skiing and snowboarding communities across North America and brings their stories to life. TREW To...

Events

Press Releases

October 31, 2024

TREW Gear Brings “TREW To You” Film Project to Bozeman, MT

Portland, OR – /ENDURANCE SPORTSWIRE/ – TREW Gear is excited to announce the final screening of its TREW To You film contest tour in Bozeman, Montana, on Friday, November 8th, at the Emerson Theatre. This special event marks the culmination of a journey that has celebrated skiing and snowboarding communities...

Events

Press Releases

October 30, 2024

Golden Gate Half Marathon Celebrates Fall Running Tradition with Local Brews at Finish Line

SAN FRANCISCO – October 30, 2024 /ENDURANCE SPORTSWIRE/ – The sold-out Golden Gate Half Marathon & 5k is proud to announce the return of San Francisco Brewing Co. as the Official Beer Sponsor for the 2024 event scheduled for this weekend on Sunday, November 3. All runners aged 21 and over will be...

Events

Press Releases

Running

Sponsorship

October 30, 2024

Dave McGillivray Completes 2024 IRONMAN World Championship

BOSTON, Mass. /ENDURANCE SPORTSWIRE/ – This past weekend, over 5,000 miles away from Boston, Dave McGillivray took part in the VinFast IRONMAN World Championship in Kailua-Kona, Hawai`i as an official ambassador for the event. This marks McGillivray’s 10th time participating in and completing the world’s most famous triathlon. McGillivray finished...

Events

Press Releases

Running

Triathlon

October 30, 2024

Chargel Finishes 2024 On-Site Samplings with Bi-Coastal Events in New York and Southern California

IRVINE, Calif. (October 30, 2024) /ENDURANCE SPORTSWIRE/ — Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy before any workout with zero caffeine, today, announced its November competitive event station lineup. Chargel will round out its 2024 sampling events by showcasing its half drink,...

Cycling

Events

Newswire Syndication

Press Releases

Running

Sponsorship

October 30, 2024

Showcased

San Francisco Marathon Shatters Fundraising Records by Over 40% with GoFundraise Partnership

/ENDURANCE SPORTSWIRE/ - The San Francisco Marathon is an open charity event, welcoming any charity to join. This year, the marathon, in partnership with GoFundraise, is proud to announce a record-breaking fundraising year. They reached a new milestone, raising over $128,000 for local charities, exceeding their goal by 28%. Surpassing...

Events

Giving

Press Releases

Running