我有一张table：

$taxonomy_table (
                `id` int(11) NOT NULL AUTO_INCREMENT,
                `type` varchar(10) NOT NULL,
                `title` varchar(255) NOT NULL,
                `media_id` int(11) NOT NULL,
                `playlist_id` int(11) NOT NULL,
                PRIMARY KEY (`id`),
                INDEX `media_id` (`media_id`),
                CONSTRAINT `mqap_taxonomy_ibfk_1` FOREIGN KEY (`media_id`) REFERENCES {$media_table} (`id`) ON DELETE CASCADE ON UPDATE CASCADE
            )";

media_id     type      title
------------------------------
23           tag       fashion
23           tag       beauty
23           category  foo
24           tag       fashion
24           category  foo

我想选择所有这些标签都是“fashion，beauty”和category=“foo”的商品，所以只有media\u id=23。
查询是：

$query = "SELECT media_id
                FROM {$taxonomy_table}
                WHERE type='tag' AND title IN ($arg) 
                AND type='category' AND title IN ($arg2)
                AND playlist_id=%d
                GROUP BY media_id
                HAVING count(DISTINCT title) = $total";

$arg=“时尚，美丽”，$arg2=“foo”

"SELECT media_id 
 FROM wp_mvp_taxonomy 
 WHERE type='tag' 
   AND title IN (%s,%s) 
   AND type='category' 
   AND title IN (%s) 
 GROUP BY media_id 
 HAVING count(DISTINCT title) = 3"

但这不是回报。