select datemodelpublic.object_description, model.object_id, model.object_name, becausewas.object_name from objects datemodelpublic, objects model, objects becausewas, eav_objects note where datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id and model.object_class=19 and note.attribute_id=426 and note.object_id=datemodelpublic.object_id and note.value_=becausewas.object_id and becausewas.object_class=128 order by datemodelpublic.object_description
|