|
|
Categories & Brands
|
Top Selling Products for Removable Storage
|
External Drives
|
Internal Drives
|
|
|
|
|
[ No Brands Found ]
SELECT DISTINCT p.brand FROM Categories AS C1 RIGHT OUTER JOIN MultiCat AS m ON C1.catId = m.CatID RIGHT OUTER JOIN Products AS p ON m.ProdID = p.prodid LEFT OUTER JOIN Categories AS c ON p.catid = c.catId WHERE (c.ParentId = 'REMOVABLE_STORAGE') AND (p.active = 1) AND (p.AccessoryOnly <> 1) OR (p.active = 1) AND (p.AccessoryOnly <> 1) AND (C1.ParentId = 'REMOVABLE_STORAGE') ORDER BY p.brand
|
|
|
|