/**
* Overrides the DataModel's buildQuery to allow nested set searches using the provided scopes
*
* @param bool $overrideLimits
*
* @return \Awf\Database\Query
*/
public function buildQuery($overrideLimits = false)
{
$db = $this->getDbo();
$query = parent::buildQuery($overrideLimits);
$query->select(null)->select($db->qn('node') . '.*')->from(null)->from($db->qn($this->tableName) . ' AS ' . $db->qn('node'));
if ($this->treeNestedGet) {
$query->join('CROSS', $db->qn($this->tableName) . ' AS ' . $db->qn('parent'));
}
return $query;
}
