MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Question

While I am running this query

SELECT * FROM 
tb_emp_daily_status d 
where 
d.shiftdate>='2017-06-07' and 
shiftdate<='2017-06-13' and 
emp_id in (SELECT id FROM tb_employee e WHERE e.user_id = '18145' LIMIT 20) 
order by d.id asc

How to write this query in mysql

Answer 1

Try this:

  SELECT * FROM 
    tb_emp_daily_status d 
    where 
    d.shiftdate>='2017-06-07' and 
    shiftdate<='2017-06-13' and 
    emp_id in (SELECT * FROM (SELECT id FROM tb_employee e WHERE e.user_id = '18145' LIMIT 20)   
          as t)
    order by d.id asc