SELECT * FROM product_range INNER JOIN product_range_type ON product_range_type.product_range_id = product_range.product_range_id INNER JOIN product_type ON product_type.product_type_id = product_range_type.product_type_id WHERE product_range.product_range_id NOT IN ('11') AND product_type.product_type_id LIKE '172096' ORDER BY product_range_name ASC