SELECT SQL_CALC_FOUND_ROWS g.ID AS ID, g.oID oId, g.mID mId, g.CisloZapisu AS CisloZapisu, g.DatNarozeni AS DatNar, g.UmrtiKomentar AS UmrtiKomentar, CASE WHEN g.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(g.DatUmrti,"%d.%m.%Y") END AS DatUmrti, g.Jmeno AS Jmeno, g.Plemeno, g.Barva, g.Pohlavi, g.DatNarozeni AS oDN, CASE WHEN g.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(g.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni, g.Chovnost, IFNULL(matka.Jmeno,"-") AS Matka, IFNULL(otec.Jmeno,"-") AS Otec FROM pes AS g LEFT JOIN pes AS otec ON g.oID=otec.ID LEFT JOIN pes AS matka ON g.mID=matka.ID LEFT JOIN zdravi AS dkk ON ( g.ID=dkk.pID && dkk.Typ=1 ) LEFT JOIN zdravi AS dlk ON ( g.ID=dlk.pID && dlk.Typ=2 ) GROUP BY ID ORDER BY dlk.Vysledek LIMIT 150,30

Error writing file '/usr/local/mysql/tmp/MYMY2qir' (Errcode: 28)