this query has almost half the rows 3296, whereas the larger query that you wrote had the correct amount of rows: 6810