http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599 ------- Additional Comments From paul.poulain@free.fr 2003-09-23 21:32 ------- A few hours of digging later... MY opinion is that the imported datas were a little bit corrupted BEFORE importing process. Let me explain : 1 ---------------- try this request : FROM marc_subfield_table, marc_biblio LEFT JOIN items ON items.barcode = marc_subfield_table.subfieldvalue WHERE tag = "952" AND subfieldcode = "p" AND items.biblionumber <> marc_biblio.biblionumber AND marc_biblio.bibid = marc_subfield_table.bibid ("translation" of this request : search barcode in marc & non marc table, search marc & non-marc biblio number, show those who are differents => those records have a problem) It gives me 87 results. It means that 87 items are connected to marc data X and to non-marc data Y to be continued soon >>> ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.