这条SQL语句在thinkphp怎么写?

浏览:408 发布日期:2017/12/11 分类:求助交流 关键字: sql
SELECT * FROM goods t1,
(SELECT guanlian_id,COUNT(guanlian_id) as zhichishu from goods group by guanlian_id) t2
where t1.shenfen = 1 AND t2.guanlian_id = t1.id
order by rand() limit 2;
最佳答案
评论( 相关
后面还有条评论,点击查看>>