select
        a1_0.id,
        a1_0.action_details,
        a1_0.lead_id,
        a1_0.location 
    from
        actions a1_0 
    left join
        location l1_0 
            on l1_0.id=a1_0.location 
    left join
        leads l2_0 
            on l2_0.id=a1_0.lead_id 
    where
        l1_0.Active 
        or l2_0.Active