Simple querying
Since Magento uses an EAV (Entity Attribute Value) data model, raw SQL queries are (for most practical purposes) out the window. Therefore, this is a typical method of grabbing the collection of objects you are searching for: $products = ...

