From 0230657978c214cded3256ecec59a97980f7d408 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Fri, 19 Mar 2010 00:41:19 +0100 Subject: [PATCH] Fix company queries, enable preload MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Raphaël Barrois --- include/profilefields.inc.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/include/profilefields.inc.php b/include/profilefields.inc.php index b1f0f59..97eebaf 100644 --- a/include/profilefields.inc.php +++ b/include/profilefields.inc.php @@ -603,6 +603,7 @@ class ProfileJobs extends ProfileField public static function fetchData(array $pids, $visibility) { + CompanyList::preload($pids); $data = XDB::iterator('SELECT id, pid, description, url, jobid, sectorid, subsectorid, subsubsectorid, IF(email_pub IN {?}, email, NULL) AS email @@ -671,8 +672,8 @@ class CompanyList } // Load raw data if (count($pids)) { - $join = 'LEFT JOIN profile_jobs ON (profile_job.jobid = profile_job_enum.id)'; - $where = 'profile_jobs.pid IN ' . XDB::formatArray($pids); + $join = 'LEFT JOIN profile_job ON (profile_job.jobid = pje.id)'; + $where = 'WHERE profile_job.pid IN ' . XDB::formatArray($pids); } else { $join = ''; $where = ''; -- 2.1.4