SELECT
  lib_cite,
  TRIM(TRAILING ', ' FROM CONCAT(
    CASE
      WHEN NOT lib_qpv1 IS NULL AND lib_qpv1 <> ''
      THEN CONCAT(lib_qpv1, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv2 IS NULL AND lib_qpv2 <> ''
      THEN CONCAT(lib_qpv2, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv3 IS NULL AND lib_qpv3 <> ''
      THEN CONCAT(lib_qpv3, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv4 IS NULL AND lib_qpv4 <> ''
      THEN CONCAT(lib_qpv4, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv5 IS NULL AND lib_qpv5 <> ''
      THEN CONCAT(lib_qpv5, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv6 IS NULL AND lib_qpv6 <> ''
      THEN CONCAT(lib_qpv6, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv7 IS NULL AND lib_qpv7 <> ''
      THEN CONCAT(lib_qpv7, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv8 IS NULL AND lib_qpv8 <> ''
      THEN CONCAT(lib_qpv8, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv9 IS NULL AND lib_qpv9 <> ''
      THEN CONCAT(lib_qpv9, ', ')
      ELSE ''
    END,
    CASE
      WHEN NOT lib_qpv10 IS NULL AND lib_qpv10 <> ''
      THEN CONCAT(lib_qpv10, ', ')
      ELSE ''
    END
  )) AS liste_qpv,
  annee_labellisation
FROM cites_educatives
ORDER BY
  lib_cite