/**
* Method to build the database query
*
* @access protected
* @param null
* @return mixed
*/
protected function buildQuery()
{
if (YireoHelper::isJoomla15()) {
$query = "SELECT `plugin`.*, {access}, {editor} FROM `#__plugins` AS `plugin`\n";
} else {
$query = "SELECT `plugin`.*, {access}, {editor} FROM `#__extensions` AS `plugin`\n";
}
return parent::buildQuery($query);
}
/**
* Method to build the database query
*
* @access protected
* @param null
* @return mixed
*/
protected function buildQuery()
{
$query = 'SELECT item.*' . ' FROM #__simplelists_items AS item' . ' LEFT JOIN #__simplelists_categories AS relation ON item.id = relation.id' . ' LEFT JOIN #__categories AS category ON category.id = relation.category_id';
return parent::buildQuery($query);
}
/**
* Method to build the database query
*
* @access protected
* @param null
* @return mixed
*/
protected function buildQuery()
{
$query = "SELECT `category`.*, {access}, {editor}, `parent`.`title` AS `parent_title`, `parent`.`checked_out` AS `parent_checked_out`,\n" . " CASE WHEN CHAR_LENGTH(`category`.`alias`) THEN CONCAT_WS(':', `category`.`id`, `category`.`alias`) ELSE `category`.`id` END AS `slug`\n" . " FROM `#__categories` AS `category`\n" . " LEFT JOIN `#__categories` AS `parent` ON `parent`.`id` = `category`.`parent_id`\n";
return parent::buildQuery($query);
}
/**
* Method to build the database query
*
* @access protected
* @param null
* @return mixed
*/
protected function buildQuery()
{
$query = "SELECT item.*, {access}, {editor} FROM #__simplelists_items AS item \n";
return parent::buildQuery($query);
}