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

October 6, 2021

Akagiyama Hill Climb Race Hosts a 2nd Virtual Edition on ROUVY On Oct 9th

Maebashi City, Japan / Oct 6th 2021 - Akagiyama Hill Climb Race hosts its second open virtual edition on ROUVY, on October 9th, with the pro riders, Takahiro Koyama and Kazuki Nagatomi, from Team Griffin. Mountain Akagiyama provides the best cycling during a beautiful autumn season in October and November....

Cycling

Events

Press Releases

October 6, 2021

IRONMAN Announces Mossel Bay in South Africa as New Host City for IRONMAN 70.3 Triathlon

NELSON MANDELA BAY / LONDON / TAMPA (October 6, 2021) - IRONMAN announced today that it will add a brand-new event to its 2022 global race calendar with the IRONMAN® 70.3® Mossel Bay triathlon in South Africa. The inaugural IRONMAN 70.3 Mossel Bay triathlon will take place on Sunday, November 6,...

Events

Press Releases

Triathlon

October 6, 2021

Showcased

GiveSignup | RunSignup Announces GivingTuesday $50K Grants Giveaway

Moorestown, NJ (October 6, 2021) — GiveSignup | RunSignup is excited to announce the GivingTuesday $50K Grants Giveaway. The first 500 nonprofit organizations with a 501(c)(3) designation that raises at least $100 with their GivingTuesday campaign on the GiveSignup | RunSignup free platform on November 30, 2021 will receive a...

Giving

Press Releases

Running

October 6, 2021

Atlanta Track Club and haku Take Memberships to the Next Level Through Innovative Solutions

Effective membership programs have shifted from brands simply driving revenue to a value model where they invest in benefitting their communities – such as access, knowledge, information, experience, and belonging. Over the years, Atlanta Track Club has proven to be one of the most forward-thinking, innovative organizations that puts its...

Business

Events

Press Releases

Running

October 6, 2021

Inaugural WineShine Half Marathon to Debut in the Napa Valley Next Summer

NAPA, CA – The nonprofit Napa Valley Marathon, Inc., is thrilled to announce the launch of a new summer race in wine country, the WineShine Half Marathon & 3.9-Miler. The inaugural race, which starts and finishes at the Silverado Resort & Spa, will be held on July 16, 2022. Registration...

Events

Press Releases

Running

October 6, 2021

Shalane Flanagan Partners with InsideTracker to Make Professional-Level Blood Data Insights Accessible to Every Athlete

CAMBRIDGE, Mass.— Oct. 6, 2021— InsideTracker, the leading truly personalized performance and nutrition system, today announced a limited-edition blood biometric panel created alongside Olympic medalist and New York City Marathon champion, Shalane Flanagan. The InsideTracker x Shalane Flanagan Panel tests more than 20 key biomarkers that are critical to endurance...

Press Releases

Products

Running

October 6, 2021

Gnarly Nutrition Transitions to Recyclable Steel Packaging

SALT LAKE CITY, UT (October 6, 2021) -- Gnarly Sports Nutrition, the makers of clean, effective, and great tasting sports nutrition supplements, is proud to announce that they will be transitioning all of their product packaging from plastic tubs to highly recyclable tin coated steel cans. As the first sports...

All Sports

Press Releases

Products

October 5, 2021

Purity Products Releases Muscle Accelerator to Enhance Muscle Strength and Size

Plainview, NY (October 5, 2021) - Purity Products®, the leading science-backed supplement brand recently announced a new addition to its product line, Purity’s Muscle Accelerator, that works to promote muscle strength, increase muscle size and support endurance. “We have been testing and formulating this unique, patented product for over two...

All Sports

Press Releases

Products