public static function clientesFrecuentes($date) { $clientes = DB::Select('select c.id,c.cedula,c.nombre,c.apellidos,(select count(*) from reservacion where id_cliente = c.id and fecha_reservacion like \'%' . $date . '%\')as visitas, c.telefono,c.id_empresa, c.ultimavisita from cliente as c where c.visitas != 0 ORDER BY visitas DESC'); return $clientes; }