全部商品分类
家用电器
>
消息MySQL Query Error
SQLSELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `wwwshop`.`ecs_brand`AS b, `wwwshop`.`ecs_goods` AS g WHERE g.brand_id = b.brand_id AND g.cat_id IN ('5','182','218','217','215','219','216','220','178','185','189','186','183','190','187','184','188','180','201','205','202','199','206','203','200','204','179','198','195','192','196','193','197','194','191','181','214','211','208','212','209','213','210','207') AND is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC
错误Got error 28 from storage engine
代码1030