duplicate job listings

query https://user-images.githubusercontent.com/103982094/211246010-ea3cf036-1973-4a69-b2da-57ecc51737a3.png

please share your solutions or discuss the solutions in the comments.
Kysely feedback and suggestions for enhancement are also welcome.

v0.24.2 solution https://wirekang.github.io/kysely-playground/?p=f&i=-NSNBXDoS_Mam_zlMMNH