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

December 20, 2021

American Surfer Sage Erickson Joins The Pho3nix Movement

20 December 2021, SYDNEY /ENDURANCE SPORTSWIRE / - MANA Sports & Entertainment Group are proud to announce American professional surfer Sage Erickson has signed on as an ambassador for the Pho3nix Foundation, a not-for-profit with the express aim to assist and inspire children through sport. The Pho3nix Foundation has tasked...

Business

Press Releases

Sponsorship

December 15, 2021

The Mesa Marathon’s 10-Year Anniversary Presented by Mountain Vista Medical Center

Mesa, Arizona /ENDURANCE SPORTSWIRE/ - The Mesa Marathon is proud to announce its new presenting sponsor Mountain Vista Medical Center, a Steward Family Hospital and Mesa’s premier hospital. The Mesa Marathon presented by Mountain Vista Medical Center will commence on February 12, 2022. “We are very excited to be a...

Events

Press Releases

Running

Sponsorship

December 15, 2021

Showcased

Mark Allen Sports Announces New Partnership

Santa Cruz, December 14, 2021 - /ENDURANCE SPORTSWIRE/ - Mark Allen Sports is proud to announce a new partnership with one of the leading brands in performance nutrition, Tennant Products. "Whether you are at the top of your game or starting at the beginning, Tennant Products has a product that...

Business

Press Releases

Products

Sponsorship

Triathlon

December 14, 2021

Thorne HealthTech Announces Multi-Year Partnership with Professional Cycling Team, Human Powered Health

NEW YORK, Dec. 14, 2021 /ENDURANCE SPORTSWIRE/ - Thorne HealthTech today announced a new, multi-year partnership with Human Powered Health (formerly Rally Cycling one of America’s top professional teams), in which Thorne will serve as their Official Personalized Health Solutions Partner. The partnership will equip the elite athletes of Human...

Cycling

Press Releases

Sponsorship

December 14, 2021

Applewood Manor Announced as Presenting Sponsor of Gran Fondo Asheville and USA Cycling Gran Fondo National Championships for 2022

Gettysburg, PA – December 14, 2021 /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series is proud to announce Applewood Manor Bed & Breakfast as the Presenting Sponsor for both Gran Fondo Asheville and the USA Cycling Gran Fondo National Championship events, to be held in Asheville, North Carolina on July 17, 2022....

Cycling

Events

Press Releases

Sponsorship