insideout10 / wordlift-plugin

	 *

	 * @return array|object|null Database query results

	 */

	public function get_non_article_subjects( $object_id, $fields = '*', $status = null ) {

		global $wpdb;

		// The output fields.

		$actual_fields = self::fields( $fields );

		$sql = $wpdb->prepare(

			"

			SELECT p.$actual_fields

			FROM {$this->relation_table} r

			INNER JOIN $wpdb->posts p

				ON p.id = r.subject_id

			"

			// Add the status clause.

			. self::and_status( $status )

			. self::inner_join_is_not_article() .

			"

			WHERE r.object_id = %d

				AND p.post_type IN ( 'post', 'page', 'entity' )

			"

			,

			$object_id

		);

		return '*' === $actual_fields ? $wpdb->get_results( $sql ) : $wpdb->get_col( $sql );

	}

	/**

	 * Get the entities referenced by the specified {@link WP_Post}.

	 *

	 * @return array|object|null Database query results

	 */

	public function get_objects( $subject_id, $fields = '*', $predicate = null, $status = null ) {

		global $wpdb;

		// The output fields.

		$actual_fields = self::fields( $fields );

		$sql = $wpdb->prepare(

			"

			SELECT p.$actual_fields

			FROM {$this->relation_table} r

			INNER JOIN $wpdb->posts p

				ON p.id = r.object_id

			"

			// Add the status clause.

			. self::and_status( $status )

			. self::inner_join_is_not_article()

			. "

			WHERE r.subject_id = %d

				AND p.post_type IN ( 'post', 'page', 'entity' )

			"

			. self::and_predicate( $predicate )

			,

			$subject_id

		);

		return '*' === $actual_fields ? $wpdb->get_results( $sql ) : $wpdb->get_col( $sql );

	}

	/**

	 * Add the `post_status` clause.