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 (16)
) 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 4090, 10

May 22, 2022

Tulsa, Oklahoma’s Sam Carr and Boulder, Colorado’s Maggie Rusch Victorious at Second Edition Of Certified Piedmontese Beef IRONMAN Tulsa Triathlon

TULSA, Okla. (May 22, 2022) /ENDURANCE SPORTSWIRE/ - Northeastern Oklahoma provided a stunning backdrop for the second edition of the Certified Piedmontese Beef IRONMAN triathlon on Sunday, May 22. Athletes from around the world started the Certified Piedmontese Beef IRONMAN triathlon, it was local Tulsa, Okla. athlete Sam Carr from...

Events

Press Releases

Triathlon

May 22, 2022

Jason West (USA) And Jackie Hering (USA) Claim Victories At 2022 Sunbelt Bakery IRONMAN 70.3 North American Championship Chattanooga Presented by Mckee A Family Bakery

CHATTANOOGA, Tenn. (May 22, 2022) /ENDURANCE SPORTSWIRE/ - The Scenic City and southeastern Tennessee and northern Georgia provided a stunning backdrop for the 2022 Sunbelt Bakery IRONMAN® 70.3® North American Championship Chattanooga presented by McKee A Family Bakery triathlon. With some of triathlon’s best on hand,  Jason West (USA) won the...

Events

Press Releases

Triathlon

May 20, 2022

Yinz Like to Run, N’at? Dress in Yer Finest Steel City Attire and Run the Yinzer 4.12K® on Aug. 20

PITTSBURGH (May 20, 2022)/ENDURANCE SPORTSWIRE/ – Light of Life Rescue Mission, in partnership with P3R, will once again host the annual Yinzer 4.12K® and Lil’ Yinzer Fun Run this year on Saturday, Aug. 20. The event welcomes runners from across the region to dress up in ways that represent Pittsburgh to...

Events

Giving

Press Releases

Running

May 20, 2022

Celebrating Sisterhood on Bikes

Washington, D.C. /ENDURANCE SPORTSWIRE/ – Major Knox Adventures is pleased to announce the launch of the 1928 Legacy Tour and Virtual Endurance Challenge, set to take place this Memorial Day weekend. This 250 mile endurance ride follows in the tracks of 5 Black female cycling pioneers, who blazed a trail from Harlem...

Cycling

Events

Press Releases

May 19, 2022

Electrolit Partners with Pato O’Ward For The 2022 Racing Season To Assist Him in Competing At Highest Level

CERRITOS, Calif. (May 19, 2022) /ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – has partnered with racecar driver Pato O’Ward for the 2022 racing season, including the Indianapolis 500 Race on May 29th. Working to support young and talented competitors, Electrolit...

Events

Press Releases

Sponsorship