Miscellany

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