The reason you are getting the three products on the page for the different options is because there is a product inserted for each of the different options into the products table. If you take the original SQL query from the product_Results page and add an additional condition that ProductCategoryID = 9 this should get the correct values.