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

January 10, 2022

Runners from around the world celebrating Louisiana culture with weekend-long festival

BATON ROUGE, La. /ENDURANCE SPORTSWIRE/ - Thousands of runners from over 44 states and as far away as Denmark will celebrate more than a decade’s worth of passion for running and Louisiana culture at this weekend’s Louisiana Marathon. Now in its 11th year, the Louisiana Marathon aims to encourage the...

Events

Press Releases

Running

January 10, 2022

Sea, Air & Space Challenge Announced for 2022 U.S. Military Races

ELIZABETH CITY, NC | WRIGHT-PATTERSON AFB, OH (January 10, 2022) /ENDURANCE SPORTSWIRE/ - In honor and celebration of the collaborative efforts of the branches of the U.S. Armed Forces, the 2022 Coast Guard Marathon, Air Force Marathon and Space Force T-Minus 10-Miler have launched a first-of-its-kind, cross-race challenge for their...

Events

Press Releases

Running

January 10, 2022

Rock Harbor Marketing Picks Up World Obstacle Sports Federation

Morro Bay, CA  – (January 10, 2022) /ENDURANCE SPORTSWIRE/ - Rock Harbor Marketing (RHM), a digital marketing company based in Morro Bay, California, has added World Obstacle to its growing list of globally recognized clients. World Obstacle, also known as the Fédération Internationale de Sports d'Obstacles (FISO), is the sole international...

Business

Press Releases

January 8, 2022

Runners Celebrated the Return of the DICK’S Sporting Goods Pittsburgh Marathon with Annual Kickoff Training Run

PITTSBURGH (Jan. 8, 2022) /ENDURANCE SPORTSWIRE/ - After two years of crossing virtual finishers tapes, runners are thrilled for the opportunity to toe the start line of an in-person DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. This morning more than 300 runners met outdoors at P3R headquarters on the...

Events

Press Releases

Running

January 7, 2022

Compete PR chosen by Destination Sport Experiences for PR support in 2022

/ENDURANCE SPORTSWIRE/ - The newest name in sports travel, Destination Sport Experiences caters for those who want to participate in the very best cycling, running and triathlon events around the world, whilst focusing on the logistics, so their customers can focus on what really matters – the taking part, and enjoying...

Business

Cycling

Events

Press Releases

Running

Triathlon

January 6, 2022

Tucson Bicycle Classic Delighted to Announce Title Sponsor, The Meteor

January 6, 2022, Tucson, AZ /ENDURANCE SPORTSWIRE/ - The Tucson Bicycle Classic is delighted to announce The Meteor as Title Sponsor for the Tucson Bicycle Classic p/b The Meteor. In addition to the sponsorship, The Meteor will be involved in social media prize giveaways through the Tucson Bicycle Classic Facebook page....

Cycling

Events

Press Releases

Sponsorship