- Timestamp:
- 01/22/08 16:12:19 (1 year ago)
- Files:
-
- kladr/addr_suggest.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
kladr/addr_suggest.php
r64 r65 86 86 " (SELECT name, korp, id, type, _index FROM buildings FORCE INDEX(parent_street) ". 87 87 "$where_q) AS temp ". 88 " INNER JOIN types ON temp.type = types.id ";88 " INNER JOIN types ON temp.type = types.id "; 89 89 $database->setQuery($query); 90 90 $res = $database->loadObjectList(); … … 188 188 " (SELECT name, id, type FROM streets FORCE INDEX(parent_settlement) ". 189 189 "$where_q LIMIT 10) AS temp ". 190 " INNER JOIN types ON temp.type = types.id $check_type )".190 " INNER JOIN types ON temp.type = types.id $check_type ". 191 191 "ORDER BY name LIMIT 10"; 192 192 $database->setQuery($query);
