CloneSet101


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
22330.967statement_sequence[2]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
14116
administrator/components/com_categories/models/categories.php
24120
administrator/components/com_categories/models/categories.php
34112
administrator/components/com_content/models/articles.php
44116
administrator/components/com_content/models/articles.php
54120
administrator/components/com_content/models/articles.php
6448
administrator/components/com_content/models/featured.php
7452
administrator/components/com_content/models/featured.php
8456
administrator/components/com_content/models/featured.php
92183
administrator/components/com_menus/models/item.php
104116
administrator/components/com_menus/models/items.php
114120
administrator/components/com_menus/models/items.php
12446
administrator/components/com_menus/models/menus.php
13450
administrator/components/com_menus/models/menus.php
14354
administrator/components/com_menus/models/menus.php
15251
administrator/components/com_users/models/groups.php
16251
administrator/components/com_users/models/levels.php
17246
administrator/components/com_users/models/users.php
184120
administrator/components/com_weblinks/models/weblinks.php
194124
administrator/components/com_weblinks/models/weblinks.php
20484
components/com_content/models/article.php
214147
components/com_content/models/frontpage.php
22243
libraries/joomla/form/fields/accesslevels.php
232227
libraries/joomla/html/html/access.php
Clone Instance
1
Line Count
4
Source Line
116
Source File
administrator/components/com_categories/models/categories.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');


Clone Instance
2
Line Count
4
Source Line
120
Source File
administrator/components/com_categories/models/categories.php

                $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');


Clone Instance
3
Line Count
4
Source Line
112
Source File
administrator/components/com_content/models/articles.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');


Clone Instance
4
Line Count
4
Source Line
116
Source File
administrator/components/com_content/models/articles.php

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

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


Clone Instance
5
Line Count
4
Source Line
120
Source File
administrator/components/com_content/models/articles.php

                $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');


Clone Instance
6
Line Count
4
Source Line
48
Source File
administrator/components/com_content/models/featured.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');


Clone Instance
7
Line Count
4
Source Line
52
Source File
administrator/components/com_content/models/featured.php

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

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


Clone Instance
8
Line Count
4
Source Line
56
Source File
administrator/components/com_content/models/featured.php

                $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');


Clone Instance
9
Line Count
2
Source Line
183
Source File
administrator/components/com_menus/models/item.php

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


Clone Instance
10
Line Count
4
Source Line
116
Source File
administrator/components/com_menus/models/items.php

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

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


Clone Instance
11
Line Count
4
Source Line
120
Source File
administrator/components/com_menus/models/items.php

                $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');


Clone Instance
12
Line Count
4
Source Line
46
Source File
administrator/components/com_menus/models/menus.php

                $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');


Clone Instance
13
Line Count
4
Source Line
50
Source File
administrator/components/com_menus/models/menus.php

                $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');


Clone Instance
14
Line Count
3
Source Line
54
Source File
administrator/components/com_menus/models/menus.php

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

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


Clone Instance
15
Line Count
2
Source Line
51
Source File
administrator/components/com_users/models/groups.php

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


Clone Instance
16
Line Count
2
Source Line
51
Source File
administrator/components/com_users/models/levels.php

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


Clone Instance
17
Line Count
2
Source Line
46
Source File
administrator/components/com_users/models/users.php

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


Clone Instance
18
Line Count
4
Source Line
120
Source File
administrator/components/com_weblinks/models/weblinks.php

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

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


Clone Instance
19
Line Count
4
Source Line
124
Source File
administrator/components/com_weblinks/models/weblinks.php

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

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


Clone Instance
20
Line Count
4
Source Line
84
Source File
components/com_content/models/article.php

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

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


Clone Instance
21
Line Count
4
Source Line
147
Source File
components/com_content/models/frontpage.php

                $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');


Clone Instance
22
Line Count
2
Source Line
43
Source File
libraries/joomla/form/fields/accesslevels.php

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


Clone Instance
23
Line Count
2
Source Line
227
Source File
libraries/joomla/html/html/access.php

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


Clone AbstractionParameter Count: 3Parameter Bindings

