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 (22)
) 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 890, 10

November 13, 2023

Showcased

Endurance Sportswire Executive Interview Series – Event Director of The Running Event

The Running Event, North America’s premier run and outdoor specialty retail conference and tradeshow, is just around the corner. We sat down with the show's event director, Christina Henderson, for a Q & A to learn more about her role, and what to expect at this year's event. Can you...

Awards

Business

Events

Products

Running

Sponsorship

Trade Shows

November 10, 2023

Registration opens for 22nd Little Rock Marathon Expo

LITTLE ROCK, Ark. (November 10, 2023) /ENDURANCE SPORTSWIRE/ - Registration is now open for the 2024 Little Rock Marathon Health and Fitness Expo, presented by the Hatcher Agency. The two day event features vendors and exhibitors showcasing products and services geared toward runners, walkers and health-minded consumers. The Expo will...

Business

Events

Press Releases

Running

Sponsorship

Trade Shows

November 9, 2023

Life Time Sea Otter Classic Expo off to Record-Breaking Start

MONTEREY, Calif. (November 9, 2023) /ENDURANCE SPORTSWIRE/ - Life Time (NYSE: LTH), the nation's premier healthy lifestyle brand, announced that more than 1,000 brands will be represented at the 34th Annual Life Time Sea Otter Classic presented by Continental. With reservations coming in at record pace, exhibitor space for the...

Business

Cycling

Events

Press Releases

Products

Sponsorship

Trade Shows

November 9, 2023

P3R and Pittsburgh Flag Football League Team Up to Take Youth Activity to the Next Level

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has partnered with the Pittsburgh Flag Football League (PFFL) to inspire youth to MOVE in new ways. Through the partnership, P3R plans to help organize, facilitate and promote a Youth Flag Football Clinic and an open Recreational Flag Football Tournament in 2024. P3R recently announced their...

Press Releases

Sponsorship

November 9, 2023

USA Cycling Partners with the EuroCrossAcademy for 2023-2024 Cyclocross Season

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling and EuroCrossAcademy (ECA) will partner for cyclocross junior development throughout the 2023-2024 season. The common goal of USA Cycling and ECA is to focus on long-term, holistic development for junior athletes through a character-driven curriculum and a process-to-performance philosophy. The partnership will kick...

Cycling

Events

Press Releases

Sponsorship

November 9, 2023

Cigna Healthcare Extends Title Sponsorship with the Denver Colfax Marathon

Denver, CO (November 9th, 2023) /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon announced today that Cigna Healthcare is renewing its title sponsorship for the 2024 Denver Colfax Marathon. This partnership comes as the health benefits provider continues to support the health and vitality of those in the greater Denver community...

Business

Events

Press Releases

Running

Sponsorship

November 8, 2023

USA Triathlon Partners with Ka’Chava as Official Nutrition Shake Partner Through 2025

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced Ka’Chava as an Official Partner of USA Triathlon through 2025. The Official Nutrition Shake of USA Triathlon, Ka’Chava is also the Presenting Partner of Ignite the Spark, USA Triathlon’s and the USA Triathlon Foundation’s marketing and fundraising initiative that celebrates the resilience, determination,...

Press Releases

Sponsorship

Triathlon