def METHOD_NAME(self):
    return self.session.query(Link, Url.url).join(
        Url, Link.url_to == Url.url).filter(
            Link.site_id == self.context.getId(),
            ~Url.status_code.in_([-1, 200, 999, 429, 524])
    )