SELECT CatItems.*, CatCategories.Name AS CategoryName, CatCategories.Sale AS SaleCat FROM CatItems LEFT JOIN CatCategories ON CatItems.Category = CatCategories.__id WHERE CatItems.__id='295637' AND CatItems.isDomainMarket='0'