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 (22)
) 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 920, 10

June 29, 2023

Long Beach Marathon Highlights Partnership with the Aquarium of the Pacific for National Aquarium Month

Long Beach, California – June 29, 2023 /ENDURANCE SPORTSWIRE/ – The Long Beach Marathon and Half Marathon is kicking off its partnership with the nonprofit Aquarium of the Pacific during National Aquarium Month in June. The two community institutions are once again coming together to host the Aquarium of the Pacific...

Events

Press Releases

Running

Sponsorship

June 29, 2023

USA Cycling Welcomes BikeInsure as Official Bicycle Insurance Partner

Colorado Springs, Colorado /ENDURANCE SPORTSWIRE/ – We are thrilled to announce that USA Cycling has partnered with BikeInsure through 2026, a bicycle insurance company that shares our commitment to promoting the crucial 'need' of protecting bicycles with its specialty bike insurance policy. As a USA Cycling member, you can quickly sign up...

Cycling

Press Releases

Sponsorship

June 29, 2023

46th Crim 10-Mile Race Seeks Title Sponsor

Flint, MI /ENDURANCE SPORTSWIRE/ –The HAP Crim Festival of Races, the signature event of the Crim Fitness Foundation, is returning to the historic bricks of downtown Flint for the 46th time August 25-26. The Festival, home to one of the nation’s largest and oldest 10-mile races, the “Crim,” is seeking a...

Events

Press Releases

Running

Sponsorship

June 29, 2023

Chasing Watts releases new details of their Chasing Watts Century Challenge.

/ENDURANCE SPORTSWIRE/ - Chasing Watts, the leading app for connecting cyclists with group rides, is thrilled to announce the fourth edition of the highly anticipated Chasing Watts Century Challenge. This year, the challenge takes on a new and exciting twist, as it puts the power in the hands of ride...

Cycling

Events

Press Releases

Sponsorship

June 29, 2023

Two-Time MLB All-Star Justin Turner Creates Signature Collection with Kaenon Sunglasses

Irvine, Calif (June 29, 2023)/ENDURANCE SPORTSWIRE/ – Kaenon is releasing its first signature sunglass collection with two-time MLB All-Star Justin Turner. The first installment of the Justin Turner Signature Collection from Kaenon includes two versions of the Arcata SR, Turner's preferred model for on-field play. Unlike typical athlete-endorsement relationships, Turner has a...

Press Releases

Sponsorship

June 28, 2023

BibRave Elevates Brooks Running Reach to Lifestyle Consumers

Honolulu, HI/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, launched an Influencer campaign as part of their year-long retainer with Brooks Running, to position how Brooks performance running and walking shoes can transition to everyday life and be part of personal fashion expression. The campaign leveraged Brooks’ evergreen...

Press Releases

Running

Sponsorship

June 27, 2023

Join the Ride: Bike Fest 2023 Brings Cycling, Community, and Celebration to Asheville, NC

Asheville, NC, June 27, 2023 /ENDURANCE SPORTSWIRE/ - Asheville on Bikes (AoB) is thrilled to announce the return of the much-anticipated 2nd annual Bike Fest, presented by Cane Creek Cycling Components. The event kicks off in Asheville on Friday, July 14, and runs through Saturday, July 15. The Gran Fondo Asheville...

Business

Cycling

Events

Press Releases

Sponsorship

June 23, 2023

Wattbike support the first ever Esports Olympic Series

23rd June 2023 - UK/ENDURANCE SPORTSWIRE/ – The original, indoor smart bike innovator Wattbike is the choice of both elite athletes and fitness enthusiasts around the globe, and the team were delighted that the Olympic Esports Finals chose their award-winning Wattbike Atom for their cycling event which took place today. Presented...

Cycling

Events

Press Releases

Sponsorship