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

December 12, 2023

Over 1,200 Kids to Complete Finish Like a Champion Project at Orlando Magic 5K, 1 Mile and Kids’ Run

ORLANDO, Fla. /ENDURANCE SPORTSWIRE/ – The Orlando Magic 5K, 1 Mile and Kids’ Run is providing an opportunity for kids taking part in Finish Like a Champion to mark a special accomplishment at the run on February 4, the day after the U.S. Marathon Team Trials. Finish Like a Champion is...

Events

Press Releases

Running

December 12, 2023

XTERRA European Championship 2024: High Stakes and Festivities in Prachatice

/ENDURANCE SPORTSWIRE/ - The fight for European Championship glory returns to the tried and tested trails of the Czech Republic. Key Points: Prachatice, Czech named as official destination of 2024 XTERRA European Championship. A €30,000 Elite prize purse and regional championship crowns up for grabs in one of the most...

Cycling

Events

Press Releases

Running

Triathlon

December 12, 2023

The Wizard Run Has a Magical Return to Philly

PHILADELPHIA, Pa. /ENDURANCE SPORTSWIRE/ – Runners and walkers sporting their wizard and magical-themed gear flew through the streets of Philadelphia on Dec. 9 for the return of the in-person Wizard Run. Participants at this year’s Wizard Run started in South Philadelphia’s Navy Yard and journeyed through the 5K and one-mile routes....

Events

Press Releases

December 11, 2023

SUAREZ Gran Fondo National Series and Zwift Announce Schedule for 8-Event E-Fondo Series

(Gettysburg, PA ) /ENDURANCE SPORTSWIRE/ - The SUAREZ Gran Fondo National Series today announced the event schedule for the 4th Annual E-Fondo Series, an 8-event series of competitive cycling events hosted on Zwift’s industry leading virtual cycling platform. The 8-event e-sports cycling competition features timed segments like the Series’ real-world...

Business

Cycling

Events

Press Releases

December 10, 2023

Mississippi Gulf Coast Marathon Weekend: A Resounding Success!

BILOXI, MS. /ENDURANCE SPORTSWIRE/ - The Mississippi Gulf Coast Marathon Weekend reached its peak on Sunday morning as participants from across the nation crossed the finish line with remarkable achievements in the Marathon and Half Marathon. The coastal landscape served as a stunning backdrop for the runners, who showcased exceptional...

Business

Events

Press Releases

Running

Sponsorship

December 10, 2023

Eight Titles Awarded on the Third Day of Cyclocross Nationals at Joe Creason Park

LOUISVILLE, Ky. /ENDURANCE SPORTSWIRE - It was another beautiful day in Louisville for the 2023 USA Cycling Cyclocross National Championships. With lines being dialed in and course conditions drying out, each race saw a battle of attrition as riders from around the country competed for the coveted Stars and Stripes...

Cycling

Events

Press Releases

December 10, 2023

Colorado Mesa University and University of Colorado Boulder Claim 2024 Collegiate Cyclocross Omnium Titles

December 8, 2023, LOUISVILLE, Ky. /ENDURANCE SPORTSWIRE/ - Warm temperatures, overcast skies, and low dew points greeted the fourth day of the 2023 USA Cycling Cyclocross National Championships took place on Friday. The Masters Women, Men’s and Women’s Singlespeed, Collegiate Team Relays, and Non-Champ Team Relay took on the 1.7-mile...

Cycling

Events

Press Releases