SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
					 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (8742)
) AND ( 
  ( wp_postmeta.meta_key = 'promoted' AND wp_postmeta.meta_value LIKE '{303009d1b1b26da2bbe1cbc6611283b3f7061d28d763be356d0ed41a51804b34}1{303009d1b1b26da2bbe1cbc6611283b3f7061d28d763be356d0ed41a51804b34}' )
) 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.post_date DESC
					 LIMIT 290, 10

September 24, 2021

Showcased

P3R Joins Greater Pittsburgh Community Food Bank Sports and Media Coalition

PITTSBURGH (Sept. 24, 2021) – P3R, the engine behind Pittsburgh’s greatest races – including the DICK’S Sporting Goods Pittsburgh Marathon – is honored to share that it has joined the Greater Pittsburgh Community Food Bank’s new initiative aimed at ending childhood hunger. The Sports and Media Coalition is a collaborative...

Business

Press Releases

Running

September 23, 2021

Showcased

GFNY Ecuador: Spectacular coastal roads at the equator

/ENDURANCE SPORTSWIRE/-- GFNY Global Endurance Sports Series returns to Latin America for the third time this year with GFNY Ecuador on Sunday, September 26. The race offers a long course of 143 kilometers and a (non-competitive) medium course of 65 kilometers. The competitive long course, with 2034 meters of climbing, ...

Cycling

Events

Press Releases

September 23, 2021

Showcased

GFNY Santa Fe: Ferrara still wins post-pandemic

/ENDURANCE SPORTSWIRE/-- The second annual GFNY Santa Fe bounced back from the pandemic with a bang. The southern end of the Rocky Mountains made for spectacular racing in a high altitude setting with perfect racing weather. The 75-mile course included 7,150 feet of climbing of which most is attacked at...

Cycling

Events

Press Releases