SELECT deal.ID, act.ID as act_id, act_stat.OWNER_ID as act_stat_id, act_stat.DEADLINE_DATE as act_stat_date
FROM b24hokv.b_crm_deal deal
  LEFT JOIN b24hokv.b_crm_act act on deal.ID = act.OWNER_ID and act.OWNER_TYPE_ID = 2 and act.TYPE_ID in(1,2,102)
  LEFT JOIN b24hokv.b_crm_act_stat act_stat on act.ID = act_stat.OWNER_ID and act_stat.COMPLETED = 'N' and act_stat.DEADLINE_DATE = '2019-11-25'
WHERE deal.STAGE_SEMANTIC_ID = 'P' and deal.CATEGORY_ID = 0
ORDER by deal.ID desc
LIMIT 100