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-1-910158-94-4 hbk; 978-1-910158-95-1 pbk; 978-1-910158-96-8 eBook' AND p.priceINR != 0 AND p.wip NOT LIKE 'y' AND p.deprecated LIKE 'n' ORDER BY p.skuLook, p.sortOrder