Compare text

Find the difference between two text files
Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Tools

Untitled diff

Created Diff never expires
8 removals
84 lines
1 addition
77 lines
SELECT COUNT(*)
SELECT COUNT(*)
FROM "merge_requests"
FROM "merge_requests"
INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id"
INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id"
AND "projects"."pending_delete" = 'f'
AND "projects"."pending_delete" = 'f'
WHERE "merge_requests"."deleted_at" IS NULL
WHERE "merge_requests"."deleted_at" IS NULL
AND ("projects"."visibility_level" IN (20,
AND ("projects"."visibility_level" IN (20,
10)
10)
OR EXISTS
OR EXISTS
(SELECT 1
(SELECT 1
FROM "project_authorizations"
FROM "project_authorizations"
WHERE "projects"."id" = "project_authorizations"."project_id"
WHERE "projects"."id" = "project_authorizations"."project_id"
AND "project_authorizations"."user_id" = 669))
AND "project_authorizations"."user_id" = 669))
AND "projects"."id" IN
AND "projects"."id" IN
(SELECT "merge_requests"."target_project_id"
(SELECT "merge_requests"."target_project_id"
FROM "merge_requests"
FROM "merge_requests"
WHERE "merge_requests"."deleted_at" IS NULL)
WHERE "merge_requests"."deleted_at" IS NULL)
AND "projects"."id" IN
AND "projects"."id" IN
(SELECT "projects"."id"
(SELECT "projects"."id"
FROM "projects"
FROM "projects"
LEFT JOIN project_features ON projects.id = project_features.project_id
LEFT JOIN project_features ON projects.id = project_features.project_id
WHERE ("projects"."visibility_level" IN (20,
WHERE ("projects"."visibility_level" IN (20,
10)
10)
OR EXISTS
OR EXISTS
(SELECT 1
(SELECT 1
FROM "project_authorizations"
FROM "project_authorizations"
WHERE "projects"."id" = "project_authorizations"."project_id"
WHERE "projects"."id" = "project_authorizations"."project_id"
AND "project_authorizations"."user_id" = 669))
AND "project_authorizations"."user_id" = 669))
AND "projects"."id" IN
AND "projects"."id" IN
(SELECT "merge_requests"."target_project_id"
(SELECT "merge_requests"."target_project_id"
FROM "merge_requests"
FROM "merge_requests"
WHERE "merge_requests"."deleted_at" IS NULL)
WHERE "merge_requests"."deleted_at" IS NULL)
AND ("project_features"."merge_requests_access_level" = 20
AND ("project_features"."merge_requests_access_level" = 20
OR "project_features"."merge_requests_access_level" IS NULL)
OR "project_features"."merge_requests_access_level" IS NULL)
UNION SELECT "projects"."id"
UNION SELECT "projects"."id"
FROM "projects"
FROM "projects"
INNER JOIN "project_authorizations" ON "projects"."id" = "project_authorizations"."project_id"
INNER JOIN "project_authorizations" ON "projects"."id" = "project_authorizations"."project_id"
LEFT JOIN project_features ON projects.id = project_features.project_id
LEFT JOIN project_features ON projects.id = project_features.project_id
WHERE ("projects"."visibility_level" IN (20,
WHERE ("projects"."visibility_level" IN (20,
10)
10)
OR EXISTS
OR EXISTS
(SELECT 1
(SELECT 1
FROM "project_authorizations"
FROM "project_authorizations"
WHERE "projects"."id" = "project_authorizations"."project_id"
WHERE "projects"."id" = "project_authorizations"."project_id"
AND "project_authorizations"."user_id" = 669))
AND "project_authorizations"."user_id" = 669))
AND "project_authorizations"."user_id" = 669
AND ("projects"."visibility_level" IN (20,
10)
OR EXISTS
(SELECT 1
FROM "project_authorizations"
WHERE "projects"."id" = "project_authorizations"."project_id"
AND "project_authorizations"."user_id" = 669))
AND "projects"."id" IN
AND "projects"."id" IN
(SELECT "merge_requests"."target_project_id"
(SELECT "merge_requests"."target_project_id"
FROM "merge_requests"
FROM "merge_requests"
WHERE "merge_requests"."deleted_at" IS NULL)
WHERE "merge_requests"."deleted_at" IS NULL)
AND "project_authorizations"."user_id" = 669
AND "project_features"."merge_requests_access_level" = 10)
AND "project_features"."merge_requests_access_level" = 10)
AND (merge_requests.id IN
AND (merge_requests.id IN
(SELECT "merge_requests"."id"
(SELECT "merge_requests"."id"
FROM "merge_requests"
FROM "merge_requests"
WHERE "merge_requests"."source_project_id" IN
WHERE "merge_requests"."source_project_id" IN
(SELECT "projects"."id"
(SELECT "projects"."id"
FROM "projects"
FROM "projects"
WHERE ("projects"."visibility_level" IN (20,
WHERE ("projects"."visibility_level" IN (20,
10)
10)
OR EXISTS
OR EXISTS
(SELECT 1
(SELECT 1
FROM "project_authorizations"
FROM "project_authorizations"
WHERE "projects"."id" = "project_authorizations"."project_id"
WHERE "projects"."id" = "project_authorizations"."project_id"
AND "project_authorizations"."user_id" = 669)))
AND "project_authorizations"."user_id" = 669)))
UNION SELECT "merge_requests"."id"
UNION SELECT "merge_requests"."id"
FROM "merge_requests"
FROM "merge_requests"
WHERE "merge_requests"."target_project_id" IN
WHERE "merge_requests"."target_project_id" IN
(SELECT "projects"."id"
(SELECT "projects"."id"
FROM "projects"
FROM "projects"
WHERE ("projects"."visibility_level" IN (20,
WHERE ("projects"."visibility_level" IN (20,
10)
10)
OR EXISTS
OR EXISTS
(SELECT 1
(SELECT 1
FROM "project_authorizations"
FROM "project_authorizations"
WHERE "projects"."id" = "project_authorizations"."project_id"
WHERE "projects"."id" = "project_authorizations"."project_id"
AND "project_authorizations"."user_id" = 669)))))
AND "project_authorizations"."user_id" = 669)))))
AND ("merge_requests"."title" ILIKE '%seed%'
AND ("merge_requests"."title" ILIKE '%seed%'
OR "merge_requests"."description" ILIKE '%seed%')
OR "merge_requests"."description" ILIKE '%seed%')
Saved diffs