php - 为什么此SQL给出语法错误？

This question already has answers here:

Alternative to Intersect in MySQL
                                
                                    （8个答案）
                                
                        
                                5年前关闭。
            
                    
尝试查看“ me_id”和“ you_id”两个视频类别都观看了以下视频：

SELECT c.title, COUNT(*) AS popularity
FROM video v
JOIN user u ON v.user_id = u.id
JOIN v_cat vc ON c.id = vc.vid_id
JOIN cat c ON c.id = vc.cat_id
JOIN u_cat uc ON uc.cat_id = c.id
WHERE uc.user_id = '$me_id'

INTSERSECT

SELECT c.title, COUNT(*) AS popularity
FROM video v
JOIN user u ON v.user_id = u.id
JOIN v_cat vc ON c.id = vc.vid_id
JOIN cat c ON c.id = vc.cat_id
JOIN u_cat uc ON uc.cat_id = c.id
WHERE uc.user_id = '$you_id'

GROUP BY c.title
ORDER BY uc.id DESC LIMIT 0, 10

我在使用PHP / MYSQL有什么想法吗？

最佳答案

MySQL doesn't have INTERSECT.