Optimize SQL Queries

[mbillow]

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.

[mbillow]

If someone who is looking to contribute to Conditional wants to see an example of what we are talking about, the issue above has several examples of me switching queries to use functions like outerjoin() instead of if statements in list comprehensions.

[mbillow]

#153 is also a good example of this.