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

December 26, 2023

SUAREZ and Gran Fondo National Series Release 2024 Event Apparel Collection

(Gettysburg, PA – December 26, 2023) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series and SUAREZ Cycling Apparel today released the designs for event-specific cycling jerseys that will be included with registration for 2024 Gran Fondo National Series owned events. Now in its third year as the title sponsor of the...

Business

Cycling

Events

Press Releases

Sponsorship

December 22, 2023

Mountain Outpost to Broadcast the 2024 Hardrock 100

/ENDURANCE SPORTSWIRE/ - The Hardrock Hundred Mile Endurance Run (Hardrock) is excited to announce a partnership with Mountain Outpost (a division of Aravaipa Running) to deliver the 2024 Livestream of the Hardrock. Building on the excitement generated from the 2023 Livestream, Hardrock is looking forward to working with Mountain Outpost...

Business

Events

Press Releases

Running

Sponsorship

December 21, 2023

Marathon Tours & Travel announces further growth of expert team

/ENDURANCE SPORTSWIRE/ Marathon Tours & Travel (MTT) provides comprehensive travel packages for runners that include guaranteed entry, transfers, accommodation, and expert team support for some of the most popular events around the world. Proud partners of the Abbott World Marathon Majors, the team is extremely well connected, working closely with global...

Business

Press Releases

Running

December 21, 2023

The Atlanta Rise, Denver Disruptors, and Miami Nights Announce their 2024 National Cycling League (NCL) Cup Team Rosters

 (Miami, Fla, December 21, 2023) /ENDURANCE SPORTSWIRE/ - After a successful inaugural season, three teams from the National Cycling League announced their 2024 rosters. Two second-year teams, Denver Disruptors and Miami Nights, will include riders from 2023, plus talented rookies and familiar names. First-year team Atlanta Rise has a roster...

Business

Cycling

Events

Press Releases