select * from `cht_ad` where ad_cate='2' and (ad_status='1' or (ad_status='2' and ad_startdate <= '2018-01-19' and ad_enddate >= '2018-01-19') ) and (ad_show_type='0' or (ad_show_type='1' and find_in_set('0',ad_show_zone)>0 )) order by rand()
Got error 28 from storage engine