SELECT models.object_name, models.created, USERS.LOGIN,
simenv_obj.object_name
FROM OBJECTS models , users , objects simenv_obj, eav_objects simenv_att
WHERE models.OBJECT_CLASS = 19
and simenv_obj.object_class = 36
and simenv_att.attribute_id= 114
and simenv_obj.object_id = simenv_att.value_
and simenv_att.object_id = models.object_id
and models.OWNER = USERS.user_id
and models.private = 0
ORDER BY created asc
|