SELECT np.nomorPerdanaId , np.memberId , np.operatorProdukId , np.nomorPerdanaAsli , np.nomorPerdanaNomor , np.nomorPerdanaHarga FROM nomor_perdana np WHERE np.nomorSoldDate IS NULL AND np.memberId=1588 AND np.operatorProdukId=580 ORDER BY np.operatorProdukId ASC, np.nomorPerdanaHarga desc, np.nomorPerdanaId ASC