SHARE
TWEET

Untitled

a guest Jul 17th, 2017 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.         "t3"."id" "spn_realty_id", "t3"."author_id" "spn_realty_author_id", "t3"."last_operation_id" "spn_realty_last_operation_id",
  3.         "t3"."last_operation_type" "spn_realty_last_operation_type", "t3"."last_operation_inc" "spn_realty_last_operation_inc",
  4.         "t3"."chain_id" "spn_realty_chain_id", "t3"."parent_id" "spn_realty_parent_id", "t3"."caption" "spn_realty_caption",
  5.         "t3"."time_created" "spn_realty_time_created", "t3"."type" "spn_realty_type"
  6.     FROM "spn_operation_list" "t1"
  7.     JOIN "spn_operation_data_jsonp" "t2" ON "t2"."id" = "t1"."id"
  8.     JOIN "spn_realty" "t3" ON "t3"."id" = "t1"."realty_id"
  9.     WHERE
  10.         "t1"."operation_type" = 15 AND
  11.         "t1"."is_last_operation" = TRUE AND
  12.         to_timestamp(("t2"."data"->>'data_okonchaniya')::float) <= now()
RAW Paste Data
Top