Sql

Query.php

public function getCustomers()
    {
        $customers = $this->_db->query('select c.*, ctrl.seen, ctrl.date as edited from customers c, control ctrl where c.id = ctrl.customer_id and ctrl.user_id = ' . Session::get('id_user') . ' order by ctrl.date desc, c.date desc');

        return $customers->fetchAll(PDO::FETCH_ASSOC);
    }