CloneSet1145


Clone Mass	Clones in CloneSet	Parameter Count	Clone Similarity	Syntax Category [Sequence Length]
12	2	4	0.975	statement

Clone Abstraction

Parameter Bindings

Clone Instance (Click to see clone)	Line Count	Source Line	Source File
1	12	106	plugins/search/newsfeeds.php
2	12	118	plugins/search/weblinks.php

Clone Instance
1

Line Count
12

Source Line
106

Source File

plugins/search/newsfeeds.php

        $query=  'SELECT a.name AS title, "" AS created, a.link AS text,'
                 . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, '
                 . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END as catslug, '
                 . ' CONCAT_WS(" / ", '
                 .              $db->Quote($searchNewsfeeds)
        .                                                     ', b.title)AS section,'
        . ' "1" AS browsernav'
        . ' FROM #__newsfeeds AS a'
        . ' INNER JOIN #__categories AS b ON b.id = a.catid'
        . ' WHERE ('
        .             $where
        .                     ')'
        . ' AND a.published = 1'
        . ' AND b.published = 1'
        . ' AND b.access IN ('
        .                      $groups
        .                              ')'
        . ' ORDER BY '
        .               $order;

Clone Instance
2

Line Count
12

Source Line
118

Source File

plugins/search/weblinks.php

        $query=  'SELECT a.title AS title, a.description AS text, a.date AS created, a.url, '
                 . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, '
                 . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END as catslug, '
                 . ' CONCAT_WS(" / ", '
                 .             $db->Quote($section)
        .                                           ', b.title) AS section,'
        . ' "1" AS browsernav'
        . ' FROM #__weblinks AS a'
        . ' INNER JOIN #__categories AS b ON b.id = a.catid'
        . ' WHERE ('
        .             $where
        .                     ')'
        . ' AND a.published = 1'
        . ' AND b.published = 1'
        . ' AND b.access IN ('
        .                      $groups
        .                              ')'
        . ' ORDER BY '
        .               $order;

Clone Abstraction

Parameter Count: 4

Parameter Bindings

$query= [[#variable2301dd60]]
       . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, '
       . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END as catslug, '
       . ' CONCAT_WS(" / ", '
       . $db->Quote( [[#variable2301dce0]])
.  [[#variable2301dc40]]
. ' "1" AS browsernav'
.  [[#variable2301db20]]
. ' INNER JOIN #__categories AS b ON b.id = a.catid'
. ' WHERE ('
. $where
. ')'
. ' AND a.published = 1'
. ' AND b.published = 1'
. ' AND b.access IN ('
. $groups
. ')'
. ' ORDER BY '
. $order;

CloneAbstraction

Parameter Bindings
Parameter Index	Clone Instance	Parameter Name	Value
1	1	`[[#2301dd60]]`	'SELECT a.name AS title, "" AS created, a.link AS text,'
1	2	`[[#2301dd60]]`	'SELECT a.title AS title, a.description AS text, a.date AS created, a.url, '
2	1	`[[#2301dce0]]`	$searchNewsfeeds
2	2	`[[#2301dce0]]`	$section
3	1	`[[#2301dc40]]`	', b.title)AS section,'
3	2	`[[#2301dc40]]`	', b.title) AS section,'
4	1	`[[#2301db20]]`	' FROM #__newsfeeds AS a'
4	2	`[[#2301db20]]`	' FROM #__weblinks AS a'