how can i run this query in code igniter

[eluser]CroNiX[/eluser]

Code:

$this->db
  ->select('roleID, permID')
  ->select('count(*) as NumDuplicates', FALSE)
  ->group_by(array('roleID', 'permID'))
  ->having('NumDuplicates > 1')
  ->get('role_perms')
  ->result();

Code:

//Produces
SELECT roleID, permID, count(*) as NumDuplicates
FROM (role_perms)
GROUP BY roleID, permID
HAVING NumDuplicates > 1

Haven't tried it as I don't have your tables, but probably something like that