active record query help

[eluser]umefarooq[/eluser]
i really prefer to create a query not to use Active Records, just create query in controller and pass that query to your model

$this->db->query($query);

if you have query you can know where im doing wrong