这个SQL语句使用M语法应该怎么写啊
知道告诉我下我QQ29295842
//分页
import('ORG.Util.Page'); //引入
$count=M('open_ip')->count(); //获取总共条数
$page=new Page($count,10); //实例化 每页多少条
$limit=$page->firstRow.','.$page->listRows; //读取从第几条到第几条

$wish =M('open_ip')->order('time DESC')->limit($limit)->select();
$this->wish = $wish;
$this->page = $page->show(); //页码



select url1, count(url1) from tk_open_ip group by url1 having count(url1) >= 1 order by count(url1) desc

怎么执行这个语句啊
在TP下