Код: Выделить всё
SELECT id,vacancy_id,prof_area_ids,latitude,longitude from jobVacancy where prof_area_ids=199 group by vacancy_id;
SELECT GROUPBY() AS prof_area_id, COUNT(DISTINCT vacancy_id) as count FROM jobVacancy WHERE prof_area_ids=199 GROUP BY prof_area_ids;
SELECT GROUPBY() AS employment_id, COUNT(DISTINCT vacancy_id) as count FROM jobVacancy where prof_area_ids=199 GROUP BY employment_id;
...
здесь могут быт еще запросы
Пробовал так:
Код: Выделить всё
yii::$app->sphinx->createCommand($myMultipleSphinxRawSQL)->queryAll()
Код: Выделить всё
$first_query = yii::$app->sphinx->createCommand($myMultipleSphinxRawSQL_1)->queryAll();
$second_query = yii::$app->sphinx->createCommand($myMultipleSphinxRawSQL_2)->queryAll();
$third_query = yii::$app->sphinx->createCommand($myMultipleSphinxRawSQL_3)->queryAll();
...