Product collection magento

Get product list of any categories with "not visible individually" filter

Limit product listing to 3 only


$products = Mage::getResourceModel('catalog/product_collection')->addCategoryFilter($_subcategory)->addAttributeToFilter('visibility', 4)->addAttributeToSelect('*');

$products->getSelect()->order(new Zend_Db_Expr('RAND()'))->limit(3);
$products->load();