Partial summary.

Always try to find a query which causes problematic behavior.
Analyze what behaves wrong and solve the problem using results of this analysis.
Use noted methods for analysing results.