SELECT DISTINCT TOP (1000) PP.BusinessEntityID AS KlijentiID,
REPLACE (RIGHT (PP.rowguid, LEN(PP.rowguid)-23),'-',1) AS JMBG,
PP.FirstName AS Ime, PP.LastName AS Prezime,
PA.AddressLine1 AS Adresa, PPP.PhoneNumber AS Telefon,
PEA.EmailAddress AS Email

FROM Person.Person AS PP
INNER JOIN Sales.Customer AS SC ON PP.BusinessEntityID=SC.CustomerID
INNER JOIN Person.PersonPhone AS PPP ON PP.BusinessEntityID = PPP.BusinessEntityID
INNER JOIN Person.EmailAddress AS PEA ON PP.BusinessEntityID = PEA.BusinessEntityID
INNER JOIN Person.BusinessEntity AS PBE ON PP.BusinessEntityID=PBE.BusinessEntityID
INNER JOIN Person.BusinessEntityAddress AS PBEA ON PBE.BusinessEntityID = PBEA.BusinessEntityID
INNER JOIN Person.Address AS PA ON PBEA.AddressID = PA.AddressID