select a.* from products a left join products_category b on b.CateId=a.CateId where a.GroupId='products' and a.UnfinishedState='0' and a.AuditState='3' and (b.domain_list IS NULL or b.domain_list='' or b.domain_list like '%,www.kepusz.com,%') order by a.AuditState asc,if(a.MyOrder>0, a.MyOrder, if(a.MyOrder=0, 1000000, 1000001)) asc,a.AccTime desc limit 60, 12<br>连接数据表错误<br>错误代码： 1:Can't create/write to file '/tmp/MYt5bZ99' (Errcode: 28 - No space left on device)