Compare text

Find the difference between two text files

Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Tools
Diffchecker Desktop icon
Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

query_diff

Created Diff never expires
28 removals
Words removed36
Total words487
Words removed (%)7.39
181 lines
31 additions
Words added34
Total words485
Words added (%)7.01
184 lines
SELECT "epics".*
SELECT "epics".*
FROM "epics"
FROM "epics"
WHERE "epics"."group_id" IN
WHERE "epics"."group_id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND "namespaces"."id" IN
AND "namespaces"."id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}')))
traversal_ids @> ('{6543}')))
AND (
AND (
id IN (
id IN (
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids && array
traversal_ids && array
(
(
select "members"."source_id"
select "members"."source_id"
FROM "members"
FROM "members"
LEFT OUTER JOIN "users"
LEFT OUTER JOIN "users"
ON "users"."id" = "members"."user_id"
ON "users"."id" = "members"."user_id"
WHERE "members"."type" = 'GroupMember'
WHERE "members"."type" = 'GroupMember'
AND "members"."source_type" = 'Namespace'
AND "members"."source_type" = 'Namespace'
AND "users"."state" = 'active'
AND "users"."state" = 'active'
AND "members"."state" = 0
AND "members"."state" = 0
AND "members"."requested_at" IS NULL
AND "members"."requested_at" IS NULL
AND "members"."invite_token" IS NULL
AND "members"."invite_token" IS NULL
AND (
AND (
members.access_level > 5)
members.access_level > 5)
AND "members"."source_id" IN
AND "members"."source_id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}')))
traversal_ids @> ('{6543}')))
AND (
AND (
access_level >= 10)
access_level >= 10)
AND "members"."user_id" = 402401))) UNION
AND "members"."user_id" = 402401))) UNION
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids && array
traversal_ids && array
(
(
SELECT "group_group_links"."shared_group_id"
SELECT "group_group_links"."shared_group_id"
FROM "group_group_links"
FROM "group_group_links"
WHERE "group_group_links"."shared_group_id" IN
WHERE "group_group_links"."shared_group_id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}')))
traversal_ids @> ('{6543}')))
AND (
AND (
group_access >= 10)
group_access >= 10)
AND "group_group_links"."shared_with_group_id" IN
AND "group_group_links"."shared_with_group_id" IN
(
(
SELECT "members"."source_id"
SELECT "members"."source_id"
FROM "members"
FROM "members"
WHERE "members"."type" = 'GroupMember'
WHERE "members"."type" = 'GroupMember'
AND "members"."source_type" = 'Namespace'
AND "members"."source_type" = 'Namespace'
AND "members"."user_id" = 402401
AND "members"."user_id" = 402401
AND "members"."user_id" IS NOT NULL
AND "members"."user_id" IS NOT NULL
AND "members"."state" = 0
AND "members"."state" = 0
AND "members"."requested_at" IS NULL
AND "members"."requested_at" IS NULL
AND (
AND (
members.access_level > 5)))::int[])) UNION
members.access_level > 5)))::int[])) UNION
(
(
SELECT unnest(traversal_ids)
SELECT unnest(traversal_ids)
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND "namespaces"."id" IN
AND "namespaces"."id" IN
(
(
SELECT "projects"."namespace_id"
SELECT "projects"."namespace_id"
FROM "projects"
FROM "projects"
INNER JOIN "members"
WHERE "projects"."namespace_id" IN
ON "projects"."id" = "members"."source_id"
(
WHERE "members"."type" = 'ProjectMember'
SELECT "namespaces"."id"
AND "members"."source_type" = 'Project'
FROM "namespaces"
AND "members"."user_id" = 402401
WHERE "namespaces"."type" = 'Group'
AND "members"."requested_at" IS NULL
AND (
AND "projects"."namespace_id" IN
traversal_ids @> ('{6543}')))
(
AND (
SELECT "namespaces"."id"
EXISTS
FROM "namespaces"
(
WHERE "namespaces"."type" = 'Group'
SELECT 1
AND (
FROM "project_authorizations"
traversal_ids @> ('{6543}'))))) UNION
WHERE "project_authorizations"."user_id" = 402401
AND (
project_authorizations.project_id = projects.id))
OR projects.visibility_level IN (10,20)))) UNION
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}'))
traversal_ids @> ('{6543}'))
AND (
AND (
visibility_level > 0)))))
visibility_level > 0)))))
AND (
AND (
"epics"."confidential" = false
"epics"."confidential" = false
OR "epics"."confidential" = true
OR "epics"."confidential" = true
AND "epics"."group_id" IN
AND "epics"."group_id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND "namespaces"."id" IN
AND "namespaces"."id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}')))
traversal_ids @> ('{6543}')))
AND (
AND (
id IN (
id IN (
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids && array
traversal_ids && array
(
(
SELECT "members"."source_id"
SELECT "members"."source_id"
FROM "members"
FROM "members"
LEFT OUTER JOIN "users"
LEFT OUTER JOIN "users"
ON "users"."id" = "members"."user_id"
ON "users"."id" = "members"."user_id"
WHERE "members"."type" = 'GroupMember'
WHERE "members"."type" = 'GroupMember'
AND "members"."source_type" = 'Namespace'
AND "members"."source_type" = 'Namespace'
AND "users"."state" = 'active'
AND "users"."state" = 'active'
AND "members"."state" = 0
AND "members"."state" = 0
AND "members"."requested_at" IS NULL
AND "members"."requested_at" IS NULL
AND "members"."invite_token" IS NULL
AND "members"."invite_token" IS NULL
AND (
AND (
members.access_level > 5)
members.access_level > 5)
AND "members"."source_id" IN
AND "members"."source_id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}')))
traversal_ids @> ('{6543}')))
AND (
AND (
access_level >= 20)
access_level >= 20)
AND "members"."user_id" = 402401))) UNION
AND "members"."user_id" = 402401))) UNION
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids && array
traversal_ids && array
(
(
SELECT "group_group_links"."shared_group_id"
SELECT "group_group_links"."shared_group_id"
FROM "group_group_links"
FROM "group_group_links"
WHERE "group_group_links"."shared_group_id" IN
WHERE "group_group_links"."shared_group_id" IN
(
(
SELECT "namespaces"."id"
SELECT "namespaces"."id"
FROM "namespaces"
FROM "namespaces"
WHERE "namespaces"."type" = 'Group'
WHERE "namespaces"."type" = 'Group'
AND (
AND (
traversal_ids @> ('{6543}')))
traversal_ids @> ('{6543}')))
AND (
AND (
group_access >= 20)
group_access >= 20)
AND "group_group_links"."shared_with_group_id" IN
AND "group_group_links"."shared_with_group_id" IN
(
(
SELECT "members"."source_id"
SELECT "members"."source_id"
FROM "members"
FROM "members"
WHERE "members"."type" = 'GroupMember'
WHERE "members"."type" = 'GroupMember'
AND "members"."source_type" = 'Namespace'
AND "members"."source_type" = 'Namespace'
AND "members"."user_id" = 402401
AND "members"."user_id" = 402401
AND "members"."user_id" IS NOT NULL
AND "members"."user_id" IS NOT NULL
AND "members"."state" = 0
AND "members"."state" = 0
AND "members"."requested_at" IS NULL
AND "members"."requested_at" IS NULL
AND (
AND (
members.access_level > 5)))::int[]))))))
members.access_level > 5)))::int[]))))))
ORDER BY "epics"."id" DESC
ORDER BY "epics"."id" DESC
Saved diffs