Query failed:SELECT DISTINCT P.ID as ID,CONCAT(Prenume,' ',Nume) AS Nume,CONCAT(L.Denumire,' ( ',(CASE(ISNULL(J.Denumire)) WHEN 1 THEN T.Denumire ELSE J.Denumire END), ' ) ') AS Localitate FROM Localitate AS L ,Persoana AS P LEFT JOIN Judet AS J ON L.IDJudet = J.ID LEFT OUTER JOIN Persoana2Domeniu AS P2D ON (P2D.IDPersoana = P.ID ) LEFT JOIN Tara AS T ON L.IDTara = T.ID WHERE (L.ID = P.IDLocalitate) AND (P.Prenume LIKE '%') AND (P.Nume LIKE '%') ORDER BY 1 LIMIT 0,10| |
