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

July 10, 2024

The RunnerBox and RiderBox Announce Their Top Picks to Fuel Your Summer Adventures

/ENDURANCE SPORTSWIRE/ – The RunnerBox and The RiderBox, leaders in the endurance subscription space, have announced the release of their highly anticipated Summer Edition which will be available exclusively at Fuel Goods. Just in time for those warmer months, this new lineup features a selection of thoughtfully curated fuel and...

Cycling

Press Releases

Products

Running

Triathlon

July 9, 2024

Australia Set to Host 2025 XTERRA Asia-Pacific Championship

Key Points Dunsborough welcomes the 2025 XTERRA Asia-Pacific Championship, XTERRA World Cup opener, and Asia-Pacific Trail Run Championship in March 2025. The 2-day event includes Full Distance and Sprint Triathlons, a livestreamed XTERRA Short Track race, and youth-focused competitions. Supported by Tourism Western Australia Regional Events Scheme, Royalties for Regions,...

Cycling

Events

Press Releases

Running

Triathlon

July 9, 2024

Registration Now Open for the 18th Annual Buzzards Bay Watershed Ride October 6th

NEW BEDFORD, Mass./ENDURANCE SPORTSWIRE/ - Fall is the perfect time to pedal through the fresh air and stunning landscapes of southeastern Massachusetts. If you love to ride and want to make a difference in your local environment, then sign up for the 18th Annual Buzzards Bay Watershed Ride on Sunday,...

Cycling

Press Releases

July 9, 2024

Penticton To Host Its Final IRONMAN Canada Event In 2024; Ottawa To Carry On The Legacy Of IRONMAN Canada Beginning In 2025

- Final edition of IRONMAN Canada and IRONMAN 70.3 Canada in Penticton, B.C., Canada to take place on August 25, 2024; registration for final event in Okanagan Valley is available by visiting www.ironman.com/im-canada and www.ironman.com/im703-canada - First edition of IRONMAN Canada triathlon in Ottawa, part of the VinFast IRONMAN North...

Events

Press Releases

Triathlon

July 9, 2024

Spectrum Sports Management Obtains Sustainability Certification for Catalina Island Marathon

CLAREMONT, Calif. /ENDURANCE SPORTSWIRE/ – Spectrum Sports Management, producer of the Run Catalina Island race series, has announced that the Catalina Island Marathon has received the Silver Certification from the Council of Responsible Sport, the world's leading responsible sport certification program. The Council of Responsible Sport attended the 2024 Catalina...

Awards

Press Releases

July 9, 2024

La Sala Named Emerging Industry Leader By NCS4

/ENDURANCE SPORTSWIRE/ - Blistering Pace Race Management President Michelle La Sala will be recognized with the 2024 Emerging Industry Leader Award by the National Center for Spectator Sports Safety and Security. The award is given to a professional who has demonstrated outstanding leadership in addressing safety and security issues. The...

Awards

Business

Events

Press Releases

Running

July 9, 2024

Permasteel Launches All-New Elevated Garden Bed

Pomona, Calif. (July 9, 2024) — Permasteel, a leading innovator in outdoor living products, proudly announces the launch of its all-new elevated garden bed powered by EnGrow’s patented TrueSoil™ Technology. This high-quality, durable, cutting-edge patio-style raised garden bed is now available wherever Permasteel products are sold. “This garden bed is...

Press Releases

Products

Wire Syndication

July 9, 2024

Course Revealed for the 2024 Vinfast IRONMAN 70.3 World Championship In Taupō, New Zealand

TAUPŌ, New Zealand / TAMPA, Fla. (9 July, 2024) - With five months to go until more than 6,000 of the world’s top professional and age-group triathletes descend on Taupō, New Zealand for the 2024 VinFast IRONMAN® 70.3® World Championship triathlon, IRONMAN is excited to reveal the championship course that...

Events

Press Releases

Triathlon