Miscellany

if ( !empty($q['tag_slug__and']) ) {	$post_ids = $wpdb->get_col("SELECT $wpdb->posts.ID FROM $wpdb->posts LEFT JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) LEFT JOIN $wpdb->terms ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id) WHERE $wpdb->term_taxonomy.taxonomy = 'post_tag' AND $wpdb->terms.slug IN ('" . implode("', '", $q['tag_slug__and']) . "') GROUP BY post_name HAVING count($wpdb->posts.ID) = " . count($q['tag_slug__and']));				if ( count($post_ids) )		$where .= "AND $wpdb->posts.ID IN (" . implode(', ', $post_ids) . ") ";}