mysql - DISTINCT clause in main query and subquery -

below query :

select distinct(di.device_token) device_info di di.imei_number in (select distinct(ud.device_id) user_details ud ud.device_os='android') 

this query takes hell lot of time execute because of in clause. found using joins best way. yet, unable figure how use distinct on both tables.

any suggestion welcome.

try below query -

select distinct (di.device_token) device_info di,user_details di.imei_number in (user_details.ud.device_id) , ud.device_os='android';