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

March 7, 2022

Stampone O’Brien Dilsheimer Law announced as new Title Sponsor of Women’s Philadelphia Triathlon & 5K, Expanding Partnership with DelMoSports

Cape May, NJ - March 7, 2022 /ENDURANCE SPORTSWIRE/ - DelMoSports is pleased to announce that Stampone O’Brien Dilsheimer Law has agreed to title sponsor the Women’s Philadelphia Triathlon & 5K for the next 4 years. Scheduled for July 10, 2022, at John B. Kelly Pool in West Fairmount Park,...

Press Releases

Sponsorship

March 4, 2022

Shamrock Run Portland Returns for 44th year

PORTLAND, Ore. – March 4, 2022 /ENDURANCE SPORTSWIRE/ - For those who love lacing up their running shoes and pounding the pavement, imagine Beantown minus the Boston Marathon. Think of the Big Apple missing the New York City Marathon. For two years, that’s what it’s been like for the Portland...

Events

Press Releases

Running

March 4, 2022

US Trail Running Conference Webinar Offers Guidelines to Increase Diversity for Trail Races

Estes Park, CO /ENDURANCE SPORTSWIRE/ - The second webinar in a seven-webinar series produced by the US Trail Running Conference and presented by Marathon Printing, the leading producer of custom printed items for endurance sports, was live on Thursday, February 24. The session subject for was: Diversity and Inclusion, focused on...

Events

Press Releases

Running

March 4, 2022

Showcased

Race Roster introduces mobile scanning solutions for quick and easy check-in

London, ON (Friday, March 4, 2022) - With Race Roster’s new mobile scanning solutions, event organizers can reimagine their check-in process. “We are always thinking of ways we can help organizers streamline their race day experiences, which includes eliminating long check-in line-ups!" Says Emily Lutz, Product Manager at Race Roster....

Business

Press Releases

March 4, 2022

Kane Footwear collaborates with Brian Mazza to launch first athlete-designed shoe

Westport, CT (March 4, 2022) /ENDURANCE SPORTSWIRE/ - Kane Footwear is releasing their first collaborative design of the Revive recovery shoe with athlete and entrepreneur Brian Mazza. The shoe features earth tones and a printed message on the sole of the shoe that reflects Mazza's story and mission: Nothing Changes if Nothing...

Business

Press Releases

Products

March 4, 2022

Showcased

Dean Karnazes appointed Chief Exercise Officer for Afloat

TAMARAC, Fla. /ENDURANCE SPORTSWIRE/ - Afloat, the creators of the reimagined and technologically advanced waterbed, have announced a new partnership with ultrarunner Dean Karnazes. Taking on the honorary title of Chief Exercise Officer, Karnazes will act as an ambassador for the brand, sharing how waterbeds offer a superior level of...

Press Releases

Running

Sponsorship

March 3, 2022

Yamaha Bicycles Introduces Two New e-Bikes for the U.S. Market

Cypress, Calif. – March 3, 2022 //ENDURANCE SPORTSWIRE/ - Yamaha Motor Corp., USA, the pioneering brand in electric bicycles, is introducing two all-new, class 3, power assist bicycles: the Wabash RT and the CrossCore RC, e-Bikes built from the ground up with the all new Yamaha PWSeries ST drive unit,...

Cycling

Press Releases

Products

March 3, 2022

Showcased

Tucson Bicycle Classic THIS WEEKEND Brings Pro Teams, Novices Together for 3-Day Stage Race

March 3, 2022, Tucson, AZ /ENDURANCE SPORTSWIRE/ - The Tucson Bicycle Classic is excited to bring pro and novice cyclists together this weekend (March 4-6) for a challenging 3-day stage race! This race is in its 34th year, and has a reputation within the cycling community for being challenging, well-run...

Cycling

Events

Press Releases