Select distinct paper1.object_id, paper2.object_id, paper1.object_name FROM objects paper1, objects paper2, eav_string y1, eav_string y2 Where paper1.object_class = 42 and paper2.object_class = 42 and paper1.object_name=paper2.object_name and paper1.object_id > paper2.object_id and y1.object_id=paper1.object_id and y2.object_id=paper2.object_id and y1.value=y2.value order by paper1.object_name, paper1.object_id, paper2.object_id
|