SELECT p.productID,p.description,p.skuLook,p.skuPartID,p.releasedate,p.stock,p.stockML,p.forsale,p.productType,p.priceGBP,p.priceEUR,p.priceUSD,p.vat,p.multiplediscount FROM product p WHERE p.skuLook LIKE '978-1906884-16-1' AND p.priceINR != 0 AND p.wip NOT LIKE 'y' AND p.deprecated LIKE 'n' ORDER BY p.skuLook, p.sortOrder