Web Specials
The following items are first-quality garments with fabrics, colors or sizes that are no longer in production or have been phased out of future production.
SELECT p.* FROM dev1.ds_products as p, ds_product_categories as c, ds_product_option_sets as d where (p.invLevel > 0 or (p.invTrack = 'O' and d.inventory > 0)) and p.pID = d.productId and p.pID = c.pID and c.catID !=0 and p.pAvail = 'Y' and p.pID in (0,28,29,138,284,285,286,287,356,357,541,542,571,572,573,574,575,576,577,578,579) group by p.pID order by case c.sortOrder when 0 then 100 else c.sortOrder end
View More
