Code Duplication    Length = 11-15 lines in 4 locations

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

@@ 127-137 (lines=11) @@
124
            )
125
        );
126
127
        if ($languageId !== false) {
128
            $query->where(
129
                $query->expr->gt(
130
                    $query->expr->bitAnd(
131
                        $this->dbHandler->quoteColumn('lang_mask'),
132
                        $query->bindValue($languageId, null, \PDO::PARAM_INT)
133
                    ),
134
                    0
135
                )
136
            );
137
        }
138
139
        $statement = $query->prepare();
140
        $statement->execute();
@@ 191-205 (lines=15) @@
188
            $limit,
189
            $offset
190
        );
191
        if (isset($languageCode)) {
192
            $query->where(
193
                $query->expr->gt(
194
                    $query->expr->bitAnd(
195
                        $this->dbHandler->quoteColumn('lang_mask'),
196
                        $query->bindValue(
197
                            $this->languageMaskGenerator->generateLanguageIndicator($languageCode, false),
198
                            null,
199
                            \PDO::PARAM_INT
200
                        )
201
                    ),
202
                    0
203
                )
204
            );
205
        }
206
        $statement = $query->prepare();
207
        $statement->execute();
208

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

@@ 1603-1613 (lines=11) @@
1600
        }
1601
1602
        // relation type
1603
        if (isset($relationType)) {
1604
            $query->where(
1605
                $query->expr->gt(
1606
                    $query->expr->bitAnd(
1607
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1608
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1609
                    ),
1610
                    0
1611
                )
1612
            );
1613
        }
1614
1615
        $statement = $query->prepare();
1616
        $statement->execute();
@@ 1660-1670 (lines=11) @@
1657
        );
1658
1659
        // relation type
1660
        if (isset($relationType)) {
1661
            $query->where(
1662
                $query->expr->gt(
1663
                    $query->expr->bitAnd(
1664
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1665
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1666
                    ),
1667
                    0
1668
                )
1669
            );
1670
        }
1671
1672
        $statement = $query->prepare();
1673