Code Duplication    Length = 11-15 lines in 4 locations

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

@@ 1803-1813 (lines=11) @@
1800
        }
1801
1802
        // relation type
1803
        if (isset($relationType)) {
1804
            $query->where(
1805
                $query->expr->gt(
1806
                    $query->expr->bitAnd(
1807
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1808
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1809
                    ),
1810
                    0
1811
                )
1812
            );
1813
        }
1814
1815
        $statement = $query->prepare();
1816
        $statement->execute();
@@ 1860-1870 (lines=11) @@
1857
        );
1858
1859
        // relation type
1860
        if (isset($relationType)) {
1861
            $query->where(
1862
                $query->expr->gt(
1863
                    $query->expr->bitAnd(
1864
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1865
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1866
                    ),
1867
                    0
1868
                )
1869
            );
1870
        }
1871
1872
        $statement = $query->prepare();
1873

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