$select = $this->select();
$select->where('Catalog.trashed = ?', 1)
->where('C.trashed = ?', 0)
->join(array('C' => 'Categories'), 'C.id = Catalog.categoryid', array())
->order($sort);
SELECT `Catalog`.* FROM `Categories` AS `C` INNER JOIN `Catalog` WHERE (Catalog.trashed = 1) AND (C.trashed = 0) ORDER BY `sort` ASC
$select = $this->select();
$select->assemble();
$select->where('Catalog.trashed = ?', 1)
->where('C.trashed = ?', 0)
->join(array('C' => 'Categories'), 'C.id = Catalog.categoryid', array())
->order($sort);
SELECT `Catalog`.* FROM `Catalog` INNER JOIN `Categories` AS `C` ON C.id = Catalog.categoryid WHERE (Catalog.trashed = 1) AND (C.trashed = 0) ORDER BY `sort` ASC
Source: https://habr.com/ru/post/76317/
All Articles