I've tried grouping by ID from the product table, and also using ProdIDType from the foreign key table - each give similar results whether LubeID is added or not.
I've attached a pdf file that shows the table (which has been changed to force feed results), one of the the SQL statements, and the search results page.