Velosport(495) 223-43-28, (495) 223-44-28,
Профессиональный велосипедный магазин

открыть  Колеса и запчасти
  Как купить
  Лаборатория NEW!!!

************ ошибка ***********

SQL ERROR..... N1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY Brand.Name' at line 1

SELECT Product.IsActive, Product.BrandId, Product.ProductId, Brand.Name AS BrandName FROM Brand LEFT JOIN Product ON Brand.BrandId = Product.BrandId LEFT JOIN Category ON Product.CategoryId = Category.CategoryId WHERE Product.IsActive=1 AND Brand.IsActive=1 AND Product.CategoryId =  ORDER BY Brand.Name