SEARCH
Your selection did not match any results.
select p.ProductID, p.Productname, p.Available, (select top 1 TypeName from mss_index i inner join mss_types t on i.typeid=t.typeid where t.[sign]='MANUS' and i.ProductID=p.ProductID) Manu, (select top 1 TypeName from mss_index i inner join mss_types t on i.typeid=t.typeid where t.[sign]='DESIGNERS' and i.ProductID=p.ProductID) Designer, (select top 1 ImagePath from msS_Images where ProductID=p.ProductID order by PicOrder,ImageID) as ImagePath, Price, SalePrice from mss_Products p where (Available<4 or Available=5) and (ProductName like '%toogood%' or ProductDescription like '%toogood%' or exists(select top 1 1 from mss_Index i inner join mss_Types t on i.TypeID=t.TypeID where i.ProductId = p.ProductId and t.Typename like '%toogood%')) order by ProductRank
Back