select row_number() over (order by datemodelpublic.object_description) as row, datemodelpublic.object_description, model.object_id, model.object_name, becausewas.object_name as because from objects datemodelpublic, objects model, objects becausewas, eav_objects note where datemodelpublic.object_class=127 and datemodelpublic.object_name=Convert(varchar, 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 and becausewas.object_id=92554 order by datemodelpublic.object_description
|