SELECT C2 FROM(
  -- 分支1: c6='V6' AND C4='25' AND C5 IN(...) AND c7='v7a'
  SELECT C2 FROM t1
  WHERE C2 IS NOT NULL AND C2 <>''
    AND C6 IN ('V6') AND C4='25' AND C5 IN ('1238'，'1296'，...)
    AND C7 IN ('v7a')
  UNION ALL
  -- 分支2: c4='4' AND C5 IN(...)
  SELECT C2 FROM t1
  WHERE C2 IS NOT NULL AND C2 <>''
    AND C4 ='4' AND 5 IN ('10135269'，'10144642')
  UNION ALL
  -- 分支3: c4='20' AND C5 IN(...)
  SELECT C2 FROM t1
  WHERE C2 IS NOT NULL AND c2 <>''
  AND C4 ='20' AND C5 IN ('2000000085', '2000000086'，...)
  UNION ALL
  -- 分支4-7: NOT IN 分支，同理拆分
  SELECT C2 FROM t1
  WHERE C2 IS NOT NULL AND c2 <>''
  AND C4 ='25' AND C5 NOT IN ('1238'，'1296'，...)
  UNION ALL
  -- ...其他 NOT IN 分支 ...
) AS sub;