X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fdirenum.php;h=5176c4a262080e6ddfe4860db6b5f93abce6b059;hb=e8ecbab4ad48a3c8c262c91bb492312be3738f86;hp=f7100c5526f5af5bdb9fb726009a77d4aa768d73;hpb=07d0a10adbc2578f9b85875e551a03b99d3650e8;p=platal.git

diff --git a/classes/direnum.php b/classes/direnum.php
index f7100c5..5176c4a 100644
--- a/classes/direnum.php
+++ b/classes/direnum.php
@@ -625,7 +625,9 @@ class DE_Localities extends DE_AddressesComponents
                                                                              AND pac1.groupid = pac2.groupid AND pac1.type = pac2.type)
                   INNER JOIN  profile_addresses_components_enum AS pace2 ON (pac2.component_id = pace2.id AND FIND_IN_SET('country', pace2.types))
                        WHERE  pace2.id = {?} AND FIND_IN_SET('locality', pace1.types) AND pac1.type = 'home' AND " . $where . "
-                    GROUP BY  pace1.long_name";
+                    GROUP BY  pace1.long_name
+                    ORDER BY  nb DESC, field
+                       LIMIT  " . self::AUTOCOMPLETE_LIMIT;
             return XDB::fetchAllAssoc($query, $sub_id);
         }
     }