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

October 4, 2021

12th annual Northshore Half Marathon and 10-miler return to St. Tammany Sunday

BATON ROUGE, La. - The 12th annual Northshore Half Marathon and 10-miler return to St. Tammany on Sunday, Oct. 10 as one of the first events the parish will host since Hurricane Ida made landfall in August. Over 800 participants from 14 different states will flock to the historic streets...

Events

Press Releases

Running

October 4, 2021

Silicon Valley Welcomes Back San Jose’s Largest Running Block Party for the 2021 United Airlines Rock ‘N’ Roll Running Series San Jose

SAN JOSE, Calif. – Following a two-year hiatus due to the COVID-19 pandemic, Rock ‘n’ Roll Running Series events returned in San Jose over the weekend commemorating one of northern California’s most celebrated running events. This weekend’s event marked the 15th edition of the United Airlines Rock ‘n’ Roll Running Series...

Press Releases

Running

October 4, 2021

Keegan Swenson finishes 7th in 2021 Marathon MTB World Championships

ELBA ISLAND, Ita. – The 2021 Marathon Mountain Bike World Championships took on the island of Elba in Tuscany. Almost every part of this course is demanding single track with challenging climbs. The men raced 71 miles with 14,000 feet of climbing. The women raced 50 miles with over 10,000...

Cycling

Events

Press Releases

October 4, 2021

Jason West (USA) and Ellie Salthouse (AUS) Claim Victories at The Inaugural 2021 St. Jude IRONMAN 70.3 Memphis

MEMPHIS, Tenn. (October 2, 2021) – Memphis, Tennessee and Shelby Farms Park played host to the inaugural edition of the 2021 St. Jude IRONMAN® 70.3® Memphis triathlon on Sunday, Oct. 2. With some of triathlon’s best on hand, the event benefiting St. Jude Children’s Research Hospital® saw Jason West (Boulder,...

Events

Press Releases

Triathlon

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