getSelect example

return $this->_select;
    }

    /** * Run query and returns matches, or null if no matches are found. * * @param String $value * @return Array when matches are found. */
    protected function _query($value)
    {
        $select = $this->getSelect();
        /** * Run query */
        $result = $select->getAdapter()->fetchRow(
            $select,
            array('value' => $value), // this should work whether db supports positional or named params             Zend_Db::FETCH_ASSOC
            );

        return $result;
    }
}