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

April 18, 2024

OOFOS Unveils One-of-a-Kind Recovery Sponsorship at Boston Marathon Finish Line

BRAINTREE, MA /ENDURANCE SPORTSWIRE/ – OOFOS, the Boston-based global leader in Active Recovery footwear, confirms its commitment to recovery by implementing a completely unique sponsorship initiative that supports and celebrates “Real People” in their recovery journey following the Boston Marathon. With a pop-up retail store located by the Boston Marathon...

Events

Press Releases

Running

Sponsorship

April 18, 2024

Inaugural Michelob Ultra GFNY Miami this Sunday

/ENDURANCE SPORTSWIRE/ - This Sunday, Michelob Ultra GFNY Miami offers riders an entirely flat and fast racecourse of 70.7 miles completely closed to traffic. The North American Championship race starts and finishes at Miccosukee Resort & Casino on the western edge of Miami at the portal to the Everglades. Race...

Cycling

Events

Press Releases

April 17, 2024

Riviera Nayarit, Mexico Set To Host New IRONMAN 70.3 Triathlon

- Organizers of the IRONMAN 70.3 Acapulco, IRONMAN 70.3 Campeche, IRONMAN 70.3 Cozumel, IRONMAN 70.3 Monterrey, and IRONMAN Cozumel races to host new event - The inaugural IRONMAN 70.3 Riviera Nayarit triathlon is scheduled to take place on Sunday, Nov. 10, 2024; Registration is now available by visiting www.ironman.com/im703-riviera-nayarit MEXICO...

Events

Press Releases

Triathlon

April 17, 2024

Chevron Joins the Denver Colfax Marathon as the 2024 Race Volunteer Sponsor

Denver, CO /ENDURANCE SPORTSWIRE/ – The Denver Colfax Marathon, presented by Cigna Healthcare, welcomes Chevron as the 2024 race volunteer program sponsor. This partnership will allow for the marathon to continue its support of more than a thousand volunteers during the race weekend in May. “Our volunteers are a major...

Events

Press Releases

Running

Sponsorship

April 17, 2024

supertri League Calendar Delivers Two New Events In USA

/ENDURANCE SPORTSWIRE/ – supertri is expanding in North America with two new events forming part of a five-stop League that will see the world’s best athletes take on fast, technical and tactical racing just weeks after competing in the Olympics. A US-double header will open up supertri’s stunning 2024 League,...

Events

Press Releases

Triathlon

April 17, 2024

Ekoï official partner of GFNY USA

NEW YORK CITY, April 17, 2024 /ENDURANCE SPORTSWIRE/ - French brand Ekoï partners with GFNY to become the official Helmet, Sunglasses and Shoes of GFNY USA. The US race series includes the iconic Michelob ULTRA GFNY World Championship NYC as well as the brand new Michelob ULTRA GFNY Miami. “The...

Cycling

Events

Press Releases

Sponsorship

April 17, 2024

Athletes Line Up for Challenge Family European Season Opener on Gran Canaria

/ENDURANCE SPORTSWIRE/ - This weekend, on 20 April, the picturesque island of Gran Canaria will once again host Anfi Challenge Mogán Gran Canaria. Athletes from 27 countries will gather to test their endurance, strength, and determination against the stunning backdrop of this Canary Island European season opener. The tough and...

Events

Press Releases

Triathlon