Nette\Database\Context::fetchPairs PHP Method

    public function fetchPairs($sql, ...$params)
    {
        return $this->connection->query($sql, ...$params)->fetchPairs();
    }

 public function get($id)
 {
     $clanek = $this->database->fetch("SELECT c.*, cr.perex, cr.text,cr.datum as aktualizovano, k.nazev as kategorie,cr.id as crid,\n                                                      ko.komentaru, u.alt, u.title\n                                        FROM clanky c\n                                        JOIN (select * from clanky_revize where id in (SELECT max(id) from clanky_revize group by clanek_id )) cr ON (c.id=cr.clanek_id)\n                                        JOIN kategorie k ON (c.kategorie_id = k.id)\n                                        LEFT JOIN (select clanek_id,count(*) as komentaru from komentare group by clanek_id) ko ON (ko.clanek_id=c.id)\n                                        LEFT JOIN upload u ON (c.obrazek_id = u.id)\n                                        WHERE c.id=? and c.smazano=0 ORDER BY cr.id DESC LIMIT 1;", $id);
     $stitky = $this->database->fetchPairs("SELECT stitek FROM stitky WHERE clanek_id=?;", $id);
     if (!empty($clanek)) {
         $clanek->stitky = array_unique($stitky);
     }
     return $clanek;
 }