Есть такой запрос:

Select parent.*,

( Select count(*)  from (  Select e.email, e.task_id
     from  event e
     where  e.company_id = parent.company_id
       AND e.event_type_id in (10, 11, 12)
       AND e.email in ( 'email1', 'email2' )
       AND e.task_id in ( 5,10,15 ) 
    GROUP by e.email, e.subject_id ) as pairs  ) as done


from parent_table parent

ошибка

#1054 — Unknown column 'parent.company_id' in 'where clause'

такое как нибудь обходится?