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 (11)
) 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 990, 10

January 9, 2025

360 Hoops™ is Coming to New Jersey! Iron Peak Sports & Events Partners with the Innovative New Sports Experience

Hillsborough Township, NJ - January 9, 2025 /ENDURANCE SPORTSWIRE/ – Renowned as Central Jersey’s premier destination for sports, fun, and healthy competition, Iron Peak Sports & Events is the ideal partner for 360 Hoops to debut its revolutionary new game in the state. With perfectly aligned missions, Iron Peak is...

Business

Events

Press Releases

Products

January 8, 2025

Tri Travel announced as new travel partner of the German Triathlon Union (DTU)

January 8, 2025, Manchester UK /ENDURANCE SPORTSWIRE/ - The cooperation will span four years and will see Tri Travel offering travel management for the DTU. Customised travel planning for all levels of triathlon Tri Travel will plan and coordinate travel for the national DTU teams to international competitions, whilst also...

Business

Press Releases

Triathlon

January 8, 2025

The Hub and Pisgah Tavern Launches ‘Local Love on Wheels’ Hurricane Helene Relief Fundraiser

Brevard, NC — January 8, 2024 /ENDURANCE SPORTSWIRE/ – In response to Hurricane Helene, which swept through the Southeast on September 27th causing widespread destruction, The Hub and Pisgah Tavern is honored to announce the launch of "Local Love on Wheels," a special fundraising initiative aimed at supporting the ongoing...

Business

Giving

Press Releases

January 8, 2025

New Horizons for Tour de Big Bear 2025

Big Bear Lake, CA (January 8, 2025) /ENDURANCE SPORTSWIRE/ – The Big Bear Cycling Association (BBCA) is thrilled to announce the highly anticipated return of the Tour de Big Bear in 2025. The Tour de Big Bear has solidified its status as a leading Gran Fondo in North America. Voted...

Business

Cycling

Events

Press Releases

January 8, 2025

Fusion Media Appointed as PR Agency for Mizuno Running in the UK

January 8, 2025 /ENDURANCE SPORTSWIRE/ - Fusion Media, the integrated PR and Marketing agency specialising in cycling, running, outdoor and lifestyle brands, is delighted to announce its partnership with Japanese global sporting goods brand Mizuno. Fusion Media will focus exclusively on promoting Mizuno’s innovative running products, helping to elevate the...

Business

Press Releases

Running

January 8, 2025

RunSignup Releases 2024 Top 100 Largest Road Races

Moorestown, NJ—January 8, 2025 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for races in the U.S., released a list of the Top 100 Largest Road Races in the United States. In the absence of a single aggregator for US road race data, this report is compiled to...

Business

Events

Press Releases

Running

Studies

Triathlon

January 8, 2025

US Trail Running Conference Launches Race Director Mentorship Program

January 8, 2025 /ENDURANCE SPORTSWIRE/ - The US Trail Running Conference, presented by Marathon Printing, Inc., announced an innovative Race Director Mentorship Program at the 2024 event, held October 23-25, 2024, in Knoxville, TN. The initiative invited race directors to complete an online application ahead of the Conference to apply...

Business

Press Releases

Running