小弟是菜鸟,求高手帮忙看看怎么优化?试了几次,只有这样数据才正确SELECT P.ID,P.CODE FROM PRODUCT P INNER JOIN (select PRODUCT_ID from
(select * from (select * from LABEL_REL order by click desc) t group by t.product_id order by t.click desc) v
WHERE v.PRODUCT_LABEL_ID IN (23,14,19,16,20,13,18,17,15,90,29,39) order by v.click desc limit 12) A ON P.ID=A.PRODUCT_ID
(select * from (select * from LABEL_REL order by click desc) t group by t.product_id order by t.click desc) v
WHERE v.PRODUCT_LABEL_ID IN (23,14,19,16,20,13,18,17,15,90,29,39) order by v.click desc limit 12) A ON P.ID=A.PRODUCT_ID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货