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

February 9, 2022

Quincy Cass Associates Marathon Challenge to Highlight Elite Runners of 2022 Los Angeles Marathon

Los Angeles, CA (February 10, 2022) /ENDURANCE SPORTSWIRE/ - The 2022 Los Angeles Marathon presented by ASICS is proud to announce the return of the Quincy Cass Associates Marathon Challenge, an exciting 26.2-mile race-within-a-race competition that will highlight the talented runners of the women’s and men’s elite fields in an...

Events

Press Releases

Running

Sponsorship

February 9, 2022

BikeFlights.com Announces 2022 Brand Ambassadors

PORTLAND, OR (February 9, 2022) /ENDURANCE SPORTSWIRE/ - BikeFlights, an easy-to-use bicycle shipping service and supplier of easy-to-pack bike boxes, is pleased to introduce its Brand Ambassadors for the 2022 season, including 39 individuals and one team. “We have an amazing and talented roster of cyclists who will represent BikeFlights...

Cycling

Press Releases

Sponsorship

Triathlon

February 9, 2022

Ultrarunner Dylan Bowman Signs to Gnarly Nutrition Athlete Team

Salt Lake City, UT (February 9, 2022) /ENDURANCE SPORTSWIRE/ - Gnarly Nutrition is excited to announce the official signing of ultrarunner Dylan Bowman to its athlete team. “I'm really excited to join the Gnarly Nutrition team and am glad they had the vision to create such a unique partnership,” said...

Press Releases

Running

Sponsorship

February 8, 2022

Showcased

UNDRBUDR Continues Partnership with Gran Fondo National Series as Exclusive Chamois Cream Partner Through 2022

Montclair, NJ, February 8, 2022 /ENDURANCE SPORTSWIRE/ - UNDRBUDR, developer of high performance, nature-inspired skin care and recovery products, today announced an exclusive sponsoring partnership with the Gran Fondo National Series (GFNS) to continue throughout 2022.  This year the relationship will expand to highlight the company's full line of skin...

Press Releases

Sponsorship

February 8, 2022

F2C Nutrition Named Official Nutrition Partner of the Somersault Multisport Series

/ENDURANCE SPORTSWIRE/ - F2C Nutrition Inc. has partnered with the Somersault Multisport Series. F2C Nutrition, known for its clean, athlete-focused, science driven premium sports nutrition products and internationally recognized for quality and innovation, will support Eastern Ontario’s largest multisport series with race fuel, electrolytes and recovery beverages. “The Somersault Multisport Series...

Events

Press Releases

Running

Sponsorship

Triathlon