SELECT *
  FROM (SELECT   ypmc00, ypgg00, ypbm00, pysm00, wbsm00, ypnm00, lsjxx0,
                 sjkcxx, yblbmc, zfbl00, bz0000, ypsysm, colour
            FROM vw_bq_fbyp00
           WHERE (pysm00 LIKE 'bdws')
             AND (    (   (    (   yfbmbh = 55
                                OR (    bqkdyf = 'Y'
                                    AND yfbmbh IN (
                                            SELECT yfbmbh
                                              FROM xt_ypfwfx
                                             WHERE slbmbh = 52
                                                   AND yplbbh = '0'
                                                   )
                                   )
                               )
                           AND lbbh00 = '0'
                          )
                       OR (    (   yfbmbh = 55
                                OR (    bqkdyf = 'Y'
                                    AND yfbmbh IN (
                                            SELECT yfbmbh
                                              FROM xt_ypfwfx
                                             WHERE slbmbh = 52
                                                   AND yplbbh = '1'
                                                  )
                                   )
                               )
                         AND lbbh00 = '1'
                          )
                      )
                  AND (   (EXISTS (
                              SELECT 1
                                FROM vw_bq_bqzyyp
                               WHERE ypnm00 = vw_bq_fbyp00.ypnm00
                                 AND bz0000 = '??2¨²??¡ê¡§2???¡ê?')
                          )
                       OR (NOT EXISTS (SELECT 1
                                         FROM vw_bq_bqzyyp
                                        WHERE ypnm00 = vw_bq_fbyp00.ypnm00))
                      )
                 )
        ORDER BY INSTRB (pysm00, 'bd'), pysm00)
 WHERE ROWNUM <= 10