SERVEUR

   Tables: Détails  
    Views: Détails  
   Tables & Views: Liste  
   Records  
  Actions  
  Files
LIST OF VIEWS in MySQL
  1. attente_identification_demographiques_ok
    2. select `altesse_smartnephro`.`attente_identification_demographiques`.`id` AS `id`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_numero_identification` AS `patient_numero_identification`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_nom` AS `patient_nom`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_prenom` AS `patient_prenom`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_date_naissance` AS `patient_date_naissance`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_age_remplissage` AS `patient_age_remplissage`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_ville_naissance` AS `patient_ville_naissance`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_pays_naissance` AS `patient_pays_naissance`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_sexe` AS `patient_sexe`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_commentaire` AS `patient_commentaire`,`altesse_smartnephro`.`attente_identification_demographiques`.`centre_inclusion_code` AS `centre_inclusion_code`,`altesse_smartnephro`.`attente_identification_demographiques`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`attente_identification_demographiques`.`patient_epi` AS `patient_epi`,`altesse_smartnephro`.`attente_identification_demographiques`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`attente_identification_demographiques`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`attente_identification_demographiques`.`dates` AS `dates`,`altesse_smartnephro`.`attente_identification_demographiques`.`date_modif` AS `date_modif`,year(`altesse_smartnephro`.`attente_identification_demographiques`.`patient_date_remplissage`) AS `annee_remplissage`,(year(curdate()) - year(`altesse_smartnephro`.`attente_identification_demographiques`.`patient_date_naissance`)) AS `age`,(case when (`altesse_smartnephro`.`attente_identification_demographiques`.`centre_inclusion_code` = '000-000-000') then '000-000-000' else `altesse_smartnephro`.`centres`.`centre_code` end) AS `centre_code`,(case when (`altesse_smartnephro`.`attente_identification_demographiques`.`centre_inclusion_code` = '000-000-000') then 'En Attente' else `altesse_smartnephro`.`centres`.`centre` end) AS `centre` from (`altesse_smartnephro`.`attente_identification_demographiques` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`centres`.`centre_code` = `altesse_smartnephro`.`attente_identification_demographiques`.`centre_inclusion_code`)))

  2. centre_code1a
    3. select `altesse_smartnephro`.`centres`.`id` AS `id`,`altesse_smartnephro`.`centres`.`centre` AS `centre`,`altesse_smartnephro`.`centres`.`centre_code` AS `centre_code`,`altesse_smartnephro`.`centres`.`ville` AS `ville`,`altesse_smartnephro`.`centres`.`type_centre` AS `type_centre`,`altesse_smartnephro`.`centres`.`id` AS `Numero`,(case when (`altesse_smartnephro`.`centres`.`ville` like 'Abidjan%') then '-0-' else '-1-' end) AS `laville`,(case when (`altesse_smartnephro`.`centres`.`type_centre` like 'Publi%') then '-PU' else '-PR' end) AS `type`,concat(`altesse_smartnephro`.`villes`.`ville_abbrev`,'-') AS `abbrev` from (`altesse_smartnephro`.`centres` left join `altesse_smartnephro`.`villes` on((`altesse_smartnephro`.`centres`.`ville` = `altesse_smartnephro`.`villes`.`ville`)))

  3. centre_code1b
    4. select `a`.`id` AS `id`,`a`.`centre` AS `centre`,`a`.`centre_code` AS `centre_code`,`a`.`ville` AS `ville`,`a`.`type_centre` AS `type_centre`,`a`.`Numero` AS `Numero`,`a`.`laville` AS `laville`,`a`.`type` AS `type`,`a`.`abbrev` AS `abbrev`,(select count(0) from `altesse_smartnephro`.`centre_code1a` `b` where ((`a`.`ville` = `b`.`ville`) and (`a`.`id` >= `b`.`id`))) AS `ranked` from `altesse_smartnephro`.`centre_code1a` `a` order by `a`.`ville`,`a`.`id`

  4. centre_code2
    5. select `centre_code1b`.`id` AS `id`,`centre_code1b`.`centre_code` AS `centre_code`,`centre_code1b`.`centre` AS `centre`,`centre_code1b`.`ville` AS `ville`,`centre_code1b`.`type_centre` AS `type_centre`,`centre_code1b`.`ranked` AS `ranked`,concat(`centre_code1b`.`Numero`,convert(`centre_code1b`.`laville` using utf8),`centre_code1b`.`abbrev`,`centre_code1b`.`ranked`,convert(`centre_code1b`.`type` using utf8)) AS `codeducentre` from `altesse_smartnephro`.`centre_code1b` order by `centre_code1b`.`id`,`centre_code1b`.`ranked`

  5. centre_ville
    6. select `altesse_smartnephro`.`centres`.`id` AS `id`,`altesse_smartnephro`.`centres`.`ville` AS `ville`,`altesse_smartnephro`.`centres`.`centre` AS `centre`,`altesse_smartnephro`.`centres`.`type_centre` AS `type_centre`,(case when (`altesse_smartnephro`.`centres`.`ville` like 'Abidjan%') then 'Abidjan' else `altesse_smartnephro`.`centres`.`ville` end) AS `laville` from `altesse_smartnephro`.`centres` where (`altesse_smartnephro`.`centres`.`centre` <> 'Institut Pasteur')

  6. centre_ville_1
    7. select count(`centre_ville`.`id`) AS `totalcentre`,`centre_ville`.`laville` AS `laville`,`centre_ville`.`type_centre` AS `type_centre` from `altesse_smartnephro`.`centre_ville` group by `centre_ville`.`laville`,`centre_ville`.`type_centre`

  7. centre_ville_2
    8. select `p`.`laville` AS `Ville`,sum(if((`p`.`type_centre` = 'Publique'),`p`.`totalcentre`,NULL)) AS `Publique`,sum(if((`p`.`type_centre` = 'Privé'),`p`.`totalcentre`,NULL)) AS `Privé` from `altesse_smartnephro`.`centre_ville_1` `p` group by `Ville`

  8. centre_ville_3
    9. select `centre_ville_2`.`Ville` AS `Ville`,`centre_ville_2`.`Publique` AS `Publique`,`centre_ville_2`.`Privé` AS `Prive` from `altesse_smartnephro`.`centre_ville_2`

  9. infirmiers_centre
    10. select `altesse_smartnephro`.`centres`.`centre` AS `centre`,`altesse_smartnephro`.`infirmiers`.`id` AS `id`,`altesse_smartnephro`.`infirmiers`.`centre_code` AS `centre_code`,`altesse_smartnephro`.`infirmiers`.`inf_nom_prenoms` AS `inf_nom_prenoms`,`altesse_smartnephro`.`infirmiers`.`inf_contact_1` AS `inf_contact_1`,`altesse_smartnephro`.`infirmiers`.`inf_contact_2` AS `inf_contact_2`,`altesse_smartnephro`.`infirmiers`.`inf_whatsapp` AS `inf_whatsapp`,`altesse_smartnephro`.`infirmiers`.`inf_email` AS `inf_email`,`altesse_smartnephro`.`infirmiers`.`inf_actif` AS `inf_actif`,`altesse_smartnephro`.`infirmiers`.`inf_code` AS `inf_code`,`altesse_smartnephro`.`infirmiers`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`infirmiers`.`dates` AS `dates`,`altesse_smartnephro`.`infirmiers`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`infirmiers`.`date_modif` AS `date_modif` from (`altesse_smartnephro`.`infirmiers` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`centres`.`centre_code` = `altesse_smartnephro`.`infirmiers`.`centre_code`)))

  10. infirmiers_centre_ville
    11. select `infirmiers_numero`.`id` AS `id`,`infirmiers_numero`.`centre_code` AS `centre_code`,`infirmiers_numero`.`inf_nom_prenoms` AS `inf_nom_prenoms`,`infirmiers_numero`.`inf_contact_1` AS `inf_contact_1`,`infirmiers_numero`.`inf_contact_2` AS `inf_contact_2`,`infirmiers_numero`.`inf_whatsapp` AS `inf_whatsapp`,`infirmiers_numero`.`inf_email` AS `inf_email`,`infirmiers_numero`.`inf_actif` AS `inf_actif`,`infirmiers_numero`.`saisie_par` AS `saisie_par`,`infirmiers_numero`.`dates` AS `dates`,`infirmiers_numero`.`modifie_par` AS `modifie_par`,`infirmiers_numero`.`date_modif` AS `date_modif`,`infirmiers_numero`.`numero_centre` AS `numero_centre`,`altesse_smartnephro`.`centres`.`centre` AS `centre`,`altesse_smartnephro`.`centres`.`type_centre` AS `type_centre`,`altesse_smartnephro`.`centres`.`ville` AS `ville` from (`altesse_smartnephro`.`infirmiers_numero` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`centres`.`centre_code` = `infirmiers_numero`.`centre_code`)))

  11. infirmiers_numero
    12. select `a`.`id` AS `id`,`a`.`centre_code` AS `centre_code`,`a`.`inf_nom_prenoms` AS `inf_nom_prenoms`,`a`.`inf_contact_1` AS `inf_contact_1`,`a`.`inf_contact_2` AS `inf_contact_2`,`a`.`inf_whatsapp` AS `inf_whatsapp`,`a`.`inf_email` AS `inf_email`,`a`.`inf_actif` AS `inf_actif`,`a`.`saisie_par` AS `saisie_par`,`a`.`dates` AS `dates`,`a`.`modifie_par` AS `modifie_par`,`a`.`date_modif` AS `date_modif`,(select count(0) from `altesse_smartnephro`.`infirmiers` `b` where ((`a`.`centre_code` = `b`.`centre_code`) and (`a`.`id` >= `b`.`id`))) AS `numero_centre` from `altesse_smartnephro`.`infirmiers` `a` order by `a`.`centre_code`,`a`.`id`

  12. medecins_centres
    13. select `medecins_centres_4`.`id` AS `id`,`medecins_centres_4`.`medecin_appelation` AS `medecin_appelation`,`medecins_centres_4`.`medecin_nom` AS `medecin_nom`,`medecins_centres_4`.`medecin_prenom` AS `medecin_prenom`,`medecins_centres_4`.`medecin_sexe` AS `medecin_sexe`,`medecins_centres_4`.`medecin_ddn` AS `medecin_ddn`,`medecins_centres_4`.`num_onmci` AS `num_onmci`,`medecins_centres_4`.`medecin_code` AS `medecin_code`,`medecins_centres_4`.`medecin_statut` AS `medecin_statut`,`medecins_centres_4`.`medecin_statut_autre` AS `medecin_statut_autre`,`medecins_centres_4`.`medecin_centre_code_1` AS `medecin_centre_code_1`,`medecins_centres_4`.`medecin_centre_role_1` AS `medecin_centre_role_1`,`medecins_centres_4`.`medecin_centre_code_2` AS `medecin_centre_code_2`,`medecins_centres_4`.`medecin_centre_role_2` AS `medecin_centre_role_2`,`medecins_centres_4`.`medecin_centre_code_3` AS `medecin_centre_code_3`,`medecins_centres_4`.`medecin_centre_role_3` AS `medecin_centre_role_3`,`medecins_centres_4`.`medecin_sineph` AS `medecin_sineph`,`medecins_centres_4`.`medecin_sineph_annee` AS `medecin_sineph_annee`,`medecins_centres_4`.`medecin_sineph_role` AS `medecin_sineph_role`,`medecins_centres_4`.`medecin_tel_1` AS `medecin_tel_1`,`medecins_centres_4`.`medecin_tel_2` AS `medecin_tel_2`,`medecins_centres_4`.`medecin_cel_1` AS `medecin_cel_1`,`medecins_centres_4`.`medecin_cel_2` AS `medecin_cel_2`,`medecins_centres_4`.`medecin_fax` AS `medecin_fax`,`medecins_centres_4`.`medecin_email` AS `medecin_email`,`medecins_centres_4`.`medecin_profil` AS `medecin_profil`,`medecins_centres_4`.`medecin_inviter` AS `medecin_inviter`,`medecins_centres_4`.`medecin_inviter_date` AS `medecin_inviter_date`,`medecins_centres_4`.`medecin_code_invitation` AS `medecin_code_invitation`,`medecins_centres_4`.`commentaire` AS `commentaire`,`medecins_centres_4`.`medecin_actif` AS `medecin_actif`,`medecins_centres_4`.`saisie_public_nom` AS `saisie_public_nom`,`medecins_centres_4`.`saisie_public_email` AS `saisie_public_email`,`medecins_centres_4`.`saisie_public_cel` AS `saisie_public_cel`,`medecins_centres_4`.`modif_nom` AS `modif_nom`,`medecins_centres_4`.`modif_email` AS `modif_email`,`medecins_centres_4`.`modif_cel` AS `modif_cel`,`medecins_centres_4`.`date_modif` AS `date_modif`,`medecins_centres_4`.`saisie_par` AS `saisie_par`,`medecins_centres_4`.`modifie_par` AS `modifie_par`,`medecins_centres_4`.`dates` AS `dates`,`medecins_centres_4`.`centre_1` AS `centre_1`,`medecins_centres_4`.`centre_2` AS `centre_2`,`medecins_centres_3`.`centre_3` AS `centre_3` from (`altesse_smartnephro`.`medecins_centres_3` left join `altesse_smartnephro`.`medecins_centres_4` on((`medecins_centres_4`.`id` = `medecins_centres_3`.`id`)))

  13. medecins_centres_1
    14. select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_appelation` AS `medecin_appelation`,`altesse_smartnephro`.`medecins`.`medecin_nom` AS `medecin_nom`,`altesse_smartnephro`.`medecins`.`medecin_prenom` AS `medecin_prenom`,`altesse_smartnephro`.`medecins`.`medecin_sexe` AS `medecin_sexe`,`altesse_smartnephro`.`medecins`.`medecin_ddn` AS `medecin_ddn`,`altesse_smartnephro`.`medecins`.`num_onmci` AS `num_onmci`,`altesse_smartnephro`.`medecins`.`medecin_code` AS `medecin_code`,`altesse_smartnephro`.`medecins`.`medecin_statut` AS `medecin_statut`,`altesse_smartnephro`.`medecins`.`medecin_statut_autre` AS `medecin_statut_autre`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_1` AS `medecin_centre_code_1`,`altesse_smartnephro`.`medecins`.`medecin_centre_role_1` AS `medecin_centre_role_1`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_2` AS `medecin_centre_code_2`,`altesse_smartnephro`.`medecins`.`medecin_centre_role_2` AS `medecin_centre_role_2`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_3` AS `medecin_centre_code_3`,`altesse_smartnephro`.`medecins`.`medecin_centre_role_3` AS `medecin_centre_role_3`,`altesse_smartnephro`.`medecins`.`medecin_sineph` AS `medecin_sineph`,`altesse_smartnephro`.`medecins`.`medecin_sineph_annee` AS `medecin_sineph_annee`,`altesse_smartnephro`.`medecins`.`medecin_sineph_role` AS `medecin_sineph_role`,`altesse_smartnephro`.`medecins`.`medecin_tel_1` AS `medecin_tel_1`,`altesse_smartnephro`.`medecins`.`medecin_tel_2` AS `medecin_tel_2`,`altesse_smartnephro`.`medecins`.`medecin_cel_1` AS `medecin_cel_1`,`altesse_smartnephro`.`medecins`.`medecin_cel_2` AS `medecin_cel_2`,`altesse_smartnephro`.`medecins`.`medecin_fax` AS `medecin_fax`,`altesse_smartnephro`.`medecins`.`medecin_email` AS `medecin_email`,`altesse_smartnephro`.`medecins`.`medecin_profil` AS `medecin_profil`,`altesse_smartnephro`.`medecins`.`medecin_inviter` AS `medecin_inviter`,`altesse_smartnephro`.`medecins`.`medecin_inviter_date` AS `medecin_inviter_date`,`altesse_smartnephro`.`medecins`.`medecin_code_invitation` AS `medecin_code_invitation`,`altesse_smartnephro`.`medecins`.`commentaire` AS `commentaire`,`altesse_smartnephro`.`medecins`.`medecin_actif` AS `medecin_actif`,`altesse_smartnephro`.`medecins`.`saisie_public_nom` AS `saisie_public_nom`,`altesse_smartnephro`.`medecins`.`saisie_public_email` AS `saisie_public_email`,`altesse_smartnephro`.`medecins`.`saisie_public_cel` AS `saisie_public_cel`,`altesse_smartnephro`.`medecins`.`modif_nom` AS `modif_nom`,`altesse_smartnephro`.`medecins`.`modif_email` AS `modif_email`,`altesse_smartnephro`.`medecins`.`modif_cel` AS `modif_cel`,`altesse_smartnephro`.`medecins`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`medecins`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`medecins`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`medecins`.`dates` AS `dates`,`altesse_smartnephro`.`centres`.`centre` AS `centre_1` from (`altesse_smartnephro`.`medecins` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`medecins`.`medecin_centre_code_1` = `altesse_smartnephro`.`centres`.`centre_code`)))

  14. medecins_centres_2
    15. select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_2` AS `medecin_centre_code_2`,`altesse_smartnephro`.`centres`.`centre` AS `centre_2` from (`altesse_smartnephro`.`medecins` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`medecins`.`medecin_centre_code_2` = `altesse_smartnephro`.`centres`.`centre_code`)))

  15. medecins_centres_3
    16. select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_3` AS `medecin_centre_code_3`,`altesse_smartnephro`.`centres`.`centre` AS `centre_3` from (`altesse_smartnephro`.`medecins` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`medecins`.`medecin_centre_code_3` = `altesse_smartnephro`.`centres`.`centre_code`)))

  16. medecins_centres_4
    17. select `medecins_centres_1`.`id` AS `id`,`medecins_centres_1`.`medecin_appelation` AS `medecin_appelation`,`medecins_centres_1`.`medecin_nom` AS `medecin_nom`,`medecins_centres_1`.`medecin_prenom` AS `medecin_prenom`,`medecins_centres_1`.`medecin_sexe` AS `medecin_sexe`,`medecins_centres_1`.`medecin_ddn` AS `medecin_ddn`,`medecins_centres_1`.`num_onmci` AS `num_onmci`,`medecins_centres_1`.`medecin_code` AS `medecin_code`,`medecins_centres_1`.`medecin_statut` AS `medecin_statut`,`medecins_centres_1`.`medecin_statut_autre` AS `medecin_statut_autre`,`medecins_centres_1`.`medecin_centre_code_1` AS `medecin_centre_code_1`,`medecins_centres_1`.`medecin_centre_role_1` AS `medecin_centre_role_1`,`medecins_centres_1`.`medecin_centre_code_2` AS `medecin_centre_code_2`,`medecins_centres_1`.`medecin_centre_role_2` AS `medecin_centre_role_2`,`medecins_centres_1`.`medecin_centre_code_3` AS `medecin_centre_code_3`,`medecins_centres_1`.`medecin_centre_role_3` AS `medecin_centre_role_3`,`medecins_centres_1`.`medecin_sineph` AS `medecin_sineph`,`medecins_centres_1`.`medecin_sineph_annee` AS `medecin_sineph_annee`,`medecins_centres_1`.`medecin_sineph_role` AS `medecin_sineph_role`,`medecins_centres_1`.`medecin_tel_1` AS `medecin_tel_1`,`medecins_centres_1`.`medecin_tel_2` AS `medecin_tel_2`,`medecins_centres_1`.`medecin_cel_1` AS `medecin_cel_1`,`medecins_centres_1`.`medecin_cel_2` AS `medecin_cel_2`,`medecins_centres_1`.`medecin_fax` AS `medecin_fax`,`medecins_centres_1`.`medecin_email` AS `medecin_email`,`medecins_centres_1`.`medecin_profil` AS `medecin_profil`,`medecins_centres_1`.`medecin_inviter` AS `medecin_inviter`,`medecins_centres_1`.`medecin_inviter_date` AS `medecin_inviter_date`,`medecins_centres_1`.`medecin_code_invitation` AS `medecin_code_invitation`,`medecins_centres_1`.`commentaire` AS `commentaire`,`medecins_centres_1`.`medecin_actif` AS `medecin_actif`,`medecins_centres_1`.`saisie_public_nom` AS `saisie_public_nom`,`medecins_centres_1`.`saisie_public_email` AS `saisie_public_email`,`medecins_centres_1`.`saisie_public_cel` AS `saisie_public_cel`,`medecins_centres_1`.`modif_nom` AS `modif_nom`,`medecins_centres_1`.`modif_email` AS `modif_email`,`medecins_centres_1`.`modif_cel` AS `modif_cel`,`medecins_centres_1`.`date_modif` AS `date_modif`,`medecins_centres_1`.`saisie_par` AS `saisie_par`,`medecins_centres_1`.`modifie_par` AS `modifie_par`,`medecins_centres_1`.`dates` AS `dates`,`medecins_centres_1`.`centre_1` AS `centre_1`,`medecins_centres_2`.`centre_2` AS `centre_2` from (`altesse_smartnephro`.`medecins_centres_1` left join `altesse_smartnephro`.`medecins_centres_2` on((`medecins_centres_1`.`id` = `medecins_centres_2`.`id`)))

  17. medecins_cotisations_contact
    18. select `altesse_smartnephro`.`medecins_cotisations`.`id` AS `id`,`altesse_smartnephro`.`medecins_cotisations`.`medecin_code` AS `medecin_code`,`altesse_smartnephro`.`medecins_cotisations`.`commentaire` AS `commentaire`,`altesse_smartnephro`.`medecins_cotisations`.`cotis_type` AS `cotis_type`,`altesse_smartnephro`.`medecins_cotisations`.`cotis_annee` AS `cotis_annee`,`altesse_smartnephro`.`medecins_cotisations`.`cotis_somme` AS `cotis_somme`,`altesse_smartnephro`.`medecins_cotisations`.`cotis_date` AS `cotis_date`,`altesse_smartnephro`.`medecins_cotisations`.`cotis_statut` AS `cotis_statut`,`altesse_smartnephro`.`medecins_cotisations`.`saisie_public_nom` AS `saisie_public_nom`,`altesse_smartnephro`.`medecins_cotisations`.`saisie_public_email` AS `saisie_public_email`,`altesse_smartnephro`.`medecins_cotisations`.`saisie_public_cel` AS `saisie_public_cel`,`altesse_smartnephro`.`medecins_cotisations`.`modif_nom` AS `modif_nom`,`altesse_smartnephro`.`medecins_cotisations`.`modif_email` AS `modif_email`,`altesse_smartnephro`.`medecins_cotisations`.`modif_cel` AS `modif_cel`,`altesse_smartnephro`.`medecins_cotisations`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`medecins_cotisations`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`medecins_cotisations`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`medecins_cotisations`.`dates` AS `dates`,`altesse_smartnephro`.`medecins`.`medecin_nom` AS `medecin_nom`,`altesse_smartnephro`.`medecins`.`medecin_prenom` AS `medecin_prenom`,`altesse_smartnephro`.`medecins`.`medecin_statut` AS `medecin_statut`,`altesse_smartnephro`.`medecins`.`medecin_sineph` AS `medecin_sineph`,`altesse_smartnephro`.`medecins`.`medecin_sineph_annee` AS `medecin_sineph_annee`,`altesse_smartnephro`.`medecins`.`medecin_sineph_role` AS `medecin_sineph_role`,`altesse_smartnephro`.`medecins`.`medecin_tel_1` AS `medecin_tel_1`,`altesse_smartnephro`.`medecins`.`medecin_tel_2` AS `medecin_tel_2`,`altesse_smartnephro`.`medecins`.`medecin_cel_1` AS `medecin_cel_1`,`altesse_smartnephro`.`medecins`.`medecin_cel_2` AS `medecin_cel_2`,`altesse_smartnephro`.`medecins`.`medecin_email` AS `medecin_email` from (`altesse_smartnephro`.`medecins_cotisations` left join `altesse_smartnephro`.`medecins` on((`altesse_smartnephro`.`medecins_cotisations`.`medecin_code` = `altesse_smartnephro`.`medecins`.`medecin_code`)))

  18. medecins_par_centre
    19. select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_nom` AS `medecin_nom`,`altesse_smartnephro`.`medecins`.`medecin_prenom` AS `medecin_prenom`,`altesse_smartnephro`.`medecins`.`medecin_sexe` AS `medecin_sexe`,`altesse_smartnephro`.`medecins`.`medecin_statut` AS `medecin_statut`,`altesse_smartnephro`.`medecins`.`medecin_sineph` AS `medecin_sineph`,`altesse_smartnephro`.`medecins`.`medecin_sineph_role` AS `medecin_sineph_role`,`altesse_smartnephro`.`medecins`.`medecin_tel_1` AS `medecin_tel_1`,`altesse_smartnephro`.`medecins`.`medecin_cel_1` AS `medecin_cel_1`,`altesse_smartnephro`.`medecins`.`medecin_email` AS `medecin_email`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_1` AS `centre`,`altesse_smartnephro`.`medecins`.`medecin_centre_role_1` AS `role` from `altesse_smartnephro`.`medecins` where (length(`altesse_smartnephro`.`medecins`.`medecin_centre_code_1`) > 4) union all select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_nom` AS `medecin_nom`,`altesse_smartnephro`.`medecins`.`medecin_prenom` AS `medecin_prenom`,`altesse_smartnephro`.`medecins`.`medecin_sexe` AS `medecin_sexe`,`altesse_smartnephro`.`medecins`.`medecin_statut` AS `medecin_statut`,`altesse_smartnephro`.`medecins`.`medecin_sineph` AS `medecin_sineph`,`altesse_smartnephro`.`medecins`.`medecin_sineph_role` AS `medecin_sineph_role`,`altesse_smartnephro`.`medecins`.`medecin_tel_1` AS `medecin_tel_1`,`altesse_smartnephro`.`medecins`.`medecin_cel_1` AS `medecin_cel_1`,`altesse_smartnephro`.`medecins`.`medecin_email` AS `medecin_email`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_2` AS `centre`,`altesse_smartnephro`.`medecins`.`medecin_centre_role_2` AS `role` from `altesse_smartnephro`.`medecins` where (length(`altesse_smartnephro`.`medecins`.`medecin_centre_code_2`) > 4) union all select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_nom` AS `medecin_nom`,`altesse_smartnephro`.`medecins`.`medecin_prenom` AS `medecin_prenom`,`altesse_smartnephro`.`medecins`.`medecin_sexe` AS `medecin_sexe`,`altesse_smartnephro`.`medecins`.`medecin_statut` AS `medecin_statut`,`altesse_smartnephro`.`medecins`.`medecin_sineph` AS `medecin_sineph`,`altesse_smartnephro`.`medecins`.`medecin_sineph_role` AS `medecin_sineph_role`,`altesse_smartnephro`.`medecins`.`medecin_tel_1` AS `medecin_tel_1`,`altesse_smartnephro`.`medecins`.`medecin_cel_1` AS `medecin_cel_1`,`altesse_smartnephro`.`medecins`.`medecin_email` AS `medecin_email`,`altesse_smartnephro`.`medecins`.`medecin_centre_code_3` AS `centre`,`altesse_smartnephro`.`medecins`.`medecin_centre_role_3` AS `role` from `altesse_smartnephro`.`medecins` where (length(`altesse_smartnephro`.`medecins`.`medecin_centre_code_3`) > 4) order by `medecin_nom`,`medecin_prenom`

  19. medecins_par_centre_ville
    20. select `medecins_par_centre`.`id` AS `id`,`medecins_par_centre`.`medecin_nom` AS `medecin_nom`,`medecins_par_centre`.`medecin_prenom` AS `medecin_prenom`,`medecins_par_centre`.`medecin_sexe` AS `medecin_sexe`,`medecins_par_centre`.`medecin_statut` AS `medecin_statut`,`medecins_par_centre`.`medecin_sineph` AS `medecin_sineph`,`medecins_par_centre`.`medecin_sineph_role` AS `medecin_sineph_role`,`medecins_par_centre`.`medecin_tel_1` AS `medecin_tel_1`,`medecins_par_centre`.`medecin_cel_1` AS `medecin_cel_1`,`medecins_par_centre`.`medecin_email` AS `medecin_email`,`medecins_par_centre`.`centre` AS `centre`,`medecins_par_centre`.`role` AS `role`,`altesse_smartnephro`.`centres`.`centre` AS `lecentre`,`altesse_smartnephro`.`centres`.`type_centre` AS `Type`,`altesse_smartnephro`.`centres`.`ville` AS `ville`,`altesse_smartnephro`.`centres`.`centre_nephrologues` AS `centre_nephrologues`,`altesse_smartnephro`.`centres`.`centre_actif` AS `centre_actif` from (`altesse_smartnephro`.`medecins_par_centre` left join `altesse_smartnephro`.`centres` on((`medecins_par_centre`.`centre` = `altesse_smartnephro`.`centres`.`centre_code`)))

  20. medecins_role_centre
    21. select distinct `altesse_smartnephro`.`role`.`role` AS `role` from `altesse_smartnephro`.`role` where (`altesse_smartnephro`.`role`.`membership_type` = 'medecin')

  21. medecins_stat_1
    22. select `altesse_smartnephro`.`medecins`.`id` AS `id`,`altesse_smartnephro`.`medecins`.`medecin_appelation` AS `medecin_appelation`,`altesse_smartnephro`.`medecins`.`medecin_nom` AS `medecin_nom`,`altesse_smartnephro`.`medecins`.`medecin_prenom` AS `medecin_prenom`,`altesse_smartnephro`.`medecins`.`medecin_sexe` AS `medecin_sexe`,`altesse_smartnephro`.`medecins`.`num_onmci` AS `num_onmci`,`altesse_smartnephro`.`medecins`.`medecin_code` AS `medecin_code`,`altesse_smartnephro`.`medecins`.`medecin_statut` AS `medecin_statut`,(case when (`altesse_smartnephro`.`medecins`.`medecin_sineph` like '%oui%') then 'Membre' when (`altesse_smartnephro`.`medecins`.`medecin_sineph` like '%non%') then 'Non Membre' else 'Membre Inconnu' end) AS `SINEPH`,`altesse_smartnephro`.`medecins`.`medecin_sineph_annee` AS `medecin_sineph_annee`,`altesse_smartnephro`.`medecins`.`medecin_sineph_role` AS `medecin_sineph_role`,`altesse_smartnephro`.`medecins`.`medecin_actif` AS `medecin_actif`,(case when (`altesse_smartnephro`.`medecins`.`medecin_statut` like '%Formation%') then 'En Formation de Néphrologue' when (`altesse_smartnephro`.`medecins`.`medecin_statut` like '%Néphrologue%') then 'Néphrologue' else 'Autre Spécialité' end) AS `lestatut` from `altesse_smartnephro`.`medecins`

  22. medecins_stat_2
    23. select count(`medecins_stat_1`.`id`) AS `totalmedecin`,`medecins_stat_1`.`lestatut` AS `Statut`,`medecins_stat_1`.`medecin_sexe` AS `Sexe`,`medecins_stat_1`.`SINEPH` AS `SINEPH`,`medecins_stat_1`.`medecin_sineph_annee` AS `medecin_sineph_annee`,`medecins_stat_1`.`medecin_actif` AS `medecin_actif` from `altesse_smartnephro`.`medecins_stat_1` group by `medecins_stat_1`.`lestatut`,`medecins_stat_1`.`medecin_sexe`,`medecins_stat_1`.`SINEPH`,`medecins_stat_1`.`medecin_sineph_annee`,`medecins_stat_1`.`medecin_actif`

  23. medecins_stat_2a
    24. select `p`.`Statut` AS `Statut`,`p`.`SINEPH` AS `SINEPH`,concat(`p`.`SINEPH`,' ',`p`.`Statut`) AS `groupe`,`p`.`medecin_actif` AS `medecin_actif`,sum(if((`p`.`Sexe` = 'Masculin'),`p`.`totalmedecin`,NULL)) AS `Masculin`,sum(if((`p`.`Sexe` = 'Feminin'),`p`.`totalmedecin`,NULL)) AS `Féminin` from `altesse_smartnephro`.`medecins_stat_2` `p` group by `p`.`Statut`,`p`.`SINEPH`,`groupe`,`p`.`medecin_actif`

  24. medecins_stat_2b
    25. select count(`medecins_stat_1`.`id`) AS `totalmedecin`,`medecins_stat_1`.`lestatut` AS `Statut`,`medecins_stat_1`.`medecin_actif` AS `medecin_actif` from `altesse_smartnephro`.`medecins_stat_1` group by `medecins_stat_1`.`lestatut`,`medecins_stat_1`.`medecin_actif`

  25. medecins_stat_2c
    26. select count(`medecins_stat_1`.`id`) AS `totalmedecin`,`medecins_stat_1`.`SINEPH` AS `SINEPH`,`medecins_stat_1`.`medecin_actif` AS `medecin_actif` from `altesse_smartnephro`.`medecins_stat_1` where (not((`medecins_stat_1`.`medecin_statut` like '%Autre%'))) group by `medecins_stat_1`.`SINEPH`,`medecins_stat_1`.`medecin_actif`

  26. medecins_stat_3
    27. select `p`.`Statut` AS `Statut`,sum(if((`p`.`Sexe` = 'Masculin'),`p`.`totalmedecin`,NULL)) AS `Masculin`,sum(if((`p`.`Sexe` = 'Feminin'),`p`.`totalmedecin`,NULL)) AS `Féminin` from `altesse_smartnephro`.`medecins_stat_2` `p` group by `p`.`Statut`

  27. medecins_stat_4
    28. select `medecins_stat_3`.`Statut` AS `Statut`,`medecins_stat_3`.`Masculin` AS `Masculin`,`medecins_stat_3`.`Féminin` AS `Feminin` from `altesse_smartnephro`.`medecins_stat_3`

  28. patients_a
    29. select `altesse_smartnephro`.`patients_identification_demographiques`.`id` AS `id`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_identification_temporaire` AS `patient_identification_temporaire`,replace(`altesse_smartnephro`.`patients_identification_demographiques`.`patient_identification_temporaire`,'P','') AS `patient_identification_temporaire2`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_numero_identification` AS `patient_numero_identification`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_nom` AS `patient_nom`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_prenom` AS `patient_prenom`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_date_naissance` AS `patient_date_naissance`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_age_remplissage` AS `patient_age_remplissage`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_ville_naissance` AS `patient_ville_naissance`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_pays_naissance` AS `patient_pays_naissance`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_sexe` AS `patient_sexe`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_commentaire` AS `patient_commentaire`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_inclusion_code` AS `centre_inclusion_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`patients_identification_demographiques`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`patients_identification_demographiques`.`dates` AS `dates` from `altesse_smartnephro`.`patients_identification_demographiques`

  29. patients_age_groupe
    30. select `patients_identification_demographiques_ok`.`id` AS `id`,`patients_identification_demographiques_ok`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_identification_demographiques_ok`.`patient_numero_identification` AS `patient_numero_identification`,`patients_identification_demographiques_ok`.`patient_code` AS `patient_code`,`patients_identification_demographiques_ok`.`patient_sexe` AS `patient_sexe`,`patients_identification_demographiques_ok`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_identification_demographiques_ok`.`annee_remplissage` AS `annee_remplissage`,`patients_identification_demographiques_ok`.`patient_epi` AS `patient_epi`,(case when (`patients_identification_demographiques_ok`.`patient_age_remplissage` < 20) then '< 20' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` between 20 and 29) then '20 - 29' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` between 30 and 39) then '30 - 39' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` between 40 and 49) then '40 - 49' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` between 50 and 59) then '50 - 59' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` between 60 and 69) then '60 - 69' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` >= 70) then '70 - plus' else 'ND' end) AS `age_groupe` from `altesse_smartnephro`.`patients_identification_demographiques_ok`

  30. patients_age_groupe_1
    31. select count(`patients_age_groupe`.`id`) AS `totalpatients`,`patients_age_groupe`.`age_groupe` AS `groupe`,`patients_age_groupe`.`patient_sexe` AS `Sexe`,`patients_age_groupe`.`annee_remplissage` AS `annee_remplissage`,`patients_age_groupe`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_age_groupe` group by `patients_age_groupe`.`annee_remplissage`,`groupe`,`Sexe`,`patients_age_groupe`.`patient_epi`

  31. patients_age_groupe_2
    32. select `p`.`groupe` AS `groupe`,`p`.`annee_remplissage` AS `annee_remplissage`,sum(if((`p`.`Sexe` = 'Masculin'),`p`.`totalpatients`,NULL)) AS `Masculin`,sum(if((`p`.`Sexe` = 'Feminin'),`p`.`totalpatients`,NULL)) AS `Féminin`,`p`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_age_groupe_1` `p` group by `p`.`groupe`,`p`.`annee_remplissage`,`p`.`patient_epi`

  32. patients_age_groupe_3
    33. select `patients_age_groupe_2`.`annee_remplissage` AS `annee_remplissage`,`patients_age_groupe_2`.`groupe` AS `groupe`,`patients_age_groupe_2`.`Masculin` AS `Masculin`,`patients_age_groupe_2`.`Féminin` AS `Feminin`,`patients_age_groupe_2`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_age_groupe_2`

  33. patients_b
    34. select `patients_a`.`patient_date_remplissage` AS `patient_date_remplissage`,`patients_a`.`patient_identification_temporaire` AS `patient_identification_temporaire`,cast(substring_index(`patients_a`.`patient_identification_temporaire2`,'-',-(1)) as unsigned) AS `num`,`patients_a`.`patient_numero_identification` AS `patient_numero_identification`,`patients_a`.`patient_nom` AS `patient_nom`,`patients_a`.`patient_prenom` AS `patient_prenom`,`patients_a`.`patient_code` AS `patient_code`,`patients_a`.`patient_date_naissance` AS `patient_date_naissance`,`patients_a`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_a`.`patient_ville_naissance` AS `patient_ville_naissance`,`patients_a`.`patient_pays_naissance` AS `patient_pays_naissance`,`patients_a`.`patient_sexe` AS `patient_sexe`,`patients_a`.`patient_commentaire` AS `patient_commentaire`,`patients_a`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_a`.`saisie_par` AS `saisie_par`,`patients_a`.`modifie_par` AS `modifie_par`,`patients_a`.`dates` AS `dates` from `altesse_smartnephro`.`patients_a` order by cast(substring_index(`patients_a`.`patient_identification_temporaire2`,'-',-(1)) as unsigned)

  34. patients_c
    35. select `patients_b`.`num` AS `id`,`patients_b`.`patient_date_remplissage` AS `patient_date_remplissage`,`patients_b`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_b`.`patient_numero_identification` AS `patient_numero_identification`,`patients_b`.`patient_nom` AS `patient_nom`,`patients_b`.`patient_prenom` AS `patient_prenom`,`patients_b`.`patient_code` AS `patient_code`,`patients_b`.`patient_date_naissance` AS `patient_date_naissance`,`patients_b`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_b`.`patient_ville_naissance` AS `patient_ville_naissance`,`patients_b`.`patient_pays_naissance` AS `patient_pays_naissance`,`patients_b`.`patient_sexe` AS `patient_sexe`,`patients_b`.`patient_commentaire` AS `patient_commentaire`,`patients_b`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_b`.`saisie_par` AS `saisie_par`,`patients_b`.`modifie_par` AS `modifie_par`,`patients_b`.`dates` AS `dates` from `altesse_smartnephro`.`patients_b` order by `patients_b`.`num`

  35. patients_centre
    36. select count(`altesse_smartnephro`.`patients_identification_demographiques`.`id`) AS `totalpatients`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_inclusion_code` AS `centre_inclusion_code` from `altesse_smartnephro`.`patients_identification_demographiques` group by `altesse_smartnephro`.`patients_identification_demographiques`.`centre_inclusion_code`

  36. patients_centre_ok
    37. select `altesse_smartnephro`.`centres`.`id` AS `id`,`altesse_smartnephro`.`centres`.`pays` AS `pays`,`altesse_smartnephro`.`centres`.`ville` AS `ville`,`altesse_smartnephro`.`centres`.`centre` AS `centre`,`altesse_smartnephro`.`centres`.`centre_code` AS `centre_code`,`altesse_smartnephro`.`centres`.`date_remplissage` AS `date_remplissage`,`altesse_smartnephro`.`centres`.`code_du_centre` AS `code_du_centre`,`altesse_smartnephro`.`centres`.`type_centre` AS `type_centre`,`altesse_smartnephro`.`centres`.`centre_generateurs` AS `centre_generateurs`,`altesse_smartnephro`.`centres`.`centre_generateurs_details` AS `centre_generateurs_details`,`altesse_smartnephro`.`centres`.`centre_nephrologues` AS `centre_nephrologues`,`altesse_smartnephro`.`centres`.`centre_infirmiers` AS `centre_infirmiers`,`altesse_smartnephro`.`centres`.`centre_aide_soignants` AS `centre_aide_soignants`,`altesse_smartnephro`.`centres`.`centre_techniciens` AS `centre_techniciens`,`altesse_smartnephro`.`centres`.`centre_patients` AS `centre_patients`,`altesse_smartnephro`.`centres`.`centre_adresse` AS `centre_adresse`,`altesse_smartnephro`.`centres`.`centre_telephone_1` AS `centre_telephone_1`,`altesse_smartnephro`.`centres`.`centre_telephone_2` AS `centre_telephone_2`,`altesse_smartnephro`.`centres`.`centre_fax` AS `centre_fax`,`altesse_smartnephro`.`centres`.`centre_email` AS `centre_email`,`altesse_smartnephro`.`centres`.`centre_actif` AS `centre_actif`,`altesse_smartnephro`.`centres`.`centre_date_creation` AS `centre_date_creation`,`altesse_smartnephro`.`centres`.`centre_saisie_public_nom` AS `centre_saisie_public_nom`,`altesse_smartnephro`.`centres`.`centre_saisie_public_email` AS `centre_saisie_public_email`,`altesse_smartnephro`.`centres`.`centre_saisie_public_cel` AS `centre_saisie_public_cel`,`altesse_smartnephro`.`centres`.`centre_cmtaire` AS `centre_cmtaire`,`altesse_smartnephro`.`centres`.`centre_modif_nom` AS `centre_modif_nom`,`altesse_smartnephro`.`centres`.`centre_modif_email` AS `centre_modif_email`,`altesse_smartnephro`.`centres`.`centre_modif_cel` AS `centre_modif_cel`,`altesse_smartnephro`.`centres`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`centres`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`centres`.`dates` AS `dates`,`altesse_smartnephro`.`centres`.`date_modif` AS `date_modif`,`patients_centre`.`totalpatients` AS `totalpatients`,`patients_centre`.`centre_inclusion_code` AS `centre_inclusion_code` from (`altesse_smartnephro`.`centres` left join `altesse_smartnephro`.`patients_centre` on((`patients_centre`.`centre_inclusion_code` = `altesse_smartnephro`.`centres`.`centre_code`)))

  37. patients_delai
    38. select `patients_delai_merge_diff`.`id` AS `id`,`patients_delai_merge_diff`.`patient_code` AS `patient_code`,`patients_delai_merge_diff`.`patient_numero_identification` AS `patient_numero_identification`,`patients_delai_merge_diff`.`patient_statut` AS `patient_statut`,`patients_delai_merge_diff`.`patient_consent` AS `patient_consent`,`patients_delai_merge_diff`.`patient_date_remplissage` AS `patient_date_remplissage`,`patients_delai_merge_diff`.`contexte_statut` AS `contexte_statut`,`patients_delai_merge_diff`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_merge_diff`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_merge_diff`.`contexte_dialyse` AS `contexte_dialyse`,`patients_delai_merge_diff`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_merge_diff`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_merge_diff`.`contexte_greffe` AS `contexte_greffe`,`patients_delai_merge_diff`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_delai_merge_diff`.`centre_primaire` AS `centre_primaire`,`patients_delai_merge_diff`.`centre_secondaire` AS `centre_secondaire`,`patients_delai_merge_diff`.`centre_transfert` AS `centre_transfert`,`patients_delai_merge_diff`.`centre` AS `centre`,`patients_delai_merge_diff`.`ladifference_dialyse_1` AS `ladifference_dialyse_1`,`patients_delai_merge_diff`.`ladifference_greffe_1` AS `ladifference_greffe_1`,(`patients_delai_merge_diff`.`ladifference_dialyse_1` + 0) AS `ladifference_dialyse`,(`patients_delai_merge_diff`.`ladifference_greffe_1` + 0) AS `ladifference_greffe` from `altesse_smartnephro`.`patients_delai_merge_diff` where ((`patients_delai_merge_diff`.`contexte_dialyse` = 'Démarrage de la dialyse') or (`patients_delai_merge_diff`.`contexte_greffe` = 'Greffe rénale'))

  38. patients_delai_changement
    39. select `patients_identification_demographiques_ok`.`id` AS `id`,`patients_delai_changement_2`.`patient_code` AS `patient_code`,`patients_delai_changement_2`.`date_debut_traitement` AS `date_debut_traitement`,`patients_delai_changement_2`.`date_remplissage_traitement` AS `date_remplissage_traitement`,`patients_delai_changement_2`.`contexte_traitement` AS `contexte_traitement`,`patients_delai_changement_2`.`contexte_deces` AS `contexte_deces`,`patients_delai_changement_2`.`evenement` AS `evenement`,`patients_delai_changement_2`.`la_date_deces` AS `la_date_deces`,`patients_delai_changement_2`.`diff_debut_traitment_deces` AS `diff_debut_traitment_deces`,`patients_identification_demographiques_ok`.`patient_numero_identification` AS `patient_numero_identification`,`patients_identification_demographiques_ok`.`patient_statut` AS `patient_statut`,`patients_identification_demographiques_ok`.`patient_consent` AS `patient_consent`,`patients_identification_demographiques_ok`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_identification_demographiques_ok`.`centre_primaire` AS `centre_primaire`,`patients_identification_demographiques_ok`.`centre_secondaire` AS `centre_secondaire`,`patients_identification_demographiques_ok`.`centre_transfert` AS `centre_transfert`,`patients_identification_demographiques_ok`.`centre` AS `centre`,`patients_identification_demographiques_ok`.`contexte_statut` AS `contexte_statut`,(`patients_delai_changement_2`.`diff_debut_traitment_deces` + 0) AS `ladiff_debut_traitment_deces` from (`altesse_smartnephro`.`patients_delai_changement_2` left join `altesse_smartnephro`.`patients_identification_demographiques_ok` on((`patients_identification_demographiques_ok`.`patient_code` = `patients_delai_changement_2`.`patient_code`)))

  39. patients_delai_changement_1
    40. select `altesse_smartnephro`.`patients_traitement`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_traitement`.`date_debut_traitement` AS `date_debut_traitement`,`altesse_smartnephro`.`patients_traitement`.`patient_date_remplissage` AS `date_remplissage_traitement`,`altesse_smartnephro`.`patients_traitement`.`contexte_statut` AS `contexte_traitement` from `altesse_smartnephro`.`patients_traitement` where ((`altesse_smartnephro`.`patients_traitement`.`contexte_statut` = 'Démarrage de la dialyse') and `altesse_smartnephro`.`patients_traitement`.`date_debut_traitement` in (select min(`altesse_smartnephro`.`patients_traitement`.`date_debut_traitement`) from `altesse_smartnephro`.`patients_traitement` group by `altesse_smartnephro`.`patients_traitement`.`patient_code`)) union all select `altesse_smartnephro`.`patients_traitement`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_traitement`.`date_debut_traitement` AS `date_debut_traitement`,`altesse_smartnephro`.`patients_traitement`.`patient_date_remplissage` AS `date_remplissage_traitement`,`altesse_smartnephro`.`patients_traitement`.`contexte_statut` AS `contexte_traitement` from `altesse_smartnephro`.`patients_traitement` where ((`altesse_smartnephro`.`patients_traitement`.`contexte_statut` = 'Greffe rénale') and `altesse_smartnephro`.`patients_traitement`.`date_debut_traitement` in (select min(`altesse_smartnephro`.`patients_traitement`.`date_debut_traitement`) from `altesse_smartnephro`.`patients_traitement` group by `altesse_smartnephro`.`patients_traitement`.`patient_code`)) order by `patient_code`,`date_debut_traitement`

  40. patients_delai_changement_2
    41. select `patients_delai_changement_1`.`patient_code` AS `patient_code`,`patients_delai_changement_1`.`date_debut_traitement` AS `date_debut_traitement`,`patients_delai_changement_1`.`date_remplissage_traitement` AS `date_remplissage_traitement`,`patients_delai_changement_1`.`contexte_traitement` AS `contexte_traitement`,`altesse_smartnephro`.`patients_sortie`.`contexte_statut` AS `contexte_deces`,`altesse_smartnephro`.`patients_sortie`.`evenement` AS `evenement`,(case when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and isnull(`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement`)) then `altesse_smartnephro`.`patients_sortie`.`date_deces` when (isnull(`altesse_smartnephro`.`patients_sortie`.`date_deces`) and (`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` is not null)) then `altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and (`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` is not null)) then `altesse_smartnephro`.`patients_sortie`.`date_deces` else '' end) AS `la_date_deces`,(case when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and isnull(`patients_delai_changement_1`.`date_debut_traitement`)) then (to_days(`altesse_smartnephro`.`patients_sortie`.`date_deces`) - to_days(`patients_delai_changement_1`.`date_debut_traitement`)) when (isnull(`altesse_smartnephro`.`patients_sortie`.`date_deces`) and (`patients_delai_changement_1`.`date_debut_traitement` is not null)) then (to_days(`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement`) - to_days(`patients_delai_changement_1`.`date_debut_traitement`)) when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and (`patients_delai_changement_1`.`date_debut_traitement` is not null)) then (to_days(`altesse_smartnephro`.`patients_sortie`.`date_deces`) - to_days(`patients_delai_changement_1`.`date_debut_traitement`)) else '' end) AS `diff_debut_traitment_deces` from (`altesse_smartnephro`.`patients_delai_changement_1` left join `altesse_smartnephro`.`patients_sortie` on((`altesse_smartnephro`.`patients_sortie`.`patient_code` = `patients_delai_changement_1`.`patient_code`))) where ((`altesse_smartnephro`.`patients_sortie`.`evenement` = 'DECES') or (`altesse_smartnephro`.`patients_sortie`.`contexte_statut` = 'Décès'))

  41. patients_delai_dialyse
    42. select `patients_delai_dialyse_all`.`patient_code` AS `patient_code`,`patients_delai_dialyse_all`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_dialyse_all`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_dialyse_all`.`contexte_dialyse` AS `contexte_dialyse` from `altesse_smartnephro`.`patients_delai_dialyse_all` where `patients_delai_dialyse_all`.`debut_traitement_dialyse` in (select min(`patients_delai_dialyse_all`.`debut_traitement_dialyse`) from `altesse_smartnephro`.`patients_delai_dialyse_all` group by `patients_delai_dialyse_all`.`patient_code`)

  42. patients_delai_dialyse_1
    43. select `patients_delai_dialyse`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_dialyse`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_dialyse`.`contexte_dialyse` AS `contexte_dialyse`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`contexte_statut` AS `contexte_statut` from (`altesse_smartnephro`.`patients_identification_demographiques` left join `altesse_smartnephro`.`patients_delai_dialyse` on((`altesse_smartnephro`.`patients_identification_demographiques`.`patient_code` = `patients_delai_dialyse`.`patient_code`)))

  43. patients_delai_dialyse_all
    44. select `altesse_smartnephro`.`patients_point_annuel`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_point_annuel`.`date_point_annuel` AS `debut_traitement_dialyse`,`altesse_smartnephro`.`patients_point_annuel`.`patient_date_remplissage` AS `date_remplissage_dialyse`,'Démarrage de la dialyse' AS `contexte_dialyse` from `altesse_smartnephro`.`patients_point_annuel` where (`altesse_smartnephro`.`patients_point_annuel`.`contexte_statut` = 'Dialysé') union all select `altesse_smartnephro`.`patients_traitement`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_traitement`.`date_debut_traitement` AS `debut_traitement_dialyse`,`altesse_smartnephro`.`patients_traitement`.`patient_date_remplissage` AS `date_remplissage_dialyse`,`altesse_smartnephro`.`patients_traitement`.`contexte_statut` AS `contexte_dialyse` from `altesse_smartnephro`.`patients_traitement` where (`altesse_smartnephro`.`patients_traitement`.`contexte_statut` = 'Démarrage de la dialyse')

  44. patients_delai_greffe
    45. select `patients_delai_greffe_all`.`patient_code` AS `patient_code`,`patients_delai_greffe_all`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_greffe_all`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_greffe_all`.`contexte_greffe` AS `contexte_greffe` from `altesse_smartnephro`.`patients_delai_greffe_all` where `patients_delai_greffe_all`.`debut_traitement_greffe` in (select min(`patients_delai_greffe_all`.`debut_traitement_greffe`) from `altesse_smartnephro`.`patients_delai_greffe_all` group by `patients_delai_greffe_all`.`patient_code`)

  45. patients_delai_greffe_1
    46. select `patients_delai_greffe`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_greffe`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_greffe`.`contexte_greffe` AS `contexte_greffe`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`contexte_statut` AS `contexte_statut` from (`altesse_smartnephro`.`patients_identification_demographiques` left join `altesse_smartnephro`.`patients_delai_greffe` on((`altesse_smartnephro`.`patients_identification_demographiques`.`patient_code` = `patients_delai_greffe`.`patient_code`)))

  46. patients_delai_greffe_all
    47. select `altesse_smartnephro`.`patients_point_annuel`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_point_annuel`.`date_point_annuel` AS `debut_traitement_greffe`,`altesse_smartnephro`.`patients_point_annuel`.`patient_date_remplissage` AS `date_remplissage_greffe`,'Greffe rénale' AS `contexte_greffe` from `altesse_smartnephro`.`patients_point_annuel` where (`altesse_smartnephro`.`patients_point_annuel`.`contexte_statut` = 'Greffé') union all select `altesse_smartnephro`.`patients_traitement`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_traitement`.`date_debut_traitement` AS `debut_traitement_greffe`,`altesse_smartnephro`.`patients_traitement`.`patient_date_remplissage` AS `date_remplissage_greffe`,`altesse_smartnephro`.`patients_traitement`.`contexte_statut` AS `contexte_greffe` from `altesse_smartnephro`.`patients_traitement` where (`altesse_smartnephro`.`patients_traitement`.`contexte_statut` = 'Greffe rénale')

  47. patients_delai_merge
    48. select `patients_delai_dialyse_1`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_dialyse_1`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_dialyse_1`.`contexte_dialyse` AS `contexte_dialyse`,`patients_delai_dialyse_1`.`patient_code` AS `patient_code`,`patients_delai_dialyse_1`.`contexte_statut` AS `contexte_statut`,`patients_delai_greffe_1`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_greffe_1`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_greffe_1`.`contexte_greffe` AS `contexte_greffe` from (`altesse_smartnephro`.`patients_delai_dialyse_1` left join `altesse_smartnephro`.`patients_delai_greffe_1` on((`patients_delai_dialyse_1`.`patient_code` = `patients_delai_greffe_1`.`patient_code`)))

  48. patients_delai_merge_diff
    49. select `patients_identification_demographiques_ok`.`id` AS `id`,`patients_identification_demographiques_ok`.`patient_code` AS `patient_code`,`patients_identification_demographiques_ok`.`patient_numero_identification` AS `patient_numero_identification`,`patients_identification_demographiques_ok`.`patient_statut` AS `patient_statut`,`patients_identification_demographiques_ok`.`patient_consent` AS `patient_consent`,`patients_identification_demographiques_ok`.`patient_date_remplissage` AS `patient_date_remplissage`,`patients_identification_demographiques_ok`.`contexte_statut` AS `contexte_statut`,`patients_delai_merge`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_merge`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_merge`.`contexte_dialyse` AS `contexte_dialyse`,`patients_delai_merge`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_merge`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_merge`.`contexte_greffe` AS `contexte_greffe`,`patients_identification_demographiques_ok`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_identification_demographiques_ok`.`centre_primaire` AS `centre_primaire`,`patients_identification_demographiques_ok`.`centre_secondaire` AS `centre_secondaire`,`patients_identification_demographiques_ok`.`centre_transfert` AS `centre_transfert`,`patients_identification_demographiques_ok`.`centre` AS `centre`,(case when ((`patients_delai_merge`.`debut_traitement_dialyse` is not null) and (`patients_identification_demographiques_ok`.`patient_date_remplissage` is not null)) then (to_days(`patients_delai_merge`.`debut_traitement_dialyse`) - to_days(`patients_identification_demographiques_ok`.`patient_date_remplissage`)) else '' end) AS `ladifference_dialyse_1`,(case when ((`patients_delai_merge`.`debut_traitement_greffe` is not null) and (`patients_identification_demographiques_ok`.`patient_date_remplissage` is not null)) then (to_days(`patients_delai_merge`.`debut_traitement_greffe`) - to_days(`patients_identification_demographiques_ok`.`patient_date_remplissage`)) else '' end) AS `ladifference_greffe_1` from (`altesse_smartnephro`.`patients_delai_merge` left join `altesse_smartnephro`.`patients_identification_demographiques_ok` on((`patients_identification_demographiques_ok`.`patient_code` = `patients_delai_merge`.`patient_code`)))

  49. patients_delai_premiere
    50. select `patients_delai_premiere_merge_diff`.`id` AS `id`,`patients_delai_premiere_merge_diff`.`patient_code` AS `patient_code`,`patients_delai_premiere_merge_diff`.`patient_numero_identification` AS `patient_numero_identification`,`patients_delai_premiere_merge_diff`.`patient_statut` AS `patient_statut`,`patients_delai_premiere_merge_diff`.`patient_consent` AS `patient_consent`,`patients_delai_premiere_merge_diff`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`patients_delai_premiere_merge_diff`.`contexte_statut` AS `contexte_statut`,`patients_delai_premiere_merge_diff`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_premiere_merge_diff`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_premiere_merge_diff`.`contexte_dialyse` AS `contexte_dialyse`,`patients_delai_premiere_merge_diff`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_premiere_merge_diff`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_premiere_merge_diff`.`contexte_greffe` AS `contexte_greffe`,`patients_delai_premiere_merge_diff`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_delai_premiere_merge_diff`.`centre_primaire` AS `centre_primaire`,`patients_delai_premiere_merge_diff`.`centre_secondaire` AS `centre_secondaire`,`patients_delai_premiere_merge_diff`.`centre_transfert` AS `centre_transfert`,`patients_delai_premiere_merge_diff`.`centre` AS `centre`,`patients_delai_premiere_merge_diff`.`ladifference_dialyse_1` AS `ladifference_dialyse_1`,`patients_delai_premiere_merge_diff`.`ladifference_greffe_1` AS `ladifference_greffe_1`,(`patients_delai_premiere_merge_diff`.`ladifference_dialyse_1` + 0) AS `ladifference_dialyse`,(`patients_delai_premiere_merge_diff`.`ladifference_greffe_1` + 0) AS `ladifference_greffe` from `altesse_smartnephro`.`patients_delai_premiere_merge_diff` where ((`patients_delai_premiere_merge_diff`.`contexte_dialyse` = 'Démarrage de la dialyse') or (`patients_delai_premiere_merge_diff`.`contexte_greffe` = 'Greffe rénale'))

  50. patients_delai_premiere_merge_diff
    51. select `patients_fiche_initial`.`id` AS `id`,`patients_fiche_initial`.`patient_code` AS `patient_code`,`patients_fiche_initial`.`patient_numero_identification` AS `patient_numero_identification`,`patients_fiche_initial`.`patient_statut` AS `patient_statut`,`patients_fiche_initial`.`patient_consent` AS `patient_consent`,`patients_fiche_initial`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`patients_fiche_initial`.`contexte_statut` AS `contexte_statut`,`patients_delai_merge`.`debut_traitement_dialyse` AS `debut_traitement_dialyse`,`patients_delai_merge`.`date_remplissage_dialyse` AS `date_remplissage_dialyse`,`patients_delai_merge`.`contexte_dialyse` AS `contexte_dialyse`,`patients_delai_merge`.`debut_traitement_greffe` AS `debut_traitement_greffe`,`patients_delai_merge`.`date_remplissage_greffe` AS `date_remplissage_greffe`,`patients_delai_merge`.`contexte_greffe` AS `contexte_greffe`,`patients_fiche_initial`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_fiche_initial`.`centre_primaire` AS `centre_primaire`,`patients_fiche_initial`.`centre_secondaire` AS `centre_secondaire`,`patients_fiche_initial`.`centre_transfert` AS `centre_transfert`,`patients_fiche_initial`.`centre` AS `centre`,(case when ((`patients_delai_merge`.`debut_traitement_dialyse` is not null) and (`patients_fiche_initial`.`premiere_consultatio_nephro_date` is not null)) then (to_days(`patients_delai_merge`.`debut_traitement_dialyse`) - to_days(`patients_fiche_initial`.`premiere_consultatio_nephro_date`)) else '' end) AS `ladifference_dialyse_1`,(case when ((`patients_delai_merge`.`debut_traitement_greffe` is not null) and (`patients_fiche_initial`.`premiere_consultatio_nephro_date` is not null)) then (to_days(`patients_delai_merge`.`debut_traitement_greffe`) - to_days(`patients_fiche_initial`.`premiere_consultatio_nephro_date`)) else '' end) AS `ladifference_greffe_1` from (`altesse_smartnephro`.`patients_delai_merge` left join `altesse_smartnephro`.`patients_fiche_initial` on((`patients_fiche_initial`.`patient_code` = `patients_delai_merge`.`patient_code`)))

  51. patients_delai_suppleance
    52. select `patients_delai_suppleance_3`.`id` AS `id`,`patients_delai_suppleance_3`.`patient_code` AS `patient_code`,`patients_delai_suppleance_3`.`patient_numero_identification` AS `patient_numero_identification`,`patients_delai_suppleance_3`.`patient_statut` AS `patient_statut`,`patients_delai_suppleance_3`.`patient_consent` AS `patient_consent`,`patients_delai_suppleance_3`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_delai_suppleance_3`.`centre_primaire` AS `centre_primaire`,`patients_delai_suppleance_3`.`centre_secondaire` AS `centre_secondaire`,`patients_delai_suppleance_3`.`centre_transfert` AS `centre_transfert`,`patients_delai_suppleance_3`.`centre` AS `centre`,`patients_delai_suppleance_3`.`contexte_statut` AS `contexte_statut`,`patients_delai_suppleance_3`.`contexte_date_remplissage` AS `contexte_date_remplissage`,`patients_delai_suppleance_3`.`contexte_suppleance` AS `contexte_suppleance`,`patients_delai_suppleance_3`.`date_premiere_traitement` AS `date_premiere_traitement`,`patients_delai_suppleance_3`.`fiche` AS `fiche`,`patients_delai_suppleance_3`.`suppleance` AS `suppleance`,`altesse_smartnephro`.`patients_sortie`.`contexte_statut` AS `contexte_deces`,`altesse_smartnephro`.`patients_sortie`.`evenement` AS `evenement`,(case when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and isnull(`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement`)) then `altesse_smartnephro`.`patients_sortie`.`date_deces` when (isnull(`altesse_smartnephro`.`patients_sortie`.`date_deces`) and (`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` is not null)) then `altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and (`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` is not null)) then `altesse_smartnephro`.`patients_sortie`.`date_deces` else '' end) AS `la_date_deces`,(case when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and isnull(`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement`)) then (to_days(`altesse_smartnephro`.`patients_sortie`.`date_deces`) - to_days(`patients_delai_suppleance_3`.`date_premiere_traitement`)) when (isnull(`altesse_smartnephro`.`patients_sortie`.`date_deces`) and (`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` is not null)) then (to_days(`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement`) - to_days(`patients_delai_suppleance_3`.`date_premiere_traitement`)) when ((`altesse_smartnephro`.`patients_sortie`.`date_deces` is not null) and (`altesse_smartnephro`.`patients_sortie`.`date_debut_traitement` is not null)) then (to_days(`altesse_smartnephro`.`patients_sortie`.`date_deces`) - to_days(`patients_delai_suppleance_3`.`date_premiere_traitement`)) else '' end) AS `diff_suppleance_deces` from (`altesse_smartnephro`.`patients_delai_suppleance_3` left join `altesse_smartnephro`.`patients_sortie` on((`altesse_smartnephro`.`patients_sortie`.`patient_code` = `patients_delai_suppleance_3`.`patient_code`))) where ((`altesse_smartnephro`.`patients_sortie`.`evenement` = 'DECES') or (`altesse_smartnephro`.`patients_sortie`.`contexte_statut` = 'Décès'))

  52. patients_delai_suppleance_1
    53. select `altesse_smartnephro`.`patients_initial`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_initial`.`patient_date_remplissage` AS `contexte_date_remplissage`,`altesse_smartnephro`.`patients_initial`.`contexte_statut` AS `contexte_suppleance`,`altesse_smartnephro`.`patients_initial`.`date_premiere_traitement` AS `date_premiere_traitement`,'Déclaration' AS `fiche` from `altesse_smartnephro`.`patients_initial` where (`altesse_smartnephro`.`patients_initial`.`contexte_statut` in ('Greffé','Dialysé')) union all select `altesse_smartnephro`.`patients_point_annuel`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_point_annuel`.`patient_date_remplissage` AS `contexte_date_remplissage`,`altesse_smartnephro`.`patients_point_annuel`.`contexte_statut` AS `contexte_suppleance`,`altesse_smartnephro`.`patients_point_annuel`.`date_premiere_traitement` AS `date_premiere_traitement`,'Annuel' AS `fiche` from `altesse_smartnephro`.`patients_point_annuel` where (`altesse_smartnephro`.`patients_point_annuel`.`contexte_statut` in ('Greffé','Dialysé')) order by `patient_code`,`date_premiere_traitement`

  53. patients_delai_suppleance_2
    54. select `patients_delai_suppleance_1`.`patient_code` AS `patient_code`,`patients_delai_suppleance_1`.`contexte_date_remplissage` AS `contexte_date_remplissage`,`patients_delai_suppleance_1`.`contexte_suppleance` AS `contexte_suppleance`,`patients_delai_suppleance_1`.`date_premiere_traitement` AS `date_premiere_traitement`,`patients_delai_suppleance_1`.`fiche` AS `fiche` from `altesse_smartnephro`.`patients_delai_suppleance_1` where `patients_delai_suppleance_1`.`date_premiere_traitement` in (select min(`patients_delai_suppleance_1`.`date_premiere_traitement`) from `altesse_smartnephro`.`patients_delai_suppleance_1` where (`patients_delai_suppleance_1`.`date_premiere_traitement` is not null) group by `patients_delai_suppleance_1`.`patient_code`) order by `patients_delai_suppleance_1`.`patient_code`

  54. patients_delai_suppleance_3
    55. select `patients_identification_demographiques_ok`.`id` AS `id`,`patients_delai_suppleance_2`.`patient_code` AS `patient_code`,`patients_identification_demographiques_ok`.`patient_numero_identification` AS `patient_numero_identification`,`patients_identification_demographiques_ok`.`patient_statut` AS `patient_statut`,`patients_identification_demographiques_ok`.`patient_consent` AS `patient_consent`,`patients_identification_demographiques_ok`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_identification_demographiques_ok`.`centre_primaire` AS `centre_primaire`,`patients_identification_demographiques_ok`.`centre_secondaire` AS `centre_secondaire`,`patients_identification_demographiques_ok`.`centre_transfert` AS `centre_transfert`,`patients_identification_demographiques_ok`.`centre` AS `centre`,`patients_identification_demographiques_ok`.`contexte_statut` AS `contexte_statut`,`patients_delai_suppleance_2`.`contexte_date_remplissage` AS `contexte_date_remplissage`,`patients_delai_suppleance_2`.`contexte_suppleance` AS `contexte_suppleance`,`patients_delai_suppleance_2`.`date_premiere_traitement` AS `date_premiere_traitement`,`patients_delai_suppleance_2`.`fiche` AS `fiche`,(case when ((`patients_identification_demographiques_ok`.`contexte_statut` = 'Stade V') and (`patients_delai_suppleance_2`.`contexte_suppleance` = 'Dialysé')) then 'Stade V - Dialysé' when ((`patients_identification_demographiques_ok`.`contexte_statut` = 'Stade V') and (`patients_delai_suppleance_2`.`contexte_suppleance` = 'Greffé')) then 'Stade V - Greffé' when ((`patients_identification_demographiques_ok`.`contexte_statut` = 'Dialysé') and (`patients_delai_suppleance_2`.`contexte_suppleance` = 'Dialysé')) then 'Dialysé - Dialysé' when ((`patients_identification_demographiques_ok`.`contexte_statut` = 'Greffé') and (`patients_delai_suppleance_2`.`contexte_suppleance` = 'Greffé')) then 'Greffé - Greffé' else '' end) AS `suppleance` from (`altesse_smartnephro`.`patients_delai_suppleance_2` left join `altesse_smartnephro`.`patients_identification_demographiques_ok` on((`patients_identification_demographiques_ok`.`patient_code` = `patients_delai_suppleance_2`.`patient_code`)))

  55. patients_dossier
    56. select `patients_fiche_initial`.`id` AS `id`,`patients_fiche_initial`.`demo_id` AS `demo_id`,`patients_fiche_initial`.`demo_patient_code` AS `demo_patient_code`,`patients_fiche_initial`.`annee_remplissage` AS `annee_remplissage`,`patients_fiche_initial`.`demo_date_remplissage` AS `demo_date_remplissage`,`patients_fiche_initial`.`patient_date_remplissage` AS `patient_date_remplissage`,`patients_fiche_initial`.`patient_code` AS `patient_code`,`patients_fiche_initial`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_fiche_initial`.`patient_numero_identification` AS `patient_numero_identification`,`patients_fiche_initial`.`patient_nom` AS `patient_nom`,`patients_fiche_initial`.`patient_prenom` AS `patient_prenom`,`patients_fiche_initial`.`patient_sexe` AS `patient_sexe`,`patients_fiche_initial`.`patient_date_naissance` AS `patient_date_naissance`,`patients_fiche_initial`.`centre` AS `centre`,`patients_fiche_initial`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_fiche_initial`.`centre_primaire_dossier` AS `centre_primaire_dossier` from `altesse_smartnephro`.`patients_fiche_initial`

  56. patients_fiche_initial
    57. select `patients_identification_demographiques_ok`.`id` AS `demo_id`,`patients_identification_demographiques_ok`.`patient_code` AS `demo_patient_code`,`patients_identification_demographiques_ok`.`patient_date_remplissage` AS `demo_date_remplissage`,`patients_identification_demographiques_ok`.`patient_epi` AS `patient_epi`,`patients_identification_demographiques_ok`.`patient_statut` AS `patient_statut`,`patients_identification_demographiques_ok`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_identification_demographiques_ok`.`patient_numero_identification` AS `patient_numero_identification`,`patients_identification_demographiques_ok`.`patient_nom` AS `patient_nom`,`patients_identification_demographiques_ok`.`patient_prenom` AS `patient_prenom`,`patients_identification_demographiques_ok`.`annee_remplissage` AS `annee_remplissage`,`patients_identification_demographiques_ok`.`patient_consent` AS `patient_consent`,`patients_identification_demographiques_ok`.`patient_date_naissance` AS `patient_date_naissance`,`patients_identification_demographiques_ok`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_identification_demographiques_ok`.`patient_ville_naissance` AS `patient_ville_naissance`,`patients_identification_demographiques_ok`.`patient_pays_naissance` AS `patient_pays_naissance`,`patients_identification_demographiques_ok`.`patient_sexe` AS `patient_sexe`,`patients_identification_demographiques_ok`.`patient_commentaire` AS `patient_commentaire`,`patients_identification_demographiques_ok`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_identification_demographiques_ok`.`centre` AS `centre`,`patients_identification_demographiques_ok`.`centre_primaire` AS `centre_primaire`,`patients_identification_demographiques_ok`.`centre_secondaire` AS `centre_secondaire`,`patients_identification_demographiques_ok`.`centre_transfert` AS `centre_transfert`,`patients_identification_demographiques_ok`.`centre_primaire_dossier` AS `centre_primaire_dossier`,`patients_identification_demographiques_ok`.`centre_secondaire_dossier` AS `centre_secondaire_dossier`,(case when (`patients_identification_demographiques_ok`.`patient_age_remplissage` < 16) then 'Pédiatriques (<16)' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` >= 16) then 'Adults' else 'ND' end) AS `groupe_age_remplissage`,(case when (`patients_identification_demographiques_ok`.`age` < 16) then 'Pédiatriques (<16)' when (`patients_identification_demographiques_ok`.`age` >= 16) then 'Adults' else 'ND' end) AS `groupe_age_actuel`,`altesse_smartnephro`.`patients_initial`.`id` AS `id`,`altesse_smartnephro`.`patients_initial`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_initial`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`patients_initial`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`patients_initial`.`date_premiere_traitement` AS `date_premiere_traitement`,`altesse_smartnephro`.`patients_initial`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`altesse_smartnephro`.`patients_initial`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`altesse_smartnephro`.`patients_initial`.`niveau_instruction` AS `niveau_instruction`,`altesse_smartnephro`.`patients_initial`.`profession` AS `profession`,`altesse_smartnephro`.`patients_initial`.`activite_actuelle` AS `activite_actuelle`,`altesse_smartnephro`.`patients_initial`.`situation_matrimoniale` AS `situation_matrimoniale`,`altesse_smartnephro`.`patients_initial`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`altesse_smartnephro`.`patients_initial`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`altesse_smartnephro`.`patients_initial`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`altesse_smartnephro`.`patients_initial`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`altesse_smartnephro`.`patients_initial`.`couverture_sociale` AS `couverture_sociale`,`altesse_smartnephro`.`patients_initial`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`altesse_smartnephro`.`patients_initial`.`premiere_creatininemie` AS `premiere_creatininemie`,`altesse_smartnephro`.`patients_initial`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`altesse_smartnephro`.`patients_initial`.`poids_kg` AS `poids_kg`,`altesse_smartnephro`.`patients_initial`.`taille_cm` AS `taille_cm`,`altesse_smartnephro`.`patients_initial`.`IMC` AS `IMC`,`altesse_smartnephro`.`patients_initial`.`hb_taux` AS `hb_taux`,`altesse_smartnephro`.`patients_initial`.`hb_date` AS `hb_date`,`altesse_smartnephro`.`patients_initial`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`altesse_smartnephro`.`patients_initial`.`Comorb_diabete` AS `Comorb_diabete`,`altesse_smartnephro`.`patients_initial`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`altesse_smartnephro`.`patients_initial`.`Comorb_HTA` AS `Comorb_HTA`,`altesse_smartnephro`.`patients_initial`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`altesse_smartnephro`.`patients_initial`.`Comorb_IDM` AS `Comorb_IDM`,`altesse_smartnephro`.`patients_initial`.`Comorb_pericardite` AS `Comorb_pericardite`,`altesse_smartnephro`.`patients_initial`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`altesse_smartnephro`.`patients_initial`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`altesse_smartnephro`.`patients_initial`.`Comorb_AVC` AS `Comorb_AVC`,`altesse_smartnephro`.`patients_initial`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`altesse_smartnephro`.`patients_initial`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`altesse_smartnephro`.`patients_initial`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`altesse_smartnephro`.`patients_initial`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`altesse_smartnephro`.`patients_initial`.`Comorb_vih` AS `Comorb_vih`,`altesse_smartnephro`.`patients_initial`.`Comorb_bpco` AS `Comorb_bpco`,`altesse_smartnephro`.`patients_initial`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`altesse_smartnephro`.`patients_initial`.`Comorb_cancer` AS `Comorb_cancer`,`altesse_smartnephro`.`patients_initial`.`Comorb_autre` AS `Comorb_autre`,`altesse_smartnephro`.`patients_initial`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`altesse_smartnephro`.`patients_initial`.`handicap_aucun` AS `handicap_aucun`,`altesse_smartnephro`.`patients_initial`.`handicap_para_hemi` AS `handicap_para_hemi`,`altesse_smartnephro`.`patients_initial`.`handicap_TSC` AS `handicap_TSC`,`altesse_smartnephro`.`patients_initial`.`handicap_ami` AS `handicap_ami`,`altesse_smartnephro`.`patients_initial`.`handicap_tsv` AS `handicap_tsv`,`altesse_smartnephro`.`patients_initial`.`handicap_cecite` AS `handicap_cecite`,`altesse_smartnephro`.`patients_initial`.`handicap_ND` AS `handicap_ND`,`altesse_smartnephro`.`patients_initial`.`handicap_autre` AS `handicap_autre`,`altesse_smartnephro`.`patients_initial`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`altesse_smartnephro`.`patients_initial`.`marche` AS `marche`,`altesse_smartnephro`.`patients_initial`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`altesse_smartnephro`.`patients_initial`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`altesse_smartnephro`.`patients_initial`.`ped_taille_enfant` AS `ped_taille_enfant`,`altesse_smartnephro`.`patients_initial`.`ped_scolarise` AS `ped_scolarise`,`altesse_smartnephro`.`patients_initial`.`traitement_actuel` AS `traitement_actuel`,`altesse_smartnephro`.`patients_initial`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`altesse_smartnephro`.`patients_initial`.`non_traite_autre` AS `non_traite_autre`,`altesse_smartnephro`.`patients_initial`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`altesse_smartnephro`.`patients_initial`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`altesse_smartnephro`.`patients_initial`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`altesse_smartnephro`.`patients_initial`.`traitement_actuel_type` AS `traitement_actuel_type`,`altesse_smartnephro`.`patients_initial`.`hemod_modalites` AS `hemod_modalites`,`altesse_smartnephro`.`patients_initial`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`altesse_smartnephro`.`patients_initial`.`hemod_duree_seance` AS `hemod_duree_seance`,`altesse_smartnephro`.`patients_initial`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`altesse_smartnephro`.`patients_initial`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`altesse_smartnephro`.`patients_initial`.`dia_peri_modalites` AS `dia_peri_modalites`,`altesse_smartnephro`.`patients_initial`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_type` AS `greffe_ren_type`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`altesse_smartnephro`.`patients_initial`.`fiche_commentaire` AS `fiche_commentaire`,`altesse_smartnephro`.`patients_initial`.`patient_fiche` AS `patient_fiche`,`altesse_smartnephro`.`patients_initial`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`patients_initial`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`patients_initial`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`patients_initial`.`dates` AS `dates`,`altesse_smartnephro`.`patients_initial`.`date_modif` AS `date_modif` from (`altesse_smartnephro`.`patients_identification_demographiques_ok` left join `altesse_smartnephro`.`patients_initial` on((`patients_identification_demographiques_ok`.`patient_code` = `altesse_smartnephro`.`patients_initial`.`patient_code`)))

  57. patients_fiche_initial_centre_ville
    58. select `patients_fiche_initial`.`demo_id` AS `demo_id`,`patients_fiche_initial`.`demo_patient_code` AS `demo_patient_code`,`patients_fiche_initial`.`demo_date_remplissage` AS `demo_date_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi`,`patients_fiche_initial`.`patient_statut` AS `patient_statut`,`patients_fiche_initial`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_fiche_initial`.`patient_numero_identification` AS `patient_numero_identification`,`patients_fiche_initial`.`patient_nom` AS `patient_nom`,`patients_fiche_initial`.`patient_prenom` AS `patient_prenom`,`patients_fiche_initial`.`annee_remplissage` AS `annee_remplissage`,`patients_fiche_initial`.`patient_consent` AS `patient_consent`,`patients_fiche_initial`.`patient_date_naissance` AS `patient_date_naissance`,`patients_fiche_initial`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_fiche_initial`.`patient_ville_naissance` AS `patient_ville_naissance`,`patients_fiche_initial`.`patient_pays_naissance` AS `patient_pays_naissance`,`patients_fiche_initial`.`patient_sexe` AS `patient_sexe`,`patients_fiche_initial`.`patient_commentaire` AS `patient_commentaire`,`patients_fiche_initial`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_fiche_initial`.`centre` AS `centre`,`patients_fiche_initial`.`centre_primaire` AS `centre_primaire`,`patients_fiche_initial`.`centre_secondaire` AS `centre_secondaire`,`patients_fiche_initial`.`centre_transfert` AS `centre_transfert`,`patients_fiche_initial`.`centre_primaire_dossier` AS `centre_primaire_dossier`,`patients_fiche_initial`.`centre_secondaire_dossier` AS `centre_secondaire_dossier`,`patients_fiche_initial`.`groupe_age_remplissage` AS `groupe_age_remplissage`,`patients_fiche_initial`.`groupe_age_actuel` AS `groupe_age_actuel`,`patients_fiche_initial`.`id` AS `id`,`patients_fiche_initial`.`patient_code` AS `patient_code`,`patients_fiche_initial`.`patient_date_remplissage` AS `patient_date_remplissage`,`patients_fiche_initial`.`contexte_statut` AS `contexte_statut`,`patients_fiche_initial`.`date_premiere_traitement` AS `date_premiere_traitement`,`patients_fiche_initial`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`patients_fiche_initial`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`patients_fiche_initial`.`niveau_instruction` AS `niveau_instruction`,`patients_fiche_initial`.`profession` AS `profession`,`patients_fiche_initial`.`activite_actuelle` AS `activite_actuelle`,`patients_fiche_initial`.`situation_matrimoniale` AS `situation_matrimoniale`,`patients_fiche_initial`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`patients_fiche_initial`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`patients_fiche_initial`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`patients_fiche_initial`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`patients_fiche_initial`.`couverture_sociale` AS `couverture_sociale`,`patients_fiche_initial`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`patients_fiche_initial`.`premiere_creatininemie` AS `premiere_creatininemie`,`patients_fiche_initial`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`patients_fiche_initial`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`patients_fiche_initial`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`patients_fiche_initial`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`patients_fiche_initial`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`patients_fiche_initial`.`poids_kg` AS `poids_kg`,`patients_fiche_initial`.`taille_cm` AS `taille_cm`,`patients_fiche_initial`.`IMC` AS `IMC`,`patients_fiche_initial`.`hb_taux` AS `hb_taux`,`patients_fiche_initial`.`hb_date` AS `hb_date`,`patients_fiche_initial`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`patients_fiche_initial`.`Comorb_diabete` AS `Comorb_diabete`,`patients_fiche_initial`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`patients_fiche_initial`.`Comorb_HTA` AS `Comorb_HTA`,`patients_fiche_initial`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`patients_fiche_initial`.`Comorb_IDM` AS `Comorb_IDM`,`patients_fiche_initial`.`Comorb_pericardite` AS `Comorb_pericardite`,`patients_fiche_initial`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`patients_fiche_initial`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`patients_fiche_initial`.`Comorb_AVC` AS `Comorb_AVC`,`patients_fiche_initial`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`patients_fiche_initial`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`patients_fiche_initial`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`patients_fiche_initial`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`patients_fiche_initial`.`Comorb_vih` AS `Comorb_vih`,`patients_fiche_initial`.`Comorb_bpco` AS `Comorb_bpco`,`patients_fiche_initial`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`patients_fiche_initial`.`Comorb_cancer` AS `Comorb_cancer`,`patients_fiche_initial`.`Comorb_autre` AS `Comorb_autre`,`patients_fiche_initial`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`patients_fiche_initial`.`handicap_aucun` AS `handicap_aucun`,`patients_fiche_initial`.`handicap_para_hemi` AS `handicap_para_hemi`,`patients_fiche_initial`.`handicap_TSC` AS `handicap_TSC`,`patients_fiche_initial`.`handicap_ami` AS `handicap_ami`,`patients_fiche_initial`.`handicap_tsv` AS `handicap_tsv`,`patients_fiche_initial`.`handicap_cecite` AS `handicap_cecite`,`patients_fiche_initial`.`handicap_ND` AS `handicap_ND`,`patients_fiche_initial`.`handicap_autre` AS `handicap_autre`,`patients_fiche_initial`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`patients_fiche_initial`.`marche` AS `marche`,`patients_fiche_initial`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`patients_fiche_initial`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`patients_fiche_initial`.`ped_taille_enfant` AS `ped_taille_enfant`,`patients_fiche_initial`.`ped_scolarise` AS `ped_scolarise`,`patients_fiche_initial`.`traitement_actuel` AS `traitement_actuel`,`patients_fiche_initial`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`patients_fiche_initial`.`non_traite_autre` AS `non_traite_autre`,`patients_fiche_initial`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`patients_fiche_initial`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`patients_fiche_initial`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`patients_fiche_initial`.`traitement_actuel_type` AS `traitement_actuel_type`,`patients_fiche_initial`.`hemod_modalites` AS `hemod_modalites`,`patients_fiche_initial`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`patients_fiche_initial`.`hemod_duree_seance` AS `hemod_duree_seance`,`patients_fiche_initial`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`patients_fiche_initial`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`patients_fiche_initial`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`patients_fiche_initial`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`patients_fiche_initial`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`patients_fiche_initial`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`patients_fiche_initial`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`patients_fiche_initial`.`dia_peri_modalites` AS `dia_peri_modalites`,`patients_fiche_initial`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`patients_fiche_initial`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`patients_fiche_initial`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`patients_fiche_initial`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`patients_fiche_initial`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`patients_fiche_initial`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`patients_fiche_initial`.`greffe_ren_type` AS `greffe_ren_type`,`patients_fiche_initial`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`patients_fiche_initial`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`patients_fiche_initial`.`fiche_commentaire` AS `fiche_commentaire`,`patients_fiche_initial`.`patient_fiche` AS `patient_fiche`,`patients_fiche_initial`.`patient_fiche_code` AS `patient_fiche_code`,`patients_fiche_initial`.`saisie_par` AS `saisie_par`,`patients_fiche_initial`.`modifie_par` AS `modifie_par`,`patients_fiche_initial`.`dates` AS `dates`,`patients_fiche_initial`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`centres`.`centre` AS `lecentre`,`altesse_smartnephro`.`centres`.`type_centre` AS `Type`,`altesse_smartnephro`.`centres`.`ville` AS `Ville` from (`altesse_smartnephro`.`patients_fiche_initial` left join `altesse_smartnephro`.`centres` on((`patients_fiche_initial`.`centre_inclusion_code` = `altesse_smartnephro`.`centres`.`centre_code`)))

  58. patients_fiche_initial_centre_ville_ind
    59. select `patients_fiche_initial_centre_ville`.`Ville` AS `Ville`,`patients_fiche_initial_centre_ville`.`lecentre` AS `lecentre`,`patients_fiche_initial_centre_ville`.`Type` AS `Type`,`patients_fiche_initial_centre_ville`.`annee_remplissage` AS `annee_remplissage`,concat(`patients_fiche_initial_centre_ville`.`Ville`,' | ',`patients_fiche_initial_centre_ville`.`lecentre`) AS `Centre`,count(`patients_fiche_initial_centre_ville`.`id`) AS `pretotal` from `altesse_smartnephro`.`patients_fiche_initial_centre_ville` group by `patients_fiche_initial_centre_ville`.`Ville`,`patients_fiche_initial_centre_ville`.`centre`,`patients_fiche_initial_centre_ville`.`Type`,`patients_fiche_initial_centre_ville`.`annee_remplissage` order by `patients_fiche_initial_centre_ville`.`Ville`,`Centre`,`patients_fiche_initial_centre_ville`.`Type`,`patients_fiche_initial_centre_ville`.`annee_remplissage`

  59. patients_identification_demographiques_ok
    60. select `altesse_smartnephro`.`patients_identification_demographiques`.`id` AS `id`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_numero_identification` AS `patient_numero_identification`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_nom` AS `patient_nom`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_prenom` AS `patient_prenom`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_consent` AS `patient_consent`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_date_naissance` AS `patient_date_naissance`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_age_remplissage` AS `patient_age_remplissage`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_ville_naissance` AS `patient_ville_naissance`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_pays_naissance` AS `patient_pays_naissance`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_sexe` AS `patient_sexe`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_commentaire` AS `patient_commentaire`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_inclusion_code` AS `centre_inclusion_code`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_primaire` AS `centre_primaire`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_secondaire` AS `centre_secondaire`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_transfert` AS `centre_transfert`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_primaire_dossier` AS `centre_primaire_dossier`,`altesse_smartnephro`.`patients_identification_demographiques`.`centre_secondaire_dossier` AS `centre_secondaire_dossier`,`altesse_smartnephro`.`patients_identification_demographiques`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_epi` AS `patient_epi`,`altesse_smartnephro`.`patients_identification_demographiques`.`patient_statut` AS `patient_statut`,`altesse_smartnephro`.`patients_identification_demographiques`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`patients_identification_demographiques`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`patients_identification_demographiques`.`dates` AS `dates`,`altesse_smartnephro`.`patients_identification_demographiques`.`date_modif` AS `date_modif`,year(`altesse_smartnephro`.`patients_identification_demographiques`.`patient_date_remplissage`) AS `annee_remplissage`,(year(curdate()) - year(`altesse_smartnephro`.`patients_identification_demographiques`.`patient_date_naissance`)) AS `age`,`altesse_smartnephro`.`centres`.`centre` AS `centre`,`altesse_smartnephro`.`centres`.`centre_code` AS `centre_code` from (`altesse_smartnephro`.`patients_identification_demographiques` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`centres`.`centre_code` = `altesse_smartnephro`.`patients_identification_demographiques`.`centre_primaire`)))

  60. patients_indicateur_activite_clinique
    61. select count(`patients_fiche_initial`.`id`) AS `totalpatients`,`patients_fiche_initial`.`activite_actuelle` AS `groupe`,year(`patients_fiche_initial`.`demo_date_remplissage`) AS `annee_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_fiche_initial` group by `patients_fiche_initial`.`annee_remplissage`,`groupe`,`patients_fiche_initial`.`patient_epi`

  61. patients_indicateur_diabete
    62. select count(`patients_fiche_initial`.`id`) AS `totalpatients`,`patients_fiche_initial`.`Comorb_diabete` AS `groupe`,year(`patients_fiche_initial`.`demo_date_remplissage`) AS `annee_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_fiche_initial` group by `patients_fiche_initial`.`annee_remplissage`,`groupe`,`patients_fiche_initial`.`patient_epi`

  62. patients_indicateur_hta
    63. select count(`patients_fiche_initial`.`id`) AS `totalpatients`,`patients_fiche_initial`.`Comorb_HTA` AS `groupe`,year(`patients_fiche_initial`.`demo_date_remplissage`) AS `annee_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_fiche_initial` group by `patients_fiche_initial`.`annee_remplissage`,`groupe`,`patients_fiche_initial`.`patient_epi`

  63. patients_indicateur_ped
    64. select `patients_fiche_initial`.`id` AS `id`,`patients_fiche_initial`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_fiche_initial`.`patient_numero_identification` AS `patient_numero_identification`,`patients_fiche_initial`.`patient_code` AS `patient_code`,`patients_fiche_initial`.`patient_sexe` AS `patient_sexe`,`patients_fiche_initial`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_fiche_initial`.`annee_remplissage` AS `annee_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi`,(case when (`patients_fiche_initial`.`patient_age_remplissage` < 16) then 'Pédiatriques' when (`patients_fiche_initial`.`patient_age_remplissage` >= 16) then 'Adults' else 'ND' end) AS `groupe` from `altesse_smartnephro`.`patients_fiche_initial`

  64. patients_indicateur_ped_scolarise
    65. select count(`patients_fiche_initial`.`id`) AS `totalpatients`,`patients_fiche_initial`.`ped_scolarise` AS `groupe`,year(`patients_fiche_initial`.`demo_date_remplissage`) AS `annee_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_fiche_initial` where (`patients_fiche_initial`.`patient_age_remplissage` < 16) group by `patients_fiche_initial`.`annee_remplissage`,`groupe`,`patients_fiche_initial`.`patient_epi`

  65. patients_indicateur_statut
    66. select count(`patients_fiche_initial`.`id`) AS `totalpatients`,`patients_fiche_initial`.`contexte_statut` AS `groupe`,year(`patients_fiche_initial`.`demo_date_remplissage`) AS `annee_remplissage`,`patients_fiche_initial`.`patient_epi` AS `patient_epi` from `altesse_smartnephro`.`patients_fiche_initial` group by `patients_fiche_initial`.`annee_remplissage`,`groupe`,`patients_fiche_initial`.`patient_epi`

  66. pilot_donnees
    67. select `altesse_smartnephro`.`pilot_initial`.`id` AS `id`,`altesse_smartnephro`.`pilot_initial`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`pilot_initial`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`pilot_initial`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`pilot_initial`.`date_premiere_traitement` AS `date_premiere_traitement`,`altesse_smartnephro`.`pilot_initial`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`altesse_smartnephro`.`pilot_initial`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`altesse_smartnephro`.`pilot_initial`.`niveau_instruction` AS `niveau_instruction`,`altesse_smartnephro`.`pilot_initial`.`profession` AS `profession`,`altesse_smartnephro`.`pilot_initial`.`activite_actuelle` AS `activite_actuelle`,`altesse_smartnephro`.`pilot_initial`.`situation_matrimoniale` AS `situation_matrimoniale`,`altesse_smartnephro`.`pilot_initial`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`altesse_smartnephro`.`pilot_initial`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`altesse_smartnephro`.`pilot_initial`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`altesse_smartnephro`.`pilot_initial`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`altesse_smartnephro`.`pilot_initial`.`couverture_sociale` AS `couverture_sociale`,`altesse_smartnephro`.`pilot_initial`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`altesse_smartnephro`.`pilot_initial`.`premiere_creatininemie` AS `premiere_creatininemie`,`altesse_smartnephro`.`pilot_initial`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`altesse_smartnephro`.`pilot_initial`.`poids_kg` AS `poids_kg`,`altesse_smartnephro`.`pilot_initial`.`taille_cm` AS `taille_cm`,`altesse_smartnephro`.`pilot_initial`.`IMC` AS `IMC`,`altesse_smartnephro`.`pilot_initial`.`hb_taux` AS `hb_taux`,`altesse_smartnephro`.`pilot_initial`.`hb_date` AS `hb_date`,`altesse_smartnephro`.`pilot_initial`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`altesse_smartnephro`.`pilot_initial`.`Comorb_diabete` AS `Comorb_diabete`,`altesse_smartnephro`.`pilot_initial`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`altesse_smartnephro`.`pilot_initial`.`Comorb_HTA` AS `Comorb_HTA`,`altesse_smartnephro`.`pilot_initial`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`altesse_smartnephro`.`pilot_initial`.`Comorb_IDM` AS `Comorb_IDM`,`altesse_smartnephro`.`pilot_initial`.`Comorb_pericardite` AS `Comorb_pericardite`,`altesse_smartnephro`.`pilot_initial`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`altesse_smartnephro`.`pilot_initial`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`altesse_smartnephro`.`pilot_initial`.`Comorb_AVC` AS `Comorb_AVC`,`altesse_smartnephro`.`pilot_initial`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`altesse_smartnephro`.`pilot_initial`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`altesse_smartnephro`.`pilot_initial`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`altesse_smartnephro`.`pilot_initial`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`altesse_smartnephro`.`pilot_initial`.`Comorb_vih` AS `Comorb_vih`,`altesse_smartnephro`.`pilot_initial`.`Comorb_bpco` AS `Comorb_bpco`,`altesse_smartnephro`.`pilot_initial`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`altesse_smartnephro`.`pilot_initial`.`Comorb_cancer` AS `Comorb_cancer`,`altesse_smartnephro`.`pilot_initial`.`Comorb_autre` AS `Comorb_autre`,`altesse_smartnephro`.`pilot_initial`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`altesse_smartnephro`.`pilot_initial`.`handicap_aucun` AS `handicap_aucun`,`altesse_smartnephro`.`pilot_initial`.`handicap_para_hemi` AS `handicap_para_hemi`,`altesse_smartnephro`.`pilot_initial`.`handicap_TSC` AS `handicap_TSC`,`altesse_smartnephro`.`pilot_initial`.`handicap_ami` AS `handicap_ami`,`altesse_smartnephro`.`pilot_initial`.`handicap_tsv` AS `handicap_tsv`,`altesse_smartnephro`.`pilot_initial`.`handicap_cecite` AS `handicap_cecite`,`altesse_smartnephro`.`pilot_initial`.`handicap_ND` AS `handicap_ND`,`altesse_smartnephro`.`pilot_initial`.`handicap_autre` AS `handicap_autre`,`altesse_smartnephro`.`pilot_initial`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`altesse_smartnephro`.`pilot_initial`.`marche` AS `marche`,`altesse_smartnephro`.`pilot_initial`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`altesse_smartnephro`.`pilot_initial`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`altesse_smartnephro`.`pilot_initial`.`ped_taille_enfant` AS `ped_taille_enfant`,`altesse_smartnephro`.`pilot_initial`.`ped_scolarise` AS `ped_scolarise`,`altesse_smartnephro`.`pilot_initial`.`traitement_actuel` AS `traitement_actuel`,`altesse_smartnephro`.`pilot_initial`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`altesse_smartnephro`.`pilot_initial`.`non_traite_autre` AS `non_traite_autre`,`altesse_smartnephro`.`pilot_initial`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`altesse_smartnephro`.`pilot_initial`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`altesse_smartnephro`.`pilot_initial`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`altesse_smartnephro`.`pilot_initial`.`traitement_actuel_type` AS `traitement_actuel_type`,`altesse_smartnephro`.`pilot_initial`.`hemod_modalites` AS `hemod_modalites`,`altesse_smartnephro`.`pilot_initial`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`altesse_smartnephro`.`pilot_initial`.`hemod_duree_seance` AS `hemod_duree_seance`,`altesse_smartnephro`.`pilot_initial`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`altesse_smartnephro`.`pilot_initial`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`altesse_smartnephro`.`pilot_initial`.`dia_peri_modalites` AS `dia_peri_modalites`,`altesse_smartnephro`.`pilot_initial`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_type` AS `greffe_ren_type`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`altesse_smartnephro`.`pilot_initial`.`fiche_commentaire` AS `fiche_commentaire`,`altesse_smartnephro`.`pilot_initial`.`patient_fiche` AS `patient_fiche`,`altesse_smartnephro`.`pilot_initial`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`pilot_initial`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`pilot_initial`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`pilot_initial`.`dates` AS `dates`,`altesse_smartnephro`.`pilot_initial`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`pilot_initial`.`deces` AS `deces`,`altesse_smartnephro`.`pilot_initial`.`date_deces` AS `date_deces`,`altesse_smartnephro`.`pilot_initial`.`lieu_deces` AS `lieu_deces`,`altesse_smartnephro`.`pilot_initial`.`cause_deces` AS `cause_deces`,`altesse_smartnephro`.`pilot_initial`.`cause_deces_groupe` AS `cause_deces_groupe` from `altesse_smartnephro`.`pilot_initial` union all select `altesse_smartnephro`.`pilot_evolution`.`id` AS `id`,`altesse_smartnephro`.`pilot_evolution`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`pilot_evolution`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`pilot_evolution`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`pilot_evolution`.`date_premiere_traitement` AS `date_premiere_traitement`,`altesse_smartnephro`.`pilot_evolution`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`altesse_smartnephro`.`pilot_evolution`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`altesse_smartnephro`.`pilot_evolution`.`niveau_instruction` AS `niveau_instruction`,`altesse_smartnephro`.`pilot_evolution`.`profession` AS `profession`,`altesse_smartnephro`.`pilot_evolution`.`activite_actuelle` AS `activite_actuelle`,`altesse_smartnephro`.`pilot_evolution`.`situation_matrimoniale` AS `situation_matrimoniale`,`altesse_smartnephro`.`pilot_evolution`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`altesse_smartnephro`.`pilot_evolution`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`altesse_smartnephro`.`pilot_evolution`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`altesse_smartnephro`.`pilot_evolution`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`altesse_smartnephro`.`pilot_evolution`.`couverture_sociale` AS `couverture_sociale`,`altesse_smartnephro`.`pilot_evolution`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`altesse_smartnephro`.`pilot_evolution`.`premiere_creatininemie` AS `premiere_creatininemie`,`altesse_smartnephro`.`pilot_evolution`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`altesse_smartnephro`.`pilot_evolution`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`altesse_smartnephro`.`pilot_evolution`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`altesse_smartnephro`.`pilot_evolution`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`altesse_smartnephro`.`pilot_evolution`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`altesse_smartnephro`.`pilot_evolution`.`poids_kg` AS `poids_kg`,`altesse_smartnephro`.`pilot_evolution`.`taille_cm` AS `taille_cm`,`altesse_smartnephro`.`pilot_evolution`.`IMC` AS `IMC`,`altesse_smartnephro`.`pilot_evolution`.`hb_taux` AS `hb_taux`,`altesse_smartnephro`.`pilot_evolution`.`hb_date` AS `hb_date`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_diabete` AS `Comorb_diabete`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_HTA` AS `Comorb_HTA`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_IDM` AS `Comorb_IDM`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_pericardite` AS `Comorb_pericardite`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_AVC` AS `Comorb_AVC`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_vih` AS `Comorb_vih`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_bpco` AS `Comorb_bpco`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_cancer` AS `Comorb_cancer`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_autre` AS `Comorb_autre`,`altesse_smartnephro`.`pilot_evolution`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`altesse_smartnephro`.`pilot_evolution`.`handicap_aucun` AS `handicap_aucun`,`altesse_smartnephro`.`pilot_evolution`.`handicap_para_hemi` AS `handicap_para_hemi`,`altesse_smartnephro`.`pilot_evolution`.`handicap_TSC` AS `handicap_TSC`,`altesse_smartnephro`.`pilot_evolution`.`handicap_ami` AS `handicap_ami`,`altesse_smartnephro`.`pilot_evolution`.`handicap_tsv` AS `handicap_tsv`,`altesse_smartnephro`.`pilot_evolution`.`handicap_cecite` AS `handicap_cecite`,`altesse_smartnephro`.`pilot_evolution`.`handicap_ND` AS `handicap_ND`,`altesse_smartnephro`.`pilot_evolution`.`handicap_autre` AS `handicap_autre`,`altesse_smartnephro`.`pilot_evolution`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`altesse_smartnephro`.`pilot_evolution`.`marche` AS `marche`,`altesse_smartnephro`.`pilot_evolution`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`altesse_smartnephro`.`pilot_evolution`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`altesse_smartnephro`.`pilot_evolution`.`ped_taille_enfant` AS `ped_taille_enfant`,`altesse_smartnephro`.`pilot_evolution`.`ped_scolarise` AS `ped_scolarise`,`altesse_smartnephro`.`pilot_evolution`.`traitement_actuel` AS `traitement_actuel`,`altesse_smartnephro`.`pilot_evolution`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`altesse_smartnephro`.`pilot_evolution`.`non_traite_autre` AS `non_traite_autre`,`altesse_smartnephro`.`pilot_evolution`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`altesse_smartnephro`.`pilot_evolution`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`altesse_smartnephro`.`pilot_evolution`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`altesse_smartnephro`.`pilot_evolution`.`traitement_actuel_type` AS `traitement_actuel_type`,`altesse_smartnephro`.`pilot_evolution`.`hemod_modalites` AS `hemod_modalites`,`altesse_smartnephro`.`pilot_evolution`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`altesse_smartnephro`.`pilot_evolution`.`hemod_duree_seance` AS `hemod_duree_seance`,`altesse_smartnephro`.`pilot_evolution`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`altesse_smartnephro`.`pilot_evolution`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`altesse_smartnephro`.`pilot_evolution`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`altesse_smartnephro`.`pilot_evolution`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`altesse_smartnephro`.`pilot_evolution`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`altesse_smartnephro`.`pilot_evolution`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`altesse_smartnephro`.`pilot_evolution`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`altesse_smartnephro`.`pilot_evolution`.`dia_peri_modalites` AS `dia_peri_modalites`,`altesse_smartnephro`.`pilot_evolution`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_type` AS `greffe_ren_type`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`altesse_smartnephro`.`pilot_evolution`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`altesse_smartnephro`.`pilot_evolution`.`fiche_commentaire` AS `fiche_commentaire`,`altesse_smartnephro`.`pilot_evolution`.`patient_fiche` AS `patient_fiche`,`altesse_smartnephro`.`pilot_evolution`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`pilot_evolution`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`pilot_evolution`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`pilot_evolution`.`dates` AS `dates`,`altesse_smartnephro`.`pilot_evolution`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`pilot_evolution`.`deces` AS `deces`,`altesse_smartnephro`.`pilot_evolution`.`date_deces` AS `date_deces`,`altesse_smartnephro`.`pilot_evolution`.`lieu_deces` AS `lieu_deces`,`altesse_smartnephro`.`pilot_evolution`.`cause_deces` AS `cause_deces`,`altesse_smartnephro`.`pilot_evolution`.`cause_deces_groupe` AS `cause_deces_groupe` from `altesse_smartnephro`.`pilot_evolution` order by `patient_code`,`patient_fiche` desc

  67. pilot_donnees_all
    68. select `altesse_smartnephro`.`pilot_identification_demographiques`.`patient_numero_identification` AS `patient_numero_identification`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_nom` AS `patient_nom`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_prenom` AS `patient_prenom`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_date_naissance` AS `patient_date_naissance`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_age_remplissage` AS `f`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_ville_naissance` AS `patient_ville_naissance`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_pays_naissance` AS `patient_pays_naissance`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_sexe` AS `patient_sexe`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_commentaire` AS `patient_commentaire`,`pilot_donnees_centre`.`id` AS `id`,`pilot_donnees_centre`.`patient_code` AS `patient_code`,`pilot_donnees_centre`.`patient_date_remplissage` AS `patient_date_remplissage`,`pilot_donnees_centre`.`contexte_statut` AS `contexte_statut`,`pilot_donnees_centre`.`date_premiere_traitement` AS `date_premiere_traitement`,`pilot_donnees_centre`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`pilot_donnees_centre`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`pilot_donnees_centre`.`niveau_instruction` AS `niveau_instruction`,`pilot_donnees_centre`.`profession` AS `profession`,`pilot_donnees_centre`.`activite_actuelle` AS `activite_actuelle`,`pilot_donnees_centre`.`situation_matrimoniale` AS `situation_matrimoniale`,`pilot_donnees_centre`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`pilot_donnees_centre`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`pilot_donnees_centre`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`pilot_donnees_centre`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`pilot_donnees_centre`.`couverture_sociale` AS `couverture_sociale`,`pilot_donnees_centre`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`pilot_donnees_centre`.`premiere_creatininemie` AS `premiere_creatininemie`,`pilot_donnees_centre`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`pilot_donnees_centre`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`pilot_donnees_centre`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`pilot_donnees_centre`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`pilot_donnees_centre`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`pilot_donnees_centre`.`poids_kg` AS `poids_kg`,`pilot_donnees_centre`.`taille_cm` AS `taille_cm`,`pilot_donnees_centre`.`IMC` AS `IMC`,`pilot_donnees_centre`.`hb_taux` AS `hb_taux`,`pilot_donnees_centre`.`hb_date` AS `hb_date`,`pilot_donnees_centre`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`pilot_donnees_centre`.`Comorb_diabete` AS `Comorb_diabete`,`pilot_donnees_centre`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`pilot_donnees_centre`.`Comorb_HTA` AS `Comorb_HTA`,`pilot_donnees_centre`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`pilot_donnees_centre`.`Comorb_IDM` AS `Comorb_IDM`,`pilot_donnees_centre`.`Comorb_pericardite` AS `Comorb_pericardite`,`pilot_donnees_centre`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`pilot_donnees_centre`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`pilot_donnees_centre`.`Comorb_AVC` AS `Comorb_AVC`,`pilot_donnees_centre`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`pilot_donnees_centre`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`pilot_donnees_centre`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`pilot_donnees_centre`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`pilot_donnees_centre`.`Comorb_vih` AS `Comorb_vih`,`pilot_donnees_centre`.`Comorb_bpco` AS `Comorb_bpco`,`pilot_donnees_centre`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`pilot_donnees_centre`.`Comorb_cancer` AS `Comorb_cancer`,`pilot_donnees_centre`.`Comorb_autre` AS `Comorb_autre`,`pilot_donnees_centre`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`pilot_donnees_centre`.`handicap_aucun` AS `handicap_aucun`,`pilot_donnees_centre`.`handicap_para_hemi` AS `handicap_para_hemi`,`pilot_donnees_centre`.`handicap_TSC` AS `handicap_TSC`,`pilot_donnees_centre`.`handicap_ami` AS `handicap_ami`,`pilot_donnees_centre`.`handicap_tsv` AS `handicap_tsv`,`pilot_donnees_centre`.`handicap_cecite` AS `handicap_cecite`,`pilot_donnees_centre`.`handicap_ND` AS `handicap_ND`,`pilot_donnees_centre`.`handicap_autre` AS `handicap_autre`,`pilot_donnees_centre`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`pilot_donnees_centre`.`marche` AS `marche`,`pilot_donnees_centre`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`pilot_donnees_centre`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`pilot_donnees_centre`.`ped_taille_enfant` AS `ped_taille_enfant`,`pilot_donnees_centre`.`ped_scolarise` AS `ped_scolarise`,`pilot_donnees_centre`.`traitement_actuel` AS `traitement_actuel`,`pilot_donnees_centre`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`pilot_donnees_centre`.`non_traite_autre` AS `non_traite_autre`,`pilot_donnees_centre`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`pilot_donnees_centre`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`pilot_donnees_centre`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`pilot_donnees_centre`.`traitement_actuel_type` AS `traitement_actuel_type`,`pilot_donnees_centre`.`hemod_modalites` AS `hemod_modalites`,`pilot_donnees_centre`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`pilot_donnees_centre`.`hemod_duree_seance` AS `hemod_duree_seance`,`pilot_donnees_centre`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`pilot_donnees_centre`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`pilot_donnees_centre`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`pilot_donnees_centre`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`pilot_donnees_centre`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`pilot_donnees_centre`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`pilot_donnees_centre`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`pilot_donnees_centre`.`dia_peri_modalites` AS `dia_peri_modalites`,`pilot_donnees_centre`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`pilot_donnees_centre`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`pilot_donnees_centre`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`pilot_donnees_centre`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`pilot_donnees_centre`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`pilot_donnees_centre`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`pilot_donnees_centre`.`greffe_ren_type` AS `greffe_ren_type`,`pilot_donnees_centre`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`pilot_donnees_centre`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`pilot_donnees_centre`.`fiche_commentaire` AS `fiche_commentaire`,`pilot_donnees_centre`.`patient_fiche` AS `patient_fiche`,`pilot_donnees_centre`.`patient_fiche_code` AS `patient_fiche_code`,`pilot_donnees_centre`.`saisie_par` AS `saisie_par`,`pilot_donnees_centre`.`modifie_par` AS `modifie_par`,`pilot_donnees_centre`.`dates` AS `dates`,`pilot_donnees_centre`.`date_modif` AS `date_modif`,`pilot_donnees_centre`.`deces` AS `deces`,`pilot_donnees_centre`.`date_deces` AS `date_deces`,`pilot_donnees_centre`.`lieu_deces` AS `lieu_deces`,`pilot_donnees_centre`.`cause_deces` AS `cause_deces`,`pilot_donnees_centre`.`cause_deces_groupe` AS `cause_deces_groupe`,`pilot_donnees_centre`.`centre` AS `centre` from (`altesse_smartnephro`.`pilot_donnees_centre` left join `altesse_smartnephro`.`pilot_identification_demographiques` on((`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_code` = `pilot_donnees_centre`.`patient_code`)))

  68. pilot_donnees_centre
    69. select `pilot_donnees`.`id` AS `id`,`pilot_donnees`.`patient_code` AS `patient_code`,`pilot_donnees`.`patient_date_remplissage` AS `patient_date_remplissage`,`pilot_donnees`.`contexte_statut` AS `contexte_statut`,`pilot_donnees`.`date_premiere_traitement` AS `date_premiere_traitement`,`pilot_donnees`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`pilot_donnees`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`pilot_donnees`.`niveau_instruction` AS `niveau_instruction`,`pilot_donnees`.`profession` AS `profession`,`pilot_donnees`.`activite_actuelle` AS `activite_actuelle`,`pilot_donnees`.`situation_matrimoniale` AS `situation_matrimoniale`,`pilot_donnees`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`pilot_donnees`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`pilot_donnees`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`pilot_donnees`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`pilot_donnees`.`couverture_sociale` AS `couverture_sociale`,`pilot_donnees`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`pilot_donnees`.`premiere_creatininemie` AS `premiere_creatininemie`,`pilot_donnees`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`pilot_donnees`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`pilot_donnees`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`pilot_donnees`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`pilot_donnees`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`pilot_donnees`.`poids_kg` AS `poids_kg`,`pilot_donnees`.`taille_cm` AS `taille_cm`,`pilot_donnees`.`IMC` AS `IMC`,`pilot_donnees`.`hb_taux` AS `hb_taux`,`pilot_donnees`.`hb_date` AS `hb_date`,`pilot_donnees`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`pilot_donnees`.`Comorb_diabete` AS `Comorb_diabete`,`pilot_donnees`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`pilot_donnees`.`Comorb_HTA` AS `Comorb_HTA`,`pilot_donnees`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`pilot_donnees`.`Comorb_IDM` AS `Comorb_IDM`,`pilot_donnees`.`Comorb_pericardite` AS `Comorb_pericardite`,`pilot_donnees`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`pilot_donnees`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`pilot_donnees`.`Comorb_AVC` AS `Comorb_AVC`,`pilot_donnees`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`pilot_donnees`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`pilot_donnees`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`pilot_donnees`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`pilot_donnees`.`Comorb_vih` AS `Comorb_vih`,`pilot_donnees`.`Comorb_bpco` AS `Comorb_bpco`,`pilot_donnees`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`pilot_donnees`.`Comorb_cancer` AS `Comorb_cancer`,`pilot_donnees`.`Comorb_autre` AS `Comorb_autre`,`pilot_donnees`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`pilot_donnees`.`handicap_aucun` AS `handicap_aucun`,`pilot_donnees`.`handicap_para_hemi` AS `handicap_para_hemi`,`pilot_donnees`.`handicap_TSC` AS `handicap_TSC`,`pilot_donnees`.`handicap_ami` AS `handicap_ami`,`pilot_donnees`.`handicap_tsv` AS `handicap_tsv`,`pilot_donnees`.`handicap_cecite` AS `handicap_cecite`,`pilot_donnees`.`handicap_ND` AS `handicap_ND`,`pilot_donnees`.`handicap_autre` AS `handicap_autre`,`pilot_donnees`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`pilot_donnees`.`marche` AS `marche`,`pilot_donnees`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`pilot_donnees`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`pilot_donnees`.`ped_taille_enfant` AS `ped_taille_enfant`,`pilot_donnees`.`ped_scolarise` AS `ped_scolarise`,`pilot_donnees`.`traitement_actuel` AS `traitement_actuel`,`pilot_donnees`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`pilot_donnees`.`non_traite_autre` AS `non_traite_autre`,`pilot_donnees`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`pilot_donnees`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`pilot_donnees`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`pilot_donnees`.`traitement_actuel_type` AS `traitement_actuel_type`,`pilot_donnees`.`hemod_modalites` AS `hemod_modalites`,`pilot_donnees`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`pilot_donnees`.`hemod_duree_seance` AS `hemod_duree_seance`,`pilot_donnees`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`pilot_donnees`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`pilot_donnees`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`pilot_donnees`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`pilot_donnees`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`pilot_donnees`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`pilot_donnees`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`pilot_donnees`.`dia_peri_modalites` AS `dia_peri_modalites`,`pilot_donnees`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`pilot_donnees`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`pilot_donnees`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`pilot_donnees`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`pilot_donnees`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`pilot_donnees`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`pilot_donnees`.`greffe_ren_type` AS `greffe_ren_type`,`pilot_donnees`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`pilot_donnees`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`pilot_donnees`.`fiche_commentaire` AS `fiche_commentaire`,`pilot_donnees`.`patient_fiche` AS `patient_fiche`,`pilot_donnees`.`patient_fiche_code` AS `patient_fiche_code`,`pilot_donnees`.`saisie_par` AS `saisie_par`,`pilot_donnees`.`modifie_par` AS `modifie_par`,`pilot_donnees`.`dates` AS `dates`,`pilot_donnees`.`date_modif` AS `date_modif`,`pilot_donnees`.`deces` AS `deces`,`pilot_donnees`.`date_deces` AS `date_deces`,`pilot_donnees`.`lieu_deces` AS `lieu_deces`,`pilot_donnees`.`cause_deces` AS `cause_deces`,`pilot_donnees`.`cause_deces_groupe` AS `cause_deces_groupe`,`pilot_identification_demographiques_centre`.`centre` AS `centre` from (`altesse_smartnephro`.`pilot_donnees` left join `altesse_smartnephro`.`pilot_identification_demographiques_centre` on((`pilot_identification_demographiques_centre`.`patient_code` = `pilot_donnees`.`patient_code`)))

  69. pilot_donnees_forms
    70. select `altesse_smartnephro`.`pilot_identification_demographiques`.`centre_inclusion_code` AS `centre_inclusion_code`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_code` AS `patient_code`,`pilot_donnees`.`patient_fiche` AS `patient_fiche` from (`altesse_smartnephro`.`pilot_identification_demographiques` left join `altesse_smartnephro`.`pilot_donnees` on((`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_code` = `pilot_donnees`.`patient_code`))) order by `altesse_smartnephro`.`pilot_identification_demographiques`.`patient_code`,`pilot_donnees`.`patient_fiche`

  70. pilot_donnees_forms_centre
    71. select `pilot_donnees_forms`.`centre_inclusion_code` AS `centre_inclusion_code`,`pilot_donnees_forms`.`patient_code` AS `patient_code`,`pilot_donnees_forms`.`patient_fiche` AS `patient_fiche`,`altesse_smartnephro`.`centres`.`centre` AS `centre` from (`altesse_smartnephro`.`pilot_donnees_forms` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`centres`.`centre_code` = `pilot_donnees_forms`.`centre_inclusion_code`)))

  71. pilot_forms
    72. select `pilot_donnees_forms_centre`.`centre` AS `centre`,`pilot_donnees_forms_centre`.`patient_code` AS `patient_code`,count(`pilot_donnees_forms_centre`.`patient_code`) AS `formulaire` from `altesse_smartnephro`.`pilot_donnees_forms_centre` group by `pilot_donnees_forms_centre`.`centre`,`pilot_donnees_forms_centre`.`patient_code`

  72. pilot_formulaire
    73. select `pilot_forms`.`patient_code` AS `patient_code`,`pilot_forms`.`formulaire` AS `formulaire`,(case when (`pilot_forms`.`formulaire` = 2) then 'oui' else 'non' end) AS `evolution` from `altesse_smartnephro`.`pilot_forms`

  73. pilot_identification_demographiques_centre
    74. select `altesse_smartnephro`.`pilot_identification_demographiques`.`id` AS `id`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_numero_identification` AS `patient_numero_identification`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_nom` AS `patient_nom`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_prenom` AS `patient_prenom`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_consent` AS `patient_consent`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_date_naissance` AS `patient_date_naissance`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_age_remplissage` AS `patient_age_remplissage`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_ville_naissance` AS `patient_ville_naissance`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_pays_naissance` AS `patient_pays_naissance`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_sexe` AS `patient_sexe`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_commentaire` AS `patient_commentaire`,`altesse_smartnephro`.`pilot_identification_demographiques`.`centre_inclusion_code` AS `centre_inclusion_code`,`altesse_smartnephro`.`pilot_identification_demographiques`.`centre_primaire` AS `centre_primaire`,`altesse_smartnephro`.`pilot_identification_demographiques`.`centre_secondaire` AS `centre_secondaire`,`altesse_smartnephro`.`pilot_identification_demographiques`.`centre_transfert` AS `centre_transfert`,`altesse_smartnephro`.`pilot_identification_demographiques`.`centre_primaire_dossier` AS `centre_primaire_dossier`,`altesse_smartnephro`.`pilot_identification_demographiques`.`centre_secondaire_dossier` AS `centre_secondaire_dossier`,`altesse_smartnephro`.`pilot_identification_demographiques`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_epi` AS `patient_epi`,`altesse_smartnephro`.`pilot_identification_demographiques`.`patient_statut` AS `patient_statut`,`altesse_smartnephro`.`pilot_identification_demographiques`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`pilot_identification_demographiques`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`pilot_identification_demographiques`.`dates` AS `dates`,`altesse_smartnephro`.`pilot_identification_demographiques`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`centres`.`centre` AS `centre` from (`altesse_smartnephro`.`pilot_identification_demographiques` left join `altesse_smartnephro`.`centres` on((`altesse_smartnephro`.`centres`.`centre_code` = `altesse_smartnephro`.`pilot_identification_demographiques`.`centre_inclusion_code`)))

  74. pilot_identification_demographiques_centre_forms
    75. select `pilot_identification_demographiques_centre`.`id` AS `id`,`pilot_identification_demographiques_centre`.`patient_fiche_code` AS `patient_fiche_code`,`pilot_identification_demographiques_centre`.`patient_date_remplissage` AS `patient_date_remplissage`,`pilot_identification_demographiques_centre`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`pilot_identification_demographiques_centre`.`patient_numero_identification` AS `patient_numero_identification`,`pilot_identification_demographiques_centre`.`patient_nom` AS `patient_nom`,`pilot_identification_demographiques_centre`.`patient_prenom` AS `patient_prenom`,`pilot_identification_demographiques_centre`.`patient_code` AS `patient_code`,`pilot_identification_demographiques_centre`.`patient_consent` AS `patient_consent`,`pilot_identification_demographiques_centre`.`patient_date_naissance` AS `patient_date_naissance`,`pilot_identification_demographiques_centre`.`patient_age_remplissage` AS `patient_age_remplissage`,`pilot_identification_demographiques_centre`.`patient_ville_naissance` AS `patient_ville_naissance`,`pilot_identification_demographiques_centre`.`patient_pays_naissance` AS `patient_pays_naissance`,`pilot_identification_demographiques_centre`.`patient_sexe` AS `patient_sexe`,`pilot_identification_demographiques_centre`.`patient_commentaire` AS `patient_commentaire`,`pilot_identification_demographiques_centre`.`centre_inclusion_code` AS `centre_inclusion_code`,`pilot_identification_demographiques_centre`.`centre_primaire` AS `centre_primaire`,`pilot_identification_demographiques_centre`.`centre_secondaire` AS `centre_secondaire`,`pilot_identification_demographiques_centre`.`centre_transfert` AS `centre_transfert`,`pilot_identification_demographiques_centre`.`centre_primaire_dossier` AS `centre_primaire_dossier`,`pilot_identification_demographiques_centre`.`centre_secondaire_dossier` AS `centre_secondaire_dossier`,`pilot_identification_demographiques_centre`.`contexte_statut` AS `contexte_statut`,`pilot_identification_demographiques_centre`.`patient_epi` AS `patient_epi`,`pilot_identification_demographiques_centre`.`patient_statut` AS `patient_statut`,`pilot_identification_demographiques_centre`.`saisie_par` AS `saisie_par`,`pilot_identification_demographiques_centre`.`modifie_par` AS `modifie_par`,`pilot_identification_demographiques_centre`.`dates` AS `dates`,`pilot_identification_demographiques_centre`.`date_modif` AS `date_modif`,`pilot_identification_demographiques_centre`.`centre` AS `centre`,`pilot_formulaire`.`evolution` AS `evolution` from (`altesse_smartnephro`.`pilot_identification_demographiques_centre` left join `altesse_smartnephro`.`pilot_formulaire` on((`pilot_formulaire`.`patient_code` = `pilot_identification_demographiques_centre`.`patient_code`)))

  75. pilot_initial_centre
    76. select `altesse_smartnephro`.`pilot_initial`.`id` AS `id`,`altesse_smartnephro`.`pilot_initial`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`pilot_initial`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`pilot_initial`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`pilot_initial`.`date_premiere_traitement` AS `date_premiere_traitement`,`altesse_smartnephro`.`pilot_initial`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`altesse_smartnephro`.`pilot_initial`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`altesse_smartnephro`.`pilot_initial`.`niveau_instruction` AS `niveau_instruction`,`altesse_smartnephro`.`pilot_initial`.`profession` AS `profession`,`altesse_smartnephro`.`pilot_initial`.`activite_actuelle` AS `activite_actuelle`,`altesse_smartnephro`.`pilot_initial`.`situation_matrimoniale` AS `situation_matrimoniale`,`altesse_smartnephro`.`pilot_initial`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`altesse_smartnephro`.`pilot_initial`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`altesse_smartnephro`.`pilot_initial`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`altesse_smartnephro`.`pilot_initial`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`altesse_smartnephro`.`pilot_initial`.`couverture_sociale` AS `couverture_sociale`,`altesse_smartnephro`.`pilot_initial`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`altesse_smartnephro`.`pilot_initial`.`premiere_creatininemie` AS `premiere_creatininemie`,`altesse_smartnephro`.`pilot_initial`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`altesse_smartnephro`.`pilot_initial`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`altesse_smartnephro`.`pilot_initial`.`poids_kg` AS `poids_kg`,`altesse_smartnephro`.`pilot_initial`.`taille_cm` AS `taille_cm`,`altesse_smartnephro`.`pilot_initial`.`IMC` AS `IMC`,`altesse_smartnephro`.`pilot_initial`.`hb_taux` AS `hb_taux`,`altesse_smartnephro`.`pilot_initial`.`hb_date` AS `hb_date`,`altesse_smartnephro`.`pilot_initial`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`altesse_smartnephro`.`pilot_initial`.`Comorb_diabete` AS `Comorb_diabete`,`altesse_smartnephro`.`pilot_initial`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`altesse_smartnephro`.`pilot_initial`.`Comorb_HTA` AS `Comorb_HTA`,`altesse_smartnephro`.`pilot_initial`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`altesse_smartnephro`.`pilot_initial`.`Comorb_IDM` AS `Comorb_IDM`,`altesse_smartnephro`.`pilot_initial`.`Comorb_pericardite` AS `Comorb_pericardite`,`altesse_smartnephro`.`pilot_initial`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`altesse_smartnephro`.`pilot_initial`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`altesse_smartnephro`.`pilot_initial`.`Comorb_AVC` AS `Comorb_AVC`,`altesse_smartnephro`.`pilot_initial`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`altesse_smartnephro`.`pilot_initial`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`altesse_smartnephro`.`pilot_initial`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`altesse_smartnephro`.`pilot_initial`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`altesse_smartnephro`.`pilot_initial`.`Comorb_vih` AS `Comorb_vih`,`altesse_smartnephro`.`pilot_initial`.`Comorb_bpco` AS `Comorb_bpco`,`altesse_smartnephro`.`pilot_initial`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`altesse_smartnephro`.`pilot_initial`.`Comorb_cancer` AS `Comorb_cancer`,`altesse_smartnephro`.`pilot_initial`.`Comorb_autre` AS `Comorb_autre`,`altesse_smartnephro`.`pilot_initial`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`altesse_smartnephro`.`pilot_initial`.`handicap_aucun` AS `handicap_aucun`,`altesse_smartnephro`.`pilot_initial`.`handicap_para_hemi` AS `handicap_para_hemi`,`altesse_smartnephro`.`pilot_initial`.`handicap_TSC` AS `handicap_TSC`,`altesse_smartnephro`.`pilot_initial`.`handicap_ami` AS `handicap_ami`,`altesse_smartnephro`.`pilot_initial`.`handicap_tsv` AS `handicap_tsv`,`altesse_smartnephro`.`pilot_initial`.`handicap_cecite` AS `handicap_cecite`,`altesse_smartnephro`.`pilot_initial`.`handicap_ND` AS `handicap_ND`,`altesse_smartnephro`.`pilot_initial`.`handicap_autre` AS `handicap_autre`,`altesse_smartnephro`.`pilot_initial`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`altesse_smartnephro`.`pilot_initial`.`marche` AS `marche`,`altesse_smartnephro`.`pilot_initial`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`altesse_smartnephro`.`pilot_initial`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`altesse_smartnephro`.`pilot_initial`.`ped_taille_enfant` AS `ped_taille_enfant`,`altesse_smartnephro`.`pilot_initial`.`ped_scolarise` AS `ped_scolarise`,`altesse_smartnephro`.`pilot_initial`.`traitement_actuel` AS `traitement_actuel`,`altesse_smartnephro`.`pilot_initial`.`traitement_actuel_non_traite_reason` AS `traitement_actuel_non_traite_reason`,`altesse_smartnephro`.`pilot_initial`.`non_traite_autre` AS `non_traite_autre`,`altesse_smartnephro`.`pilot_initial`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`altesse_smartnephro`.`pilot_initial`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`altesse_smartnephro`.`pilot_initial`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`altesse_smartnephro`.`pilot_initial`.`traitement_actuel_type` AS `traitement_actuel_type`,`altesse_smartnephro`.`pilot_initial`.`hemod_modalites` AS `hemod_modalites`,`altesse_smartnephro`.`pilot_initial`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`altesse_smartnephro`.`pilot_initial`.`hemod_duree_seance` AS `hemod_duree_seance`,`altesse_smartnephro`.`pilot_initial`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`altesse_smartnephro`.`pilot_initial`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`altesse_smartnephro`.`pilot_initial`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`altesse_smartnephro`.`pilot_initial`.`dia_peri_modalites` AS `dia_peri_modalites`,`altesse_smartnephro`.`pilot_initial`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_type` AS `greffe_ren_type`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`altesse_smartnephro`.`pilot_initial`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`altesse_smartnephro`.`pilot_initial`.`fiche_commentaire` AS `fiche_commentaire`,`altesse_smartnephro`.`pilot_initial`.`patient_fiche` AS `patient_fiche`,`altesse_smartnephro`.`pilot_initial`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`pilot_initial`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`pilot_initial`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`pilot_initial`.`dates` AS `dates`,`altesse_smartnephro`.`pilot_initial`.`date_modif` AS `date_modif`,`altesse_smartnephro`.`pilot_initial`.`deces` AS `deces`,`altesse_smartnephro`.`pilot_initial`.`date_deces` AS `date_deces`,`altesse_smartnephro`.`pilot_initial`.`lieu_deces` AS `lieu_deces`,`altesse_smartnephro`.`pilot_initial`.`cause_deces` AS `cause_deces`,`altesse_smartnephro`.`pilot_initial`.`cause_deces_groupe` AS `cause_deces_groupe`,`pilot_identification_demographiques_centre`.`centre` AS `centre` from (`altesse_smartnephro`.`pilot_initial` left join `altesse_smartnephro`.`pilot_identification_demographiques_centre` on((`pilot_identification_demographiques_centre`.`patient_code` = `altesse_smartnephro`.`pilot_initial`.`patient_code`)))

  76. utilisateurs
    77. select `infirmiers_centre`.`centre` AS `centre_1`,' ' AS `centre_2`,' ' AS `centre_3`,'Infirmier' AS `medecin_centre_role_1`,' ' AS `medecin_centre_role_2`,' ' AS `medecin_centre_role_3`,`infirmiers_centre`.`inf_contact_1` AS `medecin_tel_1`,`infirmiers_centre`.`inf_contact_2` AS `medecin_cel_1`,' ' AS `medecin_sineph_role`,`infirmiers_centre`.`inf_actif` AS `medecin_actif`,`infirmiers_centre`.`id` AS `medecinid`,'infirmiers' AS `tableau`,'inf_actif' AS `variable`,`infirmiers_centre`.`inf_code` AS `medecin_code` from `altesse_smartnephro`.`infirmiers_centre` union all select `medecins_centres`.`centre_1` AS `centre_1`,`medecins_centres`.`centre_2` AS `centre_2`,`medecins_centres`.`centre_3` AS `centre_3`,`medecins_centres`.`medecin_centre_role_1` AS `medecin_centre_role_1`,`medecins_centres`.`medecin_centre_role_2` AS `medecin_centre_role_2`,`medecins_centres`.`medecin_centre_role_3` AS `medecin_centre_role_3`,`medecins_centres`.`medecin_tel_1` AS `medecin_tel_1`,`medecins_centres`.`medecin_cel_1` AS `medecin_cel_1`,`medecins_centres`.`medecin_sineph_role` AS `medecin_sineph_role`,`medecins_centres`.`medecin_actif` AS `medecin_actif`,`medecins_centres`.`id` AS `medecinid`,'medecins' AS `tableau`,'medecin_actif' AS `variable`,`medecins_centres`.`medecin_code` AS `medecin_code` from `altesse_smartnephro`.`medecins_centres`

  77. zpatients_fiche_initial
    78. select `patients_identification_demographiques_ok`.`id` AS `demo_id`,`patients_identification_demographiques_ok`.`patient_code` AS `demo_patient_code`,`patients_identification_demographiques_ok`.`patient_date_remplissage` AS `demo_date_remplissage`,`patients_identification_demographiques_ok`.`patient_epi` AS `patient_epi`,`patients_identification_demographiques_ok`.`patient_identification_temporaire` AS `patient_identification_temporaire`,`patients_identification_demographiques_ok`.`patient_numero_identification` AS `patient_numero_identification`,`patients_identification_demographiques_ok`.`patient_nom` AS `patient_nom`,`patients_identification_demographiques_ok`.`patient_prenom` AS `patient_prenom`,`patients_identification_demographiques_ok`.`annee_remplissage` AS `annee_remplissage`,`patients_identification_demographiques_ok`.`patient_consent` AS `patient_consent`,`patients_identification_demographiques_ok`.`patient_date_naissance` AS `patient_date_naissance`,`patients_identification_demographiques_ok`.`patient_age_remplissage` AS `patient_age_remplissage`,`patients_identification_demographiques_ok`.`patient_ville_naissance` AS `patient_ville_naissance`,`patients_identification_demographiques_ok`.`patient_pays_naissance` AS `patient_pays_naissance`,`patients_identification_demographiques_ok`.`patient_sexe` AS `patient_sexe`,`patients_identification_demographiques_ok`.`patient_commentaire` AS `patient_commentaire`,`patients_identification_demographiques_ok`.`centre_inclusion_code` AS `centre_inclusion_code`,`patients_identification_demographiques_ok`.`centre` AS `centre`,(case when (`patients_identification_demographiques_ok`.`patient_age_remplissage` < 16) then 'Pédiatriques (<16)' when (`patients_identification_demographiques_ok`.`patient_age_remplissage` >= 16) then 'Adults' else 'ND' end) AS `groupe_age_remplissage`,(case when (`patients_identification_demographiques_ok`.`age` < 16) then 'Pédiatriques (<16)' when (`patients_identification_demographiques_ok`.`age` >= 16) then 'Adults' else 'ND' end) AS `groupe_age_actuel`,`altesse_smartnephro`.`patients_initial`.`id` AS `id`,`altesse_smartnephro`.`patients_initial`.`patient_code` AS `patient_code`,`altesse_smartnephro`.`patients_initial`.`patient_date_remplissage` AS `patient_date_remplissage`,`altesse_smartnephro`.`patients_initial`.`numero_dossier_centre` AS `numero_dossier_centre`,`altesse_smartnephro`.`patients_initial`.`contexte_statut` AS `contexte_statut`,`altesse_smartnephro`.`patients_initial`.`date_premiere_traitement` AS `date_premiere_traitement`,`altesse_smartnephro`.`patients_initial`.`duree_dialyse_jours` AS `duree_dialyse_jours`,`altesse_smartnephro`.`patients_initial`.`duree_dialyse_mois` AS `duree_dialyse_mois`,`altesse_smartnephro`.`patients_initial`.`type_centre_traitement` AS `type_centre_traitement`,`altesse_smartnephro`.`patients_initial`.`contexte_centre_code` AS `contexte_centre_code`,`altesse_smartnephro`.`patients_initial`.`niveau_instruction` AS `niveau_instruction`,`altesse_smartnephro`.`patients_initial`.`profession` AS `profession`,`altesse_smartnephro`.`patients_initial`.`profession_details` AS `profession_details`,`altesse_smartnephro`.`patients_initial`.`activite_actuelle` AS `activite_actuelle`,`altesse_smartnephro`.`patients_initial`.`activite_statut` AS `activite_statut`,`altesse_smartnephro`.`patients_initial`.`situation_matrimoniale` AS `situation_matrimoniale`,`altesse_smartnephro`.`patients_initial`.`ville_habitation_actuelle` AS `ville_habitation_actuelle`,`altesse_smartnephro`.`patients_initial`.`pays_habitation_actuelle` AS `pays_habitation_actuelle`,`altesse_smartnephro`.`patients_initial`.`ville_ancienne_habitation` AS `ville_ancienne_habitation`,`altesse_smartnephro`.`patients_initial`.`pays_ancienne_habitation` AS `pays_ancienne_habitation`,`altesse_smartnephro`.`patients_initial`.`couverture_sociale` AS `couverture_sociale`,`altesse_smartnephro`.`patients_initial`.`patient_incident` AS `patient_incident`,`altesse_smartnephro`.`patients_initial`.`premiere_consultatio_nephro_date` AS `premiere_consultatio_nephro_date`,`altesse_smartnephro`.`patients_initial`.`premiere_creatininemie` AS `premiere_creatininemie`,`altesse_smartnephro`.`patients_initial`.`premiere_clairance_creatinine` AS `premiere_clairance_creatinine`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_PBR` AS `maladie_renale_initiale_PBR`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_echo` AS `maladie_renale_initiale_echo`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_diagnostic` AS `maladie_renale_initiale_diagnostic`,`altesse_smartnephro`.`patients_initial`.`maladie_renale_initiale_diagnostic_compl` AS `maladie_renale_initiale_diagnostic_compl`,`altesse_smartnephro`.`patients_initial`.`commune_residence` AS `commune_residence`,`altesse_smartnephro`.`patients_initial`.`poids_kg` AS `poids_kg`,`altesse_smartnephro`.`patients_initial`.`taille_cm` AS `taille_cm`,`altesse_smartnephro`.`patients_initial`.`IMC` AS `IMC`,`altesse_smartnephro`.`patients_initial`.`hb_taux` AS `hb_taux`,`altesse_smartnephro`.`patients_initial`.`hb_date` AS `hb_date`,`altesse_smartnephro`.`patients_initial`.`Comorb_tabagisme` AS `Comorb_tabagisme`,`altesse_smartnephro`.`patients_initial`.`Comorb_diabete` AS `Comorb_diabete`,`altesse_smartnephro`.`patients_initial`.`Comorb_insulinotherapie` AS `Comorb_insulinotherapie`,`altesse_smartnephro`.`patients_initial`.`Comorb_HTA` AS `Comorb_HTA`,`altesse_smartnephro`.`patients_initial`.`Comorb_Insuffisance_coronarienne` AS `Comorb_Insuffisance_coronarienne`,`altesse_smartnephro`.`patients_initial`.`Comorb_IDM` AS `Comorb_IDM`,`altesse_smartnephro`.`patients_initial`.`Comorb_pericardite` AS `Comorb_pericardite`,`altesse_smartnephro`.`patients_initial`.`Comorb_trouble_rythme` AS `Comorb_trouble_rythme`,`altesse_smartnephro`.`patients_initial`.`Comorb_trouble_conduction` AS `Comorb_trouble_conduction`,`altesse_smartnephro`.`patients_initial`.`Comorb_insuffisance_cardiaque` AS `Comorb_insuffisance_cardiaque`,`altesse_smartnephro`.`patients_initial`.`Comorb_AVC` AS `Comorb_AVC`,`altesse_smartnephro`.`patients_initial`.`Comorb_arterite_mi` AS `Comorb_arterite_mi`,`altesse_smartnephro`.`patients_initial`.`Comorb_ag_hbs_positif` AS `Comorb_ag_hbs_positif`,`altesse_smartnephro`.`patients_initial`.`Comorb_Ac_hvc_positif` AS `Comorb_Ac_hvc_positif`,`altesse_smartnephro`.`patients_initial`.`Comorb_cirrhose` AS `Comorb_cirrhose`,`altesse_smartnephro`.`patients_initial`.`Comorb_vih` AS `Comorb_vih`,`altesse_smartnephro`.`patients_initial`.`Comorb_bpco` AS `Comorb_bpco`,`altesse_smartnephro`.`patients_initial`.`Comorb_tuberculose` AS `Comorb_tuberculose`,`altesse_smartnephro`.`patients_initial`.`Comorb_cancer` AS `Comorb_cancer`,`altesse_smartnephro`.`patients_initial`.`Comorb_autre` AS `Comorb_autre`,`altesse_smartnephro`.`patients_initial`.`Comorb_autre_precisez` AS `Comorb_autre_precisez`,`altesse_smartnephro`.`patients_initial`.`handicap_aucun` AS `handicap_aucun`,`altesse_smartnephro`.`patients_initial`.`handicap_para_hemi` AS `handicap_para_hemi`,`altesse_smartnephro`.`patients_initial`.`handicap_TSC` AS `handicap_TSC`,`altesse_smartnephro`.`patients_initial`.`handicap_ami` AS `handicap_ami`,`altesse_smartnephro`.`patients_initial`.`handicap_tsv` AS `handicap_tsv`,`altesse_smartnephro`.`patients_initial`.`handicap_cecite` AS `handicap_cecite`,`altesse_smartnephro`.`patients_initial`.`handicap_ND` AS `handicap_ND`,`altesse_smartnephro`.`patients_initial`.`handicap_autre` AS `handicap_autre`,`altesse_smartnephro`.`patients_initial`.`handicap_autre_precisez` AS `handicap_autre_precisez`,`altesse_smartnephro`.`patients_initial`.`marche` AS `marche`,`altesse_smartnephro`.`patients_initial`.`ped_perimetre_cranien` AS `ped_perimetre_cranien`,`altesse_smartnephro`.`patients_initial`.`ped_perimetre_brachial` AS `ped_perimetre_brachial`,`altesse_smartnephro`.`patients_initial`.`ped_taille_enfant` AS `ped_taille_enfant`,`altesse_smartnephro`.`patients_initial`.`ped_scolarise` AS `ped_scolarise`,`altesse_smartnephro`.`patients_initial`.`traitement_actuel` AS `traitement_actuel`,`altesse_smartnephro`.`patients_initial`.`non_traite_pas_nec_dialyse` AS `non_traite_pas_nec_dialyse`,`altesse_smartnephro`.`patients_initial`.`non_traite_ctre_indic` AS `non_traite_ctre_indic`,`altesse_smartnephro`.`patients_initial`.`non_traite_pas_place_pub` AS `non_traite_pas_place_pub`,`altesse_smartnephro`.`patients_initial`.`non_traite_refus_dialyse` AS `non_traite_refus_dialyse`,`altesse_smartnephro`.`patients_initial`.`non_traite_diff_finan` AS `non_traite_diff_finan`,`altesse_smartnephro`.`patients_initial`.`non_traite_bilan_pregreffe` AS `non_traite_bilan_pregreffe`,`altesse_smartnephro`.`patients_initial`.`non_traite_autre` AS `non_traite_autre`,`altesse_smartnephro`.`patients_initial`.`non_traite_autre_precisez` AS `non_traite_autre_precisez`,`altesse_smartnephro`.`patients_initial`.`non_traite_creatininemie` AS `non_traite_creatininemie`,`altesse_smartnephro`.`patients_initial`.`non_traite_clairance_creatinine` AS `non_traite_clairance_creatinine`,`altesse_smartnephro`.`patients_initial`.`traitement_actuel_type` AS `traitement_actuel_type`,`altesse_smartnephro`.`patients_initial`.`hemod_modalites` AS `hemod_modalites`,`altesse_smartnephro`.`patients_initial`.`hemod_nbre_seance_semaine` AS `hemod_nbre_seance_semaine`,`altesse_smartnephro`.`patients_initial`.`hemod_duree_seance` AS `hemod_duree_seance`,`altesse_smartnephro`.`patients_initial`.`hemod_circonstances_demarage` AS `hemod_circonstances_demarage`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_fav` AS `hemod_voie_abord_act_fav`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_pontage` AS `hemod_voie_abord_act_pontage`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_kt_tunn` AS `hemod_voie_abord_act_kt_tunn`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_kt_temp` AS `hemod_voie_abord_act_kt_temp`,`altesse_smartnephro`.`patients_initial`.`hemod_voie_abord_act_nd` AS `hemod_voie_abord_act_nd`,`altesse_smartnephro`.`patients_initial`.`hemod_projet_greffe` AS `hemod_projet_greffe`,`altesse_smartnephro`.`patients_initial`.`dia_peri_modalites` AS `dia_peri_modalites`,`altesse_smartnephro`.`patients_initial`.`dia_peri_projet_greffe` AS `dia_peri_projet_greffe`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_creatininemie` AS `greffe_ren_creatininemie`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_creatininemie_date` AS `greffe_ren_creatininemie_date`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_lieu_code` AS `greffe_ren_lieu_code`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_lieu_ville` AS `greffe_ren_lieu_ville`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_lieu_pays` AS `greffe_ren_lieu_pays`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_type` AS `greffe_ren_type`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_sexe_donneur` AS `greffe_ren_sexe_donneur`,`altesse_smartnephro`.`patients_initial`.`greffe_ren_datenaiss_donneur` AS `greffe_ren_datenaiss_donneur`,`altesse_smartnephro`.`patients_initial`.`fiche_commentaire` AS `fiche_commentaire`,`altesse_smartnephro`.`patients_initial`.`patient_fiche` AS `patient_fiche`,`altesse_smartnephro`.`patients_initial`.`patient_fiche_code` AS `patient_fiche_code`,`altesse_smartnephro`.`patients_initial`.`saisie_par` AS `saisie_par`,`altesse_smartnephro`.`patients_initial`.`modifie_par` AS `modifie_par`,`altesse_smartnephro`.`patients_initial`.`dates` AS `dates`,`altesse_smartnephro`.`patients_initial`.`date_modif` AS `date_modif` from (`altesse_smartnephro`.`patients_identification_demographiques_ok` left join `altesse_smartnephro`.`patients_initial` on((`patients_identification_demographiques_ok`.`patient_code` = `altesse_smartnephro`.`patients_initial`.`patient_code`)))

© S.I.NEPH: Société Ivoirienne de Néphrologie

   

Altesse Data Consultant
© Dr Aïcha N. Traoré
WebMail