<h2>File Contents: /home/planet5/.trash/wordpress-seo-premium/classes/export/export-keywords-term-query.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/wordpress-seo-premium/classes/export/export-keywords-term-query.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * WPSEO Premium plugin file.
 *
 * @package WPSEO\Premium\Classes\Export
 */

/**
 * Class WPSEO_Export_Keywords_Term_Query
 *
 * Creates an SQL query to gather all term data for a keywords export.
 */
class WPSEO_Export_Keywords_Term_Query implements WPSEO_Export_Keywords_Query {

	/**
	 * The WordPress database object.
	 *
	 * @var wpdb
	 */
	protected $wpdb;

	/**
	 * The columns to query for, an array of strings.
	 *
	 * @var array
	 */
	protected $columns;

	/**
	 * The database columns to select in the query, an array of strings.
	 *
	 * @var array
	 */
	protected $selects;

	/**
	 * Number of items to fetch per page.
	 *
	 * @var int
	 */
	protected $page_size;

	/**
	 * WPSEO_Export_Keywords_Query constructor.
	 *
	 * Supported values for columns are &#039;title&#039;, &#039;url&#039;, &#039;keywords&#039;, &#039;readability_score&#039; and &#039;keywords_score&#039;.
	 * Requesting &#039;keywords_score&#039; will always also return &#039;keywords&#039;.
	 *
	 * @param wpdb  $wpdb      A WordPress Database object.
	 * @param array $columns   List of columns that need to be retrieved.
	 * @param int   $page_size Number of items to retrieve.
	 */
	public function __construct( $wpdb, array $columns, $page_size = 1000 ) {
		$this-&gt;wpdb      = $wpdb;
		$this-&gt;page_size = max( 1, (int) $page_size );
		$this-&gt;set_columns( $columns );
	}

	/**
	 * Returns the page size for the query.
	 *
	 * @return int Page size that is being used.
	 */
	public function get_page_size() {
		return $this-&gt;page_size;
	}

	/**
	 * Constructs the query and executes it, returning an array of objects containing the columns this object was constructed with.
	 * Every object will always contain the ID column.
	 *
	 * @param int $page Paginated page to retrieve.
	 *
	 * @return array An array of associative arrays containing the keys as requested in the constructor.
	 */
	public function get_data( $page = 1 ) {

		if ( $this-&gt;columns === [] ) {
			return [];
		}

		$taxonomies = get_taxonomies(
			[
				&#039;public&#039;  =&gt; true,
				&#039;show_ui&#039; =&gt; true,
			],
			&#039;names&#039;
		);

		if ( empty( $taxonomies ) ) {
			return [];
		}

		// Pages have a starting index of 1, we need to convert to a 0 based offset.
		$offset_multiplier = max( 0, ( $page - 1 ) );

		$replacements   = $taxonomies;
		$replacements[] = $this-&gt;page_size;
		$replacements[] = ( $offset_multiplier * $this-&gt;page_size );

		// Construct the query.
		$query = $this-&gt;wpdb-&gt;prepare(
			&#039;SELECT &#039; . implode( &#039;, &#039;, $this-&gt;selects )
				. &#039; FROM &#039; . $this-&gt;wpdb-&gt;prefix . &#039;terms AS terms&#039;
				. &#039; INNER JOIN &#039; . $this-&gt;wpdb-&gt;prefix . &#039;term_taxonomy AS taxonomies&#039;
				. &#039; ON terms.term_id = taxonomies.term_id AND taxonomies.taxonomy IN (&#039;
				. implode( &#039;,&#039;, array_fill( 0, count( $taxonomies ), &#039;%s&#039; ) ) . &#039;)&#039;
				. &#039; LIMIT %d OFFSET %d&#039;,
			$replacements
		);

		return $this-&gt;wpdb-&gt;get_results( $query, ARRAY_A );
	}

	/**
	 * Prepares the necessary selects and joins to get all data in a single query.
	 *
	 * @param array $columns The columns we want our query to return.
	 */
	public function set_columns( array $columns ) {
		$this-&gt;columns = $columns;

		$this-&gt;selects = [ &#039;terms.term_id&#039;, &#039;taxonomies.taxonomy&#039; ];

		if ( in_array( &#039;title&#039;, $this-&gt;columns, true ) ) {
			$this-&gt;selects[] = &#039;terms.name&#039;;
		}
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Fwordpress-seo-premium%2Fclasses%2Fexport'>⬅ Back to Directory</a>