offending_query

gistfile1.txt

WITH "table_permissions" AS (SELECT "mt"."id", "dp"."perm_type", "dp"."perm_value" FROM "data_permissions" AS "dp" INNER JOIN "metabase_table" AS "mt" ON "mt"."id" = "dp"."table_id" WHERE ("dp"."table_id" IS NOT NULL) AND ("dp"."group_id" IN (SELECT "group_id" FROM "permissions_group_membership" WHERE "user_id" = 526)) AND (("dp"."perm_type" = 'perms/view-data') OR ("dp"."perm_type" = 'perms/create-queries')) AND ("mt"."active" = TRUE) UNION ALL SELECT "mt"."id", "dp"."perm_type", "dp"."perm_value" FROM "data_permissions" AS "dp" INNER JOIN "metabase_table" AS "mt" ON "mt"."db_id" = "dp"."db_id" WHERE ("dp"."table_id" IS NULL) AND ("dp"."group_id" IN (SELECT "group_id" FROM "permissions_group_membership" WHERE "user_id" = 526)) AND (("dp"."perm_type" = 'perms/view-data') OR ("dp"."perm_type" = 'perms/create-queries')) AND ("mt"."active" = TRUE)), "permitted_tables" AS (SELECT "dp"."id" FROM "table_permissions" AS "dp" GROUP BY "dp"."id" HAVING (CASE WHEN MIN(CASE WHEN "dp"."perm_type" = 'perms/view-data' THEN CASE WHEN "dp"."perm_value" = 'unrestricted' THEN 0 WHEN "dp"."perm_value" = 'blocked' THEN 1 WHEN "dp"."perm_value" = 'legacy-no-self-service' THEN 2 END END) = 0 THEN 0 WHEN MIN(CASE WHEN "dp"."perm_type" = 'perms/view-data' THEN CASE WHEN "dp"."perm_value" = 'unrestricted' THEN 0 WHEN "dp"."perm_value" = 'blocked' THEN 1 WHEN "dp"."perm_value" = 'legacy-no-self-service' THEN 2 END END) = 1 THEN 2 WHEN MIN(CASE WHEN "dp"."perm_type" = 'perms/view-data' THEN CASE WHEN "dp"."perm_value" = 'unrestricted' THEN 0 WHEN "dp"."perm_value" = 'blocked' THEN 1 WHEN "dp"."perm_value" = 'legacy-no-self-service' THEN 2 END END) = 2 THEN 1 END <= 0) AND (MIN(CASE WHEN "dp"."perm_type" = 'perms/create-queries' THEN CASE WHEN "dp"."perm_value" = 'query-builder-and-native' THEN 0 WHEN "dp"."perm_value" = 'query-builder' THEN 1 WHEN "dp"."perm_value" = 'no' THEN 2 END END) <= 1)) SELECT "legacy_input", GREATEST(30 - ((EXTRACT(epoch FROM (NOW() - COALESCE("last_viewed_at", "model_updated_at")))) / 86400.0), 0) / 30 AS "recency", COALESCE(CAST("pinned" AS INTEGER), 0) AS "pinned", CASE WHEN ("search_index"."model" IN ('card', 'metric', 'dataset')) AND ("card_bookmark"."card_id" IS NOT NULL) THEN 1 WHEN ("search_index"."model" = 'collection') AND ("collection_bookmark"."collection_id" IS NOT NULL) THEN 1 WHEN ("search_index"."model" = 'dashboard') AND ("dashboard_bookmark"."dashboard_id" IS NOT NULL) THEN 1 ELSE 0 END AS "bookmarked", COALESCE(CAST("official_collection" AS INTEGER), 0) AS "official-collection", LEAST(1, COALESCE("dashboardcard_count", 0) / GREATEST(1, 10.0)) AS "dashboard", COALESCE(CASE WHEN LOWER("search_index"."name") LIKE $1 THEN 1 ELSE 0 END, 0) AS "prefix", COALESCE(CASE WHEN "search_index"."creator_id" = $2 THEN 1 ELSE 0 END, 0) AS "mine", COALESCE(CASE WHEN LOWER("search_index"."name") = LOWER($3) THEN 1 ELSE 0 END, 0) AS "exact", LEAST(1, COALESCE("view_count", 0) / GREATEST(1, CAST(CASE WHEN "search_index"."model" = 'card' THEN $4 WHEN "search_index"."model" = 'dashboard' THEN $5 WHEN "search_index"."model" = 'dataset' THEN $6 WHEN "search_index"."model" = 'document' THEN $7 WHEN "search_index"."model" = 'metric' THEN $8 WHEN "search_index"."model" = 'table' THEN $9 END AS FLOAT))) AS "view-count", GREATEST(30 - ((EXTRACT(epoch FROM (NOW() - (SELECT CASE WHEN "search_index"."model" = 'transform' THEN (CAST(NOW() AS timestamp) + INTERVAL '-1 day') ELSE MAX("recent_views"."timestamp") END AS "last_viewed_at" FROM "recent_views" WHERE ("recent_views"."user_id" = $10) AND (CAST("recent_views"."model_id" AS TEXT) = "search_index"."model_id") AND ("recent_views"."model" = CASE WHEN "search_index"."model" = 'dataset' THEN 'card' WHEN "search_index"."model" = 'metric' THEN 'card' ELSE "search_index"."model" END))))) / 86400.0), 0) / 30 AS "user-recency", COALESCE(CAST("verified" AS INTEGER), 0) AS "verified", TS_RANK('{0, 0.2, 0.4, 1.0}', "search_vector", "query", 0) AS "text", CASE WHEN "search_index"."model" = $11 THEN $12 WHEN "search_index"."model" = $13 THEN $14 WHEN "search_index"."model" = $15 THEN 0.8461538461538461 WHEN "search_index"."model" = $16 THEN 0.7692307692307693 WHEN "search_index"."model" = $17 THEN $18 WHEN "search_index"."model" = $19 THEN 0.6153846153846154 WHEN "search_index"."model" = $20 THEN $21 WHEN "search_index"."model" = $22 THEN $23 WHEN "search_index"."model" = $24 THEN $25 WHEN "search_index"."model" = $26 THEN 0.3076923076923077 WHEN "search_index"."model" = $27 THEN 0.23076923076923078 WHEN "search_index"."model" = $28 THEN 0.15384615384615385 WHEN "search_index"."model" = $29 THEN $30 ELSE 0.01 END AS "model", ((((((((((((1 * (GREATEST(30 - ((EXTRACT(epoch FROM (NOW() - COALESCE("last_viewed_at", "model_updated_at")))) / 86400.0), 0) / 30)) + (0 * COALESCE(CAST("pinned" AS INTEGER), 0))) + (1 * CASE WHEN ("search_index"."model" IN ('card', 'metric', 'dataset')) AND ("card_bookmark"."card_id" IS NOT NULL) THEN 1 WHEN ("search_index"."model" = 'collection') AND ("collection_bookmark"."collection_id" IS NOT NULL) THEN 1 WHEN ("search_index"."model" = 'dashboard') AND ("dashboard_bookmark"."dashboard_id" IS NOT NULL) THEN 1 ELSE 0 END)) + (1 * COALESCE(CAST("official_collection" AS INTEGER), 0))) + (0 * LEAST(1, COALESCE("dashboardcard_count", 0) / GREATEST(1, 10.0)))) + (5 * COALESCE(CASE WHEN LOWER("search_index"."name") LIKE $31 THEN 1 ELSE 0 END, 0))) + (1 * COALESCE(CASE WHEN "search_index"."creator_id" = $32 THEN 1 ELSE 0 END, 0))) + (5 * COALESCE(CASE WHEN LOWER("search_index"."name") = LOWER($33) THEN 1 ELSE 0 END, 0))) + (2 * LEAST(1, COALESCE("view_count", 0) / GREATEST(1, CAST(CASE WHEN "search_index"."model" = 'card' THEN $34 WHEN "search_index"."model" = 'dashboard' THEN $35 WHEN "search_index"."model" = 'dataset' THEN $36 WHEN "search_index"."model" = 'document' THEN $37 WHEN "search_index"."model" = 'metric' THEN $38 WHEN "search_index"."model" = 'table' THEN $39 END AS FLOAT))))) + (5 * (GREATEST(30 - ((EXTRACT(epoch FROM (NOW() - (SELECT CASE WHEN "search_index"."model" = 'transform' THEN (CAST(NOW() AS timestamp) + INTERVAL '-1 day') ELSE MAX("recent_views"."timestamp") END AS "last_viewed_at" FROM "recent_views" WHERE ("recent_views"."user_id" = $40) AND (CAST("recent_views"."model_id" AS TEXT) = "search_index"."model_id") AND ("recent_views"."model" = CASE WHEN "search_index"."model" = 'dataset' THEN 'card' WHEN "search_index"."model" = 'metric' THEN 'card' ELSE "search_index"."model" END))))) / 86400.0), 0) / 30))) + (1 * COALESCE(CAST("verified" AS INTEGER), 0))) + (5 * TS_RANK('{0, 0.2, 0.4, 1.0}', "search_vector", "query", 0))) + (2 * CASE WHEN "search_index"."model" = $41 THEN $42 WHEN "search_index"."model" = $43 THEN $44 WHEN "search_index"."model" = $45 THEN 0.8461538461538461 WHEN "search_index"."model" = $46 THEN 0.7692307692307693 WHEN "search_index"."model" = $47 THEN $48 WHEN "search_index"."model" = $49 THEN 0.6153846153846154 WHEN "search_index"."model" = $50 THEN $51 WHEN "search_index"."model" = $52 THEN $53 WHEN "search_index"."model" = $54 THEN $55 WHEN "search_index"."model" = $56 THEN 0.3076923076923077 WHEN "search_index"."model" = $57 THEN 0.23076923076923078 WHEN "search_index"."model" = $58 THEN 0.15384615384615385 WHEN "search_index"."model" = $59 THEN $60 ELSE 0.01 END) AS "total_score" FROM "search_index__1ljxrwbvrv3_vatulajhc" AS "search_index" INNER JOIN to_tsquery('english', $61) AS "query" ON $62 = $63 LEFT JOIN "collection" AS "collection" ON "search_index"."collection_id" = "collection"."id" LEFT JOIN "card_bookmark" ON ("search_index"."model" IN ('card', 'metric', 'dataset')) AND ("card_bookmark"."user_id" = $64) AND ("search_index"."model_id" = CAST("card_bookmark"."card_id" AS TEXT)) LEFT JOIN "collection_bookmark" ON ("search_index"."model" = 'collection') AND ("collection_bookmark"."user_id" = $65) AND ("search_index"."model_id" = CAST("collection_bookmark"."collection_id" AS TEXT)) LEFT JOIN "dashboard_bookmark" ON ("search_index"."model" = 'dashboard') AND ("dashboard_bookmark"."user_id" = $66) AND ("search_index"."model_id" = CAST("dashboard_bookmark"."dashboard_id" AS TEXT)) WHERE search_vector @@ query AND (("search_index"."model" IN ($67, $68, $69, $70)) OR (("model" = 'table') AND ("is_published" = FALSE)) OR ((("search_index"."collection_id" IS NULL) OR ("search_index"."collection_id" IN (SELECT "id" FROM (SELECT "c"."id", "c"."location", "c"."archived", "c"."archive_operation_id", "c"."archived_directly", "c"."type", "c"."namespace" FROM "collection" AS "c" WHERE EXISTS (SELECT $71 FROM "permissions" AS "p" INNER JOIN "permissions_group_membership" AS "pgm" ON "p"."group_id" = "pgm"."group_id" WHERE ("pgm"."user_id" = 526) AND ("c"."id" = "p"."collection_id") AND ("p"."perm_type" = 'perms/collection-access') AND (("p"."perm_value" = 'read-and-write') OR ("p"."perm_value" = 'read'))) UNION ALL SELECT "c"."id", "c"."location", "c"."archived", "c"."archive_operation_id", "c"."archived_directly", "c"."type", "c"."namespace" FROM "collection" AS "c" WHERE "type" = 'trash' UNION ALL SELECT "c"."id", "c"."location", "c"."archived", "c"."archive_operation_id", "c"."archived_directly", "c"."type", "c"."namespace" FROM "collection" AS "c" WHERE "id" IN (1153)) AS "c" WHERE NOT EXISTS (SELECT $72 FROM "collection" AS "sub_c" WHERE ("c"."id" = "sub_c"."id") AND ("sub_c"."namespace" = 'shared-tenant-collection'))))) AND (("collection"."namespace" IS NULL) OR ("collection"."namespace" = $73)))) AND (("search_index"."model" IN ($74, $75, $76, $77)) OR (("model" = 'table') AND ("is_published" = FALSE)) OR ((("collection"."personal_owner_id" = $78) OR ("collection"."location" LIKE $79)) OR (("search_index"."collection_id" IS NULL) OR (("collection"."personal_owner_id" IS NULL) AND ("collection"."location" NOT LIKE $80) AND ("collection"."location" NOT LIKE $81) AND ("collection"."location" NOT LIKE $82) AND ("collection"."location" NOT LIKE $83) AND ("collection"."location" NOT LIKE $84) AND ("collection"."location" NOT LIKE $85) AND ("collection"."location" NOT LIKE $86) AND ("collection"."location" NOT LIKE $87) AND ("collection"."location" NOT LIKE $88) AND ("collection"."location" NOT LIKE $89) AND ("collection"."location" NOT LIKE $90) AND ("collection"."location" NOT LIKE $91) AND ("collection"."location" NOT LIKE $92) AND ("collection"."location" NOT LIKE $93) AND ("collection"."location" NOT LIKE $94) AND ("collection"."location" NOT LIKE $95) AND ("collection"."location" NOT LIKE $96) AND ("collection"."location" NOT LIKE $97) AND ("collection"."location" NOT LIKE $98) AND ("collection"."location" NOT LIKE $99) AND ("collection"."location" NOT LIKE $100) AND ("collection"."location" NOT LIKE $101) AND ("collection"."location" NOT LIKE $102) AND ("collection"."location" NOT LIKE $103) AND ("collection"."location" NOT LIKE $104) AND ("collection"."location" NOT LIKE $105) AND ("collection"."location" NOT LIKE $106) AND ("collection"."location" NOT LIKE $107) AND ("collection"."location" NOT LIKE $108) AND ("collection"."location" NOT LIKE $109) AND ("collection"."location" NOT LIKE $110) AND ("collection"."location" NOT LIKE $111) AND ("collection"."location" NOT LIKE $112) AND ("collection"."location" NOT LIKE $113) AND ("collection"."location" NOT LIKE $114) AND ("collection"."location" NOT LIKE $115) AND ("collection"."location" NOT LIKE $116) AND ("collection"."location" NOT LIKE $117) AND ("collection"."location" NOT LIKE $118) AND ("collection"."location" NOT LIKE $119) AND ("collection"."location" NOT LIKE $120) AND ("collection"."location" NOT LIKE $121) AND ("collection"."location" NOT LIKE $122) AND ("collection"."location" NOT LIKE $123) AND ("collection"."location" NOT LIKE $124) AND ("collection"."location" NOT LIKE $125) AND ("collection"."location" NOT LIKE $126) AND ("collection"."location" NOT LIKE $127) AND ("collection"."location" NOT LIKE $128) AND ("collection"."location" NOT LIKE $129) AND ("collection"."location" NOT LIKE $130) AND ("collection"."location" NOT LIKE $131) AND ("collection"."location" NOT LIKE $132) AND ("collection"."location" NOT LIKE $133) AND ("collection"."location" NOT LIKE $134) AND ("collection"."location" NOT LIKE $135) AND ("collection"."location" NOT LIKE $136) AND ("collection"."location" NOT LIKE $137) AND ("collection"."location" NOT LIKE $138) AND ("collection"."location" NOT LIKE $139) AND ("collection"."location" NOT LIKE $140) AND ("collection"."location" NOT LIKE $141) AND ("collection"."location" NOT LIKE $142) AND ("collection"."location" NOT LIKE $143) AND ("collection"."location" NOT LIKE $144) AND ("collection"."location" NOT LIKE $145) AND ("collection"."location" NOT LIKE $146) AND ("collection"."location" NOT LIKE $147) AND ("collection"."location" NOT LIKE $148) AND ("collection"."location" NOT LIKE $149) AND ("collection"."location" NOT LIKE $150) AND ("collection"."location" NOT LIKE $151) AND ("collection"."location" NOT LIKE $152) AND ("collection"."location" NOT LIKE $153) AND ("collection"."location" NOT LIKE $154) AND ("collection"."location" NOT LIKE $155) AND ("collection"."location" NOT LIKE $156) AND ("collection"."location" NOT LIKE $157) AND ("collection"."location" NOT LIKE $158) AND ("collection"."location" NOT LIKE $159) AND ("collection"."location" NOT LIKE $160) AND ("collection"."location" NOT LIKE $161) AND ("collection"."location" NOT LIKE $162) AND ("collection"."location" NOT LIKE $163) AND ("collection"."location" NOT LIKE $164) AND ("collection"."location" NOT LIKE $165) AND ("collection"."location" NOT LIKE $166) AND ("collection"."location" NOT LIKE $167) AND ("collection"."location" NOT LIKE $168) AND ("collection"."location" NOT LIKE $169) AND ("collection"."location" NOT LIKE $170) AND ("collection"."location" NOT LIKE $171) AND ("collection"."location" NOT LIKE $172) AND ("collection"."location" NOT LIKE $173) AND ("collection"."location" NOT LIKE $174) AND ("collection"."location" NOT LIKE $175) AND ("collection"."location" NOT LIKE $176) AND ("collection"."location" NOT LIKE $177) AND ("collection"."location" NOT LIKE $178) AND ("collection"."location" NOT LIKE $179) AND ("collection"."location" NOT LIKE $180) AND ("collection"."location" NOT LIKE $181) AND ("collection"."location" NOT LIKE $182) AND ("collection"."location" NOT LIKE $183) AND ("collection"."location" NOT LIKE $184) AND ("collection"."location" NOT LIKE $185) AND ("collection"."location" NOT LIKE $186) AND ("collection"."location" NOT LIKE $187) AND ("collection"."location" NOT LIKE $188) AND ("collection"."location" NOT LIKE $189) AND ("collection"."location" NOT LIKE $190) AND ("collection"."location" NOT LIKE $191) AND ("collection"."location" NOT LIKE $192) AND ("collection"."location" NOT LIKE $193) AND ("collection"."location" NOT LIKE $194) AND ("collection"."location" NOT LIKE $195) AND ("collection"."location" NOT LIKE $196) AND ("collection"."location" NOT LIKE $197) AND ("collection"."location" NOT LIKE $198) AND ("collection"."location" NOT LIKE $199) AND ("collection"."location" NOT LIKE $200) AND ("collection"."location" NOT LIKE $201) AND ("collection"."location" NOT LIKE $202) AND ("collection"."location" NOT LIKE $203) AND ("collection"."location" NOT LIKE $204) AND ("collection"."location" NOT LIKE $205) AND ("collection"."location" NOT LIKE $206) AND ("collection"."location" NOT LIKE $207) AND ("collection"."location" NOT LIKE $208) AND ("collection"."location" NOT LIKE $209) AND ("collection"."location" NOT LIKE $210) AND ("collection"."location" NOT LIKE $211) AND ("collection"."location" NOT LIKE $212) AND ("collection"."location" NOT LIKE $213) AND ("collection"."location" NOT LIKE $214) AND ("collection"."location" NOT LIKE $215) AND ("collection"."location" NOT LIKE $216) AND ("collection"."location" NOT LIKE $217) AND ("collection"."location" NOT LIKE $218) AND ("collection"."location" NOT LIKE $219) AND ("collection"."location" NOT LIKE $220) AND ("collection"."location" NOT LIKE $221) AND ("collection"."location" NOT LIKE $222) AND ("collection"."location" NOT LIKE $223) AND ("collection"."location" NOT LIKE $224) AND ("collection"."location" NOT LIKE $225) AND ("collection"."location" NOT LIKE $226) AND ("collection"."location" NOT LIKE $227) AND ("collection"."location" NOT LIKE $228) AND ("collection"."location" NOT LIKE $229) AND ("collection"."location" NOT LIKE $230) AND ("collection"."location" NOT LIKE $231) AND ("collection"."location" NOT LIKE $232) AND ("collection"."location" NOT LIKE $233) AND ("collection"."location" NOT LIKE $234) AND ("collection"."location" NOT LIKE $235) AND ("collection"."location" NOT LIKE $236) AND ("collection"."location" NOT LIKE $237) AND ("collection"."location" NOT LIKE $238) AND ("collection"."location" NOT LIKE $239) AND ("collection"."location" NOT LIKE $240) AND ("collection"."location" NOT LIKE $241) AND ("collection"."location" NOT LIKE $242) AND ("collection"."location" NOT LIKE $243) AND ("collection"."location" NOT LIKE $244) AND ("collection"."location" NOT LIKE $245) AND ("collection"."location" NOT LIKE $246) AND ("collection"."location" NOT LIKE $247) AND ("collection"."location" NOT LIKE $248) AND ("collection"."location" NOT LIKE $249) AND ("collection"."location" NOT LIKE $250) AND ("collection"."location" NOT LIKE $251) AND ("collection"."location" NOT LIKE $252) AND ("collection"."location" NOT LIKE $253) AND ("collection"."location" NOT LIKE $254) AND ("collection"."location" NOT LIKE $255) AND ("collection"."location" NOT LIKE $256) AND ("collection"."location" NOT LIKE $257) AND ("collection"."location" NOT LIKE $258) AND ("collection"."location" NOT LIKE $259) AND ("collection"."location" NOT LIKE $260) AND ("collection"."location" NOT LIKE $261) AND ("collection"."location" NOT LIKE $262) AND ("collection"."location" NOT LIKE $263) AND ("collection"."location" NOT LIKE $264) AND ("collection"."location" NOT LIKE $265) AND ("collection"."location" NOT LIKE $266) AND ("collection"."location" NOT LIKE $267) AND ("collection"."location" NOT LIKE $268) AND ("collection"."location" NOT LIKE $269) AND ("collection"."location" NOT LIKE $270) AND ("collection"."location" NOT LIKE $271) AND ("collection"."location" NOT LIKE $272) AND ("collection"."location" NOT LIKE $273) AND ("collection"."location" NOT LIKE $274) AND ("collection"."location" NOT LIKE $275) AND ("collection"."location" NOT LIKE $276) AND ("collection"."location" NOT LIKE $277) AND ("collection"."location" NOT LIKE $278) AND ("collection"."location" NOT LIKE $279) AND ("collection"."location" NOT LIKE $280) AND ("collection"."location" NOT LIKE $281) AND ("collection"."location" NOT LIKE $282) AND ("collection"."location" NOT LIKE $283) AND ("collection"."location" NOT LIKE $284) AND ("collection"."location" NOT LIKE $285) AND ("collection"."location" NOT LIKE $286) AND ("collection"."location" NOT LIKE $287) AND ("collection"."location" NOT LIKE $288) AND ("collection"."location" NOT LIKE $289) AND ("collection"."location" NOT LIKE $290) AND ("collection"."location" NOT LIKE $291) AND ("collection"."location" NOT LIKE $292) AND ("collection"."location" NOT LIKE $293) AND ("collection"."location" NOT LIKE $294) AND ("collection"."location" NOT LIKE $295) AND ("collection"."location" NOT LIKE $296) AND ("collection"."location" NOT LIKE $297) AND ("collection"."location" NOT LIKE $298) AND ("collection"."location" NOT LIKE $299) AND ("collection"."location" NOT LIKE $300) AND ("collection"."location" NOT LIKE $301) AND ("collection"."location" NOT LIKE $302) AND ("collection"."location" NOT LIKE $303) AND ("collection"."location" NOT LIKE $304) AND ("collection"."location" NOT LIKE $305) AND ("collection"."location" NOT LIKE $306) AND ("collection"."location" NOT LIKE $307) AND ("collection"."location" NOT LIKE $308) AND ("collection"."location" NOT LIKE $309) AND ("collection"."location" NOT LIKE $310) AND ("collection"."location" NOT LIKE $311) AND ("collection"."location" NOT LIKE $312) AND ("collection"."location" NOT LIKE $313) AND ("collection"."location" NOT LIKE $314) AND ("collection"."location" NOT LIKE $315) AND ("collection"."location" NOT LIKE $316) AND ("collection"."location" NOT LIKE $317) AND ("collection"."location" NOT LIKE $318) AND ("collection"."location" NOT LIKE $319) AND ("collection"."location" NOT LIKE $320) AND ("collection"."location" NOT LIKE $321) AND ("collection"."location" NOT LIKE $322) AND ("collection"."location" NOT LIKE $323) AND ("collection"."location" NOT LIKE $324) AND ("collection"."location" NOT LIKE $325) AND ("collection"."location" NOT LIKE $326) AND ("collection"."location" NOT LIKE $327) AND ("collection"."location" NOT LIKE $328) AND ("collection"."location" NOT LIKE $329) AND ("collection"."location" NOT LIKE $330) AND ("collection"."location" NOT LIKE $331) AND ("collection"."location" NOT LIKE $332) AND ("collection"."location" NOT LIKE $333) AND ("collection"."location" NOT LIKE $334) AND ("collection"."location" NOT LIKE $335) AND ("collection"."location" NOT LIKE $336) AND ("collection"."location" NOT LIKE $337) AND ("collection"."location" NOT LIKE $338) AND ("collection"."location" NOT LIKE $339) AND ("collection"."location" NOT LIKE $340) AND ("collection"."location" NOT LIKE $341) AND ("collection"."location" NOT LIKE $342) AND ("collection"."location" NOT LIKE $343) AND ("collection"."location" NOT LIKE $344) AND ("collection"."location" NOT LIKE $345) AND ("collection"."location" NOT LIKE $346) AND ("collection"."location" NOT LIKE $347) AND ("collection"."location" NOT LIKE $348) AND ("collection"."location" NOT LIKE $349) AND ("collection"."location" NOT LIKE $350) AND ("collection"."location" NOT LIKE $351) AND ("collection"."location" NOT LIKE $352) AND ("collection"."location" NOT LIKE $353) AND ("collection"."location" NOT LIKE $354) AND ("collection"."location" NOT LIKE $355) AND ("collection"."location" NOT LIKE $356) AND ("collection"."location" NOT LIKE $357) AND ("collection"."location" NOT LIKE $358) AND ("collection"."location" NOT LIKE $359) AND ("collection"."location" NOT LIKE $360) AND ("collection"."location" NOT LIKE $361) AND ("collection"."location" NOT LIKE $362) AND ("collection"."location" NOT LIKE $363) AND ("collection"."location" NOT LIKE $364) AND ("collection"."location" NOT LIKE $365) AND ("collection"."location" NOT LIKE $366) AND ("collection"."location" NOT LIKE $367) AND ("collection"."location" NOT LIKE $368) AND ("collection"."location" NOT LIKE $369) AND ("collection"."location" NOT LIKE $370) AND ("collection"."location" NOT LIKE $371) AND ("collection"."location" NOT LIKE $372) AND ("collection"."location" NOT LIKE $373) AND ("collection"."location" NOT LIKE $374) AND ("collection"."location" NOT LIKE $375) AND ("collection"."location" NOT LIKE $376) AND ("collection"."location" NOT LIKE $377) AND ("collection"."location" NOT LIKE $378) AND ("collection"."location" NOT LIKE $379) AND ("collection"."location" NOT LIKE $380) AND ("collection"."location" NOT LIKE $381) AND ("collection"."location" NOT LIKE $382) AND ("collection"."location" NOT LIKE $383) AND ("collection"."location" NOT LIKE $384) AND ("collection"."location" NOT LIKE $385) AND ("collection"."location" NOT LIKE $386) AND ("collection"."location" NOT LIKE $387) AND ("collection"."location" NOT LIKE $388) AND ("collection"."location" NOT LIKE $389) AND ("collection"."location" NOT LIKE $390) AND ("collection"."location" NOT LIKE $391) AND ("collection"."location" NOT LIKE $392) AND ("collection"."location" NOT LIKE $393) AND ("collection"."location" NOT LIKE $394) AND ("collection"."location" NOT LIKE $395) AND ("collection"."location" NOT LIKE $396) AND ("collection"."location" NOT LIKE $397) AND ("collection"."location" NOT LIKE $398) AND ("collection"."location" NOT LIKE $399) AND ("collection"."location" NOT LIKE $400) AND ("collection"."location" NOT LIKE $401) AND ("collection"."location" NOT LIKE $402) AND ("collection"."location" NOT LIKE $403) AND ("collection"."location" NOT LIKE $404) AND ("collection"."location" NOT LIKE $405) AND ("collection"."location" NOT LIKE $406) AND ("collection"."location" NOT LIKE $407) AND ("collection"."location" NOT LIKE $408) AND ("collection"."location" NOT LIKE $409) AND ("collection"."location" NOT LIKE $410) AND ("collection"."location" NOT LIKE $411) AND ("collection"."location" NOT LIKE $412) AND ("collection"."location" NOT LIKE $413) AND ("collection"."location" NOT LIKE $414) AND ("collection"."location" NOT LIKE $415) AND ("collection"."location" NOT LIKE $416) AND ("collection"."location" NOT LIKE $417) AND ("collection"."location" NOT LIKE $418) AND ("collection"."location" NOT LIKE $419) AND ("collection"."location" NOT LIKE $420) AND ("collection"."location" NOT LIKE $421) AND ("collection"."location" NOT LIKE $422) AND ("collection"."location" NOT LIKE $423) AND ("collection"."location" NOT LIKE $424) AND ("collection"."location" NOT LIKE $425) AND ("collection"."location" NOT LIKE $426) AND ("collection"."location" NOT LIKE $427) AND ("collection"."location" NOT LIKE $428) AND ("collection"."location" NOT LIKE $429) AND ("collection"."location" NOT LIKE $430) AND ("collection"."location" NOT LIKE $431) AND ("collection"."location" NOT LIKE $432) AND ("collection"."location" NOT LIKE $433) AND ("collection"."location" NOT LIKE $434) AND ("collection"."location" NOT LIKE $435) AND ("collection"."location" NOT LIKE $436) AND ("collection"."location" NOT LIKE $437) AND ("collection"."location" NOT LIKE $438) AND ("collection"."location" NOT LIKE $439) AND ("collection"."location" NOT LIKE $440) AND ("collection"."location" NOT LIKE $441) AND ("collection"."location" NOT LIKE $442) AND ("collection"."location" NOT LIKE $443) AND ("collection"."location" NOT LIKE $444) AND ("collection"."location" NOT LIKE $445) AND ("collection"."location" NOT LIKE $446) AND ("collection"."location" NOT LIKE $447) AND ("collection"."location" NOT LIKE $448) AND ("collection"."location" NOT LIKE $449) AND ("collection"."location" NOT LIKE $450) AND ("collection"."location" NOT LIKE $451) AND ("collection"."location" NOT LIKE $452) AND ("collection"."location" NOT LIKE $453) AND ("collection"."location" NOT LIKE $454) AND ("collection"."location" NOT LIKE $455) AND ("collection"."location" NOT LIKE $456) AND ("collection"."location" NOT LIKE $457) AND ("collection"."location" NOT LIKE $458) AND ("collection"."location" NOT LIKE $459) AND ("collection"."location" NOT LIKE $460) AND ("collection"."location" NOT LIKE $461) AND ("collection"."location" NOT LIKE $462) AND ("collection"."location" NOT LIKE $463) AND ("collection"."location" NOT LIKE $464) AND ("collection"."location" NOT LIKE $465) AND ("collection"."location" NOT LIKE $466) AND ("collection"."location" NOT LIKE $467) AND ("collection"."location" NOT LIKE $468) AND ("collection"."location" NOT LIKE $469) AND ("collection"."location" NOT LIKE $470) AND ("collection"."location" NOT LIKE $471) AND ("collection"."location" NOT LIKE $472) AND ("collection"."location" NOT LIKE $473) AND ("collection"."location" NOT LIKE $474) AND ("collection"."location" NOT LIKE $475) AND ("collection"."location" NOT LIKE $476) AND ("collection"."location" NOT LIKE $477) AND ("collection"."location" NOT LIKE $478) AND ("collection"."location" NOT LIKE $479) AND ("collection"."location" NOT LIKE $480) AND ("collection"."location" NOT LIKE $481) AND ("collection"."location" NOT LIKE $482) AND ("collection"."location" NOT LIKE $483) AND ("collection"."location" NOT LIKE $484) AND ("collection"."location" NOT LIKE $485) AND ("collection"."location" NOT LIKE $486) AND ("collection"."location" NOT LIKE $487) AND ("collection"."location" NOT LIKE $488) AND ("collection"."location" NOT LIKE $489) AND ("collection"."location" NOT LIKE $490) AND ("collection"."location" NOT LIKE $491) AND ("collection"."location" NOT LIKE $492) AND ("collection"."location" NOT LIKE $493) AND ("collection"."location" NOT LIKE $494) AND ("collection"."location" NOT LIKE $495) AND ("collection"."location" NOT LIKE $496) AND ("collection"."location" NOT LIKE $497) AND ("collection"."location" NOT LIKE $498) AND ("collection"."location" NOT LIKE $499) AND ("collection"."location" NOT LIKE $500) AND ("collection"."location" NOT LIKE $501) AND ("collection"."location" NOT LIKE $502) AND ("collection"."location" NOT LIKE $503) AND ("collection"."location" NOT LIKE $504) AND ("collection"."location" NOT LIKE $505) AND ("collection"."location" NOT LIKE $506) AND ("collection"."location" NOT LIKE $507) AND ("collection"."location" NOT LIKE $508) AND ("collection"."location" NOT LIKE $509) AND ("collection"."location" NOT LIKE $510) AND ("collection"."location" NOT LIKE $511) AND ("collection"."location" NOT LIKE $512) AND ("collection"."location" NOT LIKE $513) AND ("collection"."location" NOT LIKE $514) AND ("collection"."location" NOT LIKE $515) AND ("collection"."location" NOT LIKE $516) AND ("collection"."location" NOT LIKE $517) AND ("collection"."location" NOT LIKE $518) AND ("collection"."location" NOT LIKE $519) AND ("collection"."location" NOT LIKE $520) AND ("collection"."location" NOT LIKE $521) AND ("collection"."location" NOT LIKE $522) AND ("collection"."location" NOT LIKE $523) AND ("collection"."location" NOT LIKE $524) AND ("collection"."location" NOT LIKE $525) AND ("collection"."location" NOT LIKE $526) AND ("collection"."location" NOT LIKE $527) AND ("collection"."location" NOT LIKE $528) AND ("collection"."location" NOT LIKE $529) AND ("collection"."location" NOT LIKE $530) AND ("collection"."location" NOT LIKE $531) AND ("collection"."location" NOT LIKE $532) AND ("collection"."location" NOT LIKE $533) AND ("collection"."location" NOT LIKE $534) AND ("collection"."location" NOT LIKE $535) AND ("collection"."location" NOT LIKE $536) AND ("collection"."location" NOT LIKE $537) AND ("collection"."location" NOT LIKE $538) AND ("collection"."location" NOT LIKE $539) AND ("collection"."location" NOT LIKE $540) AND ("collection"."location" NOT LIKE $541) AND ("collection"."location" NOT LIKE $542) AND ("collection"."location" NOT LIKE $543) AND ("collection"."location" NOT LIKE $544) AND ("collection"."location" NOT LIKE $545) AND ("collection"."location" NOT LIKE $546) AND ("collection"."location" NOT LIKE $547) AND ("collection"."location" NOT LIKE $548) AND ("collection"."location" NOT LIKE $549) AND ("collection"."location" NOT LIKE $550) AND ("collection"."location" NOT LIKE $551) AND ("collection"."location" NOT LIKE $552) AND ("collection"."location" NOT LIKE $553) AND ("collection"."location" NOT LIKE $554) AND ("collection"."location" NOT LIKE $555) AND ("collection"."location" NOT LIKE $556) AND ("collection"."location" NOT LIKE $557) AND ("collection"."location" NOT LIKE $558) AND ("collection"."location" NOT LIKE $559) AND ("collection"."location" NOT LIKE $560) AND ("collection"."location" NOT LIKE $561) AND ("collection"."location" NOT LIKE $562) AND ("collection"."location" NOT LIKE $563) AND ("collection"."location" NOT LIKE $564) AND ("collection"."location" NOT LIKE $565) AND ("collection"."location" NOT LIKE $566) AND ("collection"."location" NOT LIKE $567) AND ("collection"."location" NOT LIKE $568) AND ("collection"."location" NOT LIKE $569) AND ("collection"."location" NOT LIKE $570) AND ("collection"."location" NOT LIKE $571) AND ("collection"."location" NOT LIKE $572) AND ("collection"."location" NOT LIKE $573) AND ("collection"."location" NOT LIKE $574) AND ("collection"."location" NOT LIKE $575) AND ("collection"."location" NOT LIKE $576) AND ("collection"."location" NOT LIKE $577) AND ("collection"."location" NOT LIKE $578) AND ("collection"."location" NOT LIKE $579) AND ("collection"."location" NOT LIKE $580) AND ("collection"."location" NOT LIKE $581) AND ("collection"."location" NOT LIKE $582) AND ("collection"."location" NOT LIKE $583) AND ("collection"."location" NOT LIKE $584) AND ("collection"."location" NOT LIKE $585) AND ("collection"."location" NOT LIKE $586) AND ("collection"."location" NOT LIKE $587) AND ("collection"."location" NOT LIKE $588) AND ("collection"."location" NOT LIKE $589) AND ("collection"."location" NOT LIKE $590) AND ("collection"."location" NOT LIKE $591) AND ("collection"."location" NOT LIKE $592) AND ("collection"."location" NOT LIKE $593) AND ("collection"."location" NOT LIKE $594) AND ("collection"."location" NOT LIKE $595) AND ("collection"."location" NOT LIKE $596) AND ("collection"."location" NOT LIKE $597) AND ("collection"."location" NOT LIKE $598) AND ("collection"."location" NOT LIKE $599) AND ("collection"."location" NOT LIKE $600) AND ("collection"."location" NOT LIKE $601) AND ("collection"."location" NOT LIKE $602) AND ("collection"."location" NOT LIKE $603) AND ("collection"."location" NOT LIKE $604) AND ("collection"."location" NOT LIKE $605) AND ("collection"."location" NOT LIKE $606) AND ("collection"."location" NOT LIKE $607) AND ("collection"."location" NOT LIKE $608) AND ("collection"."location" NOT LIKE $609) AND ("collection"."location" NOT LIKE $610) AND ("collection"."location" NOT LIKE $611) AND ("collection"."location" NOT LIKE $612) AND ("collection"."location" NOT LIKE $613) AND ("collection"."location" NOT LIKE $614) AND ("collection"."location" NOT LIKE $615) AND ("collection"."location" NOT LIKE $616) AND ("collection"."location" NOT LIKE $617) AND ("collection"."location" NOT LIKE $618) AND ("collection"."location" NOT LIKE $619) AND ("collection"."location" NOT LIKE $620) AND ("collection"."location" NOT LIKE $621) AND ("collection"."location" NOT LIKE $622) AND ("collection"."location" NOT LIKE $623) AND ("collection"."location" NOT LIKE $624) AND ("collection"."location" NOT LIKE $625) AND ("collection"."location" NOT LIKE $626) AND ("collection"."location" NOT LIKE $627) AND ("collection"."location" NOT LIKE $628) AND ("collection"."location" NOT LIKE $629) AND ("collection"."location" NOT LIKE $630) AND ("collection"."location" NOT LIKE $631) AND ("collection"."location" NOT LIKE $632) AND ("collection"."location" NOT LIKE $633) AND ("collection"."location" NOT LIKE $634) AND ("collection"."location" NOT LIKE $635) AND ("collection"."location" NOT LIKE $636) AND ("collection"."location" NOT LIKE $637) AND ("collection"."location" NOT LIKE $638) AND ("collection"."location" NOT LIKE $639) AND ("collection"."location" NOT LIKE $640) AND ("collection"."location" NOT LIKE $641) AND ("collection"."location" NOT LIKE $642) AND ("collection"."location" NOT LIKE $643) AND ("collection"."location" NOT LIKE $644) AND ("collection"."location" NOT LIKE $645) AND ("collection"."location" NOT LIKE $646) AND ("collection"."location" NOT LIKE $647) AND ("collection"."location" NOT LIKE $648) AND ("collection"."location" NOT LIKE $649) AND ("collection"."location" NOT LIKE $650) AND ("collection"."location" NOT LIKE $651) AND ("collection"."location" NOT LIKE $652) AND ("collection"."location" NOT LIKE $653) AND ("collection"."location" NOT LIKE $654) AND ("collection"."location" NOT LIKE $655) AND ("collection"."location" NOT LIKE $656) AND ("collection"."location" NOT LIKE $657) AND ("collection"."location" NOT LIKE $658) AND ("collection"."location" NOT LIKE $659) AND ("collection"."location" NOT LIKE $660) AND ("collection"."location" NOT LIKE $661) AND ("collection"."location" NOT LIKE $662) AND ("collection"."location" NOT LIKE $663) AND ("collection"."location" NOT LIKE $664) AND ("collection"."location" NOT LIKE $665) AND ("collection"."location" NOT LIKE $666) AND ("collection"."location" NOT LIKE $667) AND ("collection"."location" NOT LIKE $668) AND ("collection"."location" NOT LIKE $669) AND ("collection"."location" NOT LIKE $670) AND ("collection"."location" NOT LIKE $671) AND ("collection"."location" NOT LIKE $672) AND ("collection"."location" NOT LIKE $673) AND ("collection"."location" NOT LIKE $674) AND ("collection"."location" NOT LIKE $675) AND ("collection"."location" NOT LIKE $676) AND ("collection"."location" NOT LIKE $677) AND ("collection"."location" NOT LIKE $678) AND ("collection"."location" NOT LIKE $679) AND ("collection"."location" NOT LIKE $680) AND ("collection"."location" NOT LIKE $681) AND ("collection"."location" NOT LIKE $682) AND ("collection"."location" NOT LIKE $683) AND ("collection"."location" NOT LIKE $684) AND ("collection"."location" NOT LIKE $685) AND ("collection"."location" NOT LIKE $686) AND ("collection"."location" NOT LIKE $687) AND ("collection"."location" NOT LIKE $688) AND ("collection"."location" NOT LIKE $689) AND ("collection"."location" NOT LIKE $690) AND ("collection"."location" NOT LIKE $691) AND ("collection"."location" NOT LIKE $692) AND ("collection"."location" NOT LIKE $693) AND ("collection"."location" NOT LIKE $694) AND ("collection"."location" NOT LIKE $695) AND ("collection"."location" NOT LIKE $696) AND ("collection"."location" NOT LIKE $697) AND ("collection"."location" NOT LIKE $698) AND ("collection"."location" NOT LIKE $699) AND ("collection"."location" NOT LIKE $700) AND ("collection"."location" NOT LIKE $701) AND ("collection"."location" NOT LIKE $702) AND ("collection"."location" NOT LIKE $703) AND ("collection"."location" NOT LIKE $704) AND ("collection"."location" NOT LIKE $705) AND ("collection"."location" NOT LIKE $706) AND ("collection"."location" NOT LIKE $707) AND ("collection"."location" NOT LIKE $708) AND ("collection"."location" NOT LIKE $709) AND ("collection"."location" NOT LIKE $710) AND ("collection"."location" NOT LIKE $711) AND ("collection"."location" NOT LIKE $712) AND ("collection"."location" NOT LIKE $713) AND ("collection"."location" NOT LIKE $714) AND ("collection"."location" NOT LIKE $715) AND ("collection"."location" NOT LIKE $716) AND ("collection"."location" NOT LIKE $717) AND ("collection"."location" NOT LIKE $718) AND ("collection"."location" NOT LIKE $719) AND ("collection"."location" NOT LIKE $720) AND ("collection"."location" NOT LIKE $721) AND ("collection"."location" NOT LIKE $722) AND ("collection"."location" NOT LIKE $723) AND ("collection"."location" NOT LIKE $724) AND ("collection"."location" NOT LIKE $725) AND ("collection"."location" NOT LIKE $726) AND ("collection"."location" NOT LIKE $727) AND ("collection"."location" NOT LIKE $728) AND ("collection"."location" NOT LIKE $729) AND ("collection"."location" NOT LIKE $730) AND ("collection"."location" NOT LIKE $731) AND ("collection"."location" NOT LIKE $732) AND ("collection"."location" NOT LIKE $733))))) AND (("search_index"."model" IS NULL) OR ("search_index"."model" <> 'table') OR (("search_index"."model" = 'table') AND ((CAST("search_index"."model_id" AS INTEGER) IN (SELECT "id" FROM "permitted_tables")) OR ((CAST("search_index"."model_id" AS INTEGER) IN (SELECT "mt"."id" FROM "metabase_table" AS "mt" WHERE EXISTS (SELECT $734 FROM "data_permissions" AS "dp" WHERE ("dp"."perm_type" = 'perms/view-data') AND ((("mt"."db_id" = "dp"."db_id") AND ("dp"."table_id" IS NULL)) OR ("mt"."id" = "dp"."table_id")) AND ("dp"."group_id" IN (SELECT "group_id" FROM "permissions_group_membership" WHERE "user_id" = 526)) GROUP BY "mt"."id" HAVING (CASE WHEN MIN(CASE WHEN "dp"."perm_value" = 'unrestricted' THEN 0 WHEN "dp"."perm_value" = 'blocked' THEN 1 WHEN "dp"."perm_value" = 'legacy-no-self-service' THEN 2 END) = 0 THEN 0 WHEN MIN(CASE WHEN "dp"."perm_value" = 'unrestricted' THEN 0 WHEN "dp"."perm_value" = 'blocked' THEN 1 WHEN "dp"."perm_value" = 'legacy-no-self-service' THEN 2 END) = 1 THEN 2 WHEN MIN(CASE WHEN "dp"."perm_value" = 'unrestricted' THEN 0 WHEN "dp"."perm_value" = 'blocked' THEN 1 WHEN "dp"."perm_value" = 'legacy-no-self-service' THEN 2 END) = 2 THEN 1 END <= 0)) AND ("mt"."active" = TRUE))) AND (CAST("search_index"."model_id" AS INTEGER) IN (SELECT "id" FROM "metabase_table" WHERE ("is_published" = TRUE) AND (("collection_id" IS NULL) OR ("collection_id" IN (SELECT "id" FROM (SELECT "c"."id", "c"."location", "c"."archived", "c"."archive_operation_id", "c"."archived_directly", "c"."type", "c"."namespace" FROM "collection" AS "c" WHERE EXISTS (SELECT $735 FROM "permissions" AS "p" INNER JOIN "permissions_group_membership" AS "pgm" ON "p"."group_id" = "pgm"."group_id" WHERE ("pgm"."user_id" = 526) AND ("c"."id" = "p"."collection_id") AND ("p"."perm_type" = 'perms/collection-access') AND (("p"."perm_value" = 'read-and-write') OR ("p"."perm_value" = 'read'))) UNION ALL SELECT "c"."id", "c"."location", "c"."archived", "c"."archive_operation_id", "c"."archived_directly", "c"."type", "c"."namespace" FROM "collection" AS "c" WHERE "type" = 'trash' UNION ALL SELECT "c"."id", "c"."location", "c"."archived", "c"."archive_operation_id", "c"."archived_directly", "c"."type", "c"."namespace" FROM "collection" AS "c" WHERE "id" IN (1153)) AS "c" WHERE (1304 <> "c"."id") AND ("c"."archived" = FALSE) AND NOT EXISTS (SELECT $736 FROM "collection" AS "sub_c" WHERE ("c"."id" = "sub_c"."id") AND ("sub_c"."namespace" = 'shared