https://www.geekyhacker.com/emulating-intersection-in-mysql-with-self-join/