Code Duplication    Length = 11-15 lines in 4 locations

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

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

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

@@ 1670-1680 (lines=11) @@
1667
        }
1668
1669
        // relation type
1670
        if (isset($relationType)) {
1671
            $query->where(
1672
                $query->expr->gt(
1673
                    $query->expr->bitAnd(
1674
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1675
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1676
                    ),
1677
                    0
1678
                )
1679
            );
1680
        }
1681
1682
        $statement = $query->prepare();
1683
        $statement->execute();
@@ 1727-1737 (lines=11) @@
1724
        );
1725
1726
        // relation type
1727
        if (isset($relationType)) {
1728
            $query->where(
1729
                $query->expr->gt(
1730
                    $query->expr->bitAnd(
1731
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1732
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1733
                    ),
1734
                    0
1735
                )
1736
            );
1737
        }
1738
1739
        $statement = $query->prepare();
1740