Custom Queries

[know]

I haven't been able to find any documentation on this, but if there is, feel free to just send me a link to it.

I would like to write a custom query that will do the following:

I want to create a link that will decipher and list products based on it's category and manufacturer status. For example, if I had a category called 'rings' and a manufacturer called 'gold' it will list all products that are in the 'rings' category with 'gold' as it's manufacturer.

Does that make sense?

I'd like to build it in a fashion that I could easily reuse it throughout the site (given that I make obvious changes to various elements of the string).

Any one have anything I could look at? Or any recommended links to check out to figure out how to do this correctly?

Thanks!!!

Ok.....my wheels are still turning....

Let's say that 'gold' has a manufacturer ID of 8 and 'ring' has a category id of 23.

And to view all the contents under the 'gold' section I would use:

oscom/catalog/default.php?manufacturers_id=8

And to view all the contents under the 'ring' section I would use:

oscom/catalog/default.php?cPath=23

Theoretically, shouldn't I be able to use:

oscom/catalog/default.php?cPath=23&manufacturers_id=8

??

Am I crazy? Am I at least on the right path? Any comments on this concept?