Retrieving Left Table Rows from Right Table Conditions: A Deep Dive Into Alternative Approaches and Best Practices for Efficient Querying.