Friday, July 13, 2012

How to display mysql query in magento?

$objCategoryProducts = Mage::getModel('catalog/category')->load($intCategoryId)->getProductCollection()->addAttributeToFilter(array(array('attribute' => 'product_status','eq' => '126'),array('attribute' => 'product_stock_status','eq' => '486')))->setPageSize(1);

//echo $objCategoryProducts->printLogQuery(true);die;

No comments:

Post a Comment

Please mention your comments.......