Code Duplication    Length = 11-15 lines in 4 locations

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

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

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

@@ 1795-1805 (lines=11) @@
1792
        }
1793
1794
        // relation type
1795
        if (isset($relationType)) {
1796
            $query->where(
1797
                $query->expr->gt(
1798
                    $query->expr->bitAnd(
1799
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1800
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1801
                    ),
1802
                    0
1803
                )
1804
            );
1805
        }
1806
1807
        $statement = $query->prepare();
1808
        $statement->execute();
@@ 1852-1862 (lines=11) @@
1849
        );
1850
1851
        // relation type
1852
        if (isset($relationType)) {
1853
            $query->where(
1854
                $query->expr->gt(
1855
                    $query->expr->bitAnd(
1856
                        $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'),
1857
                        $query->bindValue($relationType, null, \PDO::PARAM_INT)
1858
                    ),
1859
                    0
1860
                )
1861
            );
1862
        }
1863
1864
        $statement = $query->prepare();
1865