#1317 - Query execution was interrupted
Код: Выделить всё
$QuerySale = Sale::find();
$QuerySale->from(['s' => Sale::tableName()]);
// присоединяем связи
$QuerySale->joinWith(['agent AS agent']);
$QuerySale->joinWith(['addresses AS address']);
$QuerySale->joinWith(['tags AS tags]');
Код: Выделить всё
public function getAgent()
{
return $this->hasOne(Agents::className(), ['phone' => 'phone1'])->select('person_type', 'status','person');
}
public function getAddress()
{
return $this->hasOne(Addresses::className(), ['id' => 'id_address'])->select('id', 'address');
}
public function getTags()
{
return $this->hasMany(RealTags::className(), ['sale_id' => 'id'])->select('tag_id');
}
Код: Выделить всё
SELECT COUNT(*) FROM `CITY_sale` `s`
LEFT JOIN `CITY_agents` `agent` ON `s`.`phone1` = `agent`.`phone`
LEFT JOIN `CITY_addresses` `address` ON `s`.`id_address` = `address`.`id`
LEFT JOIN `CITY_tags` `tags` ON `s`.`id` = `tags`.`sale_id`
WHERE (`date_start` >= 1511867093)
AND (`disactive` <> 1)