diff options
| author | fisharebest <fisharebest@gmail.com> | 2012-07-07 10:34:16 +0000 |
|---|---|---|
| committer | fisharebest <fisharebest@gmail.com> | 2012-07-07 10:34:16 +0000 |
| commit | 22315b460a49169534ba4e04b28a207e0566e8f4 (patch) | |
| tree | 76db5b4e671ed997d3a7fc7ea161a8e863a9c372 /autocomplete.php | |
| parent | 331dec5442a7cedb65238c322b4f2cdb87a977f7 (diff) | |
| download | webtrees-22315b460a49169534ba4e04b28a207e0566e8f4.tar.gz webtrees-22315b460a49169534ba4e04b28a207e0566e8f4.tar.bz2 webtrees-22315b460a49169534ba4e04b28a207e0566e8f4.zip | |
Remove unnecessary clauses from MySQL in the PLAC autocomplete
Diffstat (limited to 'autocomplete.php')
| -rw-r--r-- | autocomplete.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/autocomplete.php b/autocomplete.php index e51ed5846d..a508f37ea7 100644 --- a/autocomplete.php +++ b/autocomplete.php @@ -235,14 +235,14 @@ case 'PLAC': // Place names (with hierarchy), that include the search term WT_DB::prepare( "SELECT SQL_CACHE CONCAT_WS(', ', p1.p_place, p2.p_place, p3.p_place, p4.p_place, p5.p_place, p6.p_place, p7.p_place, p8.p_place, p9.p_place)". " FROM `##places` AS p1". - " LEFT JOIN `##places` AS p2 ON (p1.p_parent_id=p2.p_id AND p1.p_file=p2.p_file)". - " LEFT JOIN `##places` AS p3 ON (p2.p_parent_id=p3.p_id AND p2.p_file=p3.p_file)". - " LEFT JOIN `##places` AS p4 ON (p3.p_parent_id=p4.p_id AND p3.p_file=p4.p_file)". - " LEFT JOIN `##places` AS p5 ON (p4.p_parent_id=p5.p_id AND p4.p_file=p5.p_file)". - " LEFT JOIN `##places` AS p6 ON (p5.p_parent_id=p6.p_id AND p5.p_file=p6.p_file)". - " LEFT JOIN `##places` AS p7 ON (p6.p_parent_id=p7.p_id AND p6.p_file=p7.p_file)". - " LEFT JOIN `##places` AS p8 ON (p7.p_parent_id=p8.p_id AND p7.p_file=p8.p_file)". - " LEFT JOIN `##places` AS p9 ON (p8.p_parent_id=p9.p_id AND p8.p_file=p9.p_file)". + " LEFT JOIN `##places` AS p2 ON (p1.p_parent_id=p2.p_id)". + " LEFT JOIN `##places` AS p3 ON (p2.p_parent_id=p3.p_id)". + " LEFT JOIN `##places` AS p4 ON (p3.p_parent_id=p4.p_id)". + " LEFT JOIN `##places` AS p5 ON (p4.p_parent_id=p5.p_id)". + " LEFT JOIN `##places` AS p6 ON (p5.p_parent_id=p6.p_id)". + " LEFT JOIN `##places` AS p7 ON (p6.p_parent_id=p7.p_id)". + " LEFT JOIN `##places` AS p8 ON (p7.p_parent_id=p8.p_id)". + " LEFT JOIN `##places` AS p9 ON (p8.p_parent_id=p9.p_id)". " WHERE p1.p_place LIKE CONCAT('%', ?, '%') AND p1.p_file=?". " ORDER BY p1.p_place" ) |