select history.value_ as history from
objects collaborators, eav_memo history, eav_objects status, eav_objects local_contact where
collaborators.object_class=87 and
collaborators.object_id=history.object_id and
history.attribute_id=267 and
collaborators.object_id=status.object_id and
status.value_=28707 and
status.attribute_id=273 and
local_contact.attribute_id=271 and
local_contact.object_id=collaborators.object_id and
local_contact.value_=28692