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')