github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/cmd/remove_dup_doc/select_doublons.sql (about)

     1  SELECT
     2      cd1.id_document,
     3      documents.nom_client,
     4      documents.description
     5  FROM
     6      contenu_documents cd1
     7      JOIN documents ON documents.id = cd1.id_document
     8  WHERE
     9      (
    10          SELECT
    11              count(*)
    12          FROM
    13              contenu_documents cd2
    14          WHERE
    15              cd2.contenu = cd1.contenu
    16      ) > 1
    17      AND id_document IN (
    18          SELECT
    19              id_document
    20          FROM
    21              document_personnes
    22      )
    23  ORDER BY
    24      contenu;