SELECT np.nomorPerdanaId , np.memberId , np.operatorProdukId , np.nomorPerdanaAsli , np.nomorPerdanaNomor , np.nomorPerdanaHarga FROM nomor_perdana np FORCE INDEX(searchNomorByOperatorOnly) WHERE np.nomorSoldDate IS NULL AND np.memberId IN (3894, 394, 2904, 2932, 1609, 2115, 2847, 2371, 3928, 1715, 27, 2635, 3925, 2633, 949, 1, 74, 1290, 2916, 2174, 2950, 2406, 2023, 2037, 1789, 23, 3926, 1283, 2876, 2923, 2849, 1588, 13, 2643, 38, 3912, 2348) AND np.operatorProdukId=585 ORDER BY np.operatorProdukId ASC, np.nomorPerdanaHarga asc, np.nomorPerdanaId ASC