SELECT Products.ID, Products.Company, Products.GroupID, Groups.Path, Groups.PathNameF,   Products.UpdateDate, Products.NameF, Products.IntroF, Products.FullIntroF, Products.Status,   ProductStatus.StatusNameF, Products.Unit, ProductUnits.UnitNameF, Products.MinOrder,   Products.Advertise, Products.VisitCount, Products.KeyWords, Products.Model, Products.ProductOrginF,   Products.BrandF, Products.SaleTermsF, Products.PaymentF, Products.SupplyAbility,   Products.DeliveryLeadTime, Products.Certifications, Products.SmallPic, Products.MedPic,   Products.BigPic, Products.Personel, CompanyPersonels.TitleF, CompanyPersonels.NameF AS CompanyPersonelsNameF, CompanyPersonels.Logo, CompanyPersonels.FileUrl as PersonelFileUrl, CompanyOffices.ID AS OfficeID, CompanyOffices.TitleF AS CompanyOfficesTitleF, CompanyOffices.FileUrl as OfficeFileUrl , Products.Size, Products.Weight,   Products.Catalog, Products.MoreInfo, Products.Movie, Products.BrandID, ProductBrands.Approved,   ProductBrands.Logo AS ProductBrandsLogo, ProductBrands.BrandTitleF, ProductBrands.BrandTitleE, Products.pro   FROM ProductStatus INNER JOIN Products ON ProductStatus.ID = Products.Status LEFT OUTER JOIN  CompanyOffices INNER JOIN CompanyPersonels ON CompanyOffices.ID = CompanyPersonels.Office ON  Products.Personel = CompanyPersonels.ID LEFT OUTER JOIN ProductUnits ON Products.Unit = ProductUnits.ID LEFT OUTER JOIN Groups ON Products.GroupID = Groups.ID LEFT OUTER JOIN ProductBrands ON Products.BrandID = ProductBrands.ID  WHERE Products.ID=29156 AND Products.Company=8088