JUMA AL MAJID CENTER - LIBRARY SEARCH

Search Results

SELECT books.id, books.title, books.en_name,books.broad_name, books.latin_name,books.material_type, books.statement_of_response, book_with_author.authorname_ar, book_with_author.authorname_en, book_with_author.authorname_filter_ar, book_with_author.authorname_filter_en FROM books LEFT JOIN book_with_author ON book_with_author.book_id = books.id WHERE ( book_with_author.authorname_ar = 'رجب، عمر الفاروق السيد' OR book_with_author.authorname_filter_ar = 'رجب، عمر الفاروق السيد' OR book_with_author.authorname_en = 'رجب، عمر الفاروق السيد' OR book_with_author.authorname_ar ) GROUP BY books.id