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
121 lines
1 addition
114 lines
SELECT COUNT(*)
SELECT COUNT(*)
FROM "issues"
FROM "issues"
INNER JOIN "projects" ON "projects"."id" = "issues"."project_id"
INNER JOIN "projects" ON "projects"."id" = "issues"."project_id"
AND "projects"."pending_delete" = 'f'
AND "projects"."pending_delete" = 'f'
WHERE "issues"."deleted_at" IS NULL
WHERE "issues"."deleted_at" IS NULL
AND ( issues.confidential IS NULL
AND ( issues.confidential IS NULL
OR issues.confidential IS FALSE
OR issues.confidential IS FALSE
OR (issues.confidential = TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 669
AND (issues.author_id = 669
OR issues.assignee_id = 669
OR issues.assignee_id = 669
OR issues.project_id IN
OR issues.project_id IN
(SELECT "projects"."id"
(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"
WHERE "projects"."pending_delete" = 'f'
WHERE "projects"."pending_delete" = 'f'
AND "project_authorizations"."user_id" = 669
AND "project_authorizations"."user_id" = 669
AND (project_authorizations.access_level >= 20)
AND (project_authorizations.access_level >= 20)
ORDER BY "projects"."id" DESC))))
ORDER BY "projects"."id" DESC))))
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 "issues"."project_id"
(SELECT "issues"."project_id"
FROM "issues"
FROM "issues"
WHERE "issues"."deleted_at" IS NULL
WHERE "issues"."deleted_at" IS NULL
AND ( issues.confidential IS NULL
AND ( issues.confidential IS NULL
OR issues.confidential IS FALSE
OR issues.confidential IS FALSE
OR (issues.confidential = TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 669
AND (issues.author_id = 669
OR issues.assignee_id = 669
OR issues.assignee_id = 669
OR issues.project_id IN
OR issues.project_id IN
(SELECT "projects"."id"
(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"
WHERE "projects"."pending_delete" = 'f'
WHERE "projects"."pending_delete" = 'f'
AND "project_authorizations"."user_id" = 669
AND "project_authorizations"."user_id" = 669
AND (project_authorizations.access_level >= 20)
AND (project_authorizations.access_level >= 20)
ORDER BY "projects"."id" DESC)))))
ORDER BY "projects"."id" DESC)))))
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 "issues"."project_id"
(SELECT "issues"."project_id"
FROM "issues"
FROM "issues"
WHERE "issues"."deleted_at" IS NULL
WHERE "issues"."deleted_at" IS NULL
AND ( issues.confidential IS NULL
AND ( issues.confidential IS NULL
OR issues.confidential IS FALSE
OR issues.confidential IS FALSE
OR (issues.confidential = TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 669
AND (issues.author_id = 669
OR issues.assignee_id = 669
OR issues.assignee_id = 669
OR issues.project_id IN
OR issues.project_id IN
(SELECT "projects"."id"
(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"
WHERE "projects"."pending_delete" = 'f'
WHERE "projects"."pending_delete" = 'f'
AND "project_authorizations"."user_id" = 669
AND "project_authorizations"."user_id" = 669
AND (project_authorizations.access_level >= 20)
AND (project_authorizations.access_level >= 20)
ORDER BY "projects"."id" DESC)))))
ORDER BY "projects"."id" DESC)))))
AND ("project_features"."issues_access_level" = 20
AND ("project_features"."issues_access_level" = 20
OR "project_features"."issues_access_level" IS NULL)
OR "project_features"."issues_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 "issues"."project_id"
(SELECT "issues"."project_id"
FROM "issues"
FROM "issues"
WHERE "issues"."deleted_at" IS NULL
WHERE "issues"."deleted_at" IS NULL
AND ( issues.confidential IS NULL
AND ( issues.confidential IS NULL
OR issues.confidential IS FALSE
OR issues.confidential IS FALSE
OR (issues.confidential = TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 669
AND (issues.author_id = 669
OR issues.assignee_id = 669
OR issues.assignee_id = 669
OR issues.project_id IN
OR issues.project_id IN
(SELECT "projects"."id"
(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"
WHERE "projects"."pending_delete" = 'f'
WHERE "projects"."pending_delete" = 'f'
AND "project_authorizations"."user_id" = 669
AND "project_authorizations"."user_id" = 669
AND (project_authorizations.access_level >= 20)
AND (project_authorizations.access_level >= 20)
ORDER BY "projects"."id" DESC)))))
ORDER BY "projects"."id" DESC)))))
AND "project_authorizations"."user_id" = 669
AND "project_features"."issues_access_level" = 10)
AND "project_features"."issues_access_level" = 10)
AND "issues"."project_id" IN
AND "issues"."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 ("issues"."title" ILIKE '%seed%'
AND ("issues"."title" ILIKE '%seed%'
OR "issues"."description" ILIKE '%seed%')
OR "issues"."description" ILIKE '%seed%')
Saved diffs