Code Duplication    Length = 11-15 lines in 4 locations

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

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

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

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