<?

function queryLatestCoupons(){
	return $this->select()
				   ->from("
					   	Coupons C,
					   	Stores S,
					   	CategoryMaps M
				   	")
				   ->where("
				   		 C.Active='1' AND 
				   		 S.Active='1' AND 
				   		 M.Active='1'
				   	")
				   ->groupBy('S.Store')
				   ->orderBy('C.CouponID')
				   ->sortBy('DESC')
				   ->limit(100);
}

$data = Site::load('Coupons')->queryLatestCoupons()->limit(32)->paginate()->fetchAll();