Why does my query return inconsistent amount of rows?
Looks like I had a divide by zero error. My database tool was not reporting the error. I was able to reproduce on fiddle. http://www.sqlfiddle.com/#!18/e2ff2/1

Update: 

The bug is now fixed. 
https://valentina-db.com/bt/view.php?id=8516