Code Duplication    Length = 11-15 lines in 4 locations

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

@@ 141-151 (lines=11) @@
138
            )
139
        );
140
141
        if ($languageId !== false) {
142
            $query->where(
143
                $query->expr->gt(
144
                    $query->expr->bitAnd(
145
                        $this->dbHandler->quoteColumn('lang_mask'),
146
                        $query->bindValue($languageId, null, \PDO::PARAM_INT)
147
                    ),
148
                    0
149
                )
150
            );
151
        }
152
153
        $statement = $query->prepare();
154
        $statement->execute();
@@ 205-219 (lines=15) @@
202
            $limit,
203
            $offset
204
        );
205
        if (isset($languageCode)) {
206
            $query->where(
207
                $query->expr->gt(
208
                    $query->expr->bitAnd(
209
                        $this->dbHandler->quoteColumn('lang_mask'),
210
                        $query->bindValue(
211
                            $this->languageMaskGenerator->generateLanguageIndicator($languageCode, false),
212
                            null,
213
                            \PDO::PARAM_INT
214
                        )
215
                    ),
216
                    0
217
                )
218
            );
219
        }
220
        $statement = $query->prepare();
221
        $statement->execute();
222

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

@@ 1775-1785 (lines=11) @@
1772
        }
1773
1774
        // relation type
1775
        if (isset($relationType)) {
1776
            $query->where(
1777
                $query->expr->gt(
1778
                    $query->expr->bitAnd(
1779
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1780
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1781
                    ),
1782
                    0
1783
                )
1784
            );
1785
        }
1786
1787
        $statement = $query->prepare();
1788
        $statement->execute();
@@ 1832-1842 (lines=11) @@
1829
        );
1830
1831
        // relation type
1832
        if (isset($relationType)) {
1833
            $query->where(
1834
                $query->expr->gt(
1835
                    $query->expr->bitAnd(
1836
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1837
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1838
                    ),
1839
                    0
1840
                )
1841
            );
1842
        }
1843
1844
        $statement = $query->prepare();
1845