Query products from attributes id

[Madsex]

hi,

i need a query that find and filter product from an array of attributes.

 

For example: i have id_attribute 1 and 13 ( from prestashop base installation are orange and size S ). in my db there are 2 items with size S and one with color Orange. Then one of size S is orange.

 

So i would a query that from id attributes returns the orange product id, as a filter.

 

Is it possible to obtain this particular query? I have difficult to understand the tables.

 

Someone can help me? Thanks

[musicmaster]

Please study the tables ps_product_attribute and ps_product_attribute_combination

 

id_product_attribute is a combination of an id_product and one or more id_attributes (for example size S and color yellow).