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 (21084)
) 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 320, 10

February 7, 2023

P3R Partners with Roberto Clemente Museum and Roberto Clemente Foundation to Expand Kids of STEEL, Promote Clemente’s Legacy

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has partnered with The Clemente Museum and the Roberto Clemente Foundation to inspire more young people and their families to MOVE through the award-winning youth running program Kids of STEEL. Through the partnership, P3R plans to launch a Kids of STEEL site in Clemente’s birthplace of...

Giving

Press Releases

Running

February 3, 2023

Sharing Decades of a Dedicated Vision to End Cancer

(RYE BROOK, N.Y., February 3, 2023)/ENDURANCE SPORTSWIRE/ – Bike The West, the longstanding owner of the iconic cycling event, “America’s Most Beautiful Bike Ride” will be passing the baton to The Leukemia & Lymphoma Society (LLS) as they officially announced today, the global leader in the fight against blood cancer are named...

Cycling

Events

Giving

Press Releases

February 1, 2023

Athletic Brewing Re-releases Soul Sour for Black History Month

MILFORD, Conn. and SAN DIEGO (February 1, 2023) /ENDURANCE SPORTSWIRE/ - Athletic Brewing Company, America’s leading producer of non-alcoholic craft beer, is excited to relaunch Soul Sour in celebration of Black History Month. Originally launched in 2021, Soul Sour was inspired by Athletic teammates who wanted to celebrate the beauty,...

Business

Cycling

Events

Giving

Press Releases

Products

Running

Sponsorship

Triathlon

January 31, 2023

Shamrock Run Portland benefiting OHSU Doernbecher Children’s Hospital

PORTLAND, Ore. – January 31, 2023 /ENDURANCE SPORTSWIRE/ - The Shamrock Run Portland named OHSU Doernbecher Children’s Hospital as their primary beneficiary in 2002, and since then has raised nearly $600,000 for the world-class institution. This year, the Shamrock Run Portland is celebrating 45 years running on Sunday, March 12,...

Events

Giving

Press Releases

Running

January 19, 2023

Running USA Announces Six Scholarship Recipients

DENVER (Jan. 19, 2023) /ENDURANCE SPORTSWIRE/ – Running USA is pleased to announce the recipients of the 2023 Running USA Industry Conference scholarships. Each of the recipients will be provided with the opportunity to accelerate their business by receiving all-expense paid inclusion at the 2023 Running USA Industry Conference in Denver....

Giving

Press Releases

Trade Shows

January 19, 2023

PNC Bank Named Title Sponsor of Rush to Crush Cancer

PITTSBURGH (Jan. 19, 2023) /ENDURANCE SPORTSWIRE/ – Rush to Crush Cancer has announced that Pittsburgh-based PNC Bank has been named title sponsor of the inaugural Rush to Crush Cancer bike ride benefitting UPMC Hillman Cancer Center. The biking event, launching May 20, 2023, will bring people to pedal, partner and participate...

Cycling

Giving

Press Releases

Sponsorship

January 17, 2023

Rebranded RUN Varsity Aims to Support Teenagers Moving

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has announced that 4RUN2 Varsity has rebranded to RUN Varsity. The rebrand is designed to be more inclusive of ALL youth in the area. RUN Varsity adds to P3R’s robust programming to motivate any and all to MOVE and will continue to support, educate and encourage teenage...

Business

Giving

Press Releases

Running

January 10, 2023

BUFF® Joins the B Corporation™ Movement

SANTA ROSA, California (Jan. 10, 2023) /ENDURANCE SPORTSWIRE/ - Original BUFF®, S.A., a world leader in headwear and neckwear accessories for outdoor activities, is proud to join the movement of registered B Corporations™, scoring 105.7 in its first round of testing, a major accomplishment in elevating its DO MORE NOW...

Awards

Business

Events

Giving

Press Releases

Wire Syndication