Output raw SQL query from Magento collection

$collection = Mage::getResourceModel('rp/organisation_collection')
                ->searchByPostcodeLastname($postcode, Slastname)
                ->addFieldToSelect(array('organisation_id'))
                ->setPageSize(1);
               
               
Mage::log($collection->getSelect()->__toString(),true,'sqlquery.log')

Comments

Post a Comment

Popular Posts

Magmi Single and Multiple Category Importer

Magmi On the fly Category Creator Magmi can create or update categories while it is importing products This document refers to On the fly category creator Version 0.2.3 Categories column To assign your products to categories, include a column called "categories" in your CSV file. If a category branch does not exist, it will be created on the fly during the import process and your products will be assigned to it sku,name,categories "100","My Products/Sample Products/Sample Category" "101","My Products/Other Products" 1 2 3 sku , name , categories " 100 " , " My Products / Sample Products / Sample Category " " 101 " , " My Products / Other Products " Each branch level of the category tree is separated with a forward slash (/). In the example shown above, the two products will be put into their own categories and the following tree ...
Read more