acl.sql

SELECT
  "access_control_lists".*

FROM "access_control_lists"

WHERE
  ("access_control_lists"."roles" && '{owner}') AND
  "access_control_lists"."resource_type" = 'Project' AND
  "access_control_lists"."resource_id" IN (53, 55)

projects.sql

SELECT
  "projects"."id" AS t0_r0,
  "projects"."name" AS t0_r1,
  "projects"."display_name" AS t0_r2,
  "projects"."user_count" AS t0_r3,
  "projects"."created_at" AS t0_r4,
  "projects"."updated_at" AS t0_r5,
  "projects"."classifications_count" AS t0_r6,
  "projects"."activated_state" AS t0_r7,
  "projects"."primary_language" AS t0_r8,
  "projects"."private" AS t0_r9,
  "projects"."lock_version" AS t0_r10,
  "projects"."configuration" AS t0_r11,
  "projects"."live" AS t0_r12,
  "projects"."urls" AS t0_r13,
  "projects"."migrated" AS t0_r14,
  "projects"."classifiers_count" AS t0_r15,
  "projects"."slug" AS t0_r16,
  "projects"."redirect" AS t0_r17,
  "projects"."launch_requested" AS t0_r18,
  "projects"."launch_approved" AS t0_r19,
  "projects"."beta_requested" AS t0_r20,
  "projects"."beta_approved" AS t0_r21,
  "projects"."launched_row_order" AS t0_r22,
  "projects"."beta_row_order" AS t0_r23,
  "projects"."experimental_tools" AS t0_r24,
  "projects"."launch_date" AS t0_r25,
  "projects"."completeness" AS t0_r26,
  "projects"."activity" AS t0_r27,
  "projects"."tsv" AS t0_r28,
  "project_contents"."id" AS t1_r0,
  "project_contents"."project_id" AS t1_r1,
  "project_contents"."language" AS t1_r2,
  "project_contents"."title" AS t1_r3,
  "project_contents"."description" AS t1_r4,
  "project_contents"."created_at" AS t1_r5,
  "project_contents"."updated_at" AS t1_r6,
  "project_contents"."introduction" AS t1_r7,
  "project_contents"."url_labels" AS t1_r8,
  "project_contents"."workflow_description" AS t1_r9

FROM "projects"

INNER JOIN "project_contents" ON
  "project_contents"."project_id" = "projects"."id"

INNER JOIN "access_control_lists" ON
  "access_control_lists"."resource_id" = "projects"."id" AND
  "access_control_lists"."resource_type" = 'Project'

  WHERE
    (
      ("projects"."id" IN (53, 55)) OR
      ("projects"."private" = 'f')
    ) AND
    "projects"."activated_state" = 0 AND
    (
      "project_contents"."language" = "projects"."primary_language" OR
      "project_contents"."language" ~ '^(en|zh|fr).*'
    ) AND
    "access_control_lists"."user_group_id" = 37 AND
    ("access_control_lists"."roles" && '{owner,collaborator}')

user_groups.sql

SELECT
  "user_groups".*

FROM "user_groups"

WHERE "user_groups"."id" IN (37, 39)