select * from `newcht_ad` where ad_cate='2' and (ad_status='1' or (ad_status='2' and ad_startdate <= '2018-08-17' and ad_enddate >= '2018-08-17') ) and (ad_show_type='0' or (ad_show_type='1' and find_in_set('0',ad_show_zone)>0 )) order by rand()