DECLARE @defaultLanguage NVARCHAR(5)

        SET @defaultLanguage = (SELECT LanguageCode FROM LANGUAGE WHERE IsDefault = 1)

        SELECT
            c.Id,
            c.Name,
            c.OrgNr,
            c.UserId,
            c.Address,
            c.PostalArea,
            c.County,
            c.Country,
            c.Description,
            c.DescriptionFull,
            c.Telephone,
            c.Email,
            c.Website,
            c.IsApproved,
            s.Id
            ISNULL(tr.Name, def.Name) Name

          FROM Company c

          INNER JOIN CompanyService cs on cs.CompanyId = C.Id

          INNER JOIN Service s on s.Id = cs.ServiceId

          LEFT OUTER JOIN ServiceTranslation tr
            ON s.Id = tr.ServiceId AND tr.LanguageCode = @userLanguage
          -- join default language of the service:

          LEFT OUTER JOIN ServiceTranslation def
            ON s.Id = def.ServiceId AND def.LanguageCode = @defaultLanguage

          WHERE c.IsApproved = 1

          AND
          c.Id IN
          (
              SELECT c1.Id FROM Company c1

              INNER JOIN CompanyService cs1 on cs1.CompanyId = c1.Id

              INNER JOIN Service s1 on s1.Id = cs1.ServiceId

              INNER JOIN ServiceTranslation tr1
                ON s1.Id = tr1.ServiceId AND tr1.LanguageCode = @userLanguage
              -- join default language of the service:

              INNER JOIN ServiceTranslation def1
                ON s1.Id = def1.ServiceId AND def1.LanguageCode = @defaultLanguage



               AND s1.IsApproved = 1 AND  ISNULL(tr1.Name, def1.Name) LIKE '%' + @searchQuery + '%'
          )