Thinkphp 超长sql语句编写

最新推荐文章于 2022-08-02 15:24:14 发布

weixin_30701521

最新推荐文章于 2022-08-02 15:24:14 发布

阅读量102

点赞数

原文链接：http://www.cnblogs.com/scjzhong/p/5194699.html

版权

SELECT g.gname,sum(s.sp_number) as total FROM luofang_goods_snapshot AS s right JOIN luofang_goods g on s.sp_gid = g.gid WHERE ( `jid` = '1' ) AND ( gstatus <> -1 AND gtype=0 ) GROUP BY g.gid ORDER BY total desc LIMIT 3

这是一个简单的例子：

对应的tp的代码编写如下

$arr = M('goods_snapshot')->alias('AS s')->join('__GOODS__ g on s.sp_gid = g.gid','right')->field('g.gname,sum(s.sp_number) as total')->where($condition)->where($string)->group('g.gid')->order('total desc')->limit('3')->select();

对已生成的结果集进行排序

初次写可能会生疏写多了就ok啦

我在想你 I miss you qingqing。 Do you know？

转载于:https://www.cnblogs.com/scjzhong/p/5194699.html