mysql union不能嵌套union语句吗?报错

要查询的情况是  1查询条件联合2查询的条件后分页取4条， 然后 再联合 3条件和4条件查询的结果取4条，

不知道Mysql 会不会有union不能嵌套union的限制， 但是从报错情况看，确实是像这个样子

(SELECT v.id, v.name_cn, v.create_time, v.pic_upload, v.video_pic, m.groups

   FROM con_video_info v, con_video_match_relation r, sport_match_info m
   WHERE v.id = r.vid
   AND m.id = r.match_id
   AND m.groups = 'A'
   UNION 
   SELECT v.id, v.name_cn
   FROM con_video_info v, con_video_match_relation r
   WHERE v.id = r.vid
   AND team_id IN (6,7,12,23)
   ORDER BY create_time DESC
   LIMIT 0,4
  )
    
    UNION
   (SELECT v.id, v.name_cn, v.create_time, v.pic_upload, v.video_pic, m.groups
   FROM con_video_info v, con_video_match_relation r, sport_match_info m
   WHERE v.id = r.vid
   AND m.id = r.match_id
   AND m.groups = 'B'
   UNION 
   SELECT v.id, v.name_cn, v.create_time, v.pic_upload, v.video_pic, 'B' AS groups
   FROM con_video_info v, con_video_match_relation r
   WHERE v.id = r.vid
   AND team_id IN (3,8,24,29)
   ORDER BY create_time DESC
   LIMIT 0,4
)