projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixes ambiguous order clause.
[platal.git]
/
modules
/
search.php
diff --git
a/modules/search.php
b/modules/search.php
index
feea72a
..
8173c4a
100644
(file)
--- a/
modules/search.php
+++ b/
modules/search.php
@@
-1,6
+1,6
@@
<?php
/***************************************************************************
<?php
/***************************************************************************
- * Copyright (C) 2003-201
0
Polytechnique.org *
+ * Copyright (C) 2003-201
1
Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
@@
-417,8
+417,8
@@
class SearchModule extends PLModule
INNER JOIN profile_mentor_term AS mt ON (mt.pid = mp.pid)
INNER JOIN profile_job_term_relation AS jtr ON (jtr.jtid_2 = mt.jtid)
WHERE jtr.jtid_1 = {?}
INNER JOIN profile_mentor_term AS mt ON (mt.pid = mp.pid)
INNER JOIN profile_job_term_relation AS jtr ON (jtr.jtid_2 = mt.jtid)
WHERE jtr.jtid_1 = {?}
- GROUP BY iso_3166_1_a2
- ORDER BY country", $jtid);
+ GROUP BY
gc.
iso_3166_1_a2
+ ORDER BY
gc.
country", $jtid);
$page->assign('list', $it);
}
}
$page->assign('list', $it);
}
}