TIPS: MySQL Query Error
SQL:SELECT c.area_id,c.pinpai_id, c.pinpai_name,c.pinpai_ename,c.pinpai_zmc,c.pinpai_year,c.pinpai_pic,c.pinpai_jianjie,c.pinpai_tmall,c.pinpai_sellerID,c.pinpai_jd,c.pinpai_jdzy,a.paihang_id,a.paihang_order,a.cate_id FROM brand_pinpai_paihang a LEFT JOIN brand_pinpai c ON a.pinpai_id=c.pinpai_id where a.cate_id=29974 and c.pinpai_status=3 ORDER BY a.paihang_order ASC LIMIT 0, 100
Error:Sort aborted: Query execution was interrupted
Errno:1028