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

March 31, 2022

The 2022 Bay Bridge Run is Set for November 13

/ENDURANCE SPORTSWIRE/ - After a successful return in 2021, Corrigan Sports Enterprises has announced that the Bay Bridge Run is scheduled once again for November 13, 2022.  Registration for the 2022 Bay Bridge Run will open for signups on Monday, April 4. The Bay Bridge Run is one of the...

Events

Press Releases

Running

March 31, 2022

GFNY returns to Puerto Rico

/ENDURANCE SPORTSWIRE/ - The competitive long distance of GFNY Puerto Rico starts and finishes at the spectacular El Conquistador Resort in Fajardo. The 92 miles long course with 6013 feet of climbing tackles the hilly roads on the eastern part of the island along El Yunque National Forest. The non-competitive...

Cycling

Events

Press Releases

March 31, 2022

Natural Grocers® Returns as Sponsor for Rattler Racing In 2022

LAKEWOOD, Colo. (March 31, 2022) /ENDURANCE SPORTSWIRE/ - Natural Grocers® is proud to be a returning sponsor for Colorado-based Rattler Racing in 2022. In addition to being the largest family-operated organic and natural grocery retailer in the U.S., Natural Grocers has a bike racing team that will once again be...

Cycling

Events

Press Releases

Sponsorship

March 31, 2022

Registration is Open for the 2022 Columbia Threadneedle Investments Boston Triathlon

BOSTON – March 31, 2022 /ENDURANCE SPORTSWIRE/ - ethos, the mass participation event organization that produces the Columbia Threadneedle Investments Boston Triathlon, announced today the 14th annual event will be held on July 23-24, 2022. Registration is now open at www.BostonTri.com “The Columbia Threadneedle Investments Boston Triathlon is the only event...

Cycling

Events

Press Releases

Running

Triathlon

March 31, 2022

Tough Ruck is Back! March Honors Fallen Heroes and Raises Funds to Support Fallen Military and First Responders

CONCORD, MA – March 31, 2022 /ENDURANCE SPORTSWIRE/ - Military Friends Foundation, a nonprofit that provides critical assistance to Massachusetts military families and the families of the fallen in times of need, announced today that the 2022 event will take place on Saturday, April 16 at The Fenn School in Concord. Servicemembers, first responders, as well...

Events

Giving

Press Releases

March 30, 2022

IRONMAN Foundation and Challenged Athletes Foundation to Host the Fourth Junior Seau Adaptive Surf Clinic in Oceanside

OCEANSIDE, Calif. / TAMPA, Fla. (March 30, 2022)/ENDURANCE SPORTSWIRE/ - With the kickoff of the 2022 North America IRONMAN season at Athletic Brewing IRONMAN® 70.3® Oceanside triathlon on Saturday, April 2, the IRONMAN® Foundation will distribute more than $30,000 in charitable giveback to nonprofit initiatives and groups in the greater Oceanside...

Events

Giving

Press Releases

Triathlon

March 30, 2022

The Tour of The Alps Goes Virtual – #LIVEUPHILL CHALLENGE on ROUVY

Trento, Italy / March 30, 2022/ENDURANCE SPORTSWIRE/ - The Italian Alps are among the world’s most admired mountains and perhaps the most coveted for those who love to ride for business or pleasure. The Alps need no introduction for cyclists from all over the world, and the images and awe inspired...

Cycling

Events

Press Releases

March 30, 2022

Registration Open for the 2022 Fleet Feet Liberty Mile

PITTSBURGH (March 30, 2022)/ENDURANCE SPORTSWIRE/ - Registration is now open for the 2022 Fleet Feet Liberty Mile, Downtown Pittsburgh’s only night time road race, scheduled for July 22. The one-mile road race showcases a variety of fitness levels, from first-time runners to Olympians, and is consistently named “one of America’s most...

Events

Press Releases

Running