' ELSE '' END AS newImage, ISNULL(salesRank, 30000) AS salesRank, ISNULL(minPrice, 0) AS minPrice, ISNULL(maxPrice, 0) AS maxPrice, ISNULL(finishCount, 0) AS finishCount, ISNULL(sizeCount, 0) AS sizeCount, pg.madeInUSA, pg.energyStar, ISNULL(listingArray, '') AS listingArray, ISNULL(applicationArray, '') AS applicationArray, CASE WHEN ISNULL(checkStock, 0) > 0 AND (ISNULL(mfr_stock_qty, 0) > 0 or mfr_stock_qty=-1 ) THEN 1 ELSE 0 END AS checkStock, ISNULL(MSRP, 0) AS MSRP, ISNULL(hasProdSet, 0) AS hasProdSet, ISNULL(hasCompare, 0) AS hasCompare FROM (SELECT group_id, retail_price as retail, trade_price as trade, img as img, skuFilt.sku, ss.mfr_id, ss.getDimensions, ss.checkStock, ss.mfr_stock_qty, ss.msrp, ss.hasCompare FROM (SELECT sku FROM [CatalogFilter]..[filter249] with (NoLock) WHERE ISNULL(defaultSku, 0) = 1 UNION SELECT MIN(sku) AS sku FROM [CatalogFilter]..[filter249] WHERE groupId NOT IN (SELECT groupId FROM [CatalogFilter]..[filter249] with (NoLock) WHERE ISNULL(defaultSku, 0) = 1) GROUP BY groupId) AS skuFilt LEFT OUTER JOIN contentOptimized..skusummary ss with (NoLock) ON ss.sku = skuFilt.sku WHERE group_id IS NOT NULL) AS filt INNER JOIN contentOptimized..prodGroupSummary pg with (noLock) ON pg.group_id = filt.group_id LEFT OUTER JOIN content..manufacturers m with (NoLock) ON m.mfr_id = filt.mfr_id WHERE pg.obsolete = 'no' AND m.search_display = 0 ORDER BY ISNULL(pg.placement, 100000) -- Main Get Products QueryIF OBJECT_ID('[CatalogFilter]..[filter249]','U') IS NOT NULL SELECT ISNULL(pg.skuCount, 1) AS skuCount, styleId, styleId1, styleId2, styleId3, styleId4, ISNULL(style_name, '') AS style_name, typeId as type_id, pg.Group_ID, cast(isnull(pg.mfr_id,0) as varchar(8)) +'/' + ISNULL(filt.img, pg.img) as image, pg.group_name, ISNULL(filt.retail, 10000) AS retail_price, content.dbo.getRange(filt.retail) AS range, content.dbo.getRangeValue(filt.retail) AS rangeValue, isnull(pg.placement,6000) as placement, ISNULL(m.mfr_name, 'Multiple Brands') AS mfr_name, pg.mfr_id, CASE WHEN ISNULL(m.hide_price, 0) = 1 THEN 1 ELSE CASE WHEN ISNULL(pg.mustCallToPurchase, 0) = 1 THEN 1 ELSE 0 END END AS hide_price, ISNULL(pg.uom, '') AS uom, ISNULL(pg.minunitPerSku, '') AS unitPerSku, filt.sku, ISNULL(pg.avgReview, 'star0_0.gif') AS avgReview, ISNULL(reviewCount, 0) AS reviewCount, CASE WHEN pg.proofDate > getDate() - 90 THEN '
Cart
Product Home > Track Fixtures
Track Fixtures
| More reasons to Shop ATG Stores | |
 |
• Safe & Secure Shopping All personal information is transmitted via encrypted methods and is stored on secure servers. |
 |
• Price Shopper Technology We're so confident about our prices, we shop the web for you. |
 |
• Successful Track Record WIth over 2.4 million items shipped to almost 500,000 customers, we're one of the countries largest online retailers. |
- Tools
- More Stores
- Customer Care
- Helpful Links
-
What Others Say
-
- Industry Affiliates
- Payment Options
Your Customer Code: 1001
©1999-2008 Allied Trade Group, Inc. All rights reserved.
Copyright notice| By using this site you agree to our Terms and Conditions of Use and Privacy Statement
Site Map Lighting Light Fixtures Ceiling Lights Chandeliers Wall Sconces Large Pendants Bowl Pendants Mini Pendants Foyer Lighting
Bedroom Lighting Kitchen Lighting Family Room Lighting Table Lamps Floor Lamps Desk Lamps Energy Efficient Lighting Exterior Lighting
Local - Art - Rugs - Floors- Fixtures - Static - Searches - Hardware - Store