daily pastebin goal
43%
SHARE
TWEET

Untitled

a guest Jul 17th, 2017 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.         "t1"."id" "spn_realty_id", "t1"."author_id" "spn_realty_author_id", "t1"."last_operation_id" "spn_realty_last_operation_id",
  3.         "t1"."last_operation_type" "spn_realty_last_operation_type", "t1"."last_operation_inc" "spn_realty_last_operation_inc",
  4.         "t1"."chain_id" "spn_realty_chain_id", "t1"."parent_id" "spn_realty_parent_id", "t1"."caption" "spn_realty_caption",
  5.         "t1"."time_created" "spn_realty_time_created", "t1"."type" "spn_realty_type"
  6.     FROM "spn_realty" "t1"
  7.     JOIN "spn_realty_subagent_queue" "t2" ON "t1"."id" = "t2"."pricelist_id" AND "t2"."is_active" = TRUE
  8.     WHERE "t1"."last_operation_type" = 16
  9.     GROUP BY "t1"."id"
RAW Paste Data
Top