SELECT
  company.id
  -- Some other columns ...
FROM company
  LEFT OUTER JOIN payment_details ON company.id = payment_details.company_id
WHERE
        company.name LIKE '%email@email.com%' OR
        company.slug LIKE '%email@email.com%' OR
        company.email LIKE '%email@email.com%' OR
        company.id IN (SELECT u.company_id FROM user u WHERE (u.deleted = 0 AND u.email LIKE '%email@email.com%'))
        -- Some other restrictions
ORDER BY company.name ASC
LIMIT 100;