wikimedia / mediawiki

	 */

	public function makeGroupByWithHaving( $options ) {

		$sql = '';

		if ( isset( $options['GROUP BY'] ) ) {

			$gb = is_array( $options['GROUP BY'] )

				? implode( ',', $options['GROUP BY'] )

				: $options['GROUP BY'];

			$sql .= ' GROUP BY ' . $gb;

		}

		if ( isset( $options['HAVING'] ) ) {

			$having = is_array( $options['HAVING'] )

				? $this->makeList( $options['HAVING'], self::LIST_AND )

				: $options['GROUP BY'];

			$sql .= ' GROUP BY ' . $gb;

		}

		if ( isset( $options['HAVING'] ) ) {

			$having = is_array( $options['HAVING'] )

				? $this->makeList( $options['HAVING'], self::LIST_AND )

				: $options['HAVING'];

			$sql .= ' HAVING ' . $having;

		}

		return $sql;

	}

	 * @since 1.21

	 */

	public function makeOrderBy( $options ) {

		if ( isset( $options['ORDER BY'] ) ) {

			$ob = is_array( $options['ORDER BY'] )

				? implode( ',', $options['ORDER BY'] )

				: $options['ORDER BY'];

			return ' ORDER BY ' . $ob;

		}

		return '';

	}