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

September 13, 2024

Snowbound Expo 2024 Announces Full Speaker Agenda

Boston, MA/ENDURANCE SPORTSWIRE/ – Snowbound Expo, the leading annual event for winter sports enthusiasts, is thrilled to announce its speaker agenda in its entirety for its long-standing ski and snowboard expo taking place November 15-17, 2024 at the Boston Convention & Exhibition Center. The highly anticipated speaking program celebrates New England...

Press Releases

Trade Shows

September 13, 2024

Sportive Breaks and Team Visma | Lease a Bike come together to offer fans the ultimate cycling experiences

September 2024, Manchester UK /ENDURANCE SPORTSWIRE/ – Cycling travel experts Sportive Breaks are excited to announce that they are the exclusive fan and hospitality travel partner of Team Visma | Lease a Bike. They will be teaming up with the world’s most successful cycling team to offer fans a way...

Cycling

Press Releases

Sponsorship

September 13, 2024

Official Nonprofits Selected for 2025 Austin Marathon®

AUSTIN, Texas, September 13, 2024 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon is excited to announce the full roster of charities selected for their 2025 Austin Marathon Gives program. Austin Marathon Gives is the Official Charity Program for the Austin Marathon®. Each non-profit will raise awareness for their mission...

Events

Giving

Press Releases

Running

September 12, 2024

Superfeet and LineDrive Join Forces to Boost Workplace Safety and Performance

FERNDALE, Wash. (Sept. 12, 2024)/ENDURANCE SPORTSWIRE/ – Superfeet, the global leader in performance insoles, is proud to announce a strategic partnership with LineDrive, a solutions-based sales agency that specializes in matching large-scale businesses with innovative workplace safety tools. This collaboration aims to revolutionize employee comfort and safety in the manufacturing and...

Press Releases

Sponsorship

September 12, 2024

P3R Expands Sensory Inclusive Efforts for 2024 Fall Events

PITTSBURGH, PA (Sept. 12, 2024) /ENDURANCE SPORTSWIRE/ – P3R, the region’s go-to premier sporting event and experience expert, is proud to announce that its Sensory Trailer will be available at all upcoming P3R events this fall. This initiative aims to make P3R events more accessible and enjoyable for individuals with...

Events

Press Releases

Running

September 12, 2024

The Good Life Halfsy Half-Marathon Sells Out at Expanded Capacity Ahead of Schedule

Lincoln, Nebraska (September 12, 2024) /ENDURANCE SPORTSWIRE/ – The eleventh annual Good Life Halfsy presented by The Mercato by Certified Piedmontese has sold out at just over 7100 registered participants. The fall half-marathon is scheduled for Sunday, October 27, 2024 at 8:30am in Lincoln, Nebraska. The expanded field of runners...

Events

Press Releases

Running

September 12, 2024

Cotopaxi and Intrepid Travel Unite to Champion Responsible Adventures

Salt Lake City, UT. (September 12, 2024)/ENDURANCE SPORTSWIRE/ – Certified B Corporation™ and impact-driven adventure lifestyle brand, Cotopaxi, and BCorp adventure travel brand, Intrepid Travel are proud to align on a brand campaign to promote responsible travel, aligning with Cotopaxi’s brand ethos to “See the World and Make it Better.” The...

Business

Press Releases