select distinct datemodelpublic.object_description, models.object_id, models.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
|