1. Determine a minimum set of records from your dataset that, combined with your query, will show the problem you're describing. 2. `.dump` your DB 3. Pick out the `INSERT`s from [2] that cover the records from [1]. 4. Post these `INSERT` statements. That way, anyone can paste all these commands directly into their own test DBs to verify your issue, and figure out what's going on.