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 (1290, 3894, 394, 2904, 2932, 1609, 2115, 2847, 2371, 3928, 1715, 27, 2635, 3925, 2633, 949, 1, 74, 2916, 2174, 2950, 2406, 2023, 2037, 1789, 23, 3926, 1283, 2876, 2923, 2849, 1588, 13, 2643, 38, 3912, 2348) AND np.operatorProdukId=160 ORDER BY np.operatorProdukId ASC, np.nomorPerdanaHarga asc, np.nomorPerdanaId ASC