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

May 23, 2022

Expedition Oregon 2022 Takes Adventure Racing to a new Level of Endurance

/ENDURANCE SPORTSWIRE/ - Expedition Oregon 2022 was a race which will live long in the memory of the teams who raced and survived it, and of the many thousands of fans who were gripped by the online race coverage. It was a true expedition, a great competition, and lived up...

Events

Press Releases

May 23, 2022

Microsoft Teams integration for CorporateFitness.app released

May 23, 2022 /ENDURANCE SPORTSWIRE/ – CorporateFitness.app is proud to announce the immediate availability of its Microsoft Teams integration. The brand new Microsoft Teams integration brings your corporate step or fitness challenge right inside the Microsoft Teams app everyone is already using all day long! Using this new integration your team can...

Press Releases

Products

May 23, 2022

Registration is now open for the 5th Annual Tiger 10K

Baton Rouge, LA (May 23, 2022)/ENDURANCE SPORTSWIRE/ – Registration for the Fifth Annual Our Lady of the Lake Tiger 10K is now open. The event, which features a 10K, 5K and a Kids Mile, will take place Sunday, Dec. 4, at the South Gates of Tiger Stadium. Thousands of runners, joggers...

Events

Press Releases

Running

May 23, 2022

Run Tucson Announces Prize Money for Grand Canyon Trail Half Marathon

/ENDURANCE SPORTSWIRE/ - The November 4th Grand Canyon Trail Half Marathon is pleased to announce that it is offering prize money in 2022. With a loop course through the scenic Kaibab National Forest, the Trail Half Marathon will begin and end in Grand Canyon Village, located just a few miles...

Press Releases

Running

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 22, 2022

Runners Rejoice at 13th Annual Life Time Chicago Spring Half Marathon and 10K

CHICAGO – (May 22, 2022) /ENDURANCE SPORTSWIRE/ - The 13th annual Life Time Chicago Spring Half Marathon & 10K returned triumphantly after a two-year hiatus on Sunday, May 22 as more than 5,000 runners hailing from 47 states and 27 countries toed the start line at Maggie Daley Park downtown...

Press Releases

Running

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