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

October 13, 2021

Spartan Race Becomes Official Sponsor of Sports Business Networks

BOSTON, MA (October 13, 2021) -- Joe De Sena, the CEO of Spartan Races, has announced that Spartan will become the official sponsor of Sports Business Networks (SBN). SBN seeks to be the first true business networking platform for current and former college athletes, coaches, referees, and supporters, and it...

Events

Press Releases

Running

Sponsorship

October 12, 2021

Mascot Sports Launches First-Ever Marin Endurance Festival to Bring the Best of Running and Tri to the Bay Area

OAKLAND (October 12, 2021) – Mascot Sports, a leader in sports and experiential marketing, has acquired the Marin Triathlon and Marin Half Marathon to create the first ever Marin Endurance Festival. The festival will take place on October 30 and 31, and will include a triathlon, duathlon, half marathon, 10K...

Events

Press Releases

Running

Triathlon

October 11, 2021

CampoVelo Creates Women’s Only Cycling Weekend in Napa Valley

CALISTOGA, Calif. (Oct. 11, 2021) – CampoVelo, wine country’s premier cycling event, today announced its inaugural women’s only weekend lineup for Friday, October 22 through Sunday, October 24, 2021. Limited to 50 participants, the curated event combines cycling, skills clinics, cuisine, wine and beer tasting, and wellness for a unique...

Cycling

Events

Press Releases