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=CAST(models.object_id AS varchar(100)) and models.object_id = model_application.object_id and model_application.attribute_id = 114 and (model_application.value_ = 1882 or model_application.value_ = 7841) and application.object_id=model_application.value_ and datemodelpublic.object_description < '20170219' and datemodelpublic.object_description > '20160219' order by datemodelpublic.object_description
|