select datemodelpublic.object_description, models.object_id, models.object_name, application.object_name from objects datemodelpublic, objects models, eav_objects model_application, objects application where
datemodelpublic.object_class=127 and
datemodelpublic.object_name=models.object_id and
models.object_id = model_application.object_id and
model_application.attribute_id = 114 and
model_application.value_ <> 1882 and
model_application.value_ <> 7841 and
application.object_id=model_application.value_ and
datemodelpublic.object_description < '20070501' and
datemodelpublic.object_description > '20060431'
order by datemodelpublic.object_description
|