[solved]MYSQL ERROR 1096 - NO TABLES USED - CODEIGNITER

[eluser]brucebat[/eluser]
Hi all,

Here is my Query which works fine in PHPMyAdmin and SQLYOG

Code:

SELECT intervention.department_id, department_name, COUNT(*)
FROM intervention
LEFT JOIN department ON department.department_id = intervention.department_id

GROUP BY intervention.department_id, department.department_name
ORDER BY COUNT(*) DESC
LIMIT 1

The Query + Code:

Code:

$this->db->query("
            
                                SELECT intervention.department_id, department_name, COUNT(*)
                                FROM intervention
                                LEFT JOIN department ON department.department_id = intervention.department_id
                                GROUP BY intervention.department_id, department.department_name
                                ORDER BY COUNT(*) desc
                                LIMIT 1
                            ");

            
            $result =$this->db->get();

The error message I am getting:

A Database Error Occurred

Error Number: 1096

No tables used

SELECT *

Filename: C:\xampp\htdocs\midas\system\database\DB_driver.php

Line Number: 330