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

January 31, 2024

First US pro team announced at GP New York City

NEW YORK CITY, January 31, 2024 /ENDURANCE SPORTSWIRE/ – The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The teams...

Cycling

Events

Press Releases

January 30, 2024

PTO Announces Blockbuster Eight-Stop 2024 Calendar. Relaunching As The T100 Triathlon World Tour

London, UK/ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) and World Triathlon have announced today a significant relaunch of the PTO Tour, with 40 of the world’s highest ranked athletes competing in an expanded 2024 calendar that will feature eight races and will be known as the T100 Triathlon World...

Business

Events

Press Releases

Triathlon

January 30, 2024

Cycling Time Trials (CTT) unveils 2024 calendar with National Championship details

30th January 2024 /ENDURANCE SPORTSWIRE/ – Known as ‘the race of truth’ because there’s nowhere to hide, no wheel to sit on and no bunch to draft behind, time trialling is the purest form of bike racing: it’s just you against the clock. How fast can you complete the course? In...

Cycling

Events

Press Releases