/**
       * Content::getApparecchi()
       *
       * @return
       */
      public function getApparecchi()
      {
          $sort = sanitize(get('sort'));
          $access = '';
          $order = '';
          if (Registry::get("Users")->userlevel == 5) {
              $extra = ($sort) ? "AND" : "WHERE";
              $access = "$extra pp.staff_id='" . Registry::get("Users")->uid . "'";
              $counter = countEntries("permissions", "staff_id", Registry::get("Users")->uid);
          } else {
              $counter = countEntries("apparecchi");
          }

          $pager = Paginator::instance();
          $pager->items_total = $counter;
          $pager->default_ipp = Registry::get("Core")->perpage;
          $pager->paginate();

          ($sort) ? $order = "WHERE app.client_id = '" . (int)$sort . "'" : null;

		 $sql = "SELECT app.id as appid, u.id as uid, app.tipo_apparecchio as apptipo, app.modello, app.seriale,"
		  . "\n CONCAT(u.fname,' ',u.lname) as clientname,"
		  . "\n FROM apparecchi as app"
		  . "\n LEFT JOIN users as u ON u.id = app.client_id"
		  . "\n LEFT JOIN tipo_apparecchio as tipoapp ON tipo_apparecchio.id = app.tipo_apparecchio" . $pager->limit;

          $row = self::$db->fetch_all($sql);

          return ($row) ? $row : 0;
      }