热销产品
select a.id,a.name as pname,a.price,a.market_price,a.subhead,a.freight_type,a.index_prodesc,a.discount,a.pur_num,a.spikestime,a.spikeetime,a.is_discount,a.sales,a.member_id as userid,a.pic,b.user,b.company FROM mallbuilder_product a left join mallbuilder_shop b on a.member_id=b.userid WHERE b.shop_statu=1 and is_shelves=1 and a.is_tg='false' and a.status>0 and LOCATE(101517,a.catid)=1 order by sales DESC ,id desc limit 0,6Got error 28 from storage engine