public function get_where($table = '', $where = NULL, $limit = NULL, $offset = NULL)
{
if ($table !== '') {
$this->from($table);
}
if ($where !== NULL) {
$this->where($where);
}
if (!empty($limit)) {
$this->limit($limit, $offset);
}
$result = $this->query($this->_compile_select());
$this->_reset_select();
return $result;
}