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 (21083)
) AND ( 
  ( wp_postmeta.meta_key = 'promoted' AND wp_postmeta.meta_value LIKE '{47b9be6bb8c68b7fbe544e45f9b772e305936469c63722c8a2ede9a3e238409b}1{47b9be6bb8c68b7fbe544e45f9b772e305936469c63722c8a2ede9a3e238409b}' )
) 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 20, 10

January 6, 2022

Showcased

Monuments Of Cycling Announce Largest Ever One-Day Gravel Prize Purse for Belgian Waffle Ride CA

San Diego, CA  - January 6, 2022/ENDURANCE SPORTSWIRE/ - Monuments of Cycling (MoC), a premier cycling events producer best known for its iconic Monument of Gravel, the Belgian Waffle Ride (BWR), announced on Tuesday the prize purse for the BWR CA on April 30, 2022 will be the largest ever...

Awards

Cycling

Events

Press Releases

December 8, 2021

Showcased

Pure Gravel Announces 2021 Gravel Cycling Power Rankings

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Pure Gravel is excited to announce the 2021 Gravel Power Rankings results. The rankings give points to the top fifteen finishers at the largest gravel cycling events of the year. The winners are bestowed the coveted title of “King and Queen of Gravel” and a...

Awards

Cycling

Press Releases