Nepřihlášen
•
Přihlásit se
•
Registrovat se
SELECT *, CONCAT_WS(" ",TitulyPrefix, Jmeno, Prijmeni, TitulySuffix) AS clovek FROM uzivatel WHERE ID=11917kchbo.com/genealogie/index.php?action=ulist LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?action=ulist LIMIT 1' at line 1
Seznam psů pro
SELECT pes.ID AS ID, pes.Jmeno AS Jmeno, pes.oID AS oID, pes.mID AS mID,
plemeno.Nazev as Varieta,
pohlavi.Nazev as Pohlavi,
barva.Nazev as Barva,
pes.TitulyPredJmenem AS TitulyPredJmenem,
pes.plemeno AS Plemeno,
pes.UmrtiKomentar AS UmrtiKomentar,
CASE WHEN pes.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatUmrti,"%d.%m.%Y") END AS DatUmrti,
CASE WHEN pes.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni,
CONCAT(LEFT(pes.Jmeno,1),pes.Pohlavi) AS Trideni
FROM chovatel LEFT JOIN pes ON pes.ID=chovatel.pID
LEFT JOIN ciselnik AS pohlavi ON (pes.Pohlavi=pohlavi.Hodnota && pohlavi.Nazev!="!Typ!" && pohlavi.Typ="pohlavi")
LEFT JOIN ciselnik AS plemeno ON (pes.Plemeno=plemeno.Hodnota && plemeno.Nazev!="!Typ!" && plemeno.Typ="plemeno")
LEFT JOIN ciselnik AS barva ON (pes.Barva=barva.Hodnota && barva.Nazev!="!Typ!" && barva.Typ="barvy")
WHERE chovatel.uID=11917kchbo.com/genealogie/index.php?action=ulist ORDER BY pes.Jmeno
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?action=ulist ORDER BY pes.Jmeno' at line 16
SELECT pes.ID AS ID, pes.Jmeno AS Jmeno, pes.oID AS oID, pes.mID AS mID,
plemeno.Nazev as Varieta,
pohlavi.Nazev as Pohlavi,
barva.Nazev as Barva,
pes.TitulyPredJmenem AS TitulyPredJmenem,
pes.plemeno AS Plemeno,
pes.UmrtiKomentar AS UmrtiKomentar,
CASE WHEN pes.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatUmrti,"%d.%m.%Y") END AS DatUmrti,
CASE WHEN pes.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni,
CONCAT(LEFT(pes.Jmeno,1),pes.Pohlavi) AS Trideni
FROM majitel LEFT JOIN pes ON pes.ID=majitel.pID
LEFT JOIN ciselnik AS pohlavi ON (pes.Pohlavi=pohlavi.Hodnota && pohlavi.Nazev!="!Typ!" && pohlavi.Typ="pohlavi")
LEFT JOIN ciselnik AS plemeno ON (pes.Plemeno=plemeno.Hodnota && plemeno.Nazev!="!Typ!" && plemeno.Typ="plemeno")
LEFT JOIN ciselnik AS barva ON (pes.Barva=barva.Hodnota && barva.Nazev!="!Typ!" && barva.Typ="barvy")
WHERE majitel.uID=11917kchbo.com/genealogie/index.php?action=ulist && majitel.Soucasny=1 ORDER BY pes.Jmeno
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?action=ulist && majitel.Soucasny=1 ORDER BY pes.Jmeno' at line 16
SELECT pes.ID AS ID, pes.Jmeno AS Jmeno, pes.oID AS oID, pes.mID AS mID,
plemeno.Nazev as Varieta,
pohlavi.Nazev as Pohlavi,
barva.Nazev as Barva,
pes.TitulyPredJmenem AS TitulyPredJmenem,
pes.plemeno AS Plemeno,
pes.UmrtiKomentar AS UmrtiKomentar,
CASE WHEN pes.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatUmrti,"%d.%m.%Y") END AS DatUmrti,
CASE WHEN pes.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni,
CONCAT(LEFT(pes.Jmeno,1),pes.Pohlavi) AS Trideni
FROM majitel LEFT JOIN pes ON pes.ID=majitel.pID
LEFT JOIN ciselnik AS pohlavi ON (pes.Pohlavi=pohlavi.Hodnota && pohlavi.Nazev!="!Typ!" && pohlavi.Typ="pohlavi")
LEFT JOIN ciselnik AS plemeno ON (pes.Plemeno=plemeno.Hodnota && plemeno.Nazev!="!Typ!" && plemeno.Typ="plemeno")
LEFT JOIN ciselnik AS barva ON (pes.Barva=barva.Hodnota && barva.Nazev!="!Typ!" && barva.Typ="barvy")
WHERE majitel.uID=11917kchbo.com/genealogie/index.php?action=ulist && majitel.Soucasny=0 ORDER BY pes.Jmeno
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?action=ulist && majitel.Soucasny=0 ORDER BY pes.Jmeno' at line 16
