mysql> SELECT *, WEIGHT() FROM idx_territorial_areas WHERE MATCH('@titles *моск*') OPTION ranker=expr('99999*sum((min_hit_pos==1))');
+-------+---------+-----------+-----------------------------------------------------------------+-----------------+----------+
| id | type_id | parent_id | titles | has_coordinates | weight() |
+-------+---------+-----------+-----------------------------------------------------------------+-----------------+----------+
| 22 | 4 | 113 | Москва Moscow | 1 | 99999 |
| 113 | 3 | 20 | Московская область Moskovskaya oblastʹ | 1 | 99999 |
| 300 | 4 | 75 | Новомосковск Novomoskovsk | 1 | 99999 |
| 789 | 6 | 115 | Московский Moskovskiy | 1 | 99999 |
| 891 | 6 | 112 | Замоскворечье Zamoskvorechʹye | 1 | 99999 |
| 922 | 6 | 108 | Москворечье-Сабурово Moskvorechʹye-Saburovo | 1 | 99999 |
| 1058 | 6 | 121 | Московский Moskovskiy | 1 | 99999 |
| 17460 | 6 | 154 | Московский округ Moskovskiy okrug | 1 | 99999 |
| 17548 | 6 | 130 | Московский район Moskovskiy rayon | 1 | 99999 |
| 17554 | 6 | 139 | Московский район Moskovskiy rayon | 1 | 99999 |
| 17766 | 6 | 191 | Московский район Moskovskiy rayon | 1 | 99999 |
| 17983 | 6 | 196 | Московский район Moskovskiy rayon | 1 | 99999 |
| 18013 | 6 | 166 | Московский район Moskovskiy rayon | 1 | 99999 |
| 18029 | 6 | 121 | Московский район Moskovskiy rayon | 1 | 99999 |
| 18696 | 4 | 1098 | Новомосковск Novomoskovsk | 1 | 99999 |
| 18854 | 6 | 706 | Московский район Moskovskiy rayon | 1 | 99999 |
+-------+---------+-----------+-----------------------------------------------------------------+-----------------+----------+
16 rows in set (0.00 sec)