/** * Build and returns the full SQL SELECT query * * @return string */ public function buildQuery() { // call buildWhere() before buildTables(), to get joins ready $where = $this->where_builder->build(true); $tables = $this->tables_builder->build(); return $this->finalize($where, $tables); }
/** * Build and returns the full SQL SELECT query * * @return string */ public function buildQuery() { // Call of buildOptions() and buildWhere() before buildColumns(), as all joins must be done to // correctly deal with all properties. // Call of buildColumns() and buildWhere() before buildTables(), to get joins ready. $this->additional_where_clause = ''; // Notice : true was commented as it very often crashes mysql maintainer $where = $this->where_builder->build(); $options = $this->buildOptions(); $columns = $this->columns_builder->build(); $tables = $this->tables_builder->build(); return $this->finalize($columns, $where, $tables, $options); }