mysql> show warnings;
+---------+------+---------------------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------------------+
| warning | 1000 | suggest an explicit ANY()/ALL() around a filter on MVA column |
+---------+------+---------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select id,vacancy_id,latitude,longitude,prof_area_ids,groupby() from jobVacancy where prof_area_ids=199 group by vacancy_id facet prof_area_ids group by vacancy_id;
+------+------------+----------+-----------+-----------------+-----------+
| id | vacancy_id | latitude | longitude | prof_area_ids | groupby() |
+------+------------+----------+-----------+-----------------+-----------+
| 1 | 917 | 0.973178 | 0.743566 | 11,199,202 | 917 |
| 191 | 1004 | 0.925335 | 2.768874 | 11,196,199 | 1004 |
| 313 | 1072 | 0.963968 | 1.070624 | 1,11,60,197,199 | 1072 |
| 318 | 1136 | 0.96071 | 1.448998 | 11,196,199 | 1136 |
| 374 | 1097 | 0.785255 | 0.678504 | 11,199 | 1097 |
+------+------------+----------+-----------+-----------------+-----------+
5 rows in set, 1 warning (0.00 sec)
+-----------------+----------+
| group | count(*) |
+-----------------+----------+
| 11,199,202 | 1 |
| 11,196,199 | 2 |
| 1,11,60,197,199 | 3 |
| 11,196,199 | 3 |
| 11,199 | 3 |
+-----------------+----------+
5 rows in set, 1 warning (0.02 sec)