protected function build_sql() {

		$this->make_limit_tag();

		$builder = new Builder();

		if ( ! $this->select->is_all() && ! $this->select->get_columns() ) {
			$this->select->all( $this->alias );
		}

		$this->select->calc_found_rows( $this->calc_found_rows );

		$builder->append( $this->select );
		$builder->append( $this->from );

		foreach ( $this->joins as $join ) {
			$builder->append( $join );
		}

		if ( $this->meta_join ) {
			$builder->append( new Generic( '', $this->meta_join ) );
		}

		if ( $this->where ) {
			$builder->append( $this->where );
		}

		if ( $this->group ) {
			$builder->append( $this->group );
		}

		if ( $this->having ) {
			$builder->append( $this->having );
		}

		if ( $this->order ) {
			$builder->append( $this->order );
		}

		if ( $this->limit ) {
			$builder->append( $this->limit );
		}

		return $builder->build();
	}
protected function build_sql() {

		$this->make_limit_tag();

		$builder = new Builder();

		if ( ! $this->select->is_all() && ! $this->select->get_columns() ) {
			$this->select->all( $this->alias );
		}

		$this->select->calc_found_rows( $this->calc_found_rows );

		$builder->append( $this->select );
		$builder->append( $this->from );

		foreach ( $this->joins as $join ) {
			$builder->append( $join );
		}

		if ( $this->meta_join ) {
			$builder->append( new Generic( '', $this->meta_join ) );
		}

		if ( $this->where ) {
			$builder->append( $this->where );
		}

		if ( $this->group ) {
			$builder->append( $this->group );
		}

		if ( $this->having ) {
			$builder->append( $this->having );
		}

		if ( $this->order ) {
			$builder->append( $this->order );
		}

		if ( $this->limit ) {
			$builder->append( $this->limit );
		}

		return $builder->build();
	}
protected function build_sql ( ) { $ this -> make_limit_tag ( ) ; $ builder = new Builder ( ) ; if ( ! $ this -> select -> is_all ( ) && ! $ this -> select -> get_columns ( ) ) { $ this -> select -> all ( $ this -> alias ) ; } $ this -> select -> calc_found_rows ( $ this -> calc_found_rows ) ; $ builder -> append ( $ this -> select ) ; $ builder -> append ( $ this -> from ) ; foreach ( $ this -> joins as $ join ) { $ builder -> append ( $ join ) ; } if ( $ this -> meta_join ) { $ builder -> append ( new Generic ( '' , $ this -> meta_join ) ) ; } if ( $ this -> where ) { $ builder -> append ( $ this -> where ) ; } if ( $ this -> group ) { $ builder -> append ( $ this -> group ) ; } if ( $ this -> having ) { $ builder -> append ( $ this -> having ) ; } if ( $ this -> order ) { $ builder -> append ( $ this -> order ) ; } if ( $ this -> limit ) { $ builder -> append ( $ this -> limit ) ; } return $ builder -> build ( ) ; }
Build the SQL statement.

@since 2.0

@return string
Build the SQL statement .