Code Duplication    Length = 5-5 lines in 2 locations

lib/Db/NextNoteMapper.php 2 locations

@@ 87-91 (lines=5) @@
84
			$params[] = $group;
85
		}
86
		$deletedSql = '';
87
		if ($deleted !== false) {
88
			$deleted = (int) $deleted;
89
			$deletedSql = 'and n.deleted = ?';
90
			$params[] = $deleted;
91
		}
92
		$sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE `uid` = ? $groupSql $deletedSql";
93
		$results = [];
94
		foreach ($this->execute($sql, $params)->fetchAll() as $item) {
@@ 119-123 (lines=5) @@
116
		}
117
118
		$deletedSql = '';
119
		if ($deleted !== false) {
120
			$deleted = (int) $deleted;
121
			$deletedSql = 'and n.deleted = ?';
122
			$params[] = $deleted;
123
		}
124
125
		$sql = "SELECT n.uid, n.id, n.name, n.grouping, n.shared, n.mtime, n.deleted, p.pid, GROUP_CONCAT(p.note SEPARATOR '') as note FROM *PREFIX*ownnote n INNER JOIN *PREFIX*ownnote_parts p ON n.id = p.id WHERE n.deleted = 0 $uidSql and n.grouping = ? GROUP BY p.id";
126
		$results = [];