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

December 13, 2021

Rock ‘N’ Roll Running Series Announces 2022 Tour Schedule and 24-Hour Global Winter Sale

TAMPA, Fla. (Dec. 13, 2021) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series, the world’s largest road running series today announced its 2022 Tour Schedule covering 14 destinations. To celebrate the holidays and the launch of the 2022 Rock ‘n’ Roll Running Series Tour Schedule, a 24-hour Winter Sale...

Events

Press Releases

Running

December 11, 2021

Showcased

Leslie Jordan announces their NEW Online Outlet Store LJIoutlet.com

Portland, OR /ENDURANCE SPORTSWIRE/ - Leslie Jordan Inc. announces the debut of their online outlet store, LJIoutlet.com. Offering blank tees, hoodies, zips & jackets, buyers can buy a single item or get a 10% discount if they buy ‘by the dozen’. Leslie says, “This is something we have planned for...

Business

Press Releases

Products

Running

Triathlon

December 10, 2021

Meet Your 2022 Life Time Grand Prix Race Series Athletes

BOULDER, Colo., Dec. 10, 2021 — Life Time (NYSE: LTH), owner and producer of more than 30 renowned athletic events across the nation, today announced the 60 athletes who have been selected to compete in the 2022 Life Time Grand Prix series, which includes events such as Garmin Unbound Gravel...

Cycling

Events

Press Releases

December 10, 2021

US Trail Running Conference heads to Mukilteo, WA in 2022

Estes Park, CO /ENDURANCE SPORTSWIRE/ - Active at Altitude, organizers of the US Trail Running Conference has announced that the tenth edition of the industry-leading Conference will be held in Snohomish County, Washington, in the city of Mukilteo, October 19 - 22, 2022. Snohomish County, located in northwest Washington State...

Events

Press Releases

Running

December 10, 2021

History and Heritage Race Series Returns for Second Year

/ENDURANCE SPORTSWIRE/ - The J-3 Piper Cub will be the first historical aircraft featured in the 2022 History & Heritage Race Series, powered by the Air Force Marathon, beginning January 1. The upcoming event marks the first of six virtual races as the series returns for a second season. While the...

Events

Press Releases

Running

December 9, 2021

Bikerumor Announces 2021 Editor’s Choice Winners

Dec. 9, 2021 /ENDURANCE SPORTSWIRE/ - Bikerumor, the leading cycling technology and product review website, today announced its Editors Choice award winners for 2021. These annual Editor’s Choice awards honor the best bicycles, components, and accessories tested through the year by each of the editors. “These posts are wildly popular with our...

Awards

Cycling

Press Releases

December 9, 2021

Showcased

The Running Event Makes a Positive Impact on Attendees and the Running Community During 2021 Conference and Expo

Portland, Maine (Thursday, December 9, 2021) /ENDURANCE SPORTSWIRE/ - The Running Event, North America’s Largest run specialty conference and tradeshow, brought together thousands of retailers, race directors, industry experts, top brands, and changemakers from across run specialty last week at the Austin Convention Center in Austin, Texas. In addition to an...

Giving

Press Releases

Running

Trade Shows

December 9, 2021

Tokyo Paralympic Goalball Coaches and Athletes to Lead L.A. Clinic Dec. 11

Los Angeles, CA (December 9, 2021) /ENDURANCE SPORTSWIRE/ - Team USA head coaches and athletes will conduct two clinics on the Paralympic sport of goalball on Saturday, December 11, at the Expo Center (3980 Bill Robertson Lane) in Los Angeles. The clinics are part of USA Goalball Day and are...

Events

Press Releases