Magento Print Query of Collection

We can print query of collection using “getSelect()->__toString()”

$products = Mage::getModel(‘catalog/product’)
->getCollection()->addStoreFilter(1)
->addAttributeToFilter(‘status’, array(‘eq’ => 1))
->addAttributeToFilter(‘status’, array(‘eq’ => 1))
->addAttributeToSelect(‘name’)
->addFieldToFilter(‘attribute_set_id’, 10);
echo $products->getSelect()->__toString();

About these ads