Nepřihlášen
•
Přihlásit se
•
Registrovat se
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 g.Jmeno LIMIT 55020,30
Error writing file '/usr/local/mysql/tmp/MYMaCeyL' (Errcode: 28)