SELECT
        "t1"."id" "spn_realty_id", "t1"."author_id" "spn_realty_author_id", "t1"."last_operation_id" "spn_realty_last_operation_id",
        "t1"."last_operation_type" "spn_realty_last_operation_type", "t1"."last_operation_inc" "spn_realty_last_operation_inc",
        "t1"."chain_id" "spn_realty_chain_id", "t1"."parent_id" "spn_realty_parent_id", "t1"."caption" "spn_realty_caption",
        "t1"."time_created" "spn_realty_time_created", "t1"."type" "spn_realty_type"
    FROM "spn_realty" "t1"
    JOIN "spn_realty_subagent_queue" "t2" ON "t1"."id" = "t2"."pricelist_id" AND "t2"."is_active" = TRUE
    WHERE "t1"."last_operation_type" = 16
    GROUP BY "t1"."id"