Offset and AND terms

Hey @saskso,

Is there a way to offset the posts returned by the shortcode?

So here’s the thing: unlike recent posts lists, posts within a popular posts list -pardon the redundancy- might (and most likely will) change positions at any time (even between page loads) so there’s a good chance that this won’t work as you expect it to.

With that being said and since I’m believe you may still want to give it a try, there’s an undocumented offset parameter that’s exactly for this use case since someone else requested it a long time ago and I didn’t see a reason to not implement it at the time (and didn’t put a lot of thought into it either.) Hopefully this explains why the parameter isn’t documented anywhere 😛

For the shortcode [wpp cat=’1, 55′], this appears to be an OR on the categories. I need to do AND so that it would return only posts in category 1 AND category 55 not posts in either one. Can I do that?

You asked about this 3 years ago (wow, time sure flies!) and I did look into it back then but wasn’t happy with the end result so I abandoned that experiment. Might revisit it again in the future.

For the time being this should do the trick:

/**
 * Alters WPP's database query so the category filter uses an "AND" relationship.
 *
 * @param  string  $where    The original WHERE string
 * @param  array   $options  Array of options generated by the shortcode
 * @return string  $where    The (modified) WHERE string
 */
add_filter('wpp_query_where', function($where, $options) {
	if ( ! is_admin() && isset($options['term_id']) && $options['term_id'] ) {
		global $wpdb;

		$term_IDs = explode(',', $options['term_id']);

		$pattern = '/AND p.ID IN (.*) AND p.post_password/s';
		$replacement = 'AND ( ( SELECT COUNT(1) FROM ' . $wpdb->term_relationships . ' WHERE term_taxonomy_id IN (' . $options['term_id'] . ') AND object_id = p.ID ) = ' . count($term_IDs) . ' ) AND p.post_password';
		return preg_replace($pattern, $replacement, $where);
	}
	// ELSE
	return $where;
}, 10, 2);

• This reply was modified 1 year, 5 months ago by Hector Cabrera. Reason: Updated subquery so term count isn't fixed

Yup, the plugin uses a custom PHP class to build its own DB queries. It doesn’t rely on WP_Query at all (hence the need to write custom code to have the AND relationship stuff going.)

Alright, re-tested the code snippet and these were my results:

• Providing just one term ID returned results as expected
• Using taxonomy='post_tag' term_id='XX' (where XX is a single term ID as instructed) and this also returned the posts I expected to see

Mind you, all this with the same code snippet from above. No modifications at all.

To answer one of your previous questions, if you don’t want the AND-relationship mod to run with post tags you can do this instead:

/**
 * Alters WPP's database query so the category filter uses an "AND" relationship.
 *
 * @param  string  $where    The original WHERE string
 * @param  array   $options  Array of options generated by the shortcode
 * @return string  $where    The (modified) WHERE string
 */
add_filter('wpp_query_where', function($where, $options) {
	if (
		! is_admin()
		&& isset($options['term_id'])
		&& $options['term_id']
		&& isset($options['taxonomy'])
		&& 'category' === $options['taxonomy']
	) {
		global $wpdb;

		$term_IDs = explode(',', $options['term_id']);

		$pattern = '/AND p.ID IN (.*) AND p.post_password/s';
		$replacement = 'AND ( ( SELECT COUNT(1) FROM ' . $wpdb->term_relationships . ' WHERE term_taxonomy_id IN (' . $options['term_id'] . ') AND object_id = p.ID ) = ' . count($term_IDs) . ' ) AND p.post_password';
		return preg_replace($pattern, $replacement, $where);
	}
	// ELSE
	return $where;
}, 10, 2);