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

January 31, 2024

Ultimate Endurance Test Added to Marathon Weekend: Oxford Athletic Club Pittsburgh 4-Mile Fitness Challenge Moves Beyond Running and Walking

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has unveiled a new thrilling, adrenaline-pumping fitness challenge for the 2024 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. Limited to 500, the Oxford Athletic Club Pittsburgh 4-Mile Fitness Challenge will test participants’ full body endurance through a series of six fitness challenges. These feats will...

Events

Press Releases

Running

January 31, 2024

International run travel experts Marathon Tours & Travel acquires Kangaroo Island Marathon

January 31, 2024/ENDURANCE SPORTSWIRE/ – Kangaroo Island lies 14km off the mainland of South Australia, a short 90-minute drive from the city of Adelaide. Kangaroo Island was recently named one of the top ten travel destinations in the world by Lonely Planet and the New York Times. One third of the island...

Business

Events

Press Releases

Running

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