JUMA AL MAJID CENTER - LIBRARY SEARCH

Search Results

SELECT books.id, books.title, books.en_name,books.material_type, books.latin_name, manuscript_authors.authorname_en as authorname_en,manuscript_authors.authorname_ar, manuscript_authors.authorname_filter_ar, books.statement_of_response, books.en_name FROM books INNER JOIN manuscript_authors ON manuscript_authors.book_id = books.id WHERE ( manuscript_authors.authorname_en = 'الصفراوي:عبد الرحمن بن عبد المجيد بن إسماعيل,أبو القاسم,636هـ' OR manuscript_authors.authorname_ar = 'الصفراوي:عبد الرحمن بن عبد المجيد بن إسماعيل,أبو القاسم,636هـ' OR manuscript_authors.authorname_filter_ar = 'الصفراوي:عبد الرحمن بن عبد المجيد بن إسماعيل,أبو القاسم,636هـ' ) AND books.en_name = 'Manuscript' GROUP BY books.id