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