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

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