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

November 2, 2021

Showcased

San Diego County Credit Union Returns as Title Sponsor of SDCCU OC Marathon

NEWPORT BEACH, Calif. -- (November 2, 2021) /ENDURANCE SPORTSWIRE/ - San Diego County Credit Union® (SDCCU®), one of California’s largest credit unions, today announced its return as the title sponsor of the SDCCU OC Marathon Running Festival. The 2021 event will take place the weekend of November 6-7, with a half-...

Events

Press Releases

Running

November 2, 2021

The Run Show USA Partners with RaceRaves to Bring Events Village Concept to Life

/ENDURANCE SPORTSWIRE/ The Run Show USA, a newly launched expo for running enthusiasts, today announced a partnership with RaceRaves, the leading online race finder and reviews community for runners of all levels, to develop an Events Village as a key feature of each 2022 Run Show USA event (Jan 29-30...

Events

Press Releases

Running

November 1, 2021

The McCourt Foundation Welcomes Return of the 2021 Los Angeles Marathon presented by ASICS

Los Angeles – November 1, 2021 – Brian McCourt recalls growing up alongside his six brothers with Multiple Sclerosis a part of their life. Their father, Robert, had been diagnosed before any of his sons were born, and long outlived any expectations when he was diagnosed at the young age...

Events

Press Releases

Running

November 1, 2021

Showcased

St. Jude Heroes reach $100 million milestone for St. Jude Memphis Marathon Weekend

MEMPHIS, Tenn. (Nov. 1, 2021) / ENDURANCE SPORTSWIRE /– What does it take to keep St. Jude Children’s Research Hospital® running? If you’re a St. Jude Hero, that means running for a purpose for events like the St. Jude Memphis Marathon® Weekend presented by Juice Plus+®. For years, tens of...

Events

Giving

Press Releases

Running

November 1, 2021

US Mountain Running Team Racing XTERRA Trail Run Worlds in Maui, Dec 4

November 1, 2021 /ENDURANCE SPORTSWIRE/ - The top trail runners in the U.S. are headed to Hawaii to compete in the XTERRA Trail Run World Championship half-marathon at The Ritz-Carlton, Kapalua on December 4, 2021. Highlighting the all-star cast from the U.S. Mountain Running Team are 2019 XTERRA Trail Run...

Events

Press Releases

Running

November 1, 2021

O’Side Turkey Trot’s Triumphant Return Set For Thanksgiving Day

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ - The O’Side Turkey Trot, San Diego County’s largest Thanksgiving day running event, will be welcoming friends and family back to downtown Oceanside this year and inviting them to ‘move their feet before they eat®’ on Nov. 25. After moving to a virtual event during the...

Events

Press Releases

Running