protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { if (!$this->getState()->isUnique()) { $query->join(array('relations' => 'attachments_relations'), 'relations.attachments_attachment_id = tbl.attachments_attachment_id', 'LEFT'); } return parent::_buildQueryJoins($query); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); if (!$query->isCountQuery()) { $query->join(array('pages' => 'pages'), 'tbl.pages_menu_id = pages.pages_menu_id'); } }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); $state = $this->getState(); if ($state->container) { $query->join(array('containers' => 'files_containers'), 'containers.files_container_id = tbl.files_container_id'); } }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); if (!$query->isCountQuery()) { $query->join(array('extensions' => 'extensions'), 'extensions.extensions_extension_id = tbl.extensions_extension_id'); } $state = $this->getState(); if ($state->application) { $query->join(array('menus' => 'pages_menus'), 'menus.pages_menu_id = tbl.pages_menu_id', 'RIGHT'); } }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { $state = $this->getState(); //Exclude joins if counting records if (!$query->isCountQuery()) { if ($state->table) { $query->columns(array('count')); $subquery = $this->getObject('lib:database.query.select')->columns(array('categories_category_id', 'count' => 'COUNT(categories_category_id)'))->table($state->table)->group('categories_category_id'); $query->join(array('content' => $subquery), 'content.categories_category_id = tbl.categories_category_id')->join(array('attachments' => 'attachments'), 'attachments.attachments_attachment_id = tbl.attachments_attachment_id')->join(array('thumbnails' => 'files_thumbnails'), 'thumbnails.filename = attachments.path'); } } parent::_buildQueryJoins($query); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); $query->join(array('categories' => 'categories'), 'categories.categories_category_id = tbl.categories_category_id')->join(array('creator' => 'users'), 'creator.users_user_id = tbl.created_by')->join(array('modifier' => 'users'), 'modifier.users_user_id = tbl.modified_by'); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { $query->join(array('module_menu' => 'pages_modules_pages'), 'module_menu.pages_module_id = tbl.pages_module_id')->join(array('extensions' => 'extensions'), 'extensions.extensions_extension_id = tbl.extensions_extension_id'); parent::_buildQueryJoins($query); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); $query->join(array('relations' => 'tags_relations'), 'relations.tags_tag_id = tbl.tags_tag_id'); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); $query->join(array('categories' => 'categories'), 'categories.categories_category_id = tbl.categories_category_id'); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); $query->join(array('extensions' => 'extensions'), 'extensions.extensions_extension_id = tbl.extensions_extension_id'); }
protected function _buildQueryJoins(Library\DatabaseQuerySelect $query) { parent::_buildQueryJoins($query); $query->join(array('categories' => 'categories'), 'categories.categories_category_id = tbl.categories_category_id')->join(array('creator' => 'users'), 'creator.users_user_id = tbl.created_by')->join(array('modifier' => 'users'), 'modifier.users_user_id = tbl.modified_by')->join(array('attachments' => 'attachments'), 'attachments.attachments_attachment_id = tbl.attachments_attachment_id')->join(array('thumbnails' => 'files_thumbnails'), 'thumbnails.filename = attachments.path'); }