X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fuserset.inc.php;h=ebd37dd648c227cb350691c113a528765f083254;hb=79414508519eab284fbf5093acf478a858a77ec9;hp=65e1a9fe84cf2d1fb395337397f50506e8344828;hpb=f9cddbef7cfeeac827c8cace3375f52ae68ff940;p=platal.git diff --git a/include/userset.inc.php b/include/userset.inc.php index 65e1a9f..ebd37dd 100644 --- a/include/userset.inc.php +++ b/include/userset.inc.php @@ -201,7 +201,7 @@ class MinificheView extends MultipageView public function joins() { - return "LEFT JOIN profile_job AS j ON (j.id = 0 AND j.uid = u.user_id".(S::logged() ? "" : " AND j.pub = 'public'").") + return "LEFT JOIN profile_job AS j ON (j.uid = u.user_id".(S::logged() ? "" : " AND j.pub = 'public'").") LEFT JOIN profile_job_enum AS je ON (je.id = j.jobid) LEFT JOIN profile_job_sector_enum AS es ON (j.sectorid = es.id) LEFT JOIN fonctions_def AS ef ON (j.functionid = ef.id)