CloneSet101

administrator/components/com_categories/models/categories.php

administrator/components/com_categories/models/categories.php

administrator/components/com_content/models/articles.php

administrator/components/com_content/models/articles.php

administrator/components/com_content/models/articles.php

administrator/components/com_content/models/featured.php

administrator/components/com_content/models/featured.php

administrator/components/com_content/models/featured.php

administrator/components/com_menus/models/item.php

administrator/components/com_menus/models/items.php

administrator/components/com_menus/models/items.php

administrator/components/com_menus/models/menus.php

administrator/components/com_menus/models/menus.php

administrator/components/com_menus/models/menus.php

administrator/components/com_users/models/groups.php

administrator/components/com_users/models/levels.php

administrator/components/com_users/models/users.php

administrator/components/com_weblinks/models/weblinks.php

administrator/components/com_weblinks/models/weblinks.php

components/com_content/models/article.php

components/com_content/models/frontpage.php

libraries/joomla/form/fields/accesslevels.php

libraries/joomla/html/html/access.php

                $query->join('LEFT', '#__users AS uc ON uc.id=a.checked_out');

                // Join over the asset groups.
                $query->select('ag.title AS access_level');

                $query->join('LEFT', '#__access_assetgroups AS ag ON ag.id = a.access');

                // Join over the users for the author.
                $query->select('ua.name AS author_name');

                $query->join('LEFT', '#__users AS uc ON uc.id=a.checked_out');

                // Join over the asset groups.
                $query->select('ag.title AS access_level');

                $query->join('LEFT', '#__access_assetgroups AS ag ON ag.id = a.access');

                // Join over the categories.
                $query->select('c.title AS category_title');

                $query->join('LEFT', '#__categories AS c ON c.id = a.catid');

                // Join over the users for the author.
                $query->select('ua.name AS author_name');

                $query->join('LEFT', '#__users AS uc ON uc.id=a.checked_out');

                // Join over the asset groups.
                $query->select('ag.title AS access_level');

                $query->join('LEFT', '#__access_assetgroups AS ag ON ag.id = a.access');

                // Join over the categories.
                $query->select('c.title AS category_title');

                $query->join('LEFT', '#__categories AS c ON c.id = a.catid');

                // Join over the users for the author.
                $query->select('ua.name AS author_name');

                $query->join('LEFT', '#__access_assetgroups AS ag ON ag.id = a.access');
                $query->where('a.published >= 0');

                $query->join('LEFT', '`#__users` AS u ON u.id = a.checked_out');

                // Join over the asset groups.
                $query->select('ag.title AS access_level');

                $query->join('LEFT', '#__access_assetgroups AS ag ON ag.id = a.access');

                // Self join to find the level in the tree.
                $query->select('COUNT(DISTINCT p.id) AS level');

                $query->join('LEFT', '`#__menu` AS m1 ON m1.menutype = a.menutype AND m1.published = 1');

                // Self join to find the number of unpublished menu items in the menu.
                $query->select('COUNT(DISTINCT m2.id) AS count_unpublished');

                $query->join('LEFT', '`#__menu` AS m2 ON m2.menutype = a.menutype AND m2.published = 0');

                // Self join to find the number of trashed menu items in the menu.
                $query->select('COUNT(DISTINCT m3.id) AS count_trashed');

                $query->join('LEFT', '`#__menu` AS m3 ON m3.menutype = a.menutype AND m3.published = -2');

                $query->group('a.id');

                $query->join('LEFT', '`#__user_usergroup_map` AS map ON map.group_id = a.id');
                $query->group('a.id');

                $query->join('LEFT', '`#__access_sections` AS s ON s.id = a.section_id');
                $query->group('a.id');

                $query->join('LEFT', '#__user_usergroup_map AS map ON map.user_id = a.id');
                $query->group('a.id');

                $query->join('LEFT', '#__categories AS cc ON cc.id = a.catid');

                // Join over the users.
                $query->select('u.name AS editor');

                $query->join('LEFT', '#__users AS u ON u.id = a.checked_out');

                // Join over the asset groups.
                $query->select('ag.title AS access_level');

                                $query->join('LEFT', '#__categories AS c on c.id = a.catid');

                                // Join on user table.
                                $query->select('u.name AS author');

                $query->join('LEFT', '#__categories AS c ON c.id = a.catid');

                // Join over the users for the author.
                $query->select('ua.name AS author_name');

                $query->join('LEFT', '#__access_assetgroups AS g2 ON a.lft > g2.lft AND a.rgt < g2.rgt');
                $query->group('a.id');

                        $query->join('LEFT', '`#__access_assetgroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt');
                        $query->group('a.id');

$query->join('LEFT', [[#variable57fd7a20]]);
// Join over the asset groups.
// Join over the users for the author.
// Join over the categories.
// Self join to find the level in the tree.
// Self join to find the number of trashed menu items in the menu.
// Self join to find the number of unpublished menu items in the menu.
// Join over the users.
// Join on user table.
$query-> [[#variable56a74e20]]( [[#variable4e461a60]]);
 

'#__access_assetgroups AS ag ON ag.id = a.access' 

'#__users AS uc ON uc.id=a.checked_out' 

'#__categories AS c ON c.id = a.catid' 

'#__access_assetgroups AS ag ON ag.id = a.access' 

'#__access_assetgroups AS ag ON ag.id = a.access' 

'#__access_assetgroups AS ag ON ag.id = a.access' 

'`#__users` AS u ON u.id = a.checked_out' 

'`#__menu` AS m3 ON m3.menutype = a.menutype AND m3.published = -2' 

'`#__menu` AS m2 ON m2.menutype = a.menutype AND m2.published = 0' 

'`#__menu` AS m1 ON m1.menutype = a.menutype AND m1.published = 1' 

'`#__user_usergroup_map` AS map ON map.group_id = a.id' 

'`#__access_sections` AS s ON s.id = a.section_id' 

'#__user_usergroup_map AS map ON map.user_id = a.id' 

'#__users AS u ON u.id = a.checked_out' 

'#__categories AS cc ON cc.id = a.catid' 

'#__categories AS c on c.id = a.catid' 

'#__access_assetgroups AS g2 ON a.lft > g2.lft AND a.rgt < g2.rgt' 

'`#__access_assetgroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt' 

'#__users AS uc ON uc.id=a.checked_out' 

'#__categories AS c ON c.id = a.catid' 

'#__categories AS c ON c.id = a.catid' 

'#__access_assetgroups AS ag ON ag.id = a.access' 

'#__users AS uc ON uc.id=a.checked_out' 

where 

select 

select 

select 

select 

select 

select 

group 

select 

select 

group 

group 

group 

select 

select 

select 

group 

group 

select 

select 

select 

select 

select 

'a.published >= 0' 

'ag.title AS access_level' 

'ua.name AS author_name' 

'ua.name AS author_name' 

'c.title AS category_title' 

'COUNT(DISTINCT p.id) AS level' 

'ag.title AS access_level' 

'a.id' 

'COUNT(DISTINCT m3.id) AS count_trashed' 

'COUNT(DISTINCT m2.id) AS count_unpublished' 

'a.id' 

'a.id' 

'a.id' 

'ag.title AS access_level' 

'u.name AS editor' 

'u.name AS author' 

'a.id' 

'a.id' 

'ag.title AS access_level' 

'ua.name AS author_name' 

'ua.name AS author_name' 

'c.title AS category_title' 

'ag.title AS access_level'