YOU SHOULD ADD DEBUG VIEWS TO YOUR DB

Summary from the TLDR Web Dev newsletter

Creating debug views in your database can simplify complex queries and improve debugging efficiency. These views predefine joins and include relevant information, making it easier to find specific data based on various criteria. By making these views, it removes the need to repeatedly write lengthy queries.