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

November 20, 2023

John Dzierzbicki (Chandler, Ariz.) And Maggie Walsh (Littleton, Colo.) Top Finishers At 2023 Paradox IRONMAN Arizona Triathlon, Part of The Vinfast IRONMAN North America Series

TEMPE, Ariz. /ENDURANCE SPORTSWIRE/ - The Valley of the Sun provided a stunning backdrop for the 19th edition of the Paradox IRONMAN® Arizona triathlon, part of the VinFast IRONMAN North America Series, on Sunday, Nov. 19, 2023. John Dzierzbicki from Chandler, Arizona (M30-34 Age Group) crossed the finish line first,...

Events

Press Releases

Triathlon

November 20, 2023

First edition of Challenge Canberra gears up with stunning pro field

/ENDURANCE SPORTSWIRE/ - It may be the first edition of Challenge Canberra, but this coming weekend it will kick off with a superb pro field. A great battle is expected in both the women's and men's races, with Fenella Langridge and Daniel Bækkegård as the top seeds. Fenella Langridge has...

Events

Press Releases

Triathlon

November 20, 2023

Marathonfoto/Sportograf Announced as The Official Sponsor of the 2023 Mass Participation World Conference

Ho Chi Minh City, Vietnam /ENDURANCE SPORTSWIRE/ - MarathonFoto and Sportograf, the world’s leading race photography group, are proud to announce their sponsorship of the 2023 Mass Participation World Conference (MPW23) as the official photography partner for the next three years. This partnership is set to enhance the overall experience...

Business

Events

Press Releases

Running

November 18, 2023

La Routa Adventure Race in the Philippines Hosts the ARWS Asia Championship

.ENDURANCE SPORTSWIRE/- International adventure racing returns to the Philippines next week, when La Routa Adventure Race hosts the Adventure Racing World Series Asia Championship. La Routa is the longest established adventure race in The Philippines, and ran continuously from 2000 to 2010. It was revived in 2019, and now returns...

Events

Press Releases

November 17, 2023

The Carlsbad Marathon, Half Marathon and 5K Offers Unique LEGOLAND® Race Location for Kids Marathon Mile

Carlsbad, Calif. — The Carlsbad Marathon, Half Marathon and 5K, produced by In Motion Events, returns on Jan. 14 for another year of scenic oceanfront running. One day before the event, on Jan. 13, the Kids Marathon Mile will be taking place at LEGOLAND® California Resort, before the doors open...

Events

Press Releases

Running

November 17, 2023

Exploring the Mountains of Mexico with La Ruta Madre Adventure Race

/ENDURANCE SPORTSWIRE/ – La Ruta Madre Expedition Race starts on Saturday and the new ARWS Demonstration race will give teams the chance to explore the mountains and canyons of Nuevo Leon province in Mexico. Teams from the US, Canada and Mexico can expect a great adventure on a tough 500km...

Events

Press Releases

November 17, 2023

BibRave Helps Strava Shine at the New York City Marathon

New York, NY /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently crafted an engaging weekend of events at the New York City Marathon for the connected fitness platform, Strava. The multi-day event brought together athletes, creators, and spectators to celebrate running and women’s sports. The weekend of...

Events

Press Releases

November 17, 2023

Over 3000 racers at 10th edition of GFNY Cozumel

New York City, November 17, 2023 /ENDURANCE SPORTSWIRE/ - The completely closed to traffic 157.5km cycling long race course of the 10th GFNY Cozumel is flat yet windy and as such one of the toughest bike races in Latin America. 3000 riders were ready to race hard and play hard,...

Cycling

Events

Press Releases