select * from `neweng_ad` where ad_cate='2' and (ad_status='1' or (ad_status='2' and ad_startdate <= '2017-06-27' and ad_enddate >= '2017-06-27') ) and (ad_show_type='0' or (ad_show_type='1' and ( find_in_set('products',ad_show_func)>0 ) ) ) order by rand()