$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]]);
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#57fd7a20]]
'#__access_assetgroups AS ag ON ag.id = a.access' 
12[[#57fd7a20]]
'#__users AS uc ON uc.id=a.checked_out' 
13[[#57fd7a20]]
'#__categories AS c ON c.id = a.catid' 
14[[#57fd7a20]]
'#__access_assetgroups AS ag ON ag.id = a.access' 
15[[#57fd7a20]]
'#__access_assetgroups AS ag ON ag.id = a.access' 
16[[#57fd7a20]]
'#__access_assetgroups AS ag ON ag.id = a.access' 
17[[#57fd7a20]]
'`#__users` AS u ON u.id = a.checked_out' 
18[[#57fd7a20]]
'`#__menu` AS m3 ON m3.menutype = a.menutype AND m3.published = -2' 
19[[#57fd7a20]]
'`#__menu` AS m2 ON m2.menutype = a.menutype AND m2.published = 0' 
110[[#57fd7a20]]
'`#__menu` AS m1 ON m1.menutype = a.menutype AND m1.published = 1' 
111[[#57fd7a20]]
'`#__user_usergroup_map` AS map ON map.group_id = a.id' 
112[[#57fd7a20]]
'`#__access_sections` AS s ON s.id = a.section_id' 
113[[#57fd7a20]]
'#__user_usergroup_map AS map ON map.user_id = a.id' 
114[[#57fd7a20]]
'#__users AS u ON u.id = a.checked_out' 
115[[#57fd7a20]]
'#__categories AS cc ON cc.id = a.catid' 
116[[#57fd7a20]]
'#__categories AS c on c.id = a.catid' 
117[[#57fd7a20]]
'#__access_assetgroups AS g2 ON a.lft > g2.lft AND a.rgt < g2.rgt' 
118[[#57fd7a20]]
'`#__access_assetgroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt' 
119[[#57fd7a20]]
'#__users AS uc ON uc.id=a.checked_out' 
120[[#57fd7a20]]
'#__categories AS c ON c.id = a.catid' 
121[[#57fd7a20]]
'#__categories AS c ON c.id = a.catid' 
122[[#57fd7a20]]
'#__access_assetgroups AS ag ON ag.id = a.access' 
123[[#57fd7a20]]
'#__users AS uc ON uc.id=a.checked_out' 
21[[#56a74e20]]
where 
22[[#56a74e20]]
select 
23[[#56a74e20]]
select 
24[[#56a74e20]]
select 
25[[#56a74e20]]
select 
26[[#56a74e20]]
select 
27[[#56a74e20]]
select 
28[[#56a74e20]]
group 
29[[#56a74e20]]
select 
210[[#56a74e20]]
select 
211[[#56a74e20]]
group 
212[[#56a74e20]]
group 
213[[#56a74e20]]
group 
214[[#56a74e20]]
select 
215[[#56a74e20]]
select 
216[[#56a74e20]]
select 
217[[#56a74e20]]
group 
218[[#56a74e20]]
group 
219[[#56a74e20]]
select 
220[[#56a74e20]]
select 
221[[#56a74e20]]
select 
222[[#56a74e20]]
select 
223[[#56a74e20]]
select 
31[[#4e461a60]]
'a.published >= 0' 
32[[#4e461a60]]
'ag.title AS access_level' 
33[[#4e461a60]]
'ua.name AS author_name' 
34[[#4e461a60]]
'ua.name AS author_name' 
35[[#4e461a60]]
'c.title AS category_title' 
36[[#4e461a60]]
'COUNT(DISTINCT p.id) AS level' 
37[[#4e461a60]]
'ag.title AS access_level' 
38[[#4e461a60]]
'a.id' 
39[[#4e461a60]]
'COUNT(DISTINCT m3.id) AS count_trashed' 
310[[#4e461a60]]
'COUNT(DISTINCT m2.id) AS count_unpublished' 
311[[#4e461a60]]
'a.id' 
312[[#4e461a60]]
'a.id' 
313[[#4e461a60]]
'a.id' 
314[[#4e461a60]]
'ag.title AS access_level' 
315[[#4e461a60]]
'u.name AS editor' 
316[[#4e461a60]]
'u.name AS author' 
317[[#4e461a60]]
'a.id' 
318[[#4e461a60]]
'a.id' 
319[[#4e461a60]]
'ag.title AS access_level' 
320[[#4e461a60]]
'ua.name AS author_name' 
321[[#4e461a60]]
'ua.name AS author_name' 
322[[#4e461a60]]
'c.title AS category_title' 
323[[#4e461a60]]
'ag.title AS access_level'