SELECT
        "t3"."id" "spn_realty_id", "t3"."author_id" "spn_realty_author_id", "t3"."last_operation_id" "spn_realty_last_operation_id",
        "t3"."last_operation_type" "spn_realty_last_operation_type", "t3"."last_operation_inc" "spn_realty_last_operation_inc",
        "t3"."chain_id" "spn_realty_chain_id", "t3"."parent_id" "spn_realty_parent_id", "t3"."caption" "spn_realty_caption",
        "t3"."time_created" "spn_realty_time_created", "t3"."type" "spn_realty_type"
    FROM "spn_operation_list" "t1"
    JOIN "spn_operation_data_jsonp" "t2" ON "t2"."id" = "t1"."id"
    JOIN "spn_realty" "t3" ON "t3"."id" = "t1"."realty_id"
    WHERE
        "t1"."operation_type" = 15 AND
        "t1"."is_last_operation" = TRUE AND
        to_timestamp(("t2"."data"->>'data_okonchaniya')::float) <= now()