Code Duplication    Length = 11-15 lines in 4 locations

eZ/Publish/Core/Persistence/Legacy/Content/UrlAlias/Gateway/DoctrineDatabase.php 2 locations

@@ 153-163 (lines=11) @@
150
            )
151
        );
152
153
        if ($languageId !== false) {
154
            $query->where(
155
                $query->expr->gt(
156
                    $query->expr->bitAnd(
157
                        $this->dbHandler->quoteColumn('lang_mask'),
158
                        $query->bindValue($languageId, null, \PDO::PARAM_INT)
159
                    ),
160
                    0
161
                )
162
            );
163
        }
164
165
        $statement = $query->prepare();
166
        $statement->execute();
@@ 217-231 (lines=15) @@
214
            $limit,
215
            $offset
216
        );
217
        if (isset($languageCode)) {
218
            $query->where(
219
                $query->expr->gt(
220
                    $query->expr->bitAnd(
221
                        $this->dbHandler->quoteColumn('lang_mask'),
222
                        $query->bindValue(
223
                            $this->languageMaskGenerator->generateLanguageIndicator($languageCode, false),
224
                            null,
225
                            \PDO::PARAM_INT
226
                        )
227
                    ),
228
                    0
229
                )
230
            );
231
        }
232
        $statement = $query->prepare();
233
        $statement->execute();
234

eZ/Publish/Core/Persistence/Legacy/Content/Gateway/DoctrineDatabase.php 2 locations

@@ 1808-1818 (lines=11) @@
1805
        }
1806
1807
        // relation type
1808
        if (isset($relationType)) {
1809
            $query->where(
1810
                $query->expr->gt(
1811
                    $query->expr->bitAnd(
1812
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1813
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1814
                    ),
1815
                    0
1816
                )
1817
            );
1818
        }
1819
1820
        $statement = $query->prepare();
1821
        $statement->execute();
@@ 1865-1875 (lines=11) @@
1862
        );
1863
1864
        // relation type
1865
        if (isset($relationType)) {
1866
            $query->where(
1867
                $query->expr->gt(
1868
                    $query->expr->bitAnd(
1869
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1870
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1871
                    ),
1872
                    0
1873
                )
1874
            );
1875
        }
1876
1877
        $statement = $query->prepare();
1878