select distinct(a.name) from mb_product AS a LEFT JOIN  mb_model_name AS b ON a.name=b.name where 1  and a.member_id =5312 and a.catid =100001 and a.status =1 and a.is_shelves =1 order by (case when b.sort>0 then 3 when b.sort=0 then 2 else 1 end) desc,b.sort asc,b.id ascQuery execution was interrupted