Optimize SQL Queries

We have fallen into the ease of if statements in python list comprehension. This is negatively affecting our query efficiency. We need to move to more complex queries (using table joins, etc.) instead of falling into the `[a for a in query_a if query_b]` alternative.

Making a query for every result in the first query isn't necessary and these operations can be made far more efficient.

首先定位涉及 query_a 和 query_b 的 Python 串列推導式模式，然後檢查相關 SQL 查詢是如何建立和執行的。當每個結果各自查詢的模式被替換為使用 JOIN 的查詢或以其他方式整合的查詢，並且查詢效率得到明確改善時，工作即完成。

由索引模型根據 Issue 內容生成。