SELECT DISTINCT i.entity_id, datat.title, cp.field_code_postal_value, c.field_commune_value, feaga.field_mnt_feaga_value, feader.field_mnt_feader_value, total.field_mnt_total_value, eca.field_annee_target_id, cpa.field_is_cp_anonyme_value, n.field_nom_value, na.field_is_nom_anonyme_value
          FROM (
                (
                  SELECT DISTINCT ec.entity_id
                  FROM node__field_organisme ec
                  INNER JOIN node_field_data datat ON datat.nid = ec.entity_id AND datat.status='1'
                  INNER JOIN node__field_code_postal_organisme o ON o.entity_id = ec.field_organisme_target_id
                  INNER JOIN node__field_arrondissement a ON a.entity_id = o.field_code_postal_organisme_target_id
                  INNER join node__field_code_postal cp on cp.entity_id = o.field_code_postal_organisme_target_id
                  INNER join node__field_commune c on c.entity_id = o.field_code_postal_organisme_target_id
                  INNER JOIN node__field_is_cp_anonyme cpa ON cpa.entity_id = ec.entity_id and cpa.field_is_cp_anonyme_value = 0
                  INNER JOIN node__field_annee eca ON eca.entity_id = ec.entity_id

                  WHERE
                  cp.field_code_postal_value like '%BE-6230%'
                )
                UNION
                (
                  SELECT DISTINCT ec.entity_id
                  FROM node__field_code_postal cp
                  INNER join node__field_commune c on c.entity_id = cp.entity_id
                  INNER JOIN node__field_arrondissement a ON cp.entity_id = a.entity_id
                  INNER join (
                    SELECT cp.entity_id, a.field_arrondissement_target_id
                    FROM node__field_code_postal cp
                    INNER JOIN node__field_arrondissement a ON cp.entity_id = a.entity_id
                  ) acp on acp.field_arrondissement_target_id = a.field_arrondissement_target_id
                  INNER join node__field_code_postal cpo on cpo.entity_id = acp.entity_id
                  INNER JOIN node__field_code_postal_organisme o ON o.field_code_postal_organisme_target_id = acp.entity_id
                  INNER JOIN node__field_organisme ec ON ec.field_organisme_target_id = o.entity_id
                  INNER JOIN node_field_data datat ON datat.nid = ec.entity_id AND datat.status='1'
                  INNER JOIN node__field_annee eca ON eca.entity_id = ec.entity_id
                  INNER JOIN node__field_is_cp_anonyme cpa ON cpa.entity_id = ec.entity_id and cpa.field_is_cp_anonyme_value <> 0
                  WHERE cp.field_code_postal_value like '%BE-6230%')) as i
          LEFT JOIN node__field_mnt_feaga feaga ON feaga.entity_id = i.entity_id  AND feaga.langcode = 'fr'
          LEFT JOIN node__field_mnt_feader feader ON feader.entity_id = i.entity_id  AND feader.langcode = 'fr'
          LEFT JOIN node__field_mnt_total total ON total.entity_id = i.entity_id  AND total.langcode = 'fr'
          LEFT JOIN node_field_data datat ON datat.nid = i.entity_id AND datat.langcode = 'fr'
          LEFT JOIN node__field_organisme ec ON i.entity_id = ec.entity_id AND ec.langcode = 'fr'
          LEFT JOIN node__field_code_postal_organisme o ON o.entity_id = ec.field_organisme_target_id AND o.langcode = 'fr'
          LEFT JOIN node__field_nom n ON n.entity_id = o.entity_id AND n.langcode = 'fr'
          LEFT join node__field_code_postal cp on cp.entity_id = o.field_code_postal_organisme_target_id AND cp.langcode = 'fr'
          LEFT join node__field_commune c on c.entity_id = o.field_code_postal_organisme_target_id  AND c.langcode = 'fr'
          LEFT JOIN node__field_annee eca ON eca.entity_id = i.entity_id AND eca.langcode = 'fr'
          LEFT JOIN node__field_is_nom_anonyme na ON na.entity_id = eca.entity_id AND na.langcode = 'fr'
          LEFT JOIN node__field_is_cp_anonyme cpa ON cpa.entity_id = eca.entity_id	AND cpa.langcode = 'fr'
       ORDER BY datat.title ASC LIMIT 10 OFFSET 0