select st.instance_state_uid::text as instance_state_uid st.version st.creator_id to_char(st.dt_state, 'YYYY-MM-DD"T"HH24:MI:SS.FF3TZHTZM') as dt_state st.is_test st.instance_operation_uid::text as instance_operation_uid st.instance_data::text as instance_data (st.instance_data->>'isDeleted')::boolean as is_deleted from instance_state st join instance e on (st.instance_uid=e.instance_uid) join specification_item i on (e.specification_item_id=i.specification_item_id) where st.instance_uid= AND i.specification_id= order by st.version desc limit 1