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

March 14, 2022

Registration opens for 2022 Mississippi Gulf Coast Marathon

Biloxi, Ms. /ENDURANCE SPORTSWIRE/ - Runners who missed last year’s Mississippi Gulf Coast Marathon have another chance to #soakuptherun. Registration for the race in Dec. 2022 officially opens Monday offering the best deals and exclusive gear for a limited time. Runners who register before Mar. 22 will not only receive...

Business

Events

Press Releases

Running

Sponsorship

Studies

March 13, 2022

World Series CEO Heidi Muller Talks about Life, Family and Adventure Racing

/ENDURANCE SPORTSWIRE/ - Careful consideration doesn’t always play a part when choosing what you do in life.  Sometimes it’s all about emotion, ambition, and taking the opportunities that come your way. When Heidi Muller first went adventure racing 24 years ago, without really knowing what she was getting into, it...

Business

Events

Press Releases

Sponsorship

March 9, 2022

Bikerumor promotes Zach Overholt to Editor in Chief

MARCH 9, 2022 | LOS ANGELES, CALIF. /ENDURANCE SPORTSWIRE/ - Bikerumor, a Lola Digital Media publication, is proud to announce new editorial leadership with the promotion of Zach Overholt to Editor in Chief (EIC). Overholt replaces Tyler Benedict, who founded Bikerumor in 2008. The publication covers the cutting-edge of bike...

Business

Cycling

Press Releases