Can i get products by attribute?

[PsMax]

Any Way to get products in category by attributes??
let say i have color and size and i want to get all products with color= red and size=big ??

[rocky]

I'm not aware of any core function to get products in a category by attributes. I think you'd have to write your own query, although the "Layered Navigation block" allows you to filter categories by attribute. It creates it's own tables such as "layered_indexable_attribute_group" though. Maybe some code in that module will help you?

[NemoPS]

I think rocky is correct when mentioning layered navigation. If you click on those attributes in the layered nav, then you can copy/paste the url when you want.