2种简单的方法来做到这一点。
根据所需的列，可能的标签数等，选择以下任意一种
SELECt *FROM imagesINNER JOIN images_tags_link a ON images.image_id = a.image_id_fk AND a.tag_name_fk = 'Blue'INNER JOIN images_tags_link b ON images.image_id = b.image_id_fk AND b.tag_name_fk = 'Landscape'SELECt images.image_id, images.image_name, COUNT(*) AS tag_countFROM imagesINNER JOIN images_tags_link a ON images.image_id = a.image_id_fk WHERe a.tag_name_fk IN ('Blue', 'Landscape')GROUP BY images.image_id, images.image_nameHAVINg tag_count = 2
