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

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

October 1, 2021

Showcased

C-119 Flying Boxcar revealed as final aircraft in Air Force Marathon virtual race series

WRIGHT-PATTERSON AIR FORCE BASE, Ohio – The C-119 Flying Boxcar will be the sixth and final historical aircraft featured in the inaugural History & Heritage Race Series, powered by the Air Force Marathon, beginning November 1. The History & Heritage Race Series will hold six virtual races throughout the year....

Events

Press Releases

Running

October 1, 2021

Olympic Silver Medalist Paul Tanui Joins LEOMO as a Brand Ambassador

Boulder, CO (October 1, 2021) — LEOMO, Inc., a sports technology company based in Boulder, Colorado, best known for its advanced motion analysis devices and services, is pleased to announce the signing of Kenyan runner Paul Tanui, the silver medalist in the men’s 10,000m at the Rio Olympics, as a...

Press Releases

Products

Running

Triathlon