merhabal..db select te bir subquery yazdım bunu sayfalandırmak istiyorum ama işe yaramadı
$query=DB::select("SELECT ip,
(SELECT COUNT(DISTINCT (userid)) FROM ".$this->table("logs")." as slogs
WHERE slogs.userip=logs.userip) as ipCount,
(SELECT GROUP_CONCAT(DISTINCT(flogs.userid) ORDER BY flogs.userid SEPARATOR ',')
FROM ".$this->table("logs")." as flogs
WHERE flogs.userip=logs.userip) as ids_used
FROM ".$this->table("logs")." as logs
GROUP BY logs.userip HAVING ipCount>1");
return $query;
nasıl yapabilirim bunu paginate...