On Wed, Aug 27, 2014 at 10:59 AM, Layale Bassil <lb26@aub.edu.lb> wrote:
Hello,
I am writing an SQL query to return the records in my Koha catalogue
which are in Arabic (language code = ara). But I am not being able to know the database column and table where the language is stored? When importing into Koha, there is the "041" field that holds language info and field "008" location 35-37 that also holds the language code.
Can you please tell me how can I query records written in a specific
language? I think for MARC21 the cataloguing language is on 040$b. You can query for a specific language using this MySQL syntax (this one would be for spanish): SELECT biblionumber FROM biblioitems WHERE ExtractValue(marcxml,'//datafield[@tag="040"]/subfield[@code="b"]') = 'spa' ; You can LEFT JOIN this to the biblio table so you can show title, author, etc. Take a look at http://wiki.koha-community.org/wiki/SQL_Reports_Library for further references. -- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F