magento 执行sql

public function getLastTransIdInfo()
{
//$LastTransId=$this->getInfo()->getLastTransId();
//return $LastTransId;
$read= Mage::getSingleton('core/resource')->getConnection('core_read');  
 
  $value=$read->query("select last_trans_id from sales_flat_order_payment where parent_id =(select entity_id from sales_flat_order where increment_id='".$this->getIncrementId()."')");  
    $row = $value->fetch();

$LastTransId=$row['last_trans_id'];

return $LastTransId;
}