protected function visitSelect(Select $select) { $this->selectCount++; $columns = array(); foreach ($select->getColumns() as $c) { $columns[] = $this->process($c); } $froms = array(); foreach ($select->getFroms() as $f) { $froms[] = $this->process($f); } $sql = 'SELECT ' . ($select->distinct ? 'DISTINCT ' : '') . implode(', ', $columns) . ' FROM ' . implode(', ', $froms); $where = $select->whereClause; $orderBy = $select->orderByClause; $limit = $this->getLimitClause($select->offset, $select->limit); if ($where !== null) { $sql .= ' WHERE ' . $this->process($where); } if ($orderBy !== null) { $sql .= ' ORDER BY ' . $this->process($orderBy); } if (!empty($limit)) { $sql .= $limit; } if ($this->isSubquery()) { $sql = '(' . $sql . ')'; } $this->selectCount--; return $sql; }