It looks like adding committedqtyperlocation in the select makes 3 of the rows dissapear.