SELECT models.object_name, models.created, USERS.LOGIN, model_type_obj.object_name
FROM OBJECTS models , users , objects model_type_obj, eav_objects model_type_att WHERE
models.OBJECT_CLASS = 19 and
model_type_obj.object_class = 38 and
model_type_att.attribute_id= 112 and
model_type_obj.object_id = model_type_att.value_ and
model_type_att.object_id = models.object_id and
models.OWNER = USERS.user_id and
models.private = 0
ORDER BY created asc
|