qy: SELECT ShopCategory.URL as CategoryURL, ShopProduct.ID, ShopProduct.Name, ShopProduct.URL, ShopProduct.DisplayOrder, ShopProduct.Image1, ShopProduct.Sale, ShopProduct.Demo, ShopProduct.Price, ShopProduct.PriceSale FROM ShopProduct,ShopCategory WHERE ShopProduct.Demo=1 AND ShopProduct.Active=1 AND ShopProduct.Category = ShopCategory.ID ORDER BY Price ASCqy: SELECT ShopCategory.URL as CategoryURL, ShopProduct.ID, ShopProduct.Name, ShopProduct.URL, ShopProduct.DisplayOrder, ShopProduct.Image1, ShopProduct.Sale, ShopProduct.Demo, ShopProduct.Price, ShopProduct.PriceSale FROM ShopProduct,ShopCategory WHERE ShopProduct.Demo=1 AND ShopProduct.Active=1 AND ShopProduct.Category = ShopCategory.ID ORDER BY Price ASC LIMIT 0,15qy: SELECT Name, URL FROM Brand WHERE Active=1 ORDER BY Name ASCqy: SELECT Name, URL FROM Model WHERE Active=1 ORDER BY Name ASCqy: SELECT Name, URL FROM ShopCategory WHERE SearchLink=1 AND Active=1 ORDER BY DisplayOrderShopMenu ASC, Name from MB Bikes
