SELECT
   "facilities"."id",
   "facilities"."id" AS t0_r0,
   "facilities"."name" AS t0_r1,
   "facilities"."address_line1" AS t0_r2,
   "facilities"."address_line2" AS t0_r3,
   "facilities"."city" AS t0_r4,
   "facilities"."state_abbr" AS t0_r5,
   "facilities"."zip" AS t0_r6,
   "facilities"."created_at" AS t0_r7,
   "facilities"."updated_at" AS t0_r8,
   "facilities"."description" AS t0_r9,
   "facilities"."url" AS t0_r10,
   "facilities"."phone" AS t0_r11,
   "facilities"."fax" AS t0_r12,
   "facilities"."email" AS t0_r13,
   "facilities"."rating" AS t0_r14,
   "facilities"."medicare_overall" AS t0_r15,
   "facilities"."medicare_health" AS t0_r16,
   "facilities"."medicare_staffing" AS t0_r17,
   "facilities"."medicare_quality" AS t0_r18,
   "facilities"."image_file_name" AS t0_r19,
   "facilities"."image_content_type" AS t0_r20,
   "facilities"."image_file_size" AS t0_r21,
   "facilities"."image_updated_at" AS t0_r22,
   "facilities"."latitude" AS t0_r23,
   "facilities"."longitude" AS t0_r24,
   "facilities"."permalink" AS t0_r25,
   "facilities"."tsv_city" AS t0_r26,
   "facilities"."tsv_name" AS t0_r27,
   "facilities"."doctor_visits_per_month" AS t0_r28,
   "facilities"."golden_seal" AS t0_r29,
   "facilities"."image_processing" AS t0_r30,
   "facilities"."state" AS t0_r31,
   "categories"."id" AS t1_r0,
   "categories"."name" AS t1_r1,
   "categories"."key" AS t1_r2,
   "categories"."type_id" AS t1_r3,
   "categories"."created_at" AS t1_r4,
   "categories"."updated_at" AS t1_r5
FROM
   "facilities"
   LEFT OUTER JOIN
      "categories_facilities"
      ON "categories_facilities"."facility_id" = "facilities"."id"
   LEFT OUTER JOIN
      "categories"
      ON "categories"."id" = "categories_facilities"."category_id"
WHERE
   (
      "categories"."key" ILIKE 'assisted_living'
      AND "categories"."key" ILIKE 'independent_living'
   )