Код: Выделить всё
(new QuerySphinx)
->select([
'id',
new \yii\db\Expression('IF(`partner_id` = '.$this->partner_id.', 1, 0) AS `current_partner`'),
])
->from('idx_products_similar_ru_ru')
->andWhere(new \yii\db\Expression('id<>'.$this->id))
->andWhere(['category_id' => $this->category_id])
->orderBy(['current_partner' => SORT_DESC])
->limit(10)
->all()
А Yii в ответ мне:
Код: Выделить всё
SQLSTATE[42000]: Syntax error or access violation: 1064 index idx_products_similar_ru_ru: parse error: Sphinx expr: syntax error, unexpected TOK_IDENT near 'partner_id` = 184, 1, 0)'
The SQL being executed was: SELECT `id`, IF(`partner_id` = 184, 1, 0) AS `current_partner` FROM `idx_products_similar_ru_ru` WHERE (id<>1101670) AND (`category_id`='1704') ORDER BY `current_partner` DESC LIMIT 10