how to get product on basis of product category and product attribute

[Deepa Mandal]

Hi Ofbiz,

There is a requirement for fetching list of Product on the basis of
Product_Category_Id(TABLE:Product_Category) and
ATTR_NAME(TABLE:Product_Attribute) and ATTR_VALUE(TABLE:Product_Attribute).

Let's suppose,
The given category is
newarrival, bestseller, mostviewed.

I have to filter the result on the basis of "attr_name":language and
"attr_value":Spanish.

What will be  the best solution to do the same with minimal effort?

Thanks,
Deepa Mandal