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

March 15, 2022

Internationally renowned Gravity Media appointed as broadcast partner for Sub7 Sub8

Sydney, Australia – 15th March, 2022 /ENDURANCE SPORTSWIRE/ - Mana Sports and Entertainment Group today announced Gravity Media as the broadcast partner for the Pho3nix Sub7 and Sub8 Project, powered by Zwift, set to take place on the 5th or 6th of June 2022 at the Dekra Lausitzring in Germany....

Business

Events

Press Releases

Triathlon

March 15, 2022

Pikes Peak Apex Welcomes Back Rockshox as Presenting Sponsor

Colorado Springs, CO, March 15, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces a two-year partnership between SRAM and Pikes Peak APEX. The iconic RockShox brand will return as presenting sponsor of the event for 2022 and 2023. “We are very proud,” said Micah Rice, Executive Director of Pikes Peak APEX....

Cycling

Events

Press Releases

Sponsorship

March 15, 2022

Tough Mudder and Contiki Team Up to Offer Sweepstakes Giveaway for an Adventure-Filled Weekend

BOSTON, Mass. (March 15, 2022)/ENDURANCE SPORTSWIRE/ - Contiki, the social travel operator, has teamed up with Tough Mudder, the global leader in obstacle course adventures, to host a sweepstakes giveaway for an adventure-filled weekend. Running today through April 5, 2022, the sweepstakes offers a chance for you and a friend to...

Events

Press Releases

March 15, 2022

Tifosi Optics Launches New Rimless Eyeshield in Time for Spring Cycling

Watkinsville, GA (March 15, 2022)/ENDURANCE SPORTSWIRE/ - Tifosi Optics, the #1 selling brand of eyewear in specialty cycling stores, is excited to announce the March 15 debut of its next rimless eyeshield: The Rail. Ideal for cyclists but equally functional for other endurance pursuits, the Rail offers a lightweight package that...

Cycling

Press Releases

Products

Running

Triathlon

March 14, 2022

Registration opens for 2022 Mississippi Gulf Coast Marathon

Biloxi, Ms. /ENDURANCE SPORTSWIRE/ - Runners who missed last year’s Mississippi Gulf Coast Marathon have another chance to #soakuptherun. Registration for the race in Dec. 2022 officially opens Monday offering the best deals and exclusive gear for a limited time. Runners who register before Mar. 22 will not only receive...

Business

Events

Press Releases

Running

Sponsorship

Studies

March 14, 2022

XTERRA USA Championship Rotates to Colorado

/ENDURANCE SPORTSWIRE/ - The 21st annual XTERRA USA Championship off-road triathlon will be held in conjunction with the new family-friendly and community focused weekend of events in Avon, Colorado on July 15-17, 2022. It’s the first-time XTERRA has hosted its national championship in the Colorado Rockies, following 12 seasons at Snowbasin...

Events

Press Releases

Running

Triathlon