SELECT (SELECT TOP (100) PERCENT SUM(AmazonOrdersCompleted_1.quantitypurchased) AS ItemTotal FROM AmazonOrdersCompleted AS AmazonOrdersCompleted_1 INNER JOIN Products ON AmazonOrdersCompleted_1.sku = Products.SKU INNER JOIN VendorArtwork ON Products.ArtworkID = VendorArtwork.ID WHERE (VendorArtwork.DisplayName = VendorArtwork_1.DisplayName) AND (AmazonOrdersCompleted_1.purchasedate > GETDATE() - 180) ORDER BY ItemTotal DESC) AS TotalArtSold, (SELECT SUM(quantitypurchased) AS TotalPurchased FROM AmazonOrdersCompleted WHERE (sku = Products_1.SKU) AND (AmazonOrdersCompleted.purchasedate > GETDATE() - 180) GROUP BY sku) AS TotalPurchased, Products_1.ID as ProductID, Products_1.ProductTitleShort, VendorArtwork_1.DisplayName AS ArtworkDisplayName FROM Products AS Products_1 INNER JOIN VendorArtwork AS VendorArtwork_1 ON Products_1.ArtworkID = VendorArtwork_1.ID WHERE (Products_1.Active = 1) AND (Products_1.ProductCategoryID IN (180))ORDER BY TotalPurchased DESC, TotalArtSold DESC XBOX One Elite Wireless Controller Skins - Skins and Decals for the Xbox One Elite Controller
