SQL from users/index

queries_2.rb

# All users (count)
# ======================
SELECT COUNT(DISTINCT "users"."id") FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE (logins.account_id = 5359 and (logins.id = 59251 or logins.role >= 6) and users.status != 'Retired' and users.deleted_at is null)

# Filtered users (count)
# ======================
SELECT COUNT(DISTINCT "users"."id") FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE (logins.account_id = 5359 and (logins.id = 59251 or logins.role >= 6) and users.status != 'Retired' and users.deleted_at is null) AND ("ole_core"."logins"."id" IN (SELECT "ole_core"."taggings"."taggable_id" FROM "ole_core"."taggings" INNER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE "ole_core"."tags"."name" = '348'))

# current subscription
# ======================
SELECT "ole_core"."subscriptions".* FROM "ole_core"."subscriptions" WHERE "ole_core"."subscriptions"."deleted_at" IS NULL AND "ole_core"."subscriptions"."account_id" = 5359 LIMIT 1

# Filtered users
# ======================
SELECT DISTINCT "users".id, logins.first_name, logins.last_name, logins.id AS alias_0 FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE (logins.account_id = 5359 and (logins.id = 59251 or logins.role >= 6) and users.status != 'Retired' and users.deleted_at is null) AND ("ole_core"."logins"."id" IN (SELECT "ole_core"."taggings"."taggable_id" FROM "ole_core"."taggings" INNER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE "ole_core"."tags"."name" = '348')) ORDER BY logins.first_name, logins.last_name, logins.id asc LIMIT 20 OFFSET 0

# Filtered users (with udfs data)
# ======================
SELECT "users"."id" AS t0_r0, "users"."login_id" AS t0_r1, "users"."created_at" AS t0_r2, "users"."updated_at" AS t0_r3, "users"."accepted_disclaimer" AS t0_r4, "users"."status" AS t0_r5, "users"."client_ref" AS t0_r6, "users"."avatar" AS t0_r7, "users"."subscription_group_id" AS t0_r8, "users"."show_cb_welcome" AS t0_r9, "users"."view_preference" AS t0_r10, "users"."can_assign_subscription" AS t0_r11, "users"."deleted_at" AS t0_r12, "ole_core"."logins"."id" AS t1_r0, "ole_core"."logins"."email" AS t1_r1, "ole_core"."logins"."encrypted_password" AS t1_r2, "ole_core"."logins"."reset_password_token" AS t1_r3, "ole_core"."logins"."reset_password_sent_at" AS t1_r4, "ole_core"."logins"."remember_created_at" AS t1_r5, "ole_core"."logins"."sign_in_count" AS t1_r6, "ole_core"."logins"."current_sign_in_at" AS t1_r7, "ole_core"."logins"."last_sign_in_at" AS t1_r8, "ole_core"."logins"."current_sign_in_ip" AS t1_r9, "ole_core"."logins"."last_sign_in_ip" AS t1_r10, "ole_core"."logins"."created_at" AS t1_r11, "ole_core"."logins"."updated_at" AS t1_r12, "ole_core"."logins"."role" AS t1_r13, "ole_core"."logins"."first_name" AS t1_r14, "ole_core"."logins"."last_name" AS t1_r15, "ole_core"."logins"."username" AS t1_r16, "ole_core"."logins"."primary_admin" AS t1_r17, "ole_core"."logins"."account_id" AS t1_r18, "ole_core"."logins"."full_name" AS t1_r19, "ole_core"."logins"."commission" AS t1_r20, "ole_core"."logins"."authentication_token" AS t1_r21, "ole_core"."logins"."creator_id" AS t1_r22, "ole_core"."tags"."id" AS t2_r0, "ole_core"."tags"."name" AS t2_r1 FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE "users"."id" IN (105236, 114738, 105238, 105241, 105237) AND (logins.account_id = 5359 and (logins.id = 59251 or logins.role >= 6) and users.status != 'Retired' and users.deleted_at is null) AND ("ole_core"."logins"."id" IN (SELECT "ole_core"."taggings"."taggable_id" FROM "ole_core"."taggings" INNER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE "ole_core"."tags"."name" = '348')) ORDER BY logins.first_name, logins.last_name, logins.id asc