Avoiding making joins on ClickHouse prefiltering data(blog.tinybird.co)

https://blog.tinybird.co/2021/04/23/tips-6-faster-joins-without-joining-using-where/