c174:resulting where: AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND ((YEAR(wp_posts.post_date)=2014 AND MONTH(wp_posts.post_date)=06 AND DAYOFMONTH(wp_posts.post_date)=19) OR ((YEAR(start)=2014 AND MONTH(start)=06 AND DAYOFMONTH(start)=19) OR (start<='2014-06-19 0:0:0' AND end>='2014-06-19 0:0:0')))