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

October 4, 2021

Norden and Chartier Dominate at Challenge Salou

CHALLENGESALOU 2021 didn’t start as planned with high winds causing the cancellation of the Sailfish Swim for safety reasons but it didn't make the middle distance race along the shores of the Mediterranean any less exciting with Colin Chartier (USA) and Lisa Norden (SWE) taking the wins. With the race...

Events

Press Releases

Triathlon

October 3, 2021

She Tris Sprint Triathlon Concludes 2021 Season

Charleston, SC (October 3, 2021). Over 200 women and girls from ages 5 to 78 participated in the final triathlon events for She Tris Sprint Triathlon on September 26, 2021. The triathlon events took place in the Carnes Crossroads neighborhood in Summerville. Title sponsor Crews Subaru, represented by Ken French,...

Events

Press Releases

Triathlon

October 2, 2021

More than 1,200 Runners Take Flight at the FlyBy 5K and 2-Mile Fun Run/Walk at Pittsburgh International Airport

PITTSBURGH (October 2, 2021) – More than 1,200 runners and walkers raced the runway and earned their wings at this morning’s FlyBy 5K and 2-Mile Fun Run/Walk presented by CNX Resources. This family-friendly race offered participants the rare opportunity to be up close to specialized aircraft and equipment as they...

Events

Press Releases

Running

October 2, 2021

Popular Half Marathon Returns to Live Start Line

LAWRENCE, IN - The 25th edition of the Indy Half Marathon at Fort Ben took place Saturday morning in Lawrence, IN. Competitors returned to a live start line for the 13.1-mile half marathon, 5K run, and Kids One Mile Run. The race welcomed over 2,000 racers back to historic Fort...

Events

Press Releases

Running

October 1, 2021

ARCHER Components Adds Sprint Battery Upgrade for D1x Trail Users

Scotts Valley, California (October 1, 2021) —Archer Components continues to shift the paradigm of wireless electronic components in the bike industry with its new Sprint Battery upgrade for the D1x Trail that increases shift speed by up to 50%, matching the speed of the SRAM AXS electronic groupset. Since 2015...

Cycling

Press Releases

Products

October 1, 2021

iFIT Announces Multi-Year Exclusive Connected Treadmill and Content Partnerships With Boston, Chicago, London and New York City Marathons

(LOGAN, UT, October 1, 2021) -- iFIT, a global leader in connected fitness software, content, and equipment, today announced multi-year partnerships with the organizations behind four of the Abbott World Marathon Majors to become the Official Connected Treadmill and Digital Fitness Content Subscription partner of the Boston, Chicago, London and...

Business

Press Releases

Running

October 1, 2021

Women Who Rally: Pensacola Sports Gears Up for 2021 Women’s Half Marathon

Pensacola, Fla. (October 01, 2021) – This one is for the ladies! Pensacola Sports and Rally Pensacola are gearing up for the annual Women’s Half Marathon, presented by Publix. Be a part of this unique event, dedicated to empowering women within the Gulf Coast running community. Taking place Sunday, Nov. 7,...

Events

Giving

Press Releases

Running

October 1, 2021

Booze and Tennis: 2021 Bud Light Tennis Challenge Is on The Horizon

Pensacola, Fla. – (October 01, 2021)) – Start warming up those backhand and topspin hits; Pensacola Sports is two weeks away from hosting the 16th annual Bud Light Tennis Charity Challenge This year’s event takes place October 15-16 at Roger Scott Tennis Center and consists of men and women team...

Events

Giving

Press Releases