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.Sale=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.Sale=1 AND ShopProduct.Active=1 AND ShopProduct.Category = ShopCategory.ID ORDER BY Price ASC LIMIT 0,15qy: SELECT Product, AttributeOption FROM ShopProductAttributeOptionRelationships WHERE Product IN (1277,1308,1996,1997,1973,1974,1975,1976,1314,1977,1907)qy: 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
