select datemodelpublic.object_description as day, serialno.value_ as serialno , model.object_id, model.object_name, becausewas.object_name as because from objects datemodelpublic, objects model, objects becausewas, eav_objects note, eav_int serialno where datemodelpublic.object_class=127 and datemodelpublic.object_name=cast(model.object_id as varchar(100)) 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 and serialno.object_id= datemodelpublic.object_id and serialno.attribute_id=427 order by serialno.value_
|