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 (233))ORDER BY TotalPurchased DESC, TotalArtSold DESC
LG V30 - Skins and Decals for LG V30
  Mature content filter is ON 

Skin Decal Wrap for LG V30 Electrify Purple
More Colors Available!
Skin for LG V30 Electrify Purple

Skin Decal Wrap for LG V30 Electrify Red
More Colors Available!
Skin for LG V30 Electrify Red

Skin Decal Wrap for LG V30 Fire Green
More Colors Available!
Skin for LG V30 Fire Green

Skin Decal Wrap for LG V30 Fire Red
More Colors Available!
Skin for LG V30 Fire Red

Skin Decal Wrap for LG V30 Baseball
More Colors Available!
Skin for LG V30 Baseball

Skin Decal Wrap for LG V30 Basketball
More Colors Available!
Skin for LG V30 Basketball

Skin Decal Wrap for LG V30 Fire Purple
More Colors Available!
Skin for LG V30 Fire Purple

Skin Decal Wrap for LG V30 Camouflage Red
More Colors Available!
Skin for LG V30 Camouflage Red

Skin Decal Wrap for LG V30 Lightning Black
More Colors Available!
Skin for LG V30 Lightning Black

Skin Decal Wrap for LG V30 Lightning Blue
More Colors Available!
Skin for LG V30 Lightning Blue

Skin Decal Wrap for LG V30 HEX Green
More Colors Available!
Skin for LG V30 HEX Green