Communiquez
sur votre établissement et
Adressez-vous
à plusieurs milliers de professionnels de la santé
DERNIÈRES ACTIVITES
DERNIÈRES ACTUALITÉS
ECR 2014 : qu’en retenir ? sur UNIR - Union Nationale des Internes en Radiologie
Congrès franco-israelien à Tel Aviv sur UNIR - Union Nationale des Internes en Radiologie
JFR 2014 : Soirée péniche UNIR sur UNIR - Union Nationale des Internes en Radiologie
Village de la Radiologie Interventionnelle sur UNIR - Union Nationale des Internes en Radiologie
LA SFR JUNIOR sur UNIR - Union Nationale des Internes en Radiologie
RI en cancérologie, algoradiologie sur UNIR - Union Nationale des Internes en Radiologie
Consentement des patients : « Pourquoi m’a-t-on fait subir ce geste ? » sur AGOF - Association des Gynécologues Obstétriciens en Formation
Un village presque parfait sur Médecin généraliste - RÉSEAU SOCIAL PUBLIC
application intrasoins sur Enseignement - RÉSEAU SOCIAL PUBLIC
Présentation du CHRU de Montpellier. sur CHRU de Montpellier
Polyclinique de Furiani. sur Polyclinique de Furiani, Haute-Corse, Corse
Les nouveaux Ehpad sur EHPAD Centre d'Action Sociale de Ville de Paris, Île-de-France.
EHPAD François 1er, une nouvelle aventure sur EHPAD Centre d'Action Sociale de Ville de Paris, Île-de-France.
Qu'est ce être médecin pour la casvp ? sur Centre d'Action Sociale de Ville de Paris, Île-de-France.
Les nouveaux Ehpad. sur Centre d'Action Sociale de Ville de Paris, Île-de-France.
DERNIÈRES OFFRES D'EMPLOI
Fédération Hospitalière de France
Fédération des Etablissements Hospitaliers & d'Aide à la Personne
resah idf
UniHA
InterSyndicat National des Internes
Syndicat des médecins anesthésistes réanimateurs non universitaires
(default) 65 queries took 1728 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Countarchive`.`contrat_id`, `Countarchive`.`count` FROM `rpsv3`.`countarchives` AS `Countarchive` WHERE `geographie_id` = 0 AND `profession_id` = 0 AND `structure_id` = 0 AND `temps_id` = 0 AND `contrat_id` <> 0 ORDER BY `count` DESC LIMIT 2012120
2SELECT `Profession`.`id`, `Profession`.`name` FROM `rpsv3`.`professions` AS `Profession` WHERE 1 = 12282280
3SELECT `Geographie`.`id`, `Geographie`.`name` FROM `rpsv3`.`geographies` AS `Geographie` WHERE 1 = 11301300
4SELECT `Countarchive`.`profession_id`, `Countarchive`.`count` FROM `rpsv3`.`countarchives` AS `Countarchive` WHERE `geographie_id` = 0 AND `contrat_id` = 0 AND `structure_id` = 0 AND `temps_id` = 0 AND `profession_id` <> 0 ORDER BY `count` DESC LIMIT 2020206
5SELECT `Countarchive`.`geographie_id`, `Countarchive`.`count` FROM `rpsv3`.`countarchives` AS `Countarchive` WHERE `profession_id` = 0 AND `contrat_id` = 0 AND `structure_id` = 0 AND `temps_id` = 0 AND `geographie_id` <> 0 ORDER BY `count` DESC LIMIT 2020200
6SELECT `Blog`.`id`, `Blog`.`name`, `Blog`.`content`, `Blog`.`date_creation`, `Blog`.`online`, `Blog`.`groupe_id`, `Blog`.`user_id`, `Blog`.`date_modification`, `Blog`.`like_count`, `Blog`.`ext`, `Blog`.`canonical`, `Blog`.`visite_count`, `Groupe`.`id`, `Groupe`.`name`, `Groupe`.`user_id`, `Groupe`.`profession_id`, `Groupe`.`geographie_id`, `Groupe`.`type`, `Groupe`.`slug`, `Groupe`.`structure_id`, `Groupe`.`user_count` FROM `rpsv3`.`blogs` AS `Blog` LEFT JOIN `rpsv3`.`groupes` AS `Groupe` ON (`Blog`.`groupe_id` = `Groupe`.`id`) WHERE `Groupe`.`type` = 'publique' GROUP BY `Blog`.`date_creation` ORDER BY `Blog`.`date_creation` DESC LIMIT 888180
7SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
8SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
9SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
10SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
11SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
12SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
13SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37175 AND 1=1 LIMIT 1110
14SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 254 AND 1=1 LIMIT 1110
15SELECT `Evenement`.`id`, `Evenement`.`name`, `Evenement`.`content`, `Evenement`.`message`, `Evenement`.`url`, `Evenement`.`date_debut`, `Evenement`.`date_fin`, `Evenement`.`date_creation`, `Evenement`.`date_modification`, `Evenement`.`user_id`, `Evenement`.`groupe_id`, `Evenement`.`like_count`, `Evenement`.`alert`, `Evenement`.`canonical`, `Evenement`.`visite_count`, `Groupe`.`id`, `Groupe`.`name`, `Groupe`.`user_id`, `Groupe`.`profession_id`, `Groupe`.`geographie_id`, `Groupe`.`type`, `Groupe`.`slug`, `Groupe`.`structure_id`, `Groupe`.`user_count` FROM `rpsv3`.`evenements` AS `Evenement` LEFT JOIN `rpsv3`.`groupes` AS `Groupe` ON (`Evenement`.`groupe_id` = `Groupe`.`id`) WHERE `Groupe`.`type` = 'publique' GROUP BY `Evenement`.`date_creation` ORDER BY `Evenement`.`date_creation` DESC LIMIT 88824
16SELECT `User`.`id`, `User`.`email`, `User`.`email_n`, `User`.`password`, `User`.`gindex`, `User`.`password_tmp`, `User`.`role`, `User`.`username`, `User`.`id_number`, `User`.`id_type`, `User`.`date_naissance`, `User`.`date_creation`, `User`.`statut`, `User`.`activation`, `User`.`activation_e`, `User`.`icon`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`age`, `User`.`fonctions`, `User`.`profession_id`, `User`.`media_id`, `User`.`date_modification`, `User`.`adresse`, `User`.`postal`, `User`.`ville`, `User`.`telephone`, `User`.`telephone_portable`, `User`.`rpps`, `User`.`statut_pro`, `User`.`recruteur`, `User`.`recruteur_old`, `User`.`formateur`, `User`.`etablissement`, `User`.`adresse_pro`, `User`.`geographie_id`, `User`.`geographie_id2`, `User`.`temps_travail`, `User`.`temps_travail2`, `User`.`motivations`, `User`.`experiences`, `User`.`content`, `User`.`diplome`, `User`.`langues`, `User`.`loisirs`, `User`.`lien`, `User`.`discussion_count`, `User`.`album_count`, `User`.`media_count`, `User`.`blog_count`, `User`.`video_count`, `User`.`lien_count`, `User`.`question_count`, `User`.`evenement_count`, `User`.`medicapedia_count`, `User`.`management_count`, `User`.`casclinique_count`, `User`.`santepublique_count`, `User`.`offre_count`, `User`.`groupe_count`, `User`.`evenement_register`, `User`.`varchar_special`, `User`.`varchar_special_2`, `User`.`tinyint_special`, `User`.`tinyint_special_1`, `User`.`tinyint_special_2`, `User`.`tinyint_special_3`, `User`.`tinyint_special_4`, `User`.`tinyint_special_5`, `User`.`tinyint_special_6`, `User`.`varchar_special_1`, `User`.`tinyint_special_7`, `User`.`visite_count`, `User`.`varchar_special_3`, `User`.`varchar_special_4`, `User`.`last_notification_view`, `User`.`contact_count`, `EvenementsUser`.`id`, `EvenementsUser`.`user_id`, `EvenementsUser`.`evenement_id`, `EvenementsUser`.`statut` FROM `rpsv3`.`users` AS `User` JOIN `rpsv3`.`evenements_users` AS `EvenementsUser` ON (`EvenementsUser`.`evenement_id` IN (2107, 2106, 2105, 2104, 2103, 2102, 2101, 2100) AND `EvenementsUser`.`user_id` = `User`.`id`) 000
17SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 8963 ORDER BY `Groupe`.`name` ASC LIMIT 1110
18SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 93 AND 1=1 LIMIT 1110
19SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
20SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
21SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
22SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
23SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
24SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
25SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
26SELECT `Media`.`id`, `Media`.`name`, `Media`.`content`, `Media`.`ext`, `Media`.`disabled_library`, `Media`.`type`, `Media`.`user_id`, `Media`.`mime`, `Media`.`groupe_id`, `Media`.`date_modification`, `Media`.`date_creation`, `Media`.`album_id`, `Media`.`like_count`, `Media`.`canonical`, `Media`.`visite_count`, `Groupe`.`id`, `Groupe`.`name`, `Groupe`.`profession_id`, `Groupe`.`geographie_id`, `Groupe`.`user_id`, `Groupe`.`type`, `Groupe`.`slug`, `Groupe`.`structure_id`, `Groupe`.`user_count`, `Album`.`id`, `Album`.`name`, `Album`.`content`, `Album`.`media_id`, `Album`.`user_id`, `Album`.`groupe_id`, `Album`.`date_modification`, `Album`.`date_creation`, `Album`.`like_count`, `Album`.`canonical`, `Album`.`visite_count` FROM `rpsv3`.`medias` AS `Media` LEFT JOIN `rpsv3`.`groupes` AS `Groupe` ON (`Media`.`groupe_id` = `Groupe`.`id`) LEFT JOIN `rpsv3`.`albums` AS `Album` ON (`Album`.`media_id` = `Media`.`id`) WHERE `Groupe`.`type` = 'publique' GROUP BY `Media`.`date_creation` ORDER BY `Media`.`date_creation` DESC LIMIT 888885
27SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 81 AND 1=1 LIMIT 1110
28SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 81 AND 1=1 LIMIT 1110
29SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 81 AND 1=1 LIMIT 1110
30SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 12252 AND 1=1 LIMIT 1110
31SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 12252 AND 1=1 LIMIT 1110
32SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 12252 AND 1=1 LIMIT 1110
33SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 12252 AND 1=1 LIMIT 1110
34SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 37356 AND 1=1 LIMIT 1110
35SELECT `Video`.`id`, `Video`.`name`, `Video`.`url`, `Video`.`content`, `Video`.`groupe_id`, `Video`.`user_id`, `Video`.`date_modification`, `Video`.`date_creation`, `Video`.`like_count`, `Video`.`canonical`, `Video`.`visite_count`, `Groupe`.`id`, `Groupe`.`name`, `Groupe`.`geographie_id`, `Groupe`.`profession_id`, `Groupe`.`user_id`, `Groupe`.`type`, `Groupe`.`slug`, `Groupe`.`structure_id`, `Groupe`.`user_count` FROM `rpsv3`.`videos` AS `Video` LEFT JOIN `rpsv3`.`groupes` AS `Groupe` ON (`Video`.`groupe_id` = `Groupe`.`id`) WHERE `Groupe`.`type` = 'publique' GROUP BY `Video`.`date_creation` ORDER BY `Video`.`date_creation` DESC LIMIT 8888
36SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 81 AND 1=1 LIMIT 1110
37SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 35495 AND 1=1 LIMIT 1110
38SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
39SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
40SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
41SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
42SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
43SELECT `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`role`, `User`.`profession_id` FROM `rpsv3`.`users` AS `User` WHERE `id` = 1 AND 1=1 LIMIT 1110
44SELECT `Medicapedia`.`name`, `Medicapedia`.`id`, `Medicapedia`.`id_mesh` FROM `rpsv3`.`medicapedias` AS `Medicapedia` WHERE `langue` = 'fr' ORDER BY rand() ASC LIMIT 10101083
45SELECT `Santepublique`.`id`, `Santepublique`.`name`, `Santepublique`.`auteurs`, `Santepublique`.`slug`, `Santepublique`.`content`, `Santepublique`.`filename`, `Santepublique`.`date_creation`, `Santepublique`.`online`, `Santepublique`.`moral_id`, `Santepublique`.`date_modification`, `Santepublique`.`like_count`, `Santepublique`.`visite_count`, `Moral`.`id`, `Moral`.`name`, `Moral`.`santepublique_count` FROM `rpsv3`.`santepubliques` AS `Santepublique` LEFT JOIN `rpsv3`.`morals` AS `Moral` ON (`Santepublique`.`moral_id` = `Moral`.`id`) WHERE 1 = 1 ORDER BY `date_creation` desc LIMIT 8880
46SELECT `Notification`.`id`, `Notification`.`ip`, `Notification`.`user_id`, `Notification`.`type`, `Notification`.`cible_id`, `Notification`.`table_id`, `Notification`.`date`, `Notification`.`groupe_id`, `Notification`.`model`, `Notification`.`message`, `Notification`.`categorie`, `User`.`id`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `Friend`.`id`, `Friend`.`email`, `Friend`.`email_n`, `Friend`.`password`, `Friend`.`gindex`, `Friend`.`password_tmp`, `Friend`.`role`, `Friend`.`username`, `Friend`.`id_number`, `Friend`.`id_type`, `Friend`.`date_naissance`, `Friend`.`date_creation`, `Friend`.`statut`, `Friend`.`activation`, `Friend`.`activation_e`, `Friend`.`icon`, `Friend`.`nom`, `Friend`.`prenom`, `Friend`.`civilite`, `Friend`.`age`, `Friend`.`fonctions`, `Friend`.`profession_id`, `Friend`.`media_id`, `Friend`.`date_modification`, `Friend`.`adresse`, `Friend`.`postal`, `Friend`.`ville`, `Friend`.`telephone`, `Friend`.`telephone_portable`, `Friend`.`rpps`, `Friend`.`statut_pro`, `Friend`.`recruteur`, `Friend`.`recruteur_old`, `Friend`.`formateur`, `Friend`.`etablissement`, `Friend`.`adresse_pro`, `Friend`.`geographie_id`, `Friend`.`geographie_id2`, `Friend`.`temps_travail`, `Friend`.`temps_travail2`, `Friend`.`motivations`, `Friend`.`experiences`, `Friend`.`content`, `Friend`.`diplome`, `Friend`.`langues`, `Friend`.`loisirs`, `Friend`.`lien`, `Friend`.`discussion_count`, `Friend`.`album_count`, `Friend`.`media_count`, `Friend`.`blog_count`, `Friend`.`video_count`, `Friend`.`lien_count`, `Friend`.`question_count`, `Friend`.`evenement_count`, `Friend`.`medicapedia_count`, `Friend`.`management_count`, `Friend`.`casclinique_count`, `Friend`.`santepublique_count`, `Friend`.`offre_count`, `Friend`.`groupe_count`, `Friend`.`evenement_register`, `Friend`.`varchar_special`, `Friend`.`varchar_special_2`, `Friend`.`tinyint_special`, `Friend`.`tinyint_special_1`, `Friend`.`tinyint_special_2`, `Friend`.`tinyint_special_3`, `Friend`.`tinyint_special_4`, `Friend`.`tinyint_special_5`, `Friend`.`tinyint_special_6`, `Friend`.`varchar_special_1`, `Friend`.`tinyint_special_7`, `Friend`.`visite_count`, `Friend`.`varchar_special_3`, `Friend`.`varchar_special_4`, `Friend`.`last_notification_view`, `Friend`.`contact_count`, `Blog`.`id`, `Blog`.`name`, `Blog`.`content`, `Blog`.`date_creation`, `Blog`.`online`, `Blog`.`groupe_id`, `Blog`.`user_id`, `Blog`.`date_modification`, `Blog`.`like_count`, `Blog`.`ext`, `Blog`.`canonical`, `Blog`.`visite_count`, `Question`.`id`, `Question`.`name`, `Question`.`note`, `Question`.`parent_id`, `Question`.`content`, `Question`.`online`, `Question`.`groupe_id`, `Question`.`user_id`, `Question`.`date_creation`, `Question`.`date_modification`, `Question`.`like_count`, `Question`.`canonical`, `Question`.`visite_count`, `Media`.`id`, `Media`.`name`, `Media`.`content`, `Media`.`ext`, `Media`.`disabled_library`, `Media`.`type`, `Media`.`user_id`, `Media`.`mime`, `Media`.`groupe_id`, `Media`.`date_modification`, `Media`.`date_creation`, `Media`.`album_id`, `Media`.`like_count`, `Media`.`canonical`, `Media`.`visite_count`, `Album`.`id`, `Album`.`name`, `Album`.`content`, `Album`.`media_id`, `Album`.`user_id`, `Album`.`groupe_id`, `Album`.`date_modification`, `Album`.`date_creation`, `Album`.`like_count`, `Album`.`canonical`, `Album`.`visite_count`, `Video`.`id`, `Video`.`name`, `Video`.`url`, `Video`.`content`, `Video`.`groupe_id`, `Video`.`user_id`, `Video`.`date_modification`, `Video`.`date_creation`, `Video`.`like_count`, `Video`.`canonical`, `Video`.`visite_count`, `Offre`.`id`, `Offre`.`date_activation`, `Offre`.`duree`, `Offre`.`statut`, `Offre`.`is_fhf`, `Offre`.`ref`, `Offre`.`titre`, `Offre`.`content`, `Offre`.`profession_id`, `Offre`.`geographie_id`, `Offre`.`temps_travail`, `Offre`.`temps_travail2`, `Offre`.`structure_id`, `Offre`.`organisation_id`, `Offre`.`user_id`, `Offre`.`interne`, `Offre`.`disabled`, `Offre`.`date_creation`, `Offre`.`date_modification`, `Offre`.`metades`, `Offre`.`metakey`, `Offre`.`admin_id`, `Offre`.`visite_count`, `Like`.`id`, `Like`.`modelClass`, `Like`.`modelId`, `Like`.`user_id`, `Commentaire`.`id`, `Commentaire`.`content`, `Commentaire`.`modelClass`, `Commentaire`.`user_id`, `Commentaire`.`modelId`, `Commentaire`.`date_creation`, `Commentaire`.`date_modification`, `Commentaire`.`like_count`, `Lien`.`id`, `Lien`.`name`, `Lien`.`url`, `Lien`.`content`, `Lien`.`groupe_id`, `Lien`.`user_id`, `Lien`.`date_modification`, `Lien`.`date_creation`, `Lien`.`like_count`, `Lien`.`canonical`, `Lien`.`visite_count`, `Evenement`.`id`, `Evenement`.`name`, `Evenement`.`content`, `Evenement`.`message`, `Evenement`.`url`, `Evenement`.`date_debut`, `Evenement`.`date_fin`, `Evenement`.`date_creation`, `Evenement`.`date_modification`, `Evenement`.`user_id`, `Evenement`.`groupe_id`, `Evenement`.`like_count`, `Evenement`.`alert`, `Evenement`.`canonical`, `Evenement`.`visite_count`, `Discussion`.`id`, `Discussion`.`name`, `Discussion`.`content`, `Discussion`.`date_creation`, `Discussion`.`groupe_id`, `Discussion`.`user_id`, `Discussion`.`date_modification`, `Discussion`.`like_count`, `GroupesUsers`.`id`, `GroupesUsers`.`user_id`, `GroupesUsers`.`groupe_id`, `GroupesUsers`.`statut` FROM `rpsv3`.`notifications` AS `Notification` LEFT JOIN `rpsv3`.`users` AS `User` ON (`Notification`.`user_id` = `User`.`id`) LEFT JOIN `rpsv3`.`users` AS `Friend` ON (`Notification`.`cible_id` = `Friend`.`id` AND `Notification`.`model`="Contact") LEFT JOIN `rpsv3`.`blogs` AS `Blog` ON (`Notification`.`cible_id` = `Blog`.`id` AND `Notification`.`model`="Blog") LEFT JOIN `rpsv3`.`questions` AS `Question` ON (`Notification`.`cible_id` = `Question`.`id` AND `Notification`.`model`="Question") LEFT JOIN `rpsv3`.`medias` AS `Media` ON (`Notification`.`cible_id` = `Media`.`id` AND `Notification`.`model`="Media") LEFT JOIN `rpsv3`.`albums` AS `Album` ON (`Notification`.`cible_id` = `Album`.`id` AND `Notification`.`model`="Album") LEFT JOIN `rpsv3`.`videos` AS `Video` ON (`Notification`.`cible_id` = `Video`.`id` AND `Notification`.`model`="Video") LEFT JOIN `rpsv3`.`offres` AS `Offre` ON (`Notification`.`cible_id` = `Offre`.`id` AND ((`Notification`.`model`="Offre") OR (`Notification`.`model`="OffresUser"))) LEFT JOIN `rpsv3`.`likes` AS `Like` ON (`Notification`.`cible_id` = `Like`.`id` AND `Notification`.`model`="Like") LEFT JOIN `rpsv3`.`commentaires` AS `Commentaire` ON (`Notification`.`cible_id` = `Commentaire`.`id` AND `Notification`.`model`="Commentaire") LEFT JOIN `rpsv3`.`liens` AS `Lien` ON (`Notification`.`cible_id` = `Lien`.`id` AND `Notification`.`model`="Lien") LEFT JOIN `rpsv3`.`evenements` AS `Evenement` ON (`Notification`.`cible_id` = `Evenement`.`id` AND `Notification`.`model`="Evenement") LEFT JOIN `rpsv3`.`discussions` AS `Discussion` ON (`Notification`.`cible_id` = `Discussion`.`id` AND `Notification`.`model`="Discussion") LEFT JOIN `rpsv3`.`groupes_users` AS `GroupesUsers` ON (`Notification`.`cible_id` = `GroupesUsers`.`id` AND `Notification`.`model`="GroupesUsers" AND `GroupesUsers`.`statut`="1") WHERE `Notification`.`categorie` = 1 AND `Notification`.`user_id` <> 1 AND `model` <> 'GroupesUsers' ORDER BY `date` desc LIMIT 1212122
47SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 749 ORDER BY `Groupe`.`name` ASC LIMIT 1110
48SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 57 ORDER BY `Groupe`.`name` ASC LIMIT 1110
49SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 380 ORDER BY `Groupe`.`name` ASC LIMIT 1110
50SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 5947 ORDER BY `Groupe`.`name` ASC LIMIT 1110
51SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 119 ORDER BY `Groupe`.`name` ASC LIMIT 1110
52SELECT `Groupe`.`name`, `Groupe`.`slug`, `Groupe`.`id` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 42 ORDER BY `Groupe`.`name` ASC LIMIT 1110
53SELECT `Groupe`.`id`, `Groupe`.`name`, `Groupe`.`content`, `Groupe`.`slug`, `Groupe`.`type`, `Groupe`.`icon`, `Groupe`.`organisation`, `Groupe`.`universite`, `Groupe`.`user_id`, `Groupe`.`date_creation`, `Groupe`.`date_modification`, `Groupe`.`profession_id`, `Groupe`.`geographie_id`, `Groupe`.`structure_id`, `Groupe`.`officiel`, `Groupe`.`user_count`, `Groupe`.`metades`, `Groupe`.`metakey`, `Groupe`.`visite_count`, `Groupe`.`blog_count`, `Groupe`.`media_count`, `Groupe`.`evenement_count`, `Groupe`.`discussion_count`, `Groupe`.`lien_count`, `Groupe`.`album_count`, `Groupe`.`video_count`, `Groupe`.`offre_count`, `Groupe`.`question_count` FROM `rpsv3`.`groupes` AS `Groupe` WHERE `id` = 11643 ORDER BY `Groupe`.`name` ASC LIMIT 1110
54SELECT `Offre`.`id`, `Offre`.`date_activation`, `Offre`.`duree`, `Offre`.`statut`, `Offre`.`is_fhf`, `Offre`.`ref`, `Offre`.`titre`, `Offre`.`content`, `Offre`.`profession_id`, `Offre`.`geographie_id`, `Offre`.`temps_travail`, `Offre`.`temps_travail2`, `Offre`.`structure_id`, `Offre`.`organisation_id`, `Offre`.`user_id`, `Offre`.`interne`, `Offre`.`disabled`, `Offre`.`date_creation`, `Offre`.`date_modification`, `Offre`.`metades`, `Offre`.`metakey`, `Offre`.`admin_id`, `Offre`.`visite_count`, `Groupe`.`id`, `Groupe`.`name`, `Groupe`.`content`, `Groupe`.`slug`, `Groupe`.`type`, `Groupe`.`icon`, `Groupe`.`organisation`, `Groupe`.`universite`, `Groupe`.`user_id`, `Groupe`.`date_creation`, `Groupe`.`date_modification`, `Groupe`.`profession_id`, `Groupe`.`geographie_id`, `Groupe`.`structure_id`, `Groupe`.`officiel`, `Groupe`.`user_count`, `Groupe`.`metades`, `Groupe`.`metakey`, `Groupe`.`visite_count`, `Groupe`.`blog_count`, `Groupe`.`media_count`, `Groupe`.`evenement_count`, `Groupe`.`discussion_count`, `Groupe`.`lien_count`, `Groupe`.`album_count`, `Groupe`.`video_count`, `Groupe`.`offre_count`, `Groupe`.`question_count`, `User`.`username`, `User`.`nom`, `User`.`prenom`, `User`.`civilite`, `User`.`id`, `User`.`profession_id`, `User`.`temps_travail`, `User`.`geographie_id`, `User`.`date_creation`, `User`.`statut_pro`, `User`.`email`, `Geographie`.`id`, `Geographie`.`name`, `Geographie`.`lft`, `Geographie`.`rght`, `Geographie`.`parent_id`, `Profession`.`id`, `Profession`.`name`, `Profession`.`lft`, `Profession`.`rght`, `Profession`.`parent_id`, `Structure`.`id`, `Structure`.`name` FROM `rpsv3`.`offres` AS `Offre` LEFT JOIN `rpsv3`.`groupes` AS `Groupe` ON (`Offre`.`organisation_id` = `Groupe`.`id` AND `Offre`.`organisation_id` <> 0) LEFT JOIN `rpsv3`.`users` AS `User` ON (`Offre`.`user_id` = `User`.`id`) LEFT JOIN `rpsv3`.`geographies` AS `Geographie` ON (`Offre`.`geographie_id` = `Geographie`.`id`) LEFT JOIN `rpsv3`.`professions` AS `Profession` ON (`Offre`.`profession_id` = `Profession`.`id`) LEFT JOIN `rpsv3`.`structures` AS `Structure` ON (`Offre`.`structure_id` = `Structure`.`id`) WHERE `Offre`.`statut` = 3 ORDER BY `Offre`.`date_creation` desc LIMIT 88811
55SELECT `Contrat`.`id`, `Contrat`.`name`, `ContratsOffre`.`id`, `ContratsOffre`.`contrat_id`, `ContratsOffre`.`offre_id` FROM `rpsv3`.`contrats` AS `Contrat` JOIN `rpsv3`.`contrats_offres` AS `ContratsOffre` ON (`ContratsOffre`.`offre_id` IN (29840, 29839, 29838, 29837, 29836, 29835, 29834, 29833) AND `ContratsOffre`.`contrat_id` = `Contrat`.`id`) 880
56SELECT `Contrat`.`id`, `Contrat`.`name` FROM `rpsv3`.`contrats` AS `Contrat` WHERE 1 = 112120
57SELECT `Meta`.`id`, `Meta`.`controller`, `Meta`.`page_id`, `Meta`.`keywords`, `Meta`.`description`, `Meta`.`action`, `Meta`.`title` FROM `rpsv3`.`metas` AS `Meta` WHERE `controller` = 'pages' AND `action` = 'home' AND isNull(page_id) LIMIT 1110
58SELECT `Visite`.`id` FROM `rpsv3`.`visites` AS `Visite` WHERE `Visite`.`modelClass` = 'Page' AND `Visite`.`action` = 'home' AND `Visite`.`ip` = '54.205.68.5' LIMIT 100523
59INSERT INTO `rpsv3`.`visites` (`modelClass`, `ip`, `action`, `url`, `date_creation`) VALUES ('Page', '54.205.68.5', 'home', '/', 1425213356)111
60SELECT `Visite`.`modelId` FROM `rpsv3`.`visites` AS `Visite` WHERE `Visite`.`id` = 1741161 LIMIT 1110
61SELECT COUNT(*) AS `count` FROM `rpsv3`.`visites` AS `Visite` WHERE `Visite`.`modelId` = 0115
62UPDATE `rpsv3`.`liens` AS `Lien` LEFT JOIN `rpsv3`.`groupes` AS `Groupe` ON (`Lien`.`groupe_id` = `Groupe`.`id`) SET `Lien`.`visite_count` = 18206 WHERE `Lien`.`id` = 0000
63SELECT COUNT(*) AS `count` FROM `rpsv3`.`visites` AS `Visite` WHERE `Visite`.`modelId` = 0110
64UPDATE `rpsv3`.`santepubliques` AS `Santepublique` LEFT JOIN `rpsv3`.`morals` AS `Moral` ON (`Santepublique`.`moral_id` = `Moral`.`id`) SET `Santepublique`.`visite_count` = 18206 WHERE `Santepublique`.`id` = 0000
65SELECT `Help`.`url` FROM `rpsv3`.`helps` AS `Help` WHERE `action` = 'home' AND `modelClass` = 'Page' LIMIT 1000